R_WG_Work_Order_Action


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

General Information

[Next]
Name R_WG_Work_Order_Action
Entity Type Table
Description The action matrix of all possible actions for work order processing are contained here.
Submodel WesternGeco
Entity Scope Reference
Primary Key Ref_Id
Natural Key
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)
Code CODE NA
A standard abbreviation, mnemonic, or short code that represents the reference value. No
VARCHAR2(64)
Default_Flag boolean NA
A flag that indicates if the action is the default action for a list. There can be only one default action for each list. A value of 1 indicates that it is the default action for a given list number. A value of 0 indicates that it is not the default action for a given list number. Yes
NUMBER(1)
Description STRING2000 NA
A textual definition of the reference value. No
VARCHAR2(2000)
Fifth_Command int No_Unit
The fifth command to be executed for an action. No
NUMBER(10)
First_Command int No_Unit
The first command to be executed for an action. Yes
NUMBER(10)
Fourth_Command int No_Unit
The fourth command to be executed for an action. No
NUMBER(10)
Icon_Id int No_Unit
The Id of the image associated with this action. No
NUMBER(10)
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)
Inventory_Ownership_Flag boolean NA
A flag that indicates whether it is necessary for the user to own all the inventory in the work order for the action to be valid. A value of 1 indicates that it is required that the user own all the inventory for the action to be valid. A value of 0 indicates that it is not required that the user own all the inventory for the action to be valid. . Yes
NUMBER(1)
List_Number int No_Unit
The number of the list to which the action belongs. Yes
NUMBER(10)
Name STRING255 NA
The spelled-out name of the reference value. No
VARCHAR2(255)
Ref_Id ID No_Unit
The surrogate identifier of an instance of reference data. Yes
NUMBER(38)
Second_Command int No_Unit
The second command to be executed for an action. No
NUMBER(10)
Sixth_Command int No_Unit
The sixth command to be executed for an action. No
NUMBER(10)
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)
Third_Command int No_Unit
The third command to be executed for an action. No
NUMBER(10)
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)
Valid_Start_Copy_Flag boolean NA
A flag that indicates if this is a valid start action for a copy process. A value of 1 indicates that it is a valid action to start a copy process. A value of 0 indicates that it is not a valid action to start copy process. Yes
NUMBER(1)


Referenced By

[Previous] [Next] [Top]
From EntityLinkDescriptionImplementation TechniqueRequired
R_WG_Action_Parm Work_Order_Action The entry in the action matrix for which a parameter type is valid. Cascade Yes
WG_Process_Action Work_Order_Action The entry in the work order action matrix included in a work order process. Restrict Yes


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.