| Name | R_QC_Reference_Value |
|---|---|
| Entity Type | Table |
| Description | Allowable values for a controlled QC Attribute. For example, for the QC_Attribute_Name Status, in the context of External_Object_Type Well_Log, allowed values are "High", "Medium", "Low". |
| Submodel | Quality_And_Context |
| Entity Scope | Reference |
| Primary Key | Pick_List_Value , Attribute_Name_Context , Attribute_Type , External_Object_Type_Contxt , Storage_System_Code |
| Natural Key | Pick_List_Value , Attribute_Name_Context , Attribute_Type , External_Object_Type_Contxt , Storage_System_Code |
| Generalizations | Reference_Entity_Parent |
| Specializations |
| Name | Value Domain | Property / Storage Unit | 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) |
| Attribute_Name_Context | R_QC_Attribute_Use | NA |
The code, mnemonic, or identifier used to enumerate types, occurrences, or instances of some property or entity. | Yes |
VARCHAR2(64) |
| Attribute_Type | R_QC_Attribute_Use | NA |
The code, mnemonic, or identifier used to enumerate types, occurrences, or instances of some property or entity. | Yes |
VARCHAR2(64) |
| Description | STRING2000 | NA |
A textual definition of the reference value. | No |
VARCHAR2(2000) |
| External_Object_Type_Contxt | R_QC_Attribute_Use | NA |
The code, mnemonic, or identifier used to enumerate types, occurrences, or instances of some property or entity. | Yes |
VARCHAR2(64) |
| 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) |
| Pick_List_Value | STRING255 | NA |
List of values used to control qc attribute values. Also used by application to present a dropdown list of allowable values. | Yes |
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) |
| Storage_System_Code | R_QC_Attribute_Use | NA |
The code, mnemonic, or identifier used to enumerate types, occurrences, or instances of some property or entity. | Yes |
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 |
|---|---|---|---|---|
| QC_Attribute_Value | Attribute_Constraint | The value in QC_Attribute_Value must match one of the allowed values in QC_Reference_Value. | Restrict | Yes |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Attribute_Use_Context | R_QC_Attribute_Use | The QC value is defined for a particular attribute name in the context of a particular object type. | Restrict | Yes |