1. Tables and Views for SCM
  2. RCS_PLANT_SHIFT_EXC_B

RCS_PLANT_SHIFT_EXC_B

This table contains data related to shift exceptions. A Shift Exception represents a change in the Shift assigned to a specific Manufacturing Plant. Each shift exception represents either (1) a change to a shift representing working time in the plant or (2) a change to the non-working time in the plant production calendar. Non-working time converted to working time must be associated with a calendar shift to properly default the resources that will be working in the plant during this exception period.

Details

  • Schema: FUSION

  • Object owner: RCS

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

RCS_PLANT_SHIFT_EXC_B_PK

PLANT_SHIFT_EXC_ID

Columns

Name Datatype Length Precision Not-null Comments
PLANT_SHIFT_EXC_ID NUMBER 18 Yes Primary key for the plant shift exception.
ORGANIZATION_ID NUMBER 18 Yes Foreign key of the manufacturing plant the exception is for.
MFG_WC_ID NUMBER 18 Represents the work center identifier that is the foreign key to the WIS_WORK_CENTERS_B table.
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.
ASSOCIATED_SHIFT_ID NUMBER 18 Yes Foreign key to one of the Shifts which are assigned to the Schedule/Manufacturing Calendar. The Shift has to be present in the Schedule/Manufacturing Calendar.
START_DATE DATE Yes Start date for a Shift exception. Normally this is an input argument to the creation flow, which is launched from the Calendar view.
END_DATE DATE Yes End date for a Shift exception. Default is the Start Date.
EXCEPTION_TYPE VARCHAR2 30 Yes Exception type. Possible values are: Change shift, Remove shift, Split shift and Add shift. When an associated shift is passed into the exception as an input, the default value is Change shift. When no shift is passed into the exception as an input, the only valid value is Add shift.
EXC_START_TIME NUMBER 18 Yes Start time for shift exception. Default is the start time of the associated shift. Time is stored in milli seconds.
EXC_DURATION NUMBER 18 Duration of the shift exception. Default value is the duration of the associated shift.
EXC_END_TIME NUMBER 18 Yes A calculated value, derived from the Exception Start Time and Duration. Note that end times will not take breaks in the Shift into account. Time value will be stored in milli seconds.
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_PLANT_SHIFT_EXC_B_U1 Unique FUSION_TS_TX_IDX PLANT_SHIFT_EXC_ID