IsAmountEnteredBetweenMinMax

Determine If Entered Amount Falls Between Min Max

Minor Business Rule

Object Name: N0800385

Parent DLL: CHRM

Location: Client/Server

Language: NER

Business Function Specification

1.Functional Description

1.1Purpose
To determine if an amount entered by an employee during self-service is or is not between the min and max amounts for that DBA in the F085573W.

1.2Setup Notes and Prerequisites

1.3Special Logic

2.Technical Specifications

2.1Parameters:   D0800385
Data Item Data Structure DescriptionI/ORequiredNotes AN8mnAddressNumberIYesEmployees Address Number JOBSmnJobnumberAIYesJob
Number for B0500546 Cache EVETmnEnrollmentEventTypeIYesFrom Process Script PDBAmnDBACodeINoPass in or get from plan
master PLANszPlanIdINoPlan to test max min for AOPTszPlanAdditionalOptionINoOption to test max min for RTAMmnAmountEnteredIYesAmount or rate for
plan MINCOVmnMinCoverageAmountONoFrom F085573W based on DBA MAXCOVmnMaxCoverageAmountONoFrom F085573W based on
DBA SUPPScSuppressErrorMessageINoPass in 1 will suppress errors EV01cErrorFlagONoError 1 returned if min max test fails
2.2Related Tables
Table Table Description F085573WEntered Benefit Amount/Rate Edits F060116Employee Master F08320Benefits Plan Master F083202Plan Additional
Options
2.3Related Business Functions
Source NameFunction Name B0000045Convert Math Numeric to String B0000198Set Currency Code and Decimals N0000580Data
Structure for String to N B0500546Cache Job Number By BSFN Name B0500561Cache ESS Common Data B0500655Text Sub Error Two
Math Numeric N0800031Get UDC Description
2.4Processing

1) If DBA is Not passed in, only have plan get DBA from F08320/F083202
              a) If FDBA is not blank in plan master use it
              b) if it is blank use PDDP

2) Retrive the Pay Frequency from B0500561 ESS Cache

3) If Pay Frequency is blank in cache get it from F060116

4) Fetch min and max from F085573W based on EVET, PDBA and PFRQ

5) Compare Entered Amount with Min and Max
                    a) If max is Zero treat it as no Max

7) If amount doesn't fall between min and max send error or call error

Data Structure

D0800385 - Determine If Entered Amount Falls Between Min Max

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.

mnJobnumberA JOBS MATH_NUMERIC REQ 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

mnDBACode PDBA MATH_NUMERIC OPT INPUT

A code that defines the type of pay, deduction, benefit, or accrual. Pay types are numbered from 1 to 999. Deductions and benefits are
numbered from 1000 to 9999.

szPlanId PLAN char OPT 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.

mnAmountEntered RTAM MATH_NUMERIC REQ INPUT

A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field
override the hourly rate.

mnMinCoverageAmount MINCOV MATH_NUMERIC OPT OUTPUT

The minimum amount per pay period that an employee can enter for this benefit plan.

mnMaxCoverageAmount MAXCOV MATH_NUMERIC OPT OUTPUT

The maximum amount per pay period that an employee can enter for this benefit plan.

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.
mnJobnumberA	JOBS	MATH_NUMERIC	REQ	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
mnDBACode	PDBA	MATH_NUMERIC	OPT	INPUT
A code that defines the type of pay, deduction, benefit, or accrual. Pay types are numbered from 1 to 999. Deductions and benefits are numbered from 1000 to 9999.
szPlanId	PLAN	char	OPT	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.
mnAmountEntered	RTAM	MATH_NUMERIC	REQ	INPUT
A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used. Valid values are: 1 For a deduction, benefit, or accrual, the meaning of this value depends on the method of calculation. The method determines whether the deduction is a flat monetary amount, a percentage, or a multiplication rate. Table method DBAs, depending on which table method they use, can either use this amount in the calculation or ignore it. If there are exceptions to the table calculation, you can override the table code in the detail area, set up a flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field override the hourly rate.
mnMinCoverageAmount	MINCOV	MATH_NUMERIC	OPT	OUTPUT
The minimum amount per pay period that an employee can enter for this benefit plan.
mnMaxCoverageAmount	MAXCOV	MATH_NUMERIC	OPT	OUTPUT
The maximum amount per pay period that an employee can enter for this benefit plan.
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.