[Home] [Help]
[Dependency Information]
Object Name: | MSC_ST_WORKDAY_PATTERNS |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
This is an interface table for staging days on/days off patterns for your calendar and your shifts from Legacy Instances. The 'Pre-Processor' would then validate the data in this table and insert into MSC_WORKDAY_PATTERNS.
SEQ_NUM is the order of your days on/days off to create the repeating workday pattern. For example, if you define a calendar as follows:
=
SeqNum DaysOn DaysOff
1 5 2
2 4 3
=
Your repeating workday pattern will be over 14 days (5+2+4+3) as follows: = 5 days on 2 days off 4 days on 3 days off
=
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CALENDAR_CODE | VARCHAR2 | (14) | Workday calendar identifier | |
DESCRIPTION | VARCHAR2 | (250) | Description | |
SR_INSTANCE_CODE | VARCHAR2 | (3) | Source Instance code | |
SR_INSTANCE_ID | NUMBER | Source Instance id | ||
DELETED_FLAG | NUMBER | Deleted Flag | ||
SHIFT_NAME | VARCHAR2 | (80) | To identify a shift | |
SHIFT_NUM | NUMBER | Shift Number | ||
SEQ_NUM | NUMBER | Sequence Number | ||
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 | ||
DAYS_ON | NUMBER | Number of consecutive working days | ||
DAYS_OFF | NUMBER | Number of consecutive non-working days | ||
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 | ||
MESSAGE_ID | NUMBER | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML | ||
PROCESS_FLAG | NUMBER | Processing Flag indicating the status of records during pre-processing.1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed | ||
DATA_SOURCE_TYPE | VARCHAR2 | (15) | Source type indicating the source of the data | |
ST_TRANSACTION_ID | NUMBER | Transaction ID generated during pre-processing to uniquely identify a record in the staging table | ||
ERROR_TEXT | VARCHAR2 | (2000) | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error | |
COMPANY_NAME | VARCHAR2 | (255) | Company Name | |
COMPANY_ID | NUMBER | Company Id |
Cut, paste (and edit) the following text to query this object:
SELECT CALENDAR_CODE
, DESCRIPTION
, SR_INSTANCE_CODE
, SR_INSTANCE_ID
, DELETED_FLAG
, SHIFT_NAME
, SHIFT_NUM
, SEQ_NUM
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, DAYS_ON
, DAYS_OFF
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REFRESH_ID
, MESSAGE_ID
, PROCESS_FLAG
, DATA_SOURCE_TYPE
, ST_TRANSACTION_ID
, ERROR_TEXT
, COMPANY_NAME
, COMPANY_ID
FROM MSC.MSC_ST_WORKDAY_PATTERNS;
MSC.MSC_ST_WORKDAY_PATTERNS does not reference any database object
MSC.MSC_ST_WORKDAY_PATTERNS is referenced by following:
|
|
|