ATS WORKFLOW ACTIVITY Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AAP_JOB_GROUP_CODE |
XXX |
VARCHAR2 |
50 |
AAP_UNIT |
XXX |
VARCHAR2 |
80 |
AAP_UNIT_ID |
XXX |
VARCHAR2 |
8 |
AAP_UNIT_SHORT_NAME |
XXX |
VARCHAR2 |
15 |
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 |
DISQUALIFIES_FLAG |
XXX |
VARCHAR2 |
3 |
EEO_CATEGORY |
XXX |
VARCHAR2 |
30 |
EEO_CATEGORY_CODE |
XXX |
VARCHAR2 |
3 |
EMPLOYMENT_TYPE |
XXX |
VARCHAR2 |
100 |
ETHNICITY_CODE |
XXX |
VARCHAR2 |
100 |
ETHNICITY_DESCR |
XXX |
VARCHAR2 |
100 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
100 |
FLSA_STATUS |
XXX |
VARCHAR2 |
100 |
FROM_FOLDER |
XXX |
VARCHAR2 |
50 |
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 |
HOURS_PER_WEEK |
XXX |
VARCHAR2 |
50 |
HR_DEPARTMENT_CODE |
Department number, such as HR-871000 |
VARCHAR2 |
103 |
HR_DEPARTMENT_NAME |
Name of the department, school, center, or lab. |
VARCHAR2 |
200 |
HR_OFFICER_NAME |
XXX |
VARCHAR2 |
100 |
HR_ORG_UNIT_ID |
8-digit unique number generated by SAP for each org unit. All levels within the HR org hierarcy (e.g. school, department, sub-department) are assigned an HR Org Unit ID. |
VARCHAR2 |
8 |
HR_ORG_UNIT_TITLE |
Name of the department, school, center, or lab. (Known as Org Units in SAP.) |
VARCHAR2 |
75 |
JOB_GROUP |
XXX |
VARCHAR2 |
30 |
JOB_GROUP_CODE |
XXX |
VARCHAR2 |
2 |
JOB_ID |
The SAP 8-digit object id assigned to the job. |
VARCHAR2 |
8 |
JOB_TITLE |
In MIT's HR tables this field contains the official MIT job Title. This title is tied to the Job ID, and can only be changed by the Compensation Office. |
VARCHAR2 |
40 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
100 |
MIDDLE_INITIAL |
XXX |
VARCHAR2 |
30 |
MIT_JOB_CODE |
Indicates the job code used by Human Resources. For admin and support staff jobs, the codes include the level of the job (e.g. HR-QG034, HR-04FN01). |
VARCHAR2 |
53 |
MOVED_BY_USER |
XXX |
VARCHAR2 |
100 |
MOVED_DT |
XXX |
DATE |
|
NUM_OF_OPENINGS |
XXX |
NUMBER |
7,2 |
OFFER_ACCEPT_DT |
XXX |
DATE |
|
ORG_HIER_SCHOOL_AREA_CODE |
XXX |
VARCHAR2 |
8 |
ORG_HIER_SCHOOL_AREA_NAME |
Identifies the school, ie. School of Humanities. |
VARCHAR2 |
75 |
ORG_UNIT_ID |
XXX |
VARCHAR2 |
8 |
OTHER_NAME |
XXX |
VARCHAR2 |
100 |
OTHER_SOURCE_INFO |
XXX |
VARCHAR2 |
255 |
PAYROLL_CATEGORY |
XXX |
VARCHAR2 |
100 |
PCT_TIME |
XXX |
VARCHAR2 |
20 |
PERSON_BEING_REPLACED |
XXX |
VARCHAR2 |
200 |
POSITION_ID |
This is an 8-digit unique number generated by SAP and is specific to each position. |
VARCHAR2 |
50 |
POSTING_JOB_TITLE |
XXX |
VARCHAR2 |
200 |
POSTING_TITLE |
XXX |
VARCHAR2 |
100 |
PREFERRED_NAME |
XXX |
VARCHAR2 |
255 |
REASON_POSITION_OPEN |
XXX |
VARCHAR2 |
100 |
RECRUITER_SUPPORT_FLAG |
XXX |
VARCHAR2 |
5 |
REQUISITION_KEY |
XXX |
VARCHAR2 |
50 |
REQ_CONTACT_1_KRB |
XXX |
VARCHAR2 |
20 |
REQ_CONTACT_1_NAME |
XXX |
VARCHAR2 |
100 |
REQ_CONTACT_1_PRIM_FLAG |
XXX |
VARCHAR2 |
5 |
REQ_CONTACT_1_ROLE |
XXX |
VARCHAR2 |
100 |
REQ_CONTACT_2_KRB |
XXX |
VARCHAR2 |
20 |
REQ_CONTACT_2_NAME |
XXX |
VARCHAR2 |
100 |
REQ_CONTACT_2_PRIM_FLAG |
XXX |
VARCHAR2 |
5 |
REQ_CONTACT_2_ROLE |
XXX |
VARCHAR2 |
100 |
REQ_CONTACT_3_KRB |
XXX |
VARCHAR2 |
20 |
REQ_CONTACT_3_NAME |
XXX |
VARCHAR2 |
100 |
REQ_CONTACT_3_PRIM_FLAG |
XXX |
VARCHAR2 |
5 |
REQ_CONTACT_3_ROLE |
XXX |
VARCHAR2 |
100 |
REQ_CREATED_ON_DT |
XXX |
DATE |
|
REQ_INFO |
XXX |
VARCHAR2 |
500 |
REQ_IS_ACTIVE_FLAG |
XXX |
VARCHAR2 |
5 |
REQ_STATUS |
XXX |
VARCHAR2 |
100 |
REQ_STATUS_ACTIVITY_ID |
XXX |
VARCHAR2 |
50 |
REQ_STATUS_AFTER |
XXX |
VARCHAR2 |
100 |
REQ_STATUS_BEFORE |
XXX |
VARCHAR2 |
100 |
REQ_STATUS_CHANGE_DT |
XXX |
DATE |
|
REQ_WORKFLOW |
XXX |
VARCHAR2 |
100 |
SAP_RACE_ETHNICITY_CODE |
XXX |
VARCHAR2 |
5 |
SAP_RACE_ETHNICITY_DESCR |
XXX |
VARCHAR2 |
200 |
SCHOOL_AREA_NAME |
The name of the school or area associated with the DLC. |
VARCHAR2 |
100 |
SOURCE |
Tells where the information about the person was obtained. |
VARCHAR2 |
100 |
SOURCE_REQUISITION_KEY |
XXX |
VARCHAR2 |
50 |
SPECIFIC_SOURCE |
XXX |
VARCHAR2 |
255 |
STATE |
State. |
VARCHAR2 |
100 |
STEP |
XXX |
VARCHAR2 |
50 |
STEP_NUMBER |
XXX |
VARCHAR2 |
5 |
STEP_RANK_DESC |
XXX |
NUMBER |
19 |
SUFFIX |
Name suffix (e.g., "III", "Jr.", "Sr", etc. |
VARCHAR2 |
10 |
TO_FOLDER |
XXX |
VARCHAR2 |
50 |
VISA_SPONSORSHIP_FLAG |
XXX |
VARCHAR2 |
5 |
WAREHOUSE_CREATE_DATE |
XXX |
DATE |
|
WAREHOUSE_UPDATE_DATE |
XXX |
DATE |
|
WF_COMMENT |
XXX |
VARCHAR2 |
255 |
WORKFLOW_ACTIVITY_KEY |
XXX |
VARCHAR2 |
50 |
WORK_ELIGIBILITY |
XXX |
VARCHAR2 |
10 |
ZIP_CODE |
The zip code. |
VARCHAR2 |
20 |