GPDE_RP_TX03_3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
7	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
8	SLICE_END_DT	Date(10)	DATE	Element Slice End Date
9	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
10	PRD_END_DT	Date(10)	DATE	Pay Period End Date
11	GPDE_AL_CPAY_ENDDT	Date(10)	DATE	Current Pay End Date
12	GPDE_AZ_RP_003_11	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Grs Recurr Stat. DA
13	GPDE_AZ_RP_003_12	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Grs Once Stat. DA
14	GPDE_AZ_RP_003_21	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	FT Grs Recurr Stat. DA
15	GPDE_AZ_RP_003_22	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	FT Grs Once Stat. DA
16	GPDE_AZ_RP_003_31	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Statutory DA Recurring Pay
17	GPDE_AZ_RP_003_32	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Stat DA onetime pay
18	GPDE_AZ_RP_003_36	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	OAPT DA Stat. Marchclause
19	GPDE_AZ_RP_001_63	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Statutory Gross Increase
20	GPDE_AZ_RP_002_68	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Stat. Increase Min. Net.
21	GPDE_AZ_RP_011_63	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Gross Increase Vol1
22	GPDE_AZ_RP_012_68	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Minimum Net Increase Vol1
23	GPDE_AZ_RP_013_31	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Vol1 DA recurring pay
24	GPDE_AZ_RP_013_32	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Vol 1 DA Onetime Pay
25	GPDE_AZ_RP_013_36	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	OAPT DA Vol.1 Marchclause
26	GPDE_AZ_RP_021_63	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Gross Increase Vol2
27	GPDE_AZ_RP_022_68	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Minimum Net Increase Vol2
28	GPDE_AZ_RP_023_31	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Vol2 DA recurring pay
29	GPDE_AZ_RP_023_32	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Vol 2 DA Onetime Pay
30	GPDE_AZ_RP_023_36	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	OAPT Marchclause Voluntary 2
31	GPDE_RC_PRT_SIGN	Character(1)	VARCHAR2(1) NOT NULL	PRINT SIGN N=Non Elements in Print Class Y=Only Elements in Print Class
32	BEGIN_DT	Date(10)	DATE	Begin Date
33	GPDE_AZ_RP_S03_31	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick Fill for Stat DA recurr