[Home] [Help] [Dependency Information]
Object Name: | PER_CAL_MAP_CACHE |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PER.PER_CAL_MAP_CACHE |
Subobject Name: | |
Status: | VALID |
This table holds the mapping between a person assignment and the applicable calendar entries based on geographic and organizational coverage. The data held in this table is used by the set up administration user interface and is not persistent.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (15) | Yes | Person Identifier |
ASSIGNMENT_ID | NUMBER | (15) | Yes | Assignment Identifier |
EVENT_NAME | VARCHAR2 | (80) | Yes | Calendar Event Name |
EVENT_TYPE | VARCHAR2 | (30) | Yes | Calendar Event Type |
START_DATE | DATE | Calendar Event Start Date | ||
END_DATE | DATE | Calendar Event End Date | ||
START_HOUR | VARCHAR2 | (30) | Calendar Event Start Hour | |
END_HOUR | VARCHAR2 | (30) | Calendar Event End Hour | |
START_MINUTE | VARCHAR2 | (30) | Calendar Event Start Minute | |
END_MINUTE | VARCHAR2 | (30) | Calendar Event End Minute | |
LAST_UPDATE_DATE | DATE | Standard WHO Column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
CREATED_BY | NUMBER | (15) | Standard WHO Column | |
CREATION_DATE | DATE | Standard WHO Column |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, ASSIGNMENT_ID
, EVENT_NAME
, EVENT_TYPE
, START_DATE
, END_DATE
, START_HOUR
, END_HOUR
, START_MINUTE
, END_MINUTE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HR.PER_CAL_MAP_CACHE;
HR.PER_CAL_MAP_CACHE does not reference any database object
HR.PER_CAL_MAP_CACHE is referenced by following:
|
|
|