GPCHAEZV1_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: GPCH_SI_VARIAN1.EFFDT
5	GPCH_SI_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Insurance Type ID
6	GPCH_SI_ALT_ID	Character(8)	VARCHAR2(8) NOT NULL	Insurance Alternative ID
7	GPCH_SI_PROV_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Provider Type 0=Identify 1=Others 2=UVG-LAA 3=KTG-AMC 4=UVGZ-LAAC 5=FAK-CAF 6=BVG-LPP 7=AHV-AVS 8=LAW-CDS 9=BFS-OFS A=QST-IS B=Write File C=Base AL08 D=GRFI-FRFI E=EO-APG I=BNK_BNQ
8	BEGIN_DT	Date(10)	DATE	Begin Date
9	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
10	GPCH_CALCULATE	Character(1)	VARCHAR2(1) NOT NULL	Calculate A=Active I=Inactive Default Value: A
11	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	END_DT	Date(10)	DATE	end date
14	ENDING_DT_PERIOD	Date(10)	DATE	Ending date of period
15	HIRE_DT	Date(10)	DATE	First Start Date
16	TERMINATION_DT	Date(10)	DATE	Termination Date
17	GPCH_RP_AMOUNT1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate Result Value
18	GPCH_RP_AMOUNT2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate Result Value
19	GPCH_RP_AMOUNT3	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate Result Value
20	GPCH_RP_AMOUNT4	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate Result Value
21	GPCH_RP_AMOUNT5	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate Result Value
22	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description