GPDE_AZ_EE_VW

#	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	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	GPDE_AZ_MODEL_ID	Character(6)	VARCHAR2(6) NOT NULL	OAPT Model Prompt Table: GPDE_AZ_MODEL
5	BGN_DT	Date(10)	DATE NOT NULL	Begin Date
6	END_DT	Date(10)	DATE NOT NULL	end date
7	GPDE_AZ_TYPE	Character(1)	VARCHAR2(1) NOT NULL	OAPT Type 0=No OAPT 1=With Reimbursement 2=Without Reimbursement
8	GPDE_AZ_BLOCKING	Character(1)	VARCHAR2(1) NOT NULL	Blocking Y/N Table Edit Default Value: N
9	GPDE_AZ_SICK_FILL	Character(1)	VARCHAR2(1) NOT NULL	Sick Fill Agreed Y/N Table Edit Default Value: Y
10	GPDE_AZ_EE_AGRMT	Character(1)	VARCHAR2(1) NOT NULL	Agreement Signed Y/N Table Edit Default Value: N
11	GPDE_AZ_RATE1_LAW	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Increase 1 Compulsory in % Default Value: 20
12	GPDE_AZ_RATE2_LAW	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Minimum Net Compulsory in % Default Value: 70
13	GPDE_AZ_RATE2_VOL	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Increase 1 Voluntary in % Default Value: 0
14	GPDE_AZ_SIRATE_LAW	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Increase PI Gross Compulsory % Default Value: 90
15	GPDE_AZ_SIRATE_VOL	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Increase PI Gross Voluntary % Default Value: 0
16	GPDE_AZ_RATE_T1	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Minimum Net Tariff in %
17	GPDE_AZ_PCT_PT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	OAPT Part Time Percentage