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_POSITION_EXTRA_INFO#

Source

View Text - Preformatted


select POSITION_EXTRA_INFO_ID POSITION_EXTRA_INFO_ID, POSITION_ID POSITION_ID, INFORMATION_TYPE INFORMATION_TYPE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, POEI_ATTRIBUTE_CATEGORY POEI_ATTRIBUTE_CATEGORY, POEI_ATTRIBUTE1 POEI_ATTRIBUTE1, POEI_ATTRIBUTE2 POEI_ATTRIBUTE2, POEI_ATTRIBUTE3 POEI_ATTRIBUTE3, POEI_ATTRIBUTE4 POEI_ATTRIBUTE4, POEI_ATTRIBUTE5 POEI_ATTRIBUTE5, POEI_ATTRIBUTE6 POEI_ATTRIBUTE6, POEI_ATTRIBUTE7 POEI_ATTRIBUTE7, POEI_ATTRIBUTE8 POEI_ATTRIBUTE8, POEI_ATTRIBUTE9 POEI_ATTRIBUTE9, POEI_ATTRIBUTE10 POEI_ATTRIBUTE10, POEI_ATTRIBUTE11 POEI_ATTRIBUTE11, POEI_ATTRIBUTE12 POEI_ATTRIBUTE12, POEI_ATTRIBUTE13 POEI_ATTRIBUTE13, POEI_ATTRIBUTE14 POEI_ATTRIBUTE14, POEI_ATTRIBUTE15 POEI_ATTRIBUTE15, POEI_ATTRIBUTE16 POEI_ATTRIBUTE16, POEI_ATTRIBUTE17 POEI_ATTRIBUTE17, POEI_ATTRIBUTE18 POEI_ATTRIBUTE18, POEI_ATTRIBUTE19 POEI_ATTRIBUTE19, POEI_ATTRIBUTE20 POEI_ATTRIBUTE20, POEI_INFORMATION_CATEGORY POEI_INFORMATION_CATEGORY, POEI_INFORMATION1 POEI_INFORMATION1, POEI_INFORMATION2 POEI_INFORMATION2, POEI_INFORMATION3 POEI_INFORMATION3, POEI_INFORMATION4 POEI_INFORMATION4, POEI_INFORMATION5 POEI_INFORMATION5, POEI_INFORMATION6 POEI_INFORMATION6, POEI_INFORMATION7 POEI_INFORMATION7, POEI_INFORMATION8 POEI_INFORMATION8, POEI_INFORMATION9 POEI_INFORMATION9, POEI_INFORMATION10 POEI_INFORMATION10, POEI_INFORMATION11 POEI_INFORMATION11, POEI_INFORMATION12 POEI_INFORMATION12, POEI_INFORMATION13 POEI_INFORMATION13, POEI_INFORMATION14 POEI_INFORMATION14, POEI_INFORMATION15 POEI_INFORMATION15, POEI_INFORMATION16 POEI_INFORMATION16, POEI_INFORMATION17 POEI_INFORMATION17, POEI_INFORMATION18 POEI_INFORMATION18, POEI_INFORMATION19 POEI_INFORMATION19, POEI_INFORMATION20 POEI_INFORMATION20, POEI_INFORMATION21 POEI_INFORMATION21, POEI_INFORMATION22 POEI_INFORMATION22, POEI_INFORMATION23 POEI_INFORMATION23, POEI_INFORMATION24 POEI_INFORMATION24, POEI_INFORMATION25 POEI_INFORMATION25, POEI_INFORMATION26 POEI_INFORMATION26, POEI_INFORMATION27 POEI_INFORMATION27, POEI_INFORMATION28 POEI_INFORMATION28, POEI_INFORMATION29 POEI_INFORMATION29, POEI_INFORMATION30 POEI_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_POSITION_EXTRA_INFO"

View Text - HTML Formatted

SELECT POSITION_EXTRA_INFO_ID POSITION_EXTRA_INFO_ID
, POSITION_ID POSITION_ID
, INFORMATION_TYPE INFORMATION_TYPE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, POEI_ATTRIBUTE_CATEGORY POEI_ATTRIBUTE_CATEGORY
, POEI_ATTRIBUTE1 POEI_ATTRIBUTE1
, POEI_ATTRIBUTE2 POEI_ATTRIBUTE2
, POEI_ATTRIBUTE3 POEI_ATTRIBUTE3
, POEI_ATTRIBUTE4 POEI_ATTRIBUTE4
, POEI_ATTRIBUTE5 POEI_ATTRIBUTE5
, POEI_ATTRIBUTE6 POEI_ATTRIBUTE6
, POEI_ATTRIBUTE7 POEI_ATTRIBUTE7
, POEI_ATTRIBUTE8 POEI_ATTRIBUTE8
, POEI_ATTRIBUTE9 POEI_ATTRIBUTE9
, POEI_ATTRIBUTE10 POEI_ATTRIBUTE10
, POEI_ATTRIBUTE11 POEI_ATTRIBUTE11
, POEI_ATTRIBUTE12 POEI_ATTRIBUTE12
, POEI_ATTRIBUTE13 POEI_ATTRIBUTE13
, POEI_ATTRIBUTE14 POEI_ATTRIBUTE14
, POEI_ATTRIBUTE15 POEI_ATTRIBUTE15
, POEI_ATTRIBUTE16 POEI_ATTRIBUTE16
, POEI_ATTRIBUTE17 POEI_ATTRIBUTE17
, POEI_ATTRIBUTE18 POEI_ATTRIBUTE18
, POEI_ATTRIBUTE19 POEI_ATTRIBUTE19
, POEI_ATTRIBUTE20 POEI_ATTRIBUTE20
, POEI_INFORMATION_CATEGORY POEI_INFORMATION_CATEGORY
, POEI_INFORMATION1 POEI_INFORMATION1
, POEI_INFORMATION2 POEI_INFORMATION2
, POEI_INFORMATION3 POEI_INFORMATION3
, POEI_INFORMATION4 POEI_INFORMATION4
, POEI_INFORMATION5 POEI_INFORMATION5
, POEI_INFORMATION6 POEI_INFORMATION6
, POEI_INFORMATION7 POEI_INFORMATION7
, POEI_INFORMATION8 POEI_INFORMATION8
, POEI_INFORMATION9 POEI_INFORMATION9
, POEI_INFORMATION10 POEI_INFORMATION10
, POEI_INFORMATION11 POEI_INFORMATION11
, POEI_INFORMATION12 POEI_INFORMATION12
, POEI_INFORMATION13 POEI_INFORMATION13
, POEI_INFORMATION14 POEI_INFORMATION14
, POEI_INFORMATION15 POEI_INFORMATION15
, POEI_INFORMATION16 POEI_INFORMATION16
, POEI_INFORMATION17 POEI_INFORMATION17
, POEI_INFORMATION18 POEI_INFORMATION18
, POEI_INFORMATION19 POEI_INFORMATION19
, POEI_INFORMATION20 POEI_INFORMATION20
, POEI_INFORMATION21 POEI_INFORMATION21
, POEI_INFORMATION22 POEI_INFORMATION22
, POEI_INFORMATION23 POEI_INFORMATION23
, POEI_INFORMATION24 POEI_INFORMATION24
, POEI_INFORMATION25 POEI_INFORMATION25
, POEI_INFORMATION26 POEI_INFORMATION26
, POEI_INFORMATION27 POEI_INFORMATION27
, POEI_INFORMATION28 POEI_INFORMATION28
, POEI_INFORMATION29 POEI_INFORMATION29
, POEI_INFORMATION30 POEI_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_POSITION_EXTRA_INFO"