Lockbox Version F 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: <Account/Group/Outlet> + “_” + <Configurable Field> + “_” + <BusinessDate> + “.txt”
- Date is the processing date of the detail transactions
- File can be generated by Account, End of Day File Group or Outlet
- The Configurable Field in the file name is optional and is blank by default
File Format: Fixed Position, Fixed Width, no Header record
Note: String values that are longer than the maximum column size are truncated. For example, the value “SMITH” in a four-character column is truncated to “SMIT.” This behavior applies to monetary amounts as well.
| Field | Location | Type | Description | Comments |
|---|---|---|---|---|
| Detail Record | ||||
| Record Type (F1) | 1-2 | AN | Constant Value = "P1". | |
| Medical Record Number | 3-22 | AN | Left Justified/Space Filled | Required Source: MRN field on payment form. |
| Transaction Date | 23-30 | DT | Left Justified/Space Filled | Date transaction is processed: YYYYMMDD. |
| Payment Amount | 31-40 | NUM | Right Justified/Space Filled No Decimal Point | |
| Guar Medical Record Number | 41-60 | AN | Left Justified/Space Filled | Additional Info 6. |
| Check Number | 61-75 | AN | Right Justified/Space Filled | Payment Method: "CREDITCARD," "ECHECK," "MANUAL" or "CASH" Check number is appended when applicable Ensure field has "MANUAL" and check number for Manual checks." |
| BAR Group Number | 76-80 | AN | Right Justified/Zero Filled | Optional if only 1 group is in scope. Source: Transaction Code field on payment form. |
| Additional Information | 81-100 | AN | Left Justified/Space Filled | Optional Source: Additional Info 2 field on payment form. |
| Patient First Name | 101-120 | AN | Left Justified/Space Filled | Optional. |
| Patient Last Name | 121-140 | AN | Left Justified/Space Filled | Optional. |
| Invoice Number | 141-160 | AN | Left Justified/Space Filled | Optional Source: Additional Info 1 or Invoice Number field on payment form. |
| Transaction ID | 161-192 | AN | Left Justified/Space Filled | Transaction ID. |
| MST | 193-223 | AN | Left Justified/Space Filled | Outlet ID. |
| Billing Area | 224-233 | AN | Left Justified/Zero Filled | Additional Info 3. |
| Location | 234-243 | AN | Left Justified/Zero Filed | Additional Info 4. |
| Provider | 244-253 | AN | Left Justified/Zero Filled | Additional Info 5. |
| Trailer Record | ||||
| Record Type (T1) | 1-2 | AN | "T1" Constant | One per file. |
| Number of payments | 3-12 | NUM | Right Justified/Zero Filled | Count of P1 records. |
| Total Payments | 13-22 | NUM | Right Justified/Zero Filled | Sum of payment amounts of all P1 records. Decimal point is assumed. |
| Total Records | 23-32 | NUM | Right Justified/Zero Filled | Count of all P1 and T1 records. |