servicer that will service the loan HUD assigned Integer; mortgagee To Investor Must be > 0; Yes 4 number of Must be a valid FHA Investor Number investor Loan Setup Import – Record Layout This table describes the required data elements, formats and their sequence within the file. Table 7: Data Item Descriptions for File LoanSetupImport File Type Identifier: LoanSetupImport Seq. Data Item Description Format/Range of Values Required # FHA Case # FHA case number Numeric(10); Yes 1 Interest Rate Note interest Rate at Integer followed by decimal(3); Yes 2 At Closing closing Range and >‘0.000’ <’20.000’ Exp. Interest Expected Interest Integer followed by decimal(3); Yes 3 Rate Rate Range >= <= ‘3.000’ ‘18.875’; String(1); = Annual; ‘A’ Rate Type Type of interest rate Yes 4 = Fixed; ‘F’ = Monthly; ‘M’ Integer; If Rate Type ‘A’ : = 1-Year CMT; ‘100’ = 1-Year LIBOR; ‘230’ If Rate Type : ‘F’ Index Type Interest rate index = No Index; Yes 5 ‘240’ If Rate Type : ‘M’ = 1-Year CMT; ‘100’ = 1-Month CMT; ‘110’ = 1-Month LIBOR; ‘200’ Integer followed by decimal(3); If Rate Type A or M: Conditional; and <= if Rate Type = >‘0.000’ ‘5.000’; Margin Interest Rate margin 6 If Rate Type F: Monthly or or NULL Annual ‘0.000’ Date(10); Format: YYYY-MM-DD; Conditional; ARM First First interest rate If Rate Type Monthly: if Rate Type = 7 Change Date change date 1st of the month AND >= 30days and Monthly or <= 6 months from Closing Date; Annual
servicer that will service the loan To Investor HUD assigned mortgagee number of investor Integer; Must be > 0; Must be a valid FHA Investor Number Yes 4 Loan Setup Import – Record Layout This table describes the required data elements, formats and their sequence within the file. Table 7: Data Item Descriptions for File LoanSetupImport File Type Identifier: LoanSetupImport Data Item Description Format/Range of Values Required Seq. # FHA Case # FHA case number Numeric(10); Yes 1 Interest Rate At Closing Note interest Rate at closing Integer followed by decimal(3); Range >‘0.000’ and <’20.000’ Yes 2 Exp. Interest Rate Expected Interest Rate Integer followed by decimal(3); Range >= ‘3.000’ <= ‘18.875’; Yes 3 Rate Type Type of interest rate String(1); ‘A’ = Annual; ‘F’ = Fixed; ‘M’ = Monthly; Yes 4 Index Type Interest rate index Integer; If Rate Type ‘A’ : ‘100’ = 1-Year CMT; ‘230’ = 1-Year LIBOR; If Rate Type ‘F’ : ‘240’ = No Index; If Rate Type ‘M’ : ‘100’ = 1-Year CMT; ‘110’ = 1-Month CMT; ‘200’ = 1-Month LIBOR; Yes 5 Margin Interest Rate margin Integer followed by decimal(3); If Rate Type A or M: >‘0.000’ and <= ‘5.000’; If Rate Type F: ‘0.000’ or NULL Conditional; if Rate Type = Monthly or Annual 6 ARM First Change Date First interest rate change date Date(10); Format: YYYY-MM-DD; If Rate Type Monthly: 1st of the month AND >= 30days and <= 6 months from Closing Date; Conditional; if Rate Type = Monthly or Annual 7