WG_Work_Order_Default

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

General Information

[Next]
Name WG_Work_Order_Default
Entity Type Table
Description Contains the basic default values used by an application to process a work order. E.g. schema, work order Active ID, etc.
Submodel WesternGeco
Entity Scope Project
Primary Key Id
Natural Key
Generalizations Entity , IT_Object , Tracked_Object
Specializations


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit		DescriptionRequired /
Default		Type
Active_Flag boolean NA
 A flag that indicates if the row is the active row. A value of 1 indicates that the row is active, a value of 0 indicates that the row is not active. There can be only one active row. Yes
1		 NUMBER(1)
Application_Name STRING255 NA
 The name of the application to which the defaults apply. Yes
 VARCHAR2(255)
Box_Barcode_Block_Size int No_Unit
 The default batch size for box barcode identifiers. No
 NUMBER(10)
Default_Batch_Size int No_Unit
 The default batch size for user barcode identifiers. No
 NUMBER(10)
Entitlement_Schema STRING2000 NA
 The name of the schema where the entitlement tables are stored. No
 VARCHAR2(2000)
Existence_Kind REF_EXISTENCE_KIND NA
 A reference value that describes the state of existence in the lifecycle of the entity, for example, Planned, Predicted, Required, Simulated, and Actual. Yes
Actual		 VARCHAR2(64)
GUID STRING128 NA
 Globally Unique IDentifier for an instance of a class. USAGE NOTES: There are two cases: 1) GUID is not populated or used; and 2) it is populated with a value that is globally unique. If the GUID is populated there are two means of doing so for a given project: 2a) Seabed automatically generates and populates the GUID when an instance is created (valid only on Oracle based systems); and 2b) the GUID is generated and populated by an application (other than Seabed) on instance creation. Whether Seabed automatically generates GUIDs for a project is determined by the Auto_GUID flag in SDS_Account. Note that techniques 2a and 2b can coexist in the same project. When GUIDs are automatically generated an application can override the automatically generated GUID with its own GUID by simply supplying the GUID value. Applications that generate their own GUIDs and populate the GUID column will function correctly on projects which have automatic GUID generation turned on. No
 VARCHAR2(128)
IP_Entitlement_Flag boolean NA
 A flag that indicates if the IP entitlement is enabled for this entity. A value of 1 indicates that the entitlement is available. No
0		 NUMBER(1)
Id ID No_Unit
 Unique identifier for this entity. Yes
 NUMBER(38)
Initial_Security_Level int No_Unit
 Used by security to know what the default security level is upon system start. Valid values are 0, 1, 2. Yes
2		 NUMBER(10)
Initial_Work_Order_Status STRING255 NA
 This is the default value for the status of new work orders. No
 VARCHAR2(255)
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)
Inv_Barcode_Block_Size int No_Unit
 The default batch size for inventory barcode identifiers. No
 NUMBER(10)
Inv_Reshelved_Code R_Progression_Status
The code that is assigned to the work order status when the inventory item is reshelved. Yes
 VARCHAR2(64)
Location_Barcode_Block_Size int No_Unit
 The default batch size for location barcode identifiers. No
 NUMBER(10)
Logo_File_Path STRING255 NA
 The path to the logo file. No
 VARCHAR2(255)
Name ENTITY_NAME NA
 The name given to any object or data item, e.g. name of Well, name of Field, etc. No
 VARCHAR2(255)
Next_Barcode_No STRING255 NA
 The next available barcode number. No
 VARCHAR2(255)
Next_Box_Barcode_No STRING255 NA
 The next available barcode number for the box method. No
 VARCHAR2(255)
Next_Inv_Barcode_No STRING255 NA
 The next available barcode number for the inventory method. No
 VARCHAR2(255)
Next_Location_Barcode_No STRING255 NA
 The next available barcode number for the location method. No
 VARCHAR2(255)
Next_Sequence_Barcode_No STRING255 NA
 The next available barcode Number for the sequence method. No
 VARCHAR2(255)
ODBC_Driver_Name STRING255 NA
 The name of the default ODBC driver. No
 VARCHAR2(255)
Open_Hold_Code R_Progression_Status
Status of work order when it tries to activate but cannot due to engaged inventory. Yes
 VARCHAR2(64)
Original_Source STRING64 NA
 The name of the person, Organization or project source that originally provided this entity, e.g. "IHS-EnergyData" or "FinderUpper Stratton Deeper Pool 15" No
 VARCHAR2(64)
Pre_Active_List_Code R_Progression_Status
The status code assigned in the list before a work order is active. Yes
 VARCHAR2(64)
Primary_List_Active_Code R_Progression_Status
The code to assign in the active list when work order is activated. This is for the first level of progression for the active list. Yes
 VARCHAR2(64)
Primary_WO_Active_Code R_Progression_Status
The status code that signifies that a work order is active. Yes
 VARCHAR2(64)
Produced_By STRING64 NA
 The name of application role that created the entity, for data created programmatically. No
 VARCHAR2(64)
Remarks STRING2000 NA
 Any type of remarks added to an entity instance. No
 VARCHAR2(2000)
Root_Process_Active_Code R_Progression_Status
The status code to use when a root process initially starts progressing. Yes
 VARCHAR2(64)
Root_Process_Closed_Code R_Progression_Status
Root process status code to use when a root process initially starts progressing. Yes
 VARCHAR2(64)
SDAT_Label int No_Unit
 Label used by the security system for entitlements. SDAT is Secure Data Access Technology. No
 NUMBER(10)
Secondary_List_Active_Code R_Progression_Status
The code to assign in the active list when work order is activated. This is for the second level of progression for the active list. No
 VARCHAR2(64)
Secondary_WO_Active_Code R_Progression_Status
The status code that signifies that a work order is now active. Second level of status in the work order process. No
 VARCHAR2(64)
Sequence_Barcode_Block_Size int No_Unit
 The default value for inventory barcode identifiers. No
 NUMBER(10)
Source STRING64 NA
 Name of the person or organization responsible for this entitys E and P content and quality. Not the data technologist or IT expert creating the entity, for which see IT_Object.Insert_User and Update_User. 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 STRING255 NA
 The form or variant of the entity. Yes
1		 VARCHAR2(255)
WDMS_Report_Folder STRING2000 NA
 The name of the folder containing the WDMS reports. This can be a relative path or a Universal Naming Convention (UNC) name. Yes
 VARCHAR2(2000)
Western_Client_Id_List STRING128 NA
 The comma separated list of ids of the Western clients. No
 VARCHAR2(128)
Western_User_Id int No_Unit
 The default WesternGeco User id, used by work order templates No
 NUMBER(10)
Work_Order_Closed_Code R_Progression_Status
The status code to assign to a work order when it closes. Yes
 VARCHAR2(64)


Refers To

[Previous] [Next] [Top]
LinkTo EntityDescriptionImplementation TechniqueRequired
Root_Process_Closed_Code R_Progression_Status Root process status code to use when a root process initially starts progressing. Restrict Yes
Root_Process_Active_Code R_Progression_Status The status code to use when a root process initially starts progressing. Restrict Yes
Pre_Active_List_Code R_Progression_Status The status code assigned in the list before a work order is active. Restrict Yes
Primary_List_Active_Code R_Progression_Status The code to assign in the active list when work order is activated. This is for the first level of progression for the active list. Restrict Yes
Secondary_List_Active_Code R_Progression_Status The code to assign in the active list when work order is activated. This is for the second level of progression for the active list. Restrict No
Open_Hold_Code R_Progression_Status Status of work order when it tries to activate but cannot due to engaged inventory. Restrict Yes
Inv_Reshelved_Code R_Progression_Status The code that is assigned to the work order status when the inventory item is reshelved. Restrict Yes
Work_Order_Closed_Code R_Progression_Status The status code to assign to a work order when it closes. Restrict Yes
Secondary_WO_Active_Code R_Progression_Status The status code that signifies that a work order is now active. Second level of status in the work order process. Restrict No
Primary_WO_Active_Code R_Progression_Status The status code that signifies that a work order is active. Restrict Yes


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

Copyright © 2018 Schlumberger. All rights reserved.