Refund Transactions Layout

The Refund Transactions report file provides information about refunds for your FHA cases that were created or had a change in status during the current month. The file is updated weekly (available each Monday) with new statuses and newly initiated refunds. The complete Refund Transactions report file for the month is available on the 2nd day of the following month. Refunds with no change in status during the month are not included in the file. Any refund that goes to a returned or canceled status will be added to a later report when the status change occurs.

Field Name

Length

Type

Start Position

Picture

Description

Mortgagee ID5Alphanumeric1X(5)First five digits of the FHA's unique 10-digit identifier assigned to the servicing lender that requested the refund.
Refund Request Number10Alphanumeric6X(10)Ten-digit identifier assigned to the group of case numbers included in this refund request (mortgagee requested refunds can have 10 cases maximum; system-generated refunds for invalid cases can have 500 cases maximum).
Period6Alphanumeric16YYYYMMThe month/year of the refund transaction file.
Mortgagee Name40Alphanumeric22X(40)Name of the lender that requested the refund.
Status Date8Alphanumeric62YYYYMMDDDate of the last action taken for the refund request (e.g., created, authorized, etc.); relates to the refund Status
Request Status Code4Alphanumeric70X(4)

Status code of the request.

CRTECreated by online process
AUTHAuthorized by online process
DISBDisbursed
CONFConfirming issuance by Treasury
RETNReturned/Canceled check to HUD
REJPRejected, did not pass edits
REJTRejected, did not pass edits after overnight processing
Reason Code4Alphanumeric74X(4)

Code representing the reason the refund request was created.

R001Overpayment
R002Late/Interest Adjustment
R003Payment remitted for wrong case
R004Case canceled (not endorsed)
R005Payment made on sold case
R006Payment made on non Periodic or invalid case
R007Other
FHA Case Number10Alphanumeric78X(10)Unique 10-digit identifier assigned to the FHA loan by HUD. The first two positions identify the state where the property is located, the third position identifies the HUD Field Office territory in which the property is located, the next six positions identify the serial number, and the final position is the check digit.
Loan Number25Alphanumeric88X(25)Number assigned to the mortgage loan by the lender. Note: This number must be sent monthly with the monthly premium payment for the case in order for it to be displayed here.
Case Refund Amount Sign1Alphanumeric113X(1)Positive or Negative indicator ("+" or "-") for refund amount.
Note: A negative amount may indicate a returned or canceled refund check.
Case Refund Amount11Numeric1149(9)V99Requested refund amount for specified case.
Case Reject Amount Sign1Alphanumeric125X(1)Positive or Negative indicator ("+" or "-") for reject amount.
Case Reject Amount11Numeric1269(9)V99Rejected refund amount for specified case.

Total Record Length: 136

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