GP_ABS_LVDNVWLN

(SQL View)
Index Back

Abs Leave Donation Lang View

Abs Leave Donation Lang View

SELECT OP.OPRID , P.COUNTRY , P.LVDN_PRGM_ID , P.LANGUAGE_CD , C.DESCR , P.DESCR FROM PS_GP_ABS_LVDN_LNG P , PS_GP_OPR_RULE_PRF OP , PS_COUNTRYTBL_LANG C WHERE (OP.COUNTRY = 'ALL' OR P.COUNTRY = OP.COUNTRY) AND P.COUNTRY = C.COUNTRY AND P.LANGUAGE_CD = C.LANGUAGE_CD

  • Related Language Record for GP_ABS_LVDN_VW GP_ABS_LVPRG_VW
  • # 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_LVDN_VW

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr