eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PER_NL_ABSENCE_HISTORY_V

Product:	PER - Human Resources
Description:	Dutch Absence History View
Implementation/DBA Data:	APPS.PER_NL_ABSENCE_HISTORY_V

View Text

SELECT PPF1.FULL_NAME
, PPF1.EMPLOYEE_NUMBER
, PPF1.NATIONAL_IDENTIFIER
, PAA.ABSENCE_ATTENDANCE_ID
, PAA.BUSINESS_GROUP_ID
, PAA.ABSENCE_ATTENDANCE_TYPE_ID
, PAA.PERSON_ID
, PAAT.NAME
, HRL.MEANING
, PAAR.NAME
, PAA.OCCURRENCE
, PAA.DATE_NOTIFICATION
, PAA.DATE_PROJECTED_START
, PAA.TIME_PROJECTED_START
, PAA.DATE_PROJECTED_END
, PAA.TIME_PROJECTED_END
, PAA.DATE_START
, PAA.TIME_START
, PAA.DATE_END
, PAA.TIME_END
, PAA.ABSENCE_DAYS
, PAA.ABSENCE_HOURS
, PAA.ABS_INFORMATION1
, PPF2.FULL_NAME
, PPF2.EMPLOYEE_NUMBER
, PPF3.FULL_NAME
, PPF3.EMPLOYEE_NUMBER
, PAA.LAST_UPDATE_DATE
, PAA.LAST_UPDATED_BY
, PAA.LAST_UPDATE_LOGIN
, PAA.CREATED_BY
, PAA.CREATION_DATE
, PAA.ATTRIBUTE1
, PAA.ATTRIBUTE2
, PAA.ATTRIBUTE3
, PAA.ATTRIBUTE4
, PAA.ATTRIBUTE5
, PAA.ATTRIBUTE6
, PAA.ATTRIBUTE7
, PAA.ATTRIBUTE8
, PAA.ATTRIBUTE9
, PAA.ATTRIBUTE10
, PAA.ATTRIBUTE11
, PAA.ATTRIBUTE12
, PAA.ATTRIBUTE13
, PAA.ATTRIBUTE14
, PAA.ATTRIBUTE15
, PAA.ATTRIBUTE16
, PAA.ATTRIBUTE17
, PAA.ATTRIBUTE18
, PAA.ATTRIBUTE19
, PAA.ATTRIBUTE20
FROM PER_ALL_PEOPLE_F PPF1
, PER_ALL_PEOPLE_F PPF2
, PER_ALL_PEOPLE_F PPF3
, PER_ABSENCE_ATTENDANCES PAA
, PER_ABSENCE_ATTENDANCE_TYPES PAAT
, PER_ABS_ATTENDANCE_REASONS PAAR
, HR_LOOKUPS HRL
WHERE PPF1.PERSON_ID =PAA.PERSON_ID
AND PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAAT.ABSENCE_ATTENDANCE_TYPE_ID
AND PAA.ABS_ATTENDANCE_REASON_ID = PAAR.ABS_ATTENDANCE_REASON_ID(+)
AND PAA.AUTHORISING_PERSON_ID=PPF2.PERSON_ID(+)
AND PAA.REPLACEMENT_PERSON_ID=PPF3.PERSON_ID(+)
AND HRL.LOOKUP_TYPE = 'ABSENCE_CATEGORY'
AND PAAT.ABSENCE_CATEGORY=HRL.LOOKUP_CODE
AND PPF1.EFFECTIVE_END_DATE BETWEEN NVL(PPF2.EFFECTIVE_START_DATE
, PPF1.EFFECTIVE_END_DATE)
AND NVL(PPF2.EFFECTIVE_END_DATE
, PPF1.EFFECTIVE_END_DATE)
AND PPF1.EFFECTIVE_END_DATE BETWEEN NVL(PPF3.EFFECTIVE_START_DATE
, PPF1.EFFECTIVE_END_DATE)
AND NVL(PPF3.EFFECTIVE_END_DATE
, PPF1.EFFECTIVE_END_DATE)
AND NVL(PAA.DATE_START
, PAA.DATE_PROJECTED_START) BETWEEN PPF1.EFFECTIVE_START_DATE
AND PPF1.EFFECTIVE_END_DATE

Columns

Name
EMPLOYEE_NAME
EMPLOYEE_NUMBER
EMPLOYEE_SOFI_NUMBER
ABSENCE_ATTENDANCE_ID
BUSINESS_GROUP_ID
ABSENCE_ATTENDANCE_TYPE_ID
PERSON_ID
ABSENCE_TYPE
ABSENCE_CATEGORY
ABSENCE_REASON
OCCURRENCE
NOTIFIED_DATE
PROJECTED_START_DATE
PROJECTED_START_TIME
PROJECTED_END_DATE
PROJECTED_END_TIME
ACTUAL_START_DATE
ACTUAL_START_TIME
ACTUAL_END_DATE
ACTUAL_END_TIME
DURATION_DAYS
DURATION_HOURS
PERCENTAGE_SICK
AUTHORISING_PERSON_NAME
AUTHORISING_PERSON_NUMBER
REPLACING_PERSON_NAME
REPLACING_PERSON_NUMBER
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20