GVT_PAY_PLAN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GVT_PAY_PLAN	Character(2)	VARCHAR2(2) NOT NULL	Pay Plan
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
6	GVT_AUTO_WGI	Character(1)	VARCHAR2(1) NOT NULL	Auto Within Grade Increase Y/N Table Edit Default Value: Y
7	GVT_CLASS_AUTH	Character(2)	VARCHAR2(2) NOT NULL	Classification Authority 05=Title 5, Other 38=Title 38, United States Code GE=Equivalent to GS Class System GS=Title 5, GS Class System WE=Equivalent to Title 5 FWS WG=Title 5, Prevailing Rate Sys Default Value: GS
8	GVT_IGA_PAY	Character(1)	VARCHAR2(1) NOT NULL	Interim Geographic Adjustment Y/N Table Edit Default Value: N
9	GVT_LEO_PAY	Character(1)	VARCHAR2(1) NOT NULL	Law Enforcement Officer Pay Y/N Table Edit Default Value: N
10	GVT_LOCALITY_PAY	Character(1)	VARCHAR2(1) NOT NULL	Locality Adjusted Pay Y/N Table Edit Default Value: N
11	GVT_PREMIUM_PAY	Character(1)	VARCHAR2(1) NOT NULL	Premium Pay Y/N Table Edit Default Value: N
12	GVT_SAL_STEP_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Non-Numeric Steps Y/N Table Edit Default Value: N
13	GVT_BW_LIM_OK_PAY	Character(1)	VARCHAR2(1) NOT NULL	OK to Pay Y/N Table Edit Default Value: N
14	ERNCD_SPCL	Character(3)	VARCHAR2(3) NOT NULL	Special Accumulator Code Prompt Table: SPCL_EARNS_TBL
15	GVT_FEGLI_ACCUM	Character(3)	VARCHAR2(3) NOT NULL	Field used to store Special FEGLI Accum Prompt Table: GVT_ERN_SPCL_VW
16	GVT_PAY_LIMIT_REQ	Character(1)	VARCHAR2(1) NOT NULL	Pay Limit Check Required Y/N Table Edit Default Value: N
17	GVT_NIGHT_DIFF_ACC	Character(3)	VARCHAR2(3) NOT NULL	Night differential accumulator. Prompt Table: GVT_ERN_SPCL_VW