UpdateF08910DateNoticeWasMailed

Update F08910 Date Notice Mailed

Minor Business Rule

Object Name: N0800377

Parent DLL: CHRM

Location: Client/Server

Language: NER

1.Functional Description

1.1Purpose 

This function is used to update the F08910 or the F089101 Date Notice Mailed field after the COBRA letter has been printed.



1.2Setup Notes and Prerequisites


Source Data Structure


Data Item Data Structure DescriptionI/OReqNotes

PAN8mnParticipantAddressInThe address number of the COBRA Participant

QE1szQualifyingEvent1InEvent that qualified a participant for COBRA 

coverage

QD1jdQualifyingEventDate1InThe date that qualifying event took place

QDM1jdDateMailedQualEv1InThe date the election notice was mailed to the 

qualified beneficiary for the first qualifying event. 

EV01cOriginalOrSubsequentFlagI/O   n

QE2szQualifyingEvent2I/O   nThe subsequent qualifying event

QD2jdQualifyingEventDate2I/OnThe date of the second qualifying event.

ERRCcErrorCodeI/OnThe flag that indicates if it is Original 

Qualifying Event or Subsequent Qualifying Event (0=Original Event, 1=Subsequent event)



Related Tables 

Table Table Description F08910COBRA Qualified Beneficiary File F089101COBRA Subsequent Qualifying Event

Related Business Functions

NONE



Special Logic



2.   Technical Specifications


1.0Check if it is an Original Qualifying event or a subsequent qualifying event. 
2.0If it is Original Qualifying event, Update F08910 table.

2.1If the table update is not success, set error.
3.0If it is subsequent qualifying event, update F089101 table.
3.1If the table update is not success, set error.


Data Structure

D0800377 - Update F08910 Date Notice Mailed

Data Item Data Structure DescriptionI/OReqNotes
PAN8mnParticipantAddressInThe address number of the COBRA Participant

QE1szQualifyingEvent1InEvent that qualified a participant for COBRA 

coverage

QD1jdQualifyingEventDate1InThe date that qualifying event took place

QDM1jdDateMailedQualEv1InThe date the election notice was mailed to the 

qualified beneficiary for the first qualifying event. 

EV01cOriginalOrSubsequentFlagI/O   n

QE2szQualifyingEvent2I/O   nThe subsequent qualifying event

QD2jdQualifyingEventDate2I/OnThe date of the second qualifying event.

ERRCcErrorCodeI/OnThe flag that indicates if it is Original 

Qualifying Event or Subsequent Qualifying Event (0=Original Event, 1=Subsequent event)


Parameter NameData ItemData TypeReq/OptI/O/Both
szQualifyingEvent1QE1charOPTNONE

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


jdQualifyingEventDate1QD1JDEDATEOPTNONE

Data Item  ab Data Structure  Descriptionabab  I/Oab  Reqab Notes
QD1abab  jdQualifyingEventDate1abab  Iab  nabThe date that qualifying event took place

jdDateMailedQualEv1QDM1JDEDATEOPTNONE

Data Item  ab Data Structure  Descriptionabab  I/Oab  Reqab Notes
QDM1abab  jdDateMailedQualEv1abab  Iab  nabThe date the election notice was mailed to the qualified 

beneficiary for the first qualifying event. 


cOriginalOrSubsequentFlagEV01charOPTNONE

Data Item  ab Data Structure  Descriptionabab  I/Oab  Reqab Notes

szQualifyingEvent2QE2charOPTNONE

Data Item  ab Data Structure  Descriptionabab  I/Oab  Reqab Notes
QE2abab  szQualifyingEvent2abab I/O    nabThe subsequent qualifying event


jdQualifyingEventDate2QD2JDEDATEOPTNONE

Data Item  ab Data Structure  Descriptionabab  I/Oab  Reqab Notes
QD2abab  jdQualifyingEventDate2abab  I/Oab  nabThe date of the second qualifying event.


cErrorCodeERRCcharOPTNONE

Data Item  ab Data Structure  Descriptionabab  I/Oab  Reqab Notes
ERRCabab  cErrorCodeabababab  I/Oab  nabThe flag that indicates if it is Original Qualifying Event or 

Subsequent Qualifying Event (0=Original Event, 1=Subsequent event)


mnEmployeeOrBeneficiaryPAN8MATH_NUMERICOPTNONE

Data Item  ab Data Structure  Descriptionabab  I/Oab  Reqab Notes
PAN8abab  mnParticipantAddressabab  Iab  nabThe address number of the COBRA Participant


Related Functions

None

Related Tables

None