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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HRI.HR_EDW_WRK_RCTMNT_F

Object Details

Object Name:	HR_EDW_WRK_RCTMNT_F
Object Type:	TABLE
Owner:	HRI
FND Design Data:	HRI.HR_EDW_WRK_RCTMNT_F
Subobject Name:
Status:	VALID

This is the Workforce Recruitment Stage fact table. This fact contains information about each stage of the recruitment process, from application to hire and eventual separation. There is one row in the fact table for each application (one per applicant assignment) and one row for each employee assignment (for current employees who may be hired directly without following the recruitment process).

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	30
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_EDW_WRK_RCTMNT_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	RECRUITMENT_GAIN_PK
HR_EDW_WRK_RCTMNT_F_N1	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	PERSON_TYPE_FK_KEY
HR_EDW_WRK_RCTMNT_F_N10	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	ORGANIZATION_ASSGNMNT_FK_KEY
HR_EDW_WRK_RCTMNT_F_N11	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	ORGANIZATION_CRDNTNG_FK_KEY
HR_EDW_WRK_RCTMNT_F_N12	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	TIME_APPLICATION_FK_KEY
HR_EDW_WRK_RCTMNT_F_N13	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	TIME_INTERVIEW1_FK_KEY
HR_EDW_WRK_RCTMNT_F_N14	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	TIME_INTERVIEW2_FK_KEY
HR_EDW_WRK_RCTMNT_F_N15	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	ASSIGNMENT_FK_KEY
HR_EDW_WRK_RCTMNT_F_N16	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	GRADE_FK_KEY
HR_EDW_WRK_RCTMNT_F_N17	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	INSTANCE_FK_KEY
HR_EDW_WRK_RCTMNT_F_N18	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	JOB_FK_KEY
HR_EDW_WRK_RCTMNT_F_N19	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	PERSON_APPLICANT_FK_KEY
HR_EDW_WRK_RCTMNT_F_N2	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	RECRUITMENT_ACTIVITY_FK_KEY
HR_EDW_WRK_RCTMNT_F_N20	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	PERSON_AUTHORISER_FK_KEY
HR_EDW_WRK_RCTMNT_F_N21	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	PERSON_CONTACT_FK_KEY
HR_EDW_WRK_RCTMNT_F_N22	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	PERSON_RECRUITER_FK_KEY
HR_EDW_WRK_RCTMNT_F_N23	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	POSITION_FK_KEY
HR_EDW_WRK_RCTMNT_F_N24	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	GEOGRAPHY_FK_KEY
HR_EDW_WRK_RCTMNT_F_N25	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	AGE_BAND_FK_KEY
HR_EDW_WRK_RCTMNT_F_N26	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	MOVEMENT_APPLICATION_FK_KEY
HR_EDW_WRK_RCTMNT_F_N27	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	MOVEMENT_INTERVIEW1_FK_KEY
HR_EDW_WRK_RCTMNT_F_N28	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	MOVEMENT_INTERVIEW2_FK_KEY
HR_EDW_WRK_RCTMNT_F_N29	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	MOVEMENT_OFFER_FK_KEY
HR_EDW_WRK_RCTMNT_F_N3	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	VACANCY_FK_KEY
HR_EDW_WRK_RCTMNT_F_N30	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	MOVEMENT_ACCEPT_FK_KEY
HR_EDW_WRK_RCTMNT_F_N31	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	MOVEMENT_HIRE_FK_KEY
HR_EDW_WRK_RCTMNT_F_N32	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	MOVEMENT_TERMINATION_FK_KEY
HR_EDW_WRK_RCTMNT_F_N33	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	MOVEMENT_EMPLYMNT_END_FK_KEY
HR_EDW_WRK_RCTMNT_F_N34	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	REASON_APPLICATION_FK_KEY
HR_EDW_WRK_RCTMNT_F_N35	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	REASON_INTERVIEW1_FK_KEY
HR_EDW_WRK_RCTMNT_F_N36	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	REASON_INTERVIEW2_FK_KEY
HR_EDW_WRK_RCTMNT_F_N37	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	REASON_OFFER_FK_KEY
HR_EDW_WRK_RCTMNT_F_N38	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	REASON_ACCEPT_FK_KEY
HR_EDW_WRK_RCTMNT_F_N39	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	REASON_HIRE_FK_KEY
HR_EDW_WRK_RCTMNT_F_N4	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SERVICE_BAND_FK_KEY
HR_EDW_WRK_RCTMNT_F_N40	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	REASON_TERMINATION_FK_KEY
HR_EDW_WRK_RCTMNT_F_N41	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	REASON_EMPLYMNT_END_FK_KEY
HR_EDW_WRK_RCTMNT_F_N5	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	TIME_ACCEPT_FK_KEY
HR_EDW_WRK_RCTMNT_F_N6	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	TIME_HIRE_FK_KEY
HR_EDW_WRK_RCTMNT_F_N7	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	TIME_TERMINATION_FK_KEY
HR_EDW_WRK_RCTMNT_F_N8	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	TIME_EMPLOYMENT_END_FK_KEY
HR_EDW_WRK_RCTMNT_F_N9	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	TIME_OFFER_FK_KEY

Columns

Name	Datatype	Length	Comments
ACCEPT_OCCURRED	NUMBER		Indicator taking the value 1 if the applicant reached the offer accepted stage, and 0 otherwise
APPLICANT_FTE	NUMBER		Full Time Equivalent value of the applicant at the most recent stage
APPLICANT_HEADCOUNT	NUMBER		Headcount value of the applicant at the most recent stage
APPLICATION_END_DATE	DATE		Date the application ended
APPLICATION_ID	NUMBER		Hidden identifier for the application from the data source
APPLICATION_START_DATE	DATE		Date the application was received
APPLICATION_TERMINATED	NUMBER		Indicator taking the value 1 if the application was rejected, and 0 otherwise
ASSIGNMENT_ID	NUMBER		Hidden identifier for the assignment from the data source
BUSINESS_GROUP_ID	NUMBER		Hidden identifier for the business group from the data source
CREATION_DATE	DATE		Standard who column
DAYS_TO_ACCEPT	NUMBER		Number of days between application start and offer acceptance
DAYS_TO_END_EMP	NUMBER		Number of days between application start and separation from the enterprise (if hired)
DAYS_TO_HIRE	NUMBER		Number of days between application start and hire
DAYS_TO_INTERVIEW1	NUMBER		Number of days between application start and first interview
DAYS_TO_INTERVIEW2	NUMBER		Number of days between application start and second interview
DAYS_TO_OFFER	NUMBER		Number of days between application start and offer
DAYS_TO_TERM_APL	NUMBER		Number of days between application start and rejection
END_EMP_OCCURRED	NUMBER		Indicator taking the value 1 if separated from the enterprise (after hiring), and 0 otherwise
FINISHED_VALUE	NUMBER		Indicator taking the value 1 if the application has ended (hire or rejection), and 0 otherwise
HIRE_DATE	DATE		Hire date, one day after the application end date for successful applications
PERSON_TYPE_FK_KEY	NUMBER		Warehouse foreign key to the Person Type dimension for the current person type
RECRUITMENT_ACTIVITY_FK_KEY	NUMBER		Warehouse foreign key to the Recruitment Activity dimension
VACANCY_FK_KEY	NUMBER		Warehouse foreign key to the Vacancy dimension
SERVICE_BAND_FK_KEY	NUMBER		Warehouse foreign key to the Period of Work Band dimension for the successful applicant's current period of work
TIME_OFFER_FK_KEY	NUMBER		Warehouse foreign key to the Time dimension for the offer date
TIME_ACCEPT_FK_KEY	NUMBER		Warehouse foreign key to the Time dimension for the offer acceptance date
TIME_HIRE_FK_KEY	NUMBER		Warehouse foreign key to the Time dimension for the hire date
TIME_TERMINATION_FK_KEY	NUMBER		Warehouse foreign key to the Time dimension for the application rejected date
TIME_EMPLOYMENT_END_FK_KEY	NUMBER		Warehouse foreign key to the Time dimension for the separation date (of a successful applicant)
ORGANIZATION_ASSGNMNT_FK_KEY	NUMBER		Warehouse foreign key to the Organization dimension for the assignment organization
ORGANIZATION_CRDNTNG_FK_KEY	NUMBER		Warehouse foreign key to the Organization dimension for the organization co-ordinating the recruitment activity
TIME_APPLICATION_FK_KEY	NUMBER		Warehouse foreign key to the Time dimension for the date the application was received
TIME_INTERVIEW1_FK_KEY	NUMBER		Warehouse foreign key to the Time dimension for the first interview date
TIME_INTERVIEW2_FK_KEY	NUMBER		Warehouse foreign key to the Time dimension for the second interview date
ASSIGNMENT_FK_KEY	NUMBER		Warehouse foreign key to the Assignment dimension for the applicant (or direct hire employee) assignment
GRADE_FK_KEY	NUMBER		Warehouse foreign key to the Grade dimension
INSTANCE_FK_KEY	NUMBER		Warehouse foreign key to the Instance dimension
JOB_FK_KEY	NUMBER		Warehouse foreign key to the Job dimension
PERSON_APPLICANT_FK_KEY	NUMBER		Warehouse foreign key to the Person dimension for the applicant (or direct hire employee)
PERSON_AUTHORISER_FK_KEY	NUMBER		Warehouse foreign key to the Person dimension for the person authorizing the recruitment activity
PERSON_CONTACT_FK_KEY	NUMBER		Warehouse foreign key to the Person dimension for the internal contact for the recruitment activity
PERSON_RECRUITER_FK_KEY	NUMBER		Warehouse foreign key to the Person dimension for the vacancy recruiter
POSITION_FK_KEY	NUMBER		Warehouse foreign key to the Position dimension
USER_ATTRIBUTE14	VARCHAR2	(400)	User defined attribute
USER_ATTRIBUTE15	VARCHAR2	(400)	User defined attribute
USER_ATTRIBUTE2	VARCHAR2	(400)	User defined attribute
USER_ATTRIBUTE3	VARCHAR2	(400)	User defined attribute
USER_ATTRIBUTE4	VARCHAR2	(400)	User defined attribute
USER_ATTRIBUTE5	VARCHAR2	(400)	User defined attribute
USER_ATTRIBUTE6	VARCHAR2	(400)	User defined attribute
USER_ATTRIBUTE7	VARCHAR2	(400)	User defined attribute
USER_ATTRIBUTE8	VARCHAR2	(400)	User defined attribute
USER_ATTRIBUTE9	VARCHAR2	(400)	User defined attribute
GEOGRAPHY_FK_KEY	NUMBER		Warehouse foreign key to the Geography dimension
USER_MEASURE1	NUMBER		User defined measure
USER_MEASURE2	NUMBER		User defined measure
USER_MEASURE3	NUMBER		User defined measure
USER_MEASURE4	NUMBER		User defined measure
USER_MEASURE5	NUMBER		User defined measure
AGE_BAND_FK_KEY	NUMBER		Warehouse foreign key to the Age Band dimension for the age of the person at the latest recruitment stage
HIRE_OCCURRED	NUMBER		Indicator taking the value 1 if the applicant is hired or is a direct hire, and 0 otherwise
INTERVIEW1_OCCURRED	NUMBER		Indicator taking the value 1 if the applicant reached the first interview stage, and 0 otherwise
INTERVIEW2_OCCURRED	NUMBER		Indicator taking the value 1 if the applicant reached the second interview stage, and 0 otherwise
LAST_UPDATE_DATE	DATE		Standard who column
OFFER_OCCURRED	NUMBER		Indicator taking the value 1 if the applicant reached the offer stage, and 0 otherwise
PERSON_ID	NUMBER		Hidden Identifier for the person from the data source
RECRUITMENT_GAIN_PK	VARCHAR2	(400)	Textual unique identifier for the Workforce Recruitment fact
RECRUITMENT_GAIN_PK_KEY	NUMBER		Unique warehouse identifier for the Workforce Recruitment fact
USER_FK1_KEY	NUMBER		User defined foreign key
USER_FK2_KEY	NUMBER		User defined foreign key
USER_FK3_KEY	NUMBER		User defined foreign key
USER_FK4_KEY	NUMBER		User defined foreign key
USER_FK5_KEY	NUMBER		User defined foreign key
USER_ATTRIBUTE1	VARCHAR2	(400)	User defined attribute
USER_ATTRIBUTE10	VARCHAR2	(400)	User defined attribute
USER_ATTRIBUTE11	VARCHAR2	(400)	User defined attribute
USER_ATTRIBUTE12	VARCHAR2	(400)	User defined attribute
USER_ATTRIBUTE13	VARCHAR2	(400)	User defined attribute
MOVEMENT_APPLICATION_FK_KEY	NUMBER		Warehouse foreign key to the Movement Type dimension for the application stage
MOVEMENT_INTERVIEW1_FK_KEY	NUMBER		Warehouse foreign key to the Movement Type dimension for the first interview stage
MOVEMENT_INTERVIEW2_FK_KEY	NUMBER		Warehouse foreign key to the Movement Type dimension for the second interview stage
MOVEMENT_OFFER_FK_KEY	NUMBER		Warehouse foreign key to the Movement Type dimension for the offer stage
MOVEMENT_ACCEPT_FK_KEY	NUMBER		Warehouse foreign key to the Movement Type dimension for the offer accepted stage
MOVEMENT_HIRE_FK_KEY	NUMBER		Warehouse foreign key to the Movement Type dimension for the hire stage
MOVEMENT_TERMINATION_FK_KEY	NUMBER		Warehouse foreign key to the Movement Type dimension for the application rejected stage
MOVEMENT_EMPLYMNT_END_FK_KEY	NUMBER		Warehouse foreign key to the Movement Type dimension for the separation stage
REASON_APPLICATION_FK_KEY	NUMBER		Warehouse foreign key to the Reason dimension for the application reason
REASON_INTERVIEW1_FK_KEY	NUMBER		Warehouse foreign key to the Reason dimension for the first interview reason
REASON_INTERVIEW2_FK_KEY	NUMBER		Warehouse foreign key to the Reason dimension for the second interview reason
REASON_OFFER_FK_KEY	NUMBER		Warehouse foreign key to the Reason dimension for the offer reason
REASON_ACCEPT_FK_KEY	NUMBER		Warehouse foreign key to the Reason dimension for the offer accepted reason
REASON_HIRE_FK_KEY	NUMBER		Warehouse foreign key to the Reason dimension for the hire reason
REASON_TERMINATION_FK_KEY	NUMBER		Warehouse foreign key to the Reason dimension for the application rejected reason
REASON_EMPLYMNT_END_FK_KEY	NUMBER		Warehouse foreign key to the Reason dimension for the separation reason
PERSON_ORIGINATOR_FK_KEY	NUMBER		Warehouse foreign key to the Person dimension for the requisition originator
ACCEPT_FAIL_OCCURRED	NUMBER		Indicator taking the value 1 if the application was rejected at the offer accepted stage, and 0 otherwise
APPLICATION_PASS_OCCURRED	NUMBER		Indicator taking the value 1 if the application stage is successful, and 0 otherwise
APPLICATION_FAIL_OCCURRED	NUMBER		Indicator taking the value 1 if the application is rejected at the application stage, and 0 otherwise
APPLICATION_RESULT_PENDING	NUMBER		Indicator taking the value 1 if the application has been received and is being processed, and 0 otherwise
INTERVIEW1_PASS_OCCURRED	NUMBER		Indicator taking the value 1 if the applicant has reached and passed the first interview stage, and 0 otherwise
INTERVIEW1_FAIL_OCCURRED	NUMBER		Indicator taking the value 1 if the application has been rejected at the first interview stage, and 0 otherwise
INTERVIEW1_RESULT_PENDING	NUMBER		Indicator taking the value 1 if the applicant has reached the first interview stage and is awaiting a decision, and 0 otherwise
INTERVIEW2_PASS_OCCURRED	NUMBER		Indicator taking the value 1 if the applicant has reached and passed the second interview stage, and 0 otherwise
INTERVIEW2_FAIL_OCCURRED	NUMBER		Indicator taking the value 1 if the application has been rejected at the second interview stage, and 0 otherwise
INTERVIEW2_RESULT_PENDING	NUMBER		Indicator taking the value 1 if the applicant has reached the second interview stage and is awaiting a decision, and 0 otherwise
OFFER_FAIL_OCCURRED	NUMBER		Indicator taking the value 1 if the application has been rejected at the offer stage, and 0 otherwise
APPLICATION_OCCURRED	NUMBER		Indicator taking the value 1 if the person applied through the recruitment stage process, and 0 if they were hired directly
ACCEPT_RESULT_PENDING	NUMBER		Indicator taking the value 1 if the offer has been accepted but the applicant has not yet been hired, and 0 otherwise
OFFER_RESULT_PENDING	NUMBER		Indicator taking the value 1 if the offer has been made and is awaiting a decision, and 0 otherwise
MOVEMENT_CRRNT_STAGE_FK_KEY	NUMBER		Warehouse foreign key to the Movement Type dimension for the current stage
REASON_CRRNT_STAGE_FK_KEY	NUMBER		Warehouse foreign key to the Reason dimension for the current stage reason
TIME_CRRNT_STAGE_FK_KEY	NUMBER		Warehouse foreign key to the Time dimension for the current stage date

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACCEPT_OCCURRED
,      APPLICANT_FTE
,      APPLICANT_HEADCOUNT
,      APPLICATION_END_DATE
,      APPLICATION_ID
,      APPLICATION_START_DATE
,      APPLICATION_TERMINATED
,      ASSIGNMENT_ID
,      BUSINESS_GROUP_ID
,      CREATION_DATE
,      DAYS_TO_ACCEPT
,      DAYS_TO_END_EMP
,      DAYS_TO_HIRE
,      DAYS_TO_INTERVIEW1
,      DAYS_TO_INTERVIEW2
,      DAYS_TO_OFFER
,      DAYS_TO_TERM_APL
,      END_EMP_OCCURRED
,      FINISHED_VALUE
,      HIRE_DATE
,      PERSON_TYPE_FK_KEY
,      RECRUITMENT_ACTIVITY_FK_KEY
,      VACANCY_FK_KEY
,      SERVICE_BAND_FK_KEY
,      TIME_OFFER_FK_KEY
,      TIME_ACCEPT_FK_KEY
,      TIME_HIRE_FK_KEY
,      TIME_TERMINATION_FK_KEY
,      TIME_EMPLOYMENT_END_FK_KEY
,      ORGANIZATION_ASSGNMNT_FK_KEY
,      ORGANIZATION_CRDNTNG_FK_KEY
,      TIME_APPLICATION_FK_KEY
,      TIME_INTERVIEW1_FK_KEY
,      TIME_INTERVIEW2_FK_KEY
,      ASSIGNMENT_FK_KEY
,      GRADE_FK_KEY
,      INSTANCE_FK_KEY
,      JOB_FK_KEY
,      PERSON_APPLICANT_FK_KEY
,      PERSON_AUTHORISER_FK_KEY
,      PERSON_CONTACT_FK_KEY
,      PERSON_RECRUITER_FK_KEY
,      POSITION_FK_KEY
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      GEOGRAPHY_FK_KEY
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      AGE_BAND_FK_KEY
,      HIRE_OCCURRED
,      INTERVIEW1_OCCURRED
,      INTERVIEW2_OCCURRED
,      LAST_UPDATE_DATE
,      OFFER_OCCURRED
,      PERSON_ID
,      RECRUITMENT_GAIN_PK
,      RECRUITMENT_GAIN_PK_KEY
,      USER_FK1_KEY
,      USER_FK2_KEY
,      USER_FK3_KEY
,      USER_FK4_KEY
,      USER_FK5_KEY
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      MOVEMENT_APPLICATION_FK_KEY
,      MOVEMENT_INTERVIEW1_FK_KEY
,      MOVEMENT_INTERVIEW2_FK_KEY
,      MOVEMENT_OFFER_FK_KEY
,      MOVEMENT_ACCEPT_FK_KEY
,      MOVEMENT_HIRE_FK_KEY
,      MOVEMENT_TERMINATION_FK_KEY
,      MOVEMENT_EMPLYMNT_END_FK_KEY
,      REASON_APPLICATION_FK_KEY
,      REASON_INTERVIEW1_FK_KEY
,      REASON_INTERVIEW2_FK_KEY
,      REASON_OFFER_FK_KEY
,      REASON_ACCEPT_FK_KEY
,      REASON_HIRE_FK_KEY
,      REASON_TERMINATION_FK_KEY
,      REASON_EMPLYMNT_END_FK_KEY
,      PERSON_ORIGINATOR_FK_KEY
,      ACCEPT_FAIL_OCCURRED
,      APPLICATION_PASS_OCCURRED
,      APPLICATION_FAIL_OCCURRED
,      APPLICATION_RESULT_PENDING
,      INTERVIEW1_PASS_OCCURRED
,      INTERVIEW1_FAIL_OCCURRED
,      INTERVIEW1_RESULT_PENDING
,      INTERVIEW2_PASS_OCCURRED
,      INTERVIEW2_FAIL_OCCURRED
,      INTERVIEW2_RESULT_PENDING
,      OFFER_FAIL_OCCURRED
,      APPLICATION_OCCURRED
,      ACCEPT_RESULT_PENDING
,      OFFER_RESULT_PENDING
,      MOVEMENT_CRRNT_STAGE_FK_KEY
,      REASON_CRRNT_STAGE_FK_KEY
,      TIME_CRRNT_STAGE_FK_KEY
FROM HRI.HR_EDW_WRK_RCTMNT_F;

Dependencies

[top of page]

HRI.HR_EDW_WRK_RCTMNT_F does not reference any database object

HRI.HR_EDW_WRK_RCTMNT_F is referenced by following:

APPS: HR_EDW_WRK_RCTMNT_F