| Name | R_Lab_Procedure_Condition |
|---|---|
| Entity Type | Table |
| Description | A reference table that stores valid lab procedure conditions. A lab procedure condition is a condition under which a lab procedure (such as rock sample preparation or rock sample analysis) is performed. Examples are time, pressure, temperature, etc. |
| Submodel | Rock_Sample_Analysis |
| 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 |
|---|---|---|---|---|---|
| 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) |
| Default_UOM | R_Unit |
|
The identifier of the unit of measure in which the lab procedure condition is normally measured such as kilograms, degrees Celsius, etc. This is the default value but the actual unit of measure for a given lab procedure condition is stored with the lab procedure condition itself. | No |
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 |
|---|---|---|---|---|
| SCAL_Analysis_Condition | Analysis_Condition | The lab procedure condition under which the analysis was performed. Examples are time, pressure, temperature. | Restrict | Yes |
| Sample_Prep_Condition | Prep_Condition | The lab procedure condition under which the preparation method was performed. Examples include, SOLVENT, TEMPERATURE, PRESSURE, TIME, FLOW THROUGH VOLUME, FLOW THROUGH RATE, RELATIVE HUMIDITY. | Restrict | Yes |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Default_UOM | R_Unit | The identifier of the unit of measure in which the lab procedure condition is normally measured such as kilograms, degrees Celsius, etc. This is the default value but the actual unit of measure for a given lab procedure condition is stored with the lab procedure condition itself. | Restrict | No |