Lockbox Version E 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> + “_” + <Business Date> + “.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: Pipe Delimited, no Header or Trailer records
| Field # | Field Name | Format | Required? | Min | Max | Comment |
|---|---|---|---|---|---|---|
| 1 | Transaction ID | AN | Y | 3 | 3 | Constant Value = "GPT". |
| 2 | Event ID | AN | Y | 3 | 3 | Constant Value = "PMT". |
| 3 | Batch Close ID | AN | Y | 5 | 5 | Constant Value = "False". |
| 4 | Batched Ind | AN | Y | 4 | 4 | Constant Value = "True". |
| 5 | Sending Application | AN | Y | 11 | 11 | Varies by version, contact implementation manager Version E.1 = "US Bank PN". |
| 6 | Account ID | AN | Y | 4 | 12 | Patient ID from payment form Billing = 4 Characters Encounter = 12 Characters." |
| 7 | Account ID Type Code | NUM | Y | 1 | 1 | Billing = "1" Encounter = "2". |
| 8 | External Transaction ID | AN | Y | 32 | 32 | Unique Transaction ID. |
| 9 | Effective Date | DT | Y | 8 | 8 | Business date of transaction (CCYYMMDD). |
| 10 | External Transaction Type | NUM | Y | 1 | 1 | Payment = "5" Adjustment = "6". |
| 11 | Master Financials Transaction ID | AN | Y | 3 | 3 | Billing = "100" Encounter = "104". |
| 12 | Amount Extended | NUM | Y | Payment transaction amount is a negative number, adjustment transaction amount is a positive number and decimal point is assumed (e.g., 1.00 is output as 100). No leading zeros. | ||
| 13 | Tracking Text | AN | O | 0 | 0 | Blank. |
| 14 | Check Name | AN | O | 1 | 101 | Check Account Holder Name. |
| 15 | Check Number | AN | O | 1 | 50 | Check Number. |
| 16 | Credit Card Expiration Date | DT | O | 8 | 8 | Expiration date on credit card —CCYYMMDD. |
| 17 | Credit Card Holder Name | AN | O | 1 | 121 | Card Holder Name. |
| 18 | Credit Card Number | NUM | O | 1 | 4 | Last 4 digits of credit card number. |