This table holds information about referrals
Module: Recruiting
REFERRAL_ID
| 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 |
Copyright © 2019, 2025, Oracle and/or its affiliates.