ERE_CNTR_VW_ESP

(SQL View)
 Index Back

ERE Base Contribution Data

ERE Base Contribution Data.

SELECT A.EMPLID , A.EMPL_RCD , A.TERMINATION_DT , A.TERMINATION_DT , 'P' , 'P' , A.DAILY_CNTB_BS_ESP , A.CONTRIB_DAYS_ESP , A.CONTRIB_BASE_ESP FROM PS_ERE_PERM_EE_ESP A UNION SELECT B.EMPLID , B.EMPL_RCD , B.ERE_BGNDT_ESP , B.ERE_ENDDT_ESP , 'S' , 'S' , B.DAILY_CNTB_BS_ESP , B.CONTRIB_DAYS_ESP , B.CONTRIB_BASE_ESP FROM PS_ERE_SUSP_EE_ESP B WHERE EXISTS ( SELECT 'X' FROM PS_INSTALLATION WHERE INSTALLED_GP_ESP = 'N') UNION SELECT C.EMPLID , C.EMPL_RCD , C.ERE_BGNDT_ESP , C.ERE_ENDDT_ESP , 'R' , C.ERE_SCH_DST_ESP , C.DAILY_CNTB_BS_ESP , C.CONTRIB_DAYS_ESP , C.CONTRIB_BASE_ESP FROM PS_ERE_WSRD_EE_ESP C WHERE EXISTS ( SELECT 'X' FROM PS_INSTALLATION WHERE INSTALLED_GP_ESP = 'N') UNION SELECT B.EMPLID , B.EMPL_RCD , B.BGN_DT , B.END_DT , 'S' , 'S' , %Round(%decdiv(B.CONTRIB_BASE_ESP, B.CONTRIB_DAYS_ESP), 2) , B.CONTRIB_DAYS_ESP , B.CONTRIB_BASE_ESP FROM PS_GPES_ABSEVT_AD B , PS_ERE_UPD_ACT_ESP B1 WHERE B.PIN_TAKE_NUM = B1.PIN_TAKE_NUM AND EXISTS ( SELECT 'X' FROM PS_INSTALLATION WHERE INSTALLED_GP_ESP = 'Y') AND B.CONTRIB_DAYS_ESP > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERS_SRCH_GBL

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

Prompt Table: EMPLOYMENT

3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 END_EFFDT Date(10) DATE End Effdt
5 ERE_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL ERE Type
P=Permanent
R=Schedule Reduction
S=Suspensive
6 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
7 DAILY_CNTB_BS_ESP Number(19,6) DECIMAL(18,6) NOT NULL Daily regulatory base (BRD: Base Reguladora Diaria)
8 CONTRIB_DAYS_ESP Number(4,0) SMALLINT NOT NULL Contribution Days
9 CONTRIB_BASE_ESP Number(19,6) DECIMAL(18,6) NOT NULL Common Contingency Base