| 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 |
| 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) |
| 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) |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| 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 |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Storage_Unit_System | R_Unit_System | _ | Restrict | No |