GP_ABS_LVPRG_VW

(SQL View)
 Index Back

Abs Mgmt Leave Donation View

Absence Management Leave Donation View to show only active programs as of current date

SELECT OP.OPRID , P.COUNTRY , P.LVDN_PRGM_ID , C.DESCR , P.DESCR FROM PS_GP_ABS_LVDN_PRG P , PS_GP_OPR_RULE_PRF OP , PS_COUNTRY_TBL C WHERE (OP.COUNTRY = 'ALL' OR P.COUNTRY = OP.COUNTRY) AND P.COUNTRY = C.COUNTRY AND P.EFF_STATUS = 'A' AND P.BEGIN_DT <= %CurrentDateIn

  • Related Language Record: GP_ABS_LVDNVWLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: GP_CNTRY_OP_VW

    3 LVDN_PRGM_ID Character(10) VARCHAR2(10) NOT NULL Leave Program

    Prompt Table: GP_ABS_LVPRG_VW

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr