1. Tables and Views for SCM
  2. MSC_CALENDARS

MSC_CALENDARS

MSC_CALENDARS stores the definition of your workday calendar. You can follow any of the four following type of quarters for your yearly calendar identified by Quarterly Calendar Type = 1. 4-4-5 : quarterly pattern having two 4 weeks followed by a 5 week period 2. 5-4-4 : one 5 week followed by two 4 week periods 3. 13 periods : for calendar year 4. regular months of calendar year =

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

MSC_CALENDARS_PK

CALENDAR_CODE

Columns

Name Datatype Length Precision Not-null Comments
CALENDAR_CODE VARCHAR2 22 Yes Sequence generated calendar identifier on destination
CALENDAR_NAME VARCHAR2 240 Yes Name of the calendar for the selected period.
SR_CALENDAR_CODE VARCHAR2 32 Yes Source side unique identifier for the calendar or a schedule.
CALENDAR_TYPE VARCHAR2 30 Type of the calendar. RECEIVING, SHIPPING, CARRIER
DESCRIPTION VARCHAR2 250 Description of the associated calendar
DAYS_ON NUMBER Number of consecutive working days
DAYS_OFF NUMBER Number of consecutive non working days
CALENDAR_START_DATE DATE Beginning date for the calendar
CALENDAR_END_DATE DATE Ending date for the given calendar
QUARTERLY_CALENDAR_TYPE NUMBER Quarterely calendar type code. Possible Values:1. 4-4-5 : quarterly pattern having two 4 weeks followedby a 5 week period2. 5-4-4 : one 5 week followed by two 4 week periods3. 13 periods : for calendar year4. regular months of calendar year
PATTERN_STRING VARCHAR2 150 Pattern string indicating repetition of the days in a calendar.
DELETED_FLAG VARCHAR2 1 Flag that indicates whether a schedule is active or inactive. If deleted_flag==N then it is active.
SR_INSTANCE_ID NUMBER 18 Yes Identifier of the source system from where the data is collected.
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.
REFRESH_NUMBER NUMBER 18 Refresh identifier populated by the collection program.
OVERWRITE_FLAG VARCHAR2 1 This is used by the pre-processor during the batch load to determine whether an existing calendar needs to be rebuilt. Possible values for this field are 'Y' and 'N'. If this flag is 'Y' and the calendar does not exist in the planning system, then this calendar record would not be accepted by the pre-processor. Also, if this flag is 'N' or empty and the calendar does exist in the planning system (ODS) then this record would be rejected by the pre-processor.
WEEK_START_DAY NUMBER Indicates the day of calendar start date
FIRST_WORKING_DATE DATE First Working Date of the calendar
LAST_WORKING_DATE DATE Last Working Date
PATTERN_START_DAY NUMBER Start day of the week, possible values are 1- Monday, 2- First day of the calendar. Values from week_start_day are moved to this column.

Foreign Keys

Table Foreign Table Foreign Key Column
msc_workday_patterns msc_calendars CALENDAR_CODE
msc_cal_year_start_dates msc_calendars CALENDAR_CODE
msc_calendar_months msc_calendars CALENDAR_CODE
msc_calendar_dates msc_calendars CALENDAR_CODE
msc_calendar_shifts msc_calendars CALENDAR_CODE
msc_cal_week_start_dates msc_calendars CALENDAR_CODE
msc_calendar_exceptions msc_calendars CALENDAR_CODE
msc_calendar_assignments msc_calendars CALENDAR_CODE
msc_period_start_dates msc_calendars CALENDAR_CODE

Indexes

Index Uniqueness Tablespace Columns
MSC_CALENDARS_U1 Unique Default CALENDAR_CODE
MSC_CALENDARS_U2 Unique Default SR_CALENDAR_CODE, SR_INSTANCE_ID