GPDE_RP_AZ01_VW

(SQL View)
 Index Back

WA Record for AZ

WA Record for AZ

SELECT A.EMPLID ,A.CAL_RUN_ID ,A.EMPL_RCD ,A.GP_PAYGROUP ,A.CAL_ID ,A.ORIG_CAL_RUN_ID ,A.RSLT_SEG_NUM ,A.SEG_END_DT ,A.SLICE_END_DT ,A.PAY_ENTITY ,A.PRD_END_DT ,A.GPDE_AL_CPAY_ENDDT ,A.GPDE_AZ_RP_001_11 ,A.GPDE_AZ_RP_001_12 ,A.GPDE_AZ_RP_001_53 ,A.GPDE_AZ_RP_001_63 ,A.GPDE_AZ_RP_002_11 ,A.GPDE_AZ_RP_002_12 ,A.GPDE_AZ_RP_002_14 ,A.GPDE_AZ_RP_002_17 ,A.GPDE_AZ_RP_002_19 ,A.GPDE_AZ_RP_002_21 ,A.GPDE_AZ_RP_002_22 ,A.GPDE_AZ_RP_002_28 ,A.GPDE_AZ_RP_002_68 ,A.GPDE_AZ_RP_003_11 ,A.GPDE_AZ_RP_003_12 ,A.GPDE_AZ_RP_003_15 ,A.GPDE_AZ_RP_003_21 ,A.GPDE_AZ_RP_003_22 ,A.GPDE_AZ_RP_003_31 ,A.GPDE_AZ_RP_003_32 ,A.GPDE_AZ_RP_003_36 ,A.GPDE_AZ_RP_003_41 ,A.GPDE_AZ_RP_003_42 ,A.GPDE_AZ_RP_003_46 ,A.GPDE_AZ_RP_003_ATD ,A.GPDE_AZ_RP_004_0B ,A.GPDE_AZ_RP_004_0C ,A.GPDE_AZ_RP_004_11 ,A.GPDE_AZ_RP_004_1A ,A.GPDE_AZ_RP_011_11 ,A.GPDE_AZ_RP_011_12 ,A.GPDE_AZ_RP_011_53 ,A.GPDE_AZ_RP_011_63 ,A.GPDE_AZ_RP_012_11 ,A.GPDE_AZ_RP_012_12 ,A.GPDE_AZ_RP_012_14 ,A.GPDE_AZ_RP_012_17 ,A.GPDE_AZ_RP_012_19 ,A.GPDE_AZ_RP_012_21 ,A.GPDE_AZ_RP_012_22 ,A.GPDE_AZ_RP_012_28 ,A.GPDE_AZ_RP_012_68 ,A.GPDE_AZ_RP_013_31 ,A.GPDE_AZ_RP_013_32 ,A.GPDE_AZ_RP_013_36 ,A.GPDE_AZ_RP_013_41 ,A.GPDE_AZ_RP_013_42 ,A.GPDE_AZ_RP_013_46 ,A.GPDE_AZ_RP_013_ATD ,A.GPDE_AZ_RP_021_11 ,A.GPDE_AZ_RP_021_12 ,A.GPDE_AZ_RP_021_53 ,A.GPDE_AZ_RP_021_63 ,A.GPDE_AZ_RP_022_11 ,A.GPDE_AZ_RP_022_12 ,A.GPDE_AZ_RP_022_14 ,A.GPDE_AZ_RP_022_17 ,A.GPDE_AZ_RP_022_19 ,A.GPDE_AZ_RP_022_21 ,A.GPDE_AZ_RP_022_22 ,A.GPDE_AZ_RP_022_28 ,A.GPDE_AZ_RP_022_68 ,A.GPDE_AZ_RP_023_31 ,A.GPDE_AZ_RP_023_32 ,A.GPDE_AZ_RP_023_36 ,A.GPDE_AZ_RP_023_41 ,A.GPDE_AZ_RP_023_42 ,A.GPDE_AZ_RP_023_46 ,A.GPDE_AZ_RP_023_ATD ,A.GPDE_AZ_RP_BBG_ATD ,A.GPDE_AZ_RP_BBG_MON ,A.GPDE_AZ_RP_ELG_BON ,A.GPDE_AZ_RP_ELG_FIL ,A.GPDE_AZ_RP_ELG_MAR ,A.GPDE_AZ_ELG_LINE10 ,A.GPDE_AZ_RP_H01_53 ,A.GPDE_AZ_RP_H01_63 ,A.GPDE_AZ_RP_H02_68 ,A.GPDE_AZ_RP_H03_31 ,A.GPDE_AZ_RP_MBBG_AT ,A.GPDE_AZ_RP_MRVB_AT ,A.GPDE_AZ_RP_S01_63 ,A.GPDE_AZ_RP_S02_68 ,A.GPDE_AZ_RP_S03_31 ,A.GPDE_AZ_RP_S03_41 ,A.BEGIN_DT ,A.GPDE_AZ_IMODEL1 ,A.GPDE_AZ_IMODEL2 ,A.GPDE_AZ_RP_003_CUR ,A.GPDE_AZ_RP_003_FRM ,A.GPDE_AZ_RP_003_GOA ,A.GPDE_AZ_RP_003_LIM ,A.GPDE_AZ_RP_003_REA ,A.GPDE_AZ_RP_003_TDA ,A.GPDE_AZ_RP_013_CUR ,A.GPDE_AZ_RP_013_FRM ,A.GPDE_AZ_RP_013_GOA ,A.GPDE_AZ_RP_013_LIM ,A.GPDE_AZ_RP_013_REA ,A.GPDE_AZ_RP_013_TDA ,A.GPDE_AZ_RP_023_CUR ,A.GPDE_AZ_RP_023_FRM ,A.GPDE_AZ_RP_023_GOA ,A.GPDE_AZ_RP_023_LIM ,A.GPDE_AZ_RP_023_REA ,A.GPDE_AZ_RP_023_TDA ,A.GPDE_AZ_RP_M003_13 ,A.GPDE_AZ_RP_M003_15 ,A.GPDE_AZ_RP_M003_23 ,A.GPDE_AZ_RP_M003_31 ,A.GPDE_AZ_RP_M003_32 ,A.GPDE_AZ_RP_M003_CR ,A.GPDE_AZ_RP_M013_31 ,A.GPDE_AZ_RP_M013_32 ,A.GPDE_AZ_RP_M023_31 ,A.GPDE_AZ_RP_M023_32 ,A.GPDE_AZ_RP_H11_53 ,A.GPDE_AZ_RP_H11_63 ,A.GPDE_AZ_RP_H12_68 ,A.GPDE_AZ_RP_H13_31 ,A.GPDE_AZ_RP_H21_53 ,A.GPDE_AZ_RP_H21_63 ,A.GPDE_AZ_RP_H22_68 ,A.GPDE_AZ_RP_H23_31 ,A.GPDE_AZ_RP_S11_63 ,A.GPDE_AZ_RP_S12_68 ,A.GPDE_AZ_RP_S13_31 ,A.GPDE_AZ_RP_S13_41 ,A.GPDE_AZ_RP_S21_63 ,A.GPDE_AZ_RP_S22_68 ,A.GPDE_AZ_RP_S23_31 ,A.GPDE_AZ_RP_S23_41 ,A.GPDE_AZ_RP_T03_31 ,A.GPDE_AZ_RP_T03_41 ,A.GPDE_AZ_RP_T13_31 ,A.GPDE_AZ_RP_T13_41 ,A.GPDE_AZ_RP_T23_31 ,A.GPDE_AZ_RP_T23_41 FROM PS_GPDE_RP_AZ01 A WHERE 'N' IN ( SELECT E.GPDE_RETRO_DISP FROM PS_GPDE_AL_EMPLMT E WHERE A.EMPLID = E.EMPLID AND A.EMPL_RCD = E.EMPL_RCD ) OR EXISTS( SELECT 1 FROM PS_GPDE_RP_AL92 B WHERE B.EMPLID=A.EMPLID AND B.CAL_RUN_ID=A.CAL_RUN_ID AND B.EMPL_RCD=A.EMPL_RCD AND B.GP_PAYGROUP=A.GP_PAYGROUP AND B.CAL_ID=A.CAL_ID AND B.ORIG_CAL_RUN_ID=A.ORIG_CAL_RUN_ID AND B.RSLT_SEG_NUM=A.RSLT_SEG_NUM AND (B.GPDE_RP_CHAR01_01='P' OR B.GPDE_RP_CHAR01_02='P' OR B.GPDE_RP_CHAR01_03='P' OR B.GPDE_RP_CHAR01_04='P' OR B.GPDE_RP_CHAR01_05='P' OR B.GPDE_RP_CHAR01_06='P' ))

# 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 Record
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