IsInsuranceChgOverIncreaseAmount

Determine If Insurance Change Exceeds Increase Amount

Minor Business Rule

Object Name: N0800384

Parent DLL: CHRM

Location: Client/Server

Language: NER

Business Function Specification

1.Functional Description

1.1Purpose

This function will set an error or determine if an error must be set when an employee tries to increase their life insurance during an ESS process by
more than the allowed amount entered for that category/plan/option combination in the F085574.

1.2Setup Notes and Prerequisites

1.3Special Logic

2.Technical Specifications

2.1Parameters: D0800384
Data Item Data Structure DescriptionI/ORequiredNotes
AN8mnAddressNumberIYesEmployees Address number F060116
JOBSmnJobnumberIYesB0500546 Cache Job number
EVETmnEnrollmentEventTypeIYesFrom script
DIVCszBenefitGroupCodeIYesEmployees Benefit group
SBGRszBenefitGroupCategoryIYesCategory for increase of insurance coverage - part of hierarchy
PLANszPlanIdINoPlan for increase of insurance - part of hierarchy
AOPTszPlanAdditionalOptionINoOption for increase of insurance - part of hierarchy
COVAmnNewCoverageAmountONoCoverage amount from plan master tag table for new plan passed in
COVAmnOldCoverageAmountONoCoverage amount from plan master tag table for old plan in 30W
COVAmnDifferenceCoverageAmountONoDifference between old and new coverage
ICRAMTmnIncreaseAmountONoAllowed increase amount from F085574
SUPPScSuppressErrorMessageINoIf 1 passed in error will not be called
EV01cErrorFlagONoIf increase amount is greater than allowed return 1

2.2Related Tables
Table Table Description F060116Employee Master F08320Benefits Plan Master F08320DBenefits Plan Master Tag Table F085530WEmployee
Current/Pending Elections Work Table F085574Maximum Insurance Coverage Increase Amounts
2.3Related Business Functions
Source NameFunction Name B0400410Convert Math Numeric To A String B0800168Get Employee Master Specific Data
Item B0800366Text Substitution Error
2.4Processing

1) Fetch Increase Amount from F085574 according to hierarchy
                1. Plan/Category Combination
                2. Plan Only
                3. Category Only

2) Fetch the Old plan from Current Coverage Work file F085530W according to
       category and system date

3) Fetch the Old Coverage Amount from the Plan Master for the Old Plan/Option
        F08320/F08320D - May be Amount or Multiplier - Also Rounding Amount

4) If multiplier calculate actual amount from value in F060116

5) Round the Old Coverage Amount by the Old Rounding Amount

6) Fetch the New Coverage Amount from the plan master according to the
        plan/option passed in F08320/F08320D - May be Amount or Multiplier
        Also Fetch the New Rounding Amount

7) If multiplier calculate actual amount from value in F060116

8)   Round the New Coverage Amount by the New Rounding Amount

9) Subtract the Old Coverage Amount from the New Coverage Amount

10) If the difference is greater than the Increase Amount return Error/Set
        Error 161V

Data Structure

D0800384 - Determine If Insurance Change Exceeds Increase Amount

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.

mnJobnumber JOBS MATH_NUMERIC OPT INPUT

The job number (work station ID) which executed the particular job.

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

szBenefitGroupCode DIVC char OPT INPUT

The benefit group to which the employee is assigned. Benefit groups facilitate employee enrollment by categorizing benefit plans and
allowing enrollment rules for those categories. For example, assigning an employee to an executive (EXEC) benefit group automatically links the
employee to the benefits available to executives in your organization.

szBenefitGroupCategory SBGR char REQ INPUT

The category of a benefit group. The category is used to group benefit plans according to the type and/or rule. For
example: MEDICAL Required Medical Selections   DENTAL Optional Dental Selections   LIFE Required Life Ins Selections Valid categories are set up in the Generic
Rate and Message table (F00191) for system 08/type SG. Associated text for categories is stored in the General Message Detail table
(F00192). For more information, see program P00191.

szPlanId PLAN char REQ INPUT

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 INPUT

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.

mnNewCoverageAmount COVA MATH_NUMERIC OPT OUTPUT

The dollar amount of coverage that this plan provides to every employee enrolled in the plan.

mnOldCoverageAmount COVA MATH_NUMERIC OPT OUTPUT

The dollar amount of coverage that this plan provides to every employee enrolled in the plan.

mnDifferenceCoverageAmount COVA MATH_NUMERIC OPT OUTPUT

The dollar amount of coverage that this plan provides to every employee enrolled in the plan.

mnIncreaseAmount ICRAMT MATH_NUMERIC OPT OUTPUT

The maximum increase of coverage that an employee can elect.

cSuppressErrorMessage SUPPS char OPT INPUT

A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.        0 = allow
runtime error message handling.        1 = suppress runtime error message handling.

cErrorFlag EV01 char OPT OUTPUT

An option that specifies the type of processing for an event.

Related Functions

None

Related Tables

None

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.
mnJobnumber	JOBS	MATH_NUMERIC	OPT	INPUT
The job number (work station ID) which executed the particular job.
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
szBenefitGroupCode	DIVC	char	OPT	INPUT
The benefit group to which the employee is assigned. Benefit groups facilitate employee enrollment by categorizing benefit plans and allowing enrollment rules for those categories. For example, assigning an employee to an executive (EXEC) benefit group automatically links the employee to the benefits available to executives in your organization.
szBenefitGroupCategory	SBGR	char	REQ	INPUT
The category of a benefit group. The category is used to group benefit plans according to the type and/or rule. For example: MEDICAL Required Medical Selections DENTAL Optional Dental Selections LIFE Required Life Ins Selections Valid categories are set up in the Generic Rate and Message table (F00191) for system 08/type SG. Associated text for categories is stored in the General Message Detail table (F00192). For more information, see program P00191.
szPlanId	PLAN	char	REQ	INPUT
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	INPUT
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.
mnNewCoverageAmount	COVA	MATH_NUMERIC	OPT	OUTPUT
The dollar amount of coverage that this plan provides to every employee enrolled in the plan.
mnOldCoverageAmount	COVA	MATH_NUMERIC	OPT	OUTPUT
The dollar amount of coverage that this plan provides to every employee enrolled in the plan.
mnDifferenceCoverageAmount	COVA	MATH_NUMERIC	OPT	OUTPUT
The dollar amount of coverage that this plan provides to every employee enrolled in the plan.
mnIncreaseAmount	ICRAMT	MATH_NUMERIC	OPT	OUTPUT
The maximum increase of coverage that an employee can elect.
cSuppressErrorMessage	SUPPS	char	OPT	INPUT
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function. 0 = allow runtime error message handling. 1 = suppress runtime error message handling.
cErrorFlag	EV01	char	OPT	OUTPUT
An option that specifies the type of processing for an event.