GPDE_RP_AZ1_HST

(SQL Table)
 Index Back

WA Record for AZ

This is the Archive (shadow) table used in Data Archiving for the record: GPDE_RP_AZ01.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
7 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
8 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
9 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
10 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
11 SLICE_END_DT Date(10) DATE Element Slice End Date
12 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
13 PRD_END_DT Date(10) DATE Pay Period End Date
14 GPDE_AL_CPAY_ENDDT Date(10) DATE Current Pay End Date
15 GPDE_AZ_RP_001_11 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Grs Stat. Grs Inc
16 GPDE_AZ_RP_001_12 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Grs Once Stat. Grs Inc
17 GPDE_AZ_RP_001_53 Signed Number(20,6) DECIMAL(18,6) NOT NULL Base for Statutory Gross Inc
18 GPDE_AZ_RP_001_63 Signed Number(20,6) DECIMAL(18,6) NOT NULL Statutory Gross Increase
19 GPDE_AZ_RP_002_11 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Grs Recurr Stat. Min
20 GPDE_AZ_RP_002_12 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Grs Once Stat. Min
21 GPDE_AZ_RP_002_14 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Tax and SI-free Stat.
22 GPDE_AZ_RP_002_17 Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculated Parttime Net
23 GPDE_AZ_RP_002_19 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Statutory TotalNet
24 GPDE_AZ_RP_002_21 Signed Number(20,6) DECIMAL(18,6) NOT NULL FT Grs Recurr Stat. Min.
25 GPDE_AZ_RP_002_22 Signed Number(20,6) DECIMAL(18,6) NOT NULL FT Grs Once Stat. Min.
26 GPDE_AZ_RP_002_28 Signed Number(20,6) DECIMAL(18,6) NOT NULL Statutory Flat Minimum Net
27 GPDE_AZ_RP_002_68 Signed Number(20,6) DECIMAL(18,6) NOT NULL Stat. Increase Min. Net.
28 GPDE_AZ_RP_003_11 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Grs Recurr Stat. DA
29 GPDE_AZ_RP_003_12 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Grs Once Stat. DA
30 GPDE_AZ_RP_003_15 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Overtime Pay Stat.
31 GPDE_AZ_RP_003_21 Signed Number(20,6) DECIMAL(18,6) NOT NULL FT Grs Recurr Stat. DA
32 GPDE_AZ_RP_003_22 Signed Number(20,6) DECIMAL(18,6) NOT NULL FT Grs Once Stat. DA
33 GPDE_AZ_RP_003_31 Signed Number(20,6) DECIMAL(18,6) NOT NULL Statutory DA Recurring Pay
34 GPDE_AZ_RP_003_32 Signed Number(20,6) DECIMAL(18,6) NOT NULL Stat DA onetime pay
35 GPDE_AZ_RP_003_36 Signed Number(20,6) DECIMAL(18,6) NOT NULL OAPT DA Stat. Marchclause
36 GPDE_AZ_RP_003_41 Signed Number(20,6) DECIMAL(18,6) NOT NULL Contr. Stat. DA Recurring Pay
37 GPDE_AZ_RP_003_42 Signed Number(20,6) DECIMAL(18,6) NOT NULL Contr. Stat. DA onetime pay
38 GPDE_AZ_RP_003_46 Signed Number(20,6) DECIMAL(18,6) NOT NULL Contr. Stat. DA Marchclause
39 GPDE_AZ_RP_003_ATD Signed Number(20,6) DECIMAL(18,6) NOT NULL SIP Gross in OAPT period
40 GPDE_AZ_RP_004_0B Signed Number(20,6) DECIMAL(18,6) NOT NULL Time Units Unpaid Sickness
41 GPDE_AZ_RP_004_0C Signed Number(20,6) DECIMAL(18,6) NOT NULL Time Units Unpaid Total
42 GPDE_AZ_RP_004_11 Signed Number(20,6) DECIMAL(18,6) NOT NULL Reducable Payment Amounts
43 GPDE_AZ_RP_004_1A Signed Number(20,6) DECIMAL(18,6) NOT NULL Bases of Reducable Payments
44 GPDE_AZ_RP_011_11 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Grs Vol.1 Grs Inc
45 GPDE_AZ_RP_011_12 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Grs Once Vol.1 Grs Inc
46 GPDE_AZ_RP_011_53 Signed Number(20,6) DECIMAL(18,6) NOT NULL Base for Gross Increase Vol1
47 GPDE_AZ_RP_011_63 Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross Increase Vol1
48 GPDE_AZ_RP_012_11 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Grs Recurr Vol.1 Min
49 GPDE_AZ_RP_012_12 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Grs Once Vol.1 Min
50 GPDE_AZ_RP_012_14 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Tax and SI-free Vol.1
51 GPDE_AZ_RP_012_17 Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculated Parttime Net
52 GPDE_AZ_RP_012_19 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Voluntary 1 Total Net
53 GPDE_AZ_RP_012_21 Signed Number(20,6) DECIMAL(18,6) NOT NULL FT Grs Recurr Vol.1 Min.
54 GPDE_AZ_RP_012_22 Signed Number(20,6) DECIMAL(18,6) NOT NULL FT Grs Once Vol.1 Min.
55 GPDE_AZ_RP_012_28 Signed Number(20,6) DECIMAL(18,6) NOT NULL FT Flat Minimum Net
56 GPDE_AZ_RP_012_68 Signed Number(20,6) DECIMAL(18,6) NOT NULL Minimum Net Increase Vol1
57 GPDE_AZ_RP_013_31 Signed Number(20,6) DECIMAL(18,6) NOT NULL Vol1 DA recurring pay
58 GPDE_AZ_RP_013_32 Signed Number(20,6) DECIMAL(18,6) NOT NULL Vol 1 DA Onetime Pay
59 GPDE_AZ_RP_013_36 Signed Number(20,6) DECIMAL(18,6) NOT NULL OAPT DA Vol.1 Marchclause
60 GPDE_AZ_RP_013_41 Signed Number(20,6) DECIMAL(18,6) NOT NULL Contr. vol.1 DA Recurring Pay
61 GPDE_AZ_RP_013_42 Signed Number(20,6) DECIMAL(18,6) NOT NULL Contr. vol.1 DA onetime pay
62 GPDE_AZ_RP_013_46 Signed Number(20,6) DECIMAL(18,6) NOT NULL Contr. vol.1 DA Marchclause
63 GPDE_AZ_RP_013_ATD Signed Number(20,6) DECIMAL(18,6) NOT NULL Vol 1 Diff Amounts YTD
64 GPDE_AZ_RP_021_11 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Grs Vol.2 Grs Inc
65 GPDE_AZ_RP_021_12 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Grs Once Vol.2 Grs Inc
66 GPDE_AZ_RP_021_53 Signed Number(20,6) DECIMAL(18,6) NOT NULL Base for Gross Increase Vol2
67 GPDE_AZ_RP_021_63 Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross Increase Vol2
68 GPDE_AZ_RP_022_11 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Grs Recurr Vol.2 Min
69 GPDE_AZ_RP_022_12 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Grs Once Vol.2 Min
70 GPDE_AZ_RP_022_14 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Tax and SI-free Vol.2
71 GPDE_AZ_RP_022_17 Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculated Parttime Net
72 GPDE_AZ_RP_022_19 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Voluntary 1 Total Net
73 GPDE_AZ_RP_022_21 Signed Number(20,6) DECIMAL(18,6) NOT NULL FT Grs Recurr Vol.2 Min.
74 GPDE_AZ_RP_022_22 Signed Number(20,6) DECIMAL(18,6) NOT NULL FT Grs Once Vol.2 Min.
75 GPDE_AZ_RP_022_28 Signed Number(20,6) DECIMAL(18,6) NOT NULL FT Flat Minimum Net Vol2
76 GPDE_AZ_RP_022_68 Signed Number(20,6) DECIMAL(18,6) NOT NULL Minimum Net Increase Vol2
77 GPDE_AZ_RP_023_31 Signed Number(20,6) DECIMAL(18,6) NOT NULL Vol2 DA recurring pay
78 GPDE_AZ_RP_023_32 Signed Number(20,6) DECIMAL(18,6) NOT NULL Vol 2 DA Onetime Pay
79 GPDE_AZ_RP_023_36 Signed Number(20,6) DECIMAL(18,6) NOT NULL OAPT Marchclause Voluntary 2
80 GPDE_AZ_RP_023_41 Signed Number(20,6) DECIMAL(18,6) NOT NULL Contr. vol.2 DA Recurring Pay
81 GPDE_AZ_RP_023_42 Signed Number(20,6) DECIMAL(18,6) NOT NULL Contr. vol.2 DA onetime pay
82 GPDE_AZ_RP_023_46 Signed Number(20,6) DECIMAL(18,6) NOT NULL Contr. vol.2 DA Marchclause
83 GPDE_AZ_RP_023_ATD Signed Number(20,6) DECIMAL(18,6) NOT NULL Vol 2 Diff Amounts YTD
84 GPDE_AZ_RP_BBG_ATD Signed Number(20,6) DECIMAL(18,6) NOT NULL Yeartodate SIP-Limit in OAPT
85 GPDE_AZ_RP_BBG_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Monthly SIP-Limit for the EE
86 GPDE_AZ_RP_ELG_BON Character(1) VARCHAR2(1) NOT NULL Eligible for AZ Bonus Calculation
87 GPDE_AZ_RP_ELG_FIL Character(1) VARCHAR2(1) NOT NULL Eligible for Sick-Fill in AZ Calculation
88 GPDE_AZ_RP_ELG_MAR Character(1) VARCHAR2(1) NOT NULL Eligible for Marchclause Calculation
89 GPDE_AZ_ELG_LINE10 Character(1) VARCHAR2(1) NOT NULL Provide Value in Report Line10

Y/N Table Edit

90 GPDE_AZ_RP_H01_53 Signed Number(20,6) DECIMAL(18,6) NOT NULL Base for Statutory Gross Inc
91 GPDE_AZ_RP_H01_63 Signed Number(20,6) DECIMAL(18,6) NOT NULL Statutory Gross Increase
92 GPDE_AZ_RP_H02_68 Signed Number(20,6) DECIMAL(18,6) NOT NULL Stat. Incr. Minimum Net
93 GPDE_AZ_RP_H03_31 Signed Number(20,6) DECIMAL(18,6) NOT NULL Unreduced Stat DA recurr
94 GPDE_AZ_RP_MBBG_AT Signed Number(20,6) DECIMAL(18,6) NOT NULL ATD Si-Limit last year
95 GPDE_AZ_RP_MRVB_AT Signed Number(20,6) DECIMAL(18,6) NOT NULL ATD-Gross Stat. OAPT MCC
96 GPDE_AZ_RP_S01_63 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Stat. Gross Increase
97 GPDE_AZ_RP_S02_68 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Stat. Min. Increase
98 GPDE_AZ_RP_S03_31 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick Fill for Stat DA recurr
99 GPDE_AZ_RP_S03_41 Signed Number(20,6) DECIMAL(18,6) NOT NULL Cont Sick Fill Stat DA recurr
100 BEGIN_DT Date(10) DATE Begin Date
101 GPDE_AZ_IMODEL1 Character(12) VARCHAR2(12) NOT NULL Descr
102 GPDE_AZ_IMODEL2 Character(12) VARCHAR2(12) NOT NULL Descr
103 GPDE_AZ_RP_003_CUR Signed Number(20,6) DECIMAL(18,6) NOT NULL Real Amount Curr Period
104 GPDE_AZ_RP_003_FRM Signed Number(20,6) DECIMAL(18,6) NOT NULL Contributable Frame
105 GPDE_AZ_RP_003_GOA Signed Number(20,6) DECIMAL(18,6) NOT NULL Goal for Difference Amt
106 GPDE_AZ_RP_003_LIM Signed Number(20,6) DECIMAL(18,6) NOT NULL ATD SI-Limit
107 GPDE_AZ_RP_003_REA Signed Number(20,6) DECIMAL(18,6) NOT NULL Real Amount Contributed
108 GPDE_AZ_RP_003_TDA Signed Number(20,6) DECIMAL(18,6) NOT NULL Remaining Diff. Amt.
109 GPDE_AZ_RP_013_CUR Signed Number(20,6) DECIMAL(18,6) NOT NULL Real Amount Curr Period
110 GPDE_AZ_RP_013_FRM Signed Number(20,6) DECIMAL(18,6) NOT NULL Contributable Frame
111 GPDE_AZ_RP_013_GOA Signed Number(20,6) DECIMAL(18,6) NOT NULL Goal for Difference Amt
112 GPDE_AZ_RP_013_LIM Signed Number(20,6) DECIMAL(18,6) NOT NULL ATD SI-Limit
113 GPDE_AZ_RP_013_REA Signed Number(20,6) DECIMAL(18,6) NOT NULL Real Amount Contributed
114 GPDE_AZ_RP_013_TDA Signed Number(20,6) DECIMAL(18,6) NOT NULL Remaining Diff. Amt.
115 GPDE_AZ_RP_023_CUR Signed Number(20,6) DECIMAL(18,6) NOT NULL Real Amount Curr Period
116 GPDE_AZ_RP_023_FRM Signed Number(20,6) DECIMAL(18,6) NOT NULL Contributable Frame
117 GPDE_AZ_RP_023_GOA Signed Number(20,6) DECIMAL(18,6) NOT NULL Goal for Difference Amt
118 GPDE_AZ_RP_023_LIM Signed Number(20,6) DECIMAL(18,6) NOT NULL ATD SI-Limit
119 GPDE_AZ_RP_023_REA Signed Number(20,6) DECIMAL(18,6) NOT NULL Real Amount Contributed
120 GPDE_AZ_RP_023_TDA Signed Number(20,6) DECIMAL(18,6) NOT NULL Remaining Diff. Amt.
121 GPDE_AZ_RP_M003_13 Signed Number(20,6) DECIMAL(18,6) NOT NULL PT Gross unlimited OAPT MCC
122 GPDE_AZ_RP_M003_15 Signed Number(20,6) DECIMAL(18,6) NOT NULL Overtime in assignment period
123 GPDE_AZ_RP_M003_23 Signed Number(20,6) DECIMAL(18,6) NOT NULL FT Gross unlimited OAPT MCC
124 GPDE_AZ_RP_M003_31 Signed Number(20,6) DECIMAL(18,6) NOT NULL Statutory DA recurr pay
125 GPDE_AZ_RP_M003_32 Signed Number(20,6) DECIMAL(18,6) NOT NULL Statutory DA onetime pay
126 GPDE_AZ_RP_M003_CR Signed Number(20,6) DECIMAL(18,6) NOT NULL Total Real SI Gross unlim. MCC
127 GPDE_AZ_RP_M013_31 Signed Number(20,6) DECIMAL(18,6) NOT NULL Vol. 1 DA recurring pay
128 GPDE_AZ_RP_M013_32 Signed Number(20,6) DECIMAL(18,6) NOT NULL Vol. 1 DA onetime pay
129 GPDE_AZ_RP_M023_31 Signed Number(20,6) DECIMAL(18,6) NOT NULL Vol. 2 DA recurring pay
130 GPDE_AZ_RP_M023_32 Signed Number(20,6) DECIMAL(18,6) NOT NULL Vol. 2 DA onetime pay
131 GPDE_AZ_RP_H11_53 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Base Vol 1 Grs Inc
132 GPDE_AZ_RP_H11_63 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Vol 1 Grs Inc
133 GPDE_AZ_RP_H12_68 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Vol 1 Minnet
134 GPDE_AZ_RP_H13_31 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Unred Vol 1 DA recurr
135 GPDE_AZ_RP_H21_53 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Base Vol 2 Grs Inc
136 GPDE_AZ_RP_H21_63 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Vol 2 Grs Inc
137 GPDE_AZ_RP_H22_68 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Vol 2 Minnet
138 GPDE_AZ_RP_H23_31 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Unred Vol 2 DA recurr
139 GPDE_AZ_RP_S11_63 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Vol 1 Grs Inc
140 GPDE_AZ_RP_S12_68 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Vol 1 Minnet
141 GPDE_AZ_RP_S13_31 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Vol 1 DA recurr
142 GPDE_AZ_RP_S13_41 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Ctrb Vol 1 DA recurr
143 GPDE_AZ_RP_S21_63 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Vol 2 Grs Inc
144 GPDE_AZ_RP_S22_68 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Vol 2 Minnet
145 GPDE_AZ_RP_S23_31 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Vol 2 DA recurr
146 GPDE_AZ_RP_S23_41 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Ctrb Vol 2 DA recurr
147 GPDE_AZ_RP_T03_31 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Stat DA recurr PKV
148 GPDE_AZ_RP_T03_41 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Ctrb Stat DA rc PKV
149 GPDE_AZ_RP_T13_31 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Vol 1 DA recurr PKV
150 GPDE_AZ_RP_T13_41 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Ctrb Vol 1 DA rc PKV
151 GPDE_AZ_RP_T23_31 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Vol 2 DA recurr PKV
152 GPDE_AZ_RP_T23_41 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick-Fill Ctrb Vol 2 DA rc PKV