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   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