VIEW: HR.PER_PREVIOUS_JOBS#

Source

View Text - Preformatted

select PREVIOUS_JOB_ID PREVIOUS_JOB_ID, PREVIOUS_EMPLOYER_ID PREVIOUS_EMPLOYER_ID, START_DATE START_DATE, END_DATE END_DATE, PERIOD_YEARS PERIOD_YEARS, PERIOD_DAYS PERIOD_DAYS, JOB_NAME JOB_NAME, EMPLOYMENT_CATEGORY EMPLOYMENT_CATEGORY, DESCRIPTION DESCRIPTION, PJO_ATTRIBUTE_CATEGORY PJO_ATTRIBUTE_CATEGORY, PJO_ATTRIBUTE1 PJO_ATTRIBUTE1, PJO_ATTRIBUTE2 PJO_ATTRIBUTE2, PJO_ATTRIBUTE3 PJO_ATTRIBUTE3, PJO_ATTRIBUTE4 PJO_ATTRIBUTE4, PJO_ATTRIBUTE5 PJO_ATTRIBUTE5, PJO_ATTRIBUTE6 PJO_ATTRIBUTE6, PJO_ATTRIBUTE7 PJO_ATTRIBUTE7, PJO_ATTRIBUTE8 PJO_ATTRIBUTE8, PJO_ATTRIBUTE9 PJO_ATTRIBUTE9, PJO_ATTRIBUTE10 PJO_ATTRIBUTE10, PJO_ATTRIBUTE11 PJO_ATTRIBUTE11, PJO_ATTRIBUTE12 PJO_ATTRIBUTE12, PJO_ATTRIBUTE13 PJO_ATTRIBUTE13, PJO_ATTRIBUTE14 PJO_ATTRIBUTE14, PJO_ATTRIBUTE15 PJO_ATTRIBUTE15, PJO_ATTRIBUTE16 PJO_ATTRIBUTE16, PJO_ATTRIBUTE17 PJO_ATTRIBUTE17, PJO_ATTRIBUTE18 PJO_ATTRIBUTE18, PJO_ATTRIBUTE19 PJO_ATTRIBUTE19, PJO_ATTRIBUTE20 PJO_ATTRIBUTE20, PJO_ATTRIBUTE21 PJO_ATTRIBUTE21, PJO_ATTRIBUTE22 PJO_ATTRIBUTE22, PJO_ATTRIBUTE23 PJO_ATTRIBUTE23, PJO_ATTRIBUTE24 PJO_ATTRIBUTE24, PJO_ATTRIBUTE25 PJO_ATTRIBUTE25, PJO_ATTRIBUTE26 PJO_ATTRIBUTE26, PJO_ATTRIBUTE27 PJO_ATTRIBUTE27, PJO_ATTRIBUTE28 PJO_ATTRIBUTE28, PJO_ATTRIBUTE29 PJO_ATTRIBUTE29, PJO_ATTRIBUTE30 PJO_ATTRIBUTE30, PJO_INFORMATION_CATEGORY PJO_INFORMATION_CATEGORY, PJO_INFORMATION1 PJO_INFORMATION1, PJO_INFORMATION2 PJO_INFORMATION2, PJO_INFORMATION3 PJO_INFORMATION3, PJO_INFORMATION4 PJO_INFORMATION4, PJO_INFORMATION5 PJO_INFORMATION5, PJO_INFORMATION6 PJO_INFORMATION6, PJO_INFORMATION7 PJO_INFORMATION7, PJO_INFORMATION8 PJO_INFORMATION8, PJO_INFORMATION9 PJO_INFORMATION9, PJO_INFORMATION10 PJO_INFORMATION10, PJO_INFORMATION11 PJO_INFORMATION11, PJO_INFORMATION12 PJO_INFORMATION12, PJO_INFORMATION13 PJO_INFORMATION13, PJO_INFORMATION14 PJO_INFORMATION14, PJO_INFORMATION15 PJO_INFORMATION15, PJO_INFORMATION16 PJO_INFORMATION16, PJO_INFORMATION17 PJO_INFORMATION17, PJO_INFORMATION18 PJO_INFORMATION18, PJO_INFORMATION19 PJO_INFORMATION19, PJO_INFORMATION20 PJO_INFORMATION20, PJO_INFORMATION21 PJO_INFORMATION21, PJO_INFORMATION22 PJO_INFORMATION22, PJO_INFORMATION23 PJO_INFORMATION23, PJO_INFORMATION24 PJO_INFORMATION24, PJO_INFORMATION25 PJO_INFORMATION25, PJO_INFORMATION26 PJO_INFORMATION26, PJO_INFORMATION27 PJO_INFORMATION27, PJO_INFORMATION28 PJO_INFORMATION28, PJO_INFORMATION29 PJO_INFORMATION29, PJO_INFORMATION30 PJO_INFORMATION30, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, 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, ALL_ASSIGNMENTS ALL_ASSIGNMENTS, PERIOD_MONTHS PERIOD_MONTHS from "HR"."PER_PREVIOUS_JOBS"

View Text - HTML Formatted

SELECT PREVIOUS_JOB_ID PREVIOUS_JOB_ID
, PREVIOUS_EMPLOYER_ID PREVIOUS_EMPLOYER_ID
, START_DATE START_DATE
, END_DATE END_DATE
, PERIOD_YEARS PERIOD_YEARS
, PERIOD_DAYS PERIOD_DAYS
, JOB_NAME JOB_NAME
, EMPLOYMENT_CATEGORY EMPLOYMENT_CATEGORY
, DESCRIPTION DESCRIPTION
, PJO_ATTRIBUTE_CATEGORY PJO_ATTRIBUTE_CATEGORY
, PJO_ATTRIBUTE1 PJO_ATTRIBUTE1
, PJO_ATTRIBUTE2 PJO_ATTRIBUTE2
, PJO_ATTRIBUTE3 PJO_ATTRIBUTE3
, PJO_ATTRIBUTE4 PJO_ATTRIBUTE4
, PJO_ATTRIBUTE5 PJO_ATTRIBUTE5
, PJO_ATTRIBUTE6 PJO_ATTRIBUTE6
, PJO_ATTRIBUTE7 PJO_ATTRIBUTE7
, PJO_ATTRIBUTE8 PJO_ATTRIBUTE8
, PJO_ATTRIBUTE9 PJO_ATTRIBUTE9
, PJO_ATTRIBUTE10 PJO_ATTRIBUTE10
, PJO_ATTRIBUTE11 PJO_ATTRIBUTE11
, PJO_ATTRIBUTE12 PJO_ATTRIBUTE12
, PJO_ATTRIBUTE13 PJO_ATTRIBUTE13
, PJO_ATTRIBUTE14 PJO_ATTRIBUTE14
, PJO_ATTRIBUTE15 PJO_ATTRIBUTE15
, PJO_ATTRIBUTE16 PJO_ATTRIBUTE16
, PJO_ATTRIBUTE17 PJO_ATTRIBUTE17
, PJO_ATTRIBUTE18 PJO_ATTRIBUTE18
, PJO_ATTRIBUTE19 PJO_ATTRIBUTE19
, PJO_ATTRIBUTE20 PJO_ATTRIBUTE20
, PJO_ATTRIBUTE21 PJO_ATTRIBUTE21
, PJO_ATTRIBUTE22 PJO_ATTRIBUTE22
, PJO_ATTRIBUTE23 PJO_ATTRIBUTE23
, PJO_ATTRIBUTE24 PJO_ATTRIBUTE24
, PJO_ATTRIBUTE25 PJO_ATTRIBUTE25
, PJO_ATTRIBUTE26 PJO_ATTRIBUTE26
, PJO_ATTRIBUTE27 PJO_ATTRIBUTE27
, PJO_ATTRIBUTE28 PJO_ATTRIBUTE28
, PJO_ATTRIBUTE29 PJO_ATTRIBUTE29
, PJO_ATTRIBUTE30 PJO_ATTRIBUTE30
, PJO_INFORMATION_CATEGORY PJO_INFORMATION_CATEGORY
, PJO_INFORMATION1 PJO_INFORMATION1
, PJO_INFORMATION2 PJO_INFORMATION2
, PJO_INFORMATION3 PJO_INFORMATION3
, PJO_INFORMATION4 PJO_INFORMATION4
, PJO_INFORMATION5 PJO_INFORMATION5
, PJO_INFORMATION6 PJO_INFORMATION6
, PJO_INFORMATION7 PJO_INFORMATION7
, PJO_INFORMATION8 PJO_INFORMATION8
, PJO_INFORMATION9 PJO_INFORMATION9
, PJO_INFORMATION10 PJO_INFORMATION10
, PJO_INFORMATION11 PJO_INFORMATION11
, PJO_INFORMATION12 PJO_INFORMATION12
, PJO_INFORMATION13 PJO_INFORMATION13
, PJO_INFORMATION14 PJO_INFORMATION14
, PJO_INFORMATION15 PJO_INFORMATION15
, PJO_INFORMATION16 PJO_INFORMATION16
, PJO_INFORMATION17 PJO_INFORMATION17
, PJO_INFORMATION18 PJO_INFORMATION18
, PJO_INFORMATION19 PJO_INFORMATION19
, PJO_INFORMATION20 PJO_INFORMATION20
, PJO_INFORMATION21 PJO_INFORMATION21
, PJO_INFORMATION22 PJO_INFORMATION22
, PJO_INFORMATION23 PJO_INFORMATION23
, PJO_INFORMATION24 PJO_INFORMATION24
, PJO_INFORMATION25 PJO_INFORMATION25
, PJO_INFORMATION26 PJO_INFORMATION26
, PJO_INFORMATION27 PJO_INFORMATION27
, PJO_INFORMATION28 PJO_INFORMATION28
, PJO_INFORMATION29 PJO_INFORMATION29
, PJO_INFORMATION30 PJO_INFORMATION30
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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
, ALL_ASSIGNMENTS ALL_ASSIGNMENTS
, PERIOD_MONTHS PERIOD_MONTHS
FROM "HR"."PER_PREVIOUS_JOBS"