VIEW: HR.PQP_SERVICE_HISTORY_PERIODS#

Source

View Text - Preformatted

select SERVICE_HISTORY_PERIOD_ID SERVICE_HISTORY_PERIOD_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ASSIGNMENT_ID ASSIGNMENT_ID, START_DATE START_DATE, END_DATE END_DATE, EMPLOYER_NAME EMPLOYER_NAME, EMPLOYER_ADDRESS EMPLOYER_ADDRESS, EMPLOYER_TYPE EMPLOYER_TYPE, EMPLOYER_SUBTYPE EMPLOYER_SUBTYPE, PERIOD_YEARS PERIOD_YEARS, PERIOD_DAYS PERIOD_DAYS, DESCRIPTION DESCRIPTION, CONTINUOUS_SERVICE CONTINUOUS_SERVICE, ALL_ASSIGNMENTS ALL_ASSIGNMENTS, 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, SHP_ATTRIBUTE_CATEGORY SHP_ATTRIBUTE_CATEGORY, SHP_ATTRIBUTE1 SHP_ATTRIBUTE1, SHP_ATTRIBUTE2 SHP_ATTRIBUTE2, SHP_ATTRIBUTE3 SHP_ATTRIBUTE3, SHP_ATTRIBUTE4 SHP_ATTRIBUTE4, SHP_ATTRIBUTE5 SHP_ATTRIBUTE5, SHP_ATTRIBUTE6 SHP_ATTRIBUTE6, SHP_ATTRIBUTE7 SHP_ATTRIBUTE7, SHP_ATTRIBUTE8 SHP_ATTRIBUTE8, SHP_ATTRIBUTE9 SHP_ATTRIBUTE9, SHP_ATTRIBUTE10 SHP_ATTRIBUTE10, SHP_ATTRIBUTE11 SHP_ATTRIBUTE11, SHP_ATTRIBUTE12 SHP_ATTRIBUTE12, SHP_ATTRIBUTE13 SHP_ATTRIBUTE13, SHP_ATTRIBUTE14 SHP_ATTRIBUTE14, SHP_ATTRIBUTE15 SHP_ATTRIBUTE15, SHP_ATTRIBUTE16 SHP_ATTRIBUTE16, SHP_ATTRIBUTE17 SHP_ATTRIBUTE17, SHP_ATTRIBUTE18 SHP_ATTRIBUTE18, SHP_ATTRIBUTE19 SHP_ATTRIBUTE19, SHP_ATTRIBUTE20 SHP_ATTRIBUTE20, SHP_INFORMATION_CATEGORY SHP_INFORMATION_CATEGORY, SHP_INFORMATION1 SHP_INFORMATION1, SHP_INFORMATION2 SHP_INFORMATION2, SHP_INFORMATION3 SHP_INFORMATION3, SHP_INFORMATION4 SHP_INFORMATION4, SHP_INFORMATION5 SHP_INFORMATION5, SHP_INFORMATION6 SHP_INFORMATION6, SHP_INFORMATION7 SHP_INFORMATION7, SHP_INFORMATION8 SHP_INFORMATION8, SHP_INFORMATION9 SHP_INFORMATION9, SHP_INFORMATION10 SHP_INFORMATION10, SHP_INFORMATION11 SHP_INFORMATION11, SHP_INFORMATION12 SHP_INFORMATION12, SHP_INFORMATION13 SHP_INFORMATION13, SHP_INFORMATION14 SHP_INFORMATION14, SHP_INFORMATION15 SHP_INFORMATION15, SHP_INFORMATION16 SHP_INFORMATION16, SHP_INFORMATION17 SHP_INFORMATION17, SHP_INFORMATION18 SHP_INFORMATION18, SHP_INFORMATION19 SHP_INFORMATION19, SHP_INFORMATION20 SHP_INFORMATION20 from "HR"."PQP_SERVICE_HISTORY_PERIODS"

View Text - HTML Formatted

SELECT SERVICE_HISTORY_PERIOD_ID SERVICE_HISTORY_PERIOD_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, START_DATE START_DATE
, END_DATE END_DATE
, EMPLOYER_NAME EMPLOYER_NAME
, EMPLOYER_ADDRESS EMPLOYER_ADDRESS
, EMPLOYER_TYPE EMPLOYER_TYPE
, EMPLOYER_SUBTYPE EMPLOYER_SUBTYPE
, PERIOD_YEARS PERIOD_YEARS
, PERIOD_DAYS PERIOD_DAYS
, DESCRIPTION DESCRIPTION
, CONTINUOUS_SERVICE CONTINUOUS_SERVICE
, ALL_ASSIGNMENTS ALL_ASSIGNMENTS
, 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
, SHP_ATTRIBUTE_CATEGORY SHP_ATTRIBUTE_CATEGORY
, SHP_ATTRIBUTE1 SHP_ATTRIBUTE1
, SHP_ATTRIBUTE2 SHP_ATTRIBUTE2
, SHP_ATTRIBUTE3 SHP_ATTRIBUTE3
, SHP_ATTRIBUTE4 SHP_ATTRIBUTE4
, SHP_ATTRIBUTE5 SHP_ATTRIBUTE5
, SHP_ATTRIBUTE6 SHP_ATTRIBUTE6
, SHP_ATTRIBUTE7 SHP_ATTRIBUTE7
, SHP_ATTRIBUTE8 SHP_ATTRIBUTE8
, SHP_ATTRIBUTE9 SHP_ATTRIBUTE9
, SHP_ATTRIBUTE10 SHP_ATTRIBUTE10
, SHP_ATTRIBUTE11 SHP_ATTRIBUTE11
, SHP_ATTRIBUTE12 SHP_ATTRIBUTE12
, SHP_ATTRIBUTE13 SHP_ATTRIBUTE13
, SHP_ATTRIBUTE14 SHP_ATTRIBUTE14
, SHP_ATTRIBUTE15 SHP_ATTRIBUTE15
, SHP_ATTRIBUTE16 SHP_ATTRIBUTE16
, SHP_ATTRIBUTE17 SHP_ATTRIBUTE17
, SHP_ATTRIBUTE18 SHP_ATTRIBUTE18
, SHP_ATTRIBUTE19 SHP_ATTRIBUTE19
, SHP_ATTRIBUTE20 SHP_ATTRIBUTE20
, SHP_INFORMATION_CATEGORY SHP_INFORMATION_CATEGORY
, SHP_INFORMATION1 SHP_INFORMATION1
, SHP_INFORMATION2 SHP_INFORMATION2
, SHP_INFORMATION3 SHP_INFORMATION3
, SHP_INFORMATION4 SHP_INFORMATION4
, SHP_INFORMATION5 SHP_INFORMATION5
, SHP_INFORMATION6 SHP_INFORMATION6
, SHP_INFORMATION7 SHP_INFORMATION7
, SHP_INFORMATION8 SHP_INFORMATION8
, SHP_INFORMATION9 SHP_INFORMATION9
, SHP_INFORMATION10 SHP_INFORMATION10
, SHP_INFORMATION11 SHP_INFORMATION11
, SHP_INFORMATION12 SHP_INFORMATION12
, SHP_INFORMATION13 SHP_INFORMATION13
, SHP_INFORMATION14 SHP_INFORMATION14
, SHP_INFORMATION15 SHP_INFORMATION15
, SHP_INFORMATION16 SHP_INFORMATION16
, SHP_INFORMATION17 SHP_INFORMATION17
, SHP_INFORMATION18 SHP_INFORMATION18
, SHP_INFORMATION19 SHP_INFORMATION19
, SHP_INFORMATION20 SHP_INFORMATION20
FROM "HR"."PQP_SERVICE_HISTORY_PERIODS"