GPDE_RP_AZ01

#	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	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
8	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
9	SLICE_END_DT	Date(10)	DATE	Element Slice End Date
10	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
11	PRD_END_DT	Date(10)	DATE	Pay Period End Date
12	GPDE_AL_CPAY_ENDDT	Date(10)	DATE	Current Pay End Date
13	GPDE_AZ_RP_001_11	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Grs Stat. Grs Inc
14	GPDE_AZ_RP_001_12	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Grs Once Stat. Grs Inc
15	GPDE_AZ_RP_001_53	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Base for Statutory Gross Inc
16	GPDE_AZ_RP_001_63	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Statutory Gross Increase
17	GPDE_AZ_RP_002_11	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Grs Recurr Stat. Min
18	GPDE_AZ_RP_002_12	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Grs Once Stat. Min
19	GPDE_AZ_RP_002_14	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Tax and SI-free Stat.
20	GPDE_AZ_RP_002_17	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculated Parttime Net
21	GPDE_AZ_RP_002_19	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Statutory TotalNet
22	GPDE_AZ_RP_002_21	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	FT Grs Recurr Stat. Min.
23	GPDE_AZ_RP_002_22	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	FT Grs Once Stat. Min.
24	GPDE_AZ_RP_002_28	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Statutory Flat Minimum Net
25	GPDE_AZ_RP_002_68	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Stat. Increase Min. Net.
26	GPDE_AZ_RP_003_11	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Grs Recurr Stat. DA
27	GPDE_AZ_RP_003_12	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Grs Once Stat. DA
28	GPDE_AZ_RP_003_15	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Overtime Pay Stat.
29	GPDE_AZ_RP_003_21	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	FT Grs Recurr Stat. DA
30	GPDE_AZ_RP_003_22	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	FT Grs Once Stat. DA
31	GPDE_AZ_RP_003_31	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Statutory DA Recurring Pay
32	GPDE_AZ_RP_003_32	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Stat DA onetime pay
33	GPDE_AZ_RP_003_36	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	OAPT DA Stat. Marchclause
34	GPDE_AZ_RP_003_41	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Contr. Stat. DA Recurring Pay
35	GPDE_AZ_RP_003_42	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Contr. Stat. DA onetime pay
36	GPDE_AZ_RP_003_46	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Contr. Stat. DA Marchclause
37	GPDE_AZ_RP_003_ATD	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	SIP Gross in OAPT period
38	GPDE_AZ_RP_004_0B	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Time Units Unpaid Sickness
39	GPDE_AZ_RP_004_0C	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Time Units Unpaid Total
40	GPDE_AZ_RP_004_11	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Reducable Payment Amounts
41	GPDE_AZ_RP_004_1A	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Bases of Reducable Payments
42	GPDE_AZ_RP_011_11	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Grs Vol.1 Grs Inc
43	GPDE_AZ_RP_011_12	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Grs Once Vol.1 Grs Inc
44	GPDE_AZ_RP_011_53	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Base for Gross Increase Vol1
45	GPDE_AZ_RP_011_63	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Gross Increase Vol1
46	GPDE_AZ_RP_012_11	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Grs Recurr Vol.1 Min
47	GPDE_AZ_RP_012_12	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Grs Once Vol.1 Min
48	GPDE_AZ_RP_012_14	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Tax and SI-free Vol.1
49	GPDE_AZ_RP_012_17	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculated Parttime Net
50	GPDE_AZ_RP_012_19	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Voluntary 1 Total Net
51	GPDE_AZ_RP_012_21	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	FT Grs Recurr Vol.1 Min.
52	GPDE_AZ_RP_012_22	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	FT Grs Once Vol.1 Min.
53	GPDE_AZ_RP_012_28	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	FT Flat Minimum Net
54	GPDE_AZ_RP_012_68	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Minimum Net Increase Vol1
55	GPDE_AZ_RP_013_31	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Vol1 DA recurring pay
56	GPDE_AZ_RP_013_32	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Vol 1 DA Onetime Pay
57	GPDE_AZ_RP_013_36	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	OAPT DA Vol.1 Marchclause
58	GPDE_AZ_RP_013_41	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Contr. vol.1 DA Recurring Pay
59	GPDE_AZ_RP_013_42	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Contr. vol.1 DA onetime pay
60	GPDE_AZ_RP_013_46	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Contr. vol.1 DA Marchclause
61	GPDE_AZ_RP_013_ATD	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Vol 1 Diff Amounts YTD
62	GPDE_AZ_RP_021_11	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Grs Vol.2 Grs Inc
63	GPDE_AZ_RP_021_12	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Grs Once Vol.2 Grs Inc
64	GPDE_AZ_RP_021_53	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Base for Gross Increase Vol2
65	GPDE_AZ_RP_021_63	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Gross Increase Vol2
66	GPDE_AZ_RP_022_11	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Grs Recurr Vol.2 Min
67	GPDE_AZ_RP_022_12	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Grs Once Vol.2 Min
68	GPDE_AZ_RP_022_14	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Tax and SI-free Vol.2
69	GPDE_AZ_RP_022_17	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculated Parttime Net
70	GPDE_AZ_RP_022_19	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Voluntary 1 Total Net
71	GPDE_AZ_RP_022_21	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	FT Grs Recurr Vol.2 Min.
72	GPDE_AZ_RP_022_22	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	FT Grs Once Vol.2 Min.
73	GPDE_AZ_RP_022_28	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	FT Flat Minimum Net Vol2
74	GPDE_AZ_RP_022_68	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Minimum Net Increase Vol2
75	GPDE_AZ_RP_023_31	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Vol2 DA recurring pay
76	GPDE_AZ_RP_023_32	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Vol 2 DA Onetime Pay
77	GPDE_AZ_RP_023_36	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	OAPT Marchclause Voluntary 2
78	GPDE_AZ_RP_023_41	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Contr. vol.2 DA Recurring Pay
79	GPDE_AZ_RP_023_42	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Contr. vol.2 DA onetime pay
80	GPDE_AZ_RP_023_46	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Contr. vol.2 DA Marchclause
81	GPDE_AZ_RP_023_ATD	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Vol 2 Diff Amounts YTD
82	GPDE_AZ_RP_BBG_ATD	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Yeartodate SIP-Limit in OAPT
83	GPDE_AZ_RP_BBG_MON	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly SIP-Limit for the EE
84	GPDE_AZ_RP_ELG_BON	Character(1)	VARCHAR2(1) NOT NULL	Eligible for AZ Bonus Calculation
85	GPDE_AZ_RP_ELG_FIL	Character(1)	VARCHAR2(1) NOT NULL	Eligible for Sick-Fill in AZ Calculation
86	GPDE_AZ_RP_ELG_MAR	Character(1)	VARCHAR2(1) NOT NULL	Eligible for Marchclause Calculation
87	GPDE_AZ_ELG_LINE10	Character(1)	VARCHAR2(1) NOT NULL	Provide Value in Report Line10 Y/N Table Edit
88	GPDE_AZ_RP_H01_53	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Base for Statutory Gross Inc
89	GPDE_AZ_RP_H01_63	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Statutory Gross Increase
90	GPDE_AZ_RP_H02_68	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Stat. Incr. Minimum Net
91	GPDE_AZ_RP_H03_31	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Unreduced Stat DA recurr
92	GPDE_AZ_RP_MBBG_AT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	ATD Si-Limit last year
93	GPDE_AZ_RP_MRVB_AT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	ATD-Gross Stat. OAPT MCC
94	GPDE_AZ_RP_S01_63	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Stat. Gross Increase
95	GPDE_AZ_RP_S02_68	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Stat. Min. Increase
96	GPDE_AZ_RP_S03_31	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick Fill for Stat DA recurr
97	GPDE_AZ_RP_S03_41	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Cont Sick Fill Stat DA recurr
98	BEGIN_DT	Date(10)	DATE	Begin Date
99	GPDE_AZ_IMODEL1	Character(12)	VARCHAR2(12) NOT NULL	Descr
100	GPDE_AZ_IMODEL2	Character(12)	VARCHAR2(12) NOT NULL	Descr
101	GPDE_AZ_RP_003_CUR	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Real Amount Curr Period
102	GPDE_AZ_RP_003_FRM	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Contributable Frame
103	GPDE_AZ_RP_003_GOA	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Goal for Difference Amt
104	GPDE_AZ_RP_003_LIM	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	ATD SI-Limit
105	GPDE_AZ_RP_003_REA	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Real Amount Contributed
106	GPDE_AZ_RP_003_TDA	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Remaining Diff. Amt.
107	GPDE_AZ_RP_013_CUR	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Real Amount Curr Period
108	GPDE_AZ_RP_013_FRM	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Contributable Frame
109	GPDE_AZ_RP_013_GOA	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Goal for Difference Amt
110	GPDE_AZ_RP_013_LIM	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	ATD SI-Limit
111	GPDE_AZ_RP_013_REA	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Real Amount Contributed
112	GPDE_AZ_RP_013_TDA	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Remaining Diff. Amt.
113	GPDE_AZ_RP_023_CUR	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Real Amount Curr Period
114	GPDE_AZ_RP_023_FRM	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Contributable Frame
115	GPDE_AZ_RP_023_GOA	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Goal for Difference Amt
116	GPDE_AZ_RP_023_LIM	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	ATD SI-Limit
117	GPDE_AZ_RP_023_REA	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Real Amount Contributed
118	GPDE_AZ_RP_023_TDA	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Remaining Diff. Amt.
119	GPDE_AZ_RP_M003_13	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	PT Gross unlimited OAPT MCC
120	GPDE_AZ_RP_M003_15	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Overtime in assignment period
121	GPDE_AZ_RP_M003_23	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	FT Gross unlimited OAPT MCC
122	GPDE_AZ_RP_M003_31	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Statutory DA recurr pay
123	GPDE_AZ_RP_M003_32	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Statutory DA onetime pay
124	GPDE_AZ_RP_M003_CR	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total Real SI Gross unlim. MCC
125	GPDE_AZ_RP_M013_31	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Vol. 1 DA recurring pay
126	GPDE_AZ_RP_M013_32	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Vol. 1 DA onetime pay
127	GPDE_AZ_RP_M023_31	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Vol. 2 DA recurring pay
128	GPDE_AZ_RP_M023_32	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Vol. 2 DA onetime pay
129	GPDE_AZ_RP_H11_53	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Base Vol 1 Grs Inc
130	GPDE_AZ_RP_H11_63	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Vol 1 Grs Inc
131	GPDE_AZ_RP_H12_68	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Vol 1 Minnet
132	GPDE_AZ_RP_H13_31	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Unred Vol 1 DA recurr
133	GPDE_AZ_RP_H21_53	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Base Vol 2 Grs Inc
134	GPDE_AZ_RP_H21_63	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Vol 2 Grs Inc
135	GPDE_AZ_RP_H22_68	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Vol 2 Minnet
136	GPDE_AZ_RP_H23_31	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Unred Vol 2 DA recurr
137	GPDE_AZ_RP_S11_63	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Vol 1 Grs Inc
138	GPDE_AZ_RP_S12_68	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Vol 1 Minnet
139	GPDE_AZ_RP_S13_31	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Vol 1 DA recurr
140	GPDE_AZ_RP_S13_41	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Ctrb Vol 1 DA recurr
141	GPDE_AZ_RP_S21_63	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Vol 2 Grs Inc
142	GPDE_AZ_RP_S22_68	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Vol 2 Minnet
143	GPDE_AZ_RP_S23_31	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Vol 2 DA recurr
144	GPDE_AZ_RP_S23_41	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Ctrb Vol 2 DA recurr
145	GPDE_AZ_RP_T03_31	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Stat DA recurr PKV
146	GPDE_AZ_RP_T03_41	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Ctrb Stat DA rc PKV
147	GPDE_AZ_RP_T13_31	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Vol 1 DA recurr PKV
148	GPDE_AZ_RP_T13_41	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Ctrb Vol 1 DA rc PKV
149	GPDE_AZ_RP_T23_31	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Vol 2 DA recurr PKV
150	GPDE_AZ_RP_T23_41	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sick-Fill Ctrb Vol 2 DA rc PKV