eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: MSC.MSC_CALENDARS

Object Details

Object Name:	MSC_CALENDARS
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.MSC_CALENDARS
Subobject Name:
Status:	VALID

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
=

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_CALENDARS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SR_INSTANCE_ID CALENDAR_CODE

Columns

Name	Datatype	Length	Comments
CALENDAR_CODE	VARCHAR2	(30)	Workday calendar identifier
DESCRIPTION	VARCHAR2	(250)	Description
DAYS_ON	NUMBER		Number of consecutive working days
DAYS_OFF	NUMBER		Number of consecutive non working days
CALENDAR_START_DATE	DATE		Start date of calendar
CALENDAR_END_DATE	DATE		End date of 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
SR_INSTANCE_ID	NUMBER		Source Instance id
LAST_UPDATE_DATE	DATE		Standard WHO column
LAST_UPDATED_BY	NUMBER		Standard WHO column
CREATION_DATE	DATE		Standard WHO column
CREATED_BY	NUMBER		Standard WHO column
LAST_UPDATE_LOGIN	NUMBER		Standard WHO column
REQUEST_ID	NUMBER		Concurrent WHO column
PROGRAM_APPLICATION_ID	NUMBER		Concurrent WHO column
PROGRAM_ID	NUMBER		Concurrent WHO column
PROGRAM_UPDATE_DATE	DATE		Concurrent WHO column
REFRESH_ID	NUMBER		Refresh Id
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		Start day of the week, possible values are 1- Monday, 2- First day of the calendar
FIRST_WORKING_DATE	DATE		First Working Date
LAST_WORKING_DATE	DATE		Last Working Date
CALENDAR_TYPE	VARCHAR2	(10)	Calendar type: 'FISCAL' - Fiscal Cal for DP/Demantra; null otherwise

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CALENDAR_CODE
,      DESCRIPTION
,      DAYS_ON
,      DAYS_OFF
,      CALENDAR_START_DATE
,      CALENDAR_END_DATE
,      QUARTERLY_CALENDAR_TYPE
,      SR_INSTANCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REFRESH_ID
,      OVERWRITE_FLAG
,      WEEK_START_DAY
,      FIRST_WORKING_DATE
,      LAST_WORKING_DATE
,      CALENDAR_TYPE
FROM MSC.MSC_CALENDARS;

Dependencies

[top of page]

MSC.MSC_CALENDARS does not reference any database object

MSC.MSC_CALENDARS is referenced by following:

APPS: MSC_CALENDARS; MSC_PHUB_MFG_CAL_DATES_MV; MSC_PHUB_MFG_CAL_PERIODS_MV; MSC_PHUB_MFG_CAL_WEEKS_MV