| Name | R_Measurement_Scal_Cat |
|---|---|
| Entity Type | Table |
| Description | The catalog for scalar measurement tags with default information |
| Submodel | Facility |
| Entity Scope | Reference |
| Primary Key | Ref_Id |
| Natural Key | |
| Generalizations | R_Measurement_Tag_Cat , Ref_Entity_Surrogate_Key , Reference_Entity_Parent |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Acquistion_Device_Cat | R_Acquisition_Device_Cat |
|
The type of acquisition device for which this measurement tag is defined. | No |
NUMBER(38) |
| 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. | No |
VARCHAR2(64) |
| Description | STRING2000 | NA |
A textual definition of the reference value. | No |
VARCHAR2(2000) |
| IO_Data_Type | R_Data_Type |
|
The data type of the input/output. For example, boolean, integer, float, etc. | No |
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) |
| Measurement_Tag_Type | R_Measurement_Tag |
|
The type associated with the definition of a measurement. | No |
VARCHAR2(64) |
| Measurement_Tag_UOM | R_Unit |
|
The unit of measure in which the value for the measurement tag is stored. | No |
VARCHAR2(64) |
| Name | STRING255 | NA |
The spelled-out name of the reference value. | No |
VARCHAR2(255) |
| Property_Code | R_Property |
|
The property represented by this measurement tag (e.g. Pressure, Temperature) | No |
VARCHAR2(64) |
| Raw_High_Limit_Value | double | No_Unit |
The default upper raw limit value for a measurement | No |
NUMBER |
| Raw_High_Value | double | No_Unit |
The maximum value possible for the raw value (as it is acquired from the device) of the scalar tag. | No |
NUMBER |
| Raw_Low_Limit_Value | double | No_Unit |
The default lower raw limit value for a measurement | No |
NUMBER |
| Raw_Low_Value | double | No_Unit |
The minimal value possible for the raw value (as it is acquired from the device) of the scalar tag. | No |
NUMBER |
| Read_Write_Indicator | STRING4 | NA |
Read means measurement device, Write means control device. So a device is either a measurement or a control device. | No |
VARCHAR2(4) |
| Ref_Id | ID | No_Unit |
The surrogate identifier of an instance of reference data. | Yes |
NUMBER(38) |
| Register_Address | STRING64 | NA |
Equipment register | No |
VARCHAR2(64) |
| Scale_High_Value | double | No_Unit |
The maximum value possible for the scaled value (the value in the real physical scale) of the scalar tag. | No |
NUMBER |
| Scale_Low_Value | double | No_Unit |
The minimal value possible for the scaled value (the value in the real physical scale) of the scalar tag. | No |
NUMBER |
| 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_Unit_System | R_Unit_System |
|
The unit system in which the numeric values are stored. It is expected that every numeric value in this table will be of the same unit system e.g Metric, English etc | No |
VARCHAR2(64) |
| Typical_Source | CODE | NA |
A string to denote whether this tag is usually associated with a well, a facility or another entity. | 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) |
| Version | CODE | NA |
A string to represent the version assigned to this particular tag configuration. | No |
VARCHAR2(64) |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Measurement_Set_Component | Measurement | The measurement that is part of the Measurement_Set | Restrict | Yes |
| Measurement_Tag_Scal_Conf | Config_Cat | The default catalog entry for this tag configuration | Restrict | No |
| R_Acquisition_Dev_Config | Measurement_Tag_Cat | The measurement tag catalog entry which forms part of the default configuration of the acquisition device. | Restrict | Yes |
| R_Measurement_Threshold | Threshold_Tag_Cat | The definition of the tag that provides the threshold value for the parent tag | Restrict | Yes |
| R_Measurement_Threshold | Measurement_Tag_Cat | The definition of the tag to which the threshold is associated. | Restrict | Yes |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Property_Code | R_Property | _ | Restrict | No |
| Measurement_Tag_UOM | R_Unit | _ | Restrict | No |
| Storage_Unit_System | R_Unit_System | _ | Restrict | No |
| IO_Data_Type | R_Data_Type | _ | Restrict | No |
| Acquistion_Device_Cat | R_Acquisition_Device_Cat | _ | Restrict | No |
| Measurement_Tag_Type | R_Measurement_Tag | _ | Restrict | No |