BAS_OE_DEFN (SQL Table)	Index Back
BAS OE Defn BAS_OE_DEFN is a record that allows you to establish an ID for a set of benefit programs and plan types to include during Open Enrollment Benefits Administration processing. The record defines the effective date, description, period begin date, and period end date.

BAS_OE_DEFN

(SQL Table)

BAS OE Defn

BAS_OE_DEFN is a record that allows you to establish an ID for a set of benefit programs and plan types to include during Open Enrollment Benefits Administration processing. The record defines the effective date, description, period begin date, and period end date.

Related Language Record: BAS_OE_DEFN_LNG

Parent Record Of 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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

4 PERIOD_BEGIN_DT Date(10) DATE NOT NULL Period Begin Date

5 PERIOD_END_DT Date(10) DATE NOT NULL Period End Date

6 GVT_OS_BEGIN_DT Date(10) DATE Enrollment Begin Date

7 GVT_OS_END_DT Date(10) DATE Enrollment End Date

8 EVENT_CLASS Character(3) VARCHAR2(3) NOT NULL Event Classification
Prompt Table: BAS_EVT_CLASS

#	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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
4	PERIOD_BEGIN_DT	Date(10)	DATE NOT NULL	Period Begin Date
5	PERIOD_END_DT	Date(10)	DATE NOT NULL	Period End Date
6	GVT_OS_BEGIN_DT	Date(10)	DATE	Enrollment Begin Date
7	GVT_OS_END_DT	Date(10)	DATE	Enrollment End Date
8	EVENT_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Event Classification Prompt Table: BAS_EVT_CLASS