DBA Data[Home] [Help]

VIEW: HR.PER_NL_ABSENCE_CHANGES#

Source

View Text - Preformatted

select ABSENCE_ATTENDANCE_ID ABSENCE_ATTENDANCE_ID, DATE_CHANGED DATE_CHANGED, UPDATE_TYPE UPDATE_TYPE, REPORTED_INDICATOR REPORTED_INDICATOR, PERSON_ID PERSON_ID, SICKNESS_START_DATE SICKNESS_START_DATE, PERCENTAGE_SICK PERCENTAGE_SICK, RECOVERY_DATE RECOVERY_DATE from "HR"."PER_NL_ABSENCE_CHANGES"
View Text - HTML Formatted

SELECT ABSENCE_ATTENDANCE_ID ABSENCE_ATTENDANCE_ID
, DATE_CHANGED DATE_CHANGED
, UPDATE_TYPE UPDATE_TYPE
, REPORTED_INDICATOR REPORTED_INDICATOR
, PERSON_ID PERSON_ID
, SICKNESS_START_DATE SICKNESS_START_DATE
, PERCENTAGE_SICK PERCENTAGE_SICK
, RECOVERY_DATE RECOVERY_DATE
FROM "HR"."PER_NL_ABSENCE_CHANGES"