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.IRC_REFERRAL_INFO#

Source

View Text - Preformatted


select REFERRAL_INFO_ID REFERRAL_INFO_ID, OBJECT_ID OBJECT_ID, OBJECT_TYPE OBJECT_TYPE, START_DATE START_DATE, END_DATE END_DATE, SOURCE_TYPE SOURCE_TYPE, SOURCE_NAME SOURCE_NAME, SOURCE_CRITERIA1 SOURCE_CRITERIA1, SOURCE_VALUE1 SOURCE_VALUE1, SOURCE_CRITERIA2 SOURCE_CRITERIA2, SOURCE_VALUE2 SOURCE_VALUE2, SOURCE_CRITERIA3 SOURCE_CRITERIA3, SOURCE_VALUE3 SOURCE_VALUE3, SOURCE_CRITERIA4 SOURCE_CRITERIA4, SOURCE_VALUE4 SOURCE_VALUE4, SOURCE_CRITERIA5 SOURCE_CRITERIA5, SOURCE_VALUE5 SOURCE_VALUE5, SOURCE_PERSON_ID SOURCE_PERSON_ID, CANDIDATE_COMMENT CANDIDATE_COMMENT, EMPLOYEE_COMMENT EMPLOYEE_COMMENT, IRF_ATTRIBUTE_CATEGORY IRF_ATTRIBUTE_CATEGORY, IRF_ATTRIBUTE1 IRF_ATTRIBUTE1, IRF_ATTRIBUTE2 IRF_ATTRIBUTE2, IRF_ATTRIBUTE3 IRF_ATTRIBUTE3, IRF_ATTRIBUTE4 IRF_ATTRIBUTE4, IRF_ATTRIBUTE5 IRF_ATTRIBUTE5, IRF_ATTRIBUTE6 IRF_ATTRIBUTE6, IRF_ATTRIBUTE7 IRF_ATTRIBUTE7, IRF_ATTRIBUTE8 IRF_ATTRIBUTE8, IRF_ATTRIBUTE9 IRF_ATTRIBUTE9, IRF_ATTRIBUTE10 IRF_ATTRIBUTE10, IRF_INFORMATION_CATEGORY IRF_INFORMATION_CATEGORY, IRF_INFORMATION1 IRF_INFORMATION1, IRF_INFORMATION2 IRF_INFORMATION2, IRF_INFORMATION3 IRF_INFORMATION3, IRF_INFORMATION4 IRF_INFORMATION4, IRF_INFORMATION5 IRF_INFORMATION5, IRF_INFORMATION6 IRF_INFORMATION6, IRF_INFORMATION7 IRF_INFORMATION7, IRF_INFORMATION8 IRF_INFORMATION8, IRF_INFORMATION9 IRF_INFORMATION9, IRF_INFORMATION10 IRF_INFORMATION10, OBJECT_CREATED_BY OBJECT_CREATED_BY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "HR"."IRC_REFERRAL_INFO"

View Text - HTML Formatted

SELECT REFERRAL_INFO_ID REFERRAL_INFO_ID
, OBJECT_ID OBJECT_ID
, OBJECT_TYPE OBJECT_TYPE
, START_DATE START_DATE
, END_DATE END_DATE
, SOURCE_TYPE SOURCE_TYPE
, SOURCE_NAME SOURCE_NAME
, SOURCE_CRITERIA1 SOURCE_CRITERIA1
, SOURCE_VALUE1 SOURCE_VALUE1
, SOURCE_CRITERIA2 SOURCE_CRITERIA2
, SOURCE_VALUE2 SOURCE_VALUE2
, SOURCE_CRITERIA3 SOURCE_CRITERIA3
, SOURCE_VALUE3 SOURCE_VALUE3
, SOURCE_CRITERIA4 SOURCE_CRITERIA4
, SOURCE_VALUE4 SOURCE_VALUE4
, SOURCE_CRITERIA5 SOURCE_CRITERIA5
, SOURCE_VALUE5 SOURCE_VALUE5
, SOURCE_PERSON_ID SOURCE_PERSON_ID
, CANDIDATE_COMMENT CANDIDATE_COMMENT
, EMPLOYEE_COMMENT EMPLOYEE_COMMENT
, IRF_ATTRIBUTE_CATEGORY IRF_ATTRIBUTE_CATEGORY
, IRF_ATTRIBUTE1 IRF_ATTRIBUTE1
, IRF_ATTRIBUTE2 IRF_ATTRIBUTE2
, IRF_ATTRIBUTE3 IRF_ATTRIBUTE3
, IRF_ATTRIBUTE4 IRF_ATTRIBUTE4
, IRF_ATTRIBUTE5 IRF_ATTRIBUTE5
, IRF_ATTRIBUTE6 IRF_ATTRIBUTE6
, IRF_ATTRIBUTE7 IRF_ATTRIBUTE7
, IRF_ATTRIBUTE8 IRF_ATTRIBUTE8
, IRF_ATTRIBUTE9 IRF_ATTRIBUTE9
, IRF_ATTRIBUTE10 IRF_ATTRIBUTE10
, IRF_INFORMATION_CATEGORY IRF_INFORMATION_CATEGORY
, IRF_INFORMATION1 IRF_INFORMATION1
, IRF_INFORMATION2 IRF_INFORMATION2
, IRF_INFORMATION3 IRF_INFORMATION3
, IRF_INFORMATION4 IRF_INFORMATION4
, IRF_INFORMATION5 IRF_INFORMATION5
, IRF_INFORMATION6 IRF_INFORMATION6
, IRF_INFORMATION7 IRF_INFORMATION7
, IRF_INFORMATION8 IRF_INFORMATION8
, IRF_INFORMATION9 IRF_INFORMATION9
, IRF_INFORMATION10 IRF_INFORMATION10
, OBJECT_CREATED_BY OBJECT_CREATED_BY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "HR"."IRC_REFERRAL_INFO"