F08320WFGetEnrolledPlansForDep

F08320WF Get Enrolled Plans for Dep/Ben Setup

Minor Business Rule

Object Name: N0800117

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose

This NER examines the Available Plans and Plan Options by Employee work file (F08320WF). If the NER
is given a Dependent/Beneficiary code (DBEN) of 'B' for beneficiary, the NER will find all the
beneficiary plans in the F08320WF work file which the employee has selected for enrollment. If the NER is
given a Dependent/Beneficiary code of 'D' for dependent, the NER will find all the plans selected for
enrollment in the F08320WF work file that are dependent plans or that track the Primary Care Physican
(PCPF = 1).

The program will sort the plans based on the order of the categories in the F08350 table and then by
the order of the plans based on the sequence number in the F08320WF work file. A maximum of ten plans
can be returned by this NER. The NER will also return the number of plans being returned.

Setup Notes and Prerequisites

Special Logic
Clear all output variables
F060116.Fetch Single (to retrieve the Benefit Group)

F08350.Select (based on the Benefit Group)
F08350.FetchNext
While File_IO_Status = SUCCESS
If DepBenFlag = 'B'
F08320WF.Select (limited to selected benefit
plans for this employee)
Else
F08320WF.Select (limited to selected plans for
this employee)
Endif

F08320WF.FetchNext(Load values in temporary variables)
While File_IO_Status = SUCCESS
If Beneficiary plan, Dependent plan, or PCPF =1
Counter = Counter + 1
If Counter = 1
Load values into output set 1
Else
If Counter = 2
Load values into output set 2
Else
...
Endif
Endif
Endif
Clear temporary variables
F08320WF.FetchNext
Endwhile
F08350.FetchNext
Endwhile

Technical Specification

mnAddressNumber - Required input field.
cDepBen - Required input field.
mnEnrollmentEventType - Required input field.

The first description in each set is the category description, the second description in each set is
the self-service benfits plan description.

szDescription001 - Output field.
szPlanID - Output field.
szPlanAdditionalOption - Output field.
szDescription50Characters - Output field.
mnTrackPCPNumber - Output field.

szDescription001_2 - Output field.
szPlanID_2 - Output field.
szPlanAdditionalOption_2 - Output field.
szDescription50Characters_2 - Output field.
mnTrackPCPNumber_2 - Output field.

szDescription001_3 - Output field.
szPlanID_3 - Output field.
szPlanAdditionalOption_3 - Output field.
szDescription50Characters_3 - Output field.
mnTrackPCPNumber_3 - Output field.

szDescription001_4 - Output field.
szPlanID_4 - Output field.
szPlanAdditionalOption_4 - Output field.
szDescription50Characters_4 - Output field.
mnTrackPCPNumber_4 - Output field.

szDescription001_5 - Output field.
szPlanID_5 - Output field.
szPlanAdditionalOption_5 - Output field.
szDescription50Characters_5 - Output field.
mnTrackPCPNumber_5 - Output field.

szDescription001_6 - Output field.
szPlanID_6 - Output field.
szPlanAdditionalOption_6 - Output field.
szDescription50Characters_6 - Output field.
mnTrackPCPNumber_6 - Output field.

szDescription001_7 - Output field.
szPlanID_7 - Output field.
szPlanAdditionalOption_7 - Output field.
szDescription50Characters_7 - Output field.
mnTrackPCPNumber_7 - Output field.

szDescription001_8 - Output field.
szPlanID_8 - Output field.
szPlanAdditionalOption_8 - Output field.
szDescription50Characters_8 - Output field.
mnTrackPCPNumber_8 - Output field.

szDescription001_9 - Output field.
szPlanID_9 - Output field.
szPlanAdditionalOption_9 - Output field.
szDescription50Characters_9 - Output field.
mnTrackPCPNumber_9 - Output field.

szDescription001_10 - Output field.
szPlanID_10 - Output field.
szPlanAdditionalOption_10 - Output field.
szDescription50Characters_10 - Output field.
mnTrackPCPNumber_10 - Output field.

mnNumberOfPlans- Output field.

^

Data Structure

D0800117 - F08320WF Get Enrolled Plans For Dep/Ben Setup

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnAddressNumber	AN8	MATH_NUMERIC	REQ	INPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
cDepBen	DBEN	char	REQ	INPUT
A code that indicates whether the person is a dependent or a beneficiary of the employee. Valid codes are: D The person is a dependent. B The person is a beneficiary. Blank The system automatically designates the person as a beneficiary or dependent, depending on the benefit plan type.
mnEnrollmentEventType	EVET	MATH_NUMERIC	REQ	INPUT
A field that indicates the event during which the enrollment occurs. Valid values include: 1 Open Enrollment 2 Enrollment for current plan year
szDescription001	DL01	char	OPT	OUTPUT
A user defined name or remark.
szPlanId	PLAN	char	OPT	OUTPUT
An abbreviation or number that identifies a specific employee benefit. Examples are: o Employee Health Insurance o Accidental Death and Dismemberment o Health Club Expense Reimbursement o Employee Stock Appreciation Rights A benefit plan typically is associated with a deduction, benefit, or accrual. For example, a medical plan is a benefit that might also require a deduction to withhold premiums from an employee's pay.
szPlanAdditionalOption	AOPT	char	OPT	OUTPUT
A code that identifies any additional options available for a benefit plan that have been defined in the Plan Additional Options table (F083202). Note: Additional options must have the same provider, policy number, and enrollment and eligibility rules as the benefit plan to which they are associated.
szDescription50Characters	DS50	char	OPT	OUTPUT
A descriptive statement of up to 50 characters in length.
mnTrackPCPNumberFlag	PCPF	MATH_NUMERIC	OPT	OUTPUT
An option that specifies whether the benefit plan or benefit plan option tracks primary care physician numbers. If you choose this option, then the system displays a form during the enrollment process for an employee to enter the number for a primary care physician.
szDescription001_2	DL01	char	OPT	OUTPUT
A user defined name or remark.
szPlanId_2	PLAN	char	OPT	OUTPUT
An abbreviation or number that identifies a specific employee benefit. Examples are: o Employee Health Insurance o Accidental Death and Dismemberment o Health Club Expense Reimbursement o Employee Stock Appreciation Rights A benefit plan typically is associated with a deduction, benefit, or accrual. For example, a medical plan is a benefit that might also require a deduction to withhold premiums from an employee's pay.
szPlanAdditionalOption_2	AOPT	char	OPT	OUTPUT
A code that identifies any additional options available for a benefit plan that have been defined in the Plan Additional Options table (F083202). Note: Additional options must have the same provider, policy number, and enrollment and eligibility rules as the benefit plan to which they are associated.
szDescription50Characters_2	DS50	char	OPT	OUTPUT
A descriptive statement of up to 50 characters in length.
mnTrackPCPNumberFlag_2	PCPF	MATH_NUMERIC	OPT	OUTPUT
An option that specifies whether the benefit plan or benefit plan option tracks primary care physician numbers. If you choose this option, then the system displays a form during the enrollment process for an employee to enter the number for a primary care physician.
szDescription001_3	DL01	char	OPT	OUTPUT
A user defined name or remark.
szPlanId_3	PLAN	char	OPT	OUTPUT
An abbreviation or number that identifies a specific employee benefit. Examples are: o Employee Health Insurance o Accidental Death and Dismemberment o Health Club Expense Reimbursement o Employee Stock Appreciation Rights A benefit plan typically is associated with a deduction, benefit, or accrual. For example, a medical plan is a benefit that might also require a deduction to withhold premiums from an employee's pay.
szPlanAdditionalOption_3	AOPT	char	OPT	OUTPUT
A code that identifies any additional options available for a benefit plan that have been defined in the Plan Additional Options table (F083202). Note: Additional options must have the same provider, policy number, and enrollment and eligibility rules as the benefit plan to which they are associated.
szDescription50Characters_3	DS50	char	OPT	OUTPUT
A descriptive statement of up to 50 characters in length.
mnTrackPCPNumberFlag_3	PCPF	MATH_NUMERIC	OPT	OUTPUT
An option that specifies whether the benefit plan or benefit plan option tracks primary care physician numbers. If you choose this option, then the system displays a form during the enrollment process for an employee to enter the number for a primary care physician.
szDescription001_4	DL01	char	OPT	OUTPUT
A user defined name or remark.
szPlanId_4	PLAN	char	OPT	OUTPUT
An abbreviation or number that identifies a specific employee benefit. Examples are: o Employee Health Insurance o Accidental Death and Dismemberment o Health Club Expense Reimbursement o Employee Stock Appreciation Rights A benefit plan typically is associated with a deduction, benefit, or accrual. For example, a medical plan is a benefit that might also require a deduction to withhold premiums from an employee's pay.
szPlanAdditionalOption_4	AOPT	char	OPT	OUTPUT
A code that identifies any additional options available for a benefit plan that have been defined in the Plan Additional Options table (F083202). Note: Additional options must have the same provider, policy number, and enrollment and eligibility rules as the benefit plan to which they are associated.
szDescription50Characters_4	DS50	char	OPT	OUTPUT
A descriptive statement of up to 50 characters in length.
mnTrackPCPNumberFlag_4	PCPF	MATH_NUMERIC	OPT	OUTPUT
An option that specifies whether the benefit plan or benefit plan option tracks primary care physician numbers. If you choose this option, then the system displays a form during the enrollment process for an employee to enter the number for a primary care physician.
szDescription001_5	DL01	char	OPT	OUTPUT
A user defined name or remark.
szPlanId_5	PLAN	char	OPT	OUTPUT
An abbreviation or number that identifies a specific employee benefit. Examples are: o Employee Health Insurance o Accidental Death and Dismemberment o Health Club Expense Reimbursement o Employee Stock Appreciation Rights A benefit plan typically is associated with a deduction, benefit, or accrual. For example, a medical plan is a benefit that might also require a deduction to withhold premiums from an employee's pay.
szPlanAdditionalOption_5	AOPT	char	OPT	OUTPUT
A code that identifies any additional options available for a benefit plan that have been defined in the Plan Additional Options table (F083202). Note: Additional options must have the same provider, policy number, and enrollment and eligibility rules as the benefit plan to which they are associated.
szDescription50Characters_5	DS50	char	OPT	OUTPUT
A descriptive statement of up to 50 characters in length.
mnTrackPCPNumberFlag_5	PCPF	MATH_NUMERIC	OPT	OUTPUT
An option that specifies whether the benefit plan or benefit plan option tracks primary care physician numbers. If you choose this option, then the system displays a form during the enrollment process for an employee to enter the number for a primary care physician.
szDescription001_6	DL01	char	OPT	OUTPUT
A user defined name or remark.
szPlanId_6	PLAN	char	OPT	OUTPUT
An abbreviation or number that identifies a specific employee benefit. Examples are: o Employee Health Insurance o Accidental Death and Dismemberment o Health Club Expense Reimbursement o Employee Stock Appreciation Rights A benefit plan typically is associated with a deduction, benefit, or accrual. For example, a medical plan is a benefit that might also require a deduction to withhold premiums from an employee's pay.
szPlanAdditionalOption_6	AOPT	char	OPT	OUTPUT
A code that identifies any additional options available for a benefit plan that have been defined in the Plan Additional Options table (F083202). Note: Additional options must have the same provider, policy number, and enrollment and eligibility rules as the benefit plan to which they are associated.
szDescription50Characters_6	DS50	char	OPT	OUTPUT
A descriptive statement of up to 50 characters in length.
mnTrackPCPNumberFlag_6	PCPF	MATH_NUMERIC	OPT	OUTPUT
An option that specifies whether the benefit plan or benefit plan option tracks primary care physician numbers. If you choose this option, then the system displays a form during the enrollment process for an employee to enter the number for a primary care physician.
szDescription001_7	DL01	char	OPT	OUTPUT
A user defined name or remark.
szPlanId_7	PLAN	char	OPT	OUTPUT
An abbreviation or number that identifies a specific employee benefit. Examples are: o Employee Health Insurance o Accidental Death and Dismemberment o Health Club Expense Reimbursement o Employee Stock Appreciation Rights A benefit plan typically is associated with a deduction, benefit, or accrual. For example, a medical plan is a benefit that might also require a deduction to withhold premiums from an employee's pay.
szPlanAdditionalOption_7	AOPT	char	OPT	OUTPUT
A code that identifies any additional options available for a benefit plan that have been defined in the Plan Additional Options table (F083202). Note: Additional options must have the same provider, policy number, and enrollment and eligibility rules as the benefit plan to which they are associated.
szDescription50Characters_7	DS50	char	OPT	OUTPUT
A descriptive statement of up to 50 characters in length.
mnTrackPCPNumberFlag_7	PCPF	MATH_NUMERIC	OPT	OUTPUT
An option that specifies whether the benefit plan or benefit plan option tracks primary care physician numbers. If you choose this option, then the system displays a form during the enrollment process for an employee to enter the number for a primary care physician.
szDescription001_8	DL01	char	OPT	OUTPUT
A user defined name or remark.
szPlanId_8	PLAN	char	OPT	OUTPUT
An abbreviation or number that identifies a specific employee benefit. Examples are: o Employee Health Insurance o Accidental Death and Dismemberment o Health Club Expense Reimbursement o Employee Stock Appreciation Rights A benefit plan typically is associated with a deduction, benefit, or accrual. For example, a medical plan is a benefit that might also require a deduction to withhold premiums from an employee's pay.
szPlanAdditionalOption_8	AOPT	char	OPT	OUTPUT
A code that identifies any additional options available for a benefit plan that have been defined in the Plan Additional Options table (F083202). Note: Additional options must have the same provider, policy number, and enrollment and eligibility rules as the benefit plan to which they are associated.
szDescription50Characters_8	DS50	char	OPT	OUTPUT
A descriptive statement of up to 50 characters in length.
mnTrackPCPNumberFlag_8	PCPF	MATH_NUMERIC	OPT	OUTPUT
An option that specifies whether the benefit plan or benefit plan option tracks primary care physician numbers. If you choose this option, then the system displays a form during the enrollment process for an employee to enter the number for a primary care physician.
szDescription001_9	DL01	char	OPT	OUTPUT
A user defined name or remark.
szPlanId_9	PLAN	char	OPT	OUTPUT
An abbreviation or number that identifies a specific employee benefit. Examples are: o Employee Health Insurance o Accidental Death and Dismemberment o Health Club Expense Reimbursement o Employee Stock Appreciation Rights A benefit plan typically is associated with a deduction, benefit, or accrual. For example, a medical plan is a benefit that might also require a deduction to withhold premiums from an employee's pay.
szPlanAdditionalOption_9	AOPT	char	OPT	OUTPUT
A code that identifies any additional options available for a benefit plan that have been defined in the Plan Additional Options table (F083202). Note: Additional options must have the same provider, policy number, and enrollment and eligibility rules as the benefit plan to which they are associated.
szDescription50Characters_9	DS50	char	OPT	OUTPUT
A descriptive statement of up to 50 characters in length.
mnTrackPCPNumberFlag_9	PCPF	MATH_NUMERIC	OPT	OUTPUT
An option that specifies whether the benefit plan or benefit plan option tracks primary care physician numbers. If you choose this option, then the system displays a form during the enrollment process for an employee to enter the number for a primary care physician.
szDescription001_10	DL01	char	OPT	OUTPUT
A user defined name or remark.
szPlanId_10	PLAN	char	OPT	OUTPUT
An abbreviation or number that identifies a specific employee benefit. Examples are: o Employee Health Insurance o Accidental Death and Dismemberment o Health Club Expense Reimbursement o Employee Stock Appreciation Rights A benefit plan typically is associated with a deduction, benefit, or accrual. For example, a medical plan is a benefit that might also require a deduction to withhold premiums from an employee's pay.
szPlanAdditionalOption_10	AOPT	char	OPT	OUTPUT
A code that identifies any additional options available for a benefit plan that have been defined in the Plan Additional Options table (F083202). Note: Additional options must have the same provider, policy number, and enrollment and eligibility rules as the benefit plan to which they are associated.
szDescription50Characters_10	DS50	char	OPT	OUTPUT
A descriptive statement of up to 50 characters in length.
mnTrackPCPNumberFlag_10	PCPF	MATH_NUMERIC	OPT	OUTPUT
An option that specifies whether the benefit plan or benefit plan option tracks primary care physician numbers. If you choose this option, then the system displays a form during the enrollment process for an employee to enter the number for a primary care physician.
mnNumberOfPlans	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.

Related Functions

None

Related Tables

None