PLN_CATEGORY_VW

(SQL View)
 Index Back

Benefit Plan Categories

This view returns the broad benefit plan "categories" that group benefit plan types with common functionality and attributes. Note that this view assumes the maximum Effective Date and does not respect Effective Status. Because Plan Categories are highlevel system features built into the Base Benefits architecture, we assume they cannot change over time.

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

  • Related Language Record: PLAN_CAT_VW_LNG

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description