VIEW: APPS.PER_PERIODS_OF_WORK_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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