DW_TA_REFERRALS_D

This table holds information about referrals

Details

Module: Recruiting

Key Columns

REFERRAL_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
REFERRAL_ID NUMBER 38 0 True Referral Identifier
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. Primary Key consisting of Referral identifier
REQUISITION_ID NUMBER 38 0 Requisition Identifier DW_TA_JOB_REQUISITION_D REQUISITION_ID
REFERRER_PERSON_ID NUMBER 38 0 Dimension Identifier DW_PERSON_D PERSON_ID
CANDIDATE_PERSON_ID NUMBER 38 0 Dimension Identifier DW_PERSON_D PERSON_ID
JOB_APPLICATION_ID NUMBER 38 0 Dimension Identifier DW_TA_JOB_APPLICATION_D JOB_APPLICATION_ID
REFERRAL_TYPE_CODE VARCHAR2 32 Dimension Identifier
CANDIDATE_TYPE_CODE VARCHAR2 32 Dimension Identifier
NOTES_CANDIDATE VARCHAR2 999 Attribute