HRS_GVA_TRK_HST(SQL Table) |
Index Back |
---|---|
USA Job Tracking Table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). | |
2 | Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number | |
3 | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone | |
4 | Character(27) | VARCHAR2(27) NOT NULL | Vacancy Announcement Number | |
5 | Character(4) | VARCHAR2(4) NOT NULL | Occupational Series | |
6 | Character(1) | VARCHAR2(1) NOT NULL | Occupational Suffix | |
7 | Character(2) | VARCHAR2(2) NOT NULL | Pay Plan | |
8 | Character(4) | VARCHAR2(4) NOT NULL | Duty Location Code 1 | |
9 | Character(4) | VARCHAR2(4) NOT NULL | Duty Location Code 2 | |
10 | Character(4) | VARCHAR2(4) NOT NULL | Duty Location Code 3 | |
11 | GVT_DLOC_OPENINGS1 | Number(4,0) | SMALLINT NOT NULL | # of Vacancies - Duty Loc1 |
12 | GVT_DLOC_OPENINGS2 | Number(4,0) | SMALLINT NOT NULL | # of Vacancies - Duty Loc2 |
13 | GVT_DLOC_OPENINGS3 | Number(4,0) | SMALLINT NOT NULL | # of Vacancies - Duty Loc3 |
14 | GVT_CONTROL_NBR | Character(10) | VARCHAR2(10) NOT NULL | USA Jobs Control Number |
15 | GVT_VA_TEMPLATE | Character(4) | VARCHAR2(4) NOT NULL | Posting Template ID |
16 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
17 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
18 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
19 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |