[Home] [Help] [Dependency Information]
Object Name: | JTF_CAL_EXCEPTION_ASSIGN |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTF_CAL_EXCEPTION_ASSIGN |
Subobject Name: | |
Status: | VALID |
Takes the PATTERN EXECPTION and allocates it to either the CALENDAR ASSIGNMENT or CALENDAR. to remove from those efforts (as a result of the processing) the exceptions.
EXAMPLE
Repeating patterns may have exceptions (e.g. a Bank Holiday Monday in a normal Monday-Friday working week). These exceptions may be applied either to whole calendars (e.g., the 'Night Shift Calendar'), or to individual users of that calendar (e.g., 'Fred Bloggs' or 'Finance Department'). Exceptions applied to a calendar are inherited by all users of that calendar, whilst exceptions applied to an individual are specific to that individual. The application of a particular exception is recorded in this table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTF_CAL_EXCEPTION_ASSIGN_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CAL_EXCEPTION_ASSIGN_ID |
JTF_CAL_EXCEPTION_ASSIGN_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CALENDAR_ID
EXCEPTION_ID |
JTF_CAL_EXCEPTION_ASSIGN_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EXCEPTION_REASON |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAL_EXCEPTION_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. | |
EXCEPTION_REASON | VARCHAR2 | (400) | A description of why the execption is to be applied. Foreign Key to FND_LOOKUP_VALUES. | |
CALENDAR_ID | NUMBER | Yes | Foreign key to JTF_CALENDARS_B. | |
EXCEPTION_ID | NUMBER | Yes | Foreign Key to JTF_CAL_EXCEPTIONS_B. | |
START_DATE_ACTIVE | DATE | Date this Exception is valid from, in the Calendar | ||
END_DATE_ACTIVE | DATE | Date this Exception is valid upto, in the Calendar | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | 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 | |
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 | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
SECURITY_GROUP_ID | NUMBER | Column used for Applications Hosting purposes |
Cut, paste (and edit) the following text to query this object:
SELECT CAL_EXCEPTION_ASSIGN_ID
, EXCEPTION_REASON
, CALENDAR_ID
, EXCEPTION_ID
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, SECURITY_GROUP_ID
FROM JTF.JTF_CAL_EXCEPTION_ASSIGN;
JTF.JTF_CAL_EXCEPTION_ASSIGN does not reference any database object
JTF.JTF_CAL_EXCEPTION_ASSIGN is referenced by following:
|
|
|