GVT_WGI_MAN(SQL Table) |
Index Back |
---|---|
WGI Manual Notice |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
4 | GVT_WGI_DUE_DATE | Date(10) | DATE | Within-Grade Increase Due Date |
5 | GVT_PAY_PLAN | Character(2) | VARCHAR2(2) NOT NULL | Pay Plan |
6 | SAL_ADMIN_PLAN | Character(4) | VARCHAR2(4) NOT NULL | Salary Administration Plan |
7 | GRADE | Character(3) | VARCHAR2(3) NOT NULL | Salary Grade |
8 | STEP | Number(2,0) | SMALLINT NOT NULL | Step |
9 | GVT_STEP | Character(2) | VARCHAR2(2) NOT NULL | US Federal Step |
10 | EMPL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Employee Type
E=Exception Hourly H=Hourly N=Not Applicable S=Salaried |
11 | GVT_WGI_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Current WGI Status
A=Approved C=WGI Created D=Denied M=Manual WGI N=WGI Not Applicable P=Postponed W=Waiting WGI Processing |
12 | GVT_PAY_RATE_DETER | Character(1) | VARCHAR2(1) NOT NULL |
Pay Rate Determinant
0=Regular Rate 2=Saved Rate - Indefinite 3=Retained Pay - Spec Rt Adjust 4=Saved Rate - Other 5=Special & Superior Quals 6=Special Rate 7=Superior Qualifications Rate A=Retained Grade - Diff Posn B=Retained Grade - Same Posn C=Critical Position Pay E=Rtnd Grd & Spec Rt - Diff Posn F=Rtnd Grd & Spec Rt - Same Posn J=Retained Pay - Same Position K=Retained Pay - Diff Posn M=Continued IGA Pay M=Continued IGA Pay P=Preserved IGA Pay R=Retained Pay - SES Removal S=Continued SES Basic Pay T=Below the Minimum Rate U=Rtnd Grade & Pay - Same Posn V=Rtnd Grade & Pay - Diff Posn Y=NSPS Retained Pay Z=Border Equalization Allowance |
13 | GVT_WORK_SCHED | Character(1) | VARCHAR2(1) NOT NULL |
Work Schedule
B=Baylor Plan F=Full Time G=Full Time Seasonal I=Intermittent J=Intermittent-Seasonal P=Part Time Q=Part-Time Seasonal R=Part-Time Phased Retiree S=Part-Time Job Sharer T=Part-Time Seasonal Job Sharer |