EXCLD_BENPL_LNG (SQL View)	Index Back
Excluded BenPlans- Rel Lang This 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

EXCLD_BENPL_LNG

(SQL View)

Excluded BenPlans- Rel Lang

This 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 CNTRL_PLAN_TYPE 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 CNTRL_BENEFIT_PLAN 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 EFFDT Date(10) DATE Effective Date

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CNTRL_PLAN_TYPE	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	CNTRL_BENEFIT_PLAN	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	EFFDT	Date(10)	DATE	Effective Date
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description