EXCLD_BENPL_LNG(SQL View) |
Index Back |
---|---|
Excluded BenPlans- Rel LangThis is the related language view associated with CNTRL_BENPL_VW, which is a prompt table which provides plan type, benefit plan and description for use by "excluded" benefit plans |
SELECT P.PLAN_TYPE ,P.BENEFIT_PLAN ,P.LANGUAGE_CD ,P.EFFDT ,P.DESCR ,P.DESCRSHORT FROM PS_BENEF_PLAN_LANG P |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(2) | VARCHAR2(2) NOT NULL |
This is used to identify the controlling Plan Type on setup tables, when PLAN_TYPE is already a record key.
Prompt Table: PLAN_TYPE_VW |
|
2 | Character(6) | VARCHAR2(6) NOT NULL |
This is used to identify the controlling Benefit Plan on setup tables, when BENEFIT_PLAN is already a record key.
Prompt Table: BENEF_PLAN_TBL |
|
3 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
4 | Date(10) | DATE | Effective Date | |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |