BAS_ENR_PLAN_V2 (SQL View)	Index Back
BAS Enr RunCtl-Sch Plan PlnTyp BAS_ENR_PLAN_V2 is a view used by the Benefits Administration Run Control panel to return plan types for Open Enrollment option reprocessing.

BAS_ENR_PLAN_V2

(SQL View)

BAS Enr RunCtl-Sch Plan PlnTyp

BAS_ENR_PLAN_V2 is a view used by the Benefits Administration Run Control panel to return plan types for Open Enrollment option reprocessing.

SELECT OE_DEFN_ID ,BENEFIT_PROGRAM ,PLAN_TYPE FROM PS_BAS_OE_DEFN_PLN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OE_DEFN_ID Character(4) VARCHAR2(4) NOT NULL Open Enrollment Definition ID

2 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.

3 PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OE_DEFN_ID	Character(4)	VARCHAR2(4) NOT NULL	Open Enrollment Definition ID
2	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules.
3	PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.