R_Borehole_Status


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

General Information

[Next]
Name R_Borehole_Status
Entity Type Table
Description List of valid borehole statuses
Submodel Well
Entity Scope Reference
Primary Key Code
Natural Key Code
Generalizations Reference_Entity , 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)
Code CODE NA
A standard abbreviation, mnemonic, or short code that represents the reference value. Yes
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)
Life_Cycle_Sequence_Num int No_Unit
An integer that shows the typical sequence of borehole statuses over the lifetime of a borehole. The earliest status is sequence 1, the second earliest is sequence 2, etc. No
1
NUMBER(10)
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)


Referenced By

[Previous] [Next] [Top]
From EntityLinkDescriptionImplementation TechniqueRequired
Borehole Current_Status The status of the borehole that is currently in effect. This column represents a denormalization; and its value should be equal to the Borehole_Status.Status value in the Borehole_Status record where End_Date is NULL. Restrict No
Borehole_Status Status The Status code for the borehole status Restrict Yes
Rig_Planning Well_Type Type of well Nullify No


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

Copyright © 2018 Schlumberger. All rights reserved.