Creating the Image Index Table

Top  Previous  Next

To create the table for the image index, follow the instructions below.

1.Select Image arrow Create Image Index Table in the main menu.
The "Create Image Index Table" menu
2.The following window will appear.
The "Create Image Index Table" window
3.Select one of the necessary options:
Microsoft SQL Server

4. Then make sure the image index table script is correct.

The "Create Image Index Table" window with the "Microsoft SQL Server" option selected

The "Create Image Index Table" window with the "MySQL/Generic" option selected

5. Click on the "Execute Script" button.
The "Execute Script" button

Then you will receive a notification like this. Click "OK."

The success message

6. Then click "Save."



You can use the following MySQL/SQL script:


CREATE TABLE `edi_835imageindex` (


 `EDIFilename` varchar(100) DEFAULT NULL,

 `ImageFilename` varchar(100) DEFAULT NULL,

 `ClaimNo` varchar(35) DEFAULT NULL,

 `TradingPartnerID` char(15) DEFAULT NULL,

 `PayDate` date DEFAULT NULL,

 `PayorID` varchar(25) DEFAULT NULL,

 `PayorName` varchar(60) DEFAULT NULL,

 `PayeeID` varchar(25) DEFAULT NULL,

 `PayeeLast` varchar(60) DEFAULT NULL,

 `SubscriberID` varchar(15) DEFAULT NULL,

 `SubscriberLast` varchar(60) DEFAULT NULL,

 `SubscriberFirst` varchar(35) DEFAULT NULL,

 `PatientID` varchar(15) DEFAULT NULL,

 `PatientLast` varchar(60) DEFAULT NULL,

 `PatientFirst` varchar(35) DEFAULT NULL,

 `AmountCharged` decimal(10,2) DEFAULT NULL,

 `AmountPaid` decimal(10,2) DEFAULT NULL,

 `ServiceDateFrom` date DEFAULT NULL,

 `ServiceDateTo` date DEFAULT NULL,





Tip: Make sure you use a correct symbol ` and not ' in the script.


Tip: If you encounter errors running the script on MySQL or other database systems, then modify it until it works or consult with your database administrator to make the modifications. SQL Scripts share over all platforms a lot of syntax, but still each flavor demands its own adjustments.