VIEW: HR.PER_PREV_JOB_EXTRA_INFO#

Source

View Text - Preformatted

select PREVIOUS_JOB_EXTRA_INFO_ID PREVIOUS_JOB_EXTRA_INFO_ID, PREVIOUS_JOB_ID PREVIOUS_JOB_ID, INFORMATION_TYPE INFORMATION_TYPE, PJI_ATTRIBUTE_CATEGORY PJI_ATTRIBUTE_CATEGORY, PJI_ATTRIBUTE1 PJI_ATTRIBUTE1, PJI_ATTRIBUTE2 PJI_ATTRIBUTE2, PJI_ATTRIBUTE3 PJI_ATTRIBUTE3, PJI_ATTRIBUTE4 PJI_ATTRIBUTE4, PJI_ATTRIBUTE5 PJI_ATTRIBUTE5, PJI_ATTRIBUTE6 PJI_ATTRIBUTE6, PJI_ATTRIBUTE7 PJI_ATTRIBUTE7, PJI_ATTRIBUTE8 PJI_ATTRIBUTE8, PJI_ATTRIBUTE9 PJI_ATTRIBUTE9, PJI_ATTRIBUTE10 PJI_ATTRIBUTE10, PJI_ATTRIBUTE11 PJI_ATTRIBUTE11, PJI_ATTRIBUTE12 PJI_ATTRIBUTE12, PJI_ATTRIBUTE13 PJI_ATTRIBUTE13, PJI_ATTRIBUTE14 PJI_ATTRIBUTE14, PJI_ATTRIBUTE15 PJI_ATTRIBUTE15, PJI_ATTRIBUTE16 PJI_ATTRIBUTE16, PJI_ATTRIBUTE17 PJI_ATTRIBUTE17, PJI_ATTRIBUTE18 PJI_ATTRIBUTE18, PJI_ATTRIBUTE19 PJI_ATTRIBUTE19, PJI_ATTRIBUTE20 PJI_ATTRIBUTE20, PJI_ATTRIBUTE21 PJI_ATTRIBUTE21, PJI_ATTRIBUTE22 PJI_ATTRIBUTE22, PJI_ATTRIBUTE23 PJI_ATTRIBUTE23, PJI_ATTRIBUTE24 PJI_ATTRIBUTE24, PJI_ATTRIBUTE25 PJI_ATTRIBUTE25, PJI_ATTRIBUTE26 PJI_ATTRIBUTE26, PJI_ATTRIBUTE27 PJI_ATTRIBUTE27, PJI_ATTRIBUTE28 PJI_ATTRIBUTE28, PJI_ATTRIBUTE29 PJI_ATTRIBUTE29, PJI_ATTRIBUTE30 PJI_ATTRIBUTE30, PJI_INFORMATION_CATEGORY PJI_INFORMATION_CATEGORY, PJI_INFORMATION1 PJI_INFORMATION1, PJI_INFORMATION2 PJI_INFORMATION2, PJI_INFORMATION3 PJI_INFORMATION3, PJI_INFORMATION4 PJI_INFORMATION4, PJI_INFORMATION5 PJI_INFORMATION5, PJI_INFORMATION6 PJI_INFORMATION6, PJI_INFORMATION7 PJI_INFORMATION7, PJI_INFORMATION8 PJI_INFORMATION8, PJI_INFORMATION9 PJI_INFORMATION9, PJI_INFORMATION10 PJI_INFORMATION10, PJI_INFORMATION11 PJI_INFORMATION11, PJI_INFORMATION12 PJI_INFORMATION12, PJI_INFORMATION13 PJI_INFORMATION13, PJI_INFORMATION14 PJI_INFORMATION14, PJI_INFORMATION15 PJI_INFORMATION15, PJI_INFORMATION16 PJI_INFORMATION16, PJI_INFORMATION17 PJI_INFORMATION17, PJI_INFORMATION18 PJI_INFORMATION18, PJI_INFORMATION19 PJI_INFORMATION19, PJI_INFORMATION20 PJI_INFORMATION20, PJI_INFORMATION21 PJI_INFORMATION21, PJI_INFORMATION22 PJI_INFORMATION22, PJI_INFORMATION23 PJI_INFORMATION23, PJI_INFORMATION24 PJI_INFORMATION24, PJI_INFORMATION25 PJI_INFORMATION25, PJI_INFORMATION26 PJI_INFORMATION26, PJI_INFORMATION27 PJI_INFORMATION27, PJI_INFORMATION28 PJI_INFORMATION28, PJI_INFORMATION29 PJI_INFORMATION29, PJI_INFORMATION30 PJI_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 from "HR"."PER_PREV_JOB_EXTRA_INFO"

View Text - HTML Formatted

SELECT PREVIOUS_JOB_EXTRA_INFO_ID PREVIOUS_JOB_EXTRA_INFO_ID
, PREVIOUS_JOB_ID PREVIOUS_JOB_ID
, INFORMATION_TYPE INFORMATION_TYPE
, PJI_ATTRIBUTE_CATEGORY PJI_ATTRIBUTE_CATEGORY
, PJI_ATTRIBUTE1 PJI_ATTRIBUTE1
, PJI_ATTRIBUTE2 PJI_ATTRIBUTE2
, PJI_ATTRIBUTE3 PJI_ATTRIBUTE3
, PJI_ATTRIBUTE4 PJI_ATTRIBUTE4
, PJI_ATTRIBUTE5 PJI_ATTRIBUTE5
, PJI_ATTRIBUTE6 PJI_ATTRIBUTE6
, PJI_ATTRIBUTE7 PJI_ATTRIBUTE7
, PJI_ATTRIBUTE8 PJI_ATTRIBUTE8
, PJI_ATTRIBUTE9 PJI_ATTRIBUTE9
, PJI_ATTRIBUTE10 PJI_ATTRIBUTE10
, PJI_ATTRIBUTE11 PJI_ATTRIBUTE11
, PJI_ATTRIBUTE12 PJI_ATTRIBUTE12
, PJI_ATTRIBUTE13 PJI_ATTRIBUTE13
, PJI_ATTRIBUTE14 PJI_ATTRIBUTE14
, PJI_ATTRIBUTE15 PJI_ATTRIBUTE15
, PJI_ATTRIBUTE16 PJI_ATTRIBUTE16
, PJI_ATTRIBUTE17 PJI_ATTRIBUTE17
, PJI_ATTRIBUTE18 PJI_ATTRIBUTE18
, PJI_ATTRIBUTE19 PJI_ATTRIBUTE19
, PJI_ATTRIBUTE20 PJI_ATTRIBUTE20
, PJI_ATTRIBUTE21 PJI_ATTRIBUTE21
, PJI_ATTRIBUTE22 PJI_ATTRIBUTE22
, PJI_ATTRIBUTE23 PJI_ATTRIBUTE23
, PJI_ATTRIBUTE24 PJI_ATTRIBUTE24
, PJI_ATTRIBUTE25 PJI_ATTRIBUTE25
, PJI_ATTRIBUTE26 PJI_ATTRIBUTE26
, PJI_ATTRIBUTE27 PJI_ATTRIBUTE27
, PJI_ATTRIBUTE28 PJI_ATTRIBUTE28
, PJI_ATTRIBUTE29 PJI_ATTRIBUTE29
, PJI_ATTRIBUTE30 PJI_ATTRIBUTE30
, PJI_INFORMATION_CATEGORY PJI_INFORMATION_CATEGORY
, PJI_INFORMATION1 PJI_INFORMATION1
, PJI_INFORMATION2 PJI_INFORMATION2
, PJI_INFORMATION3 PJI_INFORMATION3
, PJI_INFORMATION4 PJI_INFORMATION4
, PJI_INFORMATION5 PJI_INFORMATION5
, PJI_INFORMATION6 PJI_INFORMATION6
, PJI_INFORMATION7 PJI_INFORMATION7
, PJI_INFORMATION8 PJI_INFORMATION8
, PJI_INFORMATION9 PJI_INFORMATION9
, PJI_INFORMATION10 PJI_INFORMATION10
, PJI_INFORMATION11 PJI_INFORMATION11
, PJI_INFORMATION12 PJI_INFORMATION12
, PJI_INFORMATION13 PJI_INFORMATION13
, PJI_INFORMATION14 PJI_INFORMATION14
, PJI_INFORMATION15 PJI_INFORMATION15
, PJI_INFORMATION16 PJI_INFORMATION16
, PJI_INFORMATION17 PJI_INFORMATION17
, PJI_INFORMATION18 PJI_INFORMATION18
, PJI_INFORMATION19 PJI_INFORMATION19
, PJI_INFORMATION20 PJI_INFORMATION20
, PJI_INFORMATION21 PJI_INFORMATION21
, PJI_INFORMATION22 PJI_INFORMATION22
, PJI_INFORMATION23 PJI_INFORMATION23
, PJI_INFORMATION24 PJI_INFORMATION24
, PJI_INFORMATION25 PJI_INFORMATION25
, PJI_INFORMATION26 PJI_INFORMATION26
, PJI_INFORMATION27 PJI_INFORMATION27
, PJI_INFORMATION28 PJI_INFORMATION28
, PJI_INFORMATION29 PJI_INFORMATION29
, PJI_INFORMATION30 PJI_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
FROM "HR"."PER_PREV_JOB_EXTRA_INFO"