Issue#
Application Module
Primary Function
Detail
Reported Issues
SUG-548
Vendor
Send Form Letters
Issue: When printing a letter for multiple vendors on the Send Form Letters screen, not all the letters are being printed. The system prints some of the letters then appears to lock up; however, the user can cancel the process and still work in the application. The letters that print are for vendors who have at least a partial address in the system.
Resolution: The system locking up was caused by Microsoft Word being unable to merge larger sets of Word documents. The code has been modified for vendor standard letters to use the same merge code as that used for custom letters. This generates mail merge documents using the OpenXML SDK libraries provided for free by Microsoft that are separate from Word in order to prevent lockups. This change helps larger merges; however, it is still possible for a lockup to occur since Word is still saving templates in .docx format, saving templates in .pdf format, and submitting documents to the document printer.
The system has been modified for vendor custom letters to exclude blank lines created by blank merge fields. This allows standard letters to be generated without regression issues. Additionally, the merge code for vendor custom letters has been modified to correctly merge a single field contained in a single paragraph for vendor standard letter merge fields.
The Letter Sent screen has been modified to no longer save an extra Letter Sent event when the system generates a batch of custom letters.
If a vendor does not have at least one partial address, a document is not generated during batch merge operations.
SUG-1152
Clinic
View Participant Transfer History
Issue: When the Print button is clicked on the View Participant Transfer History screen, the output is printed and the last two columns are cut off.
Resolution: The code has been modified so the report prints in landscape format. Additionally, the heading and report title fields are longer to work with the landscape format.
SUG-1261
Clinic
Demographics
Issue: When a participant's WIC category is changed from breastfeeding to non-breastfeeding on the Demographics screen, the CPA-assigned risk factors are not being carried forward to the pseudo-certification.
Resolution: The code modifications made for SVN-43 corrected this issue.
SUG-1307
Clinic
Certification Guided Script
Issue: When completing a Certification Guided Script, Risk Factor 103 is flagging the participant as high risk outside of the assigned threshold.
Additionally, Risk Factor 201 is flagging the participant as high risk outside of the assigned threshold.
Resolution: The code has been modified for the RiskFactorThreshold table for children 24-months or older. The rows do not have the WHO percentile populated, so in the Reference Utility module these risk factor thresholds for any child over 24-months display the CDC values rather than the WHO values.
The DFDD has been updated for Risk Factor 201 to document the Hct threshold is Hct < 32.9.
SUG-1351
State Office
List of Dual Reported Participation Cases Report ENR002 (Output)
Issue: When generating the List of Dual Reported Participation Cases Report ENR002 (Output), the system is reporting participants without dual issuance for the last three reported months. The report includes two participants who appear to be the same person, but one of them has no food instrument history in the FoodInstrumentSet table. Instead, the participant has only an LDTU in the Member table that is older than the last three reported months.
Resolution: The code has been modified to change the date format to include the day of the month.
The code and the DFDD are not consistent with one another. The system includes not only participants who have redeemed food instruments but also participants who were fully breastfeeding infants or were mothers of children receiving more than the maximum formula amount. The DFDD has been updated to correctly document that the report should not consider redemption. Additionally, fully breastfeeding infants and mothers of infants over 6 months old who are receiving more than the maximum amount of formula are counted on the report. The code and the DFDD have been modified to change the name of the report from List of Dual Participation Cases Report ENR002 (Output) to List of Dual Reported Participation Cases Report ENR002 (Output).
SUG-1457
Financial Management
Supplier Rebate Report FIN001 (Output)
Issue: When generating the Supplier Rebate Report FIN001 (Output) for months where End of Month Processing has completed, the report is showing blank values. The data that exists in the CaseLoadCountRebateItems table are not displaying on the report.
Resolution: An analysis of the issue resulted in the blank report being the primary issue. For some databases, there were no recent rebates within the past year so the report should be blank. A bug was discovered in the EBT portion of the report where the query was not correctly joining values of Vendor ID. The code has been modified to compare IDs padded with zeros so the report now correctly populates.
SUG-1462
Clinic
AdditionalInfo1
Issue: The Hardship list box on the AdditionalInfo1 screen is displaying list items that are marked in the database as inactive. Additionally, there is no user interface available to change the values of the list items. The DFDD documents the list items, but not all of them are available in all states.
Resolution: The code has been modified to hide inactive list items from controls within the Participant Folder.
SUG-1463
Financial Management
Supplier Rebate Report FIN001 (Output)
Issue: When generating the Supplier Rebate Report FIN001 (Output), the user name is cut off the output for Display on Screen and Send to Printer. The Save as PDF option functions correctly.
Resolution: The code has been modified to widen the user name field on the report to prevent it from being cut off.
SUG-1473
State Office
List of Dual Reported Participation Cases Report ENR002 (Output)
Issue: When generating the List of Dual Reported Participation Cases Report ENR002 (Output) for January 2013, the monthly process failed with a date format error as the date is formatted CCYYMM. The system is reporting participants without dual issuance for the last three reported months; this is not consistent with the way the report is to be generated according to the DFDD.
Resolution: The code has been modified to change the date format to include the day of the month.
The code and the DFDD are not consistent with one another. The system includes not only participants who have redeemed food instruments but also participants who were fully breastfeeding infants or were mothers of children receiving more than the maximum formula amount. The DFDD has been updated to correctly document that the report should not consider redemption. Additionally, fully breastfeeding infants and mothers of infants over 6 months old who are receiving more than the maximum amount of formula are counted on the report. The code and the DFDD have been modified to change the name of the report from List of Dual Participation Cases Report ENR002 (Output) to List of Dual Reported Participation Cases Report ENR002 (Output).
SUG-1499
Financial Management
Rebate Item
Issue: On the Rebate Item screen, an item was added to the Items Related to Selected Rebate Product list box from the Food Distribution Item Inventory list box. After clicking the OK button and returning to the Rebate Items screen, the newly added food item was not visible in the tree list. The rebate product is not being saved.
Resolution: The code has been modified to correctly save the rebate item when the OK button is clicked on the Rebate Item screen.
SUG-1536
Clinic
Participant Folder
Issue: While the Participant Folder is opened for each member of a multiple person household, the first participant can be certified. When the Work with Another Household Member screen displays, it is cancelled. When the certification attempt is started on the next participant in the household, the system displays a standard error message with the text, "No search criteria".
Resolution: The code has been modified to set InvokedByCGS to true when displaying the Certification Guided Script screen from within the Participant Folder.
SUG-1537
Clinic
Demographics
Issue: During a Certification Guided Script, the Income value label displays the monthly or yearly income with a comma to denote the thousands value on the Demographics screen. However, on the Income History screen, the comma is not displayed in the node of the tree list.
Resolution: The code has been modified to add the comma to the node of the tree list.
SUG-1545
Clinic
VOC Document (Output) and Participant Summary (Output)
Issue: On the VOC Document (Output) and Participant Summary (Output), the height information is displayed with the word "inches" twice (42 inches 5/8 inches). The word "inches" only needs to be displayed once. If there are multiple height entries for the certification period, the system correctly prints inches and eighths. However, if the height has a value of "0" for the eighths, only inches displays (for example, 65 inches and 0 eighths prints as "65 inches").
Resolution: The duplication of the word "inches" was corrected in a previous release. The system has been modified to display only inches when there are 0 eighths of an inch. For example, if the measurement is 42 inches and 0 eighths, the system displays "42 inches".
SUG-1613
Clinic and State Office
Breastfeeding Item Inventory Report CLN012 (Output)
Issue: On the Breastfeeding Item Inventory Report CLN012 (Output), the DFDD does not accurately describe the ordered status section of the report.
Resolution: The DFDD has been updated to clarify the Breastfeeding Item Inventory Report CLN012 (Output). The Order Status section of the report is activity performed by the state where items are ordered from the manufacturer and then consigned to a clinic location. The Units Ordered, Date Received, Units Received, Pending Receipt, and Units on Hand columns represent orders submitted by the state to the manufacturer. The Units Consigned column is the total number of product units assigned to clinics (all locations).
SUG-1646
Clinic
Issue Benefits
Issue: The system is not suggesting the correct benefits when a participant has a late pickup and the new FDTU is not the same month as the PFDTU. As a result, the participant does not receive the fourth benefit.
Resolution: The issue is caused by the system taking into account the value of the CLN_AllowFutureBenefitsWithinDays business rule. If the total number of days of issuance is less than the CLN_AllowFutureBenefitsWithinDays business rule value, the system keeps adding benefits.
The code has been modified to remove the CLN_AllowFutureBenefitsWithinDays business rule from the issuance logic. The system now only looks at the member's issuance frequency and determines the number of unique benefit months to be issued, taking into account any future benefits previously issued.
Additionally, code has been added to work in the situation where one tri-monthly household member was issued two months of benefits and then later the other household member is issued all 3-months of benefits. The system now issues the third benefit for the first member and all three benefits for the second member as long as the CLN_AllowFutureBenefitsWithinDays business rule is set to be large enough to allow the third set to be issued.
SUG-1656
State Office
Formula Purchased Report - Contract FDI009 (Output)
Issue: On the Formula Purchased Report - Contract FDI009 (Output), "WIC" is incorrectly capitalized as "Wic" in Column J. Additionally, the Paid Amount is no longer formatted as currency; only whole dollar amounts are displaying.
Resolution: The code has been modified to correct the capitalization of "WIC". The Paid Amount column is formatted as currency. Additionally, the cells for the State WIC ID and Household ID columns have been formatted as numbers to prevent Excel from displaying the green triangle suggesting a formatting change.
SUG-1682
Financial Management
Supplier Rebate Report FIN001 (Output)
Issue: When generating the Supplier Rebate Report FIN001 (Output), it is not populating all items issued on the rebate contract during the month. When a second agreement is added, the report does not populate the information for the first agreement.
Resolution: The code has been modified to correct a SQL error that was selecting each rebate supplier's most recent rebate schedule for inclusion in the report. The code now selects each rebate agreement's most recent schedule rather than each supplier's most recent schedule.
SUG-1683
Financial Management
Supplier Rebate Report FIN001 (Output)
Issue: When generating the Supplier Rebate Report FIN001 (Output), if a new formula item is created that is identical to an existing formula item, the report does not populate the Average Price for the item. Additionally, the Calculated Unit Purchased and Rebate Dollars are not calculated. If new rebate items are created and redeemed in the same month, the system does not calculate the average price for them. Instead, the average price is calculated only when the items are redeemed at the beginning of the following month in which the items were added. The PeerGroupItemHistory table shows null for the average and maximum prices, and this report pulls data from that table.
Resolution: The code responsible for keeping the PeerGroupItemHistory table up to date either created new history rows at the beginning of the month based on the PeerGroupItem entries or updated the existing history rows throughout the month. However, it never created new history rows based on PeerGroupItem entries that were created during the current month. The code has been modified to create new history rows whenever there are PeerGroupItem entries with no history regardless of the date. After a user recalculates the peer group average, the recently added food items are immediately available to be included in the rebate report.
SUG-1691
Clinic
Child Health Information and Infant Information
Issue: When an infant is changed from full breastfeeding to non-breastfeeding on the Child Health Information screen and a reason stopped is selected, that information is not displayed on the Infant Information screen. Instead, the Reason Stopped list box does not have a list item selected
Resolution: The code modifications made for SVN-43 corrected this issue. The code has been modified to change the save method for the infant's breastfeeding stopped reason to properly clear and save the new values.
SUG-1826
Clinic
Nutrition Education Contact
Issue: When the DELETEEDCONTACT business rule is set to "Y", users are able to delete contacts on the Nutrition Education Contact screen during a Certification Guided Script before the certification attempt is completed. When the certification attempt is completed, the contact cannot be deleted from within the Participant Folder on the same day it was added.
Resolution: The code has been modified to properly enable and disable the Edit Contact, Material or Referral button and the Delete Contact, Material or Referral button based on the requirements documented in the DFDD.
SUG-1828
Clinic
Certification Notice (Output)
Issue: When the Certification Notice (Output) is printed at the end of Certification Guided Script, the last four digits of the ZIP code is being printed from the physical address record. All address information should print from the mailing address record.
Resolution: The code has been modified to change the report parameters to correctly display the address.
SUG-1860
State Office
Referrals and Other Programs
Issue: On the Referrals and Other Programs screen, the Available list box and Selected list box are not correctly displaying the available or selected other program enrollment list items.
Resolution: The code has been modified to display a blank Available list box on the Referrals and Other Programs screen in the Central Administrative Site and State Office modules. The Selected list box has been modified to correctly display the list items selected in the Clinic module.
SUG-1873
Central Administrative Site
Build Clinic Calendar
Issue: When a resource's defined schedule is deleted on the Adjust Resource Schedules screen to leave a blank day, the calendar on the Build Clinic Calendar screen is not updating correctly to show the day as being undefined.
Resolution: The code has been modified to refresh the Build Clinic Calendar screen to correctly update the display for modified resource schedules.
SUG-1902
Clinic
Participant List
Issue: When the Appointments for Today radio button is selected on the Participant List screen and a search is performed, the appointments are correctly displayed in ascending order by the Appointment Time column. If the Appointment Time column is clicked to sort the records, the records are not displayed in the correct order and they cannot be returned to the correct order.
Resolution: The code has been modified to correct the sorting of the columns when the column headers are clicked.
SUG-1916
Clinic
Infant Information
Issue: When the Infant in Foster Care check box is selected on the Infant Information screen, all other controls on the screen are disabled and the infant is automatically set to non-breastfeeding.
Resolution: The code has been modified so when the Infant in Foster Care check box is selected it does not disable the controls in the Breastfeeding Information group box.
SUG-1919
State Office
Nutrition Education Contacts Report NUT004 (Output)
Issue: When generating the Nutrition Education Contacts Report NUT004 (Output), the report is blank with no data being displayed on the output.
Resolution: The SQL was miscalculating the 6-month date range to use for the report so the range was always empty. The code has been modified to correctly calculate the date range. Additionally, the report now correctly displays the agency and clinic. A correction was made to the report so that it no longer displays multiple rows for each contact type with its total.
SUG-1920
Clinic
Participant List
Issue: When opening the Participant Folder from the Participant List screen for a participant who has two records in the database for two different clinics, the system displays a standard error message with the text, "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=, >, >= or when the subquery is used as an expression."
Resolution: The system wants to verify the old household ID and it is assuming there is only one. However, there could be multiple old household IDs. The code has been modified to change the SQL statement to be "IN" rather than "=".
SUG-1922
Clinic
Breastfeeding Peer Counselor Referral, Group Education Contact, and Individual Nutrition Education Contact
Issue: When adding a contact on the Group Education Contact screen or the Individual Nutrition Education Contact screen, if the Topic(s) Discussed list box is left blank, the system does not highlight it with an orange halo signifying it is a required field. The same issue occurs on the Breastfeeding Peer Counselor Referral screen for the Reason for Referral list box.
Resolution: The code has been modified to correctly display an orange halo around the controls.
SUG-1925
Clinic
CPA-determined Follow-up
Issue: On the CPA-determined Follow-up screen, the only required control is the Issuance Frequency drop-down list box. All other controls are set in other places within the application.
Resolution: The code has been modified to remove the non-required controls from the CPA-determined Follow-up screen. Only the Issuance Frequency drop-down list box is displayed. Additionally, the CPA_FOLLOWUP_REQUIRE_ISSUANCEFREQ_ONLY business rule has been removed as it is no longer required.
SUG-1927
Clinic
Calendar Controls
Issue: On several screens in the Participant Folder and in Certification Guided Script, the orange halos for required controls display on top of an expanded calendar control. The following screens are affected:
Add Immunization(s)
Blood Measurement
Goal Setting Contact
Height/Weight Measurement
Infant Information
Resolution: The code has been modified to use the HaloSafe drop-down for calendar controls which is designed to work properly with halos.
SUG-1949
Clinic
Postpartum Information
Issue: When the date entered in the Hospital Discharge Date calendar control is less than the value entered in the Actual Delivery Date calendar control on the Postpartum Information screen, the system is displaying two standard error messages that state the hospital discharge date must be greater than or equal to actual delivery date.
Resolution: The code has been modified to display only one standard error message. The DFDD has been updated to correctly document the consistent standard error message (E0129) with the text, "Hospital Discharge Date must be greater than or equal to the value of Actual Delivery Date."
SUG-1953
Reference Utility
Category/Subcategory Maintenance
Issue: When adding a new row on the Category/Subcategory Maintenance screen, the system displays a standard error message with the text, "Index was outside the bounds of the array."
Resolution: When a new row is added, the system is trying to default the unit of measure from the wildcard subcategory "000". Unfortunately, not all categories have this subcategory. The code has been modified to verify if the category has the necessary subcategory. If it is not found, the system tries to use the row above it.
If the user accidently clicks on the new blank row at the bottom of the screen, the system locks the user into the control. The user has to type in some information to exit the row and then delete it.
Additionally, the code has been modified to skip cell validation on entirely blank rows. A waitcursor has been added to the Save button. Two events were missing try catches, and those have been added.
SUG-1955
Clinic
EBT Issuance
Issue: After the EBT Processor had an outage and a new household was added to the system, benefits could not be issued. After the outage was resolved, benefits could not be issued as the system displayed a standard information message (I0008) with the text, "Pending EBT Issuance found! You must resolve them before proceeding." When the Resolve EBT Issuances menu option was selected, the system continued to display the standard information message.
Resolution: The ability to resolve EBT errors was not functioning correctly. The columns in the EBTPending_FOODINSTRUMENT table no longer matched the columns in the FOODINSTRUMENT table. The SQLChanges script has been updated to add an alter table statement to resolve the issue.
SUG-1975
SPIRIT
All Applications
Issue: The SPIRIT application's publisher is not identified, and is instead listed as an "Unknown" publisher.
To correctly launch the SPIRIT applications, the user must right-click on the shortcut and select Run as administrator.
Resolution: The code has been modified to find the local data directory if the desktop used the two new locations added to the client setup. Additionally, the PC20XX File (Output) generation has been updated because the code was searching for the bin path. Code has been added in case the user installed to the new installation path.
SUG-1981
Clinic
Identify Benefits to Void
Issue: The DFDD incorrectly documents the names of some controls on the Identify Benefits to Void screen. These controls use the term "Check" rather than "Benefit".
Resolution: The DFDD has been updated for the Identify Benefits to Void screen topic to correctly document the names of the controls. There are other instances in the DFDD where this issue may still exist.
SUG-1983
Clinic
Button Labels
Issue: The DFDD still contains references to the Issue to Household, Issue to Member Only, Print for Household, and Print for Member Only buttons.
Resolution: The DFDD has been updated to remove references to these buttons and replace them with the Issue Benefits to Selected Members button. The training topics have been modified to remove references to these buttons.
SUG-1991
Clinic, State Office, and Vendor
Food Instrument Details
Issue: The DFDD documents the non-existent FoodItemOnCheck table on the Food Instrument Details screen.
Resolution: The DFDD has been updated to remove the reference to the FoodItemOnCheck table.
SUG-1992
Appendix
Risk Factors Matrix
Issue: The DFDD does not consistently document the BMI chart for Risk Factor 133.
Resolution: The DFDD has been updated to make all the BMI charts for Risk Factor 133 be consistent.
SUG-1993
Clinic
Certification Guided Script toolbar
Issue: The DFDD image of the Certification Guided Script toolbar still displays an Exit toolbar button.
Resolution: The DFDD has been updated to include a new image of the Certification Guided Script toolbar.
SUG-1999
Clinic
Demographics
Issue: The Date Verified calendar control on the Demographics screen is documented in the DFDD as not accepting alphabetic or special characters.
Resolution: The DFDD has been updated to remove the incorrect information that the calendar control does not accept alphabetic or special characters. In a search of the DFDD, the only other reference was found on the Blood Measurement screen and it has been corrected.
SUG-2000
Clinic
Benefits (Issue Benefits)
Issue: The DFDD does not clearly document when the Selected LDTU of radio button and calendar control is enabled on the Benefits (Issue Benefits) screen.
Resolution: The DFDD has been updated to document that the control is enabled when, "There are outstanding future benefits for the household that have a LDTU greater than or equal to the current system date."
SUG-2002
DFDD
Permissions Matrix
Issue: The DFDD contains duplicate information on the Permissions Matrix for Feature ID 23, 101, 104, 144, and 304.
Resolution: The DFDD has been updated to remove the duplicate entries for Feature ID 23, 144, and 304. Feature ID 101 and 104 were removed in a previous release.
SUG-2003
Vendor Online Application
Business Information
Issue: The DFDD contains an image of the Business Information screen that shows a different label on the WIC Contact Information tab.
Resolution: The tabs in the Vendor Online Application can be renamed by the state. As a result, the image displayed in the DFDD may not match the actual application. The DFDD has been updated to correct the image to be consistent with the other images documented for the Business Information screen.
SUG-2009
Clinic
Benefits (Issue Benefits)
Issue: The DFDD does not document the standard information message received when a child food package cannot be found and infant food package is used instead.
Resolution: The DFDD has been updated to document the standard information message (I0057) with the text, "A child food package was not found for the participant {StateWICID, Last Name, First Name}. An infant food prescription will be used instead."
SUG-2012
DFDD
Permissions Matrix
Issue: The DFDD incorrectly states that when Risk Factor 101 and Risk Factor 371 are assigned to a participant together, the participant is high risk.
Resolution: The DFDD has been updated to remove this incorrect statement.
SUG-2017
Clinic
Food Prescription (Issue Benefits)
Issue: The DFDD does not specify that the tree list on the Food Prescription (Issue Benefits) screen only contains those household members who will receive benefits.
Resolution: The DFDD has been updated to clarify that the Household Food Prescriptions tree list is populated with household members who will receive benefits.
SUG-2018
Clinic
Certification WIC Category
Issue: The DFDD incorrectly documents how the Yes and No radio buttons function on the Certification WIC Category screen.
Resolution: The DFDD has been updated to specify that the Yes radio button causes the system to link the old pregnancy record with the new certification record. The No radio button causes the system to create and link a new pregnancy record with the new certification record. Additionally, the radio buttons have been updated to specify that the previous record was a pregnancy record and not a postpartum record.
SUG-2026
DFDD
Vendor Setup
Issue: The DFDD incorrectly documents how to setup custom letters for the Vendor application in the Vendor Setup topic.
Resolution: The DFDD has been updated to correctly document how to setup the custom letter functionality.
SUG-2029
Clinic
Participant List
Issue: The Date of Birth calendar control on the Participant List screen is documented in the DFDD as not accepting alphabetic or special characters.
Resolution: The DFDD has been updated to remove the incorrect information that the calendar control does not accept alphabetic or special characters. This correction was made in release 2.16.05.
SVN-1
Clinic
Participant Folder
Issue: When a new participant is added and the Participant Folder displays after prescreening, the user can double-click the record on the Participant List screen and open another instance of the same participant's Participant Folder.
Resolution: The code has been modified so that when the Participant Folder is displayed after prescreening, it adds the state WIC ID to the OpenedParticipantFolder collection. If the user attempts to display the Participant Folder again, the system displays a standard error message (E0365) with the text, "Another copy of folder for this Participant is already opened. Please use the existing folder."
SVN-2
State Office
Estimated Caseload
Issue: According to the DFDD, an AgencyEligibles table is to be present on all databases to store case load counts by agency on the Estimated Caseload screen.
Resolution: A new AgencyEligibles table has been added to store case load counts for an agency. The ClinicEligibles table is no longer used to store agency counts, but it still stores clinic counts.
SVN-3
Vendor
Add Food Item
Issue: The Food Category drop-down list box on the Add Food Item screen is blank when creating a compliance buy for a breastfeeding participant. This prevents the user from adding food items to a compliance buy.
Resolution: The Food Category drop-down list box was blank because the participant did not have any breastfeeding infants. Adding a breastfeeding infant to the breastfeeding participant resolved the issue.
SVN-4
State Office
Generate Clinic Activity Report
Issue: When the OK button is clicked on the Generate Clinic Activity Report screen, the system displays a standard error message with the text, "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
Resolution: When the report is output to a printer, the output has been modified to be landscape to prevent report data from being cropped.
The timeout occurs due to some of the tables in the report having many inserts/updates resulting in row locks. The report queries have been modified to ignore these row locks in order to return data in a timely manner.
The timeout value for the report queries to run has been increased to two (2) minutes for retrieval of the clinic related data and two (2) minutes for the retrieval of state related data.
The report queries run in an adequate amount of time after the timeout corrections, so no additional modifications were made.
SVN-5
State Office
Generate Breastfeeding Discontinuance Report
Issue: When the OK button is clicked on the Generate Breastfeeding Discontinuance Report screen, the system displays a standard error message with the text, "Min (956) must be less than or equal to max (-1) in a Range object."
Resolution: The query is returning an Agency 88 row and in a Minnesota database the StateCd is null, thus the system is displaying the standard error message. The code has been modified to exclude Agency 88 rows.
SVN-10
Reference Utility
Maintain State Nutrition Assessment Questions
Issue: When a new question is added on the Maintain State Nutrition Assessment Questions screen and the Reference Utility module is closed, the question cannot be deleted when the screen is displayed again. The system displays a standard error message (E0007) with the text, "The state nutrition assessment question is in use and cannot be deleted." The question was just added and is not in use by any participant. The same standard error message is displayed when attempting to delete recently added questions. The same issue occurs when attempting to delete answers.
Resolution: The system is working as designed. The system does not allow the deletion of questions or answers that have been used in a nutrition assessment. Additionally, the system does not allow the deletion of questions or answers if a clinic is marked as offline by ACM.
SVN-11
Reference Utility
Materials Given
Issue: The system is taking an excessively long time to display the Materials Given screen. In one instance, it took 1 minute and 20 seconds to display.
Resolution: The system was downloading the complete MaterialContacts table and iterating through it to create the list of material IDs in use. The code has been modified to use a new function using SQL to retrieve the distinct material IDs and download only the list of IDs in use.
SVN-12
Clinic
Child Health Information
Issue: On the Child Health Information screen for an infant who is over 6 months old, the Breastfeeding Now check box cannot be unchecked. When the check box is selected to be unchecked, the system displays a standard information message (I0049) with the text, "The participant's mother is categorically ineligible and mom's certification needs to be terminated."
Resolution: The standard information message has been changed to a standard confirmation message (C0068) with the text, "Mother's breastfeeding certification will be terminated because her linked infant over 6 months old stopped breastfeeding. Do you want to continue?" The options of Yes and No are available. If the user clicks Yes, the mother is terminated with the reason "Categorically Ineligible" and the change to the breastfeeding amount is allowed. If the user clicks No, the change is not made.
SVN-14
SPIRIT
Change Password
Issue: When entering a new password on the Change Password screen, the system displays a standard error message (E0373) with the text, "The password cannot be re-used." The standard error message is not descriptive enough for the user.
Resolution: The code has been modified to change the E0373 standard error message text to, "The password has been used previously. The new password cannot be the same as the previous {number} passwords." The variable {number} refers to the number of previous passwords.
SVN-16
Clinic
Mother's WIC Category Change
Issue: On the Mother's WIC Category Change screen, the Date Solids Were Introduced column requires an entry, but no entry can be made on the screen
Resolution: The code has been modified to make the Date Solids Were Introduced column not required.
SVN-19
Clinic
Mother's WIC Category Change
Issue: On the Mother's WIC Category Change screen, the dates entered can be a date in the future, which it should not be.
Resolution: The code has been modified to prevent the entry of future dates.
SVN-20
Clinic
Infant Information
Issue: When changing an infant's breastfeeding amount on the Infant Information screen, the system displays an object reference error.
Resolution: The code has been modified to verify the mother's household object is null and load it if necessary before referencing it.
SVN-21
Management Console
User Profile
Issue: On the User Profile screen, when a user selects the Active check box and enters an inactive date, the data is saved in the database. However, when the User Profile screen is displayed again, the Active check box is checked and the Inactive Date calendar control is disabled and blank. The screen is not saving the status of the Active check box.
Resolution: When the User Profile screen was loaded, the properties for the Active check box and Inactive Date calendar control were set according to values in the UserProfile table. A routine was then called that set the properties for these controls incorrectly. The code has been deleted that incorrectly set the properties.
SVN-24
Clinic
Infant Information
Issue: When the Infant in Foster Care check box is selected on the Infant Information screen, the Infant on WIC check box is unchecked.
Resolution: The code has been modified to prevent the Infant on WIC check box becoming unchecked when a change is made to the Infant in Foster Care check box.
SVN-26
Appendix
Permissions Matrix
Issue: The DFDD is unclear as to the meaning of N/A for certain permissions on the Permissions Matrix.
Resolution: The DFDD has been updated to more clearly explain what N/A means in regards to permission levels. The permissions of View, Add, and Full are a hierarchical structure with the higher permission encompassing the lower permissions when determining what functionality the user can access. For example, if a feature has defined functionality for View and Full, but the Add permission is documented as N/A, selecting the Add permission allows the user to have the View permission. Selecting the Full permission allows the user to have the View, Add, and Full permissions even though there is no defined functionality for the Add permission. Additionally, if the user selects a View permission for a feature that has N/A for View, the user does not have access to that feature.
SVN-27
Report Generator
Report Filter
Issue: On the Report Filter screen, the user is unable to create a query related to InitialContactDate or FirstAppointmentOfferedDate. When either of those is selected, the system does not insert the slashes in the Enter Value group box as it does when CreateDtTm is selected. When CreateDtTm is selected first and then either InitialContactDate or FirstAppointmentOfferedDate is selected, the slashes are inserted and remain. However, the SQL statement presents a standard error message that the system cannot select a value.
Resolution: The code has been modified to change the InitialContactDate and FirstAppointmentOfferedDate data types to datetime.
SVN-30
Clinic
Child Health Information
Issue: When the Breastfeeding Now check box on the Child Health Information screen is unchecked, the Date Solids Were Introduced calendar control is cleared.
Resolution: The code has been modified to not clear the Date Solids Were Introduced calendar control when the Breastfeeding Now check box is unchecked.
SVN-32
State Office
Dual Enrollment Report ENR001 (Output)
Issue: The DFDD does not include the details provided in SUG-1118 for the Dual Enrollment Report ENR001 (Output). Additionally, the DFDD needs to better explain the combinations and how the system chooses active participants.
Resolution: The DFDD has been updated with the changes documented in SUG-1118. Additionally, the DFDD has been updated to document that either the create date or the modify date of the Member table must be within the report month.
SVN-33
Scheduled Job Administration
End of Day
Issue: When the paid files for End of Day processing are in the correct folder on the application server, they are not being processed during End of Day. Instead, the system displays a standard error message with the text, "No Bank Paid files found to process."
Resolution: A previous change to remove a redundant parameter in ImportManager caused a problem for End of Day. The code has been modified to fix the function call in End of Day.
Additionally, a bug that was fixed in End of Day to remove carriage return characters in the filenames prevented any files from being downloaded with the error of invalid characters in the path. The code has been modified to remove it and replace it with a .Trim() statement.
SVN-34
Clinic
Certification Guided Script
Issue: The DFDD shows an incorrect image of the Certification Guided Script screen.
Resolution: The DFDD has been updated with a correct image.
SVN-35
Reference Utility
State Nutrition Assessment Question (Page 2)
Issue: A new nutrition assessment question can be added on the State Nutrition Assessment Question (Page 2) screen without entering any value in the Name or Text text boxes.
Resolution: The change order specifies that the Name, Question, and Text text boxes as well as the contents of the Answers group box are not required when saving a nutrition assessment question. When a question does not have any active answers, and a question answer targets an incomplete question, the answer instead targets the next active question.
SVN-36
Clinic
Infant Information
Issue: If there is no link between the mother and infant participant and the Breastfeeding Now check box is checked on the Infant Information screen, the Breastfeeding Amount drop-down list box changes to "Non-breastfeeding" and becomes disabled.
Resolution: The code has been modified to add a check to verify that the infant's information is populated before verifying the infant's date of birth.
SVN-37
Clinic
Nutrition Assessment Contact
Issue: The Question text box on the Nutrition Assessment Contact screen contains text that is grayed and difficult to read.
Resolution: The code has been modified to use the same text color as the label controls for better readability. However, the Question text box remains disabled.
SVN-39
Clinic
AdditionalInfo2
Issue: When removing an alternate representative on the AdditionalInfo2 screen, the Relationship drop-down list box cannot be cleared.
Resolution: The code has been modified so that when the other controls related to the alternate representative are cleared, the Relationship drop-down list box becomes blank when the screen is saved.
SVN-42
Reference Utility
Base Food Category Limits
Issue: When a food item is set to Round / Front Load on the Base Food Category Limits screen, the benefits are not being rounded correctly. For example, a formula food item was set to Round / Front Load and the infant was issued 9.82 cans of formula.
Resolution: The system was overriding the distribution rule for Rule 5 if it is EBT. This results in the system not rounding the quantity correctly. The code has been modified to examine the distribution rule for the food item so the rounding works correctly.
SVN-43
Clinic
Mother's WIC Category Change
Issue: When a mother's WIC category is changed on the Mother's WIC Category Change screen and the infant is not linked, no new food prescription is created for the mothers. Additionally, the new pseudo-certification does not have the system-assigned risk factors (Risk Factor 133 and Risk Factor 312).
When a mother's WIC category is changed from breastfeeding to non-breastfeeding, she is in a current certification, and there are infants linked to the mother, the Date BF Verified column is not automatically populated with the current system date.
The Reason BF Ended column should be renamed to Reason Stopped.
Carriage return line feeds should be added to the I0051 standard information message.
When an infant's breastfeeding amount is changed, the I0056 standard information message should tell the user that the mother's food package is also being changed.
When an infant's breastfeeding amount is changed, the standard confirmation message (C0057) states, "Infant is over 6 months receiving Food Package III." However, the infant may be less than 6 months old. The message is misleading.
The value in the Date BF Ended column should be cleared when changing a mother from non-breastfeeding to breastfeeding.
Resolution: The Mother's WIC Category Change screen now displays for unlinked infants. For unlinked infants, the State WIC ID, Name, and Age columns are blank. The editable data grid has been renamed the Infants Born from This Pregnancy editable data grid. The standard warning message (W0017) has been changed to, "Mother's WIC category will not change because the breastfeeding changes for her infants were cancelled. Do you want to continue?" Additionally, the mother's food prescriptions with dates before today are no longer deleted.
The code has been modified to automatically populate the Date BF Verified column with the current system date.
The code has been modified to rename the Reason BF Ended column to Reason Stopped.
The code has been modified to add carriage return line feeds to the I0051 standard information message.
The I0056 standard information message text has been changed to "A new food prescription was created based on the default food package for mom. New food prescription(s) were created based on the default food package for all linked infants that had their breastfeeding amounts changed."
The C0057 standard confirmation message text has been changed to read, "Infant will be over 6 months receiving Food Package III."
The code has been modified to clear the Date BF Ended column when the mother's WIC category is changed from non-breastfeeding to breastfeeding.
SVN-44
Reference Utility
Adjunctive Income Eligibility Maintenance
Issue: The DFDD does not document that numeric and special characters are not allowed in the Name column of the Additional Adjunctive Eligibility Options editable data grid on the Adjunctive Income Eligibility Maintenance screen.
Resolution: The DFDD has been updated to document that numeric and special characters are not allowed as valid characters in the Name column of the Additional Adjunctive Eligibility Options editable data grid.
SVN-45
Clinic
View Appointments for Date and Appointments for Date Listing Report CLN017 (Output)
Issue: On the View Appointments for Date screen, the Confirm button becomes disabled after it is clicked, but it does not re-enable until after the screen is closed and reopened.
The appointment type is not printing on the Appointments for Date Listing Report CLN017 (Output).
Resolution: The code has been modified to enable the Confirm button when the clinic selection is changed.
No change was made to the Appointments for Date Listing Report CLN017 (Output). The appointment type is printing on the output.
SVN-46
Clinic
Participant Folder and Certification Guided Script
Issue: The title bar of the Participant Folder and Certification Guided Script does not correctly display the gestational period for pregnant participants after the health information has been saved.
Resolution: The code has been modified to correctly display the gestational period after the health information has been saved to the database.
SVN-47
Clinic
Applicant Prescreening
Issue: When a value is entered in the Register to Vote drop-down list box on the Applicant Prescreening screen for an adult female participant, the value is not being copied into the Participant Folder.
Resolution: The issue was caused by an event handler of the WIC Category drop-down list box that incorrectly cleared the selection in the Register to Vote drop-down list box if the WIC category was an infant or child. The code has been modified to avoid clearing the selection in the Register to Vote drop-down list box.
SVN-48
Clinic
AdditionalInfo2
Issue: When a selection is made in the Relationship drop-down list box on the AdditionalInfo2 screen, it is not being correctly saved. The user has to reselect the Relationship drop-down list box a second time in order to save the selection.
Additionally, the hot key functionality to move to an option in the drop-down list box by pressing the key corresponding to the first letter of the option does not function in the Relationship drop-down list box within the Participant Folder.
Resolution: The code has been modified to update the Relationship drop-down list box when the name of an authorized or alternate representative is modified.
SVN-49
Clinic
Assign Certification Risk Factors
Issue: When the Remove button is clicked on the Assign Certification Risk Factors screen, the focus does not remain on the Remove button. The focus moves to the Risk Factors Detail Guide button. Pressing Enter on the keyboard activates the Risk Factors Detail Guide button instead of the OK button.
Resolution: The code has been modified so the OK button receives focus when the Remove button is clicked.
SVN-54
Clinic
Display Alerts
Issue: When a participant, who has a household alert and a CPA alert on the Display Alerts screen, has his or her Participant Folder opened, both alerts display. When the Participant Folder is closed and a new participant from the same household has the Participant Folder opened, the household alerts do not consistently display.
Resolution: The code has been modified to consistently display the household alerts.
SVN-55
Financial Management and Vendor
Bank Exceptions
Issue: On the Bank Exceptions screen, there are bank exceptions for a specific month, but the Bank Reconciliation screen does not display these exceptions for that month.
The DFDD does not specify where the Quarantine Date text and value label is populating its information from within the database. According to the change order, it should be in the BankExceptions table, but it is not and cannot be found in the database.
The change order specified that the BNKEXCPTREASON category of the Reference Dictionary table would be cleaned up and have several exceptions removed. No exceptions were removed, but several were added.
The numeric data in the Bank Exceptions data grid is left-aligned on the Bank Exceptions screen; it should be right-aligned according to the change order.
When the Process Banking File button is clicked on the Bank Exceptions screen, the system displays a standard error message (E0181) with the text, "The file was not found. Please verify the file path and name." This may be due to the system trying to find the EODProcess.XML file in the website folder. However, some environments keep the file with the application server files. This part of the application uses the correct file name, but End of Day processing does not. The same code should be used to generate the file name.
The OnDemandBankPaidFileProcess table does not record the CreateUserID or the ModifyUserID. It does record the AccessUserID, however.
When processing the bank file, the process is not using the application server. Instead, it uses the web server. The system is using its current environment to execute code.
Resolution: If there are no bank exceptions with a paid date that is within the specified date range, then the bank exceptions do not display on the Bank Reconciliation screen.
The Quarantine Date text and value label is taking its value from the CreateDtTm column of the BankExceptions table. The DFDD does document this information as of the 2.17 release.
The BNKEXCPTREASON category of the Reference Dictionary table contains foreign keys to other tables. Because the system does not use a foreign key constraint on these, if they were deleted there would be an issue with referential integrity. The code has been modified to set them to inactive rather than deleting them.
The numeric data in the Bank Exceptions data grid is left-aligned on the Bank Exceptions screen because they are not necessarily numeric values. The benefit number and stamp number are varchar values in the database. Additionally, the leading zeros on the values are significant and can only be displayed when stored as varchar.
The file name used when the Process Banking File button is clicked is using the same function to name the file as is used during End of Day. The system looks in the application folder for the file.
The OnDemandBankPaidFileProcess table does record the CreateUserID or the ModifyUserID. It uses the standard DataAccess layer functions. This may be an issue with the test environment being used.
The web server should be used when processing the bank file because the application can be run from any computer on the network. By necessity, this process must run on the web server.
Additionally, when the bank exception is modified on the Resolve Exception screen, the system displays a standard confirmation message (C0066) with the text, "Do you want to save your changes to the Bank Exception?"
SVN-56
SPIRIT
Permissions Matrix
Issue: When the permission for State Office - Reports is set to "None" on the Role Profile screen, users can still access and generate reports.
When the permission for accessing State Office is set to "Full", all subsequent permissions for State Office inherit the "Full" permission even when they are set to "View".
When the permission for accessing State Office is set to "Add" or "View", the user can open and access the State Office module.
Resolution: The permissions are functioning as designed. The DFDD has been updated for Feature ID 715 to be the Report Generator feature of the State Office feature group. All permission types allow access to the Report Generator module.
Additionally, the DFDD has been updated for Feature ID 300 to be for the State Office feature. The view permission allows access to generate reports.
SVN-58
Reference Utility
State Nutrition Assessment Question (Page 2)
Issue: On the State Nutrition Assessment Question (Page 2) screen, the check box in the Active column cannot be deselected.
Resolution: The system is functioning as designed. The active flag for the answers or short answer or true/false questions has been left disabled because they are managed internally by the system.
The code has been modified to correct Add and Full permissions for access to the buttons.
SVN-72
Clinic
Participant List
Issue: When the PAN # radio button is selected, the previously selected radio button for a search is not deselected on the Participant List screen. Only when the Clear button is clicked are the radio buttons deselected.
Resolution: This issue was discovered while working an enhancement for a future release. The code has been modified to correct this issue for the current release and future release.
SVN-73
DFDD
Permissions Matrix
Issue: Feature ID 104 is duplicated on the Permissions Matrix topic of the DFDD.
Resolution: The duplicate entry for Feature ID 104 has been removed.
TOF-9
Clinic
Capture Signature
Issue: When an electronic signature is captured and displayed on the screen, the picture box shows a signature image that is small and difficult to read. The following screens are affected:
Capture Electronic Signature (for Receipt of Food Instrument Benefits)
Capture Electronic Signature (for Receipt of Returnable Breastfeeding Items)
Capture Electronic Signature (for Receipt of the Rights and Responsibilities Statement)
Capture Signature for Card
Capture Staff Electronic Signature
Resolution: The code has been modified to correct the display of the signature within the application on either Windows XP or Windows 7.
TOF-26
Clinic
Work with On-site Group
Issue: When a household is added to the Work with On-site Group screen and benefits are issued to at least one member of the household, the entire household is removed from the Work with On-site Group screen. This applies only to EBT-enabled system.
Resolution: The code has been modified so the functionality for EBT-enabled system is the same as the functionality for EBT-disabled system. If a household is added to the Work with On-site Group screen and benefits are issued to one member but not to the others, the household remains on the screen until all necessary actions have been completed.
TOF-36
Clinic
Food Prescription
Issue: On the Food Prescription screen, the equivalent value of a food item (for example, "22 quarts of milk product" is displayed at the end of the food item description) does not display for items in the MilkSubstitutionType table.
Resolution: The code has been modified to add an exception for duplicate values on the Food Prescription screen. The exception for 1:1 ratios was removed.
TOF-51
Clinic
Child Health Information
Issue: When a currently breastfeeding infant is set as Fully Breastfeeding on the Child Health Information screen, the system is requiring a selection in the Reason(s) Stopped list box. A selection should not be required as the infant is current breastfeeding.
Resolution: This issue is caused by the Breastfeeding Now check box being selected before an option in the Ever Breastfed radio button group. The code has been modified to require an entry in the Ever Breastfed radio button group before the Breastfeeding Now check box can be selected.
TOF-74
Reference Utility
Food Item Wizard (2 of 3)
Issue: On the Risk Factor Associations tab on the Food Item Wizard (2 of 3) screen, the system does nothing when the Restore Base Food Category Limits button is clicked.
Resolution: The system is functioning as designed. The food item limits inherit from the base food item limits, so only the food item limits can be reset to the base limits.
To add clarity, the code has been modified to rename the Restore Base Food Category Limits button the Reset Food Item Limits button and move it to only display on the Food Items Limits tab.
TOF-111
Financial Management
Supplier Rebate Report FIN001 (Output)
Issue: When generating the Supplier Rebate Report FIN001 (Output) when a new rebate supplier has been added to the system, the report is blank. When a new rebate supplier is added, the RebateAgreementItemRx table is not populated with the new rebate supplier.
Resolution: The code has been modified to correctly save the rebate item when the OK button is clicked on the Rebate Item screen.
TOF-123
Financial Management
Supplier Rebate Report FIN001 (Output)
Issue: When generating the Supplier Rebate Report FIN001 (Output), the report doubles the count by returning two rows for each food item even though there is only one redemption for each item.
Resolution: The code has been modified to correct the SQL to add the condition to the join that the rebate schedule's supplier ID must equal the rebate agreement's supplier ID. The presence of two or more valid rebate schedules from different suppliers caused duplication in the totals. In other words, all rebates for all schedules were being included in each supplier's totals. Now only the rebates associated with a given supplier's rebate schedule is included in the totals for that supplier.
TOF-137
Clinic
Participant Folder
Issue: When a participant is changed from non-breastfeeding to breastfeeding, the system correctly updates the CERTCONTACT.CertEndDate but the MEMBER.CertificationDueDate is not updated.
Resolution: The code has been modified so the CertificationDueDate is updated with the same value as the new CertEndDate.
TOF-140
Reference Utility
Food Item Wizard (3 of 3)
Issue: When "Not Applicable" is selected in the Formulation Base drop-down list box and the Finish button is clicked on the Food Item Wizard (3 of 3) screen, the next time the screen is displayed, the Formulation Base drop-down list box is blank.
Resolution: When the "Not Applicable" value was added in the ExternalID, it was added as "NA". However, ExternalID only allows a single character. The system is truncating the "NA" value to "N" when saving the data. As a result, no code change was necessary.
The same issue was found for FormulationFormat, but as above, no code change was necessary.
TOF-160
Clinic
Pregnancy Information
Issue: The Last Pregnancy Ended masked edit box on the Pregnancy Information screen allows year values that should be considered invalid, such as 0001.
Resolution: The code has been modified to validate the Last Pregnancy Ended masked edit box. If the date entered is less than the participant's date of birth or greater than the LMP start date, the system displays a standard error message (E0386) with the text, "The Last Pregnancy Ended must be greater than the participant's Birth Date and less than the LMP Start Date for this pregnancy."
TOF-161
State Office
Year-to-date Participation and Outlays Report FIN017 (Output)
Issue: When generating the Year-to-date Participation and Outlays Report FIN017 (Output) for the month of July, the system displays a standard error message with the text, "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated."
Resolution: The code has been modified to retrieve the report using the dbo.uspLoadYearTodateParticipationOutlays stored procedure. The report no longer scans the FoodInstrumentItemRedeemed table for non-EBT and non-direct distribution databases. The FoodInstrumentSet, FoodInstrument, and FoodInstrumentItemRedeemed tables are scanned once to retrieve summary values instead of being scanned multiple times. The data is retrieved using WITH (NOLOCK) hints in order to reduce data contention.
The SQL connection for the data retrieval has been changed to have a timeout of six (6) minutes. The data returned from the database is now binary compressed in order to reduce latency from the web server to the client application. The retrieval times for the Clinic, Grantee, and Agency options have been significantly reduced. The retrieval times for the State and All options have been reduced, but times over a minute may still occur depending on the amount of data required.
The control layout on the Generate Year-to-date Participation and Outlays Report screen has been corrected to be better aligned. The phrase "Total Partic" has been changed to "Total Participation" in the output.
TOF-163
Clinic
Pre-pregnancy BMI
Issue: A participant whose anthropometric measurement was taken prior to the certification effective date is not being plotted on the Pre-pregnancy BMI screen. However, the risk factor was assigned correctly. A measurement added after the certification effective date does plot correctly.
Resolution: The code has been modified to allow measurements completed before the certification start date to display on the pregnancy and postpartum growth grids.
TOF-167
Financial Management
Supplier Rebate Report FIN001 (Output)
Issue: When generating the Supplier Rebate Report FIN001 (Output) that contains a vendor with a status of Denied, the system displays a standard error message with the text, "Conversion failed when converting the varchar value '{vendor ID}' to data type int." The vendor ID contains the letter "P" as the vendor was a denied applicant.
Resolution: The code has been modified to change the SQL of the report to not assume that Vendor ID is an integer. This allows it to perform correctly when a vendor ID is prefaced with a "P".
TOS-6
Appendix
Risk Factors Matrix
Issue: The DFDD does not clearly define how the USETWOMOSTRECENTMESUREMENTSRF131P business rule influences when Risk Factor 131 is assigned.
Resolution: The DFDD has been updated to clarify how the business rule influences the assignment of Risk Factor 131.
TOS-10
Clinic
Pregnancy Information
Issue: When a pregnant participant is assigned Risk Factor 345 by the system, the Hypertension or Prehypertension check box is not selected on the Pregnancy Information screen.
Resolution: The code has been modified to verify the Hypertension or Prehypertension check box on a new postpartum certification is checked if the linked pregnancy certification has it checked. The user may uncheck it during a Certification Guided Script if the participant does not have the condition.
TOS-11
Clinic
Child Health Information
Issue: When a linked infant's health information is entered on the Infant Information screen, the Child Health Information screen for the infant is blank during a Certification Guided Script.
Resolution: The code has been modified to add a check on the Health Information link of the Certification Guided Script to verify the participant is an infant or child and if the relationship with the mother has changed. If the relationship has changed, the participant is reloaded and the risk factors updated before displaying the Child Health Information screen.
TOS-20
Clinic
Risk Factors
Issue: A child who is more than 2-years old was measured recumbently and plotted correctly on the Growth Grids. However, the system assigned Risk Factor 113. Children more than 2-years old and measured recumbently should not be assigned anthropometric risk factors.
Resolution: The code has been modified to remove previously implemented code that system-assigned Risk Factor 113 for 24-36 month old children who are measured recumbently and have a weight for height percentile equal to or above 95%.
TOS-21
Clinic
Benefits (Issue Benefits)
Issue: A participant with monthly issuance has three months of benefits suggested on the Benefits (Issue Benefits) screen. The participants are receiving more benefits than their issuance frequency.
Resolution: The issue is caused by the system taking into account the value of the CLN_AllowFutureBenefitsWithinDays business rule. If the total number of days of issuance is less than the CLN_AllowFutureBenefitsWithinDays business rule value, the system keeps adding benefits.
The code has been modified to remove the CLN_AllowFutureBenefitsWithinDays business rule from the issuance logic. The system now only looks at the member's issuance frequency and determines the number of unique benefit months to be issued, taking into account any future benefits previously issued.
Additionally, code has been added to work in the situation where one tri-monthly household member was issued two months of benefits and then later the other household member is issued all 3-months of benefits. The system now issues the third benefit for the first member and all three benefits for the second member as long as the CLN_AllowFutureBenefitsWithinDays business rule is set to be large enough to allow the third set to be issued.
TOS-44
Vendor Online Price Survey
New Price List
Issue: When importing a price list from an Excel file on the New Price List screen, the system does not correctly handle the values. When importing, the system is to divide the retail item prices by their unit amounts and choose the highest price to use as the distribution item price. Instead, the system imports the values and does not divide the retail item prices. However, it still assigns the highest price for the distribution item.
Resolution: The code has been modified to divide the vendor price by the retail item size and use the maximum price across all retail items as the distribution item price.
TOS-68
DFDD
Risk Factors Matrix
Issue: The Risk Factors Matrix topic in the DFDD is missing the decimal point for Overweight and Obese weight gains for Risk Factor 133. The entries in the chart should be 0.7 and not 7; and 0.6 and not 6.
Resolution: The DFDD has been updated to add the decimal points.
TOS-78
Clinic
Generate Missed Appointment Notices
Issue: The DFDD documents duplicates information on the Missed Appointment Notice Document (Output) topic stating that the report can be generated by clicking the OK button on the Generate Missed Appointment Notices screen or the Generate Missed Appointment Notice screen.
Resolution: The Missed Appointment Notice Document (Output) can be generated from two different locations in the application: From the Generate Documents screen and from the Follow-up Information screen. However, the screen displayed is nearly identical except for a few controls that are only visible when the Generate Missed Appointment Notices screen is displayed from the Generate Documents screen.
The DFDD has been updated to document the Generate Missed Appointment Notices screen in a single topic.
TOS-82
Clinic
Risk Factors
Issue: Risk Factor 142 does not system-assign for children 1-2 years in age.
Resolution: The application is functioning as designed. The risk factor is system-assigned if the difference between the LMP date of the linked mother and the actual date of birth of the infant or child is 37 or fewer weeks.
TOS-83
DFDD
Risk Factors Matrix
Issue: The Risk Factors Matrix topic in the DFDD does not document the assignment method for children birth to 2 years of age if the participant is <= 5th percentile for weight-for-length for Risk Factor 103.
Resolution: The DFDD has been updated to correctly document that assignment method for the risk factor.
TOS-88
Vendor
Generate TIP File - Step 1
Issue: The DFDD incorrectly spells the High Risk Analysis radio button on the Generate TIP File - Step 1 screen as "Hight Risk Analysis".
Resolution: The DFDD has been updated to correct all misspellings of the High Risk Analysis radio button.
TOS-91
Clinic
Certification History
Issue: When a CPA-assigned risk factor is removed, the system-assigned risk factors are not carried forward to the pseudo-certification.
Resolution: The code has been modified to retain the system-assigned risk factors when CPA-assigned risk factors are removed from a participant.
TOS-97
Reference Utility
Risk Factor
Issue: The DFDD is unclear about when the Assignment Method drop-down list box is enabled on the Risk Factor screen.
Resolution: The DFDD has been updated to clarify when the Assignment Method drop-down list box is enabled or disabled.
TOS-102
DFDD
Table and Column Names
Issue: The DFDD incorrectly documents some table and column names from the database with hyphens.
Resolution: The DFDD has been updated to remove the hyphens from table or column names defined in the issue description. Other instances of hyphens in table or column names may still exist.
TOS-103
Vendor
Vendors Whose Average Food Package Cost is More Than 10% Above Peer Group Average Report VND028 (Output)
Issue: The DFDD states that the calculation for determining the values of the Infant, Breastfeeding Pregnant, and Non-B/Feeding Child columns of the Vendors Whose Average Food Package Cost is More Than 10% Above Peer Group Average Report VND028 (Output) is the sum of the PaidAmt column of the FoodInstrument table divided by the count of selected food instruments for each vendor where the WICStatus column of the FoodInstrument table equals a specific value. There is no WICStatus column in the FoodInstrument table.
Resolution: The DFDD has been updated to correctly document that the WICStatus column is being pulled from the FoodInstrumentSet table.
TOS-104
Clinic
Risk Factors
Issue: CPA-assigned risk factors are carried forward for a participant in a new certification period.
Resolution: The Invoked from Certification Guided Script property on the Infants Born from This Pregnancy screen was not being set correctly by the system for a mother participant. This causes the risk factor code to pull CPA-assigned risk factors from the previous certification and add them to the current certification. The code has been modified to correctly set this property so the code does not carry forward CPA-assigned risk factors to the current certification.
TOS-114
Clinic
Infant Information
Issue: When a female participant is certified as non-breastfeeding and a reason stopped is selected, the value in the Reason(s) Stopped list box is not carried forward on the Infant Information screen.
Resolution: This issue was resolved with changes related to the WIC category changes for a mother on the Mother's WIC Category Change screen.
TOS-115
Scheduled Job Administration
End of Month Processing
Issue: When running End of Month Processing, the system times out during the optional process and then terminates.
Resolution: The code has been modified to change the execution timeout of the BMI report from 2 minutes to 10 minutes.
TOS-121
Central Administrative Site, Clinic, and State Office
Growth Grids
Issue: The 0-24 WHO Len/Age, 0-24 WHO WT/Age and 0-24 WHO WT/Len growth grids do not include the 2nd and 98th percentile lines.
Resolution: The code has been modified to add the 2.3 and 97.7 percentile curves to all three growth grids.
TOS-138
Clinic
Capture Electronic Signature (for Receipt of Returnable Breastfeeding Items)
Issue: The DFDD incorrectly states in a note on the Capture Electronic Signature (for Receipt of Returnable Breastfeeding Items) screen topic that the signature captured on the screen is an acknowledgement by the signatory that he or she has determined that the participant is either eligible or ineligible for WIC benefits based on the accuracy of information collected during certification.
Resolution: The DFDD has been updated to change the note text to, "The signature captured on the screen is an acknowledgement by the signatory that he or she has received the receipt of returnable breastfeeding items."
VRP-4
Vendor Online Price Survey
Price List Details
Issue: When a price is entered for a parent item on the Price List Details screen, the child item is correctly calculated. However, if the price for the parent item is cleared and a rejection reason is selected, the child item's price is not cleared. Rejecting the parent item and resubmitting a different price is not reflected in the child item. As a result, the system approves the price survey even though a price was rejected.
Resolution: The code has been modified to divide the retail item price by size and take the maximum price from all the retail items linked to the distribution item.
VRP-88
DFDD
Communication Template Merge Fields
Issue: The DFDD is unclear on the Communication Template Merge Fields topic regarding what merge fields can be used with the Vendor Online Price Survey module.
Resolution: The DFDD has been updated to document that only the Vendor.TradeName merge field can be used with the Vendor Online Price Survey module.
VRP-154
Vendor
Compliance Buy Benefits
Issue: On the Compliance Buy Benefits screen, there is a six (6) item limit for the number of food items. However, some benefits may have seven (7) food items. Additionally, only three (3) benefits are available to be populated on the screen. Some default food packages have four (4) benefits and, as a result, two food packages must be created to account for the fourth benefit which usually results in benefit numbers that are not sequential.
Resolution: The code has been modified to allow the entry of seven (7) food items in each of the three (3) benefits.