Lockbox Version I v1 of the EOD Posting File is known to work with several existing Patient Accounts Receivable systems. Contact your Implementations Manager for further information.
File Name Standard: Report Configuration ID | Report File Configuration ID | Account ID + _ + <ConfigurableValue> + “_” + CCYYMMDD + “.txt”
- File can be generated by Account, End of Day File Group or Outlet.
File Format: Fixed Position, Fixed Width
No Header Record
| Field | Location | Type | Description | Comments |
|---|---|---|---|---|
| Detail Record | ||||
| Account Number | 1-12 | AN | Left Justified/Zero Filled | Patient Account Number. |
| Patient Name | 13-24 | AN | Left Justified/Space Filled | Patient Last Name + ", " + Patient First Name No "," if only have last name. If have first name only, will put "," without last name (", name")." |
| OCR Scan Line | 25-78 | AN | Space filled | Empty String, not used. |
| Statement Date | 79-86 | DT | Today's Date, not Business Date (mmddccyy). | |
| COID | 87-91 | NUM | Zero filled | Zero Filled String. |
| Practice/Facility ID | 92-96 | AN | Left Justified/Zero Filled | Additional Info 1. |
| Payment Date | 97-104 | DT | Business Date of Transaction. | |
| Payment Type | 105 | NUM | 0 = Default 1 = eCheck Transaction 2 = Credit Card Transaction 3 = Manual Check." |
|
| Credit Card Type | 106 | NUM | 0 = Default 1 = American Express 2 = Visa 3 = Discover. | |
| Check Number | 107-116 | NUM | Left Justified/Zero Filled | Check number if present |
| Paid Amount | 117-127 | NUM | Left Justified/Zero Filled | Absolute value of payment, implied decimal. |
| Balance Due | 128-138 | NUM | Zero Filled | Zero Filled String. |
| Trailer Record | ||||
| Record ID | 1/2/2016 | AN | "99". | |
| Total Patient Records | 3-12 | NUM | Left Justified/Zero Filled | Total Transactions in the file (count). |
| Total Check Payments | 13-23 | NUM | Left Justified/Zero Filled | Total Check Sale Amount - Check Refund Amount Monetary Value, not a count of how many transactions Implied Decimal. |
| Total Credit Payments | 24-34 | NUM | Left Justified/Zero Filled | Total Credit Card Sale Amount - Credit Card Refund Amount. Monetary Value, not a count of how many transactions. Implied Decimal. |
| Total Cash Payments | 35-45 | NUM | Left Justified/Zero Filled | Total Cash Sale Amount - Cash Refund Amount. Monetary Value, not a count of how many transactions Implied Decimal. |
| Total Sum of All Payments | 46-56 | NUM | Left Justified/Zero Filled | Total Sale Amount - Total Refund Amount. Monetary Value, not a count of how many transactions. Implied Decimal. |
| Filter | 57-138 | AN | Space Filled | Empty String. |