View: PER_PERIODS_OF_WORK_V

Product:	PER - Human Resources
Description:	Combined view of periods of service and periods of placement
Implementation/DBA Data:	APPS.PER_PERIODS_OF_WORK_V

View Text

SELECT PERIOD_OF_SERVICE_ID
, 'PPS'
, BUSINESS_GROUP_ID
, PERSON_ID
, DATE_START
, ACTUAL_TERMINATION_DATE
, FINAL_PROCESS_DATE
, LAST_STANDARD_PROCESS_DATE
, LEAVING_REASON
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('LEAV_REAS'
, LEAVING_REASON)
, 1
, 80)
, PROJECTED_TERMINATION_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, PDS_INFORMATION_CATEGORY
, PDS_INFORMATION1
, PDS_INFORMATION2
, PDS_INFORMATION3
, PDS_INFORMATION4
, PDS_INFORMATION5
, PDS_INFORMATION6
, PDS_INFORMATION7
, PDS_INFORMATION8
, PDS_INFORMATION9
, PDS_INFORMATION10
, PDS_INFORMATION11
, PDS_INFORMATION12
, PDS_INFORMATION13
, PDS_INFORMATION14
, PDS_INFORMATION15
, PDS_INFORMATION16
, PDS_INFORMATION17
, PDS_INFORMATION18
, PDS_INFORMATION19
, PDS_INFORMATION20
, PDS_INFORMATION21
, PDS_INFORMATION22
, PDS_INFORMATION23
, PDS_INFORMATION24
, PDS_INFORMATION25
, PDS_INFORMATION26
, PDS_INFORMATION27
, PDS_INFORMATION28
, PDS_INFORMATION29
, PDS_INFORMATION30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, HR_GENERAL.DECODE_ORGANIZATION(BUSINESS_GROUP_ID)
FROM PER_PERIODS_OF_SERVICE UNION ALL SELECT PERIOD_OF_PLACEMENT_ID
, 'PPP'
, BUSINESS_GROUP_ID
, PERSON_ID
, DATE_START
, ACTUAL_TERMINATION_DATE
, FINAL_PROCESS_DATE
, LAST_STANDARD_PROCESS_DATE
, TERMINATION_REASON
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('HR_CWK_TERMINATION_REASONS'
, TERMINATION_REASON)
, 1
, 80)
, PROJECTED_TERMINATION_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, INFORMATION_CATEGORY
, INFORMATION1
, INFORMATION2
, INFORMATION3
, INFORMATION4
, INFORMATION5
, INFORMATION6
, INFORMATION7
, INFORMATION8
, INFORMATION9
, INFORMATION10
, INFORMATION11
, INFORMATION12
, INFORMATION13
, INFORMATION14
, INFORMATION15
, INFORMATION16
, INFORMATION17
, INFORMATION18
, INFORMATION19
, INFORMATION20
, INFORMATION21
, INFORMATION22
, INFORMATION23
, INFORMATION24
, INFORMATION25
, INFORMATION26
, INFORMATION27
, INFORMATION28
, INFORMATION29
, INFORMATION30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, HR_GENERAL.DECODE_ORGANIZATION(BUSINESS_GROUP_ID)
FROM PER_PERIODS_OF_PLACEMENT

Columns