GPES_FIE_BER_VL

(SQL View)
 Index Back

Benefit end payment reason lng

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. Related language view.

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

  • Related Language Record for GPES_FIE_BER_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR125 Character(125) VARCHAR2(125) NOT NULL Long Description