GPDE_RP_0003_VW

(SQL View)
 Index Back

WA Record for Year To Date

WA Record for Year To Date

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_RP_SIGRSS_AMT ,A.GPDE_RP_SIGRS_ANLZ ,A.GPDE_RP_HICNTB_AMT ,A.GPDE_RP_PICNTB_AMT ,A.GPDE_RP_UICNTB_AMT ,A.GPDE_RP_CICNTB_AMT ,A.GPDE_RP_HIVOL_AMT ,A.GPDE_RP_CIVOL_AMT ,A.GPDE_RP_RIGRSS_AMT ,A.GPDE_RP_U1CNTB_AMT ,A.GPDE_RP_U2CNTB_AMT ,A.GPDE_RP_RIGRSM_AMT ,A.GPDE_RP_U1CTBM_AMT ,A.GPDE_RP_U2CTBM_AMT ,A.GPDE_RP_SIGRSM_AMT ,A.GPDE_RP_HICTBM_AMT ,A.GPDE_RP_PICTBM_AMT ,A.GPDE_RP_UICTBM_AMT ,A.GPDE_RP_CICTBM_AMT ,A.GPDE_RP_OAPGRS_AMT ,A.GPDE_RP_AZGRS_ANLZ ,A.GPDE_RP_AZGRS_BON ,A.GPDE_RP_OAPPEN_AMT ,A.GPDE_RP_OAPPEN_ANL ,A.GPDE_RP_OAPPEN_BON ,A.GPDE_RP_OAPGRS_MC ,A.GPDE_RP_OAPPEN_MC ,A.GPDE_AZ_RP_S03_31 ,A.GPDE_AZ_RP_S03_41 ,A.GPDE_RP_SIDAYS ,A.GPDE_RP_AVDAYS ,A.GPDE_RP_KVDAYS ,A.GPDE_RP_PVDAYS ,A.GPDE_RP_AVDAYS_BON ,A.GPDE_RP_KVDAYS_BON ,A.GPDE_RP_PVDAYS_BON ,A.GPDE_RP_RVDAYS_BON ,A.GPDE_RP_AVDAYS_MC ,A.GPDE_RP_KVDAYS_MC ,A.GPDE_RP_PVDAYS_MC ,A.GPDE_RP_RVDAYS_MC ,A.GPDE_RP_AVGRS_ANLZ ,A.GPDE_RP_AVGRS_BON ,A.GPDE_RP_AVGRS_MC ,A.GPDE_RP_KVGRS_ANLZ ,A.GPDE_RP_KVGRS_BON ,A.GPDE_RP_KVGRS_MC ,A.GPDE_RP_PVGRS_ANLZ ,A.GPDE_RP_PVGRS_BON ,A.GPDE_RP_PVGRS_MC ,A.GPDE_RP_RVGRS_ANLZ ,A.GPDE_RP_RVGRS_BON ,A.GPDE_RP_RVGRS_MC ,A.GPDE_RP_AVLFD_AG ,A.GPDE_RP_AVLFD_AN ,A.GPDE_RP_KVLFD_AG ,A.GPDE_RP_KVLFD_AN ,A.GPDE_RP_PVLFD_AG ,A.GPDE_RP_PVLFD_AN ,A.GPDE_RP_RVLFD_AG ,A.GPDE_RP_RVLFD_AN ,A.GPDE_RP_AVBON_AG ,A.GPDE_RP_AVBON_AN ,A.GPDE_RP_KVBON_AG ,A.GPDE_RP_KVBON_AN ,A.GPDE_RP_PVBON_AG ,A.GPDE_RP_PVBON_AN ,A.GPDE_RP_RVBON_AG ,A.GPDE_RP_RVBON_AN ,A.GPDE_RP_AVAG_MC ,A.GPDE_RP_AVAN_MC ,A.GPDE_RP_KVAG_MC ,A.GPDE_RP_KVAN_MC ,A.GPDE_RP_PVAG_MC ,A.GPDE_RP_PVAN_MC ,A.GPDE_RP_RVAG_MC ,A.GPDE_RP_RVAN_MC ,A.GPDE_RP_SIGRUNLM_A ,A.GPDE_RP_SIGRUNLM_B ,A.GPDE_RP_CIVLER_AMT ,A.GPDE_RP_HIVLER_AMT ,A.GPDE_RP_AV_BBE_EGA ,A.GPDE_RP_AV_BBE_LGA ,A.GPDE_RP_KV_BBE_EGA ,A.GPDE_RP_KV_BBE_LGA ,A.GPDE_RP_KUG_KVCTB ,A.GPDE_RP_KUG_PVCTB ,A.GPDE_RP_KUG_RVCTB ,A.GPDE_RP_KUG_KVGRS ,A.GPDE_RP_KUG_PVGRS ,A.GPDE_RP_KUG_RVGRS ,A.GPDE_RPKUGKVCTBVP ,A.GPDE_RPKUGKVCTBVP ,A.GPDE_RP_SFN_SI_ABL ,A.GPDE_RP_SK_NET ,A.GPDE_RP_SK_SL_NET ,A.GPDE_RP_SK_SIEXEMP ,A.GPDE_RP_SK_GROSS ,A.GPDE_RP_GRSS_INSOL ,A.GPDE_RP_UML_INSOLV ,A.GPDE_RP_GRSSINSLFD ,A.GPDE_RP_GRSSINSEGA ,A.GPDE_RP_VW_RVLFDAG ,A.GPDE_RP_VW_RVBONAG ,A.GPDE_RP_VW_RVAG_MC ,A.GPDE_RP_GRS_INS_MC ,A.GPDE_RP_UML_INS_MC ,A.GPDE_DV_DBKV_GROSS FROM PS_GPDE_RP_0003 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 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_RP_SIGRSS_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
14 GPDE_RP_SIGRS_ANLZ Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
15 GPDE_RP_HICNTB_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
16 GPDE_RP_PICNTB_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
17 GPDE_RP_UICNTB_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
18 GPDE_RP_CICNTB_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
19 GPDE_RP_HIVOL_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
20 GPDE_RP_CIVOL_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
21 GPDE_RP_RIGRSS_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
22 GPDE_RP_U1CNTB_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
23 GPDE_RP_U2CNTB_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
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_RP_SIGRSM_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
28 GPDE_RP_HICTBM_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
29 GPDE_RP_PICTBM_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
30 GPDE_RP_UICTBM_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
31 GPDE_RP_CICTBM_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
32 GPDE_RP_OAPGRS_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
33 GPDE_RP_AZGRS_ANLZ Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
34 GPDE_RP_AZGRS_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
35 GPDE_RP_OAPPEN_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
36 GPDE_RP_OAPPEN_ANL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
37 GPDE_RP_OAPPEN_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
38 GPDE_RP_OAPGRS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
39 GPDE_RP_OAPPEN_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
40 GPDE_AZ_RP_S03_31 Signed Number(20,6) DECIMAL(18,6) NOT NULL Sick Fill for Stat DA recurr
41 GPDE_AZ_RP_S03_41 Signed Number(20,6) DECIMAL(18,6) NOT NULL Cont Sick Fill Stat DA recurr
42 GPDE_RP_SIDAYS Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
43 GPDE_RP_AVDAYS Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
44 GPDE_RP_KVDAYS Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
45 GPDE_RP_PVDAYS Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
46 GPDE_RP_AVDAYS_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
47 GPDE_RP_KVDAYS_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
48 GPDE_RP_PVDAYS_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
49 GPDE_RP_RVDAYS_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
50 GPDE_RP_AVDAYS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
51 GPDE_RP_KVDAYS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
52 GPDE_RP_PVDAYS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
53 GPDE_RP_RVDAYS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
54 GPDE_RP_AVGRS_ANLZ Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
55 GPDE_RP_AVGRS_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
56 GPDE_RP_AVGRS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
57 GPDE_RP_KVGRS_ANLZ Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
58 GPDE_RP_KVGRS_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
59 GPDE_RP_KVGRS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
60 GPDE_RP_PVGRS_ANLZ Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
61 GPDE_RP_PVGRS_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
62 GPDE_RP_PVGRS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
63 GPDE_RP_RVGRS_ANLZ Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
64 GPDE_RP_RVGRS_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
65 GPDE_RP_RVGRS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
66 GPDE_RP_AVLFD_AG Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
67 GPDE_RP_AVLFD_AN Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
68 GPDE_RP_KVLFD_AG Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
69 GPDE_RP_KVLFD_AN Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
70 GPDE_RP_PVLFD_AG Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
71 GPDE_RP_PVLFD_AN Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
72 GPDE_RP_RVLFD_AG Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
73 GPDE_RP_RVLFD_AN Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
74 GPDE_RP_AVBON_AG Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
75 GPDE_RP_AVBON_AN Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
76 GPDE_RP_KVBON_AG Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
77 GPDE_RP_KVBON_AN Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
78 GPDE_RP_PVBON_AG Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
79 GPDE_RP_PVBON_AN Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
80 GPDE_RP_RVBON_AG Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
81 GPDE_RP_RVBON_AN Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
82 GPDE_RP_AVAG_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
83 GPDE_RP_AVAN_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
84 GPDE_RP_KVAG_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
85 GPDE_RP_KVAN_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
86 GPDE_RP_PVAG_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
87 GPDE_RP_PVAN_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
88 GPDE_RP_RVAG_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
89 GPDE_RP_RVAN_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
90 GPDE_RP_SIGRUNLM_A Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
91 GPDE_RP_SIGRUNLM_B Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
92 GPDE_RP_CIVLER_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
93 GPDE_RP_HIVLER_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
94 GPDE_RP_AV_BBE_EGA Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
95 GPDE_RP_AV_BBE_LGA Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
96 GPDE_RP_KV_BBE_EGA Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
97 GPDE_RP_KV_BBE_LGA Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
98 GPDE_RP_KUG_KVCTB Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
99 GPDE_RP_KUG_PVCTB Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
100 GPDE_RP_KUG_RVCTB Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
101 GPDE_RP_KUG_KVGRS Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
102 GPDE_RP_KUG_PVGRS Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
103 GPDE_RP_KUG_RVGRS Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
104 GPDE_RPKUGKVCTBVP Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
105 GPDE_RPKUGPVCTBVP Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
106 GPDE_RP_SFN_SI_ABL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
107 GPDE_RP_SK_NET Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
108 GPDE_RP_SK_SL_NET Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
109 GPDE_RP_SK_SIEXEMP Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
110 GPDE_RP_SK_GROSS Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross During Social Benifit
111 GPDE_RP_GRSS_INSOL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
112 GPDE_RP_UML_INSOLV Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
113 GPDE_RP_GRSSINSLFD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
114 GPDE_RP_GRSSINSEGA Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
115 GPDE_RP_VW_RVLFDAG Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
116 GPDE_RP_VW_RVBONAG Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
117 GPDE_RP_VW_RVAG_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
118 GPDE_RP_GRS_INS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross amount for Insolvency for March Clause
119 GPDE_RP_UML_INS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Contribution Insolvency March Clause
120 GPDE_DV_DBKV_GROSS Signed Number(20,6) DECIMAL(18,6) NOT NULL DBKV Gross