MSC_ST_CAL_WEEK_START

Details

Schema: FUSION
Object owner: MSC
Object type: TABLE
Tablespace: INTERFACE

Columns

Name	Datatype	Length	Not-null	Comments
CALENDAR_CODE	VARCHAR2	22	Yes	CALENDAR_CODE of the given Calendar
EXCEPTION_SET_ID	NUMBER			Exception set identifier for this process result
WEEK_START_DATE	DATE		Yes	This value indicates the start date of the week.
WEEK_END_DATE	DATE			This value indicates the end date of the week.
NEXT_DATE	DATE			The column indicates the next week start date.
PRIOR_DATE	DATE			Previous date for the current date in the calendar dates.
SEQ_NUM	NUMBER			Sequence number of the date on a calendar.
DELETED_FLAG	NUMBER			Flag indicating whether this is a deleted record
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			Refresh identifier populated by the collection program
PROCESS_FLAG	NUMBER			Processing Flag indicating the status of records during pre-processing. 1- Complete Record, 2- Error Record, 3- Warning Record, 4- Retry Record, 5- New Record.
RETRY_COUNT	NUMBER			Number of retries to process failed records.
ERROR_CODE	VARCHAR2	150		Error code for functional validation errors in the record
ERROR_TEXT	VARCHAR2	2000		This will describe the reason for the error if any.
SR_INSTANCE_CODE	VARCHAR2	30		Source Instance code from which data is being populated.
SR_INSTANCE_ID	NUMBER			Identifier of the source system from where the data is collected.
OPERATION_TYPE	VARCHAR2	2		The column indicates the type of operation.
LOAD_REQUEST_ID	NUMBER			It Stores the Request ID of Job that loaded the data.