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

TABLE: HRI.HR_EDW_WRK_RCTMNT_FSTG

Object Details
Object Name: HR_EDW_WRK_RCTMNT_FSTG
Object Type: TABLE
Owner: HRI
FND Design Data: TableHRI.HR_EDW_WRK_RCTMNT_FSTG
Subobject Name:
Status: VALID


This is the staging table for the Workforce Recruitment Stage fact. Data from multiple transactional systems is staged here for verification and cleansing before it is loaded into the fact table.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 5
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HR_EDW_WRK_RCTMNT_FSTG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnRECRUITMENT_GAIN_PK
HR_EDW_WRK_RCTMNT_FSTG_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCOLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_FK_KEY NUMBER

Warehouse foreign key to the Assignment dimension for the applicant (or direct hire employee) assignment
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
COLLECTION_STATUS VARCHAR2 (30)
Loading status code for the record
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
ERROR_CODE VARCHAR2 (2000)
Code used to store error messages
FINISHED_VALUE NUMBER

Indicator taking the value 1 if the application has ended (hire or rejection), and 0 otherwise
GEOGRAPHY_FK VARCHAR2 (400)
Textual foreign key to the dimension
GEOGRAPHY_FK_KEY NUMBER

Warehouse foreign key to the Geography dimension
GRADE_FK VARCHAR2 (400)
Textual foreign key to the dimension
GRADE_FK_KEY NUMBER

Warehouse foreign key to the Grade dimension
HIRE_DATE DATE

Hire date, one day after the application end date for successful applications
ACCEPT_OCCURRED NUMBER

Indicator taking the value 1 if the applicant reached the offer accepted stage, and 0 otherwise
AGE_BAND_FK VARCHAR2 (400)
Textual foreign key to the dimension
AGE_BAND_FK_KEY NUMBER

Warehouse foreign key to the Age Band dimension for the age of the person at the latest recruitment stage
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_FK VARCHAR2 (400)
Textual foreign key to the dimension
TIME_HIRE_FK_KEY NUMBER

Warehouse foreign key to the Time dimension for the hire date
TIME_INTERVIEW1_FK VARCHAR2 (400)
Textual foreign key to the dimension
TIME_INTERVIEW1_FK_KEY NUMBER

Warehouse foreign key to the Time dimension for the first interview date
TIME_INTERVIEW2_FK VARCHAR2 (400)
Textual foreign key to the dimension
TIME_INTERVIEW2_FK_KEY NUMBER

Warehouse foreign key to the Time dimension for the second interview date
TIME_OFFER_FK VARCHAR2 (400)
Textual foreign key to the dimension
TIME_OFFER_FK_KEY NUMBER

Warehouse foreign key to the Time dimension for the offer date
TIME_TERMINATED_FK VARCHAR2 (400)
Textual foreign key to the dimension
TIME_TERMINATED_FK_KEY NUMBER

Warehouse foreign key to the Time dimension for the application rejected date
USER_FK1 VARCHAR2 (400)
User defined foreign key
USER_FK1_KEY NUMBER

User defined foreign key
USER_FK2 VARCHAR2 (400)
User defined foreign key
USER_FK2_KEY NUMBER

User defined foreign key
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
USER_FK3 VARCHAR2 (400)
User defined foreign key
USER_FK3_KEY NUMBER

User defined foreign key
USER_FK4 VARCHAR2 (400)
User defined foreign key
USER_FK4_KEY NUMBER

User defined foreign key
USER_FK5 VARCHAR2 (400)
User defined foreign key
USER_FK5_KEY NUMBER

User defined foreign key
USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE10 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE11 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE12 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE13 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE14 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE15 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE6 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE7 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE8 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE9 VARCHAR2 (240)
User defined attribute
MOVEMENT_INTERVIEW1_FK VARCHAR2 (400)
Textual foreign key to the dimension
MOVEMENT_INTERVIEW1_FK_KEY NUMBER

Warehouse foreign key to the Movement Type dimension for the first interview stage
MOVEMENT_INTERVIEW2_FK VARCHAR2 (400)
Textual foreign key to the dimension
MOVEMENT_INTERVIEW2_FK_KEY NUMBER

Warehouse foreign key to the Movement Type dimension for the second interview stage
MOVEMENT_OFFER_FK VARCHAR2 (400)
Textual foreign key to the dimension
MOVEMENT_OFFER_FK_KEY NUMBER

Warehouse foreign key to the Movement Type dimension for the offer stage
MOVEMENT_TERMINATION_FK VARCHAR2 (400)
Textual foreign key to the dimension
MOVEMENT_TERMINATION_FK_KEY NUMBER

Warehouse foreign key to the Movement Type dimension for the application rejected stage
RECRUITMENT_ACTIVITY_FK VARCHAR2 (400)
Textual foreign key to the dimension
RECRUITMENT_ACTIVITY_FK_KEY NUMBER

Warehouse foreign key to the Recruitment Activity dimension
RECRUITMENT_GAIN_PK VARCHAR2 (400)
Textual unique identifier for the Workforce Recruitment fact
REQUEST_ID NUMBER

Identifier used by collection program
REQUISITION_VACANCY_FK VARCHAR2 (400)
Textual foreign key to the dimension
REQUISITION_VACANCY_FK_KEY NUMBER

Warehouse foreign key to the Vacancy dimension
ROW_ID ROWID (10)
Row identifier
SERVICE_BAND_FK VARCHAR2 (400)
Textual foreign key to the 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_ACCEPTED_FK VARCHAR2 (400)
Textual foreign key to the dimension
TIME_ACCEPTED_FK_KEY NUMBER

Warehouse foreign key to the Time dimension for the offer acceptance date
TIME_APPLICATION_FK VARCHAR2 (40)
Textual foreign key to the dimension
TIME_APPLICATION_FK_KEY NUMBER

Warehouse foreign key to the Time dimension for the date the application was received
TIME_EMPLOYMENT_ENDED_FK VARCHAR2 (400)
Textual foreign key to the dimension
TIME_EMPLOYMENT_ENDED_FK_KEY NUMBER

Warehouse foreign key to the Time dimension for the separation date (of a successful applicant)
TIME_HIRE_FK VARCHAR2 (400)
Textual foreign key to the dimension
PERSON_AUTHORISER_FK VARCHAR2 (400)
Textual foreign key to the dimension
PERSON_AUTHORISER_FK_KEY NUMBER

Warehouse foreign key to the Person dimension for the person authorizing the recruitment activity
PERSON_CONTACT_FK VARCHAR2 (400)
Textual foreign key to the dimension
PERSON_CONTACT_FK_KEY NUMBER

Warehouse foreign key to the Person dimension for the internal contact for the recruitment activity
PERSON_ID NUMBER

Hidden Identifier for the person from the data source
PERSON_RECRUITER_FK VARCHAR2 (400)
Textual foreign key to the dimension
PERSON_RECRUITER_FK_KEY NUMBER

Warehouse foreign key to the Person dimension for the vacancy recruiter
PERSON_TYPE_FK VARCHAR2 (400)
Textual foreign key to the dimension
PERSON_TYPE_FK_KEY NUMBER

Warehouse foreign key to the Person Type dimension for the current person type
PLANNED_START_DATE DATE

Reserved for future use
POSITION_FK VARCHAR2 (400)
Textual foreign key to the dimension
POSITION_FK_KEY NUMBER

Warehouse foreign key to the Position dimension
MOVEMENT_ACCEPT_FK VARCHAR2 (400)
Textual foreign key to the dimension
MOVEMENT_ACCEPT_FK_KEY NUMBER

Warehouse foreign key to the Movement Type dimension for the offer accepted stage
MOVEMENT_APPLICATION_FK VARCHAR2 (400)
Textual foreign key to the dimension
MOVEMENT_APPLICATION_FK_KEY NUMBER

Warehouse foreign key to the Movement Type dimension for the application stage
MOVEMENT_EMPLYMNT_END_FK VARCHAR2 (400)
Textual foreign key to the dimension
MOVEMENT_EMPLYMNT_END_FK_KEY NUMBER

Warehouse foreign key to the Movement Type dimension for the separation stage
MOVEMENT_HIRE_FK VARCHAR2 (400)
Textual foreign key to the dimension
MOVEMENT_HIRE_FK_KEY NUMBER

Warehouse foreign key to the Movement Type dimension for the hire stage
HIRE_OCCURRED NUMBER

Indicator taking the value 1 if the applicant is hired or is a direct hire, and 0 otherwise
INSTANCE_FK VARCHAR2 (400)
Textual foreign key to the dimension
INSTANCE_FK_KEY NUMBER

Warehouse foreign key to the Instance dimension
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
JOB_FK VARCHAR2 (400)
Textual foreign key to the dimension
JOB_FK_KEY NUMBER

Warehouse foreign key to the Job dimension
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
OPERATION_CODE VARCHAR2 (30)
Code used by the loader program to determine whether to insert/update/delete this record
ORGNZTN_ASSGNMNT_FK VARCHAR2 (400)
Textual foreign key to the dimension
ORGNZTN_ASSGNMNT_FK_KEY NUMBER

Warehouse foreign key to the Organization dimension for the assignment organization
ORGNZTN_CRDNTNG_FK VARCHAR2 (400)
Textual foreign key to the dimension
ORGNZTN_CRDNTNG_FK_KEY NUMBER

Warehouse foreign key to the Organization dimension for the organization co-ordinating the recruitment activity
PERSON_APPLICANT_FK VARCHAR2 (400)
Textual foreign key to the dimension
PERSON_APPLICANT_FK_KEY NUMBER

Warehouse foreign key to the Person dimension for the applicant (or direct hire employee)
REASON_ACCEPT_FK VARCHAR2 (400)
Textual foreign key to the dimension
REASON_ACCEPT_FK_KEY NUMBER

Warehouse foreign key to the Reason dimension for the offer accepted reason
REASON_APPLICATION_FK VARCHAR2 (400)
Textual foreign key to the dimension
REASON_APPLICATION_FK_KEY NUMBER

Warehouse foreign key to the Reason dimension for the application reason
REASON_EMPLYMNT_END_FK VARCHAR2 (400)
Textual foreign key to the dimension
REASON_EMPLYMNT_END_FK_KEY NUMBER

Warehouse foreign key to the Reason dimension for the separation reason
REASON_HIRE_FK VARCHAR2 (400)
Textual foreign key to the dimension
REASON_HIRE_FK_KEY NUMBER

Warehouse foreign key to the Reason dimension for the hire reason
REASON_INTERVIEW1_FK VARCHAR2 (400)
Textual foreign key to the dimension
REASON_INTERVIEW1_FK_KEY NUMBER

Warehouse foreign key to the Reason dimension for the first interview reason
REASON_INTERVIEW2_FK VARCHAR2 (400)
Textual foreign key to the dimension
REASON_INTERVIEW2_FK_KEY NUMBER

Warehouse foreign key to the Reason dimension for the second interview reason
REASON_OFFER_FK VARCHAR2 (400)
Textual foreign key to the dimension
REASON_OFFER_FK_KEY NUMBER

Warehouse foreign key to the Reason dimension for the offer reason
REASON_TERMINATION_FK VARCHAR2 (400)
Textual foreign key to the dimension
REASON_TERMINATION_FK_KEY NUMBER

Warehouse foreign key to the Reason dimension for the application rejected reason
PERSON_ORIGINATOR_FK VARCHAR2 (400)
Textual foreign key to the dimension
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
OFFER_FAIL_OCCURRED NUMBER

Indicator taking the value 1 if the application has been rejected at the offer 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
INTERVIEW2_PASS_OCCURRED NUMBER

Indicator taking the value 1 if the applicant has reached and passed the second 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
INTERVIEW2_FAIL_OCCURRED NUMBER

Indicator taking the value 1 if the application has been rejected at the second 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_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
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
TIME_CRRNT_STAGE_FK_KEY NUMBER

Warehouse foreign key to the Time dimension for the current stage date
TIME_CRRNT_STAGE_FK VARCHAR2 (400)
Textual foreign key to the dimension
MOVEMENT_CRRNT_STAGE_FK_KEY NUMBER

Warehouse foreign key to the Movement Type dimension for the current stage
MOVEMENT_CRRNT_STAGE_FK VARCHAR2 (400)
Textual foreign key to the dimension
REASON_CRRNT_STAGE_FK_KEY NUMBER

Warehouse foreign key to the Reason dimension for the current stage reason
REASON_CRRNT_STAGE_FK VARCHAR2 (400)
Textual foreign key to the dimension
Query Text

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


SELECT ASSIGNMENT_FK_KEY
,      ASSIGNMENT_ID
,      BUSINESS_GROUP_ID
,      COLLECTION_STATUS
,      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
,      ERROR_CODE
,      FINISHED_VALUE
,      GEOGRAPHY_FK
,      GEOGRAPHY_FK_KEY
,      GRADE_FK
,      GRADE_FK_KEY
,      HIRE_DATE
,      ACCEPT_OCCURRED
,      AGE_BAND_FK
,      AGE_BAND_FK_KEY
,      APPLICANT_FTE
,      APPLICANT_HEADCOUNT
,      APPLICATION_END_DATE
,      APPLICATION_ID
,      APPLICATION_START_DATE
,      APPLICATION_TERMINATED
,      ASSIGNMENT_FK
,      TIME_HIRE_FK_KEY
,      TIME_INTERVIEW1_FK
,      TIME_INTERVIEW1_FK_KEY
,      TIME_INTERVIEW2_FK
,      TIME_INTERVIEW2_FK_KEY
,      TIME_OFFER_FK
,      TIME_OFFER_FK_KEY
,      TIME_TERMINATED_FK
,      TIME_TERMINATED_FK_KEY
,      USER_FK1
,      USER_FK1_KEY
,      USER_FK2
,      USER_FK2_KEY
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      USER_FK3
,      USER_FK3_KEY
,      USER_FK4
,      USER_FK4_KEY
,      USER_FK5
,      USER_FK5_KEY
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      MOVEMENT_INTERVIEW1_FK
,      MOVEMENT_INTERVIEW1_FK_KEY
,      MOVEMENT_INTERVIEW2_FK
,      MOVEMENT_INTERVIEW2_FK_KEY
,      MOVEMENT_OFFER_FK
,      MOVEMENT_OFFER_FK_KEY
,      MOVEMENT_TERMINATION_FK
,      MOVEMENT_TERMINATION_FK_KEY
,      RECRUITMENT_ACTIVITY_FK
,      RECRUITMENT_ACTIVITY_FK_KEY
,      RECRUITMENT_GAIN_PK
,      REQUEST_ID
,      REQUISITION_VACANCY_FK
,      REQUISITION_VACANCY_FK_KEY
,      ROW_ID
,      SERVICE_BAND_FK
,      SERVICE_BAND_FK_KEY
,      TIME_ACCEPTED_FK
,      TIME_ACCEPTED_FK_KEY
,      TIME_APPLICATION_FK
,      TIME_APPLICATION_FK_KEY
,      TIME_EMPLOYMENT_ENDED_FK
,      TIME_EMPLOYMENT_ENDED_FK_KEY
,      TIME_HIRE_FK
,      PERSON_AUTHORISER_FK
,      PERSON_AUTHORISER_FK_KEY
,      PERSON_CONTACT_FK
,      PERSON_CONTACT_FK_KEY
,      PERSON_ID
,      PERSON_RECRUITER_FK
,      PERSON_RECRUITER_FK_KEY
,      PERSON_TYPE_FK
,      PERSON_TYPE_FK_KEY
,      PLANNED_START_DATE
,      POSITION_FK
,      POSITION_FK_KEY
,      MOVEMENT_ACCEPT_FK
,      MOVEMENT_ACCEPT_FK_KEY
,      MOVEMENT_APPLICATION_FK
,      MOVEMENT_APPLICATION_FK_KEY
,      MOVEMENT_EMPLYMNT_END_FK
,      MOVEMENT_EMPLYMNT_END_FK_KEY
,      MOVEMENT_HIRE_FK
,      MOVEMENT_HIRE_FK_KEY
,      HIRE_OCCURRED
,      INSTANCE_FK
,      INSTANCE_FK_KEY
,      INTERVIEW1_OCCURRED
,      INTERVIEW2_OCCURRED
,      JOB_FK
,      JOB_FK_KEY
,      LAST_UPDATE_DATE
,      OFFER_OCCURRED
,      OPERATION_CODE
,      ORGNZTN_ASSGNMNT_FK
,      ORGNZTN_ASSGNMNT_FK_KEY
,      ORGNZTN_CRDNTNG_FK
,      ORGNZTN_CRDNTNG_FK_KEY
,      PERSON_APPLICANT_FK
,      PERSON_APPLICANT_FK_KEY
,      REASON_ACCEPT_FK
,      REASON_ACCEPT_FK_KEY
,      REASON_APPLICATION_FK
,      REASON_APPLICATION_FK_KEY
,      REASON_EMPLYMNT_END_FK
,      REASON_EMPLYMNT_END_FK_KEY
,      REASON_HIRE_FK
,      REASON_HIRE_FK_KEY
,      REASON_INTERVIEW1_FK
,      REASON_INTERVIEW1_FK_KEY
,      REASON_INTERVIEW2_FK
,      REASON_INTERVIEW2_FK_KEY
,      REASON_OFFER_FK
,      REASON_OFFER_FK_KEY
,      REASON_TERMINATION_FK
,      REASON_TERMINATION_FK_KEY
,      PERSON_ORIGINATOR_FK
,      PERSON_ORIGINATOR_FK_KEY
,      ACCEPT_FAIL_OCCURRED
,      OFFER_FAIL_OCCURRED
,      APPLICATION_PASS_OCCURRED
,      APPLICATION_FAIL_OCCURRED
,      APPLICATION_RESULT_PENDING
,      INTERVIEW1_PASS_OCCURRED
,      INTERVIEW2_PASS_OCCURRED
,      INTERVIEW1_FAIL_OCCURRED
,      INTERVIEW2_FAIL_OCCURRED
,      INTERVIEW1_RESULT_PENDING
,      INTERVIEW2_RESULT_PENDING
,      APPLICATION_OCCURRED
,      ACCEPT_RESULT_PENDING
,      OFFER_RESULT_PENDING
,      TIME_CRRNT_STAGE_FK_KEY
,      TIME_CRRNT_STAGE_FK
,      MOVEMENT_CRRNT_STAGE_FK_KEY
,      MOVEMENT_CRRNT_STAGE_FK
,      REASON_CRRNT_STAGE_FK_KEY
,      REASON_CRRNT_STAGE_FK
FROM HRI.HR_EDW_WRK_RCTMNT_FSTG;

Dependencies

[top of page]

HRI.HR_EDW_WRK_RCTMNT_FSTG does not reference any database object

HRI.HR_EDW_WRK_RCTMNT_FSTG is referenced by following:

SchemaAPPS
SynonymHR_EDW_WRK_RCTMNT_FSTG