BEN_DEFN_PLAN (SQL Table)	Index Back
Benefit Plan-type Definition BEN_DEFN_PLAN is a record that defines the plan types for each benefit program and is used for processing in Payroll and Benefit Administration. For Benefit Administration, it contains information on each plan type such as the display plan sequence, event rules ID, etc.

BEN_DEFN_PLAN

(SQL Table)

Benefit Plan-type Definition

BEN_DEFN_PLAN is a record that defines the plan types for each benefit program and is used for processing in Payroll and Benefit Administration. For Benefit Administration, it contains information on each plan type such as the display plan sequence, event rules ID, etc.

Parent record: BEN_DEFN_PGM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.
Prompt Table: BEN_DEFN_PGM

2 EFFDT Date(10) DATE NOT NULL Effective Date

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.
Prompt Table: BN_PLAN_TYPE_VW

4 DISPLAY_PLN_SEQ Character(2) VARCHAR2(2) NOT NULL Display Plan-type Sequence

5 MIN_ANNUAL_CONTRIB Number(7,2) DECIMAL(6,2) NOT NULL Minimum Annual Contribution

6 MAX_ANNUAL_CONTRIB Number(11,2) DECIMAL(10,2) NOT NULL Maximum Annual Contribution

7 WAIVE_COVERAGE Character(1) VARCHAR2(1) NOT NULL Waive Coverage Permitted
N=Not Allowed
P=Allowed with Proof
X=Not Applicable
Y=Always Allowed
Default Value: N

8 RESTRICT_ENTRY_MM Number(2,0) SMALLINT NOT NULL Months to Restrict Data Entry

9 EVENT_RULES_ID Character(4) VARCHAR2(4) NOT NULL Event Rules ID
Prompt Table: BAS_EVENT_RULES

10 COBRA_PLAN Character(1) VARCHAR2(1) NOT NULL COBRA Plan?
Y/N Table Edit
Default Value: N

11 HIPAA_PLAN Character(1) VARCHAR2(1) NOT NULL HIPAA Plan
Y/N Table Edit

12 COLLECT_DEPBEN Character(1) VARCHAR2(1) NOT NULL This field tells the system whether to collect dependents or beneficiaries with the employee's enrollment.
Y/N Table Edit
Default Value: Y

13 COLLECT_FUNDS Character(1) VARCHAR2(1) NOT NULL This field tells the system whether to collect fund allocations with the employee's enrollment.
Y/N Table Edit
Default Value: Y

14 SHOW_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL This flag tells the system whether to show a plan type on the enrollment form if the employee has no choice in the election.
Y/N Table Edit
Default Value: Y

15 HANDBOOK_URL_ID Character(30) VARCHAR2(30) NOT NULL This field holds the ID of a URL object. The URL object points to the companies enrollment handbook.
Prompt Table: PSURLDEFN

16 DEP_RULE_ID Character(5) VARCHAR2(5) NOT NULL Dependent Rules ID
Prompt Table: DEP_RULE_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules. Prompt Table: BEN_DEFN_PGM
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
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. Prompt Table: BN_PLAN_TYPE_VW
4	DISPLAY_PLN_SEQ	Character(2)	VARCHAR2(2) NOT NULL	Display Plan-type Sequence
5	MIN_ANNUAL_CONTRIB	Number(7,2)	DECIMAL(6,2) NOT NULL	Minimum Annual Contribution
6	MAX_ANNUAL_CONTRIB	Number(11,2)	DECIMAL(10,2) NOT NULL	Maximum Annual Contribution
7	WAIVE_COVERAGE	Character(1)	VARCHAR2(1) NOT NULL	Waive Coverage Permitted N=Not Allowed P=Allowed with Proof X=Not Applicable Y=Always Allowed Default Value: N
8	RESTRICT_ENTRY_MM	Number(2,0)	SMALLINT NOT NULL	Months to Restrict Data Entry
9	EVENT_RULES_ID	Character(4)	VARCHAR2(4) NOT NULL	Event Rules ID Prompt Table: BAS_EVENT_RULES
10	COBRA_PLAN	Character(1)	VARCHAR2(1) NOT NULL	COBRA Plan? Y/N Table Edit Default Value: N
11	HIPAA_PLAN	Character(1)	VARCHAR2(1) NOT NULL	HIPAA Plan Y/N Table Edit
12	COLLECT_DEPBEN	Character(1)	VARCHAR2(1) NOT NULL	This field tells the system whether to collect dependents or beneficiaries with the employee's enrollment. Y/N Table Edit Default Value: Y
13	COLLECT_FUNDS	Character(1)	VARCHAR2(1) NOT NULL	This field tells the system whether to collect fund allocations with the employee's enrollment. Y/N Table Edit Default Value: Y
14	SHOW_PLAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	This flag tells the system whether to show a plan type on the enrollment form if the employee has no choice in the election. Y/N Table Edit Default Value: Y
15	HANDBOOK_URL_ID	Character(30)	VARCHAR2(30) NOT NULL	This field holds the ID of a URL object. The URL object points to the companies enrollment handbook. Prompt Table: PSURLDEFN
16	DEP_RULE_ID	Character(5)	VARCHAR2(5) NOT NULL	Dependent Rules ID Prompt Table: DEP_RULE_TBL