ATS REQUISITION 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 |
EEO_CATEGORY |
XXX |
VARCHAR2 |
30 |
EEO_CATEGORY_CODE |
XXX |
VARCHAR2 |
3 |
EMPLOYMENT_TYPE |
XXX |
VARCHAR2 |
100 |
FLSA_STATUS |
XXX |
VARCHAR2 |
100 |
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 |
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 |
NUM_OF_OPENINGS |
XXX |
NUMBER |
7,2 |
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 |
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 |
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_CONTACT_4_KRB |
XXX |
VARCHAR2 |
20 |
REQ_CONTACT_4_NAME |
XXX |
VARCHAR2 |
100 |
REQ_CONTACT_4_PRIM_FLAG |
XXX |
VARCHAR2 |
5 |
REQ_CONTACT_4_ROLE |
XXX |
VARCHAR2 |
100 |
REQ_CONTACT_5_KRB |
XXX |
VARCHAR2 |
20 |
REQ_CONTACT_5_NAME |
XXX |
VARCHAR2 |
100 |
REQ_CONTACT_5_PRIM_FLAG |
XXX |
VARCHAR2 |
5 |
REQ_CONTACT_5_ROLE |
XXX |
VARCHAR2 |
100 |
REQ_CONTACT_6_KRB |
XXX |
VARCHAR2 |
20 |
REQ_CONTACT_6_NAME |
XXX |
VARCHAR2 |
100 |
REQ_CONTACT_6_PRIM_FLAG |
XXX |
VARCHAR2 |
5 |
REQ_CONTACT_6_ROLE |
XXX |
VARCHAR2 |
100 |
REQ_CONTACT_7_KRB |
XXX |
VARCHAR2 |
20 |
REQ_CONTACT_7_NAME |
XXX |
VARCHAR2 |
100 |
REQ_CONTACT_7_PRIM_FLAG |
XXX |
VARCHAR2 |
5 |
REQ_CONTACT_7_ROLE |
XXX |
VARCHAR2 |
100 |
REQ_CREATED_ON_DT |
XXX |
DATE |
|
REQ_FOLDER_ACTIVE_DT |
XXX |
DATE |
|
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_STATUS_LOG_ENTRY_TYPE |
XXX |
VARCHAR2 |
100 |
REQ_WORKFLOW |
XXX |
VARCHAR2 |
100 |
SCHOOL_AREA_NAME |
The name of the school or area associated with the DLC. |
VARCHAR2 |
100 |
VISA_SPONSORSHIP_FLAG |
XXX |
VARCHAR2 |
5 |
WAREHOUSE_CREATE_DATE |
XXX |
DATE |
|
WAREHOUSE_UPDATE_DATE |
XXX |
DATE |