Table: WIP_OPERATION_RESOURCE_USAGE

Product:	WIP - Work in Process
Description:	Resource usage in an operation resource according to the shift and calendar information
Implementation/DBA Data:	WIP.WIP_OPERATION_RESOURCE_USAGE

Primary Key: WIP_OPERATION_RESOURCE_USG_PK

1. OPERATION_SEQ_NUM
2. ORGANIZATION_ID
3. REPETITIVE_SCHEDULE_ID
4. RESOURCE_SEQ_NUM
5. START_DATE
6. WIP_ENTITY_ID

Primary Key: WIP_OPERATION_RESOURCE_USG_UK

1. INSTANCE_ID
2. SERIAL_NUMBER
3. OPERATION_SEQ_NUM
4. ORGANIZATION_ID
5. REPETITIVE_SCHEDULE_ID
6. RESOURCE_SEQ_NUM
7. START_DATE
8. WIP_ENTITY_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
WIP_OPERATION_RESOURCE_USAGE		WIP_OPERATION_RESOURCES	WIP_OPERATION_RESOURCE_USAGE.WIP_ENTITY_ID WIP_OPERATION_RESOURCE_USAGE.OPERATION_SEQ_NUM WIP_OPERATION_RESOURCE_USAGE.RESOURCE_SEQ_NUM WIP_OPERATION_RESOURCE_USAGE.REPETITIVE_SCHEDULE_ID