MSC_WTM_CALENDAR_WEEK_PERIODS

This table save the week and periods data for the week to month calendar hierarchy

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
MSC_WTM_CAL_WEEK_PERIOD_PK	ID, HIERARCHY_ID, DAY

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ID	NUMBER		18	Yes	Unique Identifier of the week to month calendar.
HIERARCHY_ID	NUMBER			Yes	Week to month hierarchy id of the source calendar.
DAY	DATE			Yes	Calendar Date for which week and period are mapped.
WEEK_START_DATE	DATE			Yes	Start date of the week for the week to month hierarchy.
WEEK_END_DATE	DATE			Yes	End date of the week for the week to month hierarchy.
WEEK_LENGTH	NUMBER		5	Yes	Length of the calendar week of week to month calendar hierarchy.
PERIOD_START_DATE	DATE			Yes	Start date of the period for the week to month hierarchy.
PERIOD_END_DATE	DATE			Yes	End date of the period for the week to month hierarchy.
PERIOD_LENGTH	NUMBER		5	Yes	Length of the calendar period of week to month calendar hierarchy.
REFRESH_NUMBER	NUMBER		18	Yes	Refresh Number identifier populated by the week to month hierarchy creation ESS process.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_WTM_CAL_WEEK_PERIODS_U1	Unique	Default	ID, HIERARCHY_ID, DAY