[Home] [Help] [Dependency Information]
Object Name: | PQP_GAP_DURATION_SUMMARY |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PQP.PQP_GAP_DURATION_SUMMARY |
Subobject Name: | |
Status: | VALID |
This table is used to store absence details like Absence star date , Absence end date, No. of days in each band level of absence.
This table will be populated with the above data when the person enrolls into the absence with the configuration for log duration summary set to Yes
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PQP_GAP_DURATION_SUMMARY_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ASSIGNMENT_ID
SUMMARY_TYPE DATE_START |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GAP_DURATION_SUMMARY_ID | NUMBER | (15) | Yes | Primary Key |
ASSIGNMENT_ID | NUMBER | (10) | Yes | Holds the assignment id |
GAP_ABSENCE_PLAN_ID | NUMBER | (15) | Yes | GAP absence plan id |
SUMMARY_TYPE | VARCHAR2 | (30) | Yes | Indicates the summary type |
GAP_LEVEL | VARCHAR2 | (30) | Yes | Indicates the GAP level |
DURATION_IN_DAYS | NUMBER | (15) | Yes | Duration in days |
DURATION_IN_HOURS | NUMBER | (15) | Yes | Duration in hours |
DATE_START | DATE | Yes | Start date of the absence duration | |
DATE_END | DATE | Yes | End date of the absence duration | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | Standard WHO column |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO column |
CREATION_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column |
Cut, paste (and edit) the following text to query this object:
SELECT GAP_DURATION_SUMMARY_ID
, ASSIGNMENT_ID
, GAP_ABSENCE_PLAN_ID
, SUMMARY_TYPE
, GAP_LEVEL
, DURATION_IN_DAYS
, DURATION_IN_HOURS
, DATE_START
, DATE_END
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM HR.PQP_GAP_DURATION_SUMMARY;
HR.PQP_GAP_DURATION_SUMMARY does not reference any database object
HR.PQP_GAP_DURATION_SUMMARY is referenced by following:
|
|
|