[Home] [Help] [Dependency Information]
Object Name: | PER_NL_ABSENCE_CHANGES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PER.PER_NL_ABSENCE_CHANGES |
Subobject Name: | |
Status: | VALID |
Records all the Changes done to Absence Record for Absence Category of Sickness
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PER_NL_ABSENCE_CHANGES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PERSON_ID
DATE_CHANGED SICKNESS_START_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ABSENCE_ATTENDANCE_ID | NUMBER | (10) | Yes | Absence Attendance ID |
DATE_CHANGED | DATE | Yes | Date Changed | |
UPDATE_TYPE | VARCHAR2 | (20) | Yes | Update Type |
REPORTED_INDICATOR | VARCHAR2 | (1) | Yes | Reported Indicator |
PERSON_ID | NUMBER | (10) | Yes | Person ID |
SICKNESS_START_DATE | DATE | Sickness Start Date | ||
PERCENTAGE_SICK | NUMBER | (5) | Percentage Sick | |
RECOVERY_DATE | DATE | Recovery Date |
Cut, paste (and edit) the following text to query this object:
SELECT ABSENCE_ATTENDANCE_ID
, DATE_CHANGED
, UPDATE_TYPE
, REPORTED_INDICATOR
, PERSON_ID
, SICKNESS_START_DATE
, PERCENTAGE_SICK
, RECOVERY_DATE
FROM HR.PER_NL_ABSENCE_CHANGES;
HR.PER_NL_ABSENCE_CHANGES does not reference any database object
HR.PER_NL_ABSENCE_CHANGES is referenced by following:
|
|
|