| Name | NDC_Borehole |
|---|---|
| Entity Type | Extension of Borehole |
| Description | A table to hold NDC specific information |
| Submodel | NDC |
| Entity Scope | Project |
| Primary Key | Borehole_Id |
| Natural Key | |
| Generalizations | Tracked_Object |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Borehole_Id | Borehole |
|
The Borehole to which the additional information refers to | Yes |
NUMBER(38) |
| Insert_Date | DATE | NA |
Date the entity was created in the repository | No |
DATE |
| Insert_User | STRING64 | NA |
The name of the user responsible for the creation of this entity in the repository. | No |
VARCHAR2(64) |
| License_Id | Land_Agreement |
|
The License referred to by the borehole. Usage Notes: The association to Land_Agreement to identify the License is deprecated in Seabed release 2011.1. In a future release of Seabed this association will be removed. As part of the project upgrade process for Seabed 2011.1, any License data in NDC_Borehole will be copied into the new intersection table, Position_Xref. If you are storing Licenses or other Land Agreements, you must begin transitioning your process to the new intersection table, Position_Xref, as soon as possible to avoid problems when this association between NDC_Borehole and Land_Agreement is removed. | No |
NUMBER(38) |
| Original_Insert_Date | DATE | NA |
Original date the entity was created in the repository | No |
DATE |
| Original_Update_Date | DATE | NA |
Original date of the most-recent modification to the entity. | No |
DATE |
| Produced_By | STRING64 | NA |
The name of application role that created the entity, for data created programmatically. | No |
VARCHAR2(64) |
| Released_Date | DATE | NA |
The date that the data for the borehole was released. | No |
DATE |
| Released_Status | CODE | NA |
The release status of the borehole. Examples are Release, Not Released | No |
VARCHAR2(64) |
| SDAT_Label | int | No_Unit |
Label used by the security system for entitlements. SDAT is Secure Data Access Technology. | No |
NUMBER(10) |
| 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) |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Borehole | Borehole | The Borehole to which the additional information refers to | Cascade | Yes |
| License | Land_Agreement | The License referred to by the borehole. Usage Notes: The association to Land_Agreement to identify the License is deprecated in Seabed release 2011.1. In a future release of Seabed this association will be removed. As part of the project upgrade process for Seabed 2011.1, any License data in NDC_Borehole will be copied into the new intersection table, Position_Xref. If you are storing Licenses or other Land Agreements, you must begin transitioning your process to the new intersection table, Position_Xref, as soon as possible to avoid problems when this association between NDC_Borehole and Land_Agreement is removed. | Cascade | No |