[Home] [Help] [Dependency Information]
Object Name: | JTF_CAL_SHIFT_ASSIGN |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTF_CAL_SHIFT_ASSIGN |
Subobject Name: | |
Status: | VALID |
DEFINITION A PATTERN CALENDAR is based on linking PATTERNs or a single repeating PATTERN. By assigning a PATTERN repeating PATTERN to a start date, the PATTERN can be derived as it would be on any given date after the start date. The same PATTERN may be used for many PATTERN CALENDARs.
EXAMPLE
PATTERN a.k.a. shift, (A) which is 8 am to 5 pm Monday to Friday with Saturday and Sunday off, can be linked to a shift (B) that runs from Tuesday through Saturday with Sunday and Monday off. The control of the linking is through the UI.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTF_CAL_SHIFT_ASSIGN_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CAL_SHIFT_ASSIGN_ID |
JTF_CAL_SHIFT_ASSIGN_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CALENDAR_ID
SHIFT_SEQUENCE_NUMBER SHIFT_ID |
JTF_CAL_SHIFT_ASSIGN_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SHIFT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAL_SHIFT_ASSIGN_ID | NUMBER | Yes | Primary Key column. Standard Oracle Applications unique key. A number starting at 10,000 and being incremented by one for each new row in the table. | |
CALENDAR_ID | NUMBER | Yes | Foreign Key to JTF_CALENDARS_B. | |
SHIFT_SEQUENCE_NUMBER | NUMBER | (10) | Yes | The sequence in which this shift should be processed when multiple shifts are attached to the Calendar. |
SHIFT_ID | NUMBER | Yes | Foreign Key to JTF_CAL_SHIFTS_B. | |
SHIFT_START_DATE | DATE | Yes | Date from which this Shift is effective in the Calendar | |
SHIFT_END_DATE | DATE | Yes | Date until which this Shift is effective in the Calendar | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. It is used for database locking control when using Forms /HTML as a user interface. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | 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 | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
SECURITY_GROUP_ID | NUMBER | Column used for Applications Hosting purposes | ||
CSA_RESOURCE_ID | NUMBER | Not Used | ||
CSA_GROUP_ID | NUMBER | Not Used | ||
CSA_TEAM_ID | NUMBER | Not Used |
Cut, paste (and edit) the following text to query this object:
SELECT CAL_SHIFT_ASSIGN_ID
, CALENDAR_ID
, SHIFT_SEQUENCE_NUMBER
, SHIFT_ID
, SHIFT_START_DATE
, SHIFT_END_DATE
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE3
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, SECURITY_GROUP_ID
, CSA_RESOURCE_ID
, CSA_GROUP_ID
, CSA_TEAM_ID
FROM JTF.JTF_CAL_SHIFT_ASSIGN;
JTF.JTF_CAL_SHIFT_ASSIGN does not reference any database object
JTF.JTF_CAL_SHIFT_ASSIGN is referenced by following:
|
|
|