[Home] [Help] [Dependency Information]
Object Name: | MSC_CALENDAR_SHIFTS |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | MSC.MSC_CALENDAR_SHIFTS |
Subobject Name: | |
Status: | VALID |
MSC_CALENDAR_SHIFTS stores the shift information that you define for a
calendar (CALENDAR_CODE). You define each shift (SHIFT_NUM), its
description (DESCRIPTION), and shift workday pattern (DAYS ON and DAYS
OFF). A calendar can have multiple shifts, each having its own
workday pattern and exception dates. Each shift also has its own shift
times.
This tables stores data collected from source applications.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_CALENDAR_SHIFTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SR_INSTANCE_ID
CALENDAR_CODE SHIFT_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CALENDAR_CODE | VARCHAR2 | (14) | Yes | Workday calendar identifier |
SR_INSTANCE_ID | NUMBER | Yes | Source application instance identifier | |
SHIFT_NUM | NUMBER | Yes | Shift number | |
DAYS_ON | NUMBER | Number of consecutive working days | ||
DAYS_OFF | NUMBER | Number of consecutive non-working days | ||
DESCRIPTION | VARCHAR2 | (240) | Description | |
REFRESH_NUMBER | NUMBER | Refresh number populated by the collection program | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | Yes | Standard Who Column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
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 | ||
SHIFT_NAME | VARCHAR2 | (80) | Shift Name |
Cut, paste (and edit) the following text to query this object:
SELECT CALENDAR_CODE
, SR_INSTANCE_ID
, SHIFT_NUM
, DAYS_ON
, DAYS_OFF
, DESCRIPTION
, REFRESH_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SHIFT_NAME
FROM MSC.MSC_CALENDAR_SHIFTS;
MSC.MSC_CALENDAR_SHIFTS does not reference any database object
MSC.MSC_CALENDAR_SHIFTS is referenced by following:
|
|
|