Health Plan Daily Maintenance Reconciliation Process
Function Description (Current Environment)
This process will run each weekday (Monday through Friday) after the 834 file has been sent to the health plan. This process will retrieve the 997 file from the ETF sFTP server, validate it and then load the contents of it into the ETF reconciliation database.
System Load Report (SLR)
After the 997 file is processed above, a report is generated that displays the results of the daily maintenance process. This report is emailed to specific individuals within ETF and can be viewed on the next page.
Business Requirements (Proposed)
Load 997 Process
This is required to map the accumulator fields in the 997 file into the reconciliation database. Copy an existing 997 Data Junction map and modify it to load into the new health plan reconciliation database.
This is required to automate the map created in the step above. Copy an existing batch process and modify it to create a new SLR process.