GPES_ERE_DTA_VW

(SQL View)
 Index Back

ERE Complementary benefits

ERE Complementary benefits for employees included in an ERE procedure.

SELECT EE.EMPLID , EE.EMPL_RCD , EE.ERE_U_ACTN_TYP_ESP , EE.ERE_BGNDT_ESP , EE.ERE_ENDDT_ESP ,(CASE WHEN EE.ERE_U_ACTN_TYP_ESP = 'S' THEN ED.ERE_DAYS_TYPE_ESP WHEN EE.ERE_U_ACTN_TYP_ESP = 'P' THEN ED.ERE_DAYS_TYPE_ESP ELSE EE.ERE_U_ACTN_TYP_ESP END) , ED.ERE_WKD_CORR_ESP , ED.ERE_XTRPD_RD_ESP , ED.ERE_PIN_BN1_NUM , ED.ERE_TYP_WSRD_ESP , ED.ERE_SCH_DST_ESP , EE.FTE_AVG_ESP FROM PS_ERE_ALL_EE_VW EE , PS_ERE_DATA_ESP ED WHERE ERE_U_ACTN_TYP_ESP <> 'P' AND EE.ERE_ID_ESP = ED.ERE_ID_ESP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 ERE_U_ACTN_TYP_ESP Character(1) VARCHAR2(1) NOT NULL ERE Update action type
D=Daily Hours Reduction
P=Permanent
S=Suspension
W=Work Day Reduction
4 ERE_BGNDT_ESP Date(10) DATE ERE Begin date
5 ERE_ENDDT_ESP Date(10) DATE ERE End date
6 ERE_DAYS_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL ERE Days type
N=Natural
W=Working

Default Value: N

7 ERE_WKD_CORR_ESP Number(5,2) DECIMAL(4,2) NOT NULL Work day correction factor.
8 ERE_XTRPD_RD_ESP Number(3,0) SMALLINT NOT NULL Extra period reduction percentage
9 GPES_PIN_SS1_NUM Number(8,0) INTEGER NOT NULL This field houses the Employer SS Accumulator Pin Number.
10 ERE_TYP_WSRD_ESP Character(1) VARCHAR2(1) NOT NULL Work schedule reduction ERE type
11 ERE_SCH_DST_ESP Character(1) VARCHAR2(1) NOT NULL Work schedule distribution
D=Daily Hours Reduction
W=Work Day Reduction
12 FTE_AVG_ESP Number(8,6) DECIMAL(7,6) NOT NULL FTE Average