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

Source

View Text - Preformatted


select ASSIGNMENT_YEA_INFO_ID ASSIGNMENT_YEA_INFO_ID, ASSIGNMENT_ID ASSIGNMENT_ID, INFORMATION_TYPE INFORMATION_TYPE, TARGET_YEAR TARGET_YEAR, AYI_INFORMATION_CATEGORY AYI_INFORMATION_CATEGORY, AYI_INFORMATION1 AYI_INFORMATION1, AYI_INFORMATION2 AYI_INFORMATION2, AYI_INFORMATION3 AYI_INFORMATION3, AYI_INFORMATION4 AYI_INFORMATION4, AYI_INFORMATION5 AYI_INFORMATION5, AYI_INFORMATION6 AYI_INFORMATION6, AYI_INFORMATION7 AYI_INFORMATION7, AYI_INFORMATION8 AYI_INFORMATION8, AYI_INFORMATION9 AYI_INFORMATION9, AYI_INFORMATION10 AYI_INFORMATION10, AYI_INFORMATION11 AYI_INFORMATION11, AYI_INFORMATION12 AYI_INFORMATION12, AYI_INFORMATION13 AYI_INFORMATION13, AYI_INFORMATION14 AYI_INFORMATION14, AYI_INFORMATION15 AYI_INFORMATION15, AYI_INFORMATION16 AYI_INFORMATION16, AYI_INFORMATION17 AYI_INFORMATION17, AYI_INFORMATION18 AYI_INFORMATION18, AYI_INFORMATION19 AYI_INFORMATION19, AYI_INFORMATION20 AYI_INFORMATION20, AYI_INFORMATION21 AYI_INFORMATION21, AYI_INFORMATION22 AYI_INFORMATION22, AYI_INFORMATION23 AYI_INFORMATION23, AYI_INFORMATION24 AYI_INFORMATION24, AYI_INFORMATION25 AYI_INFORMATION25, AYI_INFORMATION26 AYI_INFORMATION26, AYI_INFORMATION27 AYI_INFORMATION27, AYI_INFORMATION28 AYI_INFORMATION28, AYI_INFORMATION29 AYI_INFORMATION29, AYI_INFORMATION30 AYI_INFORMATION30, AYI_INFORMATION31 AYI_INFORMATION31, AYI_INFORMATION32 AYI_INFORMATION32, AYI_INFORMATION33 AYI_INFORMATION33, AYI_INFORMATION34 AYI_INFORMATION34, AYI_INFORMATION35 AYI_INFORMATION35, LAST_UPDATE_DATE LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE from "HR"."PER_KR_ASSIGNMENT_YEA_INFO"

View Text - HTML Formatted

SELECT ASSIGNMENT_YEA_INFO_ID ASSIGNMENT_YEA_INFO_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, INFORMATION_TYPE INFORMATION_TYPE
, TARGET_YEAR TARGET_YEAR
, AYI_INFORMATION_CATEGORY AYI_INFORMATION_CATEGORY
, AYI_INFORMATION1 AYI_INFORMATION1
, AYI_INFORMATION2 AYI_INFORMATION2
, AYI_INFORMATION3 AYI_INFORMATION3
, AYI_INFORMATION4 AYI_INFORMATION4
, AYI_INFORMATION5 AYI_INFORMATION5
, AYI_INFORMATION6 AYI_INFORMATION6
, AYI_INFORMATION7 AYI_INFORMATION7
, AYI_INFORMATION8 AYI_INFORMATION8
, AYI_INFORMATION9 AYI_INFORMATION9
, AYI_INFORMATION10 AYI_INFORMATION10
, AYI_INFORMATION11 AYI_INFORMATION11
, AYI_INFORMATION12 AYI_INFORMATION12
, AYI_INFORMATION13 AYI_INFORMATION13
, AYI_INFORMATION14 AYI_INFORMATION14
, AYI_INFORMATION15 AYI_INFORMATION15
, AYI_INFORMATION16 AYI_INFORMATION16
, AYI_INFORMATION17 AYI_INFORMATION17
, AYI_INFORMATION18 AYI_INFORMATION18
, AYI_INFORMATION19 AYI_INFORMATION19
, AYI_INFORMATION20 AYI_INFORMATION20
, AYI_INFORMATION21 AYI_INFORMATION21
, AYI_INFORMATION22 AYI_INFORMATION22
, AYI_INFORMATION23 AYI_INFORMATION23
, AYI_INFORMATION24 AYI_INFORMATION24
, AYI_INFORMATION25 AYI_INFORMATION25
, AYI_INFORMATION26 AYI_INFORMATION26
, AYI_INFORMATION27 AYI_INFORMATION27
, AYI_INFORMATION28 AYI_INFORMATION28
, AYI_INFORMATION29 AYI_INFORMATION29
, AYI_INFORMATION30 AYI_INFORMATION30
, AYI_INFORMATION31 AYI_INFORMATION31
, AYI_INFORMATION32 AYI_INFORMATION32
, AYI_INFORMATION33 AYI_INFORMATION33
, AYI_INFORMATION34 AYI_INFORMATION34
, AYI_INFORMATION35 AYI_INFORMATION35
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
FROM "HR"."PER_KR_ASSIGNMENT_YEA_INFO"