VIEW: HR.PER_PERIODS_OF_SERVICE#

Source

View Text - Preformatted

select PERIOD_OF_SERVICE_ID PERIOD_OF_SERVICE_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, TERMINATION_ACCEPTED_PERSON_ID TERMINATION_ACCEPTED_PERSON_ID, PERSON_ID PERSON_ID, DATE_START DATE_START, ACCEPTED_TERMINATION_DATE ACCEPTED_TERMINATION_DATE, ACTUAL_TERMINATION_DATE ACTUAL_TERMINATION_DATE, FINAL_PROCESS_DATE FINAL_PROCESS_DATE, LAST_STANDARD_PROCESS_DATE LAST_STANDARD_PROCESS_DATE, LEAVING_REASON LEAVING_REASON, NOTIFIED_TERMINATION_DATE NOTIFIED_TERMINATION_DATE, PROJECTED_TERMINATION_DATE PROJECTED_TERMINATION_DATE, ADJUSTED_SVC_DATE ADJUSTED_SVC_DATE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PRIOR_EMPLOYMENT_SSP_PAID_TO PRIOR_EMPLOYMENT_SSP_PAID_TO, PRIOR_EMPLOYMENT_SSP_WEEKS PRIOR_EMPLOYMENT_SSP_WEEKS, PDS_INFORMATION_CATEGORY PDS_INFORMATION_CATEGORY, PDS_INFORMATION1 PDS_INFORMATION1, PDS_INFORMATION2 PDS_INFORMATION2, PDS_INFORMATION3 PDS_INFORMATION3, PDS_INFORMATION4 PDS_INFORMATION4, PDS_INFORMATION5 PDS_INFORMATION5, PDS_INFORMATION6 PDS_INFORMATION6, PDS_INFORMATION7 PDS_INFORMATION7, PDS_INFORMATION8 PDS_INFORMATION8, PDS_INFORMATION9 PDS_INFORMATION9, PDS_INFORMATION10 PDS_INFORMATION10, PDS_INFORMATION11 PDS_INFORMATION11, PDS_INFORMATION12 PDS_INFORMATION12, PDS_INFORMATION13 PDS_INFORMATION13, PDS_INFORMATION14 PDS_INFORMATION14, PDS_INFORMATION15 PDS_INFORMATION15, PDS_INFORMATION16 PDS_INFORMATION16, PDS_INFORMATION17 PDS_INFORMATION17, PDS_INFORMATION18 PDS_INFORMATION18, PDS_INFORMATION19 PDS_INFORMATION19, PDS_INFORMATION20 PDS_INFORMATION20, PDS_INFORMATION21 PDS_INFORMATION21, PDS_INFORMATION22 PDS_INFORMATION22, PDS_INFORMATION23 PDS_INFORMATION23, PDS_INFORMATION24 PDS_INFORMATION24, PDS_INFORMATION25 PDS_INFORMATION25, PDS_INFORMATION26 PDS_INFORMATION26, PDS_INFORMATION27 PDS_INFORMATION27, PDS_INFORMATION28 PDS_INFORMATION28, PDS_INFORMATION29 PDS_INFORMATION29, PDS_INFORMATION30 PDS_INFORMATION30, COMMENTS COMMENTS from "HR"."PER_PERIODS_OF_SERVICE"

View Text - HTML Formatted

SELECT PERIOD_OF_SERVICE_ID PERIOD_OF_SERVICE_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, TERMINATION_ACCEPTED_PERSON_ID TERMINATION_ACCEPTED_PERSON_ID
, PERSON_ID PERSON_ID
, DATE_START DATE_START
, ACCEPTED_TERMINATION_DATE ACCEPTED_TERMINATION_DATE
, ACTUAL_TERMINATION_DATE ACTUAL_TERMINATION_DATE
, FINAL_PROCESS_DATE FINAL_PROCESS_DATE
, LAST_STANDARD_PROCESS_DATE LAST_STANDARD_PROCESS_DATE
, LEAVING_REASON LEAVING_REASON
, NOTIFIED_TERMINATION_DATE NOTIFIED_TERMINATION_DATE
, PROJECTED_TERMINATION_DATE PROJECTED_TERMINATION_DATE
, ADJUSTED_SVC_DATE ADJUSTED_SVC_DATE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PRIOR_EMPLOYMENT_SSP_PAID_TO PRIOR_EMPLOYMENT_SSP_PAID_TO
, PRIOR_EMPLOYMENT_SSP_WEEKS PRIOR_EMPLOYMENT_SSP_WEEKS
, PDS_INFORMATION_CATEGORY PDS_INFORMATION_CATEGORY
, PDS_INFORMATION1 PDS_INFORMATION1
, PDS_INFORMATION2 PDS_INFORMATION2
, PDS_INFORMATION3 PDS_INFORMATION3
, PDS_INFORMATION4 PDS_INFORMATION4
, PDS_INFORMATION5 PDS_INFORMATION5
, PDS_INFORMATION6 PDS_INFORMATION6
, PDS_INFORMATION7 PDS_INFORMATION7
, PDS_INFORMATION8 PDS_INFORMATION8
, PDS_INFORMATION9 PDS_INFORMATION9
, PDS_INFORMATION10 PDS_INFORMATION10
, PDS_INFORMATION11 PDS_INFORMATION11
, PDS_INFORMATION12 PDS_INFORMATION12
, PDS_INFORMATION13 PDS_INFORMATION13
, PDS_INFORMATION14 PDS_INFORMATION14
, PDS_INFORMATION15 PDS_INFORMATION15
, PDS_INFORMATION16 PDS_INFORMATION16
, PDS_INFORMATION17 PDS_INFORMATION17
, PDS_INFORMATION18 PDS_INFORMATION18
, PDS_INFORMATION19 PDS_INFORMATION19
, PDS_INFORMATION20 PDS_INFORMATION20
, PDS_INFORMATION21 PDS_INFORMATION21
, PDS_INFORMATION22 PDS_INFORMATION22
, PDS_INFORMATION23 PDS_INFORMATION23
, PDS_INFORMATION24 PDS_INFORMATION24
, PDS_INFORMATION25 PDS_INFORMATION25
, PDS_INFORMATION26 PDS_INFORMATION26
, PDS_INFORMATION27 PDS_INFORMATION27
, PDS_INFORMATION28 PDS_INFORMATION28
, PDS_INFORMATION29 PDS_INFORMATION29
, PDS_INFORMATION30 PDS_INFORMATION30
, COMMENTS COMMENTS
FROM "HR"."PER_PERIODS_OF_SERVICE"