MSC_ST_RESOURCE_REQUIREMENTS
The staging table used by the collection program to validate and process data for table MSC_RESOURCE_REQUIREMENTS.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DEPARTMENT_ID | NUMBER | Department identifier or the work centre of the resource. | |||
| RESOURCE_ID | NUMBER | This value indicates the Resource identifier. | |||
| ORGANIZATION_ID | NUMBER | This column indicates the organization identifier. | |||
| INVENTORY_ITEM_ID | NUMBER | Identifies the inventory item id | |||
| SUPPLY_ID | NUMBER | Supply identifier of the resource requirement. This is used for pegging. | |||
| OPERATION_SEQ_NUM | NUMBER | Operation sequence number of the operation associated with the resource. | |||
| OPERATION_SEQUENCE_ID | NUMBER | Reference to the operation to which this routing is assigned. | |||
| RESOURCE_SEQ_NUM | NUMBER | This value indicates the Resource sequence number. | |||
| START_DATE | DATE | Start date of the resource requirement | |||
| OPERATION_HOURS_REQUIRED | NUMBER | This value indicates Operation hours required. | |||
| HOURS_EXPENDED | NUMBER | Hours expended on a resource of a Job | |||
| DEMAND_CLASS | VARCHAR2 | 34 | Class to which the demand is tied. | ||
| 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) | |||
| ASSIGNED_UNITS | NUMBER | Number of resource units assigned to perform the operation. | |||
| END_DATE | DATE | End date of the resource requirement | |||
| WIP_JOB_TYPE | NUMBER | This stores the value of WIP job type for an assembly. | |||
| SCHEDULED_COMPLETION_DATE | DATE | Completion date of WIP job stamped on the resource requirement demand. | |||
| SCHEDULED_QUANTITY | NUMBER | Wip job quantity of the resource requirement. | |||
| QUANTITY_COMPLETED | NUMBER | This value indicates the Quantity completed. | |||
| 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 identifier populated by the collection program | |||
| WIP_ENTITY_ID | NUMBER | This stores the value of WIP job identifier for an assembly. | |||
| STD_OP_CODE | VARCHAR2 | 4 | Standard operation code of the resource requirement demand. | ||
| SUPPLY_TYPE | NUMBER | This value indicates the Supply type of the resource requirement demand. | |||
| CUMMULATIVE_QAUNTITY | NUMBER | Cumulative quantity of the resource requirement. | |||
| MINIMUM_TRANSFER_QUANTITY | NUMBER | Minimum transfer quantity specified for the department resource. | |||
| FIRM_FLAG | NUMBER | Yes/No flag indicates whether corresponding record in ODS will be deleted | |||
| COMPANY_ID | NUMBER | Unique id assigned to the company | |||
| COMPANY_NAME | VARCHAR2 | 255 | Party name with which the company is registered. | ||
| WIP_ENTITY_NAME | VARCHAR2 | 240 | This stores the value of WIP job identifier for an assembly. | ||
| ITEM_NAME | VARCHAR2 | 300 | Identifies the inventory item name | ||
| ORGANIZATION_CODE | VARCHAR2 | 18 | This column indicates the organization code. | ||
| SR_INSTANCE_CODE | VARCHAR2 | 30 | Source Instance code from which data is being populated. | ||
| OPERATION_SEQ_CODE | VARCHAR2 | 10 | This value indicates Operation Sequence Code. | ||
| RESOURCE_SEQ_CODE | VARCHAR2 | 10 | This value indicates the Resource Sequence Identifier. | ||
| DEPARTMENT_CODE | VARCHAR2 | 120 | Department code or the work centre of the resource. | ||
| RESOURCE_CODE | VARCHAR2 | 40 | The value indicates resource code collected from source system. | ||
| ROUTING_NAME | VARCHAR2 | 250 | Name of the routing or a work definition. | ||
| ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | 10 | Name of the alternate routing. Null for primary routing | ||
| OPERATION_EFFECTIVITY_DATE | DATE | This value indicates Effectivity date. | |||
| ALTERNATE_NUMBER | NUMBER | Resources with the same number are simultaneous. Different numbers represent alternatives between groups of resources | |||
| ERROR_TEXT | VARCHAR2 | 2000 | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error | ||
| ERROR_CODE | VARCHAR2 | 150 | Error code for functional validation errors in the record | ||
| MESSAGE_ID | NUMBER | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML | |||
| PROCESS_FLAG | NUMBER | Processing Flag indicating 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 | |||
| PARENT_SEQ_NUM | NUMBER | Schedule sequence number of the parent resource sequence. Used for sequence Dependent Setups. | |||
| SETUP_ID | NUMBER | Setup identifier for the resource requirement demand. | |||
| SCHEDULE_FLAG | NUMBER | Method of scheduling the resource | |||
| QUANTITY_IN_QUEUE | NUMBER | Number of units in Queue of the operation | |||
| QUANTITY_RUNNING | NUMBER | Number of units in To Run of the operation | |||
| QUANTITY_WAITING_TO_MOVE | NUMBER | Number of units waiting To Move in the operation | |||
| YIELD | NUMBER | This value indicates the Yield specified for the operation in resource demand. | |||
| USAGE_RATE | NUMBER | Rate per assembly or amount per job | |||
| ACTIVITY_GROUP_ID | NUMBER | unique identifier for the activity group | |||
| PRINCIPAL_FLAG | NUMBER | This flag indicates whether the resource is setup as principal. | |||
| 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. | |||
| 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_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_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_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_WIP_ENTITY_ID | NUMBER | This is the WIP Entity ID for the WIP Entity 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_SEQ_NUM | 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. | |||
| ORIG_RESOURCE_SEQ_NUM | NUMBER | This value stores original resource sequence number of the supply/demand. | |||
| ROUTING_SEQUENCE_ID | NUMBER | Routing sequence identifier for the routing/work definition. | |||
| GROUP_SEQUENCE_ID | NUMBER | Identifies the firmed fixed sequence | |||
| GROUP_SEQUENCE_NUMBER | NUMBER | The group identifier to which this record refers to | |||
| BATCH_NUMBER | NUMBER | Batch Number assigned to batchable resource | |||
| MAXIMUM_ASSIGNED_UNITS | NUMBER | Number of resource units assigned to this operation. | |||
| MINIMUM_CAPACITY | NUMBER | This will be in the same capacity as department resource capacity uom | |||
| MAXIMUM_CAPACITY | NUMBER | Maximum Capacity of the Batchable resource. | |||
| BREAKABLE_ACTIVITY_FLAG | NUMBER | 1 If activity is breakable2 if activity is not breakable | |||
| STEP_QUANTITY | NUMBER | Quantity associated with an operation. Populated for opm jobs | |||
| STEP_QUANTITY_UOM | VARCHAR2 | 3 | Unit of measure of the step quantity of the resource demand. | ||
| UNADJUSTED_RESOURCE_HOURS | NUMBER | Resource hours unadjusted for utilization and efficiency | |||
| TOUCH_TIME | NUMBER | unadjusted resource hours inflated for efficiency | |||
| ACTUAL_START_DATE | DATE | Actual Start Date and Time for the activity of the job | |||
| ACTIVITY_NAME | VARCHAR2 | 20 | unique name given for the activity | ||
| OPERATION_NAME | VARCHAR2 | 20 | This column indicates the name of the operation. | ||
| OSP_OPERATION_TYPE | NUMBER | Indicate operation type: InHouse(1) or Supplier(2) | |||
| OSP_ITEM_NAME | VARCHAR2 | 300 | Name of the OSP_ITEM used for OSP operation | ||
| OSP_ITEM_ID | NUMBER | Inventory item identifier of the Outside processing item. | |||
| SUPPLIER_NAME | VARCHAR2 | 360 | Supplier name for OSP operation | ||
| SUPPLIER_ID | NUMBER | 18 | This value indicates the Supplier identifier in the planning system. | ||
| SUPPLIER_SITE_CODE | VARCHAR2 | 240 | Supplier Site code for OSP operation | ||
| SUPPLIER_SITE_ID | NUMBER | 18 | Supplier Site Id for OSP operation | ||
| OPERATION_COST | NUMBER | This value indicates OSP Operation Cost. | |||
| LEAD_TIME_UOM | VARCHAR2 | 3 | Represents the unit of measure for the fixed and/or variable lead time values on the supplier operation. | ||
| FIXED_LEAD_TIME | NUMBER | Represents the fixed lead time used to calculate the operations start and end date for the supplier operation. | |||
| VARIABLE_LEAD_TIME | NUMBER | Variable lead time used in conjunction with the quantity of the assembly being manufactured. | |||
| RETRY_COUNT | NUMBER | Number of retries to process failed records. | |||
| LOAD_REQUEST_ID | NUMBER | It Stores the Request ID of Job that loaded the data. | |||
| VCS_DATA_REQUEST_ID | NUMBER | This column is populated by SCC-SCP integration flow. It holds request_id of the SCC ESS Job that invokes the SCP CSV Upload ESS Job. | |||
| EXECUTION_SEQUENCE | NUMBER | Indicates the execution sequence number of the operation if the work order has the re-sequence operations. |