GPES_FIE_ATY_VW

(SQL View)
 Index Back

FIE Absence type

FIE File absence type codes mapped to GP Core absence types.

SELECT CASE WHEN AT1.ABS_TYPE_OPTN = 'ACC' THEN '3' WHEN AT1.ABS_TYPE_OPTN = 'DIS' THEN '1' WHEN AT1.ABS_TYPE_OPTN = 'MAT' THEN 'NC' WHEN AT1.ABS_TYPE_OPTN = 'RSK' THEN 'RE' WHEN AT1.ABS_TYPE_OPTN = 'CUI' THEN 'CM' END , AT1.ABS_TYPE_OPTN , CASE WHEN AT1.ABS_TYPE_OPTN = 'ACC' THEN '3' WHEN AT1.ABS_TYPE_OPTN = 'DIS' THEN '1' WHEN AT1.ABS_TYPE_OPTN = 'MAT' THEN 'NC' WHEN AT1.ABS_TYPE_OPTN = 'RSK' THEN 'RE' WHEN AT1.ABS_TYPE_OPTN = 'CUI' THEN 'CM' END %Concat ' - ' %Concat AT1.DESCR FROM PS_GP_ABS_TYPE AT1 WHERE (AT1.USED_BY = 'A' OR AT1.COUNTRY ='ESP') AND AT1.ABS_TYPE_OPTN IN ('ACC', 'DIS', 'MAT', 'RSK', 'CUI') AND AT1.EFFDT = ( SELECT MAX(AT.EFFDT) FROM PS_GP_ABS_TYPE AT WHERE AT.USED_BY = AT1.USED_BY AND AT.COUNTRY = AT1.COUNTRY AND AT.ABS_TYPE_OPTN = AT1.ABS_TYPE_OPTN AND AT.EFFDT <= %CurrentDateIn) AND AT1.EFF_STATUS <> 'I' UNION SELECT CASE WHEN AT2.ABS_TYPE_OPTN = 'ACC' THEN '4' WHEN AT2.ABS_TYPE_OPTN = 'DIS' THEN '2' WHEN AT2.ABS_TYPE_OPTN = 'RSK' THEN 'RL' END , AT2.ABS_TYPE_OPTN , CASE WHEN AT2.ABS_TYPE_OPTN = 'ACC' THEN '4' WHEN AT2.ABS_TYPE_OPTN = 'DIS' THEN '2' WHEN AT2.ABS_TYPE_OPTN = 'RSK' THEN 'RL' END %Concat ' - ' %Concat AT2.DESCR FROM PS_GP_ABS_TYPE AT2 WHERE (AT2.USED_BY = 'A' OR AT2.COUNTRY ='ESP') AND AT2.ABS_TYPE_OPTN IN ('ACC', 'DIS', 'RSK') AND AT2.EFFDT = ( SELECT MAX(AT.EFFDT) FROM PS_GP_ABS_TYPE AT WHERE AT.USED_BY = AT2.USED_BY AND AT.COUNTRY = AT2.COUNTRY AND AT.ABS_TYPE_OPTN = AT2.ABS_TYPE_OPTN AND AT.EFFDT <= %CurrentDateIn) AND AT2.EFF_STATUS <> 'I' UNION SELECT CASE WHEN AT3.ABS_TYPE_OPTN = 'ACC' THEN '5' END , AT3.ABS_TYPE_OPTN , CASE WHEN AT3.ABS_TYPE_OPTN = 'ACC' THEN '5' END %Concat ' - ' %Concat AT3.DESCR FROM PS_GP_ABS_TYPE AT3 WHERE (AT3.USED_BY = 'A' OR AT3.COUNTRY ='ESP') AND AT3.ABS_TYPE_OPTN IN ('ACC') AND AT3.EFFDT = ( SELECT MAX(AT.EFFDT) FROM PS_GP_ABS_TYPE AT WHERE AT.USED_BY = AT3.USED_BY AND AT.COUNTRY = AT3.COUNTRY AND AT.ABS_TYPE_OPTN = AT3.ABS_TYPE_OPTN AND AT.EFFDT <= %CurrentDateIn) AND AT3.EFF_STATUS <> 'I'

  • Related Language Record: GPES_FIE_ATY_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 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type
    3 DESCR40 Character(40) VARCHAR2(40) NOT NULL Description