Contents Show
Changes made in this release of the software are detailed below.
Release 2.36.00 (2.36.xxxxx.xxxx).zip
Release 2.36.00 (2.36.xxxxx.xxxx) Source Code.zip
BatchProcessing_Core.zip
BatchProcessing_Core_Source Code.zip
v2.36.00_dfdd.zip
v2.36.00_webhelp_dfdd.zip
SPIRIT_Release_Notes_for_Version_2.36.00.pdf
States should clear participant e-mails from records in their test environment, so that real participants are not sent test e-mails.
The first time the End of Day Command Line Batch Processing is run, the Duplicate Participant Service will calculate phonetic values for the first and last names of every participant. This may require extended processing time.
With this release of the software, changes must be made manually to the EBTCONNECTIONINFO table to support new functionality in the SPIRIT WIC system.
Ensure that valid file folder paths/filenames and values are specified within the following parameters of the EBTCONNECTIONINFO table of the SPIRIT database:
NOTE: The user running the batch must have access to the path and filename. |
i) Appointment Reminder Template English (ApptReminderTemplateEng)
This value represents the folder location and filename for the English e-mail template. This value is required. Example: C:\Program Files (x86)\Covansys Inc. - BPDS\Wic\Templates\AN005.txt
ii) Appointment Reminder Template Spanish (ApptReminderTemplateSpanish)
This value represents the folder location and filename for the Spanish e-mail template. This value is required. Example: C:\Program Files (x86)\Covansys Inc. - BPDS\Wic\Templates\AN006.txt
iii) Appointment Reminder Batch Timeout (ApptReminderBatchTimeout)
This value is used to control the timeout period of the bulk insert of health notes. The default for this value is 60 seconds. This value is required.
iv) Appointment Reminder Batch Record Count (ApptReminderBatchRecordCount)
This value used to control the number of health note rows to bulk load during each part of a single transmission. The default for this value is 5000 rows. This value is required.
Ensure that valid file folder path values are specified within the following parameters of the EBTCONNECTIONINFO table of the SPIRIT database:
NOTE: The user running the batch must have access to the path and filename. |
i) Expired Benefits Batch Timeout (ExpiredBenefitsBatchTimeout)
This value is used to control the timeout period of the bulk insert of initial records. The default for this value is 60 seconds. This value is required.
ii) Expired Benefits Batch Record Count (ExpiredBeneBatchRecordCount)
This value represents the maximum number of rows to bulk load during each part of a single transmission. The default for this value is 5000 rows. This value is required. If, for any reason, the batch record count isn't available, a default of 2000 rows is used.
iii) File Receive Path (FileReceivePath)
This value represents the folder location for the Expired Benefits File used for processing. This value is required.
iv) File Archive Path (FileArchivePath)
This value represents the folder location for the archived Expired Benefits File. This value is required.
v) Expired Benefits Filename (ExpiredBenefitsFileName)
This value represents the file name of the Expired Benefits File. This value is required.
For more information about the syntax of the ExpiredBenefitsFileName, refer to the file naming conventions section of the Expired Benefits File topic.
vi) Summer EBT Profile Number (SEBT_ProfileNum)
This value is used to compare the profile number in the Expired Benefits File. If both are same, then the Summer EBT row in the Expired Benefits File is ignored and it is not saved in the SPIRIT database. This value is not required. See the Profile Number section of the Expired Benefits File topic for more information.
vii) File Type (FileType)
This value represents the file type. This value is required. Valid values are as follows:
0 = JP Morgan
1 = WUMEI2014
2 = WUMEI2018
viii) EBT processor ICD Version (ICDVersion)
This value represents the EBT processor ICD Version to which this file complies, such as ICD.2014.2.5. This value is required when the value of the FILETYPE column in the EBTCONNECTIONINFO table is equal to "1" or "2".
ix) Universal Service Provider type (UniversalServiceProviderType)
This value represents the Universal Service Provider that generated the file. This value is required when the value of the FILETYPE column in the EBTCONNECTIONINFO table is equal to "1" or "2". Valid values are as follows:
0 = WUMEI (generic)
1 = WIC Direct
2 = S3 (Solutran)
3 = Conduent
x) WIC EBT host ID (WICEBTSystemID)
This value represents the WIC EBT host ID as per the EBT processor ICD. This value should match the file originator in the Header section of the file. This value is required when the value of the FILETYPE column in the EBTCONNECTIONINFO table is equal to "1" or "2".
xi) WIC MIS System ID (WICMISSystemID)
This value represents the WIC MIS System ID as per the EBT processor ICD. This value should match the receiving institution ID in the file. This value is required when the value of the FILETYPE column in the EBTCONNECTIONINFO table is equal to "1" or "2".
xii) WIC Benefits Purged File Type Extension (WICBenefitsPurgedFileTypeExt)
This value is used to add a file type extension to the file name when it is created in the FileSendPath and FileArchivePath. This value is required when the value of the FILETYPE column in the EBTCONNECTIONINFO table is equal to "1" or "2"and should match the file name format specified in the EBT processor ICD.
The table below documents software enhancements included within this release of the software.
Enhancements |
||||||
Enhancement# |
Primary Function |
Enhancement Detail |
||||
ENH-609 |
Duplicate Participant Service End of Day Process |
Within the SPIRIT WIC system, the End of Day Command Line Batch Processing that occurs when the BatchProcessor.dll is run from the Command Prompt was expanded to include Duplicate Participant Service processing. R1: Ensure that the new EOD correctly processes and updates the appropriate records for the following:
To accommodate the R1 requirement for this enhancement, the following new stored procedures were added and distributed with this release of the software:
Four new values were added to the MEMBER table. For more information, see the database changes for this enhancement. R2: The release notes should contain the name of any stored procedures used by EOD after these changes have been applied. To accommodate the R2 requirement for this enhancement, the following stored procedures were added and distributed with this release of the software:
For more information, see the database changes for this enhancement. R3: The legacy EOD process shall discontinue the process of identifying potential duplicate participants To accommodate the R3 requirement for this enhancement, changes to End of Day Processing for ENH-609 removed Duplicate Participant Service processing from the End of Day Process in the Scheduled Job Administration application module. With the 2.36.00 release of the SPIRIT WIC system, Duplicate Participant Service processing now occurs only during End of Day Command Line Batch Processing. R4: The new EOD will accept any modifications to criteria in the DuplicateParticipantConfiguration table. To accommodate the R4 requirement for this enhancement, the following new GetDuplicateParticipantConfiguration stored procedure was added and distributed with this release of the software to return criteria from the DUPLICATEPARTICIPANTCONFIGURATION table for determining potential duplicate participants. For more information, see the database changes for this enhancement. R5: All new processes will log information to the scheduled job log in a manner consistent with the original versions, however the order may be different since the job order may change during transition. To accommodate the R5 requirement for this enhancement, information is logged consistently in the SCHEDULEDJOBLOG table of the SPIRIT database. R6: Any prerequisite processes for either of these processes shall continue to run ahead of these processes in either legacy or the new EOD. To accommodate the R6 requirement for this enhancement, the prerequisite processes continue to run as intended. This process will only run in End of Day if at least one record exists in the DuplicateParticipantConfiguration table with the Include in Compare column equal to "Y". Processing in the BatchProcessor occurs in the following order: 1. Sanction Points Service Processing within the BatchProcessor 2. Pending Vendor Disqualifications Service within the BatchProcessor 3. Member Adjustments/Archives/Purges Service Processing within the BatchProcessor 4. Peer Group Reassessment Processing within the BatchProcessor 5. Appointment Reminder Service Processing within the BatchProcessor 6. Reset Probations Service Processing within the BatchProcessor 7. Redemption Processing within the BatchProcessor 8. WIC Activity File Processing within the BatchProcessor 9. Expired Benefits File Processing within the BatchProcessor 10. MAR Calculation Processing within the BatchProcessor
11. Category/Sub-category Processing within the BatchProcessor 12. Authorized Vendor File Processing within the BatchProcessor 13. Approved Product List (APL) Processing within the BatchProcessor 14. WIC Activity Reconciliation Processing within the BatchProcessor 15. Duplicate Participant Service Processing within the BatchProcessor Additionally, the following processing groups occur asynchronously: Group 1: 1. Sanction Points Service Processing within the BatchProcessor 2. Pending Vendor Disqualifications Service within the BatchProcessor Group 2: 1. Member Adjustments/Archives/Purges Service Processing within the BatchProcessor Group 3: 1. Peer Group Reassessment Processing within the BatchProcessor 2. Appointment Reminder Service Processing within the BatchProcessor 3. Reset Probations Service Processing within the BatchProcessor Group 4: 1. Redemption Processing within the BatchProcessor 2. WIC Activity File Processing within the BatchProcessor 3. Expired Benefits File Processing within the BatchProcessor Group 5: 1. MAR Calculation Processing within the BatchProcessor 2. Category/Sub-category Processing within the BatchProcessor 3. Authorized Vendor File Processing within the BatchProcessor Group 6: 1. Approved Product List (APL) Processing within the BatchProcessor 2. WIC Activity Reconciliation Processing within the BatchProcessor Group 7: 1. Duplicate Participant Service Processing within the BatchProcessor
|
||||
ENH-611 |
Appointment Reminder E-mail (Output) End of Day Process |
Within the SPIRIT WIC system, the End of Day Command Line Batch Processing that occurs when the BatchProcessor.dll is run from the Command Prompt was expanded to include Appointment Reminder E-mail (Output) processing. R1: The release notes should include a reminder that states will want to clear participant emails from records, in their test environment, so that real participants are not sent test emails. To accommodate the R1 requirement for this enhancement, states should clear participant e-mails from records in their test environment, so that real participants are not sent test e-mails. R2: Ensure that the new EOD processes correctly sends appointment reminder emails for the appropriate records. To accommodate the R2 requirement for this enhancement, the following new stored procedures were added and distributed with this release of the software:
Four new values were added to the EBTCONNECTIONINFO table. The Appointment Reminder Service adds a new record with the “WICEOD” value for PROCESSNAME and the "WICEOD" value for SYSTEMNAME to the COMMREQUEST table if one does not exist. For more information, see the database changes for this enhancement. R3: Ensure that the new EOD logs the appointment reminder email details appropriately in the EOD process log if business rule APT_REMINDERLOGDETAILSENABLED is set to Y. To accommodate the R3 requirement for this enhancement, the following new GetStateBusinessRuleParametersstored procedure was added and distributed with this release of the software. Failed appointment reminder e-mails are always logged in the SCHEDULEDJOBLOG table of the SPIRIT database. If the value of the APT_REMINDERLOGDETAILSENABLED business rule equals "Y", the Appointment Reminder Service also logs all successful appointment reminder e-mails. For more information, see the database changes for this enhancement. R4: Ensure a note is entered in the participant folder if an appointment reminder email is sent. To accommodate the R4 requirement for this enhancement, the following new stored procedure was added and distributed with this release of the software:
The Appointment Reminder Service creates a participant Health Note for each successful e-mail. For more information, see the database changes for this enhancement. R5: The release notes should contain the name of any stored procedures used by EOD after these changes have been applied. To accommodate the R5 requirement for this enhancement, the following stored procedures were added or modified and distributed with this release of the software:
For more information, see the database changes for this enhancement. R6: The legacy EOD process shall discontinue sending appointment reminder emails. To accommodate the R6 requirement for this enhancement, changes to End of Day Processing for ENH-611 removed Appointment Reminder E-mail (Output) processing from the End of Day Process in the Scheduled Job Administration application module. With the 2.36.00 release of the SPIRIT WIC system, Appointment Reminder E-mail (Output) processing now occurs only during End of Day Command Line Batch Processing. R7: The legacy EOD process shall discontinue logging details of appointment reminder emails. To accommodate the R7 requirement for this enhancement, changes to End of Day Processing for ENH-611 removed Appointment Reminder E-mail (Output) processing from the End of Day Process in the Scheduled Job Administration application module. R8: All new processes will log information to the scheduled job log in a manner consistent with the original versions; however, the order may be different since the job order may change during transition. To accommodate the R8 requirement for this enhancement, information is logged consistently in the SCHEDULEDJOBLOG table of the SPIRIT database. R9: Any prerequisite processes for either of these processes shall continue to run ahead of these processes in either legacy or the new EOD. To accommodate the R9 requirement for this enhancement, the prerequisite processes continue to run as intended. Processing in the BatchProcessor occurs in the following order: 1. Sanction Points Service Processing within the BatchProcessor 2. Pending Vendor Disqualifications Service within the BatchProcessor 3. Member Adjustments/Archives/Purges Service Processing within the BatchProcessor 4. Peer Group Reassessment Processing within the BatchProcessor 5. Appointment Reminder Service Processing within the BatchProcessor 6. Reset Probations Service Processing within the BatchProcessor 7. Redemption Processing within the BatchProcessor 8. WIC Activity File Processing within the BatchProcessor 9. Expired Benefits File Processing within the BatchProcessor 10. MAR Calculation Processing within the BatchProcessor
11. Category/Sub-category Processing within the BatchProcessor 12. Authorized Vendor File Processing within the BatchProcessor 13. Approved Product List (APL) Processing within the BatchProcessor 14. WIC Activity Reconciliation Processing within the BatchProcessor 15. Duplicate Participant Service Processing within the BatchProcessor Additionally, the following processing groups occur asynchronously: Group 1: 1. Sanction Points Service Processing within the BatchProcessor 2. Pending Vendor Disqualifications Service within the BatchProcessor Group 2: 1. Member Adjustments/Archives/Purges Service Processing within the BatchProcessor Group 3: 1. Peer Group Reassessment Processing within the BatchProcessor 2. Appointment Reminder Service Processing within the BatchProcessor 3. Reset Probations Service Processing within the BatchProcessor Group 4: 1. Redemption Processing within the BatchProcessor 2. WIC Activity File Processing within the BatchProcessor 3. Expired Benefits File Processing within the BatchProcessor Group 5: 1. MAR Calculation Processing within the BatchProcessor 2. Category/Sub-category Processing within the BatchProcessor 3. Authorized Vendor File Processing within the BatchProcessor Group 6: 1. Approved Product List (APL) Processing within the BatchProcessor 2. WIC Activity Reconciliation Processing within the BatchProcessor Group 7: 1. Duplicate Participant Service Processing within the BatchProcessor
|
||||
ENH-617 |
Process Pending Vendor Disqualifications End of Day Process |
Within the SPIRIT WIC system, the End of Day Command Line Batch Processing that occurs when the BatchProcessor.dll is run from the Command Prompt was expanded to include Pending Vendor Disqualifications Service processing. R1: Ensure that the new EOD processes Vendor Disqualifications correctly and updates the appropriate records when business rule EOD_PROCESSPENDINGDISQUALIFICATION is set to Y. To accommodate the R1 requirement for this enhancement, the new UpdatePendingVendorDisqualifications stored procedure was added and distributed with this release of the software. When the EOD_PROCESSPENDINGDISQUALIFICATION business rule and the EOD_RUNVENDORPROCESSES business rule equal "Y", the Pending Vendor Disqualifications Service updates the appropriate vendor records. For more information, see the database changes for this enhancement. The legacy End of Day process contained the following errors, which CDP believes were resolved with the changes made to End of Day Command Line Batch Processing for ENH-617:
R2: Vendor disqualifications should not process in new EOD when business rule EOD_PROCESSPENDINGDISQUALIFICATION is set to N. To accommodate the R2 requirement for this enhancement, the new UpdatePendingVendorDisqualifications stored procedure was added and distributed with this release of the software. If value of the EOD_PROCESSPENDINGDISQUALIFICATION business rule equals "N", the Pending Vendor Disqualifications Service does not update the appropriate vendor records. For more information, see the database changes for this enhancement. R3: The release notes should contain the name of any stored procedures used by EOD after these changes have been applied. To accommodate the R3 requirement for this enhancement, the new UpdatePendingVendorDisqualifications stored procedure was added and distributed with this release of the software. R4: The legacy EOD process shall discontinue processing vendor disqualifications. To accommodate the R4 requirement for this enhancement, changes to End of Day Processing for ENH-617 removed Process Pending Disqualification processing from the End of Day Process in the Scheduled Job Administration application module. With the 2.36.00 release of the SPIRIT WIC system, Pending Vendor Disqualifications Service processing now occurs only during End of Day Command Line Batch Processing. R5: All new processes will log information to the scheduled job log in a manner consistent with the original versions, however the order may be different since the job order may change during transition. To accommodate the R5 requirement for this enhancement, information is logged consistently in the SCHEDULEDJOBLOG table of the SPIRIT database. R6: Any prerequisite processes for either of these processes shall continue to run ahead of these processes in either legacy or the new EOD. To accommodate the R6 requirement for this enhancement, the prerequisite processes continue to run as intended: Processing in the BatchProcessor occurs in the following order: 1. Sanction Points Service Processing within the BatchProcessor 2. Pending Vendor Disqualifications Service within the BatchProcessor 3. Member Adjustments/Archives/Purges Service Processing within the BatchProcessor 4. Peer Group Reassessment Processing within the BatchProcessor 5. Appointment Reminder Service Processing within the BatchProcessor 6. Reset Probations Service Processing within the BatchProcessor 7. Redemption Processing within the BatchProcessor 8. WIC Activity File Processing within the BatchProcessor 9. Expired Benefits File Processing within the BatchProcessor 10. MAR Calculation Processing within the BatchProcessor
11. Category/Sub-category Processing within the BatchProcessor 12. Authorized Vendor File Processing within the BatchProcessor 13. Approved Product List (APL) Processing within the BatchProcessor 14. WIC Activity Reconciliation Processing within the BatchProcessor 15. Duplicate Participant Service Processing within the BatchProcessor Additionally, the following processing groups occur asynchronously: Group 1: 1. Sanction Points Service Processing within the BatchProcessor 2. Pending Vendor Disqualifications Service within the BatchProcessor Group 2: 1. Member Adjustments/Archives/Purges Service Processing within the BatchProcessor Group 3: 1. Peer Group Reassessment Processing within the BatchProcessor 2. Appointment Reminder Service Processing within the BatchProcessor 3. Reset Probations Service Processing within the BatchProcessor Group 4: 1. Redemption Processing within the BatchProcessor 2. WIC Activity File Processing within the BatchProcessor 3. Expired Benefits File Processing within the BatchProcessor Group 5: 1. MAR Calculation Processing within the BatchProcessor 2. Category/Sub-category Processing within the BatchProcessor 3. Authorized Vendor File Processing within the BatchProcessor Group 6: 1. Approved Product List (APL) Processing within the BatchProcessor 2. WIC Activity Reconciliation Processing within the BatchProcessor Group 7: 1. Duplicate Participant Service Processing within the BatchProcessor
|
||||
ENH-618 |
Process Sanction Points End of Day Process |
Within the SPIRIT WIC system, the End of Day Command Line Batch Processing that occurs when the BatchProcessor.dll is run from the Command Prompt was expanded to include Sanction Points Service processing. R1: Ensure that the new EOD processes expired vendor sanction points correctly and updates the appropriate records when business rule EOD_PROCESSSANCTIONPOINTS is set to "Y". To accommodate the R1 requirement for this enhancement, the new ProcessSanctionPoints stored procedure was added and distributed with this release of the software. When the values of both the EOD_PROCESSSANCTIONPOINTS and EOD_RUNVENDORPROCESSES business rules equal "Y", the Sanction Points Service updates the appropriate vendor records. For more information, see the database changes for this enhancement. R2: The new EOD process should not remove expired vendor sanction points if business rule EOD_PROCESSSANCTIONPOINTS is set to “N”. To accommodate the R2 requirement for this enhancement, the new ProcessSanctionPoints stored procedure was added and distributed with this release of the software. If value of either the EOD_PROCESSSANCTIONPOINTS business rule or the EOD_RUNVENDORPROCESSES business rule equals "N", the service terminates. For more information, see the database changes for this enhancement. R3: The release notes should contain the name of any stored procedures used by EOD after these changes have been applied. To accommodate the R3 requirement for this enhancement, the new ProcessSanctionPoints stored procedure was added and distributed with this release of the software. For more information, see the database changes for this enhancement. R4: The legacy EOD process shall discontinue processing expired vendor sanction points. To accommodate the R4 requirement for this enhancement, changes to End of Day Processing for ENH-618 removed Process Sanction Points processing from the End of Day Process in the Scheduled Job Administration application module. With the 2.36.00 release of the SPIRIT WIC system, Sanction Points Service processing now occurs only during End of Day Command Line Batch Processing. R5: All new processes will log information to the scheduled job log in a manner consistent with the original versions, however the order may be different since the job order may change during transition. To accommodate the R5 requirement for this enhancement, information is logged consistently in the SCHEDULEDJOBLOG table of the SPIRIT database: R6: Any prerequisite processes for either of these processes shall continue to run ahead of these processes in either legacy or the new EOD. To accommodate the R6 requirement for this enhancement, the prerequisite processes continue to run as intended: Processing in the BatchProcessor occurs in the following order: 1. Sanction Points Service Processing within the BatchProcessor 2. Pending Vendor Disqualifications Service within the BatchProcessor 3. Member Adjustments/Archives/Purges Service Processing within the BatchProcessor 4. Peer Group Reassessment Processing within the BatchProcessor 5. Appointment Reminder Service Processing within the BatchProcessor 6. Reset Probations Service Processing within the BatchProcessor 7. Redemption Processing within the BatchProcessor 8. WIC Activity File Processing within the BatchProcessor 9. Expired Benefits File Processing within the BatchProcessor 10. MAR Calculation Processing within the BatchProcessor
11. Category/Sub-category Processing within the BatchProcessor 12. Authorized Vendor File Processing within the BatchProcessor 13. Approved Product List (APL) Processing within the BatchProcessor 14. WIC Activity Reconciliation Processing within the BatchProcessor 15. Duplicate Participant Service Processing within the BatchProcessor Additionally, the following processing groups occur asynchronously: Group 1: 1. Sanction Points Service Processing within the BatchProcessor 2. Pending Vendor Disqualifications Service within the BatchProcessor Group 2: 1. Member Adjustments/Archives/Purges Service Processing within the BatchProcessor Group 3: 1. Peer Group Reassessment Processing within the BatchProcessor 2. Appointment Reminder Service Processing within the BatchProcessor 3. Reset Probations Service Processing within the BatchProcessor Group 4: 1. Redemption Processing within the BatchProcessor 2. WIC Activity File Processing within the BatchProcessor 3. Expired Benefits File Processing within the BatchProcessor Group 5: 1. MAR Calculation Processing within the BatchProcessor 2. Category/Sub-category Processing within the BatchProcessor 3. Authorized Vendor File Processing within the BatchProcessor Group 6: 1. Approved Product List (APL) Processing within the BatchProcessor 2. WIC Activity Reconciliation Processing within the BatchProcessor Group 7: 1. Duplicate Participant Service Processing within the BatchProcessor
|
||||
ENH-642 |
Expired Benefits File End of Day Process |
Within the SPIRIT WIC system, the End of Day Command Line Batch Processing that occurs when the BatchProcessor.dll is run from the Command Prompt was expanded to include Expired Benefits File processing. R1: Ensure that the new EOD imports the Expired Benefit File and updates the appropriate records by adding the FoodInstrumentItemDetail Rows with a transaction code of 5. To accommodate the R1 requirement for this enhancement, the new GetFoodInstrumentId stored procedure was added and distributed with this release of the software. For more information, see the database changes for this enhancement. The legacy End of Day process contained the following error, which CDP believes was resolved with the changes made to End of Day Command Line Batch Processing for ENH-642:
R2: Ensure the new EOD receives the file in the FileReceivePath and writes to the file archive path with the date/time attached. To accommodate the R2 requirement for this enhancement, two new values were added to the EBTCONNECTIONINFO table. For more information, see the database changes for this enhancement. R3: The name of the Expired Benefit File is the value specified in the VALUE column of the ExpiredBenefitsFileName row within the EBTCONNECTIONINFO table of the SPIRIT database. To accommodate the R3 requirement for this enhancement, the existing file naming process continues to run as intended. R4: The new EOD shall archive files that have already been processed. To accommodate the R4 requirement for this enhancement, the new RemovePreviousExpiredBenefits stored procedure was added and distributed with this release of the software. For more information, see the database changes for this enhancement. R5: The release notes should contain the name of any stored procedures used by EOD after these changes have been applied. To accommodate the R5 requirement for this enhancement, the following stored procedures were added and distributed with this release of the software:
For more information, see the database changes for this enhancement. R6: The legacy EOD process shall discontinue the import of the Expired Benefit File. To accommodate the R6 requirement for this enhancement, changes to End of Day Processing for ENH-642 removed Expired Benefits File processing from the End of Day Process in the Scheduled Job Administration application module. With the 2.36.00 release of the SPIRIT WIC system, Expired Benefits File processing now occurs only during End of Day Command Line Batch Processing. R7: All new processes will log information to the scheduled job log in a manner consistent with the original versions, however the order may be different since the job order may change during transition. To accommodate the R7 requirement for this enhancement, information is logged consistently in the SCHEDULEDJOBLOG table of the SPIRIT database. R8: Exceptions shall be logged to the appropriate table. To accommodate the R8 requirement for this enhancement, information is logged consistently in the EXCEPTIONLOG table of the SPIRIT database. R9: The same work shall be done whether the process runs at 11PM or 1AM. To accommodate the R9 requirement for this enhancement, End of Day Command Line Batch Processing will function correctly at any time of the day. R10: Any prerequisite processes for either of these processes shall continue to run ahead of these processes in either legacy or the new EOD. To accommodate the R10 requirement for this enhancement, the prerequisite processes continue to run as intended: Processing in the BatchProcessor occurs in the following order: 1. Sanction Points Service Processing within the BatchProcessor 2. Pending Vendor Disqualifications Service within the BatchProcessor 3. Member Adjustments/Archives/Purges Service Processing within the BatchProcessor 4. Peer Group Reassessment Processing within the BatchProcessor 5. Appointment Reminder Service Processing within the BatchProcessor 6. Reset Probations Service Processing within the BatchProcessor 7. Redemption Processing within the BatchProcessor 8. WIC Activity File Processing within the BatchProcessor 9. Expired Benefits File Processing within the BatchProcessor 10. MAR Calculation Processing within the BatchProcessor
11. Category/Sub-category Processing within the BatchProcessor 12. Authorized Vendor File Processing within the BatchProcessor 13. Approved Product List (APL) Processing within the BatchProcessor 14. WIC Activity Reconciliation Processing within the BatchProcessor 15. Duplicate Participant Service Processing within the BatchProcessor Additionally, the following processing groups occur asynchronously: Group 1: 1. Sanction Points Service Processing within the BatchProcessor 2. Pending Vendor Disqualifications Service within the BatchProcessor Group 2: 1. Member Adjustments/Archives/Purges Service Processing within the BatchProcessor Group 3: 1. Peer Group Reassessment Processing within the BatchProcessor 2. Appointment Reminder Service Processing within the BatchProcessor 3. Reset Probations Service Processing within the BatchProcessor Group 4: 1. Redemption Processing within the BatchProcessor 2. WIC Activity File Processing within the BatchProcessor 3. Expired Benefits File Processing within the BatchProcessor Group 5: 1. MAR Calculation Processing within the BatchProcessor 2. Category/Sub-category Processing within the BatchProcessor 3. Authorized Vendor File Processing within the BatchProcessor Group 6: 1. Approved Product List (APL) Processing within the BatchProcessor 2. WIC Activity Reconciliation Processing within the BatchProcessor Group 7: 1. Duplicate Participant Service Processing within the BatchProcessor
R11: CDP shall document within the release notes what order States/ITOs needs to run existing and new EOD/EOM. To accommodate the R11 requirement for this enhancement, Expired Benefits File processing is included in the End of Day Command Line Batch Processing as part of the new .NET core EOD solution. |
Reported Issues |
|||
Issue# |
Primary Function |
Issue Detail |
Issue Resolution |
CDP-61 |
EBT Transaction History Detail |
WEM removed the first digit "1" from the PLU number, which caused a "UPC Not Found" description to incorrectly display in the UPC Description column within the Transaction Details data grid on the EBT Transaction History Detail screen. |
The SPIRIT WIC system was modified to add the first digit "1" to restore the complete PLU number to populate the correct value(s) in the UPC Description column of the Transaction Details data grid on the following screens:
|
CDP-389 |
EBTCARDSIGNATURE table |
EBT cards were assigned to a household with no corresponding record in the EBTCARDSIGNATURE table. |
The SPIRIT WIC system was modified as follows:
|
CDP-396 |
End of Day Process |
When a split transaction was voided, incorrect PAIDAMOUNTs displayed in various locations throughout the SPIRIT WIC system. |
The InsertFIItemRedeemedAggregated stored procedure in the SPIRIT WIC system was modified to remove the original purchase from the FOODINSTRUMENTITEMREDEEMED_AGGREGATED table for split transactions during End of Day Processing and to display the correct PAIDAMOUNTs in the following locations throughout the SPIRIT WIC system:
For more information, see the database changes for this reported issue. |
CDP-398 |
End of Day Process |
The Redemption Processing within the BatchProcessor timed out during End of Day Command Line Batch Processing. |
The SPIRIT WIC system was modified to add a configurable CommandTimeout setting in the appsettings.json file within the BatchProcessing_Core.zip file to resolve this issue. |
The table below documents changes made to the SPIRIT WIC Detailed Functional Design Document (DFDD) for this release of the software.
|
Documentation Delivery Date: 08/22/2019