GPDE_RP_0002_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.PAY_ENTITY ,A.PRD_END_DT ,A.GPDE_AL_CPAY_ENDDT ,A.GPDE_RP_NOI_YTD ,A.GPDE_RP_TXGRSS_YTD ,A.GPDE_RP_TAX_YTD ,A.GPDE_RP_SLDRTY_YTD ,A.GPDE_RP_CHRTXE_YTD ,A.GPDE_RP_CHRTXS_YTD ,A.GPDE_RP_PENS_YTD ,A.GPDE_RP_MYPENS_YTD ,A.GPDE_RP_MYTXGR_YTD ,A.GPDE_RP_MYTAX_YTD ,A.GPDE_RP_MYSLDR_YTD ,A.GPDE_RP_MYCTXE_YTD ,A.GPDE_RP_MYCTXS_YTD ,A.GPDE_RP_KUGMAT_YTD ,A.GPDE_RP_ATZ_YTD ,A.GPDE_RP_DBA_YTD ,A.GPDE_RP_ATE_YTD ,A.GPDE_RP_TRVTXF_YTD ,A.GPDE_RP_TRVTXL_YTD ,A.GPDE_RP_FDALLW_YTD ,A.GPDE_RP_DH_YTD ,A.GPDE_RP_HCAG_YTD ,A.GPDE_RP_SIEE_YTD ,A.GPDE_RP_KVAN_YTD ,A.GPDE_RP_RVAN_YTD ,A.GPDE_RP_AVAN_YTD ,A.GPDE_RP_PVAN_YTD ,A.GPDE_RP_KVAG_YTD ,A.GPDE_RP_RVAG_YTD ,A.GPDE_RP_AVAG_YTD ,A.GPDE_RP_PVAG_YTD ,A.GPDE_RP_VACBAL ,A.GPDE_RP_VACENT ,A.GPDE_RP_VACTAKE ,A.GPDE_RP_VACPYR ,A.GPDE_RP_WRKDHRS ,A.GPDE_RP_OVRTMHRS ,A.GPDE_RP_TOTGRSS ,A.GPDE_RP_TTGRSS_YTD ,A.GPDE_RP_TAX_AMT ,A.GPDE_RP_SLDRTY_AMT ,A.GPDE_RP_CHTXEE_AMT ,A.GPDE_RP_CHTXSP_AMT ,A.GPDE_RP_CHTXLE_AMT ,A.GPDE_RP_CHTXLC_AMT ,A.GPDE_RP_CHTXLJ_AMT ,A.GPDE_RP_CHTX_LMPS ,A.GPDE_RP_LMP_TOT ,A.GPDE_RP_CHMBBR_AMT ,A.GPDE_RP_CHMBSA_AMT ,A.GPDE_RP_SIDAYS_YTD ,A.GPDE_RP_SIGRSA_YTD ,A.GPDE_RP_SIGRSB_YTD ,A.GPDE_RP_SIGRSS_YTD ,A.GPDE_RP_TXMYGR_YTD ,A.GPDE_RP_PENTXF_YTD ,A.GPDE_RP_TXDAYS ,A.GPDE_RP_TXGRS_TOT ,A.GPDE_RP_TXGRS_ANLZ ,A.GPDE_RP_TXGRS_BON ,A.GPDE_RP_TXGRS_PEN ,A.GPDE_RP_TXGRS_MYBN ,A.GPDE_RP_TXGRS_MYPN ,A.GPDE_RP_TAX ,A.GPDE_RP_CHRCH_TAX ,A.GPDE_RP_SLDRTY_TAX ,A.GPDE_RP_TAX_MY ,A.GPDE_RP_CRCH_TX_MY ,A.GPDE_RP_SLDY_TX_MY ,A.GPDE_RP_PENTXF ,A.GPDE_RP_NOI ,A.GPDE_RP_STATDD_SUM ,A.GPDE_RP_DED_SUM ,A.GPDE_RP_LMP_DIRINS ,A.GPDE_RP_LMP_TRVLEX ,A.GPDE_RP_LMP_GRSS ,A.GPDE_RP_LMP_TXEE ,A.GPDE_RP_LMP_CHTXEE ,A.GPDE_RP_LMP_SLTXEE ,A.GPDE_RP_LMP_TXER ,A.GPDE_RP_LMP_CHTXER ,A.GPDE_RP_LMP_SLTXER ,A.GPDE_TX_MJ_LUMP ,A.GPDE_RP_A2_9190 ,A.GPDE_RP_A2_9290 ,A.GPDE_RP_A2_9390 ,A.GPDE_RP_TXSTM_L1DE ,A.GPDE_RP_TXSTM_L1YT ,A.GPDE_RP_TXSTM_L2DE ,A.GPDE_RP_TXSTM_L2YT ,A.GPDE_RP_TXSTM_L3DE ,A.GPDE_RP_TXSTM_L3YT ,A.GPDE_RP_TXSTM_L4DE ,A.GPDE_RP_TXSTM_L4YT ,A.GPDE_RP_TXSTM_L5DE ,A.GPDE_RP_TXSTM_L5YT ,A.GPDE_RP_TXSTM_L6DE ,A.GPDE_RP_TXSTM_L6YT ,A.GPDE_RP_UNPD_CALDY ,A.GPDE_RP_LMP_TXPMKN ,A.GPDE_TX_AVAN_YTD ,A.GPDE_TX_KVAN_YTD ,A.GPDE_TX_PVAN_YTD ,A.GPDE_TX_RVAN_YTD ,A.GPDE_TX_RVAG_YTD ,A.GPDE_TX_KVPVPR_YTD ,A.GPDE_TX_VWAN_YTD ,A.GPDE_TX_VWAG_YTD ,A.GPDE_TX_KVAGPR_YD ,A.GPDE_TX_KVAGVL_YD ,A.GPDE_TX_PVAGVP_YD FROM PS_GPDE_RP_0002 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 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
10 PRD_END_DT Date(10) DATE Pay Period End Date
11 GPDE_AL_CPAY_ENDDT Date(10) DATE Current Pay End Date
12 GPDE_RP_NOI_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Nmbr of Workinterruptions YTD
13 GPDE_RP_TXGRSS_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Annualized/Bonus Tax Gross YTD
14 GPDE_RP_TAX_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Annualized/Bonus Tax YTD
15 GPDE_RP_SLDRTY_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Annualized/Bonus Soli Tax YTD
16 GPDE_RP_CHRTXE_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Annualized/BonusChrchTxEE YTD
17 GPDE_RP_CHRTXS_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Annualized/BonusChrchTxSP YTD
18 GPDE_RP_PENS_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Annualized/Bonus PensGrs YTD
19 GPDE_RP_MYPENS_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL MY Pension Gross YTD
20 GPDE_RP_MYTXGR_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL MY Tax Gross YTD
21 GPDE_RP_MYTAX_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL MY Tax YTD
22 GPDE_RP_MYSLDR_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL MY Solidarity Tax YTD
23 GPDE_RP_MYCTXE_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL MY Church Tax EE YTD
24 GPDE_RP_MYCTXS_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL MY Church Tax SP YTD
25 GPDE_RP_KUGMAT_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL KUG, SWG and Maternity YTD
26 GPDE_RP_ATZ_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Old Age Parttime YTD
27 GPDE_RP_DBA_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Double Taxation Agreement YTD
28 GPDE_RP_ATE_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Expatriate Agreement GrossYTD
29 GPDE_RP_TRVTXF_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Taxfree Travel Expenses YTD
30 GPDE_RP_TRVTXL_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Lump Sum Travel Expens YTD
31 GPDE_RP_FDALLW_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Txfree Food Allowences YTD
32 GPDE_RP_DH_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Double Household Expenses YTD
33 GPDE_RP_HCAG_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL ER Health/NCare Ins Cntrb YTD
34 GPDE_RP_SIEE_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL EE SI Contribution YTD
35 GPDE_RP_KVAN_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL EE HI Contribution YTD
36 GPDE_RP_RVAN_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL EE PI Contribution YTD
37 GPDE_RP_AVAN_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL EE UI Contribution YTD
38 GPDE_RP_PVAN_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL EE CI Contribution YTD
39 GPDE_RP_KVAG_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL ER HI Contribution YTD
40 GPDE_RP_RVAG_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL ER PI Contribution YTD
41 GPDE_RP_AVAG_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL ER UI Contribution YTD
42 GPDE_RP_PVAG_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL ER CI Contribution YTD
43 GPDE_RP_VACBAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Vacation Balance
44 GPDE_RP_VACENT Signed Number(20,6) DECIMAL(18,6) NOT NULL Vacation Entitlement
45 GPDE_RP_VACTAKE Signed Number(20,6) DECIMAL(18,6) NOT NULL Vacation Take
46 GPDE_RP_VACPYR Signed Number(20,6) DECIMAL(18,6) NOT NULL Vacation Balance Previous Year
47 GPDE_RP_WRKDHRS Signed Number(20,6) DECIMAL(18,6) NOT NULL Total of Worked Hours
48 GPDE_RP_OVRTMHRS Signed Number(20,6) DECIMAL(18,6) NOT NULL Total of Overtime Hours
49 GPDE_RP_TOTGRSS Signed Number(20,6) DECIMAL(18,6) NOT NULL Total of Gross
50 GPDE_RP_TTGRSS_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Total of Gross
51 GPDE_RP_TAX_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
52 GPDE_RP_SLDRTY_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
53 GPDE_RP_CHTXEE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
54 GPDE_RP_CHTXSP_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
55 GPDE_RP_CHTXLE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
56 GPDE_RP_CHTXLC_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
57 GPDE_RP_CHTXLJ_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
58 GPDE_RP_CHTX_LMPS Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
59 GPDE_RP_LMP_TOT Signed Number(20,6) DECIMAL(18,6) NOT NULL Taxfree Travel Expenses YTD
60 GPDE_RP_CHMBBR_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
61 GPDE_RP_CHMBSA_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
62 GPDE_RP_SIDAYS_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
63 GPDE_RP_SIGRSA_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
64 GPDE_RP_SIGRSB_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
65 GPDE_RP_SIGRSS_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
66 GPDE_RP_TXMYGR_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Annualized/Bonus Tax Gross YTD
67 GPDE_RP_PENTXF_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Taxfree Travel Expenses YTD
68 GPDE_RP_TXDAYS Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
69 GPDE_RP_TXGRS_TOT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
70 GPDE_RP_TXGRS_ANLZ Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
71 GPDE_RP_TXGRS_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
72 GPDE_RP_TXGRS_PEN Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
73 GPDE_RP_TXGRS_MYBN Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
74 GPDE_RP_TXGRS_MYPN Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
75 GPDE_RP_TAX Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
76 GPDE_RP_CHRCH_TAX Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
77 GPDE_RP_SLDRTY_TAX Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
78 GPDE_RP_TAX_MY Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
79 GPDE_RP_CRCH_TX_MY Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
80 GPDE_RP_SLDY_TX_MY Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
81 GPDE_RP_PENTXF Signed Number(20,6) DECIMAL(18,6) NOT NULL Taxfree Travel Expenses YTD
82 GPDE_RP_NOI Signed Number(20,6) DECIMAL(18,6) NOT NULL Nmbr of Workinterruptions YTD
83 GPDE_RP_STATDD_SUM Signed Number(20,6) DECIMAL(18,6) NOT NULL Taxfree Travel Expenses YTD
84 GPDE_RP_DED_SUM Signed Number(20,6) DECIMAL(18,6) NOT NULL Taxfree Travel Expenses YTD
85 GPDE_RP_LMP_DIRINS Signed Number(20,6) DECIMAL(18,6) NOT NULL Taxfree Travel Expenses YTD
86 GPDE_RP_LMP_TRVLEX Signed Number(20,6) DECIMAL(18,6) NOT NULL Taxfree Travel Expenses YTD
87 GPDE_RP_LMP_GRSS Signed Number(20,6) DECIMAL(18,6) NOT NULL Taxfree Travel Expenses YTD
88 GPDE_RP_LMP_TXEE Signed Number(20,6) DECIMAL(18,6) NOT NULL Taxfree Travel Expenses YTD
89 GPDE_RP_LMP_CHTXEE Signed Number(20,6) DECIMAL(18,6) NOT NULL Taxfree Travel Expenses YTD
90 GPDE_RP_LMP_SLTXEE Signed Number(20,6) DECIMAL(18,6) NOT NULL Taxfree Travel Expenses YTD
91 GPDE_RP_LMP_TXER Signed Number(20,6) DECIMAL(18,6) NOT NULL Taxfree Travel Expenses YTD
92 GPDE_RP_LMP_CHTXER Signed Number(20,6) DECIMAL(18,6) NOT NULL Taxfree Travel Expenses YTD
93 GPDE_RP_LMP_SLTXER Signed Number(20,6) DECIMAL(18,6) NOT NULL Taxfree Travel Expenses YTD
94 GPDE_TX_MJ_LUMP Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
95 GPDE_RP_A2_9190 Signed Number(20,6) DECIMAL(18,6) NOT NULL Total of Gross
96 GPDE_RP_A2_9290 Signed Number(20,6) DECIMAL(18,6) NOT NULL Total of Gross
97 GPDE_RP_A2_9390 Signed Number(20,6) DECIMAL(18,6) NOT NULL Total of Gross
98 GPDE_RP_TXSTM_L1DE Character(20) VARCHAR2(20) NOT NULL Tax Statment Customer Configurable Line 1
99 GPDE_RP_TXSTM_L1YT Signed Number(20,6) DECIMAL(18,6) NOT NULL Total of Gross
100 GPDE_RP_TXSTM_L2DE Character(20) VARCHAR2(20) NOT NULL Tax Statment Customer Configurable Line 2
101 GPDE_RP_TXSTM_L2YT Signed Number(20,6) DECIMAL(18,6) NOT NULL Total of Gross
102 GPDE_RP_TXSTM_L3DE Character(20) VARCHAR2(20) NOT NULL Tax Statment Customer Configurable Line 3
103 GPDE_RP_TXSTM_L3YT Signed Number(20,6) DECIMAL(18,6) NOT NULL Total of Gross
104 GPDE_RP_TXSTM_L4DE Character(20) VARCHAR2(20) NOT NULL Report Text for Tax Statement
105 GPDE_RP_TXSTM_L4YT Signed Number(20,6) DECIMAL(18,6) NOT NULL Total of Gross
106 GPDE_RP_TXSTM_L5DE Character(20) VARCHAR2(20) NOT NULL Report Text for Tax Statement
107 GPDE_RP_TXSTM_L5YT Signed Number(20,6) DECIMAL(18,6) NOT NULL Total of Gross
108 GPDE_RP_TXSTM_L6DE Character(20) VARCHAR2(20) NOT NULL Report Text for Tax Statement
109 GPDE_RP_TXSTM_L6YT Signed Number(20,6) DECIMAL(18,6) NOT NULL Total of Gross
110 GPDE_RP_UNPD_CALDY Signed Number(4,0) DECIMAL(3) NOT NULL Unpaid Calendar Days
111 GPDE_RP_LMP_TXPMKN Signed Number(20,6) DECIMAL(18,6) NOT NULL Lumpsum Tax Payment in Kind
112 GPDE_TX_AVAN_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL EE UI Contribution YTD
113 GPDE_TX_KVAN_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL EE HI Contribution YTD
114 GPDE_TX_PVAN_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL EE CI Contribution YTD
115 GPDE_TX_RVAN_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL EE PI Contribution YTD
116 GPDE_TX_RVAG_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL ER PI Contribution YTD
117 GPDE_TX_KVPVPR_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL ER PI Contribution YTD
118 GPDE_TX_VWAN_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL EE Contribution YTD for Pension Fund
119 GPDE_TX_VWAG_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL ER Contribution YTD for Pension Fund
120 GPDE_TX_KVAGPR_YD Signed Number(20,6) DECIMAL(18,6) NOT NULL ER Contribution YTD for Pension Fund
121 GPDE_TX_KVAGVL_YD Signed Number(20,6) DECIMAL(18,6) NOT NULL ER Contribution YTD for Pension Fund
122 GPDE_TX_PVAGVP_YD Signed Number(20,6) DECIMAL(18,6) NOT NULL ER Contribution YTD for Pension Fund