FND Design Data [Home] [Help]

View: PER_ABSENCE_ATTENDANCES_V3

Product: PER - Human Resources
Description: History of periods of absence for employees.
Implementation/DBA Data: ViewAPPS.PER_ABSENCE_ATTENDANCES_V3
View Text

SELECT ABA.ABSENCE_ATTENDANCE_ID
, ABA.BUSINESS_GROUP_ID
, ABA.ABSENCE_ATTENDANCE_TYPE_ID
, ABA.ABS_ATTENDANCE_REASON_ID
, ABA.PERSON_ID
, ABA.AUTHORISING_PERSON_ID
, ABA.REPLACEMENT_PERSON_ID
, ABA.PERIOD_OF_INCAPACITY_ID
, ABA.ABSENCE_DAYS
, ABA.ABSENCE_HOURS
, ABA.COMMENTS
, ABA.DATE_END
, ABA.DATE_NOTIFICATION
, ABA.DATE_PROJECTED_END
, ABA.DATE_PROJECTED_START
, ABA.DATE_START
, ABA.OCCURRENCE
, ABA.SSP1_ISSUED
, ABA.TIME_END
, ABA.TIME_PROJECTED_END
, ABA.TIME_PROJECTED_START
, ABA.TIME_START
, ABA.ATTRIBUTE_CATEGORY
, ABA.ATTRIBUTE1
, ABA.ATTRIBUTE2
, ABA.ATTRIBUTE3
, ABA.ATTRIBUTE4
, ABA.ATTRIBUTE5
, ABA.ATTRIBUTE6
, ABA.ATTRIBUTE7
, ABA.ATTRIBUTE8
, ABA.ATTRIBUTE9
, ABA.ATTRIBUTE10
, ABA.ATTRIBUTE11
, ABA.ATTRIBUTE12
, ABA.ATTRIBUTE13
, ABA.ATTRIBUTE14
, ABA.ATTRIBUTE15
, ABA.ATTRIBUTE16
, ABA.ATTRIBUTE17
, ABA.ATTRIBUTE18
, ABA.ATTRIBUTE19
, ABA.ATTRIBUTE20
, ABA.LAST_UPDATE_DATE
, ABA.LAST_UPDATED_BY
, ABA.LAST_UPDATE_LOGIN
, ABA.CREATED_BY
, ABA.CREATION_DATE
, ABT.NAME
, PEP.FULL_NAME
, PEP.EMPLOYEE_NUMBER
, PEP2.FULL_NAME
, PEP2.EMPLOYEE_NUMBER
, REAS.MEANING
, CAT.MEANING
FROM PER_ABSENCE_ATTENDANCES ABA
, PER_ABSENCE_ATTENDANCE_TYPES ABT
, PER_ABS_ATTENDANCE_REASONS ABR
, PER_ALL_PEOPLE_F PEP
, PER_ALL_PEOPLE_F PEP2
, HR_LOOKUPS REAS
, HR_LOOKUPS CAT
WHERE ABA.ABSENCE_ATTENDANCE_TYPE_ID = ABT.ABSENCE_ATTENDANCE_TYPE_ID
AND ABA.AUTHORISING_PERSON_ID = PEP.PERSON_ID (+)
AND ABA.REPLACEMENT_PERSON_ID = PEP2.PERSON_ID (+)
AND ABA.ABS_ATTENDANCE_REASON_ID = ABR.ABS_ATTENDANCE_REASON_ID (+)
AND ABR.NAME = REAS.LOOKUP_CODE (+)
AND REAS.LOOKUP_TYPE (+) = 'ABSENCE_REASON'
AND ABT.ABSENCE_CATEGORY = CAT.LOOKUP_CODE (+)
AND CAT.LOOKUP_TYPE (+) = 'ABSENCE_CATEGORY'
AND NVL(ABA.DATE_NOTIFICATION
, ABA.DATE_START) BETWEEN NVL(PEP.EFFECTIVE_START_DATE
, ABA.DATE_NOTIFICATION)
AND NVL(PEP.EFFECTIVE_END_DATE
, ABA.DATE_NOTIFICATION)
AND NVL(ABA.DATE_NOTIFICATION
, ABA.DATE_START) BETWEEN NVL(PEP2.EFFECTIVE_START_DATE
, ABA.DATE_NOTIFICATION)
AND NVL(PEP2.EFFECTIVE_END_DATE
, ABA.DATE_NOTIFICATION)

Columns

Name
ABSENCE_ATTENDANCE_ID
BUSINESS_GROUP_ID
ABSENCE_ATTENDANCE_TYPE_ID
ABS_ATTENDANCE_REASON_ID
PERSON_ID
AUTHORISING_PERSON_ID
REPLACEMENT_PERSON_ID
PERIOD_OF_INCAPACITY_ID
ABSENCE_DAYS
ABSENCE_HOURS
COMMENTS
DATE_END
DATE_NOTIFICATION
DATE_PROJECTED_END
DATE_PROJECTED_START
DATE_START
OCCURRENCE
SSP1_ISSUED
TIME_END
TIME_PROJECTED_END
TIME_PROJECTED_START
TIME_START
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
ABSENCE_TYPE
AUTHORIZER_NAME
AUTHORIZER_NO
REPLACEMENT_NAME
REPLACEMENT_NO
ABSENCE_REASON
ABSENCE_CATEGORY