RCS_RESOURCE_AVL_DTLS
This table contains the generated work center resource availability data for a manufacturing production calendar. Each record has a start and end time with a value of available units for that time period and work center resource. The data is used by the collections process for value chain planning. The table is populated using the 'Update Resource Availability Job' scheduled process.
Details
-
Schema: FUSION
-
Object owner: RCS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
RCS_RESOURCE_AVL_DTLS_PK |
RESOURCE_SCHEDULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RESOURCE_SCHEDULE_ID | NUMBER | 18 | Yes | Unique identifier of a resource and schedule combination. | |
| SCHEDULE_DETAIL_ID | NUMBER | 18 | Yes | Foreign Key attribute that uniquely identify a row in ZMM_SR_SCHEDULE_DTLS. | |
| SCHEDULE_ID | NUMBER | 18 | Yes | Foreign Key attribute to identify which Schedule this row belongs to. | |
| SHIFT_ID | NUMBER | 18 | Foreign Key attribute to identify which Shift this row belongs to. | ||
| EXCEPTION_ID | NUMBER | 18 | Foreign Key attribute to identify which Exception this row belongs to. This could be mapped to Shift exception or Work center resource exception. | ||
| START_DATE_TIME | DATE | Yes | Start Date and Time for a period of working or non-working time for a unique Work Center Resource. | ||
| END_DATE_TIME | DATE | Yes | End Date and Time for a period of working or non-working time for a unique Work Center Resource. | ||
| MFG_ORG_IDENTIFIER | NUMBER | 18 | Yes | Manufacturing organization identifier for which work center resource exceptions made to a production calendar are defined. | |
| WORK_CENTER_ID | NUMBER | Yes | Indicates the work center where this resource resides. | ||
| WC_RESOURCE_IDENTIFIER | NUMBER | 18 | Yes | Work center resource identifier. | |
| AVAILABLE_UNITS | NUMBER | 18 | Yes | Number of work center resource instances assigned to this period of working or non-working time. A zero value indicates that the period of time is non-working. | |
| 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. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RCS_RESOURCE_AVL_DTLS_N1 | Non Unique | FUSION_TS_TX_IDX | MFG_ORG_IDENTIFIER, WORK_CENTER_ID, WC_RESOURCE_IDENTIFIER |
| RCS_RESOURCE_AVL_DTLS_U1 | Unique | FUSION_TS_TX_IDX | RESOURCE_SCHEDULE_ID |