Lockbox Version H of the EOD Posting File is known to work with several existing Patient Accounts Receivable systems. Contact your Implementations Manager for further information.
File Details
- File naming convention: YYYYMMDD_REPORTID_DPA.pmt
- Date is the processing date of the detail transactions
- File can be generated by Account, End of Day File Group or Outlet
NOTE: String values 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 | DESCRIPTION | SIZE | COLS | VALUE/FORMAT |
|---|---|---|---|---|
| 1 | Record Type | 2 | 1-2 | "00" = Header record, one per file |
| 2 | Agency Code | 6 | 3-8 | Agency Code (PNPP) |
| 3 | Agency Fee | 10 | 9-18 | Right justified/zero filled No decimal (two places assumed) 000000000 |
| 4 | Total Number of Payments | 6 | 19-24 | Right justified/zero filled (bank completes) |
| 5 | Total Payment Amts | 10 | 25-34 | Right justified/zero filled (bank completes) |
| 6 | Patient Payment Transaction Code | 5 | 35-39 | P0006 - Hard coded (cash) P0001 - Hard coded (check) |
| 7 | Total Number of Adjust | 6 | 40-45 | Right justified/zero filled N/A |
| 8 | Total Adjustment Amt | 10 | 46-55 | Right justified/zero filled. No decimal (two places assumed) N/A |
| 9 | Patient Adjustment Code | 5 | 56-60 | A0138 |
| 10 | Filler | 190 | 61-250 | Spaces |
| FIELD | DESCRIPTION | SIZE | COLS | VALUE/FORMAT |
|---|---|---|---|---|
| 1 | Record Type | 2 | 1-2 | "01" = Transaction record, one or more per file |
| 2 | Patient Account Number | 10 | 3-12 | Right justified/zero filled |
| 3 | Facility Indicator | 1 | 13 | Upper case A - city M - Mainland |
| 4 | Patient Last Name | 15 | 14-28 | Left justified/upper case |
| 5 | Patient First Name | 12 | 29-40 | Left justified/upper case |
| 6 | Patient Middle Initial | 1 | 41 | Upper case M |
| 7 | Transaction Type | 1 | 42 | "P" - Payment |
| 8 | Date Paid | 6 | 43-48 | MMDDYY |
| 9 | Payment Amount Ind | 1 | 49 | "0" Postive "-" Negative |
| 10 | Payment Amount | 10 | 50-59 | Right justified/zero filled. No decimal (two places assumed). |
| 11 | Payment Type | 1 | 60 | "A" Check "C" Credit Card |
| 12 | Credit Card or Bank Acct Owner Name | 40 | 61-100 | If Field 11="C" this is Credit Card Owners name. "A" this is bank account owner's name. Left justified For testing want to use spaces to see what happens; may need to zero fill. |
| 13 | Credit card Type | 25 | 101-125 | If Field 11="C", this is the type of credit card. Left justified. (ex. American Express, Discover, Visa, Mastercard) |
| 14 | Credit Card or Bank Acct Number (last 4 digits) | 4 | If Field 11 "C", this is the last four digits of the credit card. "A", this is the last four digits of the bank account | |
| 15 | Confirmation Code | 30 | If Field 11 = "C" or "A", this is the payment confirmation message | |
| 16 | Filler | 91 | Spaces |