Lockbox Version C of the EOD Posting File is known to work with several existing Patient Accounts Receivable systems. The header record of this format includes an identifier for EOD Posting File Groups. Contact your Implementations Manager for further information.
File Name Standard: <BusinessDate> + <Account/Group/Outlet> + “.pmt”
- File can be generated by Account, End of Day File Group or Outlet.
File Format: Fixed Position, Fixed Width
| Field | Location | Type | Description | Comments |
|---|---|---|---|---|
| Header | ||||
| Account Identifier | 3-8 | AN | Right Justified/Space Filled | InstaMed EMC ID. |
| Group Identifier | 9-18 | AN | Right Justified/Zero Filled (space filled if empty) | EOD Posting File Group Name. |
| Total Number of Payments | 19-24 | NUM | Right Justified/Zero Filled | Refunds included in count. |
| Total Payment Amounts | 25-34 | NUM | Right Justified/Zero Filled No Decimal Point | Total Amount = Total Sale Amount - Total Refund Amount. |
| Patient Payment Transaction Code | 35-39 | AN | "P0000" or P. | |
| Total Number of Adjustments | 40-45 | NUM | All Zeros. | |
| Total Adjustment Amount | 46-55 | NUM | All Zeros. | |
| Patient Adjustment transaction Code | 56-60 | AN | All Spaces. | |
| Filler | 61-250 | AN | All Spaces. | |
| Transaction Record | ||||
| Record Type | 1-2 | AN | Constant Value = "01". | |
| Patient Account Number | 3-12 | AN | Right Justified/Zero Filled | If PatientID is greater than 10 characters, map the first 10 characters. |
| Facility Indicator | 13 | AN | Upper Case/Blank Filled | Prefix for Patient Account Number. |
| Patient last Name | 14-28 | AN | Right Justified/Space Filled | |
| Patient First Name | 29-40 | AN | Right Justified/Space Filled | |
| Patient Middle Initial | 41 | AN | Right Justified/Space Filled | |
| Transaction Type | 42 | AN | "P" = Payment, "A" = Adjustment. | |
| Date Paid | 43-48 | DT | YYMMDD | Business date of transaction |
| Payment Amount Indicator | 49 | AN | "0" for payments, "-" for adjustments. | |
| Payment Amount | 50-59 | NUM | Right Justified/Zero Filled No Decimal Point | 2 places assumed. |
| Payment Type | 60 | AN | "C" = Credit Card , "A" = all other payment methods (e.g., check or cash). | |
| Credit Card or Bank Account Owner Name | 61-100 | AN | Right Justified/Space Filled | Cardholder Name if Payment Type = "C," otherwise Bank Account Holder Name if available. |
| Credit Card Type | 101-125 | AN | Right Justified/Space Filled | "AMEX," "VISA," "MASTERCARD," "DISCOVER" or "OTHER" when applicable. |
| Account Number | 126-129 | NUM | Right Justified/Space Filled | Last 4 digits of card if Payment Type = "C," otherwise last four digits of bank account, if applicable. |
| Confirmation Code | 130-159 | AN | Right Justified/Zero Filled | Authorization Number if Payment Type = "C". |
| Transaction ID | 160-191 | AN | 32-character InstaMed Platform ID. | |
| Filler | 192-250 | AN | Space Filled | Blank. |