VIEW: HR.PER_ABSENCE_ATTENDANCES#

Source

View Text - Preformatted

select ABSENCE_ATTENDANCE_ID ABSENCE_ATTENDANCE_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ABSENCE_ATTENDANCE_TYPE_ID ABSENCE_ATTENDANCE_TYPE_ID, ABS_ATTENDANCE_REASON_ID ABS_ATTENDANCE_REASON_ID, PERSON_ID PERSON_ID, AUTHORISING_PERSON_ID AUTHORISING_PERSON_ID, REPLACEMENT_PERSON_ID REPLACEMENT_PERSON_ID, PERIOD_OF_INCAPACITY_ID PERIOD_OF_INCAPACITY_ID, ABSENCE_DAYS ABSENCE_DAYS, ABSENCE_HOURS ABSENCE_HOURS, DATE_END DATE_END, DATE_NOTIFICATION DATE_NOTIFICATION, DATE_PROJECTED_END DATE_PROJECTED_END, DATE_PROJECTED_START DATE_PROJECTED_START, DATE_START DATE_START, OCCURRENCE OCCURRENCE, SSP1_ISSUED SSP1_ISSUED, TIME_END TIME_END, TIME_PROJECTED_END TIME_PROJECTED_END, TIME_PROJECTED_START TIME_PROJECTED_START, TIME_START TIME_START, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, MATERNITY_ID MATERNITY_ID, SICKNESS_START_DATE SICKNESS_START_DATE, SICKNESS_END_DATE SICKNESS_END_DATE, PREGNANCY_RELATED_ILLNESS PREGNANCY_RELATED_ILLNESS, REASON_FOR_NOTIFICATION_DELAY REASON_FOR_NOTIFICATION_DELAY, ACCEPT_LATE_NOTIFICATION_FLAG ACCEPT_LATE_NOTIFICATION_FLAG, LINKED_ABSENCE_ID LINKED_ABSENCE_ID, BATCH_ID BATCH_ID, ABS_INFORMATION_CATEGORY ABS_INFORMATION_CATEGORY, ABS_INFORMATION1 ABS_INFORMATION1, ABS_INFORMATION2 ABS_INFORMATION2, ABS_INFORMATION3 ABS_INFORMATION3, ABS_INFORMATION4 ABS_INFORMATION4, ABS_INFORMATION5 ABS_INFORMATION5, ABS_INFORMATION6 ABS_INFORMATION6, ABS_INFORMATION7 ABS_INFORMATION7, ABS_INFORMATION8 ABS_INFORMATION8, ABS_INFORMATION9 ABS_INFORMATION9, ABS_INFORMATION10 ABS_INFORMATION10, ABS_INFORMATION11 ABS_INFORMATION11, ABS_INFORMATION12 ABS_INFORMATION12, ABS_INFORMATION13 ABS_INFORMATION13, ABS_INFORMATION14 ABS_INFORMATION14, ABS_INFORMATION15 ABS_INFORMATION15, ABS_INFORMATION16 ABS_INFORMATION16, ABS_INFORMATION17 ABS_INFORMATION17, ABS_INFORMATION18 ABS_INFORMATION18, ABS_INFORMATION19 ABS_INFORMATION19, ABS_INFORMATION20 ABS_INFORMATION20, ABS_INFORMATION21 ABS_INFORMATION21, ABS_INFORMATION22 ABS_INFORMATION22, ABS_INFORMATION23 ABS_INFORMATION23, ABS_INFORMATION24 ABS_INFORMATION24, ABS_INFORMATION25 ABS_INFORMATION25, ABS_INFORMATION26 ABS_INFORMATION26, ABS_INFORMATION27 ABS_INFORMATION27, ABS_INFORMATION28 ABS_INFORMATION28, ABS_INFORMATION29 ABS_INFORMATION29, ABS_INFORMATION30 ABS_INFORMATION30, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, COMMENTS COMMENTS, ABSENCE_CASE_ID ABSENCE_CASE_ID, APPROVAL_STATUS APPROVAL_STATUS, CONFIRMED_UNTIL CONFIRMED_UNTIL, SOURCE SOURCE, ADVANCE_PAY ADVANCE_PAY from "HR"."PER_ABSENCE_ATTENDANCES"

View Text - HTML Formatted

SELECT ABSENCE_ATTENDANCE_ID ABSENCE_ATTENDANCE_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ABSENCE_ATTENDANCE_TYPE_ID ABSENCE_ATTENDANCE_TYPE_ID
, ABS_ATTENDANCE_REASON_ID ABS_ATTENDANCE_REASON_ID
, PERSON_ID PERSON_ID
, AUTHORISING_PERSON_ID AUTHORISING_PERSON_ID
, REPLACEMENT_PERSON_ID REPLACEMENT_PERSON_ID
, PERIOD_OF_INCAPACITY_ID PERIOD_OF_INCAPACITY_ID
, ABSENCE_DAYS ABSENCE_DAYS
, ABSENCE_HOURS ABSENCE_HOURS
, DATE_END DATE_END
, DATE_NOTIFICATION DATE_NOTIFICATION
, DATE_PROJECTED_END DATE_PROJECTED_END
, DATE_PROJECTED_START DATE_PROJECTED_START
, DATE_START DATE_START
, OCCURRENCE OCCURRENCE
, SSP1_ISSUED SSP1_ISSUED
, TIME_END TIME_END
, TIME_PROJECTED_END TIME_PROJECTED_END
, TIME_PROJECTED_START TIME_PROJECTED_START
, TIME_START TIME_START
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, MATERNITY_ID MATERNITY_ID
, SICKNESS_START_DATE SICKNESS_START_DATE
, SICKNESS_END_DATE SICKNESS_END_DATE
, PREGNANCY_RELATED_ILLNESS PREGNANCY_RELATED_ILLNESS
, REASON_FOR_NOTIFICATION_DELAY REASON_FOR_NOTIFICATION_DELAY
, ACCEPT_LATE_NOTIFICATION_FLAG ACCEPT_LATE_NOTIFICATION_FLAG
, LINKED_ABSENCE_ID LINKED_ABSENCE_ID
, BATCH_ID BATCH_ID
, ABS_INFORMATION_CATEGORY ABS_INFORMATION_CATEGORY
, ABS_INFORMATION1 ABS_INFORMATION1
, ABS_INFORMATION2 ABS_INFORMATION2
, ABS_INFORMATION3 ABS_INFORMATION3
, ABS_INFORMATION4 ABS_INFORMATION4
, ABS_INFORMATION5 ABS_INFORMATION5
, ABS_INFORMATION6 ABS_INFORMATION6
, ABS_INFORMATION7 ABS_INFORMATION7
, ABS_INFORMATION8 ABS_INFORMATION8
, ABS_INFORMATION9 ABS_INFORMATION9
, ABS_INFORMATION10 ABS_INFORMATION10
, ABS_INFORMATION11 ABS_INFORMATION11
, ABS_INFORMATION12 ABS_INFORMATION12
, ABS_INFORMATION13 ABS_INFORMATION13
, ABS_INFORMATION14 ABS_INFORMATION14
, ABS_INFORMATION15 ABS_INFORMATION15
, ABS_INFORMATION16 ABS_INFORMATION16
, ABS_INFORMATION17 ABS_INFORMATION17
, ABS_INFORMATION18 ABS_INFORMATION18
, ABS_INFORMATION19 ABS_INFORMATION19
, ABS_INFORMATION20 ABS_INFORMATION20
, ABS_INFORMATION21 ABS_INFORMATION21
, ABS_INFORMATION22 ABS_INFORMATION22
, ABS_INFORMATION23 ABS_INFORMATION23
, ABS_INFORMATION24 ABS_INFORMATION24
, ABS_INFORMATION25 ABS_INFORMATION25
, ABS_INFORMATION26 ABS_INFORMATION26
, ABS_INFORMATION27 ABS_INFORMATION27
, ABS_INFORMATION28 ABS_INFORMATION28
, ABS_INFORMATION29 ABS_INFORMATION29
, ABS_INFORMATION30 ABS_INFORMATION30
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, COMMENTS COMMENTS
, ABSENCE_CASE_ID ABSENCE_CASE_ID
, APPROVAL_STATUS APPROVAL_STATUS
, CONFIRMED_UNTIL CONFIRMED_UNTIL
, SOURCE SOURCE
, ADVANCE_PAY ADVANCE_PAY
FROM "HR"."PER_ABSENCE_ATTENDANCES"