HRS_G_JOPST_HST(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | HRS_JOB_OPENING_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 4 | GVT_VA_NBR | Character(27) | VARCHAR2(27) NOT NULL | Vacancy Announcement Number |
| 5 | GVT_USAJOB_FIRST | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 6 | GVT_USAJOB_LAST | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 7 | GVT_DT_ANN_CLOSED | Date(10) | DATE | Date Announcement Closed |
| 8 | GVT_DT_ANN_CL_EXT | Date(10) | DATE | Extended Announcement Close Dt |
| 9 | GVT_DT_ANN_OPENED | Date(10) | DATE | Date Announcement Opened |
| 10 | GVT_DT_ANN_REOPEN | Date(10) | DATE | Date Announcement Re-Opened |
| 11 | GVT_DT_EARLY_CONS | Date(10) | DATE | Early Consideration Date |
| 12 | GVT_DT_LAST_SUBMIT | Date(10) | DATE | Last Dt to Submit Applications |
| 13 | GVT_DT_PRI_PLC_CLR | Date(10) | DATE | Dt Priority Placement Cleared |
| 14 | GVT_RECR_EXAM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Examining
C=Competitive O=Outside the Register S=Pre-Determined Score |
| 15 | GVT_VAC_FIL_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Vacancy Fill Method
C=Case Examining I=Applicant Inventory |
| 16 | GVT_SUMMER_APPT | Character(1) | VARCHAR2(1) NOT NULL |
Summer Appointment
C=Cooperative Education F=Federal Internship Program N=Not Student Opportunity S=Summer Employment T=Student Temporary Educ Program V=Volunteer Service W=University Work Study |
| 17 | GVT_VA_POSN_DESCR | Character(60) | VARCHAR2(60) NOT NULL | Vacancy PositionTitle |
| 18 | GVT_VA_DUTY_LOC | Character(1) | VARCHAR2(1) NOT NULL | Vacancy Duty Location |
| 19 | GVT_RQSN_SAL_FROM | Number(19,6) | DECIMAL(18,6) NOT NULL | Salary Range From |
| 20 | GVT_RQSN_SAL_TO | Number(19,6) | DECIMAL(18,6) NOT NULL | Salary Range To |
| 21 | GRADE_FROM | Character(3) | VARCHAR2(3) NOT NULL |
From Grade
Prompt Table: %SAL_GRD_PRMPT1 |
| 22 | GRADE_TO | Character(3) | VARCHAR2(3) NOT NULL |
To Grade
Prompt Table: %SAL_GRD_PRMPT1 |
| 23 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_HR |
| 24 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 25 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Contact Name |
| 26 | CONTACT_PHONE | Character(12) | VARCHAR2(12) NOT NULL | Contact Phone |
| 27 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |
| 28 | GVT_FORM_REQUEST | Character(1) | VARCHAR2(1) NOT NULL |
Form Request Method
F=Fax I=Internet |
| 29 | GVT_ACCPT_E_RESUME | Character(1) | VARCHAR2(1) NOT NULL |
Accept Electronic Resume?
Y/N Table Edit |
| 30 | GVT_RESUME_FORMAT | Character(3) | VARCHAR2(3) NOT NULL |
Resume Format
001=Generic 002=DOD 003=Justice |
| 31 | GVT_RESUME_EMLADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |
| 32 | GVT_REMARK_CD1 | Character(3) | VARCHAR2(3) NOT NULL | Remark Code 1 |
| 33 | GVT_REMARK_CD2 | Character(3) | VARCHAR2(3) NOT NULL | Remark Code 2 |
| 34 | GVT_REMARK_CD3 | Character(3) | VARCHAR2(3) NOT NULL | Remark Code 3 |
| 35 | GVT_REMARK_CD4 | Character(3) | VARCHAR2(3) NOT NULL | Remark Code 4 |
| 36 | GVT_REMARK_CD5 | Character(3) | VARCHAR2(3) NOT NULL | Remark Code 5 |
| 37 | GVT_REMARK_1 | Character(70) | VARCHAR2(70) NOT NULL | Remark Line 1 |
| 38 | GVT_REMARK_2 | Character(70) | VARCHAR2(70) NOT NULL | Remark Line 2 |
| 39 | GVT_REMARK_3 | Character(70) | VARCHAR2(70) NOT NULL | Remark Line 3 |
| 40 | GVT_REMARK_4 | Character(70) | VARCHAR2(70) NOT NULL | Remark Line 4 |
| 41 | GVT_REMARK_5 | Character(70) | VARCHAR2(70) NOT NULL | Remark Line 5 |
| 42 | GVT_REMARK_6 | Character(70) | VARCHAR2(70) NOT NULL | Remark Line 6 |
| 43 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 44 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 45 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 46 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |