BuildCOBRALetter

Build COBRA Letter

Minor Business Rule

Object Name: N0800374

Parent DLL: CHRM

Location: Client

Language: NER

Functional Description

Purpose

The purpose of this business function is to process mail merge functionality so that mail merge
documents can be processed.

Setup Notes and Prerequisites

Mail Merge document to use must be set up. In this case, the mail merge template letter should be
set up in P980014.

Special Logic

Technical Specification

Data Item Data Structure DescriptionI/OReqNotes
AN8mnAddressNumberIRThe address book number of the employee.
DRQJjdDateRequestedJulianInThe date that an item is scheduled to arrive or that
an action is scheduled for completion.
RQTImnTimeRequestedHHMMSSInThis is the time when an item is to arrive or an
action is to be completed.
OBNMszNameObjectI/onThe COBRA document name
EV01cProcessFlagI/OnThe flag that is used to Open, Write and close the
output file (1=Open the file, 2=Gather data and write file, 3=Close the file)
HLNKszNameofDocumentFile
QD1jdQualifyingEventDate1IYThe date that qualifying event took place
DL01szCompanyHomeDescThe description of the company
DCXjdDateCobraExpirationInThe date the COBRA Coverage ends
HMCUszCostCenterHomeThe number of the business unit in which the employee
generally resides.
COszCompanyInA code that identifies a specific organization, fund,
entity, and so on
TARRszTaxAreaResidenceInA code that identifies both the geographical location
and the tax authorities for the employee's residence
QE1szQualifyingEvent1InEvent that qualified a participant for COBRA coverage
DTETjdDateElectionTermInThe date when the qualified beneficiary terminates
the coverage

Related Tables
Table Table Description F0111Address Book F0116Address By Date F0010Company Constants
Related Business Functions
Table Table Description B0500029Open Data File B0100031F0111 Get Mailing Name N0800281Retrieve COBRA Constants N0000563F0010
Retrieve Company Constant Record B0500029Write COBRA Letter B0500029Close Data File

1.0Read the process flag passed in.

1.1If it is blank or 1, open the data file for output through B0500029.
1.2If it is blank or 2,

1.2.1Get the mailing name of the person to whom the letter is sent through F0111 Get
Mailing Name
1.2.2Get the mailing address by fetching from F0116 to get the latest address
1.2.3Write the data file through B0500029 Write COBRA Letter - All Qualifying Events

1.3If it is blank or 3,

1.3.1Close the data file through B0500029
1.3.2Call P980013 to bring up the mail merge document with merged fields

Data Structure

D0800374 - Construct COBRA Letter

Parameters

Data Item Data Structure DescriptionI/OReqNotes
AN8mnAddressNumberIRThe address book number of the employee.
DRQJjdDateRequestedJulianInThe date that an item is scheduled to arrive or that
an action is scheduled for completion.
RQTImnTimeRequestedHHMMSSInThis is the time when an item is to arrive or an
action is to be completed.
OBNMszNameObjectI/onThe COBRA document name
EV01cProcessFlagI/OnThe flag that is used to Open, Write and close the
output file (1=Open the file, 2=Gather data and write file, 3=Close the file)
HLNKszNameofDocumentFile
QD1jdQualifyingEventDate1IYThe date that qualifying event took place
DL01szCompanyHomeDescThe description of the company
DCXjdDateCobraExpirationInThe date the COBRA Coverage ends
HMCUszCostCenterHomeThe number of the business unit in which the employee
generally resides.
COszCompanyInA code that identifies a specific organization, fund,
entity, and so on
TARRszTaxAreaResidenceInA code that identifies both the geographical location
and the tax authorities for the employee's residence
QE1szQualifyingEvent1InEvent that qualified a participant for COBRA coverage
DTETjdDateElectionTermInThe date when the qualified beneficiary terminates
the coverage

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnAddressNumber AN8 MATH_NUMERIC OPT NONE

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
AN8abab mnAddressNumberabab Iab RabThe address book number of the employee.

jdDateRequestedJulian DRQJ JDEDATE OPT NONE

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
DRQJabab jdDateRequestedJulianab Iab nabThe date that an item is scheduled to arrive or that an
action is scheduled for completion.

mnTimeRequestedHHMMSS RQTI MATH_NUMERIC OPT NONE

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
RQTIabab mnTimeRequestedHHMMSSab Iab nabThis is the time when an item is to arrive or an action is to
be completed.

szNameObject OBNM char OPT NONE

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
OBNMabab szNameObjectabab I/oab nabThe COBRA document name

cProcessFlag EV01 char OPT NONE

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
EV01abab cProcessFlagabab I/Oab nabThe flag that is used to Open, Write and close the output file
(1=Open the file, 2=Gather data and write file, 3=Close the file)

szNameOfDocumentFile HLNK char OPT NONE

Data Item ab Data Structure Descriptionabab I/Oab Reqab Notes

jdQualifyingEventDate1 QD1 JDEDATE OPT NONE

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
QD1abab jdQualifyingEventDate1ab Iab YabThe date that qualifying event took place

szCompanyHomeDesc DL01 char OPT NONE

Data Item ab Data Structure Descriptionabab I/Oab Reqab Notes
DL01abab szCompanyHomeDescababababThe description of the company

jdDateCobraExpiration DCX JDEDATE OPT NONE

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
DCXabab jdDateCobraExpirationab Iab nabThe date the COBRA Coverage ends

szCostCenterHome HMCU char OPT NONE

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
HMCUabab szCostCenterHomeababababThe number of the business unit in which the employee generally
resides.

szCompany CO char OPT NONE

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
COabab szCompanyababab Iab nabA code that identifies a specific organization, fund, entity, and so on

szTaxAreaResidence TARR char OPT NONE

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
TARRabab szTaxAreaResidenceab Iab nabA code that identifies both the geographical location and the
tax authorities for the employee's residence

szQualifyingEvent1 QE1 char OPT NONE

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
QE1abab szQualifyingEvent1ab Iab nabEvent that qualified a participant for COBRA coverage

jdDateElectionTerm DTET JDEDATE OPT NONE

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
DTETabab jdDateElectionTermab Iab nabThe date when the qualified beneficiary terminates the coverage

mnWebMailMergeUniqueID MMUID MATH_NUMERIC OPT NONE

A unique value that links a record in the Web Mail Merge Letters table (F05WEBMM) to one or many records in the Mail Merge Runtime
Web Data table (F980014D). The system generates this value by adding 1 to the MMUID record in the Web Mail Merge Letters table that
represents the largest value. The resulting value is the primary, unique key for the Web Mail Merge Letters table.

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnAddressNumber	AN8	MATH_NUMERIC	OPT	NONE
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes AN8abab mnAddressNumberabab Iab RabThe address book number of the employee.
jdDateRequestedJulian	DRQJ	JDEDATE	OPT	NONE
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes DRQJabab jdDateRequestedJulianab Iab nabThe date that an item is scheduled to arrive or that an action is scheduled for completion.
mnTimeRequestedHHMMSS	RQTI	MATH_NUMERIC	OPT	NONE
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes RQTIabab mnTimeRequestedHHMMSSab Iab nabThis is the time when an item is to arrive or an action is to be completed.
szNameObject	OBNM	char	OPT	NONE
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes OBNMabab szNameObjectabab I/oab nabThe COBRA document name
cProcessFlag	EV01	char	OPT	NONE
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes EV01abab cProcessFlagabab I/Oab nabThe flag that is used to Open, Write and close the output file (1=Open the file, 2=Gather data and write file, 3=Close the file)
szNameOfDocumentFile	HLNK	char	OPT	NONE
Data Item ab Data Structure Descriptionabab I/Oab Reqab Notes
jdQualifyingEventDate1	QD1	JDEDATE	OPT	NONE
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes QD1abab jdQualifyingEventDate1ab Iab YabThe date that qualifying event took place
szCompanyHomeDesc	DL01	char	OPT	NONE
Data Item ab Data Structure Descriptionabab I/Oab Reqab Notes DL01abab szCompanyHomeDescababababThe description of the company
jdDateCobraExpiration	DCX	JDEDATE	OPT	NONE
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes DCXabab jdDateCobraExpirationab Iab nabThe date the COBRA Coverage ends
szCostCenterHome	HMCU	char	OPT	NONE
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes HMCUabab szCostCenterHomeababababThe number of the business unit in which the employee generally resides.
szCompany	CO	char	OPT	NONE
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes COabab szCompanyababab Iab nabA code that identifies a specific organization, fund, entity, and so on
szTaxAreaResidence	TARR	char	OPT	NONE
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes TARRabab szTaxAreaResidenceab Iab nabA code that identifies both the geographical location and the tax authorities for the employee's residence
szQualifyingEvent1	QE1	char	OPT	NONE
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes QE1abab szQualifyingEvent1ab Iab nabEvent that qualified a participant for COBRA coverage
jdDateElectionTerm	DTET	JDEDATE	OPT	NONE
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes DTETabab jdDateElectionTermab Iab nabThe date when the qualified beneficiary terminates the coverage
mnWebMailMergeUniqueID	MMUID	MATH_NUMERIC	OPT	NONE
A unique value that links a record in the Web Mail Merge Letters table (F05WEBMM) to one or many records in the Mail Merge Runtime Web Data table (F980014D). The system generates this value by adding 1 to the MMUID record in the Web Mail Merge Letters table that represents the largest value. The resulting value is the primary, unique key for the Web Mail Merge Letters table.