RCS_WC_RESOURCE_EXC
This table contains the data related to work center resource exceptions. These exceptions represent a change to the number of units available for a particular work center resource assigned to a manufacturing plant. The Work Center Resource Exception represents either (1) a change to the working time in the Plant for one or more resources, or (2) a change to the quantity of units available for one or more resources for a specific period of time in the Plant, or (3) a change to the non-working time in the Plant, which may be easier for a customer to model when only a small set of Work Center Resources in the Plant will be working in an exception period.
Details
-
Schema: FUSION
-
Object owner: RCS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
RCS_WC_RES_EXC_PK |
WC_RESOURCE_EXC_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ORGANIZATION_ID | NUMBER | 18 | Foreign key of the work center the exception is for. | ||
| SCHEDULE_ID | NUMBER | 18 | Yes | Foreign key of the CRM Common Schedule the exception is for. Also known as the Manufacturing Calendar, but modeled as the name used in ZMM. | |
| WC_RESOURCE_EXC_ID | NUMBER | 18 | Yes | Work center resource exception identifier. | |
| ASSOCIATED_SHIFT_ID | NUMBER | 18 | Associated shift identifier and foreign key to one of the Shifts which are assigned to the Schedule or Manufacturing Calendar. This is optional. | ||
| PLANT_SHIFT_EXC_ID | NUMBER | 18 | Plant shift exception identifier and foreign key to one of the Plant Shift Exceptions defined for this Manufacturing Plant. Optional field. | ||
| START_DATE | DATE | Yes | Start date for a resource exception. It will normally be an input argument to the creation flow, which is launched from the Calendar view. | ||
| END_DATE | DATE | Yes | End date for a resource exception. Default value is the Start Date. | ||
| EXC_START_TIME | NUMBER | 18 | Yes | Start time for resource exception. Default value is the start time of the associated shift or shift exception. | |
| EXC_END_TIME | NUMBER | 18 | Yes | End time for resource exception. Default value is the end time of the associated shift or shift exception. | |
| STANDALONE_WC_EXC_FLAG | VARCHAR2 | 1 | Flag value can be "Y" or "N". This will help in differentiating whether Work Center Exception has been created along Shift Exception("N") or not("Y"). | ||
| 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_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. | ||
| 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_WC_RES_EXC_U1 | Unique | FUSION_TS_TX_IDX | WC_RESOURCE_EXC_ID |