BAS_ENR_PLAN_V1 (SQL View)	Index Back
BAS Enr Runctl-Sch Plan BenPgm BAS_ENR_PLAN_V1 is a view used by the Benefits Administration Run Control panel to return benefit programs for Open Enrollment option reprocessing.

BAS_ENR_PLAN_V1

(SQL View)

BAS Enr Runctl-Sch Plan BenPgm

BAS_ENR_PLAN_V1 is a view used by the Benefits Administration Run Control panel to return benefit programs for Open Enrollment option reprocessing.

SELECT DISTINCT OE_DEFN_ID ,BENEFIT_PROGRAM 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.

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