CheckForOverlappingRules

Check for Overlapping Rules

Minor Business Rule

Object Name: N0800380

Parent DLL: CHRM

Location: Client/Server

Language: NER

1.Functional Description

1.1Purpose

This function is used to check for records in the F08992 where the keys are the same except begin date. For each of these records, it checks whether
the dates overlap with another rule.

1.2Setup Notes and Prerequisites

Source Data Structure

Data Item Data Structure DescriptionI/OReqNotes
QE1szQualifyingEvent1IYEvent that qualified a participant for COBRA coverage
TOIFszTypeOfInformationIyThe type of information that a qualifying event is related
to.
HMCOszCompanyHomeIyThe company number where the employee records
generally reside.
HMCUszCostCenterHomeThe number of the business unit in which the employee
generally resides.
TARRszTaxAreaResidenceIyA code that identifies both the geographical location
and the tax authorities for the employee's residence
EFTBjdDateBeginningEffective IyThe date when an address, item, transaction, or table
record becomes active
EFTEjdDateEndingEffectiveIyThe date on which the item, transaction, or table
becomes inactive
EV01cOverlapExistsFlagOnThe flag that indicates if there is a date overlap or
not. (N=No date overlap, Y=Date overlap)

Related Tables
Table Table Description F08992Qualifying Event Rules Header
Related Business Functions
N0800044F08330 Date Overlap Check

Special Logic

2. Technical Specifications

1.0Fetch for record in F08992.
2.0Set OverlapExistsFlag to N
3.0While the fetch is success and the overlapExistsflag is N

3.1Call F08330 Date overlap check - N0800044

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szQualifyingEvent1	QE1	char	REQ	INPUT
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes QE1abab szQualifyingEvent1ab Iab YabEvent that qualified a participant for COBRA coverage
szTypeOfInformation	TOIF	char	REQ	INPUT
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes TOIFababszTypeOfInformationab Iab yabThe type of information that a qualifying event is related to.
szCompanyHome	HMCO	char	REQ	INPUT
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes HMCOabab szCompanyHomeabab Iab yabThe company number where the employee records generally reside.
szCostCenterHome	HMCU	char	REQ	INPUT
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes HMCUabab szCostCenterHomeababababThe number of the business unit in which the employee generally resides.
szTaxAreaResidence	TARR	char	REQ	INPUT
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes TARRabab szTaxAreaResidenceab Iab yabA code that identifies both the geographical location and the tax authorities for the employee's residence
jdDateBeginningEffective	EFTB	JDEDATE	REQ	INPUT
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes EFTBabab jdDateBeginningEffective Iab yabThe date when an address, item, transaction, or table record becomes active
jdDateEndingEffective	EFTE	JDEDATE	REQ	INPUT
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes EFTEabab jdDateEndingEffectiveab Iab yabThe date on which the item, transaction, or table becomes inactive
cOverlapExistsFlag	EV01	char	OPT	OUTPUT
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes EV01abab cOverlapExistsFlagab Oab nabThe flag that indicates if there is a date overlap or not. (N=No date overlap, Y=Date overlap)

CheckForOverlappingRules