RCS_QS_CAL_SPECS

This table contains the specification data used by Quick Setup to rapidly construct a calendar in the RCS Schedule Repository. This table information is accessed with the Quick Setup action available in the Facilities functional area when setting up Manufacturing and Supply Chain Materials Management.

Details

• Schema: FUSION

• Object owner: RCS

• Object type: TABLE

• Tablespace: REFERENCE

Primary Key

Name	Columns
RCS_QS_CAL_SPECS_PK	QC_CALENDAR_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
QC_CALENDAR_ID	NUMBER		18	Yes	Quick setup Calendar identifier.	Active
NAME	VARCHAR2	240		Yes	Collects the name which will be concatenated to form the Shift, Workday Pattern and Schedule from the calendar data.	Active
WEEKEND_DAYS	VARCHAR2	30		Yes	Days in the week that are considered the weekend by the user. Possible values are SAT_AND_SUN, FRI_AND_SAT, THU_AND_FRI, and FRI_ONLY.	Active
WD_START_TIME_MS	NUMBER		18	Yes	Start time of work day in milliseconds.	Active
WD_END_TIME_MS	NUMBER		18	Yes	End time of work day in milliseconds.	Active
START_DATE	DATE			Yes	User specified start date for the calendar. The user value may be modified in order to set the weekend days correctly.	Active
DURATION_IN_YEARS	NUMBER		3	Yes	End date for the calendar, indicating how far forward to generate data in years.	Active
RUN_ID	NUMBER		18	Yes	Quick setup Run Identifier.	Active
SCHEDULE_ID	NUMBER		18	Yes	Schedule identifier in the ZMM Schedule Repository.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
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.	Active

Indexes

Index	Uniqueness	Tablespace	Columns	Status
RCS_QS_CALS_SPECS_U1	Unique	FUSION_TS_TX_IDX	QC_CALENDAR_ID	Active