ATS CANDIDATE PROFILE Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESS_1 |
XXX |
VARCHAR2 |
100 |
ADDRESS_2 |
XXX |
VARCHAR2 |
100 |
ADDRESS_3 |
XXX |
VARCHAR2 |
100 |
ATS_RACE_ETHNICITY_CODE |
XXX |
VARCHAR2 |
100 |
ATS_RACE_ETHNICITY_DESCR |
XXX |
VARCHAR2 |
100 |
CANDIDATE_CREATED_ON_DT |
XXX |
DATE |
|
CANDIDATE_DISABILITY_STATUS |
XXX |
VARCHAR2 |
100 |
CANDIDATE_KEY |
XXX |
VARCHAR2 |
50 |
CANDIDATE_POOL |
XXX |
VARCHAR2 |
100 |
CANDIDATE_PROFILE_ACTIVE_FLAG |
XXX |
VARCHAR2 |
5 |
CANDIDATE_PROFILE_KEY |
XXX |
VARCHAR2 |
50 |
CANDIDATE_VETERAN_STATUS |
XXX |
VARCHAR2 |
100 |
CANDIDATE_WORKFLOW_ID |
XXX |
VARCHAR2 |
100 |
CAND_APPLIED_ONLINE_DT |
XXX |
DATE |
|
CAND_APPLIED_ONLINE_STATUS |
XXX |
VARCHAR2 |
10 |
CELL_PHONE |
The employee's cell phone number. |
VARCHAR2 |
25 |
CELL_PHONE_AREA_CODE |
XXX |
VARCHAR2 |
25 |
CELL_PHONE_COUNTRY_CODE |
XXX |
VARCHAR2 |
25 |
CITY |
City. |
VARCHAR2 |
100 |
COUNTRY |
XXX |
VARCHAR2 |
100 |
CURRENT_EMPLOYEE_FLAG |
XXX |
VARCHAR2 |
5 |
CURRENT_FOLDER |
XXX |
VARCHAR2 |
100 |
DISQUALIFIES_FLAG |
XXX |
VARCHAR2 |
3 |
ETHNICITY_CODE |
XXX |
VARCHAR2 |
100 |
ETHNICITY_DESCR |
XXX |
VARCHAR2 |
100 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
100 |
GENDER |
The person's gender. |
VARCHAR2 |
50 |
HOME_PHONE |
The person's home telephone number. |
VARCHAR2 |
25 |
HOME_PHONE_AREA_CODE |
XXX |
VARCHAR2 |
25 |
HOME_PHONE_COUNTRY_CODE |
XXX |
VARCHAR2 |
25 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
100 |
MIDDLE_INITIAL |
XXX |
VARCHAR2 |
30 |
OFFER_ACCEPT_DT |
XXX |
DATE |
|
OTHER_NAME |
XXX |
VARCHAR2 |
100 |
OTHER_SOURCE_INFO |
XXX |
VARCHAR2 |
255 |
POSTING_TITLE |
XXX |
VARCHAR2 |
255 |
PREFERRED_NAME |
XXX |
VARCHAR2 |
255 |
REQUISITION_KEY |
XXX |
VARCHAR2 |
50 |
SAP_RACE_ETHNICITY_CODE |
XXX |
VARCHAR2 |
5 |
SAP_RACE_ETHNICITY_DESCR |
XXX |
VARCHAR2 |
200 |
SOURCE |
Tells where the information about the person was obtained. |
VARCHAR2 |
100 |
SPECIFIC_SOURCE |
XXX |
VARCHAR2 |
255 |
STATE |
State. |
VARCHAR2 |
100 |
SUFFIX |
Name suffix (e.g., "III", "Jr.", "Sr", etc. |
VARCHAR2 |
10 |
WAREHOUSE_CREATE_DATE |
XXX |
DATE |
|
WAREHOUSE_UPDATE_DATE |
XXX |
DATE |
|
WORK_ELIGIBILITY |
XXX |
VARCHAR2 |
10 |
ZIP_CODE |
The zip code. |
VARCHAR2 |
20 |