eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: HR.PER_JOB_EXTRA_INFO#

Source

View Text - Preformatted


select JOB_EXTRA_INFO_ID JOB_EXTRA_INFO_ID, INFORMATION_TYPE INFORMATION_TYPE, JOB_ID JOB_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, JEI_ATTRIBUTE_CATEGORY JEI_ATTRIBUTE_CATEGORY, JEI_ATTRIBUTE1 JEI_ATTRIBUTE1, JEI_ATTRIBUTE2 JEI_ATTRIBUTE2, JEI_ATTRIBUTE3 JEI_ATTRIBUTE3, JEI_ATTRIBUTE4 JEI_ATTRIBUTE4, JEI_ATTRIBUTE5 JEI_ATTRIBUTE5, JEI_ATTRIBUTE6 JEI_ATTRIBUTE6, JEI_ATTRIBUTE7 JEI_ATTRIBUTE7, JEI_ATTRIBUTE8 JEI_ATTRIBUTE8, JEI_ATTRIBUTE9 JEI_ATTRIBUTE9, JEI_ATTRIBUTE10 JEI_ATTRIBUTE10, JEI_ATTRIBUTE11 JEI_ATTRIBUTE11, JEI_ATTRIBUTE12 JEI_ATTRIBUTE12, JEI_ATTRIBUTE13 JEI_ATTRIBUTE13, JEI_ATTRIBUTE14 JEI_ATTRIBUTE14, JEI_ATTRIBUTE15 JEI_ATTRIBUTE15, JEI_ATTRIBUTE16 JEI_ATTRIBUTE16, JEI_ATTRIBUTE17 JEI_ATTRIBUTE17, JEI_ATTRIBUTE18 JEI_ATTRIBUTE18, JEI_ATTRIBUTE19 JEI_ATTRIBUTE19, JEI_ATTRIBUTE20 JEI_ATTRIBUTE20, JEI_INFORMATION_CATEGORY JEI_INFORMATION_CATEGORY, JEI_INFORMATION1 JEI_INFORMATION1, JEI_INFORMATION2 JEI_INFORMATION2, JEI_INFORMATION3 JEI_INFORMATION3, JEI_INFORMATION4 JEI_INFORMATION4, JEI_INFORMATION5 JEI_INFORMATION5, JEI_INFORMATION6 JEI_INFORMATION6, JEI_INFORMATION7 JEI_INFORMATION7, JEI_INFORMATION8 JEI_INFORMATION8, JEI_INFORMATION9 JEI_INFORMATION9, JEI_INFORMATION10 JEI_INFORMATION10, JEI_INFORMATION11 JEI_INFORMATION11, JEI_INFORMATION12 JEI_INFORMATION12, JEI_INFORMATION13 JEI_INFORMATION13, JEI_INFORMATION14 JEI_INFORMATION14, JEI_INFORMATION15 JEI_INFORMATION15, JEI_INFORMATION16 JEI_INFORMATION16, JEI_INFORMATION17 JEI_INFORMATION17, JEI_INFORMATION18 JEI_INFORMATION18, JEI_INFORMATION19 JEI_INFORMATION19, JEI_INFORMATION20 JEI_INFORMATION20, JEI_INFORMATION21 JEI_INFORMATION21, JEI_INFORMATION22 JEI_INFORMATION22, JEI_INFORMATION23 JEI_INFORMATION23, JEI_INFORMATION24 JEI_INFORMATION24, JEI_INFORMATION25 JEI_INFORMATION25, JEI_INFORMATION26 JEI_INFORMATION26, JEI_INFORMATION27 JEI_INFORMATION27, JEI_INFORMATION28 JEI_INFORMATION28, JEI_INFORMATION29 JEI_INFORMATION29, JEI_INFORMATION30 JEI_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_JOB_EXTRA_INFO"

View Text - HTML Formatted

SELECT JOB_EXTRA_INFO_ID JOB_EXTRA_INFO_ID
, INFORMATION_TYPE INFORMATION_TYPE
, JOB_ID JOB_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, JEI_ATTRIBUTE_CATEGORY JEI_ATTRIBUTE_CATEGORY
, JEI_ATTRIBUTE1 JEI_ATTRIBUTE1
, JEI_ATTRIBUTE2 JEI_ATTRIBUTE2
, JEI_ATTRIBUTE3 JEI_ATTRIBUTE3
, JEI_ATTRIBUTE4 JEI_ATTRIBUTE4
, JEI_ATTRIBUTE5 JEI_ATTRIBUTE5
, JEI_ATTRIBUTE6 JEI_ATTRIBUTE6
, JEI_ATTRIBUTE7 JEI_ATTRIBUTE7
, JEI_ATTRIBUTE8 JEI_ATTRIBUTE8
, JEI_ATTRIBUTE9 JEI_ATTRIBUTE9
, JEI_ATTRIBUTE10 JEI_ATTRIBUTE10
, JEI_ATTRIBUTE11 JEI_ATTRIBUTE11
, JEI_ATTRIBUTE12 JEI_ATTRIBUTE12
, JEI_ATTRIBUTE13 JEI_ATTRIBUTE13
, JEI_ATTRIBUTE14 JEI_ATTRIBUTE14
, JEI_ATTRIBUTE15 JEI_ATTRIBUTE15
, JEI_ATTRIBUTE16 JEI_ATTRIBUTE16
, JEI_ATTRIBUTE17 JEI_ATTRIBUTE17
, JEI_ATTRIBUTE18 JEI_ATTRIBUTE18
, JEI_ATTRIBUTE19 JEI_ATTRIBUTE19
, JEI_ATTRIBUTE20 JEI_ATTRIBUTE20
, JEI_INFORMATION_CATEGORY JEI_INFORMATION_CATEGORY
, JEI_INFORMATION1 JEI_INFORMATION1
, JEI_INFORMATION2 JEI_INFORMATION2
, JEI_INFORMATION3 JEI_INFORMATION3
, JEI_INFORMATION4 JEI_INFORMATION4
, JEI_INFORMATION5 JEI_INFORMATION5
, JEI_INFORMATION6 JEI_INFORMATION6
, JEI_INFORMATION7 JEI_INFORMATION7
, JEI_INFORMATION8 JEI_INFORMATION8
, JEI_INFORMATION9 JEI_INFORMATION9
, JEI_INFORMATION10 JEI_INFORMATION10
, JEI_INFORMATION11 JEI_INFORMATION11
, JEI_INFORMATION12 JEI_INFORMATION12
, JEI_INFORMATION13 JEI_INFORMATION13
, JEI_INFORMATION14 JEI_INFORMATION14
, JEI_INFORMATION15 JEI_INFORMATION15
, JEI_INFORMATION16 JEI_INFORMATION16
, JEI_INFORMATION17 JEI_INFORMATION17
, JEI_INFORMATION18 JEI_INFORMATION18
, JEI_INFORMATION19 JEI_INFORMATION19
, JEI_INFORMATION20 JEI_INFORMATION20
, JEI_INFORMATION21 JEI_INFORMATION21
, JEI_INFORMATION22 JEI_INFORMATION22
, JEI_INFORMATION23 JEI_INFORMATION23
, JEI_INFORMATION24 JEI_INFORMATION24
, JEI_INFORMATION25 JEI_INFORMATION25
, JEI_INFORMATION26 JEI_INFORMATION26
, JEI_INFORMATION27 JEI_INFORMATION27
, JEI_INFORMATION28 JEI_INFORMATION28
, JEI_INFORMATION29 JEI_INFORMATION29
, JEI_INFORMATION30 JEI_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_JOB_EXTRA_INFO"