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 | 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, 2023, Oracle and/or its affiliates.