HUD Logo
USA%20Flag  
Site Map         A-Z Index         Text   A   A   A
HUD   >   Program Offices   >   Housing   >   Comp   >   Premiums   >   HUD Reallocation Transactions Layout
Reallocation Transactions Layout

The Reallocation Transactions report file provides information about funds that were reallocated to and/or from a servicing lender's cases. Funds from one case (source case) may be redistributed to up to three cases (target cases) per reallocation transaction. The Reallocation Transactions report file is cumulative and is updated weekly (available every Monday). When the month is ended, another Reallocation Transactions report file is started. The complete Reallocation Transactions report file for the month is available on the 2nd day of the following month. The FHA Connection keeps the latest three Reallocation Transactions report files.
 

Field Name Length Type Start Position Picture Description
Mortgagee ID Alphanumeric  X(5)  Lender on record in HUD's Single Family Monthly Premium Collection System - Periodic (SFPCS-P) as servicing the case when the report file was created. First five digits of the FHA's unique 10-digit identifier assigned to the servicing lender.
From Case FHA Number  10  Alphanumeric  X(10)  Unique 10-digit Federal Housing Administration (FHA) identifier for the source case from which funds were reallocated.
Year  Alphanumeric  16  YYYY Year in which the reallocation transactions were processed (Report Period).
Month Alphanumeric  20 MM  Month in which the reallocation transactions were processed (Report Period).
Reallocation Requested by 40  Alphanumeric  22  X(40) Name of the lender that requested the reallocation transaction. 
Process Date Alphanumeric  62  YYYYMMDD  Date the reallocation transaction was processed.
Reason Code Alphanumeric 70  X(4)  Reason for the reallocation.
R001 Overpayment
R002 Penalty adjustment
R003 Payment remitted for wrong case
R004 Case canceled (not endorsed)
R005 Payment made on sold case
R006 Payment made on non-Periodic case
R007 Other
R008 Invalid case
R009 Terminated case
From Case Loan Number 25  Alphanumeric 74  X(25) Lender-assigned identifier for the source case, if available.
From Case Servicer Name  40  Alphanumeric  99  X(40) Name of the lender that serviced the source case when the reallocation transaction was processed.
From Case Servicer State Alphanumeric 139  X(2)  Geographical location of the servicing lender for the source case.
To Case FHA Number (1)  10  Alphanumeric  141  X(10)  Unique 10-digit FHA identifier for the target case to which funds were reallocated.
To Case Loan Number (1)  25  Alphanumeric  151  X(25)  Lender-assigned identifier for the target case, if available.
To Case Servicer Name (1) 40  Alphanumeric 176  X(40)  Name of the lender that serviced the target case when the reallocation transaction was processed.
To Case Servicer State (1)  Alphanumeric  216  X(2)  Geographical location of the servicing lender for the target case. 
To Amount (1)  11  Numeric  218  9(9)V99  Amount reallocated to the target case.
To Amount Rejected (1)  11  Numeric  229  9(9)V99  Amount that could not be reallocated to the target case.
To Case FHA Number (2)  10  Alphanumeric  240  X(10)  Unique 10-digit FHA identifier for the target case to which funds were reallocated.
To Case Loan Number (2)  25  Alphanumeric  250  X(25)  Lender-assigned identifier for the target case, if available.
To Case Servicer Name (2) 40  Alphanumeric 275  X(40)  Name of the lender that serviced the target case when the reallocation transaction was processed.
To Case Servicer State (2)  Alphanumeric  315  X(2)  Geographical location of the servicing lender for the target case. 
To Amount (2)  11  Numeric  317  9(9)V99  Amount reallocated to the target case.
To Amount Rejected (2)  11  Numeric  328  9(9)V99  Amount that could not be reallocated to the target case.
To Case FHA Number (3)  10  Alphanumeric  339  X(10)  Unique 10-digit FHA identifier for the target case to which funds were reallocated.
To Case Loan Number (3)  25  Alphanumeric  349  X(25)  Lender-assigned identifier for the target case, if available.
To Case Servicer Name (3) 40  Alphanumeric 374  X(40)  Name of the lender that serviced the target case when the reallocation transaction was processed.
To Case Servicer State (3)  Alphanumeric  414  X(2)  Geographical location of the servicing lender for the target case. 
To Amount (3)  11  Numeric  416  9(9)V99  Amount reallocated to the target case.
To Amount Rejected (3)  11  Numeric  427  9(9)V99  Amount that could not be reallocated to the target case.
Comments 80  Alphanumeric  438  X(80)  Remark or detail about the reallocation; required if the reason for the reallocation is Other (R007).

Total Record Length: 517

For the Alternate Report Retrieval process (secure file transfer process), see also Header and Trailer Records.