| Name | R_LOV |
|---|---|
| Entity Type | Table |
| Description | A table to allow generic Lists of Values to be generated on the fly. This table has no FK or ASSOC links either to it or from it and is ONLY to be used to generate a generic List of Values. |
| Submodel | Reference |
| Entity Scope | Reference |
| Primary Key | Ref_Id |
| Natural Key | Namespace , Attribute_Name , Form_Name , Code |
| Generalizations | Ref_Entity_Surrogate_Key , 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 | STRING32 | NA |
The attribute or field in the form to which this list of values refers. | Yes |
VARCHAR2(32) |
| 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) |
| Display_Order | int | No_Unit |
The default display order that the values should be displayed in. | No |
NUMBER(10) |
| Form_Name | STRING32 | NA |
The form or application in which this list of values is used. | Yes |
VARCHAR2(32) |
| 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) |
| Namespace | STRING64 | NA |
A value to differentiate between different types of LOV values. For example these are for client XYZ | Yes SLB |
VARCHAR2(64) |
| Ref_Id | ID | No_Unit |
The surrogate identifier of an instance of reference data. | Yes |
NUMBER(38) |
| 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) |
| 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 |
|---|---|---|---|---|
| Storage_Unit_System | R_Unit_System | _ | Restrict | No |