EOD Posting File LockBox H

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.

FIELDDESCRIPTIONSIZECOLSVALUE/FORMAT
1Record Type21-2"00" = Header record, one per file
2Agency Code63-8Agency Code (PNPP)
3Agency Fee109-18Right justified/zero filled No decimal (two places assumed) 000000000
4Total Number of Payments619-24Right justified/zero filled (bank completes)
5Total Payment Amts1025-34Right justified/zero filled (bank completes)
6Patient Payment Transaction Code535-39P0006 - Hard coded (cash)
P0001 - Hard coded (check)
7Total Number of Adjust640-45Right justified/zero filled N/A
8Total Adjustment Amt1046-55Right justified/zero filled.  No decimal (two places assumed) N/A
9Patient Adjustment Code556-60A0138
10Filler19061-250Spaces
FIELDDESCRIPTIONSIZECOLSVALUE/FORMAT
1Record Type21-2"01" = Transaction record, one or more per file
2Patient Account Number103-12Right justified/zero filled
3Facility Indicator113Upper case A - city M - Mainland
4Patient Last Name1514-28Left justified/upper case
5Patient First Name1229-40Left justified/upper case
6Patient Middle Initial141Upper case M
7Transaction Type142"P" - Payment
8Date Paid643-48MMDDYY
9Payment Amount Ind149"0" Postive "-" Negative
10Payment Amount1050-59Right justified/zero filled. No decimal (two places assumed).
11Payment Type160"A" Check  "C" Credit Card
12Credit Card or Bank Acct Owner Name4061-100If 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.
13Credit card Type25101-125If Field 11="C", this is the type of credit card.  Left justified. (ex. American Express, Discover, Visa, Mastercard) 
14Credit Card or Bank Acct Number (last 4 digits)4If Field 11  "C", this is the last four digits of the credit card.  "A", this is the last four digits of the bank account
15Confirmation Code30If Field 11 = "C" or "A", this is the payment confirmation message
16Filler91Spaces