DW_TA_SOURCE_TRACKING_D

Source Tracking Dimension

Details

Module: Recruiting

Key Columns

SOURCE_TRACKING_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SOURCE_TRACKING_ID NUMBER 38 0 True Unique key for the Source tracking table.    
SOURCE_RECORD_ID NUMBER 38 0   Primary Key    
SOURCE_LEVEL VARCHAR2 32     will contain the source level value for the given record    
DIMENSION_ID NUMBER 38 0   Foreign key to the Dimension table DW_TA_SOURCE_DIMENSION_D DIMENSION_ID
REQUISITION_ID NUMBER 38 0   Foreign key to the Requisition table DW_TA_JOB_REQUISITION_D REQUISITION_ID
JOB_APPLICATION_ID NUMBER 38 0   Foreign key to the DW_TA_JOB_APPLICATION_D table DW_TA_JOB_APPLICATION_D JOB_APPLICATION_ID
REFERRAL_ID NUMBER 38 0   Foreign key to the Referrals table DW_TA_REFERRALS_D REFERRAL_ID
RECRUITER_ID NUMBER 38 0   Foreign key to the Person table DW_PERSON_D PERSON_ID
CANDIDATE_NUMBER VARCHAR2 32     The person id related to the internal candidate.    

Copyright © 2019, 2022, Oracle and/or its affiliates.