JOB_REQUIS_TAO(SQL Table) |
Index Back |
|---|---|
Job Requisition CodesUse JOB_REQUISITION to record information for job requisitons such as job code, department, position ID, authorization data, status, and status dates. This data is used primarily in Recruitment. You can create only one JOB_REQUISITION record per requisition. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JOB_REQ_NBR | Character(6) | VARCHAR2(6) NOT NULL | Job requisition number |
| 2 | STATUS_DT | Date(10) | DATE | Status Date |
| 3 | STATUS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Identifies a status. |
| 4 | OPEN_DT | Date(10) | DATE | Created |
| 5 | CLOSE_DT | Date(10) | DATE | Date Closed |
| 6 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 9 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 10 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 11 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 12 | ORIGINATOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Originator's ID |
| 13 | AUTHORIZATION_ID | Character(11) | VARCHAR2(11) NOT NULL | Authorization ID |
| 14 | AUTHORIZATION_DT | Date(10) | DATE | Date Authorized |
| 15 | REQ_NEW_POSN | Character(1) | VARCHAR2(1) NOT NULL | New position |
| 16 | RECRUITER_ID | Character(11) | VARCHAR2(11) NOT NULL | Recruiter ID |
| 17 | JOB_POSTING_ID | Character(6) | VARCHAR2(6) NOT NULL | Job posting ID |
| 18 | OPENINGS_CNT | Number(3,0) | SMALLINT NOT NULL | Tracks number of openings |
| 19 | OPENINGS_TARGET | Number(3,0) | SMALLINT NOT NULL | Tracks number of target openings |
| 20 | REG_TEMP | Character(1) | VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular T=Temporary |
| 21 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 22 | END_DT | Date(10) | DATE | end date |
| 23 | FULL_PART_TIME | Character(1) | VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand F=Full-Time P=Part-Time |
| 24 | DESIRED_START_DT | Date(10) | DATE | Desired Start Date |
| 25 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |
| 26 | STD_HRS_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL | Standard Work Period |
| 27 | SHIFT | Character(1) | VARCHAR2(1) NOT NULL |
Regular Shift
1=Day 2=Evening 3=Night A=Any C=Compressed N=Not Applicable R=Rotating |
| 28 | SAL_ADMIN_PLAN | Character(4) | VARCHAR2(4) NOT NULL | Salary Administration Plan |
| 29 | GRADE_FROM | Character(3) | VARCHAR2(3) NOT NULL | From Grade |
| 30 | STEP_FROM | Number(2,0) | SMALLINT NOT NULL | Step |
| 31 | GRADE_TO | Character(3) | VARCHAR2(3) NOT NULL | To Grade |
| 32 | STEP_TO | Number(2,0) | SMALLINT NOT NULL | Step |
| 33 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |
| 34 | WC_COUNCIL_ID | Character(9) | VARCHAR2(9) NOT NULL | Works Council ID |
| 35 | ENCUMB_DT_INDC | Character(1) | VARCHAR2(1) NOT NULL |
Encumbrance Date Indicator
A=Authorization Date P=Project Fill Date |
| 36 | PROJECTED_FILL_DT | Date(10) | DATE | Projected Fill Date |
| 37 | TRAVELLING | Character(1) | VARCHAR2(1) NOT NULL |
Willing to Travel
N=No Y=Yes |
| 38 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department Set ID |
| 39 | RECRUITER_NAME | Character(50) | VARCHAR2(50) NOT NULL | Recruiter Name |
| 40 | RECRUITMT_OPEN_DT | Date(10) | DATE | Recruitment Opens |
| 41 | RECRUITMT_CLOSE_DT | Date(10) | DATE | Recruitment Closes |
| 42 | INTERNAL_DT | Date(10) | DATE | Posted Internally |
| 43 | INTERNAL_EXP_DT | Date(10) | DATE | Internal Posting Expires |
| 44 | EXTERNAL_DT | Date(10) | DATE | Posted Externally |
| 45 | EXTERNAL_EXP_DT | Date(10) | DATE | External Posting Expires |
| 46 | CONTACT_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Contact - Vacancy Announcement |
| 47 | GVT_CONSIDER_AREA | Character(1) | VARCHAR2(1) NOT NULL |
Area of Consideration
A=Agency E=External Government F=Federal Government N=Nationwide S=Subagency W=Worldwide |
| 48 | GVT_PROP_START_DT | Date(10) | DATE | Proposed Start Dt |
| 49 | GVT_WIP_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Work-in-Progress Status
Default Value: REQ Prompt Table: GVT_WIP_STS_VW |
| 50 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 51 | CITIZENSHIP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Citizenship Status
Prompt Table: CITIZEN_STS_TBL |
| 52 | GVT_DRAFT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Draft Status
N=Not Yet Registered R=Registered X=Not Applicable |
| 53 | GVT_POSN_OCCUPIED | Character(1) | VARCHAR2(1) NOT NULL |
Position Occupied
1=Competitive 2=Excepted 3=SES General 4=SES Career Reserved |
| 54 | GVT_RECR_OFFICE | Character(6) | VARCHAR2(6) NOT NULL | Recruiting Office |
| 55 | GVT_RECR_OFF_RMKS | Character(254) | VARCHAR2(254) NOT NULL | Recruiting Office Remarks |
| 56 | GVT_RQSN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Requisition Type
I=Internal M=Merit Promotion O=Open Competition Default Value: O |
| 57 | GVT_SEL_OFFICIAL | Character(11) | VARCHAR2(11) NOT NULL |
Selecting Official
Prompt Table: PERS_DTA_EMP_VW |
| 58 | GVT_STAFF_SPCLST | Character(11) | VARCHAR2(11) NOT NULL |
Staffing Specialist
Prompt Table: PERS_DTA_EMP_VW |
| 59 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 60 | FAX | Character(24) | VARCHAR2(24) NOT NULL | Fax Number |
| 61 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |
| 62 | MAX_AGE | Number(3,0) | SMALLINT NOT NULL | Maximum age for employee benefits |
| 63 | MIN_AGE | Number(3,0) | SMALLINT NOT NULL | Minimum age for employee benefits |
| 64 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown |
| 65 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 66 | COMMENTS | Long Character | CLOB | Comment |
| 67 | TRAVEL_PERCENT | Number(3,0) | SMALLINT NOT NULL | Percentage Travel |
| 68 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 69 | APPROVAL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval status
A=All Approved D=Denied P=In Approval Process U=Needs Approval |