| Name | R_Stratigraphic_Exception |
|---|---|
| Entity Type | Table |
| Description | A reference table that stores valid stratigraphic exception reasons. These are qualifiers on the nature of the pick. A stratigraphic exception explains the reason for the absence of feature boundaries for a Well_Marker or entire stratigraphic intervals for a Geologic Layer. |
| Submodel | Well_Marker |
| Entity Scope | Reference |
| Primary Key | Code |
| Natural Key | Code |
| Generalizations | Reference_Entity , Reference_Entity_Parent |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Absence_Flag | boolean | NA |
If the absence flag is yes (=1) then the feature is not present in the borehole. If the flag is no (=0) then the feature is present. | No |
NUMBER(1) |
| 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) |
| 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) |
| Name | STRING255 | NA |
The spelled-out name of the reference value. | No |
VARCHAR2(255) |
| 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 |
|---|---|---|---|---|
| Borehole_Point | Strat_Exception | This may indicate that part of the layer intersecting the borehole has been eroded, so an extra, projected marker may be set where the projected feature would have intersected the borehole. | Restrict | No |
| Borehole_Zone | Zone_Exception | This may indicate that part of the layer intersecting the borehole has been eroded, so an extra, projected marker may be set where the projected feature would have intersected the borehole. | Restrict | No |