| Name | R_Sale_Plan_Area |
|---|---|
| Entity Type | Table |
| Description | A reference table to store a list of sale planning areas. Sale planning areas are commonly referenced when communicating information about land sales, especially for land sales offered by governments or regulatory agencies. For example, the "Western Gulf of Mexico land sale". |
| Submodel | Land_Sale |
| Entity Scope | Reference |
| Primary Key | Code |
| Natural Key | Code |
| Generalizations | Reference_Entity , Reference_Entity_Parent |
| Specializations |
| Name | Value Domain / Measurement | Description | Required / Default | Type |
|---|---|---|---|---|
| Active_Flag | boolean NA |
1 = use without restriction. 0 = avoid use - the value has been deprecated and may be removed in a later release. | Yes 1 |
NUMBER(1) |
| Code | CODE NA |
A standard abbreviation, mnemonic, or short code that represents the reference value. | Yes |
VARCHAR2(64) |
| Description | STRING2000 NA |
A textual definition of the reference value. | No |
VARCHAR2(2000) |
| Jurisdiction_BA_Id | Business_Associate |
The business associate who has jurisdiction over this planning area. | No |
NUMBER(38) |
| Name | CODE NA |
The spelled-out name of the reference value. | No |
VARCHAR2(64) |
| Source | CODE NA |
The person, company or application that defined or specified the data (content) for this instance and is considered to be responsible for it. For example, POSC, EPSG, API, ISO, etc.. | No |
VARCHAR2(64) |
| Update_Date | DATE NA |
Date of the most-recent modification to the entity. | No |
DATE |
| Update_User | STRING64 NA |
The name of the user responsible for the last modification to this entity. | No |
VARCHAR2(64) |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Land_Sale_Plan_Area_XREF | Sale_Plan_Area | The sale planning area in which lands are being offered via the land sale. | Restrict | Yes |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Jurisdiction_BA | Business_Associate | The business associate who has jurisdiction over this planning area. | Restrict | No |