# 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 |  | This column is for Oracle Internal use only. 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, 2025, Oracle and/or its affiliates.