Contents Show
The Benefit Pickup Letter (Output) will be generated to notify participants that have failed to pick up their next set(s) of benefits for which they are eligible. Within the clinic, one letter is generated per household and is addressed to the lead (oldest) member for the selected participants of the clinic/household. The letter lists all members of the clinic/household who are eligible for more benefits. The letters are generated when the Letter output type is selected and the OK button is clicked on the Generate Benefit Pickup Report/Letters screen.
This section describes the data elements that print on the system output. Because of space constraints, the layout may be slightly different and/or all characters may not print within the space allotted.
Origin of Data Element
This value will be the name of the clinic site for the selected participant. The ServiceSiteID column of the Member table for the selected records is used to retrieve the associated value in the ServiceSiteName column of the ServiceSite table.
Format
This is a fifty character value.
Origin of Data Element
This value will be the address of the clinic site for the selected participant. The ServiceSiteID column of the Member table for the selected records is used to retrieve the associated value in the Address column of the ServiceSite table.
Format
This is a fifty character value.
Origin of Data Element
This value will be the city of the clinic site for the selected participant. The ServiceSiteID column of the Member table for the selected records is used to retrieve the associated value in the City column of the ServiceSite table.
Format
This is a thirty character value.
Origin of Data Element
This value will be the state of the clinic site for the selected participant. The ServiceSiteID column of the Member table for the selected records is used to retrieve the associated value in the StateCd column of the ServiceSite table.
Format
This is a two character value.
Origin of Data Element
This value will be the zip code of the clinic site for the selected participant. The ServiceSiteID column of the Member table for the selected records is used to retrieve the associated value in the ZIPCode column of the ServiceSite table.
Format
This is a nine character value that will print in #####-##### format.
Origin of Data Element
The value will be taken from the LastName, FirstName, and MiddleInitial columns of the Member table for the lead (oldest selected participant) member.
Format
LastName is a twenty-five character value. FirstName is a twenty character value. MiddleInitial is a one character value. The value will print in {first name} {middle initial}. {last name} format.
Origin of Data Element
The value will be taken from the MailAddress column of the Household table.
Format
The value is a fifty character value.
Origin of Data Element
The value will be taken from the MailCity column of the Household table.
Format
The value is a thirty character value.
Origin of Data Element
The value will be taken from the MailState column of the Household table.
Format
The value is a two character value.
Origin of Data Element
The value will be taken from the MailZIP column of the Household table.
Format
The value MailZIP column of the Household table and will print in #####-#### format.
Origin of Data Element
This value will be the current system date at the time the benefit pickup letter was generated.
Format
The value will print in {textual month} {day}, {year} format.
Origin of Data Element
The value will be taken from the FirstName column of the Member table for the oldest selected participant of the household.
Format
The value is a twenty character value.
Origin of Data Element
The value will be taken from the StateWICId column of the member table for each of the selected participants in the clinic/household.
Format
The value is an eight character value.
Origin of Data Element
The value will be taken from the LastName, FirstName and MiddleInitial columns of the Member table for each of the selected participants in the clinic/household.
Format
LastName is a twenty-five character value. FirstName is a twenty character value. MiddleInitial is a one character value. The value will print in {first name} {middle initial}. {last name} format.
Origin of Data Element
The value will be taken from the ServiceSiteName column of the ServiceSite table for the clinic the report is requested for.
Format
The value is a fifty character value.
Origin of Data Element
The value will be taken from the Telephone column of the ServiceSite table for the clinic the report is requested for.
Format
The value is a twenty character value and will print in the format ###-###-####.
Participants who are eligible for additional benefit issuance during their current certification period will be included in the report. This will be determined by comparing the Last Check-LDTU and Certification-Due-Date columns of the MEMBER table. Participants must meet the following selection criteria. Participants in hidden agencies will not be included.
TerminatedDate column of the Member table is either null or is greater than the current date
CertificationDueDate of the Member record is greater than the LastCheckLDTU column of the Member table
LastCheckLDTU column of the Member tableplus one day is within the user-specified starting and ending dates, inclusive
Infants who are exclusively breastfeeding will not be included on the report. Participants that meet the following criteria will be excluded.
WICStatus column of the Member table equals "I"
AmountBreastfeeding column of the Child table equals "1"
All clients enrolled at the user-specified Clinics will be included in the report. The AgencyID column of the Member table must equal the value of the agency the user is signed on as. The ServiceSiteID column of the Member table must equal one of the selected clinics.
Within Clinic ID, the benefit pickup letters will be sorted by the participant name (last, first then middle initial) of the lead (oldest) family member per household of selected participants.
Within the letter, when there are multiple participants listed on the letter, the first participant listed will be the oldest family member within the household for that clinic. After that, the remaining participants will be sorted by last name, first name and middle initial.
A page will be generated for each lead (oldest) family member per household of selected participants. If a household has an high number of participants to list on the report, a second page (letter) may be produced.
|
Software Version: 2.40.00
