View: HR_H2PI_PERIODS_OF_SERVICE_V

Product:	PER - Human Resources
Description:	Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for periods of service
Implementation/DBA Data:	APPS.HR_H2PI_PERIODS_OF_SERVICE_V

View Text

SELECT PPS.LAST_UPDATE_DATE
, PPS.BUSINESS_GROUP_ID
, PPS.PERIOD_OF_SERVICE_ID
, PPS.PERSON_ID
, PPS.DATE_START
, PPS.ACTUAL_TERMINATION_DATE
, PPS.FINAL_PROCESS_DATE
, PPS.LAST_STANDARD_PROCESS_DATE
, PPS.LEAVING_REASON
, PPS.ATTRIBUTE_CATEGORY
, PPS.ATTRIBUTE1
, PPS.ATTRIBUTE2
, PPS.ATTRIBUTE3
, PPS.ATTRIBUTE4
, PPS.ATTRIBUTE5
, PPS.ATTRIBUTE6
, PPS.ATTRIBUTE7
, PPS.ATTRIBUTE10
, PPS.ATTRIBUTE11
, PPS.ATTRIBUTE12
, PPS.ATTRIBUTE13
, PPS.ATTRIBUTE14
, PPS.ATTRIBUTE15
, PPS.ATTRIBUTE16
, PPS.ATTRIBUTE17
, PPS.ATTRIBUTE18
, PPS.ATTRIBUTE19
, PPS.ATTRIBUTE20
FROM PER_PERIODS_OF_SERVICE PPS
WHERE EXISTS ( SELECT PP.PERSON_ID
FROM HR_H2PI_EMPLOYEES_V PP
WHERE PP.PERSON_ID = PPS.PERSON_ID)

Columns