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