| Name | R_Progression_Status |
|---|---|
| Entity Type | Table |
| Description | Indicates the status of a work order or individual item. |
| Submodel | Reference |
| Entity Scope | Reference |
| Primary Key | Code |
| Natural Key | Code |
| Generalizations | Reference_Entity , 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. | 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) |
| 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) |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Export_Job | Status | Refers to the status of the work order. | Restrict | Yes |
| Export_Job_Item | Status | Refers to the status of the work order item in the work order. | Restrict | Yes |
| WG_Work_Order_Default | Pre_Active_List_Code | The status code assigned in the list before a work order is active. | Restrict | Yes |
| WG_Work_Order_Default | Primary_List_Active_Code | 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 |
| WG_Work_Order_Default | Primary_WO_Active_Code | The status code that signifies that a work order is active. | Restrict | Yes |
| WG_Work_Order_Default | Open_Hold_Code | Status of work order when it tries to activate but cannot due to engaged inventory. | Restrict | Yes |
| WG_Work_Order_Default | Inv_Reshelved_Code | The code that is assigned to the work order status when the inventory item is reshelved. | Restrict | Yes |
| WG_Work_Order_Default | Root_Process_Active_Code | The status code to use when a root process initially starts progressing. | Restrict | Yes |
| WG_Work_Order_Default | Root_Process_Closed_Code | Root process status code to use when a root process initially starts progressing. | Restrict | Yes |
| WG_Work_Order_Default | Work_Order_Closed_Code | The status code to assign to a work order when it closes. | Restrict | Yes |
| WG_Work_Order_Default | Secondary_List_Active_Code | 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 |
| WG_Work_Order_Default | Secondary_WO_Active_Code | The status code that signifies that a work order is now active. Second level of status in the work order process. | Restrict | No |
| Work_Order | Work_Order_Status | The current status of the work order such as Active, Pending etc.. | Restrict | No |
| Work_Order_Process | Process_Status | The current status of the work order process. | Restrict | No |
| Y_SMM_Distributor_Config | Status_When_Executing | The value assigned to POLLED_ATTRIBUTE for job-executing status. | Restrict | Yes |
| Y_SMM_Distributor_Config | Status_After_Polling | The value assigned to POLLED_ATTRIBUTE after reading a job. | Restrict | Yes |
| Y_SMM_Distributor_Config | Status_After_Completion | The value assigned to POLLED_ATTRIBUTE for job-completed status. | Restrict | Yes |
| Y_SMM_Distributor_Config | Status_If_Cancelled | Value assigned to POLLED_ATTRIBUTE for job-cancelled status. | Restrict | Yes |
| Y_SMM_Distributor_Config | Status_After_Failure | The value assigned to POLLED_ATTRIBUTE if the job fails. | Restrict | Yes |