R_LOV


[Columns] [Composed Of] [Referenced By] [Refers To]

General Information

[Next]
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


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit
DescriptionRequired /
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)


Refers To

[Previous] [Next] [Top]
LinkTo EntityDescriptionImplementation TechniqueRequired
Storage_Unit_System R_Unit_System _ Restrict No


[Seabed Objects] [Entities in Schema Seabed] [Index]

Copyright © 2018 Schlumberger. All rights reserved.