TL_BENP_LNG

(SQL View)
 Index Back

TL Benefit Plan valuelist VW


SELECT DISTINCT B.BENEFIT_PLAN , B.LANGUAGE_CD , B.DESCR FROM PS_LEAVE_ACCRUAL A , PS_BENEF_PLAN_LANG B WHERE A.PLAN_TYPE = B.PLAN_TYPE

  • Related Language Record for TL_BENEF_PLAN_V

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description