GVT_ERN_PROC_RT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GVT_PAY_PLAN	Character(2)	VARCHAR2(2) NOT NULL	Pay Plan Prompt Table: GVT_PAY_PLAN
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
3	SEQUENCE_NBR	Number(2,0)	SMALLINT NOT NULL	Sequence Number
4	GVT_EARN_PROC_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Earning Process Type CA=Pay Limit - Total Annual CB=Pay Cap - Basic Pay CP=Pay Limit - Premium Pay OT=Overtime
5	GVT_LEO_RULE	Character(1)	VARCHAR2(1) NOT NULL	LEO Rule Y/N Table Edit Default Value: N
6	GVT_LOC_RULE	Character(1)	VARCHAR2(1) NOT NULL	Location Rule Y/N Table Edit Default Value: N
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_LM_ERN_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Pay Plan Default Value: GS Prompt Table: GVT_PAY_PLAN
9	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan Prompt Table: GVT_PAY_PLN_VW
10	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade Prompt Table: GVT_GRADE_VW
11	STEP	Number(2,0)	SMALLINT NOT NULL	Step Prompt Table: GVT_STEP_VW
12	GVT_MULT_FACTOR	Number(3,0)	SMALLINT NOT NULL	Mult. Factor Default Value: 100
13	GVT_PAY_CAP_DISP	Character(1)	VARCHAR2(1) NOT NULL	Disposition D=Defer to following Year F=Forfeit
14	GVT_EMERGENCY	Character(1)	VARCHAR2(1) NOT NULL	Emergency