Lockbox A Version 2 of the EOD Posting File is known to work with several existing Patient Accounts Receivable. Specifically, this file when used will allow Member Payments to successfully post into Epic. Contact your Implementations Manager for further information.
File Name Standard: <Corporate ID> + <ReportGroupID> + “_” + <ReportGroupName> + “_” + YYYYMMDD + “.txt”
- Date is the processing date of the detail transactions
- Report Group ID and Name are included only if End of Day File Groups are configured
- If End of Day File Groups are not configured, the Merchant ID is returned in the file name between the Corporate ID and date
File Format: Fixed Position, Fixed Width
| Field | Location | Type | Description | Comments |
|---|---|---|---|---|
| Header | ||||
| Record Code | 1 | AN | Constant Value = “H” | |
| Capture Date | 2-9 | DT | YYYYMMDD | Business Date for transactions |
| Lockbox Number | 10-15 | AN | Zero Filled | Last 6 digits of Merchant ID. If EOD Posting File Groups are configured, the Merchant ID is replaced by the Report Group ID. |
| Detail Record | ||||
| Record Code | 1 | AN | Constant Value = “D” | |
| Capture Date | 2-9 | DT – YYYYMMDD | Business date of transaction, same as header | |
| Check Number | 10-19 | NUM | Right Justified/Zero Filled | All zeroes if cash or card |
| Paid Amount | 20-34 | NUM | Right Justified/Zero Filled | |
| Guarantor Account Number | 35-54 | AN | Patient ID from payment form | |
| Payment Source | 55-60 | NUM | Tender/Card Type | |
| Payment Procedure | 61-66 | NUM | Default = “000001” or Transaction Code from payment form | |
| Guarantor Account Number 2 | 67-86 | AN | Patient ID from payment form. Default = Duplicate Value for original Guarantor Account Number field | |
| Trailer Record | ||||
| Record Code | 1 | AN | Constant Value = “T” | |
| Total File Amount | 2-16 | NUM | No Decimal Point | Sum total of all detailed transaction amounts |
| File Total Payment Count | 17-26 | NUM | Sum total of detail transaction count |