MSC_RESOURCE_REQUIREMENTS
This table stores the resource requirments generated by existing supplies.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
MSC_RESOURCE_REQS_PK |
PLAN_ID, TRANSACTION_ID, PART_KEY1 |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Yes | Resource Requirement Identifier | ||
| PLAN_ID | NUMBER | Yes | This value indicates the plan identifier for the record. | |||
| SUPPLY_ID | NUMBER | 18 | Yes | Supply identifier of the resource requirement. This is used for pegging. | ||
| ORGANIZATION_ID | NUMBER | 18 | Yes | This column indicates the Organization identifier | ||
| PART_KEY1 | NUMBER | 18 | Yes | Source instance identifier for the source org | ||
| ROUTING_SEQUENCE_ID | NUMBER | Routing sequence identifier for the routing/work definition. | ||||
| OPERATION_SEQUENCE_ID | NUMBER | Operation sequence identifier which generating the requirement | ||||
| RESOURCE_SEQ_NUM | NUMBER | Yes | Identifier of the planned resource requirement | |||
| RESOURCE_ID | NUMBER | Yes | This value indicates the Resource identifier. | |||
| DEPARTMENT_ID | NUMBER | 18 | Department identifier or the work centre of the resource. | |||
| ALTERNATE_NUM | NUMBER | Alternate number of the corresponding operation resource | ||||
| START_DATE | DATE | Yes | Start date of the resource requirement | |||
| NEED_BY_DATE | DATE | This is the date on which a resource requirement should be complete in order to meet the demand on time. | ||||
| MATERIAL_AVAIL_DATE | DATE | The completion date of the previous resource requirement in sequence. If this is the first resource requirement within the supply, then this date is the same as the material available date of the supply. | ||||
| CONSUMPTION_START_DATE | DATE | The start date of the next resource requirement in sequence. If this is the last resource requirement within the supply, then this date is the same as the consumption start date of the supply | ||||
| CONTRIBUTES_OVERLOAD | NUMBER | The resource requirement will have this attribute set to Yes, if it belongs to a time bucket in which resource capacity is overloaded | ||||
| CONTRIBUTES_DMD_LATENESS | NUMBER | This attribute value is Yes, if (Need by Date - Earliest Start Date) < lead time of the resource requirement | ||||
| END_DATE | DATE | End date of the resource requirement | ||||
| BKT_START_DATE | NUMBER | Bucketed start date for the given resource demand. | ||||
| RESOURCE_HOURS | NUMBER | Yes | This value indicates the Resource hours required. | |||
| SET_UP | NUMBER | Setup time for the resource requirement demand. | ||||
| BKT_END_DATE | NUMBER | Bucketed end date for the given resource demand. | ||||
| TEAR_DOWN | NUMBER | Tear down time specified for the resource demand. | ||||
| AGGREGATE_RESOURCE_ID | NUMBER | Reference to aggregate resource, if resource aggregated (denormalized column) | ||||
| SCHEDULE_FLAG | NUMBER | Schedule flag on the resource. If this is set then the resource is used in planning. | ||||
| PARENT_ID | NUMBER | 18 | Referent to parent transaction identifier | |||
| STD_OP_CODE | VARCHAR2 | 4 | Standard operation code of the resource requirement demand. | |||
| WIP_ENTITY_ID | NUMBER | 18 | Wip entity identifier for DJ resource requirements | |||
| ASSIGNED_UNITS | NUMBER | Yes | Number of resource units assigned to perform the operation. | |||
| 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) | ||||
| OPERATION_SEQ_NUM | NUMBER | The sequence number of the operation. | ||||
| LOAD_RATE | NUMBER | Load rate defined for the resource demand. | ||||
| DAILY_RESOURCE_HOURS | NUMBER | Daily resource hours needed for repetitive schedules | ||||
| STATUS | NUMBER | Attribute used for online replanning | ||||
| APPLIED | NUMBER | Attribute used for online replanning | ||||
| UPDATED | NUMBER | Flag to determine whether add workday modification was applied | ||||
| SUBST_RES_FLAG | NUMBER | Flag indicating whether resource is substitute resource | ||||
| REFRESH_NUMBER | NUMBER | Refresh number populated by the collection program | ||||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| SOURCE_ITEM_ID | NUMBER | 18 | Source inventory item unique identifier | |||
| ASSEMBLY_ITEM_ID | NUMBER | 18 | Assembly item unique identifier | |||
| SUPPLY_TYPE | NUMBER | 38 | This value indicates the Supply type of the resource requirement demand. | |||
| FIRM_START_DATE | DATE | The start date is marked to be firm. | ||||
| FIRM_END_DATE | DATE | End Date is marked as firm so that it doesn't change during replan. | ||||
| FIRM_FLAG | NUMBER | This flag indicates whether the resource requirement is marked as firm. | ||||
| CUMMULATIVE_QUANTITY | NUMBER | Resource requirement identifier | ||||
| YIELD | NUMBER | This value indicates the Yield specified for the resource demand. | ||||
| REVERSE_CUMULATIVE_YIELD | NUMBER | Reverse cumulative yield of the resource requirement. | ||||
| BATCH_NUMBER | NUMBER | Batch identifier generated during processing | ||||
| MINIMUM_TRANSFER_QUANTITY | NUMBER | Minimum transfer quantity specified for the department resource. | ||||
| REMAINING_CAPACITY | NUMBER | This value indicates the Remaining capacity of the resource requirement demand. | ||||
| OVERLOADED_CAPACITY | NUMBER | Overloaded capacity of the resource requirement demand. | ||||
| EARLIEST_START_DATE | DATE | Earliest start date. For Improved exceptions. | ||||
| EARLIEST_COMPLETION_DATE | DATE | Earliest completion date. For Improved exceptions. | ||||
| SCHEDULED_DEMAND_ID | NUMBER | Schedule demand identifier. For Improved exceptions. | ||||
| PARENT_SEQ_NUM | NUMBER | Schedule sequence number of the parent resource sequence. Used for Sequence Dependent Setups | ||||
| SETUP_ID | NUMBER | 18 | Setup identifier for the resource requirement demand. | |||
| ULPSD | DATE | Unconstrained Latest Possible Start Date/Time | ||||
| ULPCD | DATE | Unconstrained Latest Possible Completion Date/Time | ||||
| UEPSD | DATE | Unconstrained Earliest Possible Start Date/Time | ||||
| UEPCD | DATE | Unconstrained Earliest Possible Completion Date/Time | ||||
| EACD | DATE | Earliest Allowable Completion Date/Time | ||||
| 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 | ||||
| QUANTITY_COMPLETED | NUMBER | Number of units completed by the operation | ||||
| USAGE_RATE | NUMBER | Rate per assembly or amount per job/schedule | ||||
| HOURS_EXPENDED | NUMBER | Hours expended on a resource of a Job | ||||
| RECORD_SOURCE | NUMBER | For requirements generated by ATP | ||||
| ACTIVITY_GROUP_ID | NUMBER | 18 | unique identifier for the activity group | |||
| PRINCIPAL_FLAG | NUMBER | This flag indicates whether the resource is setup as principal. | ||||
| ORIG_RESOURCE_SEQ_NUM | NUMBER | This value stores original resource sequence number of the supply/demand. | ||||
| GROUP_SEQUENCE_ID | NUMBER | 18 | Identifies the firmed fixed sequence | |||
| GROUP_SEQUENCE_NUMBER | NUMBER | The group identifier to which this record refers to | ||||
| MAXIMUM_ASSIGNED_UNITS | NUMBER | Maximum assigned units of the resource. | ||||
| MINIMUM_CAPACITY | NUMBER | This will be in the same capacity as department resource capacity uom | ||||
| MAXIMUM_CAPACITY | NUMBER | Maximum Batch Capacity of the resource. | ||||
| BREAKABLE_ACTIVITY_FLAG | NUMBER | 1 If activity is breakable2 if activity is not breakable | ||||
| CAPACITY_CONSUMED_RATIO | NUMBER | Ratio of capacity used and resource capacity | ||||
| FROM_SETUP_ID | NUMBER | 18 | For sds activity: transition from_setup_id | |||
| 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 | ||||
| JIT_END_DATE | DATE | Just in time end date for the resource requirement demand. | ||||
| UNBUCKETED_START_DATE | DATE | Unbucketed Start Date of the resource demand. | ||||
| UNBUCKETED_END_DATE | DATE | Resource requirements Unbucketed end date. | ||||
| ACTUAL_START_DATE | DATE | An actual operation start date. | ||||
| TOTAL_RESOURCE_HOURS | NUMBER | Total (inflated) Resource hours required for an activity of a job | ||||
| ACTIVITY_NAME | VARCHAR2 | 20 | unique name given for the activity | |||
| OPERATION_NAME | VARCHAR2 | 20 | This column indicates the name of the operation. | |||
| NEW_PLAN_ID | NUMBER | This column indicates the new plan identifier. | ||||
| SIMULATION_SET_ID | NUMBER | Simulation set to which the current record is added. | ||||
| WIP_ENTITY_NAME | VARCHAR2 | 240 | This value indicates WIP job name 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. | ||||
| SR_INSTANCE_ID | NUMBER | 18 | Identifier of the source system from where the data is collected. | Obsolete | ||
| SUPPLIER_ID | NUMBER | 18 | This value indicates the Supplier identifier in the planning system. | |||
| SUPPLIER_SITE_ID | NUMBER | 18 | Supplier Site ID for OSP Operation | |||
| FIXED_LEAD_TIME | NUMBER | Fixed lead time. This is used irrespective of the quantity being manufactured. | ||||
| VARIABLE_LEAD_TIME | NUMBER | Variable lead time used in conjunction with the quantity of the assembly being manufactured. | ||||
| OPERATION_COST | NUMBER | This value indicates OSP Operation Cost. | ||||
| OSP_OPERATION_TYPE | NUMBER | Indicate operation type: InHouse(1) or Supplier(2) | ||||
| PRIMARY_RESOURCE_ID | NUMBER | 18 | Primary Resource ID. Populated when alternate resource is provided. | |||
| EXECUTION_SEQUENCE | NUMBER | Indicates the execution sequence number of the operation if the work order has the re-sequence operations. | ||||
| RES_CONSTRAINT_DATE | DATE | The date populated by planning engine process for a bottleneck or resource marked as critical which is constrained. | ||||
| CONSTR_DATE_RES_CAPACITY | NUMBER | The total capacity required by the resource computed by planning engine on the resource constraint date. | ||||
| CONSTR_DATE_ADDITIONAL_CAP | NUMBER | The additional capacity required by resource computed by planning engine on the resource constraint date. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MSC_RESOURCE_REQUIREMENTS | msc_routings | PLAN_ID, ORGANIZATION_ID, ROUTING_SEQUENCE_ID, NEW_PLAN_ID, SIMULATION_SET_ID, PART_KEY1 |
| MSC_RESOURCE_REQUIREMENTS | msc_supplies | PLAN_ID, TRANSACTION_ID, PART_KEY1 |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| MSC_RESOURCE_REQS_N1 | Non Unique | Default | PLAN_ID, ORGANIZATION_ID, DEPARTMENT_ID, RESOURCE_ID, SUPPLY_ID, OPERATION_SEQ_NUM | |
| MSC_RESOURCE_REQS_N2 | Non Unique | Default | PLAN_ID, SUPPLY_ID, ORGANIZATION_ID, WIP_ENTITY_ID | |
| MSC_RESOURCE_REQS_N3 | Non Unique | Default | PLAN_ID, WIP_ENTITY_ID, OPERATION_SEQ_NUM | |
| MSC_RESOURCE_REQS_N4 | Non Unique | Default | PLAN_ID, ORGANIZATION_ID, SUPPLY_ID, FIRM_FLAG, PARENT_ID | |
| MSC_RESOURCE_REQS_N5 | Non Unique | Default | PLAN_ID, ORGANIZATION_ID, ASSEMBLY_ITEM_ID | |
| MSC_RESOURCE_REQS_U1 | Unique | Default | PLAN_ID, TRANSACTION_ID, PART_KEY1 | |
| MSC_RESOURCE_REQS_U2 | Unique | Default | PLAN_ID, ORGANIZATION_ID, WIP_ENTITY_NAME, OPERATION_SEQ_NUM, RESOURCE_SEQ_NUM, DEPARTMENT_ID, RESOURCE_ID | Obsolete |