Overflow in MAT Numeric Fields

1
Overflow in MAT Numeric Fields

• The Problem and a Proposed Solution
• Jed Graef
• IPM-Software

2
The Problem

• MAT fields for Incomes, Assets, and Asset Incomes
  are limited to 6 digits.
• The fields that hold the totals for these
  financial items are also limited to 6 digits.
• Certifications are starting to appear with asset
  totals greater than 6 digits.

3
Problem (Continued)

• Assets of 1,000,000 or greater can not be
  entered as a single asset record.
• Any asset total of 1,000,000 or greater can not
  be transmitted in a MAT file.
• These issues cause certifications to generate
  errors from TRACS or CA software.

4
Proposed Solution

• For data entry, split incomes and assets into
  multiple records whose total is the correct
  amount.
• A house with a value of 1,500,000 could be
  entered as three MAT10 Section 5 records at
  500,000 each, for example.

5
Solution (Continued)

• Vendors may either
• Tell users to split the asset manually
• Have users enter the correct asset total and
  automatically split the asset when creating the
  MAT10, Section 5 records.
• The recommended way to split the asset is in
  999,999 pieces with the last record holding the
  remainder necessary for the correct total.

6
Solution (Continued)

• Fill any totals field that is 1,000,000 or more
  with 9s (999,999) in the MAT file.
• Do all certification calculations with the
  correct total amounts no matter what the value.
  This ensures that TTP and assistance are
  calculated correctly.
• Print the correct totals on the 50059. Do not
  enter 6 9s in a total field.

7
CA Processing

• Process the cert using correct totals and do not
  issue discrepancies for totals of all 9s in the
  MAT file.
• Ignore TRACS errors related to the above issues.
  These will be level 1 calculation discrepancies.
  Pay on such certs.

8
TRACS Processing

• Short Term
• Implement the same model as for CAs.
• If this is not possible, suppress level 1 errors
  associated with fields filled with all 9s where
  the TRACS calculated total is gt 1,000,000.
• Long Term
• With TRACS 202C, make the appropriate fields
  larger to eliminate the issue once and for all.

9
Applicable MAT Field

• 29Total Assets

10
202C Fields

• 30Total Income from Assets
• 32Imputed Income from Assets
• 33-36Total Incomes
• 37Non Asset Income
• 38Asset Income
• 39Annual Income Amount
• 56Adjusted Income Amount