ATS REQUISITION Table
View exposing requisition records from the Applicant Tracking System, including position request and posting attributes used for recruiting administration and reporting.
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 |
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 |
FLSA_STATUS |
Flsa status as provided by the source. |
VARCHAR2 |
100 |
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 |
MIT_JOB_CODE |
Code identifying mit job. |
VARCHAR2 |
53 |
NUM_OF_OPENINGS |
Num of openings as provided by the source. |
NUMBER |
7,2 |
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 |
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 |
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_CONTACT_4_KRB |
Req contact 4 krb as provided by the source. |
VARCHAR2 |
20 |
REQ_CONTACT_4_NAME |
Req contact 4 name as provided by the source. |
VARCHAR2 |
100 |
REQ_CONTACT_4_PRIM_FLAG |
Req contact 4 prim flag as provided by the source. |
VARCHAR2 |
5 |
REQ_CONTACT_4_ROLE |
Req contact 4 role as provided by the source. |
VARCHAR2 |
100 |
REQ_CONTACT_5_KRB |
Req contact 5 krb as provided by the source. |
VARCHAR2 |
20 |
REQ_CONTACT_5_NAME |
Req contact 5 name as provided by the source. |
VARCHAR2 |
100 |
REQ_CONTACT_5_PRIM_FLAG |
Req contact 5 prim flag as provided by the source. |
VARCHAR2 |
5 |
REQ_CONTACT_5_ROLE |
Req contact 5 role as provided by the source. |
VARCHAR2 |
100 |
REQ_CONTACT_6_KRB |
Req contact 6 krb as provided by the source. |
VARCHAR2 |
20 |
REQ_CONTACT_6_NAME |
Req contact 6 name as provided by the source. |
VARCHAR2 |
100 |
REQ_CONTACT_6_PRIM_FLAG |
Req contact 6 prim flag as provided by the source. |
VARCHAR2 |
5 |
REQ_CONTACT_6_ROLE |
Req contact 6 role as provided by the source. |
VARCHAR2 |
100 |
REQ_CONTACT_7_KRB |
Req contact 7 krb as provided by the source. |
VARCHAR2 |
20 |
REQ_CONTACT_7_NAME |
Req contact 7 name as provided by the source. |
VARCHAR2 |
100 |
REQ_CONTACT_7_PRIM_FLAG |
Req contact 7 prim flag as provided by the source. |
VARCHAR2 |
5 |
REQ_CONTACT_7_ROLE |
Req contact 7 role as provided by the source. |
VARCHAR2 |
100 |
REQ_CREATED_ON_DT |
Req created on dt as provided by the source. |
DATE |
|
REQ_FOLDER_ACTIVE_DT |
Req folder active dt as provided by the source. |
DATE |
|
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_STATUS_LOG_ENTRY_TYPE |
Req status log entry type as provided by the source. |
VARCHAR2 |
100 |
REQ_WORKFLOW |
Req workflow as provided by the source. |
VARCHAR2 |
100 |
SCHOOL_AREA_NAME |
School area name as provided by the source. |
VARCHAR2 |
100 |
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 |