1 / 34

California Department of Health Services

teal
Download Presentation

California Department of Health Services

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

    1. California Department of Health Services Office of HIPAA Compliance 820 Process Documentation

    2. Pervasive 820 Process for Ca DHS

    3. Load Files Step This process step runs a sub-process which loads the CD102 file and the CMS84 file for the current month. The load process is completely controlled by the following commands in the process: FileList("C:\T820_In\CD102*.csv", Fary1) FileList("C:\T820_In\820*.csv", Fary2) All CD102 files are stored and named to "C:\T820_In\CD102*.csv", while the CMS64 files are named "C:\T820_In\820*.csv“.

    4. Load Files Step

    5. Load Files Step Subprocess Clear Table step This process step Moves the CD102 ( named TBL_Checklist ) data to an archive and empties the current table. This process step Moves the CMS64 ( named TBL_Checklist ) data to an archive and empties the current table.

    6. Load Files Step Subprocess Get Filelist step The load process is completely controlled by the following two filelist commands : FileList("C:\T820_In\CD102*.csv", Fary1) FileList("C:\T820_In\820*.csv", Fary2)

    7. Load Files Step Subprocess EOA for CD102 step This process step controls the looping through the filelist array to load the CD102 files

    8. Load Files Step Subprocess Load Checklist step This process step the CD102 Data file to the TBL.Checklist table.

    9. Load Files Step Subprocess Add 1 to Fndx1 step This process step increments the counter index for the filelist array.

    10. Load Files Step Subprocess LogMessage step Logging a message to the Log if there is a file to process. if Fndx2 <= Fmax2 Then LogMessage("info", "Processing : " & rootdir & Fary2(Fndx2) ) End if

    11. Load Files Step Subprocess EOA for CMS64 step This process step controls the looping through the filelist array to load the CMS64 files

    12. Load Files Step Subprocess Clear Table step This process step the CMS64 Data file to the TBL.Checklist table.

    13. Load Files Step Subprocess Add 1 to Fndx1_2 step This process step increments the counter index for the filelist array.

    14. Load Files Step Subprocess Add 1 to Fndx1_2 step This process step starts a stored procedure to assign Check numbers.

    15. Sleeper Process Step This process step sleeps until all vendors have a Check number in the CMS64 table Please review these two links and ensure every record listed has a valid check number or “0” in the check number field. Note the zero tells the system to ignore the record for processing on the 820

    16. Sleeper Step

    17. First Check for Missing Check #’s Step This process step examines the table to see if there are any null values in the check number field.

    18. Bad Vendor Check Step This process step decides if there are Vendor’s without check numbers.

    19. Send Email Sub Process Step This process step write the missing check number report.

    20. Sleeper Process Step This process step sleeps for 30 minutes.

    21. Sleeper Process Step This process step decides if there are Vendor’s without check numbers.

    22. Second Check for Missing Check #’s Step This process step examines the table to see if there are any null values in the check number field.

    23. Send EMail Step This process step currently writes an HTML report to the CaDHS website. It is suggested once connectivity is available to the mailserver to set up a send mail step to EDIADMIN mailbox.

    24. Send EMail Step

    25. Missing Check Number Report Step This process step builds an HTML report at : http://dhsohc834/Ca_DHS/Vendors_WithMissingCheckNumbers.html

    26. Send Mail Step This process step would use the SENDMAIL function to send an Email to EDIADMIN mailbox with the html attached from : http://dhsohc834/Ca_DHS/Vendors_WithMissingCheckNumbers.html

    27. Build 820 Process Step This step build 820 files for each vendor who has a non-zero and non-null value in the Check Number field.

    28. FTP files to EDS Step This step builds FTP scripts using the TP FTP Parms table. It then runs them all. Lastly it archives the Source files.

    29. FTP files to EDS Step

    30. FTP Build Scripts Step This step builds FTP scripts using the TP FTP Parms table.

    31. Run FTP Scripts Step This step executes a batch file that fires off all of generated scripts Please note on the Test system this step is disabled due to connectivity issues.

    32. Archive Source Files Step Lastly, this step archives the Source files.

More Related