GVT_WGI_RETRO

#	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 Rcd Nbr
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	GVT_WGI_DUE_DATE	Date(10)	DATE	Within-Grade Increase Due Date
5	EMPL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Employee Type E=Exception Hourly H=Hourly N=Not Applicable S=Salaried
6	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
7	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 P=Preserved IGA Pay R=Retained Pay - SES Removal S=Continued SES Basic Pay U=Rtnd Grade & Pay - Same Posn V=Rtnd Grade & Pay - Diff Posn
8	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 S=Part-Time Job Sharer T=Part-Time Seasonal Job Sharer