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.

VIEW: HR.PER_APPLICATIONS#

Source

View Text - Preformatted


select APPLICATION_ID APPLICATION_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PERSON_ID PERSON_ID, DATE_RECEIVED DATE_RECEIVED, CURRENT_EMPLOYER CURRENT_EMPLOYER, DATE_END DATE_END, PROJECTED_HIRE_DATE PROJECTED_HIRE_DATE, SUCCESSFUL_FLAG SUCCESSFUL_FLAG, TERMINATION_REASON TERMINATION_REASON, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, APPL_ATTRIBUTE_CATEGORY APPL_ATTRIBUTE_CATEGORY, APPL_ATTRIBUTE1 APPL_ATTRIBUTE1, APPL_ATTRIBUTE2 APPL_ATTRIBUTE2, APPL_ATTRIBUTE3 APPL_ATTRIBUTE3, APPL_ATTRIBUTE4 APPL_ATTRIBUTE4, APPL_ATTRIBUTE5 APPL_ATTRIBUTE5, APPL_ATTRIBUTE6 APPL_ATTRIBUTE6, APPL_ATTRIBUTE7 APPL_ATTRIBUTE7, APPL_ATTRIBUTE8 APPL_ATTRIBUTE8, APPL_ATTRIBUTE9 APPL_ATTRIBUTE9, APPL_ATTRIBUTE10 APPL_ATTRIBUTE10, APPL_ATTRIBUTE11 APPL_ATTRIBUTE11, APPL_ATTRIBUTE12 APPL_ATTRIBUTE12, APPL_ATTRIBUTE13 APPL_ATTRIBUTE13, APPL_ATTRIBUTE14 APPL_ATTRIBUTE14, APPL_ATTRIBUTE15 APPL_ATTRIBUTE15, APPL_ATTRIBUTE16 APPL_ATTRIBUTE16, APPL_ATTRIBUTE17 APPL_ATTRIBUTE17, APPL_ATTRIBUTE18 APPL_ATTRIBUTE18, APPL_ATTRIBUTE19 APPL_ATTRIBUTE19, APPL_ATTRIBUTE20 APPL_ATTRIBUTE20, 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, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, COMMENTS COMMENTS from "HR"."PER_APPLICATIONS"

View Text - HTML Formatted

SELECT APPLICATION_ID APPLICATION_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PERSON_ID PERSON_ID
, DATE_RECEIVED DATE_RECEIVED
, CURRENT_EMPLOYER CURRENT_EMPLOYER
, DATE_END DATE_END
, PROJECTED_HIRE_DATE PROJECTED_HIRE_DATE
, SUCCESSFUL_FLAG SUCCESSFUL_FLAG
, TERMINATION_REASON TERMINATION_REASON
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, APPL_ATTRIBUTE_CATEGORY APPL_ATTRIBUTE_CATEGORY
, APPL_ATTRIBUTE1 APPL_ATTRIBUTE1
, APPL_ATTRIBUTE2 APPL_ATTRIBUTE2
, APPL_ATTRIBUTE3 APPL_ATTRIBUTE3
, APPL_ATTRIBUTE4 APPL_ATTRIBUTE4
, APPL_ATTRIBUTE5 APPL_ATTRIBUTE5
, APPL_ATTRIBUTE6 APPL_ATTRIBUTE6
, APPL_ATTRIBUTE7 APPL_ATTRIBUTE7
, APPL_ATTRIBUTE8 APPL_ATTRIBUTE8
, APPL_ATTRIBUTE9 APPL_ATTRIBUTE9
, APPL_ATTRIBUTE10 APPL_ATTRIBUTE10
, APPL_ATTRIBUTE11 APPL_ATTRIBUTE11
, APPL_ATTRIBUTE12 APPL_ATTRIBUTE12
, APPL_ATTRIBUTE13 APPL_ATTRIBUTE13
, APPL_ATTRIBUTE14 APPL_ATTRIBUTE14
, APPL_ATTRIBUTE15 APPL_ATTRIBUTE15
, APPL_ATTRIBUTE16 APPL_ATTRIBUTE16
, APPL_ATTRIBUTE17 APPL_ATTRIBUTE17
, APPL_ATTRIBUTE18 APPL_ATTRIBUTE18
, APPL_ATTRIBUTE19 APPL_ATTRIBUTE19
, APPL_ATTRIBUTE20 APPL_ATTRIBUTE20
, 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
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, COMMENTS COMMENTS
FROM "HR"."PER_APPLICATIONS"