Please contact firstname.lastname@example.org for a trial program.
Posted 835 data is stored in sereval tables in the SQL server. Click here for a complete table diagram
The program main screen is shown when the program starts:
Then, set SQL server name and Login method by selecting the "Connecting to a Database" button. A popup window will prompt you for connection parameters:
Previous step merely tells the program where the 835 database is. It may be an existing database you have created and been using for a while. If this will be a new database you have not created, you need to create one by clicking on the "Create a New Database" button.
If you need to delete all the data posted in a database, you can click on "Delete All Data from Database" to clear the database. The database will still exist with all the tables but no data.
This program does not allow you to delete a database from an SQL Server. You need to open SSMS (Microsoft SQL Server Management Studio) to delete the database.
Once a database connection is set up and an 835 database exists on the server, you can start posting HIPAA 835 files to that database. You can post one file at a time, or you can post all the files in a folder.
Selecting "Post One 835 File" tab on main screen to post one file at a time.
Selecting "Batch Posting" tab on main screen to post all files in a folder.
You can do simple query against the data in the database. Selecting "835 Payments" tab on main screen to display query tab. A sample query result is shown below:
Or, you can write your own SQL query against the database.
Please contact us email@example.com for a trial program.