Procedure File
It lets you add procedures in Medisoft using input in the form of CSV file.
Note that row 1 is not used. This row can contain column names or a comment.
Key for Type column:
Text = alpha characters (e.g. a, b, c)
Numeric = numbers, whole and fractions e.g. (20.00,-7.50,-4,65)
Date = a YYYYMMDD format or MM/DD/YYYY (e.g. 20020625 or 06/25/2002).
| See notes below | Column# | Data Element | Data Type | Max. Length | Remark |
| ** | 1 | Transaction Code | Text | 99 | |
| ** | 2 | Code Description | Text | 40 | |
| * | 3 | Code Type | Text | 2 | 00=Procedure Insurance 01=Procedure=Unclassified 02=Insurance Payment 03=Patient Payment 04=Adjustment Charge 05=Adjustment Credit 06=Secondary Insurance Payment 08=Insurance Adjustment 09=Tertiary Insurance Payment 10=Partial Primary Insurance Payment 11=Partial Secondary Insurance Payment 12=Partial Tertiary Insurance Payment 13=Insurance Charge Back 14=Inventory 15=Refund 16=Sales Tax 17=Sales Tax Payment |
| * | 4 | Payment Type | Text | 2 | 0=Check 1=Cash 2=Credit Card |
Note:
* field improves quality of imported data, but can be left empty
** field requires a value