PLAN_CAT_VW_LNG

(SQL View)
Index Back

Plan Categories (Related Lang)

This view returns related language elements for the broad benefit plan "categories" that group benefit plan types with common functionality and attributes.

SELECT %Substring(A.FIELDVALUE, 1, 1) , A.LANGUAGE_CD , A.XLATLONGNAME , A.XLATSHORTNAME FROM PSXLATITEMLANG A WHERE A.FIELDNAME='PLAN_CATEGORY' AND A.EFFDT= ( SELECT MAX(X.EFFDT) FROM PSXLATITEMLANG X WHERE X.FIELDNAME=A.FIELDNAME AND X.FIELDVALUE=A.FIELDVALUE AND X.LANGUAGE_CD=A.LANGUAGE_CD)

  • Related Language Record for PLN_CATEGORY_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PLAN_CATEGORY Character(1) VARCHAR2(1) NOT NULL This is used to identify a category of Benefits Plans, based on their common functional attributes.
    1=Health Benefits
    2=Life and Accidental Death
    3=Disability Insurance
    4=Savings Plans
    5=Leave
    6=Spending Accounts
    7=Retirement Plans
    8=Pension Plans
    9=Vacation Buy and Sell
    A=Simple Benefits
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description