GPDE_RP_FL01_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_DV_SV_CODE ,A.GPDE_FL_CGRP_KV_E ,A.GPDE_FL_CGRP_RV_E ,A.GPDE_FL_CGRP_AV_E ,A.GPDE_FL_CGRP_PV_E ,A.GPDE_FL_CGRP_KV_W ,A.GPDE_FL_CGRP_RV_W ,A.GPDE_FL_CGRP_AV_W ,A.GPDE_FL_CGRP_PV_W ,A.GPDE_FL_BTNR_EAST ,A.GPDE_FL_BTNR_WEST ,A.GPDE_FL_RP_1S1AG ,A.GPDE_FL_RP_1S1AN ,A.GPDE_FL_RP_1S1B ,A.GPDE_FL_RP_1S2AG ,A.GPDE_FL_RP_1S2AN ,A.GPDE_FL_RP_1S2B ,A.GPDE_FL_RP_1S3AG ,A.GPDE_FL_RP_1S3AN ,A.GPDE_FL_RP_1S3B ,A.GPDE_FL_RP_1S4AG ,A.GPDE_FL_RP_1S4AN ,A.GPDE_FL_RP_1S4B ,A.GPDE_FL_RP_2S1AG ,A.GPDE_FL_RP_2S1AN ,A.GPDE_FL_RP_2S1B ,A.GPDE_FL_RP_2S2AG ,A.GPDE_FL_RP_2S2AN ,A.GPDE_FL_RP_2S2B ,A.GPDE_FL_RP_2S3AG ,A.GPDE_FL_RP_2S3AN ,A.GPDE_FL_RP_2S3B ,A.GPDE_FL_RP_2S4AG ,A.GPDE_FL_RP_2S4AN ,A.GPDE_FL_RP_2S4B ,A.GPDE_FL_L001S1_MON ,A.GPDE_FL_L001S2_MON ,A.GPDE_FL_L001S3_MON ,A.GPDE_FL_L001S4_MON ,A.GPDE_FL_L001S1_YTD ,A.GPDE_FL_L001S2_YTD ,A.GPDE_FL_L001S3_YTD ,A.GPDE_FL_L001S4_YTD ,A.GPDE_FL_RP_L001S1 ,A.GPDE_FL_RP_L001S2 ,A.GPDE_FL_RP_L001S3 ,A.GPDE_FL_RP_L001S4 ,A.GPDE_FL_L002S1_MON ,A.GPDE_FL_L002S2_MON ,A.GPDE_FL_L002S3_MON ,A.GPDE_FL_L002S4_MON ,A.GPDE_FL_L002S1_YTD ,A.GPDE_FL_L002S2_YTD ,A.GPDE_FL_L002S3_YTD ,A.GPDE_FL_L002S4_YTD ,A.GPDE_FL_RP_L002S1 ,A.GPDE_FL_RP_L002S2 ,A.GPDE_FL_RP_L002S3 ,A.GPDE_FL_RP_L002S4 ,A.GPDE_FL_W001E0_MON ,A.GPDE_FL_W001E0_YTD ,A.GPDE_FL_RP_W001E0 ,A.GPDE_FL_W002E0_MON ,A.GPDE_FL_W002E0_YTD ,A.GPDE_FL_RP_W002E0 ,A.GPDE_FL_W011E0_MON ,A.GPDE_FL_W011E0_YTD ,A.GPDE_FL_RP_W011E0 ,A.GPDE_FL_W012E0_MON ,A.GPDE_FL_W012E0_YTD ,A.GPDE_FL_RP_W012E0 ,A.GPDE_FL_W020E0_MON ,A.GPDE_FL_W020E0_YTD ,A.GPDE_FL_RP_W020E0 ,A.GPDE_FL_W001E0_TMP ,A.GPDE_FL_W002E0_TMP ,A.GPDE_FL_STFGRUNL_E ,A.GPDE_FL_STFGRUNL_W FROM PS_GPDE_RP_FL01 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_DV_SV_CODE Character(4) VARCHAR2(4) NOT NULL DEUEV Contribution Group Code
14 GPDE_FL_CGRP_KV_E Character(1) VARCHAR2(1) NOT NULL Contribution Group
15 GPDE_FL_CGRP_RV_E Character(1) VARCHAR2(1) NOT NULL Contribution Group
16 GPDE_FL_CGRP_AV_E Character(1) VARCHAR2(1) NOT NULL Contribution Group
17 GPDE_FL_CGRP_PV_E Character(1) VARCHAR2(1) NOT NULL Contribution Group
18 GPDE_FL_CGRP_KV_W Character(1) VARCHAR2(1) NOT NULL Contribution Group
19 GPDE_FL_CGRP_RV_W Character(1) VARCHAR2(1) NOT NULL Contribution Group
20 GPDE_FL_CGRP_AV_W Character(1) VARCHAR2(1) NOT NULL Contribution Group
21 GPDE_FL_CGRP_PV_W Character(1) VARCHAR2(1) NOT NULL Contribution Group
22 GPDE_FL_BTNR_EAST Character(8) VARCHAR2(8) NOT NULL Employer SI Number
23 GPDE_FL_BTNR_WEST Character(8) VARCHAR2(8) NOT NULL Employer SI Number
24 GPDE_FL_RP_1S1AG Signed Number(20,6) DECIMAL(18,6) NOT NULL ER SIH Contrib. Stoerfall Eas
25 GPDE_FL_RP_1S1AN Signed Number(20,6) DECIMAL(18,6) NOT NULL EE SIH Contrib. Stoerfall East
26 GPDE_FL_RP_1S1B Signed Number(20,6) DECIMAL(18,6) NOT NULL SIH Gross Stoerfall Region Eas
27 GPDE_FL_RP_1S2AG Signed Number(20,6) DECIMAL(18,6) NOT NULL ER SIC Contrib. Stoerfall East
28 GPDE_FL_RP_1S2AN Signed Number(20,6) DECIMAL(18,6) NOT NULL EE SIC Contrib. Stoerfall East
29 GPDE_FL_RP_1S2B Signed Number(20,6) DECIMAL(18,6) NOT NULL SIC Gross Stoerfall Region Eas
30 GPDE_FL_RP_1S3AG Signed Number(20,6) DECIMAL(18,6) NOT NULL ER SIP Contrib. Stoerfall East
31 GPDE_FL_RP_1S3AN Signed Number(20,6) DECIMAL(18,6) NOT NULL EE SIP Contrib. Stoerfall East
32 GPDE_FL_RP_1S3B Signed Number(20,6) DECIMAL(18,6) NOT NULL SIP Gross Stoerfall Region Eas
33 GPDE_FL_RP_1S4AG Signed Number(20,6) DECIMAL(18,6) NOT NULL ER SIU Contrib. Stoerfall East
34 GPDE_FL_RP_1S4AN Signed Number(20,6) DECIMAL(18,6) NOT NULL EE SIU Contrib. Stoerfall East
35 GPDE_FL_RP_1S4B Signed Number(20,6) DECIMAL(18,6) NOT NULL SIU Gross Stoerfall Region Eas
36 GPDE_FL_RP_2S1AG Signed Number(20,6) DECIMAL(18,6) NOT NULL ER SIH Contrib. Stoerfall West
37 GPDE_FL_RP_2S1AN Signed Number(20,6) DECIMAL(18,6) NOT NULL EE SIH Contrib. Stoerfall West
38 GPDE_FL_RP_2S1B Signed Number(20,6) DECIMAL(18,6) NOT NULL SIH Gross Stoerfall Region Wes
39 GPDE_FL_RP_2S2AG Signed Number(20,6) DECIMAL(18,6) NOT NULL ER SIC Contrib. Stoerfall West
40 GPDE_FL_RP_2S2AN Signed Number(20,6) DECIMAL(18,6) NOT NULL EE SIC Contrib. Stoerfall West
41 GPDE_FL_RP_2S2B Signed Number(20,6) DECIMAL(18,6) NOT NULL SIC Gross Stoerfall Region Wes
42 GPDE_FL_RP_2S3AG Signed Number(20,6) DECIMAL(18,6) NOT NULL ER SIP Contrib. Stoerfall West
43 GPDE_FL_RP_2S3AN Signed Number(20,6) DECIMAL(18,6) NOT NULL EE SIP Contrib. Stoerfall West
44 GPDE_FL_RP_2S3B Signed Number(20,6) DECIMAL(18,6) NOT NULL SIP Gross Stoerfall Region Wes
45 GPDE_FL_RP_2S4AG Signed Number(20,6) DECIMAL(18,6) NOT NULL ER SIU Contrib. Stoerfall West
46 GPDE_FL_RP_2S4AN Signed Number(20,6) DECIMAL(18,6) NOT NULL EE SIU Contrib. Stoerfall West
47 GPDE_FL_RP_2S4B Signed Number(20,6) DECIMAL(18,6) NOT NULL SIU Gross Stoerfall Region Wes
48 GPDE_FL_L001S1_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
49 GPDE_FL_L001S2_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
50 GPDE_FL_L001S3_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
51 GPDE_FL_L001S4_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
52 GPDE_FL_L001S1_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
53 GPDE_FL_L001S2_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
54 GPDE_FL_L001S3_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
55 GPDE_FL_L001S4_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
56 GPDE_FL_RP_L001S1 Signed Number(20,6) DECIMAL(18,6) NOT NULL gross space SIH east
57 GPDE_FL_RP_L001S2 Signed Number(20,6) DECIMAL(18,6) NOT NULL gross space SIC east
58 GPDE_FL_RP_L001S3 Signed Number(20,6) DECIMAL(18,6) NOT NULL gross space SIP east
59 GPDE_FL_RP_L001S4 Signed Number(20,6) DECIMAL(18,6) NOT NULL gross space SIU east
60 GPDE_FL_L002S1_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
61 GPDE_FL_L002S2_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
62 GPDE_FL_L002S3_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
63 GPDE_FL_L002S4_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
64 GPDE_FL_L002S1_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
65 GPDE_FL_L002S2_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
66 GPDE_FL_L002S3_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
67 GPDE_FL_L002S4_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
68 GPDE_FL_RP_L002S1 Signed Number(20,6) DECIMAL(18,6) NOT NULL gross space SIH west
69 GPDE_FL_RP_L002S2 Signed Number(20,6) DECIMAL(18,6) NOT NULL gross space SIC west
70 GPDE_FL_RP_L002S3 Signed Number(20,6) DECIMAL(18,6) NOT NULL gross space SIP west
71 GPDE_FL_RP_L002S4 Signed Number(20,6) DECIMAL(18,6) NOT NULL gross space SIU west
72 GPDE_FL_W001E0_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
73 GPDE_FL_W001E0_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
74 GPDE_FL_RP_W001E0 Signed Number(20,6) DECIMAL(18,6) NOT NULL Savings balance money east
75 GPDE_FL_W002E0_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
76 GPDE_FL_W002E0_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
77 GPDE_FL_RP_W002E0 Signed Number(20,6) DECIMAL(18,6) NOT NULL Savings balance money west
78 GPDE_FL_W011E0_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
79 GPDE_FL_W011E0_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
80 GPDE_FL_RP_W011E0 Signed Number(20,6) DECIMAL(18,6) NOT NULL Savings balance time-units eas
81 GPDE_FL_W012E0_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
82 GPDE_FL_W012E0_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
83 GPDE_FL_RP_W012E0 Signed Number(20,6) DECIMAL(18,6) NOT NULL Savings balance time-units wes
84 GPDE_FL_W020E0_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
85 GPDE_FL_W020E0_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
86 GPDE_FL_RP_W020E0 Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
87 GPDE_FL_W001E0_TMP Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
88 GPDE_FL_W002E0_TMP Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
89 GPDE_FL_STFGRUNL_E Signed Number(20,6) DECIMAL(18,6) NOT NULL Unlimited Gross Stoerfall East
90 GPDE_FL_STFGRUNL_W Signed Number(20,6) DECIMAL(18,6) NOT NULL Unlimited Gross Stoerfall West