ATS CANDIDATE PROFILE Table
View exposing candidate profile records from the Applicant Tracking System, including candidate attributes used for recruiting, screening, and hiring analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESS_1 |
Address 1 as provided by the source. |
VARCHAR2 |
100 |
ADDRESS_2 |
Address 2 as provided by the source. |
VARCHAR2 |
100 |
ADDRESS_3 |
Address 3 as provided by the source. |
VARCHAR2 |
100 |
ATS_RACE_ETHNICITY_CODE |
Code identifying ats race ethnicity. |
VARCHAR2 |
100 |
ATS_RACE_ETHNICITY_DESCR |
Ats race ethnicity descr as provided by the source. |
VARCHAR2 |
100 |
CANDIDATE_CREATED_ON_DT |
Candidate created on dt as provided by the source. |
DATE |
|
CANDIDATE_DISABILITY_STATUS |
Candidate disability status as provided by the source. |
VARCHAR2 |
100 |
CANDIDATE_KEY |
Surrogate key identifying the candidate. |
VARCHAR2 |
50 |
CANDIDATE_POOL |
Candidate pool as provided by the source. |
VARCHAR2 |
100 |
CANDIDATE_PROFILE_ACTIVE_FLAG |
Candidate profile active flag as provided by the source. |
VARCHAR2 |
5 |
CANDIDATE_PROFILE_KEY |
Surrogate key identifying the candidate profile. |
VARCHAR2 |
50 |
CANDIDATE_VETERAN_STATUS |
Candidate veteran status as provided by the source. |
VARCHAR2 |
100 |
CANDIDATE_WORKFLOW_ID |
Business identifier for the candidate workflow. |
VARCHAR2 |
100 |
CAND_APPLIED_ONLINE_DT |
Cand applied online dt as provided by the source. |
DATE |
|
CAND_APPLIED_ONLINE_STATUS |
Cand applied online status as provided by the source. |
VARCHAR2 |
10 |
CELL_PHONE |
Cell phone as provided by the source. |
VARCHAR2 |
25 |
CELL_PHONE_AREA_CODE |
Code identifying cell phone area. |
VARCHAR2 |
25 |
CELL_PHONE_COUNTRY_CODE |
Code identifying cell phone country. |
VARCHAR2 |
25 |
CITY |
City as provided by the source. |
VARCHAR2 |
100 |
COUNTRY |
Country as provided by the source. |
VARCHAR2 |
100 |
CURRENT_EMPLOYEE_FLAG |
Current employee flag as provided by the source. |
VARCHAR2 |
5 |
CURRENT_FOLDER |
Current folder as provided by the source. |
VARCHAR2 |
100 |
DISQUALIFIES_FLAG |
Disqualifies flag as provided by the source. |
VARCHAR2 |
3 |
ETHNICITY_CODE |
Code identifying ethnicity. |
VARCHAR2 |
100 |
ETHNICITY_DESCR |
Ethnicity descr as provided by the source. |
VARCHAR2 |
100 |
FIRST_NAME |
First name as provided by the source. |
VARCHAR2 |
100 |
GENDER |
Gender as provided by the source. |
VARCHAR2 |
50 |
HOME_PHONE |
Home phone as provided by the source. |
VARCHAR2 |
25 |
HOME_PHONE_AREA_CODE |
Code identifying home phone area. |
VARCHAR2 |
25 |
HOME_PHONE_COUNTRY_CODE |
Code identifying home phone country. |
VARCHAR2 |
25 |
LAST_NAME |
Last name as provided by the source. |
VARCHAR2 |
100 |
MIDDLE_INITIAL |
Middle initial as provided by the source. |
VARCHAR2 |
30 |
OFFER_ACCEPT_DT |
Offer accept dt as provided by the source. |
DATE |
|
OTHER_NAME |
Other name as provided by the source. |
VARCHAR2 |
100 |
OTHER_SOURCE_INFO |
Other source info as provided by the source. |
VARCHAR2 |
255 |
POSTING_TITLE |
Posting title as provided by the source. |
VARCHAR2 |
255 |
PREFERRED_NAME |
Preferred name as provided by the source. |
VARCHAR2 |
255 |
REQUISITION_KEY |
Surrogate key identifying the requisition. |
VARCHAR2 |
50 |
SAP_RACE_ETHNICITY_CODE |
Code identifying sap race ethnicity. |
VARCHAR2 |
5 |
SAP_RACE_ETHNICITY_DESCR |
Sap race ethnicity descr as provided by the source. |
VARCHAR2 |
200 |
SOURCE |
Source as provided by the source. |
VARCHAR2 |
100 |
SPECIFIC_SOURCE |
Specific source as provided by the source. |
VARCHAR2 |
255 |
STATE |
State as provided by the source. |
VARCHAR2 |
100 |
SUFFIX |
Suffix as provided by the source. |
VARCHAR2 |
10 |
WAREHOUSE_CREATE_DATE |
Date associated with warehouse create. |
DATE |
|
WAREHOUSE_UPDATE_DATE |
Date associated with warehouse update. |
DATE |
|
WORK_ELIGIBILITY |
Work eligibility as provided by the source. |
VARCHAR2 |
10 |
ZIP_CODE |
Code identifying zip. |
VARCHAR2 |
20 |