|
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. 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: | | 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. |
|
| 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. | |
Back to top
| 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. | |
Back to top
| 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. | |
Back to top
| 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. | |
Back to top
| 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. | |
Back to top
| 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).
| |
Back to top
| Deposit
Control Record
| Field
Name |
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. | |
Back to top
| 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).
|