ValidateCOBRAConstantDates

Validate COBRA Constant Dates

Minor Business Rule

Object Name: N0800290

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description
Check for overlapping dates based upon the input parameters and the existing records in
F08990/F089901(COBRA General Constants/COBRA General Constants Additional Information) and F08990(Qualifying Event
Constants).

Purpose
The purpose of this business function is to check for overlapping dates in the COBRA constant files (F08990, F089901,
F08991).   If the P08990 is passed as an input parameter for program id, the records in tables F08990/F089901 will be
compared with the input parameters and checked for an existing record with overlapping dates.     If the P08991 is passed as an input
parameter for program id table F08991will be will be compared with the input parameters and checked for an existing
record with overlapping dates.

The comparison between the input parameters and the existing records is done in a hierarchical manner based upon the
primary keys.  The input parameters are Company, Qualifying Event, Tax Area Residence, Cost Center, Date Beginning
Effective, Date Ending Effective and Program ID.

If an overlapping date is found the output parameter ErrorStatus is returned as '1'.

Setup Notes and Prerequisites
• If P08990 is being used as the program id Company, Tax Area Residence, Cost Center, Date Beginning Effective, Date
Ending Effective and Program Id must all be passed in as input parameters.
• If P08991 is being used as the program id Company, Qualifying Event, Tax Area
Residence, Cost Center, Date Beginning Effective, Date Ending Effective and Program
Id must all be passed in as input parameters.
'b7'b7
Special Logic

Parameters:

Data ItemData Structure Description        I/O       Required     Notes
COszCompany          IY
QE1szQualifyingEvent1          INQE is only required if P08991 is being passed in as the program id.
TARRSzTaxAreaResidence          IY
HMCUszCostCenterHome          IY
EFTBjdDateBeginningEffective          IY
EFTEjdDateEndingEffective          IY
PIDszProgramId         IYEither use P08991 or P08990
EV01cErrorStatus_EV01         ONReturns a 1 if an overlapping date is found.  Returns a
0 if an overlapping date is not found.

Related Tables
Table Table Description F08990COBRA General Constants F089901COBRA General Constants Additional Information F08991COBRA Qualifying
Event Constants
Technical Specification

1.0If ProgramId = P08990 (Testing Dates for application P08990)

1.1Check overlapping dates where CO NOT= blank, HMCU NOT= blank, and TARR NOT= blank.

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szCompany	CO	char	OPT	INPUT
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000 for transaction entries.
szQualifyingEvent1	QE1	char	OPT	INPUT
A user defined code (08/QE) that indicates the initial event that qualified a participant for COBRA continuation coverage.
szTaxAreaResidence	TARR	char	OPT	INPUT
A code that identifies both the geographical location and the tax authorities for the employee's residence. Authorities include employee and employer statutory requirements. This code is synonymous with GeoCode. Refer to Vertex System's Master GeoCode File for valid codes for your locations.
szCostCenterHome	HMCU	char	OPT	INPUT
The number of the business unit in which the employee generally resides.
jdDateBeginningEffective	EFTB	JDEDATE	OPT	INPUT
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program. For example, the effective date could represent the following: o When a change of address becomes effective. o When a lease becomes effective. o When a price becomes effective. o When the currency exchange rate becomes effective. o When a tax rate becomes effective.
jdDateEndingEffective	EFTE	JDEDATE	OPT	INPUT
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
szProgramId	PID	char	OPT	INPUT
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
cErrorStatus_EV01	EV01	char	OPT	OUTPUT
An option that specifies the type of processing for an event.

ValidateCOBRAConstantDates