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: HRI.HRI_RECRUITMENT_STAGES#

Source

View Text - Preformatted


select ASSIGNMENT_ID ASSIGNMENT_ID, ASSIGNMENT_START_DATE ASSIGNMENT_START_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ASSIGNMENT_TYPE ASSIGNMENT_TYPE, APPLICATION_ID APPLICATION_ID, PERSON_ID PERSON_ID, GAIN_TYPE GAIN_TYPE, SUCCESS SUCCESS, APPLICATION_DATE APPLICATION_DATE, APPLICATION_END_DATE APPLICATION_END_DATE, PLANNED_START_DATE PLANNED_START_DATE, APPLICATION_REASON APPLICATION_REASON, APPLICATION_SUCCESS APPLICATION_SUCCESS, INTERVIEW1_DATE INTERVIEW1_DATE, INTERVIEW1_REASON INTERVIEW1_REASON, INTERVIEW1_SUCCESS INTERVIEW1_SUCCESS, INTERVIEW2_DATE INTERVIEW2_DATE, INTERVIEW2_REASON INTERVIEW2_REASON, INTERVIEW2_SUCCESS INTERVIEW2_SUCCESS, OFFER_DATE OFFER_DATE, OFFER_REASON OFFER_REASON, OFFER_SUCCESS OFFER_SUCCESS, ACCEPT_DATE ACCEPT_DATE, ACCEPT_REASON ACCEPT_REASON, ACCEPT_SUCCESS ACCEPT_SUCCESS, HIRE_DATE HIRE_DATE, HIRE_REASON HIRE_REASON, TERMINATION_DATE TERMINATION_DATE, TERMINATION_REASON TERMINATION_REASON, SEPARATION_DATE SEPARATION_DATE, SEPARATION_REASON SEPARATION_REASON, HEADCOUNT_VALUE HEADCOUNT_VALUE, FTE_VALUE FTE_VALUE, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, CURRENT_STAGE CURRENT_STAGE, CURRENT_STAGE_DATE CURRENT_STAGE_DATE, CURRENT_STAGE_REASON CURRENT_STAGE_REASON from "HRI"."HRI_RECRUITMENT_STAGES"

View Text - HTML Formatted

SELECT ASSIGNMENT_ID ASSIGNMENT_ID
, ASSIGNMENT_START_DATE ASSIGNMENT_START_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ASSIGNMENT_TYPE ASSIGNMENT_TYPE
, APPLICATION_ID APPLICATION_ID
, PERSON_ID PERSON_ID
, GAIN_TYPE GAIN_TYPE
, SUCCESS SUCCESS
, APPLICATION_DATE APPLICATION_DATE
, APPLICATION_END_DATE APPLICATION_END_DATE
, PLANNED_START_DATE PLANNED_START_DATE
, APPLICATION_REASON APPLICATION_REASON
, APPLICATION_SUCCESS APPLICATION_SUCCESS
, INTERVIEW1_DATE INTERVIEW1_DATE
, INTERVIEW1_REASON INTERVIEW1_REASON
, INTERVIEW1_SUCCESS INTERVIEW1_SUCCESS
, INTERVIEW2_DATE INTERVIEW2_DATE
, INTERVIEW2_REASON INTERVIEW2_REASON
, INTERVIEW2_SUCCESS INTERVIEW2_SUCCESS
, OFFER_DATE OFFER_DATE
, OFFER_REASON OFFER_REASON
, OFFER_SUCCESS OFFER_SUCCESS
, ACCEPT_DATE ACCEPT_DATE
, ACCEPT_REASON ACCEPT_REASON
, ACCEPT_SUCCESS ACCEPT_SUCCESS
, HIRE_DATE HIRE_DATE
, HIRE_REASON HIRE_REASON
, TERMINATION_DATE TERMINATION_DATE
, TERMINATION_REASON TERMINATION_REASON
, SEPARATION_DATE SEPARATION_DATE
, SEPARATION_REASON SEPARATION_REASON
, HEADCOUNT_VALUE HEADCOUNT_VALUE
, FTE_VALUE FTE_VALUE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, CURRENT_STAGE CURRENT_STAGE
, CURRENT_STAGE_DATE CURRENT_STAGE_DATE
, CURRENT_STAGE_REASON CURRENT_STAGE_REASON
FROM "HRI"."HRI_RECRUITMENT_STAGES"