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:
- Header Record
- Detail Record (Mortgagee/Lender Header)
- Supplemental Record Type 4-01
- Supplemental Record Type 4-02
- Supplemental Record Type 4-03
- Supplemental Record Type 4-04
- Deposit Control Record
- Deposit Total Record
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.
Header Record
Field Name | Position | Length | Type | Format | Description |
---|---|---|---|---|---|
Record Type | 1 | 1 | Numeric | 9(1) | This field must always have the value 1. |
Filler | 2-3 | 2 | Numeric | 9(2) | Zero (0) fill. |
Filler | 4-13 | 10 | Alphanumeric | X(10) | Blank fill. |
Filler | 14-18 | 5 | Numeric | 9(5) | Zero (0) fill. |
Company Number | 19-23 | 5 | Numeric | 9(5) | Number identifying the Periodic file format. This field must always have the value 00502. |
Transmission Date | 24-29 | 6 | Numeric | YYMMDD | Estimated date the file is transmitted. |
Transmission Time | 30-33 | 4 | Numeric | HHMM | Estimated time the file is transmitted (Eastern Time). |
Override Duplicate | 34 | 1 | Alphanumeric | X(1) | Options for handling duplicate case payments per day:
|
Filler | 35-44 | 10 | Alphanumeric | X(10) | Blank fill. |
Periodic Format Indicator | 45 | 1 | Alphanumeric | X(1) | Blank space identifying the old CPU input format. |
Filler | 46-80 | 35 | Alphanumeric | X(35) | Blank fill. |
Detail Record (Mortgagee/Lender Header)
Field Name | Position | Length | Type | Format | Description |
---|---|---|---|---|---|
Record Type | 1 | 1 | Numeric | 9(1) | This field must always have the value 6. |
Filler | 2-9 | 8 | Numeric | 9(8) | Zero (0) fill. |
Mortgagee/ Lender ID Number | 10-14 | 5 | Numeric | 9(5) | Five-digit (corporate) FHA Title II identifier assigned to the lending institution making the payment. Right justify and zero (0) fill. |
Total Transaction Amount | 15-24 | 10 | Numeric | 9(8)V99 | Sum of the payment Dollar Amount for each FHA Case Number included in the Detail and Supplemental Records. Right justify and zero (0) fill. |
Supplemental Indicator | 25 | 1 | Alphanumeric | X(1) | This field must always have the value S. |
Filler | 26-30 | 5 | Numeric | 9(5) | Zero (0) fill. |
FHA Case Number | 31-40 | 10 | Numeric | 9(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. |
Filler | 41-48 | 8 | Numeric | 9(8) | Zero (0) fill. |
Dollar Amount | 49-55 | 7 | Numeric | 9(5)V99 | Total amount of payment, including late and interest charges if applicable, for the specified FHA Case Number. Right justify and zero (0) fill. |
Loan Number | 56-70 | 15 | Alphanumeric | X(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 Date | 71-76 | 6 | Numeric | MMDDYY | This field is not currently applicable and can be zero (0) filled. |
Filler | 77-80 | 4 | Alphanumeric | X(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 Name | Position | Length | Type | Format | Description |
---|---|---|---|---|---|
Record Type | 1 | 1 | Numeric | 9(1) | This field must always have the value 4. |
Sequence Number of Overflow | 2-3 | 2 | Numeric | 9(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 Indicator | 4 | 1 | Numeric | 9(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-14 | 10 | Alphanumeric | X(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. |
Filler | 15-19 | 5 | Alphanumeric | X(5) | Blank fill. |
Filler | 20-24 | 5 | Numeric | 9(5) | Zero (0) fill. |
FHA Case Number | 25-34 | 10 | Numeric | 9(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. |
Filler | 35-42 | 8 | Numeric | 9(8) | Zero (0) fill. |
Dollar Amount | 43-49 | 7 | Numeric | 9(5)V99 | Total amount of payment, including late and interest charges if applicable, for the specified FHA Case Number. Right justify and zero (0) fill. |
Loan Number | 50-64 | 15 | Alphanumeric | X(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-74 | 10 | Alphanumeric | X(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. |
Filler | 75-80 | 6 | Alphanumeric | X(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 Name | Position | Length | Type | Format | Description |
---|---|---|---|---|---|
Record Type | 1 | 1 | Numeric | 9(1) | This field must always have the value 4. |
Sequence Number of Overflow | 2-3 | 2 | Numeric | 9(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 Indicator | 4 | 1 | Numeric | 9(1) | If this is the last record for this lender, this field must have the value 9; otherwise, zero (0) fill. |
Filler | 5-9 | 5 | Numeric | 9(5) | Zero (0) fill. |
FHA Case Number | 10-19 | 10 | Numeric | 9(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. |
Filler | 20-27 | 8 | Numeric | 9(8) | Zero (0) fill. |
Dollar Amount | 28-34 | 7 | Numeric | 9(5)V99 | Total amount of payment, including late and interest charges if applicable, for the specified FHA Case Number. Right justify and zero (0) fill. |
Loan Number | 35-49 | 15 | Alphanumeric | X(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-59 | 10 | Alphanumeric | X(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. |
Filler | 60-64 | 5 | Alphanumeric | X(5) | Blank fill. |
Filler | 65-69 | 5 | Numeric | 9(5) | Zero (0) fill. |
FHA Case Number | 70-79 | 10 | Numeric | 9(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. |
Filler | 80 | 1 | Alphanumeric | X(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 Name | Position | Length | Type | Format | Description |
---|---|---|---|---|---|
Record Type | 1 | 1 | Numeric | 9(1) | This field must always have the value 4. |
Sequence Number of Overflow | 2-3 | 2 | Numeric | 9(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 Indicator | 4 | 1 | Numeric | 9(1) | If this is the last record for this lender, this field must have the value 9; otherwise, zero (0) fill. |
Filler | 5-12 | 8 | Numeric | 9(8) | Zero (0) fill. |
Dollar Amount | 13-19 | 7 | Numeric | 9(5)V99 | Total amount of payment, including late and interest charges if applicable, for the specified FHA Case Number. Right justify and zero (0) fill. |
Loan Number | 20-34 | 15 | Alphanumeric | X(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-44 | 10 | Alphanumeric | X(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. |
Filler | 45-49 | 5 | Alphanumeric | X(5) | Blank fill. |
Filler | 50-54 | 5 | Numeric | 9(5) | Zero (0) fill. |
FHA Case Number | 55-64 | 10 | Numeric | 9(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. |
Filler | 65-72 | 8 | Numeric | 9(8) | Zero (0) fill. |
Dollar Amount | 73-79 | 7 | Numeric | 9(5)V99 | Total amount of payment, including late and interest charges if applicable, for the specified FHA Case Number. Right justify and zero (0) fill. |
Filler | 80 | 1 | Alphanumeric | X(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 Name | Position | Length | Type | Format | Description |
---|---|---|---|---|---|
Record Type | 1 | 1 | Numeric | 9(1) | This field must always have the value 4. |
Sequence Number of Overflow | 2-3 | 2 | Numeric | 9(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 Indicator | 4 | 1 | Numeric | 9(1) | If this is the last record for this lender, this field must have the value 9; otherwise, zero (0) fill. |
Loan Number | 5-19 | 15 | Alphanumeric | X(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-29 | 10 | Alphanumeric | X(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. |
Filler | 30-34 | 5 | Alphanumeric | X(5) | Blank fill. |
Filler | 35-39 | 5 | Numeric | 9(5) | Zero (0) fill. |
FHA Case Number | 40-49 | 10 | Numeric | 9(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. |
Filler | 50-57 | 8 | Numeric | 9(8) | Zero (0) fill. |
Dollar Amount | 58-64 | 7 | Numeric | 9(5)V99 | Total amount of payment, including late and interest charges if applicable, for the specified FHA Case Number. Right justify and zero (0) fill. |
Loan Number | 65-79 | 15 | Alphanumeric | X(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. |
Filler | 80 | 1 | Alphanumeric | X(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> | Position | Length | Type | Format | Description |
---|---|---|---|---|---|
Record Type | 1 | 1 | Numeric | 9(1) | This field must always have the value 8. |
Company Number | 2-6 | 5 | Numeric | 9(5) | This field must always have the value 00502. |
Total Deposit Reports | 7-11 | 5 | Numeric | 9(5) | Count of the number of Detail Records (lenders) reported in the file. Right justify and zero (0) fill. |
Total Deposits | 12-22 | 11 | Numeric | 9(9)V99 | Sum 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. |
Filler | 23-80 | 58 | Alphanumeric | X(58) | Blank fill. |
Deposit Total Record
Field Name | Position | Length | Type | Format | Description |
---|---|---|---|---|---|
Record Type | 1 | 1 | Numeric | 9(1) | This field must always have the value 9. |
Total Record Count | 2-7 | 6 | Numeric | 9(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. |
Filler | 8-80 | 73 | Alphanumeric | X(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).