ATS WORKFLOW ACTIVITY Table
View exposing workflow activity records from the Applicant Tracking System, including candidate movement through recruiting steps and related hiring process activity.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AAP_JOB_GROUP_CODE |
Code identifying aap job group. |
VARCHAR2 |
50 |
AAP_UNIT |
Aap unit as provided by the source. |
VARCHAR2 |
80 |
AAP_UNIT_ID |
Business identifier for the aap unit. |
VARCHAR2 |
8 |
AAP_UNIT_SHORT_NAME |
Aap unit short name as provided by the source. |
VARCHAR2 |
15 |
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 |
DISQUALIFIES_FLAG |
Disqualifies flag as provided by the source. |
VARCHAR2 |
3 |
EEO_CATEGORY |
Eeo category as provided by the source. |
VARCHAR2 |
30 |
EEO_CATEGORY_CODE |
Code identifying eeo category. |
VARCHAR2 |
3 |
EMPLOYMENT_TYPE |
Employment type as provided by the source. |
VARCHAR2 |
100 |
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 |
FLSA_STATUS |
Flsa status as provided by the source. |
VARCHAR2 |
100 |
FROM_FOLDER |
From folder as provided by the source. |
VARCHAR2 |
50 |
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 |
HOURS_PER_WEEK |
Hours per week as provided by the source. |
VARCHAR2 |
50 |
HR_DEPARTMENT_CODE |
Code identifying hr department. |
VARCHAR2 |
103 |
HR_DEPARTMENT_NAME |
Hr department name as provided by the source. |
VARCHAR2 |
200 |
HR_OFFICER_NAME |
Hr officer name as provided by the source. |
VARCHAR2 |
100 |
HR_ORG_UNIT_ID |
Business identifier for the hr org unit. |
VARCHAR2 |
8 |
HR_ORG_UNIT_TITLE |
Hr org unit title as provided by the source. |
VARCHAR2 |
75 |
JOB_GROUP |
Job group as provided by the source. |
VARCHAR2 |
30 |
JOB_GROUP_CODE |
Code identifying job group. |
VARCHAR2 |
2 |
JOB_ID |
Business identifier for the job. |
VARCHAR2 |
8 |
JOB_TITLE |
Job title as provided by the source. |
VARCHAR2 |
40 |
LAST_NAME |
Last name as provided by the source. |
VARCHAR2 |
100 |
MIDDLE_INITIAL |
Middle initial as provided by the source. |
VARCHAR2 |
30 |
MIT_JOB_CODE |
Code identifying mit job. |
VARCHAR2 |
53 |
MOVED_BY_USER |
Moved by user as provided by the source. |
VARCHAR2 |
100 |
MOVED_DT |
Moved dt as provided by the source. |
DATE |
|
NUM_OF_OPENINGS |
Num of openings as provided by the source. |
NUMBER |
7,2 |
OFFER_ACCEPT_DT |
Offer accept dt as provided by the source. |
DATE |
|
ORG_HIER_SCHOOL_AREA_CODE |
Code identifying org hier school area. |
VARCHAR2 |
8 |
ORG_HIER_SCHOOL_AREA_NAME |
Org hier school area name as provided by the source. |
VARCHAR2 |
75 |
ORG_UNIT_ID |
Business identifier for the org unit. |
VARCHAR2 |
8 |
OTHER_NAME |
Other name as provided by the source. |
VARCHAR2 |
100 |
OTHER_SOURCE_INFO |
Other source info as provided by the source. |
VARCHAR2 |
255 |
PAYROLL_CATEGORY |
Payroll category as provided by the source. |
VARCHAR2 |
100 |
PCT_TIME |
Pct time as provided by the source. |
VARCHAR2 |
20 |
PERSON_BEING_REPLACED |
Person being replaced as provided by the source. |
VARCHAR2 |
200 |
POSITION_ID |
Business identifier for the position. |
VARCHAR2 |
50 |
POSTING_JOB_TITLE |
Posting job title as provided by the source. |
VARCHAR2 |
200 |
POSTING_TITLE |
Posting title as provided by the source. |
VARCHAR2 |
100 |
PREFERRED_NAME |
Preferred name as provided by the source. |
VARCHAR2 |
255 |
REASON_POSITION_OPEN |
Reason position open as provided by the source. |
VARCHAR2 |
100 |
RECRUITER_SUPPORT_FLAG |
Recruiter support flag as provided by the source. |
VARCHAR2 |
5 |
REQUISITION_KEY |
Surrogate key identifying the requisition. |
VARCHAR2 |
50 |
REQ_CONTACT_1_KRB |
Req contact 1 krb as provided by the source. |
VARCHAR2 |
20 |
REQ_CONTACT_1_NAME |
Req contact 1 name as provided by the source. |
VARCHAR2 |
100 |
REQ_CONTACT_1_PRIM_FLAG |
Req contact 1 prim flag as provided by the source. |
VARCHAR2 |
5 |
REQ_CONTACT_1_ROLE |
Req contact 1 role as provided by the source. |
VARCHAR2 |
100 |
REQ_CONTACT_2_KRB |
Req contact 2 krb as provided by the source. |
VARCHAR2 |
20 |
REQ_CONTACT_2_NAME |
Req contact 2 name as provided by the source. |
VARCHAR2 |
100 |
REQ_CONTACT_2_PRIM_FLAG |
Req contact 2 prim flag as provided by the source. |
VARCHAR2 |
5 |
REQ_CONTACT_2_ROLE |
Req contact 2 role as provided by the source. |
VARCHAR2 |
100 |
REQ_CONTACT_3_KRB |
Req contact 3 krb as provided by the source. |
VARCHAR2 |
20 |
REQ_CONTACT_3_NAME |
Req contact 3 name as provided by the source. |
VARCHAR2 |
100 |
REQ_CONTACT_3_PRIM_FLAG |
Req contact 3 prim flag as provided by the source. |
VARCHAR2 |
5 |
REQ_CONTACT_3_ROLE |
Req contact 3 role as provided by the source. |
VARCHAR2 |
100 |
REQ_CREATED_ON_DT |
Req created on dt as provided by the source. |
DATE |
|
REQ_INFO |
Req info as provided by the source. |
VARCHAR2 |
500 |
REQ_IS_ACTIVE_FLAG |
Req is active flag as provided by the source. |
VARCHAR2 |
5 |
REQ_STATUS |
Req status as provided by the source. |
VARCHAR2 |
100 |
REQ_STATUS_ACTIVITY_ID |
Business identifier for the req status activity. |
VARCHAR2 |
50 |
REQ_STATUS_AFTER |
Req status after as provided by the source. |
VARCHAR2 |
100 |
REQ_STATUS_BEFORE |
Req status before as provided by the source. |
VARCHAR2 |
100 |
REQ_STATUS_CHANGE_DT |
Req status change dt as provided by the source. |
DATE |
|
REQ_WORKFLOW |
Req workflow as provided by the source. |
VARCHAR2 |
100 |
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 |
SCHOOL_AREA_NAME |
School area name as provided by the source. |
VARCHAR2 |
100 |
SOURCE |
Source as provided by the source. |
VARCHAR2 |
100 |
SOURCE_REQUISITION_KEY |
Surrogate key identifying the source requisition. |
VARCHAR2 |
50 |
SPECIFIC_SOURCE |
Specific source as provided by the source. |
VARCHAR2 |
255 |
STATE |
State as provided by the source. |
VARCHAR2 |
100 |
STEP |
Step as provided by the source. |
VARCHAR2 |
50 |
STEP_NUMBER |
Step number as provided by the source. |
VARCHAR2 |
5 |
STEP_RANK_DESC |
Description of step rank. |
NUMBER |
19 |
SUFFIX |
Suffix as provided by the source. |
VARCHAR2 |
10 |
TO_FOLDER |
To folder as provided by the source. |
VARCHAR2 |
50 |
VISA_SPONSORSHIP_FLAG |
Visa sponsorship flag as provided by the source. |
VARCHAR2 |
5 |
WAREHOUSE_CREATE_DATE |
Date associated with warehouse create. |
DATE |
|
WAREHOUSE_UPDATE_DATE |
Date associated with warehouse update. |
DATE |
|
WF_COMMENT |
Wf comment as provided by the source. |
VARCHAR2 |
255 |
WORKFLOW_ACTIVITY_KEY |
Surrogate key identifying the workflow activity. |
VARCHAR2 |
50 |
WORK_ELIGIBILITY |
Work eligibility as provided by the source. |
VARCHAR2 |
10 |
ZIP_CODE |
Code identifying zip. |
VARCHAR2 |
20 |