MSC_ST_OPERATION_RESOURCES
The staging table used by the collection program to validate and process data for table MSC_OPERATION_RESOURCES.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| ROUTING_SEQUENCE_ID | NUMBER | Routing sequence identifier for the routing/work definition. | ||
| RESOURCE_TYPE | NUMBER | This value indicates the Resource type. | ||
| OPERATION_SEQUENCE_ID | NUMBER | Reference to the operation to which this resource is assigned. | ||
| RESOURCE_SEQ_NUM | NUMBER | This value indicates the Resource sequence number. | ||
| RESOURCE_ID | NUMBER | This value indicates the Resource identifier. | ||
| ALTERNATE_NUMBER | NUMBER | Resources with the same number are simultaneous. Different numbers represent alternatives between groups of resources | ||
| PRINCIPAL_FLAG | NUMBER | Flag to indicate whether the resource is the principal resource | ||
| BASIS_TYPE | NUMBER | Indicates the usage of this resource i.e whether the resource usage is fixed (e.g., usage per lot produced) or variable (e.g., usage per item produced) | ||
| RESOURCE_USAGE | NUMBER | This value indicates the Resource usage. | ||
| MAX_RESOURCE_UNITS | NUMBER | Maximum number of resource units consumed by this operation resource | ||
| RESOURCE_UNITS | NUMBER | Operation resource units (capacity) | ||
| UOM_CODE | VARCHAR2 | 50 | Unit of measure code of the operation resource. | |
| DELETED_FLAG | NUMBER | Yes/No flag indicates whether corresponding record in ODS will be deleted | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |
| SR_INSTANCE_ID | NUMBER | Source application instance identifier | ||
| REFRESH_NUMBER | NUMBER | Refresh number populated by the collection program | ||
| COMPANY_ID | NUMBER | Unique id assigned to the company | ||
| COMPANY_NAME | VARCHAR2 | 255 | Party name with which the company is registered. | |
| ROUTING_NAME | VARCHAR2 | 250 | Name of the routing or a work definition. | |
| ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | 30 | Name of the alternate routing. Null for primary routing | |
| ORGANIZATION_CODE | VARCHAR2 | 18 | Short alphanumeric code to identify the Organization. | |
| OPERATION_SEQ_NUM | NUMBER | Operation sequence number of the operation associated with the resource. | ||
| ASSEMBLY_NAME | VARCHAR2 | 300 | Assembly Name. This has to be provided for uploads from legacy | |
| OPERATION_EFFECTIVITY_DATE | DATE | This value indicates Effectivity date. | ||
| SR_INSTANCE_CODE | VARCHAR2 | 30 | Source Instance code from which data is being populated. | |
| OPERATION_SEQ_CODE | VARCHAR2 | 10 | This value indicates the Operation sequence code. | |
| RESOURCE_SEQ_CODE | VARCHAR2 | 10 | This value indicates the Resource Sequence Code. | |
| DEPARTMENT_ID | NUMBER | Department identifier or the work centre of the resource. | ||
| DEPARTMENT_CODE | VARCHAR2 | 120 | Department code or the work centre of the resource. | |
| RESOURCE_CODE | VARCHAR2 | 40 | Resource Identifier for this Operation | |
| PRIMARY_RESOURCE_CODE | VARCHAR2 | 40 | Primary resource for a resource code(alternate) | |
| ERROR_TEXT | VARCHAR2 | 2000 | This will describe the reason for the error if any. | |
| MESSAGE_ID | NUMBER | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML | ||
| PROCESS_FLAG | NUMBER | Process Flag indicates the status of records during pre-processing. 1- Compete Record, 2- Error Record, 3- Warning Record, 4- Retry Record, 5- New Record. | ||
| DATA_SOURCE_TYPE | VARCHAR2 | 15 | Source Type indicating the source of the records | |
| ST_TRANSACTION_ID | NUMBER | Transaction ID generated during pre-processing to uniquely identify a record in the staging table | ||
| BATCH_ID | NUMBER | Batch identifier generated during pre-processing | ||
| ACTIVITY_GROUP_ID | NUMBER | unique identifier for the activity group | ||
| SCHEDULE_FLAG | NUMBER | Method of scheduling the resource | ||
| ORGANIZATION_ID | NUMBER | This column indicates the organization identifier. | ||
| RESOURCE_OFFSET_PERCENT | NUMBER | Percent of total lead time upto the beginning of this operation resource. | ||
| SOURCE_ROUTING_SEQUENCE_ID | NUMBER | This is the Routing Sequence ID for the Routing Sequence in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
| SOURCE_OPERATION_SEQUENCE_ID | NUMBER | This is the Operation Sequence ID for the Operation Sequence in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
| SOURCE_RESOURCE_SEQ_NUM | NUMBER | This is the Resource Sequence Number for the Resource Sequence in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
| SOURCE_RESOURCE_ID | NUMBER | This is the Resource ID for the Resource in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
| SOURCE_DEPARTMENT_ID | NUMBER | This is the Department ID for the Department in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
| SOURCE_ORGANIZATION_ID | NUMBER | This is the Organization ID for the Organization in the legacy(source) system.This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
| SETUP_ID | NUMBER | Setup type to be used for this resource | ||
| MINIMUM_CAPACITY | NUMBER | this will be in the same capacity as department resource capacity uom | ||
| MAXIMUM_CAPACITY | NUMBER | Maximum Capacity of the Batchable resource | ||
| ORIG_RESOURCE_SEQ_NUM | NUMBER | Resource Sequence Number in resource instance | ||
| BREAKABLE_ACTIVITY_FLAG | NUMBER | 1= Activity is breakable 2 Activity is non breakable | ||
| RETRY_COUNT | NUMBER | Number of retries to process failed records. | ||
| ERROR_CODE | VARCHAR2 | 150 | Error code for functional validation errors in the record | |
| LOAD_REQUEST_ID | NUMBER | It Stores the Request ID of Job that loaded the data. |