EOD Posting File Lockbox C v2

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 + (ReportGroupID, MST or Account) + .pmt

  • File can be generated by Account, End of Day File Group or Outlet.

File Format: Fixed Position, Fixed Width

FieldLocationTypeDescriptionComments
Header
Record Type1-2AN"00" = Header Record, one per file.
Account Identifier3-8ANRight Justified/Space FilledInstaMed EMC ID.
Group Identifier9-18ANRight Justified/Zero Filled (Space filled if empty)EOD Posting File Group Name.
Total Number of Payments19-24NUMRight Justified/Zero FilledRefunds included in count.
Total Payment Amounts25-34NUMRight Justified/Zero Filled/No DecimalTotal Amount = Total Sale Amount - Total Refund Amount.
Patient Payment Transaction Code35-39AN"P0000" or P.
Total Number of Adjustments40-45NUMAll Zeroes.
Total Adjustment Amount46-55NUMAll Zeroes.
Patient Adjustment Transaction Code56-60ANAll Spaces.
Filler61-250ANAll Spaces.
Transaction Record
Record Type1-2AN"01" = Transaction Record , one or more per file.
Patient Account Number3-12ANRight Justified/Zero FilledSee explanation below.
Facility Indicator13ANUpper Case/Blank FilledThe first alpha, non-numeric character that was removed from the Patient Account Number or else leave blank.
Patient Last Name14-28ANRight Justified/Space Filled
Patient First Name29-40ANRight Justified/Space Filled
Patient Middle Initial41ANRight Justified/Space Filled
Transaction Type42AN"P" = Payment, "A" = Adjustment.
Date Paid43-48DTYYMMDDBusiness Date of transaction.
Payment Amount Indicator49AN"0" for payments, "-" for adjustments.
Payment Amount50-59NUMRight Justified/Zero Filled/No DecimalTwo places assumed.
Payment Type60AN"C" = Credit Card , "A" = Cash , "K" = Check (Manual & eCheck).
Credit Card or Bank Account Owner Name61-100ANRight Justified/Space FilledCardholder Name if Payment Type = "C", otherwise Bank Account Holder Name if available.
Credit Card Type101-125ANRight Justified/Space Filled"Amex," "Visa," "MC," "Disc," or "Other" when applicable.
Account Number126-129NUMRight Justified/Space FilledLast 4 digits of card if Payment Type = "C", otherwise last 4 digits of bank account if applicable.
Confirmation Code130-159ANRight Justified/Zero FilledAuthorization Number if Payment Type = "C".
Filler192-250ANAll Spaces.

Clarification of Patient Account Number:

  1. Alpha first character, greater than ten digits (g., A1234567890)
    1. Patient ID: 1234567890
    2. Facility Indicator: A
  1. Alpha first character, equal to ten digits (g., A123456789)
    1. Patient ID: 0123456789
    2. Facility Indicator: A
  1. Alpha first character, less than ten digits (g., A12345678)
    1. Patient ID: 0012345678
    2. Facility Indicator: A
  1. Non-alpha first character, greater than ten digits (g., 12345678901)
    1. Patient ID: 1234567890
    2. Facility Indicator: ” “
  1. Non-alpha first character, equal to ten digits (g., 1234567890)
    1. Patient ID: 1234567890
    2. Facility Indicator: ” “
  1. Non-alpha first character, less than ten digits (g., 12345678)
    1. Patient ID: 0012345678
    2. Facility Indicator: ” “
  2. OR
    1. If first character is alpha, remove and place in facility indicator. If remaining Patient ID is less than ten characters, pad left with zeroes.  If remaining Patient ID is greater than eleven characters, truncate the last characters on the Patient ID.  If Patient ID is ten characters, use the whole Patient ID.
    2. If the first character is numeric, do nothing with that character and leave the facility indicator blank. If the Patient ID is greater than ten characters, truncate the last characters on the Patient ID.  If the Patient ID is ten characters, use that Patient ID.  If the Patient ID is less than ten characters, pad the Patient ID with zeros to the left.