[Home] [Help] [Dependency Information]
Object Name: | PQP_GAP_DAILY_ABSENCES# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GAP_DAILY_ABSENCE_ID | NUMBER | (15) | Yes | |
GAP_ABSENCE_PLAN_ID | NUMBER | (15) | Yes | |
ABSENCE_DATE | DATE | Yes | ||
WORK_PATTERN_DAY_TYPE | VARCHAR2 | (30) | Yes | |
LEVEL_OF_ENTITLEMENT | VARCHAR2 | (30) | Yes | |
LEVEL_OF_PAY | VARCHAR2 | (30) | Yes | |
DURATION | NUMBER | (11) | Yes | |
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
OBJECT_VERSION_NUMBER | NUMBER | (15) | ||
DURATION_IN_HOURS | NUMBER | (11) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
WORKING_DAYS_PER_WEEK | NUMBER | (6) | ||
FTE | NUMBER | (25) |
Cut, paste (and edit) the following text to query this object:
SELECT GAP_DAILY_ABSENCE_ID
, GAP_ABSENCE_PLAN_ID
, ABSENCE_DATE
, WORK_PATTERN_DAY_TYPE
, LEVEL_OF_ENTITLEMENT
, LEVEL_OF_PAY
, DURATION
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, DURATION_IN_HOURS
, LAST_UPDATE_LOGIN
, WORKING_DAYS_PER_WEEK
, FTE
FROM HR.PQP_GAP_DAILY_ABSENCES#;
|
|
|