GPDE_RP_SI10

(SQL Table)
 Index Back

Temp Record for Repoting

Temp Record for Repoting

# 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 SLICE_END_DT Date(10) DATE Element Slice End Date
8 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
9 PRD_END_DT Date(10) DATE Pay Period End Date
10 GPDE_AL_CPAY_ENDDT Date(10) DATE Current Pay End Date
11 GPDE_RP_SIGRSS_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
12 GPDE_RP_SIGRS_ANLZ Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
13 GPDE_RP_HICNTB_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
14 GPDE_RP_PICNTB_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
15 GPDE_RP_UICNTB_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
16 GPDE_RP_CICNTB_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
17 GPDE_RP_HIVOL_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
18 GPDE_RP_CIVOL_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
19 GPDE_RP_RIGRSS_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
20 GPDE_RP_U1CNTB_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
21 GPDE_RP_U2CNTB_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
22 GPDE_RI_PCT1 Number(6,2) DECIMAL(5,2) NOT NULL Percent
23 GPDE_RI_PCT2 Number(6,2) DECIMAL(5,2) NOT NULL Percent
24 GPDE_RP_RIGRSM_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
25 GPDE_RP_U1CTBM_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
26 GPDE_RP_U2CTBM_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
27 GPDE_RI_PCT1_MC Number(6,2) DECIMAL(5,2) NOT NULL Percent
28 GPDE_RI_PCT2_MC Number(6,2) DECIMAL(5,2) NOT NULL Percent
29 GPDE_RP_SIGRSM_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
30 GPDE_RP_HICTBM_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
31 GPDE_RP_PICTBM_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
32 GPDE_RP_UICTBM_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
33 GPDE_RP_CICTBM_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
34 GPDE_RP_OAPGRS_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
35 GPDE_RP_AZGRS_ANLZ Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
36 GPDE_RP_OAPPEN_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
37 GPDE_RP_OAPGRS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
38 GPDE_RP_OAPPEN_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
39 GPDE_RP_SIDAYS Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
40 GPDE_RP_AVDAYS Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
41 GPDE_RP_KVDAYS Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
42 GPDE_RP_PVDAYS Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
43 GPDE_RP_AVDAYS_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
44 GPDE_RP_KVDAYS_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
45 GPDE_RP_PVDAYS_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
46 GPDE_RP_RVDAYS_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
47 GPDE_RP_AVGRS_ANLZ Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
48 GPDE_RP_AVGRS_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
49 GPDE_RP_AVGRS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
50 GPDE_RP_KVGRS_ANLZ Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
51 GPDE_RP_KVGRS_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
52 GPDE_RP_KVGRS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
53 GPDE_RP_PVGRS_ANLZ Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
54 GPDE_RP_PVGRS_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
55 GPDE_RP_PVGRS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
56 GPDE_RP_RVGRS_ANLZ Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
57 GPDE_RP_RVGRS_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
58 GPDE_RP_RVGRS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
59 GPDE_RP_AVLFD_AG Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
60 GPDE_RP_AVLFD_AN Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
61 GPDE_RP_KVLFD_AG Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
62 GPDE_RP_KVLFD_AN Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
63 GPDE_RP_PVLFD_AG Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
64 GPDE_RP_PVLFD_AN Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
65 GPDE_RP_RVLFD_AG Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
66 GPDE_RP_RVLFD_AN Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
67 GPDE_RP_KVBON_AG Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
68 GPDE_RP_KVBON_AN Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
69 GPDE_RP_AVBON_AG Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
70 GPDE_RP_AVBON_AN Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
71 GPDE_RP_PVBON_AG Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
72 GPDE_RP_PVBON_AN Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
73 GPDE_RP_RVBON_AG Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
74 GPDE_RP_RVBON_AN Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
75 GPDE_RP_AVAG_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
76 GPDE_RP_AVAN_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
77 GPDE_RP_KVAG_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
78 GPDE_RP_KVAN_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
79 GPDE_RP_PVAG_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
80 GPDE_RP_PVAN_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
81 GPDE_RP_RVAG_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
82 GPDE_RP_RVAN_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
83 GPDE_RP_SIGRUNLM_A Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
84 GPDE_RP_SIGRUNLM_B Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
85 GPDE_RP_CIVLER_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
86 GPDE_RP_HIVLER_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
87 GPDE_RC_PRT_SIGN Character(1) VARCHAR2(1) NOT NULL PRINT SIGN
N=Non Elements in Print Class
Y=Only Elements in Print Class
88 GPDE_SI_PROV_AV Character(8) VARCHAR2(8) NOT NULL Unemployment Insur Provider
89 GPDE_SI_PROV_KV Character(8) VARCHAR2(8) NOT NULL Health Insurance Provider
90 GPDE_SI_PROV_PV Character(8) VARCHAR2(8) NOT NULL Home Care Insurance Provider
91 GPDE_SI_PROV_RV Character(8) VARCHAR2(8) NOT NULL Pension Insurance Provider
92 GPDE_SI_PROV_UM Character(8) VARCHAR2(8) NOT NULL Unemployment Insur Provider
93 GPDE_SI_PROV_AV_M Character(8) VARCHAR2(8) NOT NULL UI Provider for March Clause
94 GPDE_SI_PROV_KV_M Character(8) VARCHAR2(8) NOT NULL HI Provider for March Clause
95 GPDE_SI_PROV_PV_M Character(8) VARCHAR2(8) NOT NULL HCI Provider for March Clause
96 GPDE_SI_PROV_RV_M Character(8) VARCHAR2(8) NOT NULL PI Provider for March Clause
97 GPDE_SI_PROV_UM_M Character(8) VARCHAR2(8) NOT NULL Unemployment Insur Provider
98 GPDE_RP_AZGRS_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
99 GPDE_RP_OAPPEN_ANL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
100 GPDE_RP_OAPPEN_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
101 GPDE_RP_AVDAYS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
102 GPDE_RP_KVDAYS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
103 GPDE_RP_PVDAYS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
104 GPDE_RP_RVDAYS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
105 GPDE_TX_MJ_LUMP Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
106 GPDE_AZ_RP_S03_31 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick Fill for Stat DA recurr
107 GPDE_AZ_RP_S03_41 Signed Number(20,6) DECIMAL(18,6) NOT NULL Cont Sick Fill Stat DA recurr
108 GPDE_SI_IS_KVDR Character(1) VARCHAR2(1) NOT NULL Health Insurance for Pensioners Flag
109 GPDE_SI_PV_CHILD Character(1) VARCHAR2(1) NOT NULL Children for PV Calculation
110 GPDE_RP_KUG_KVCTB Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
111 GPDE_RP_KUG_KVGRS Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
112 GPDE_RP_KUG_PVCTB Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
113 GPDE_RP_KUG_PVGRS Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
114 GPDE_RP_KUG_RVCTB Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
115 GPDE_RP_KUG_RVGRS Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
116 GPDE_KU_KUGAMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
117 GPDE_KU_KUGKKAMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
118 GPDE_RP_SFN_SI_ABL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
119 GPDE_RP_RV_GZ_FLG Character(1) VARCHAR2(1) NOT NULL Flag Glidezone Calculation Pension Insurance
0=No Glidezone calculation in RV
1=GZ RV btwn 400 and 800 Eur
2=GZ RV under 400 Eur
120 GPDE_RP_GRSS_INSOL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
121 GPDE_RP_UML_INSOLV Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
122 GPDE_RP_MARCH_CLS Number(2,0) SMALLINT NOT NULL March Clause
123 GPDE_RP_GRS_INS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross amount for Insolvency for March Clause
124 GPDE_RP_UML_INS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Contribution Insolvency March Clause