Source Tracking Dimension
Module: Recruiting
SOURCE_TRACKING_ID
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.