RetrieveEnrollmentParameters

Retrieve Enrollment Parameters

Minor Business Rule

Object Name: N0800036

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose
The purpose of this Named ER is to retrieve an enrollment parameter record following a hierarchy.
Setup Notes and Prerequisites

Special Logic

Technical Specification
Initialize all the output parameters to blank.

Hierarchy order:

1.Find enrollment parameter record with the all the original input parameters
Fetch record from F08392 with keys: szPlan,  szEligibilityCode010, szEnrollmentStatus, cValidPlan.
If the fetch is successful, set cEnrollmentRecordFoundFlag = '1'

2.If record is not found, find enrollment parameter record to cover all enrollment statuses
Set EnrollmentStatusVariable = '*' and then Fetch record from F08392 with keys: szPlan,
szEligibilityCode010, EnrollmentStatusVariable, cValidPlan.  If the fetch is successful, set
cEnrollmentRecordFoundFlag = '1'.

3.If record is not found, find enrollment parameter record to cover all employee benefit statuses
Set EligibilityCode10Varaible = '*'.  Fetch record from F08392 with keys:  szPlan,
EligibilityCode10Variable, szEnrollmentStatus, cValidPlan.  If the fetch is successful, Set cEnrollmentRecordFoundFlag
= '1'

4.If record is not found, find enrollment parameter record to cover all statuses and employee
benefit statuses
FetchSingle F08392 with keys:  szPlan, EligibilityCode10Variable, EnrollmentStatusVariable,
cValidPlan.  If the fetch is successful, Set cEnrollmentRecordFoundFlag = '1'

5.If record is not found, find enrollment parameter record to cover all plans
Set PlanVariable = ' '.  Fetch record from  F08392 with keys:PlanVariable, szEligibilityCode010,
szEnrollmentStatus, cValidPlan.  If the fetch is successful, Set cEnrollmentRecordFoundFlag = '1'

6.If record is not found, find enrollment parameter record to cover all plans and all enrollment
statuses
Fetch record from F08392 with keys: PlanVariable,  szEligibilityCode10, EnrollmentStatusVariable,
cValidPlan.  If the fetch is successful, Set cEnrollmentRecordFoundFlag = '1'.

7.If record is not found, find enrollment parameter record to cover all plans and all employee
benefit statuses
Fetch record from F08392 with keys: PlanVariable,  Eligibility010Variable, szEnrollmentStatus,
cValidPlan.  If the fetch is successful, Set cEnrollmentRecordFoundFlag = '1'.

8.If record is not found, find enrollment parameter record to cover all plans, all enrollment
statuses, and all employee benefit statuses
Fetch record from F08392 with keys:  PlanVariable,  Eligibility010Variable, EnrollmentStatusVariable,
cValidPlan.  If the fetch is successful, Set cEnrollmentRecordFoundFlag = '1'

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szPlanId	PLAN	char	NONE	NONE
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.
cEligibilityCode010	E010	char	NONE	NONE
A code to specify an employee's eligibility for or participation in various user defined plans or programs. For example, these codes can be used to designate the following: Voluntary Accidental Death/Dismemberment Insurance (Y/N) Overtime Call Up (Y/N) Profit Sharing (Y/N) Political Action Committee (Y/N) Coffee Fund (Y/N) U.S. Citizen (Y/N)
szEnrollmentStatus	XDFS	char	NONE	NONE
A code that indicates the status of an employee's enrollment in a plan. It is a user defined code (08/ES), and you must use the following restrictions for the definitions: o All statuses indicating active participation in a plan must begin with the letter A. o All statuses indicating an ending status that does not result in a new enrollment (such as a termination) must have the letter X in the first position of Description 2 (data item DL02), General User Defined Codes form. o A status beginning with the letter X, when used as an ending status, represents a mistaken enrollment. No employee DBA instructions are written. o An asterisk (*) indicates all statuses not otherwise specified.
cValidPlan	PLNF	char	NONE	NONE
A code that indicates whether the specified plan is a valid plan for the employee. A valid plan is one that is available within the employee's benefit group.
cPreviousEnrollment	ENRP	char	NONE	NONE
A code that indicates whether the employee was previously eligible for the plan. Valid values are: Blank Do not check for previous eligibility. Y Yes, the employee was previously eligible. N No, the employee was not previously eligible. If the system finds a code in this field, it then searches the detail area for further information.
cEligibilityCheck	ECHK	char	NONE	NONE
A code that tells the system which eligibility test to run. Valid codes are: Blank Do not test for eligibility. I Test for initial eligibility. C Test for continuing eligibility. The system uses this field to test for eligibility when previous eligibility has been met.
szEnrollmentStatusEnding	XEST	char	NONE	NONE
A code that indicates the ending status of an employee's enrollment in a plan. This status represents the reason for ending the old enrollment and is used as the beginning status of any resulting new enrollment. You can define this code using user defined code table 08/ES. See data item XDFS (Status - Enrollment) for restrictions on the allowed values. Note: An ending status that begins with the letter X represents a mistaken enrollment.
szTerminationCode	TMCD	char	NONE	NONE
A code that indicates the date that the employee's new enrollment record should begin after it is determined that the employee is not eligible for a plan. These codes are defined in the Define Date Codes table (F08395).
cManualCheck	MCHK	char	NONE	NONE
A code that indicates whether the enrollment being processed should be printed on the Manual Review Requested report so the record can be handled manually rather than through the batch process.
cPreviousEnrollment2	ENR2	char	NONE	NONE
A code to indicate whether the employee was previously eligible for the plan. Codes are: blank Do no check for previous eligibility. Y Yes, the employee was previously eligible. N No, the employee was not previously eligible. If the system finds a code in this field, it then looks to the fold area for further information.
cEligibilityCheck2	ECK2	char	NONE	NONE
A code that tells the system which eligibility test to run. Valid values are: Blank Do not test for eligibility. I Test for initial eligibility. C Test for continuing eligibility. You complete this field only when you indicate that you want to consider previous eligibility. The system uses this field to test for eligibility when previous eligibility has not been met.
szTerminationCode2	TCD2	char	NONE	NONE
A code to indicate on what date the employee's new enrollment record should begin when no eligibility test is specified in the Enrollment Parameters. These codes are defined in the Define Date Codes file (F08395). The detail lines define what action should be taken when checking if the employee was previously eligible.
szEnrollmentStatusEnd2	XST2	char	NONE	NONE
A code to indicate the ending status of an employee's enrollment in a plan. This status represents the reason for ending the old enrollment, and it is used as the beginning status of any resulting new enrollment. For restrictions on the allowed values for this field, see data item XDFS,Enrollment Status. Most importantly, note that an Ending Status that begins with the letter X represents mistaken enrollment, and no Employee DBA instructions are maintained for such enrollment.
cManualCheck2	MCK2	char	NONE	NONE
A code that specifies whether the enrollment being processed should be printed on the Manual Review Requested report. Thus the record can be handled manually rather than through the batch process. You complete this field only when you indicate that you want to consider previous eligibility. The system uses this field to test for eligibility when previous eligibility has not been met.
cEnrollmentRecordFoundFlag	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.

RetrieveEnrollmentParameters