GPES_FIE_BER_VW

(SQL View)
 Index Back

Benefitend payment reason

Retrieve description from XML code tables T-96RX, T-96CM or T-96NC depending on the value of GPES_FIE_ATY_VW.GPES_ABS_TYPE: RE, RL, CM or NC.

SELECT %Substring(BENEND.XML_XLAT_VALUE ,1 ,2) , ABSTYP.GPES_ABS_TYPE , BENEND.DESCR125 FROM PS_GPES_FIE_ATY_VW ABSTYP , PS_XML_XLATITEM BENEND WHERE ABSTYP.GPES_ABS_TYPE IN ('RE','RL') AND BENEND.SETID = 'ESP' AND BENEND.XML_XLAT_CODE = 'T-96RX' UNION SELECT %Substring(BENEND.XML_XLAT_VALUE ,1 ,2) , ABSTYP.GPES_ABS_TYPE , BENEND.DESCR125 FROM PS_GPES_FIE_ATY_VW ABSTYP , PS_XML_XLATITEM BENEND WHERE ABSTYP.GPES_ABS_TYPE IN ('CM') AND BENEND.SETID = 'ESP' AND BENEND.XML_XLAT_CODE = 'T-96CM' UNION SELECT %Substring(BENEND.XML_XLAT_VALUE ,1 ,2) , ABSTYP.GPES_ABS_TYPE , BENEND.DESCR125 FROM PS_GPES_FIE_ATY_VW ABSTYP , PS_XML_XLATITEM BENEND WHERE ABSTYP.GPES_ABS_TYPE IN ('NC') AND BENEND.SETID = 'ESP' AND BENEND.XML_XLAT_CODE = 'T-96NC'

  • Related Language Record: GPES_FIE_BER_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPES_ABS_TYPE Character(3) VARCHAR2(3) NOT NULL Absence type
    ACC=Industrial Accident
    CUI=Minors (Serious illness)
    DIS=Temporary Disability
    MAT=Maternity
    RSK=Risk on Pregnancy
    2 GPES_BEN_END_RSN Character(2) VARCHAR2(2) NOT NULL Benefit payment end reason
    3 DESCR125 Character(125) VARCHAR2(125) NOT NULL Long Description