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) |
# | 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 |