Batch File Format for Payment of Monthly (Periodic) Mortgage Insurance Premium (Old Format)

The batch file format described below is used to transmit to HUD (CPU to CPU) Single Family monthly (periodic) mortgage insurance premium payments. Collection processing of the transmitted payment is performed by Pay.gov.

This is an older format that was formerly used by some lenders and service bureaus to transmit their files to Mellon Bank. It is referred to as the Old Format. Of the two available formats (Old Format and New Format), the Old Format is more complex and is NOT recommended unless the lender used the Old Format in the past to transmit batch files to Mellon Bank. For information regarding the New Format, see Batch File Format for Payment of Monthly (Periodic) Mortgage Insurance Premium (New Format).

The batch file must include the following records, in this order:

The file can have only one Header Record, Deposit Control Record, and Deposit Total Record. The file can contain multiple Detail and Supplemental Records (Type 4). See Supplemental Record Type 04-01 for more details. For information on batch file naming conventions, see Periodic Mortgage Insurance Premium Batch Payment Processing Instructions for CPU to CPU Transmissions.

Field NamePositionLengthTypeFormatDescription
Record Type11Numeric9(1)This field must always have the value 1.
Filler2-32Numeric9(2)Zero (0) fill.
Filler4-1310AlphanumericX(10)Blank fill.
Filler14-185Numeric9(5)Zero (0) fill.
Company
Number
19-235Numeric9(5)Number identifying the
Periodic file format. This field must always have the value 00502.
Transmission Date24-296NumericYYMMDDEstimated date the file is transmitted.
Transmission Time30-334NumericHHMMEstimated time the file is transmitted (Eastern Time).
Override Duplicate341AlphanumericX(1)

Options for handling duplicate case payments per day:

  • Blank space: System rejects duplicate dollar amounts for a Mortgagee ID within the same day and duplicate files within the past 10 days.
  • U: System permits duplicate dollar amounts for a Mortgagee ID within the same day but rejects duplicate files within the past 10 days.
  • C: System rejects duplicate dollar amounts for a Mortgagee ID within the same day but permits duplicate files within the past 10 days.
  • B: System permits duplicate payment.
Filler35-4410AlphanumericX(10)Blank fill.
Periodic Format Indicator451AlphanumericX(1)Blank space identifying the old CPU input format.
Filler46-8035AlphanumericX(35)Blank fill.

Detail Record (Mortgagee/Lender Header)

Field NamePositionLengthTypeFormatDescription
Record Type11Numeric9(1)This field must always have the value 6.
Filler2-98Numeric9(8)Zero (0) fill.
Mortgagee/ Lender ID Number10-145Numeric9(5)Five-digit (corporate) FHA Title II identifier assigned to the lending institution making the payment.

Right justify and zero (0) fill.
Total Transaction Amount15-2410Numeric9(8)V99Sum of the payment Dollar Amount for each FHA Case Number included in the Detail and Supplemental Records.

Right justify and zero (0) fill.
Supplemental Indicator251AlphanumericX(1)This field must always have the value S.
Filler26-305Numeric9(5)Zero (0) fill.
FHA Case Number31-4010Numeric9(10)Unique 10-digit identifier assigned by the FHA to the mortgage loan for which monthly premium is being paid.

Right justify and zero (0) fill.
Filler41-488Numeric9(8)Zero (0) fill.
Dollar Amount49-557Numeric9(5)V99Total amount of payment, including late and interest charges if applicable, for the specified FHA Case Number.

Right justify and zero (0) fill.
Loan Number56-7015AlphanumericX(15)(Optional) First 15 characters of the identifier assigned by the lender to the mortgage loan associated with the FHA Case Number; otherwise, blank fill. If a Loan Number is provided, it is included in Monthly Premium report files, e.g., Billing and Reconciliation files.
Effective Date71-766NumericMMDDYYThis field is not currently applicable and can be zero (0) filled.
Filler77-804AlphanumericX(4)Blank fill.

Supplemental Record Type 4-01

The Supplemental Record Type 4 has four subtypes (01 through 04) that are repeated in sequence (01, 02, 03, 04) until all supplemental load data has been incorporated. As they are repeated, the actual sequence numbers (Sequence Number of Overflow) increment by one. For example, the second series of these four records would be sequence numbers 05, 06, 07, 08; and the third series would increment to 09, 10, 11, 12; etc. If the sequence number exceeds 99, restart the series at 01. The last Supplemental Record Type 4 (subtype 01, 02, 03, or 04) is indicated by placing the value 9 in the Last Record Indicator field.

Field NamePositionLengthTypeFormatDescription
Record Type11Numeric9(1)This field must always have the value 4.
Sequence Number of Overflow2-32Numeric9(2)Start at the value 01 and increment on each succeeding Supplemental Record. If sequence number is greater than 99, restart the series at the value 01.
Last Record Indicator41Numeric9(1)If this is the last record for this lender, this field must have the value 9; otherwise, zero (0) fill.
Loan Number (continued)5-1410AlphanumericX(10)(Optional) If needed, continuation of the identifier assigned by the lender to the mortgage loan associated with the FHA Case Number; otherwise, blank fill.
Filler15-195AlphanumericX(5)Blank fill.
Filler20-245Numeric9(5)Zero (0) fill.
FHA Case Number25-3410Numeric9(10)Unique 10-digit identifier assigned by the FHA to the mortgage loan for which monthly premium is being paid.

Right justify and zero (0) fill.
Filler35-428Numeric9(8)Zero (0) fill.
Dollar Amount43-497Numeric9(5)V99Total amount of payment, including late and interest charges if applicable, for the specified FHA Case Number.

Right justify and zero (0) fill.
Loan Number50-6415AlphanumericX(15)Optional) First 15 characters of the identifier assigned by the lender to the mortgage loan associated with the FHA Case Number; otherwise, blank fill. If a Loan Number is provided, it is included in Monthly Premium report files, e.g., Billing and Reconciliation files.
Loan Number (continued)65-7410AlphanumericX(10)(Optional) If needed, continuation of the identifier assigned by the lender to the mortgage loan associated with the FHA Case Number; otherwise, blank fill.
Filler75-806AlphanumericX(6)Blank fill.

Supplemental Record Type 4-02

The Supplemental Record Type 4 subtypes 01 through 04 are repeated until all supplemental load data is incorporated.

Field NamePositionLengthTypeFormatDescription
Record Type11Numeric9(1)This field must always have the value 4.
Sequence Number of Overflow2-32Numeric9(2)Next number in the Supplemental Record Type 4 sequence (see Supplemental Record Type 4-01 for definition). If sequence number is greater than 99, restart the series at the value 01.
Last Record Indicator41Numeric9(1)If this is the last record for this lender, this field must have the value 9; otherwise, zero (0) fill.
Filler5-95Numeric9(5)Zero (0) fill.
FHA Case Number10-1910Numeric9(10)Unique 10-digit identifier assigned by the FHA to the mortgage loan for which monthly premium is being paid.

Right justify and zero (0) fill.
Filler20-278Numeric9(8)Zero (0) fill.
Dollar Amount28-347Numeric9(5)V99Total amount of payment, including late and interest charges if applicable, for the specified FHA Case Number.

Right justify and zero (0) fill.
Loan Number35-4915AlphanumericX(15)(Optional) First 15 characters of the identifier assigned by the lender to the mortgage loan associated with the FHA Case Number; otherwise, blank fill. If a Loan Number is provided, it is included in Monthly Premium report files, e.g., Billing and Reconciliation files.
Loan Number (continued)50-5910AlphanumericX(10)(Optional) If needed, continuation of the identifier assigned by the lender to the mortgage loan associated with the FHA Case Number; otherwise, blank fill.
Filler60-645AlphanumericX(5)Blank fill.
Filler65-695Numeric9(5)Zero (0) fill.
FHA Case Number70-7910Numeric9(10)Unique 10-digit identifier assigned by the FHA to the mortgage loan for which monthly premium is being paid.

Right justify and zero (0) fill.
Filler801AlphanumericX(1)Blank fill.

Supplemental Record Type 4-03

The Supplemental Record Type 4 subtypes 01 through 04 are repeated until all supplemental load data is incorporated

Field NamePositionLengthTypeFormatDescription
Record Type11Numeric9(1)This field must always have the value 4.
Sequence Number of Overflow2-32Numeric9(2)Next number in the Supplemental Record Type 4 sequence (see Supplemental Record Type 4-01 for definition). If sequence number is greater than 99, restart the series at the value 01.
Last Record Indicator41Numeric9(1)If this is the last record for this lender, this field must have the value 9; otherwise, zero (0) fill.
Filler5-128Numeric9(8)Zero (0) fill.
Dollar Amount13-197Numeric9(5)V99Total amount of payment, including late and interest charges if applicable, for the specified FHA Case Number.

Right justify and zero (0) fill.
Loan Number20-3415AlphanumericX(15)(Optional) First 15 characters of the identifier assigned by the lender to the mortgage loan associated with the FHA Case Number; otherwise, blank fill. If a Loan Number is provided, it is included in Monthly Premium report files, e.g., Billing and Reconciliation files.
Loan Number (continued)35-4410AlphanumericX(10)(Optional) If needed, continuation of the identifier assigned by the lender to the mortgage loan associated with the FHA Case Number; otherwise, blank fill.
Filler45-495AlphanumericX(5)Blank fill.
Filler50-545Numeric9(5)Zero (0) fill.
FHA Case Number55-6410Numeric9(10)Unique 10-digit identifier assigned by the FHA to the mortgage loan for which monthly premium is being paid.

Right justify and zero (0) fill.
Filler65-728Numeric9(8)Zero (0) fill.
Dollar Amount73-797Numeric9(5)V99Total amount of payment, including late and interest charges if applicable, for the specified FHA Case Number.

Right justify and zero (0) fill.
Filler801AlphanumericX(1)Blank fill.

Supplemental Record Type 4-04

The Supplemental Record Type 4 subtypes 01 through 04 are repeated until all supplemental load data is incorporated.

Field NamePositionLengthTypeFormatDescription
Record Type11Numeric9(1)This field must always have the value 4.
Sequence Number of Overflow2-32Numeric9(2)Next number in the Supplemental Record Type 4 sequence (see Supplemental Record Type 4-01 for definition). If sequence number is greater than 99, restart the series at the value 01.
Last Record Indicator41Numeric9(1)If this is the last record for this lender, this field must have the value 9; otherwise, zero (0) fill.
Loan Number5-1915AlphanumericX(15)(Optional) First 15 characters of the identifier assigned by the lender to the mortgage loan associated with the FHA Case Number; otherwise, blank fill. If a Loan Number is provided, it is included in Monthly Premium report files, e.g., Billing and Reconciliation files.
Loan Number (continued)20-2910AlphanumericX(10)(Optional) If needed, continuation of the identifier assigned by the lender to the mortgage loan associated with the FHA Case Number; otherwise, blank fill.
Filler30-345AlphanumericX(5)Blank fill.
Filler35-395Numeric9(5)Zero (0) fill.
FHA Case Number40-4910Numeric9(10)Unique 10-digit identifier assigned by the FHA to the mortgage loan for which monthly premium is being paid.

Right justify and zero (0) fill.
Filler50-578Numeric9(8)Zero (0) fill.
Dollar Amount58-647Numeric9(5)V99Total amount of payment, including late and interest charges if applicable, for the specified FHA Case Number.

Right justify and zero (0) fill.
Loan Number65-7915AlphanumericX(15)(Optional) First 15 characters of the identifier assigned by the lender to the mortgage loan associated with the FHA Case Number; otherwise, blank fill. If a Loan Number is provided, it is included in Monthly Premium report files, e.g., Billing and Reconciliation files.
Filler801AlphanumericX(1)Blank fill.

Continue repeating in sequence the Supplemental Record Type 4 records (01, 02, 03, 04) until all related FHA case number information is incorporated. As they are repeated, increment the Sequence Number of Overflow for each record by one. If the sequence number exceeds 99, restart the series at 01. Place the value 9 in the Last Record Indicator field of the last Supplemental Record Type 4 record (can be subtype 01, 02, 03, or 04 as the last Supplemental Record).

Deposit Control Record

Field Namefont>PositionLengthTypeFormatDescription
Record Type11Numeric9(1)This field must always have the value 8.
Company Number2-65Numeric9(5)This field must always have the value 00502.
Total Deposit Reports7-115Numeric9(5)Count of the number of Detail Records (lenders) reported in the file.

Right justify and zero (0) fill.
Total Deposits12-2211Numeric9(9)V99Sum of the Total Transaction Amount for all Detail Records. Total amount paid for all cases specified in the file.

Right justify and zero (0) fill.
Filler23-8058AlphanumericX(58)Blank fill.

Deposit Total Record

Field NamePositionLengthTypeFormatDescription
Record Type11Numeric9(1)This field must always have the value 9.
Total Record Count2-76Numeric9(6)Total number of records in the file, including the Header Record (Record Type 1) and Deposit Total Record (Record Type 9).

Right justify and zero (0) fill.
Filler8-8073AlphanumericX(73)Blank fill.

For information regarding the other available file format, see Batch File Format for Payment of Monthly (Periodic) Mortgage Insurance Premium (New Format).