Navigation: Appendix A - Merge Field Descriptions (Loans) >
Merge Field |
Field Mnemonic/ Calculation |
Description |
|---|---|---|
ACCRUED INTEREST |
LNACIN |
Accrued interest on loan |
APPOINTMENT DATE |
EVACDT |
|
APPOINTMENT TIME |
EVTIME |
|
APPRAISAL AMOUNT |
LNAPAM |
Appraisal amount |
APPRAISAL DATE |
LNAPSR |
Appraisal date |
ARM 1ST RATE CHANGE DATE |
LN1ROL |
Date of 1st rate roll |
ARM ACCRUAL RATE |
LNAMRT |
Accrual rate on loan |
ARM ACCRUAL RATE LIFETIME MAX |
LNAMHI |
Maximum rate allowed on loan |
ARM ACCRUAL RATE LIFETIME MIN |
LNAMLO |
Minimum rate allowed on loan |
ARM ACCRUAL RATE MAX PTS DOWN |
LNAMRD |
Maximum points per period the rate can decrease |
ARM ACCRUAL RATE MAX PTS UP |
LNAMRU |
Maximum points per period the rate can increase |
ARM ACCRUAL RATE OFFSET |
LNAMOF |
Accrual rate offset |
ARM MAX PRINCIPAL BALANCE |
LNAMMX |
Maximum principal balance that the loan is allowed to reach |
ARM NEXT ACCR RATE CHANGE DATE |
LNAMDT |
Next rate change date |
ARM P/I PAYMENT CHANGE DATE |
LNPIEF |
Next P/I change date |
ASSET CLASSIFICATION |
LNACLS |
Asset classification |
BALLOON DATE |
Date used with action code 1 |
|
BANK ROUTING NUMBER |
LNABNK |
Bank routing/transit number |
BANK SOURCE ACCOUNT NUMBER |
LNANBR |
Savings or checking that will be debited for loan payment |
BRANCH ADDRESS LINE 1 |
OBADD1 |
Address line 1 where the office is located |
BRANCH ADDRESS LINE 2 |
OBADD2 |
Address line 2 where the office is located |
BRANCH CITY STATE ZIP |
OBCITY, OBSTAB, OBZIPC, OBZIP4 |
City, state, ZIP, and ZIP+4 where the office is located |
BRANCH MANAGER NAME |
LOONAM |
Adds the name of the Servicing Officer to the event letter |
BRANCH NAME |
OBFNAM |
Name or description of office |
BRANCH PHONE NUMBER |
OBPHAC, PBPHPF, OBPHON |
Phone number for the office formatted (xxx) xxx-xxxx |
COLLATERAL DESCRIPTION |
LNCLDS |
Collateral description |
CURRENT LTV |
LNPBAL + LNBAL2 / LNSELL OR / LNAPAM |
Current loan-to-value ratio which is the principal balance plus the secondary balance divided by the lesser of the selling price or the appraisal amount. If the selling price or appraisal amount fields are zero, the field with a value will be used for the calculation. |
DATE INTEREST PAID TO |
LNPDTO |
Date interest is paid to |
DATE LAST ACCRUED |
LNDLAC |
Date of last interest accrual |
DATE LAST LATE |
LNLTDT |
Date of last late charge assessment |
DATE OF LAST CHECK |
Date used with action code 212 |
|
DATE OPENED |
LNOPND |
Date the loan was opened |
DUE DATE |
LNDUDT |
Loan due date |
EFFECTIVE RATE X |
LNAMRT OR |
Loan effective rate: interest rate; accrual rate; LIP rate for LIP method code 1 or 101 |
EXTRA PRINCIPAL |
LNOPMT |
Amount of extra principal to be added to the principal |
FORMATTED LOAN NUMBER |
Uses XXXX-XXXXXX-XX instead of actual account number |
|
FORMATTED LOAN NUMBER NO LEAD ZERO |
Formats the Loan account number by automatically removing leading zeros. |
|
FIRST DUE DATE |
LN1DUE |
Date the first payment is due |
INSURER CODE |
LNINSU |
Insurer code |
INTEREST CALCULATION CODE |
LNIBAS |
Base to use to calculate loan interest |
INTEREST RATE |
LNRATE |
Annual interest rate or payment rate for payment method 7 loans |
INVESTOR GROUP |
LNIGRP |
Investor group number |
INVESTOR MASTER |
LNIMST |
Investor master number |
INVESTOR NAME |
IMNAM |
Investor name |
LATE CHARGES |
LNLATE |
Late charges on loan |
LATE CHARGES AND FEES |
LNLATE + LNFEES |
Late charges plus total loan fees |
LATE CHARGE PROJECTED |
CALC LATE |
Projected late charges for current payment |
LATE RATE |
LNLTRT |
Late rate |
LINE OF CREDIT LIMIT |
LNRLCL |
Line of credit limit |
LIP ACCRUED INTEREST |
LNLACC |
LIP accrued interest |
LIP CUSTOMER BALANCE |
LNCBAL |
LIP customer balance |
LIP DISBURSED BALANCE |
LNPBAL - LNLBAL |
LIP disbursed balance |
LIP INTEREST RATE |
LNLRAT |
LIP interest rate |
LIP LIFETIME MAX |
LNLMAX |
LIP lifetime maximum rate |
LIP LIFETIME MIN |
LNLMIN |
LIP lifetime minimum rate |
LIP RATE OFFSET |
LNLOFF |
LIP rate offset |
LIP UNDISBURSED BALANCE |
LNLBAL |
Amount of funds not yet disbursed |
LOAN FEES |
LNFEES |
Total loan fees |
LOAN OFFICER NUMBER |
LNOFCR |
Loan office number |
MATURITY DATE |
LNMATD |
Loan maturity date |
MISCELLANEOUS FUNDS |
LNMISC |
Loan miscellaneous funds |
MONTHS TO 1ST RATE CHANGE |
WKLMTH |
Indicates the number of months from the opening of the loan to the first rate roll |
NEXT PAYMENT DUE |
CALC |
Next payment due on the account |
NEXT PAYMENT PRINCIPAL PORTION |
Calculated |
Principal portion of current next payment |
NEXT PAYMENT INTEREST PORTION |
Calculated |
Interest portion of current next payment |
NEXT PMT WITH EXTRA PRINCIPAL |
CALC NEXT PYMT + LNOPMT |
Calculated next payment plus extra principal |
NUMBER PAYMENTS DELINQUENT |
RUN DATE - LNDUDT + |
Month’s difference between current run date and due date plus one divided by the loan frequency. Bi-weekly loans calculate the number of payments delinquent by taking the days’ difference between the run date and due date divided by 14 plus one. |
ORIGINAL PRINCIPAL BALANCE |
LNOBAL |
Original principal balance |
ORIGINATION OFFICER |
LOONAM |
Adds the name of the originating officer to the event letter |
P/I PAYMENT |
LNPICN |
Principal/interest payment |
PARTIAL OR APPLIED TO PAYMENTS |
LNPRTL |
Partial or applied to payments |
PAYMENT FREQUENCY |
LNFREQ |
Loan payment frequency |
PER DIEM |
LNPBAL + LNRATX / LNIBAS |
One day’s interest calculated by taking the principal balance multiplied by the effective rate divided by the interest base. |
PRIME LOWER LIMIT |
LNPSLO |
Minimum rate allowed on loan after adding index rate plus margin |
PRIME UPPER LIMIT |
LNPSHI |
Maximum rate allowed on loan after adding index rate plus margin |
PRINCIPAL BALANCE |
LNPBAL |
Principal balance on loan |
PROJECTED PMT PRINCIPAL PORTION (for ARM loans) |
Calculated |
Principal portion of the projected payment |
PROJECTED PMT INTEREST PORTION (for ARM loans) |
Calculated |
Interest portion of the projected new payment |
RATE OFFSET MARGIN |
LNROFF |
Interest rate offset margin |
RATE ROUNDING FACTOR |
LNRRND |
Prints the rounded rate factor, such as 1//4th, 1/8th, 1/10th, 1/16th, or none. This information is pulled from the Round Rate To Nearest field (LNRRND) on the Loans > Account Information > Account Detail screen in CIM GOLD. |
REMAIN PORTION DUE |
LNRPDU |
Remaining unpaid portion of payment |
REMAINING TERM |
LNTERM / LNFREQ - LNINNO |
Remaining term on the loan
Loan term divided by the loan frequency minus the installment number.
For bi-weekly loans, take the term in months divided by 12 multiplied by 26 to get the number of payments. Subtract the installment from the number of payments to get remaining payments. Take remaining payments divided by 26 then multiply by 12 to get remaining term in months. |
ESCROW BAL PLUS RESERVE BAL |
LNR1BL + LNR2BL |
Sum of Escrow and Reserve balances |
ESCROW BALANCE |
LNR1BL |
Escrow balance |
ESCROW CON PLUS RESERVE CON |
LNR1CN + LNR2CN |
Sum of Escrow and Reserve payments |
ESCROW PAYMENT |
LNR1CN |
Escrow payment |
RESERVE BALANCE |
LNR2BL |
Reserve balance |
RESERVE PAYMENT |
LNR2CN |
Reserve payment |
SECURED ACCOUNT NUMBER |
Places X’s in part of the account number, e.g., XXXX-XX1234-12 |
|
SECURITY ACCOUNT |
LNSECX |
Deposit account that secures the loan |
SERVICING OFFICER |
LOONAM |
Adds the name of the servicing officer to the event letter |
SUBSIDY BALANCE |
LNSBAL |
Subsidy balance |
SUBSIDY PAYMENT |
LNSCON |
Subsidy payment |
TERM OF LOAN |
LNTERM |
Term of the loan |
TIMES 30 LATE LAST 12 MONTHS |
BU12M |
30+ days late in the last 12 months |
TIMES 60 LATE LAST 24 MONTHS |
BU24M |
60+ days late in the last 24 months |
TIMES LATE |
LNLTNO |
Number of times the loan has been late |
TIMES LATE 10 TO 29 |
LNLT10 |
Number of times over life of loan payment has been made 10-29 days after due date |
TIMES LATE 30 TO 59 |
LNLT30 |
Number of times over life of loan payment has been made 30-59 days after due date |
TIMES LATE 60 TO 89 |
LNLT60 |
Number of times over life of loan payment has been made 60-89 days after due date |
TIMES LATE 90 OVER |
LNLT90 |
Number of times over life of loan payment has been made 90+ days after due date |
TIMES LATE LAST 2 YEARS |
LNDELQ |
Times late in past 2 years |
TOTAL DUE |
CALC PMTS + LNLATE + LNFEES - LNPRTL + LNRPDU
For payment method 3 or 6 loans with option OP01 ILF6 set to "Y," the total due is calculated as follows: |
All payments (principal, interest and escrow/reserves) that are due (all payments where the loan due date is less than or equal to the run date) plus late charges and loan fees minus partial plus remaining portion due; payment method 5 all payments that have been billed (total of all billings on the Billing & Coupons screen) plus late charges and loan fees plus remaining portion due; LIP loans use prior unpaid charges plus late charges and loan fees. |
TOTAL DUE AFTER GRACE |
CALC PMTS + LNLATE + LNFEES - LNPRTL + LNRPDU
For payment method 3 or 6 loans with option OP01 ILF6 set to "Y," the total due is calculated as follows: |
All payments (principal, interest, and escrow/reserves) where the due date plus grace days is less than or equal to the run date plus late charges and loan fees minus partial plus remaining portion due; pmth 5 all payments that are billed (total of all billings on the Billing & Coupons screen) where the due date plus grace days is less than or equal to the run date plus remaining portion due plus late charges and fees; LIP loans only include late charges and loan fees. |
TOTAL DUE TO BALLOON OR MATURITY |
LNPBAL + CALC INT + LNLATE + LNFEES - LNR1BL - LNR2BL - LNSBAL - LNR1AI - LNR2A1 - LNMISC + NIR1AC + NIR2AC - LNLBAL - LNCBAL - LNPTRL (EXCLUDING MTHD 5 OR 6) |
Total due (includes all charges due) to the lesser of the balloon date or the maturity day. If no balloon date or maturity date, interest will be calculated to the run date. This uses the current principal balance. Also see TOTAL DUE AT MATURITY (LETT01) for events 25, 26, and 27. It amortizes payments to maturity date. When the payments are amortized, the system makes pseudo-payments so the principal balance used is the amortized balance instead of the current principal balance. |
TOTAL INT TO BALLOON OR MATURITY |
CALC INT |
Total interest due to the lesser of the balloon date or the maturity date. If no balloon or maturity date, interest will be calculated to the run date. |
TOTAL PAYMENTS DUE |
CALC PMTS |
Total payments due (principal, interest, and escrow/reserves) where the loan due date is less than or equal to the run date |
TOTAL PMTS W FEES AND LATE CHGS |
CALC PMTS + LNLATE + LNFEES |
Total payments due (principal, interest, and escrow/reserves) where the loan due date is less than or equal to the run date plus late charges and loan fees |
TOTAL PMTS W FEES AND PARTIAL |
CALC PMTS + LNFEES - LNPRTL |
Total payments due (principal, interest, and escrow/reserves) where the due date is less than or equal to the run date plus loan fees minus partial |
TOTAL PMTS W LATE AND PARTIAL |
CAL PMTS + LNLATE - LNPRTL |
Total payments due (principal, interest, and escrow/reserves) where the loan due date is less than or equal to the run date plus late charges minus partial |
TOTAL PMTS WITH LATE CHARGES |
CAL PMTS + LNLATE |
Total payments due (principal, interest, and escrow/reserves) where the loan due date is less than or equal to the run date plus late charges |
TOT PMTS WITH LOAN FEES |
CALC PMTS + LNFEES |
Total payments due (principal, interest, and escrow/reserve) where the loan due date is less than or equal to the run date plus loan fees |
TOT PMTS WITH PARTIAL |
CALC PMTS - LNPRTL |
Total payments due (principal, interest, and escrow/reserve) where the loan due date is less than or equal to the run date minus partial |
TOTAL PRINCIPAL AND INTEREST DUE |
CALC PRIN / INT |
Total principal and interest due where the due date is less than or equal to the run date (does not work for payment method 5) |
TRANSFER ACCOUNT |
LNXFRX |
Account number of savings or checking account used as the transfer account |
TYPE |
LNTYPC |
Type of loan account |
USER DEFINED C17 |
UFC17 |
User-defined field C17 |
USER DEFINED C34 |
UFC34 |
User-defined field C34 |
See also:
Appendix A - Merge Field Descriptions