Table of Contents IndexTop

The Mortgage Loan system provides an accounting method for maintaining mortgage loans. Each installation is responsible for establishing its own schedule of accounting procedures to be used in system operation. In general, each bank will define daily, weekly, monthly, and annual operations.

On a daily basis, the bank will enter mortgage loan data. This includes entering new customers, new loans, transactions, and changes to any existing customers or loans.

The Mortgage Loan system requires that the Transaction Journal be run once a day as an update. This advances the Mortgage Loan system date and performs the necessary interest and insurance calculations.

On a monthly basis, reports are generated. Monthly reports will include earnings, delinquency, and new and paid out mortgage reports.

On an annual basis, annual statements must be generated. This operation generates statements to be sent to the customers and also zeros the year-to-date interest fields in the Mortgage Loan file.

When the Mortgage Loan system is selected from the BANCADO main menu, the following screen is displayed:

The following describes the various files used by the Mortgage Loan Accounting System.

The Mortgage Loan Accounting file contains one record for each loan processed by the bank. A loan record consists of 75 data items designed to describe a loan. Please note that there are two additional records per mortgage, the Mortgage Description record described in Section 13.2.2 and the Mortgage Escrow record described in Section 13.2.3. The Just Ask field names are in brackets next to the name of the field. The fields and the valid contents of each data item are as follows:

CUSTOMER NUMBER (MLCUST)

This field contains the customer number. This is a ten-character field.

MORTGAGE NUMBER (MNUMBER)

This field is a maximum of nine numeric digits and contains the mortgage number. Mortgage records are stored according to this number.

OFFICE OR BRANCH (MOFFICE)

This is a two-digit field that contains the office or branch number.

TYPE (MTYPE)

This is a two-digit field that indicates the type of mortgage as determined by the user.

USER-ASSIGNED CODE (MCODE)

This is a two-digit field and contains the code assigned for this mortgage as determined by the user.

OFFICER (MOFFICER)

This is a two-digit field and contains the code assigned to the particular officer who is responsible for the mortgage.

BALANCE (MBALANCE)

This field contains the current loan balance. The maximum value is $999,999,999.99.

AMORTIZATION SCHEDULE BALANCE (MSCBAL)

This is a 12-digit field and is used to keep track of the balance as originally scheduled for the current payment number regardless of partial payments and advance payments for amortized loans.

DAYS PER YEAR (MDPY)

This is a three-digit field that contains either 360 or 365 to indicate the interest calculation basis for the mortgage.

RATE CODE (MRTCD)

This is a two-digit field used for grouping like variable-rate mortgages as determined by the user.

CUSTOMER RATE (MRATE)

This is a numeric field that contains the annual interest rate as a percentage. The format for this field is 99.9999.

ACCRUED INTEREST (MACRUED)

This is a 12-digit field that contains the earned interest to date, which is the amount of interest that should be paid if the mortgage is paid off. The format for this field is 999999999.99.

DECIMAL SAVE (MDEC)

This field keeps track of accrued interest amounts of less than one cent so that the total periodic accrual will be accurate.

ANTICIPATED INTEREST NEXT PAYMENT (MANTINT)

This is a 12-digit field that contains the anticipated interest amount for the payment following the current one. It is used in the calculation of the distribution of pre-paid principal.

INTEREST PAID YEAR-TO-DATE (MYTDINT)

This is a 12-digit field that contains the actual amount of interest paid year-to-date by the customer. This is the amount that will be reported at year-end regardless of any amortization schedule.

PURCHASED FROM (MPURCH)

If the mortgage was purchased, this field contains the number assigned to the institution from which it was purchased. If the mortgage was not purchased, this field is zeros.

PARTICIPANT NUMBER (MPART)

This is a two-digit field that contains the participant number only if this is a participated mortgage. If there is no participant, the field contains zeros.

PARTICIPANT BALANCE (MPARTBAL)

This is a numeric field and contains the current participated amount. The maximum value of this amount is 999999999.99.

PARTICIPANT AMORTIZATION SCHEDULE BALANCE (MPSCBAL)

This is a 12-digit field that is used to keep track of the participant balance as originally scheduled for the current payment number regardless of partial payments and advance payments.

PARTICIPANT RATE (MPRATE)

This is a numeric field and contains the rate charged by the participant. The format for this field is 99.999. When entering a mortgage record, this field is requested only if participant is specified.

PARTICIPANT ACCRUED INTEREST (MPACCRUE)

This is a 12-digit field that contains the earned participant interest to date which is the amount of interest that should be paid to the participant if the mortgage is paid off.

PARTICIPANT DECIMAL SAVE (MPDEC)

This field keeps track of accrued interest amounts of less than one cent so that the total periodic participant accrual will be accurate.

ANTICIPATED PARTICIPANT INTEREST NEXT PAYMENT (MPANTINT)

This field contains the anticipated participant interest amount for the payment following the current one. It is used in the calculation of the distribution of pre-paid principal.

PARTICIPANT PRINCIPAL PAYMENT SHARE (MPPCT)

This field contains the participant's share of the principal payment expressed as a percentage of the entire principal payment. If the participant is to be paid off as soon as possible, this field will contain 100%. The format for this field is 999.9999.

ESCROW BALANCE (MESCBAL)

This field is 12-digits and contains the current positive or negative balance of escrow payments for the mortgage.

ESCROW IN ARREARS (MESCARR)

This is a 12-digit field. Since escrow payments are not required for the system to advance the due date, this field is required to keep track of unpaid customer escrow payments.

ESCROW PAYMENT AMOUNT (MESCPMP)

This field contains the amount of the payment which is to be put into escrow.

NUMBER OF TIMES EXTENED (MTEXT)

This is a two-digit field that contains a count of the number of times the mortgage has been extended.

NUMBER OF MONTHS EXTENDED (MMEXT)

This is a two-digit field that contains a count of the number of months the mortgage has been extended.

TOTAL EXTENSION FEES COLLECTED (MEXTFEE)

This field contains the total amount of extension fees collected over the life of the mortgage.

EXTENSION FEES YEAR-TO-DATE (MEXTYTD)

This field contains the total amount of extension fees collected during the current calendar year to be reported on Form 1098 at year-end.

NUMBER OF TIMES LATE (MTLATE)

This is a numeric field that keeps track of the number of times a mortgage payment is late over the life of the mortgage.

GREATEST NUMBER OF DAYS LATE (MWORST)

This is a numeric field that keeps track of the greatest number of days a mortgage payment was late over the life of the mortgage.

LATE CHARGE RATE (MLFRATE)

This is a numeric field that contains the late charge rate expressed as a percentage. The format for this field is 99.9999.

LATE CHARGES DUE (MLFD)

This field contains the amount of late charges already assessed but not yet paid.

TOTAL LATE CHARGES COLLECTED (MLFC)

This field keeps track of the total late charges collected over the life of the loan.

LATE CHARGES COLLECTED YEAR-TO-DATE (MLFCYTD)

This field keeps track of the total amount of late charges collected during the current calendar year.

DATE OF LAST CURE NOTICE (MLSTCURE)

For states in which a "Notice to Cure" is required prior to repossession procedures are initiated, this field is used to store the date that the last cure notice was sent to the customer. If no notices have been sent, the field is blank.

ORIGINAL MORTGAGE AMOUNT (MAMOUNT)

This is a numeric field that contains the total original amount of this mortgage. The maximum value of this amount is $999,999,999.99.

ORIGINAL MORTGAGE DATE (MDATE)

This is a 10-character field which contains the date that the mortgage was dated. When entering a mortgage record, the current date is displayed. Pressing <Enter> only accepts the current date as the mortgage date. To enter an earlier date, backspace to the beginning of the field and enter the correct date. If the mortgage is interest bearing and an earlier mortgage date is entered, extra interest will be accrued.

MATURITY DATE (MMATURE)

This is a 10-character field that contains the date the mortgage matures. The date is entered in MM/DD/YYYY format.

NORMAL DAY OF MONTH FOR PAYMENT (MPMTDAY)

This field is first determined by the First Due Date field. It can be changed to coincide with the day of the month desired. If the payment is due on the last day of the month, enter 31.

FIRST SCHEDULED PAYMENT DATE (MFRSTDUE)

This is a 10-character field that contains the first due date for the mortgage. The date is entered in MM/DD/YYYY format.

DATE OF LAST PAYMENT (MLSTPMT)

This is a 10-character field that contains the date of the last payment for a particular mortgage. The format is MM/DD/YYYY.

NEXT DUE DATE (MNXTDUE)

This is a 10-character field that contains the date the next payment is due for a particular mortgage. The format is MM/DD/YYYY.

TOTAL OF PAYMENTS DUE (MTOTDUE)

This is a numeric field that contains the amount of payments due, including principal, interest, and escrow, as of the current date.

PARTIAL PAYMENT ACCUMULATOR (MPARTPAY)

This is a numeric field that is used to retain extra amounts paid to be deducted from the next payment due.

ORIGINAL TERM (MTERM)

This is a three-digit field that contains the length of the mortgage term in months.

REMAINING TERM (MRTERM)

This is a three-digit field that contains the number of months remaining until maturity.

PAYMENTS PER YEAR (MPMTSYR)

This is a two-digit field that contains the number of payments to be made during a year. E.g. Monthly=12, Weekly=52, Semi-monthly=6, Quarterly=4, etc.

TOTAL NUMBER OF PAYMENTS (MTOTPMTS)

This is a three-digit field that contains the total number of payments for the entire term of the mortgage.

NEXT SCHEDULED PAYMENT NUMBER (MNXTPMTN)

This field is a three-digit field that contains the number of the next scheduled payment according to the amortization schedule based on payment amounts already received, not based on due dates.

FIRST PAYMENT INTEREST ON SCHEDULED DAYS (Y/N) (MFRSTCAL)

This is a one-character field and contains a code that indicates if the interest on the first payment of an amortized loan is to b e calculated for the actual number of days in the payment period or if the normal payment period is to be used. Y = use actual number of days, N = use normal payment period.

SCHEDULED PAYMENTS FIXED PRINCIPAL PLUS INTEREST (Y/N) (MFXDPRN)

This is a one-character field that contains a code which indicates whether the mortgage payment specified represents a fixed-principal amount or the total of principal and interest. If a fixed principal payment is specified, the amount due from the customer will gradually decrease over the life of the loan. The valid codes are: Y = Payments are Fixed-principal plus Interest. N = Payment amount specified includes both Principal and Interest.

INTEREST TYPE (MAMORT)

This one-character field contains a code that indicates the type of interest calculation to be used for this mortgage. Valid external values are: A = Amortized. S = Simple (daily interest bearing).

Interest type codes are stored on disk in a numeric format with 1 indicating amortized and 0 indicating simple interest.

FIRST PAYMENT AMOUNT (MFRSTAMT)

This is a numeric field that contains the amount of the first payment. The amount includes either principal and interest or principal only. (See SCHEDULED PAYMENTS FIXED PRINCIPAL PLUS INTEREST option above.) This field does not include any escrow amount.

REGULAR PAYMENT AMOUNT (MREGPAY)

This is a numeric field that contains the amount of the first payment. The amount includes either principal and interest or principal only. (See SCHEDULED PAYMENTS FIXED PRINCIPAL PLUS INTEREST option above.) This field does not include any escrow amount.

BALLOON PAYMENT NUMBER (MBALLNO)

This is a three-digit field. It contains the number of the payment which is the balloon payment, if any.

BALLOON PAYMENT AMOUNT (MBALLOON)

This is a numeric field that contains the amount of any balloon payment. The amount includes either principal and interest or principal only. (See SCHEDULED PAYMENTS FIXED PRINCIPAL PLUS INTEREST option above.) This field does not include any escrow amount.

AUTOMATIC PAYMENT CODE (MAUTOCD)

This is a one-character field which contains a code indicating whether the payment is to be automatically charged to a checking or savings account. Valid values are: C = Checking, S = Savings. When entering a mortgage record this field is requested only if the automatic payment response is yes. The system request this field with the prompt: Checking or Savings (C/S): []

AUTOMATIC PAYMENT ACCOUNT NUMBER (MAUTONO)

This is a nine-digit field and it contains the number of the account that is charged for automatic payments. When entering a mortgage record, this field is requested only for automatic payments.

LATE/ADVANCE NOTICE CODE (MNOTICE)

This is a one-digit field containing a code that indicates whether notices are generated in advance of payment due dates and for late payments. Valid values are:

0 = Late and Advance Notices are sent.

1 = Late Notices are sent, Advance Notices are not sent.

2 = Advance Notices are sent, Late Notices are not sent.

3 = Neither Late nor Advance Notices are sent.

When entering a mortgage record, pressing <Enter> without a code causes a zero to be entered into the field.

PRE-PAYMENT PENALTY RATE (MPPPRATE)

This is a numeric field that contains the pre-payment penalty rate, if any. The format for the field is 99.9999%.

PRE-PAYMENT PENALTY BASE (MPPPBASE)

This is a one-character field indicating the amount upon which any pre-payment penalty is based. The valid codes are: 0 = Original Loan Amount 1 = Present Balance

APPLY OVERPAYMENT TO FINAL PAYMENT (MOPOPT)

This is a one-character field that contains a code to indicate if overpayments are to be applied to the final mortgage payment or if they are to be applied to the next payment due. Valid codes are "Y" and "N". (See PARTIAL PAYMENT ACCUMULATOR).

RE-AMORTIZE IF OVERPAYMENT (MREAMORT)

This is a one-character field that determines if interest payments for amortized loans are to vary from the amortization schedule because of partial payments or if the schedule is to be adhered to regardless. The valid codes are: Y = Apply to final, N = Apply to next

NEW (MNEW)

This is a one-digit field indicating if the mortgage is new. The valid codes are:

0 = not new

1 = new today

2 = new this month

PAID-OFF (MPD)

This is a one-digit field indicating if the mortgage has been paid-off. The valid codes are:

0 = not paid off

1 = paid-off today

2 = paid-off this month

FREEZE CODE (MFREEZE)

This is a two-digit field indicating if the mortgage is frozen. The valid codes are:

0 = not frozen

1 - 99 = frozen. The user may assign various reasons to the 99 available codes.

FIRST TRANSACTION RECORD NUMBER (MFIRSTT)

This field contains the record number of the first transaction record on file for the mortgage. It is used to maintain a linked-list of transactions for ledger display and statement preparation.

LAST TRANSACTION RECORD NUMBER (MLASTT)

This field contains the record number of the last transaction record on file for this mortgage. It is used to maintain a linked-list of transactions for ledger display and statement preparation.

CALL COODE (MCALL)

This is a five-character alphanumeric field containing a code for the Federal Reserve Call Report, usually the section and line numbers where this mortgage is to be included on the report.

REMAINING ACCRUAL THIS PAYMENT PERIOD (MREMACC)

This field contains the remaining amount to be accrued this payment period for amortized loans.

REMAINING PARTICIPANT ACCRUAL THIS PERIOD (MPREMACC)

This field contains the remaining participant amount to be accrued this payment period for amortized loans.

The Mortgage Loan description file contains one record for each mortgage with the following information.

The Mortgage Loan escrow file contains one record for each mortgage processed by the bank. A mortgage escrow record consists of 55 data items designed to describe the escrow account. The Just Ask field names are in brackets next to the name of the field. The fields and the valid contents of each data item are as follows:

MORTGAGE NUMBER (ESCROWNO)

This field is a maximum of nine digits and contains the mortgage number. Mortgage records are stored according to this number.

MORTGAGE INSURANCE COMPANY (MMINSCO)

This field contains a two-digit mortgage insurance company number as assigned by the bank. If there is no mortgage insurance, the filed contains a zero. When entering a new mortgage record, pressing RETURN for this field indicates that there is no mortgage insurance and automatically causes a zero to be entered in the field.

MORTGAGE INSURANCE POLICY NUMBER (MMINSPO)

This field is 14 characters and contains the policy number of the mortgage insurance.

MORTGAGE INSURANCE BASE (MMINSB)

This field contains a one-digit code that indicates the method of calculation to be used for mortgage insurance premiums. Valid codes are:

0 = Use Amount Entered

1 = Use Rate Times Current Balance

2 = Use Rate Times Last Anniversary Balance

MORTGAGE INSURANCE RATE (MMINSRT)

This is a numeric field and contains the mortgage insurance rate. The format for this field is 99.9999%.

When entering a mortgage record, this field is requested only if mortgage insurance is specified.

MORTGAGE INSURANCE PAYMENTS PER YEAR (MMINSP)

This is a two-digit field that contains the number of mortgage insurance payments to be made each year. e.g. 12 = monthly.

NEXT MORTGAGE INSURANCE PAYMENT DUE DATE (MMINSDT)

This is a 10-character field and contains the next payment date for mortgage insurance for this loan. The date is entered in MM/DD/YYYY format.

NEXT MORTGAGE INSURANCE PAYMENT AMOUNT (MMINSAMT)

This is a numeric field and contains the amount of the next mortgage insurance payment. The maximum value is 9999999.99.

CURRENT MORTGAGE INSURANCE ESCROW AMOUNT (MMINSESC)

This numeric field contains the amount currently being collected with each mortgage payment to be escrowed for mortgage insurance.

LIFE INSURANCE COMPANY (MLINSCO)

This field contains a two-digit life insurance company number as assigned by the bank. If there is no life insurance, the field contains a zero. When entering a new mortgage record, pressing RETURN for this field indicates that there is no life insurance and automatically causes a zero to be entered in the field.

LIFE INSURANCE POLICY NUMBER (MLINSPO)

This field is 14 characters and contains the policy number of the life insurance.

LIFE INSURANCE BASE (mlinsb)

This field contains a one-digit code that indicates the method of calculation to be used for life insurance premiums. Valid codes are:

0 = Use Amount Entered

1 = Use Rate Times Current Balance

2 = Use Rate Times Last Anniversary Balance

LIFE INSURANCE RATE (MLINSRT)

This is numeric field and contains the life insurance rate. The format for this field is 99.9999%.

When entering a mortgage record, this field is requested only if life insurance is specified.

LIFE INSURANCE PAYMENTS PER YEAR (MLINSP)

This is a two-digit field that contains the number of life insurance payments to be made each year. e.g. 12 = monthly.

NEXT LIFE INSURANCE PAYMENT DUE DATE (MLINSDT)

This is a 10-character field and contains the next payment date for life insurance for this loan. The date is entered in MM/DD/YYYY format.

NEXT LIFE INSURANCE PAYMENT AMOUNT (MLINSAMT)

This is a numeric field and contains the amount of the next life insurance payment. The maximum value is 9999999.99.

CURRENT LIFE INSURANCE ESCROW AMOUNT (MLINSESC)

This numeric field contains the amount currently being collected with each mortgage payment to be escrowed for life insurance.

FIRE INSURANCE COMPANY (MFINSCO)

This field contains a two-digit fire insurance company number as assigned by the bank. If there is no fire insurance, the field contains a zero. When entering a new mortgage record, pressing RETURN for this filed indicates that there is no fire insurance and automatically causes a zero to be entered in the field.

FIRE INSURANCE POLICY NUMBER (MFINSPO)

This field is 14 characters and contains the policy number of the fire insurance.

FIRE INSURANCE BASE (MFINSB)

This field contains a one-digit code that indicates the method of calculation to be used for fire insurance premiums. Valid codes are:

0 = Use Amount Entered

1 = Use Rate Times Current Balance

2 = Use Rate Times Last Anniversary Balance

FIRE INSURANCE RATE (MFINSRT)

This is a numeric field and contains the fire insurance rate. The format for this field is 99.9999%.

When entering a mortgage record, this field is requested only if fire insurance is specified.

FIRE INSURANCE PAYMENTS PER YEAR (MFINSP)

This is a two-digit field that contains the number of fire insurance payments to be made each year. e.g. 12 = monthly.

NEXT FIRE INSURANCE PAYMENT DUE DATE (MFINSDT)

This is a 10-character field and contains the next payment date for fire insurance for this loan. The date is entered in MM/DD/YYYY format.

NEXT FIRE INSURANCE PAYMENT AMOUNT (MFINSAMT)

This is a numeric field and contains the amount of the next fire insurance payment. The maximum value is 9999999.99.

CURRENT FIRE INSURANCE ESCROW AMOUNT (MFINSESC)

This numeric field contains the amount currently being collected with each mortgage payment to be escrowed for fire insurance.

HEALTH INSURANCE COMPANY (MHINSCO)

This field contains a two-digit health insurance company number as assigned by the bank. If there is no health insurance, the field contains a zero. When entering a new mortgage record, pressing RETURN for this field indicates that there is no health insurance and automatically causes a zero to be entered in the field.

HEALTH INSURANCE POLICY NUMBER (MHINSPO)

This field is 14 characters and contains the policy number of the health insurance.

HEALTH INSURANCE BASE (MHINSB)

This field contains a one-digit code that indicates the method of calculation to be used for mortgage health premiums. Valid codes are:

0 = Use Amount Entered

1 = Use Rate Times Current Balance

2 = Use Rate Times Last Anniversary Balance

HEALTH INSURANCE RATE (MHINSRT)

This is a numeric field and contains the health insurance rate. The format for this field is 99.9999%.

When entering a mortgage record, this field is requested only if health insurance is specified.

HEALTH INSURANCE PAYMENTS PER YEAR (MHINSP)

This is a two-digit field that contains the number of health insurance payments to be made each year. e.g. 12 = monthly.

NEXT HEALTH INSURANCE PAYMENT DUE DATE (MHINSDT)

This is a 10-character field and contains the next payment date for health insurance for this loan. The date is entered in MM/DD/YYYY format.

NEXT HEALTH INSURANCE PAYMENT AMOUNT (MHINSAMT)

This is a numeric field and contains the amount of the next health insurance payment. The maximum value is 9999999.99.

CURRENT HEALTH INSURANCE ESCROW AMOUNT (MHINSESC)

This numeric field contains the amount currently being collected with each mortgage payment to be escrowed for health insurance.

STATE (MSTATE)

This field is a two-character code containing the postal abbreviation for the state in which the property is located.

PARCEL NUMBER (MSPARCEL)

This is an 11 character field containing the parcel number.

STATE TAX PAYMENTS PER YEAR (MSTAXP)

This is a two-digit code containing the number of tax payments to be made each year. i.e. 12 = monthly, 4 = quarterly, 2 = semi-annually, 1 = annually

NEXT STATE TAX PAYMENT DUE DATE (MSTAXDT)

This is a ten character field and contains the next payment date for state taxes for this mortgage. Enter MM/DD/YYYY format.

NEXT STATE TAX PAYMENT AMOUNT (MSTAXAMT)

This is a numeric field and contains the amount of the next state tax payment. The maximum value is 9999999.99.

CURRENT STATE TAX ESCROW AMOUNT (MSTAXESC)

This numeric field contains the amount currently being collected with each mortgage payment to be escrowed for state taxes.

COUNTY (MCOUNTY)

This is a two-character field containing the abbreviation or number of the county in which the property is located.

PARCEL NUMBER (MCPARCEL)

This is an 11 character field containing the parcel number.

COUNTY TAX PAYMENTS PER YEAR (MCTAXP)

This is a two-digit code containing the number of tax payments to be made each year. i.e. 12 = monthly, 4 = quarterly, 2 = semi-annually, 1 = annually

NEXT COUNTY TAX PAYMENT DUE DATE (MCTAXDT)

This is a ten character field and contains the next payment date for county taxes for this mortgage. Enter MM/DD/YYYY format.

NEXT COUNTY TAX PAYMENT AMOUNT (MCTAXAMT)

This is a numeric field and contains the mount of the next county tax payment. The maximum value is 9999999.99.

CURRENT COUNTY TAX ESCROW AMOUNT (MCTAXESC)

This numeric field contains the amount currently being collected with each mortgage payment to be escrowed for county taxes.

DISTRICT (MDISTR)

This is a two-character field containing the abbreviation or number of the district in which the property is located.

PARCEL NUMBER (MDPARCEL)

This is an 11 character field containing the parcel number.

DISTRICT TAX PAYMENTS PER YEAR (MDTAXP)

This is a two-digit code containing the number of tax payments to be made each year. i.e. 12 = monthly, 4 = quarterly, 2 = semi-monthly, 1 = annually

NEXT DISTRICT TAX PAYMENT DUE DATE 9MDTAXDT)

This is a ten character field and contains the next payment date for district taxes for this mortgage. Enter in MM/DD/YYYY format.

NEXT DISTRICT TAX PAYMENT AMOUNT (MDTAXAMT)

This is a numeric field and contains the amount of the next district tax payment. The maximum value is 9999999.99.

CURRENT DISTRICT TAX ESCROW AMOUNT (MDTAXESC)

This numeric field contains the amount currently being collected with each mortgage payment to escrowed for district taxes.

CITY (MTOWN)

This field is a two-character code containing the abbreviation or number of the city in which the property is located.

PARCEL NUMBER (MTPARCEL)

This is an 11 character field containing the parcel number.

CITY TAX PAYMENTS PER YEAR (MTTAXP)

This is a two-digit code containing the number of tax payments to be made each year. i.e. 12 - monthly, 4 = quarterly, 2 = semi-annually, 1 = annually

NEXT CITY TAX PAYMENT DUE DATE (MTTAXDT)

This is a ten character field and contains the next payment date for city taxes for this mortgage. Enter in MM/DD/YYYY format.

NEXT CITY TAX PAYMENT AMOUNT (MTTAXAMT)

This is a numeric field and contains the amount of the next city tax payment. The maximum value is 9999999.99.

CURRENT CITY TAX ESCROW AMOUNT (MTTAXESC)

This numeric field contains the amount currently being collected with each mortgage payment to be escrowed for city taxes.

The mortgage Loan Activity procedures provide functions to:

Enter new mortgages into the system.

Change existing mortgages.

Post mortgage loan transactions.

Review the current status of mortgage loan activity at any time.

Change the accrual dates in the system records. (This is an installation procedure and is not normally performed.)

Change rates for variable-rate loans

Throughout this section, you will be asked to select a particular function from the ACTIVITY portion of the menu:

MORTGAGE LOAN ACTIVITY

9. New Mortgage

10. Change Mortgage

11. Transaction

12. Activity Summary

13. Change Accrual Date

14. Change Variable Rates

This procedure is used to enter new mortgage loans into the system.

From the Mortgage Loan menu, enter 9 for New Mortgage. The system displays the prompt:

Customer Number: [ ]

Enter the customer number and press RETURN.

The system displays the customer information and lists all the customer's accounts. The following sample illustrates this display.

The system then prompts:

Mortgage Number: [ ]

Enter the mortgage number. The system then displays the customer number, mortgage number and name on the screen. Press RETURN and the system will fill out the screen as shown on the following page.

Enter data in each field of the mortgage loan records according to the definitions given in Section 13.2. Table 13.1 summarizes the data requested for each new mortgage loan.

After keying the data in each field, press RETURN to proceed to the next prompt. To skip an optional field, press RETURN only.

Since not all of the new mortgage loan data will fit onto a single display screen, the following screen will be displayed after all of the fields on the first screen have been filled:

After all of the fields on the second screen have been filled, the following will be displayed:

After all of the fields on the third screen have been filled, the following will be displayed:

After all of the fields on the fourth screen have been filled, the system will write the new mortgage to the mortgage file and display it in the normal inquiry format as shown below. At this point, the system allows you to enter a transaction. The customer information and mortgage information are displayed as well as the Transaction Code prompt.

To change customers, press RETURN only. To return to this customer's CIF display, enter 99 and press RETURN. To scan through a customer's mortgages, enter 98 and press RETURN. To view the transaction ledger for the mortgage, enter 97 and press RETURN. To enter a transaction, refer to Section 13.3.3 for a description of transaction entry.

This procedure is used to change information for an existing mortgage loan. This procedure can also be used to simply view the data defined for a mortgage.

This procedure displays the mortgage loan record in several screens. When each screen is displayed, you have three options:

1. To change an item on the screen.

2. To display the next screen.

3. To display another loan.

From the Mortgage Loan menu, select 10 for Change Mortgage. The system displays the Mortgage Loan Change Form, as follows:

Enter the customer number and press RETURN. If you do not know the customer number, press RETURN only; the system positions to the mortgage number prompt.

Enter the mortgage number for the mortgage you with to change. The system displays the customer name and the first portion of the mortgage loan record. The illustration on the following page is a sample of the display.

To change a field on the screen, enter the corresponding field number and press RETURN. If a password is required for the field you wish to change, the system will request it. Enter the password and press RETURN. The system positions to the DATA portion of the requested field. Refer to Section 13.2 for descriptions of the valid data contained in each field. Backspace to the beginning of the field, enter the correct data, and press RETURN. The system returns to the ENTER prompt.

There are nine screens to the Change Mortgage procedure. To display the next portion of the mortgage loan record, press RETURN. The next screen is displayed with the cursor positioned to the ENTER prompt.

Once you have changed the field or fields required, there is no need to page through the rest of the record. To display a different mortgage, enter 999 and press RETURN. To terminate the procedure, perform an ESCAPE and the system will return to the Mortgage Loan menu.

The change procedure may also be entered for a particular mortgage by entering a transaction code of 96 from the mortgage inquiry screen. If the change procedure is entered in this manner, pressing CANCEL at the end of the first change page or an entry of 999 at the end of any page will cause the system to return to mortgage loan inquiry display.

This procedure is used to post transactions that are stored in the Transaction file. The Transaction file is then used to print the Transaction Journal and to prepare the Customer Ledger.

This procedure performs a variety of functions based on the specified transaction code. The Mortgage Loan transaction codes are:

From the Mortgage Loan menu, enter 11 for Transaction. The system displays:

Customer Number: [ ]

Enter the customer number and press RETURN. You can press RETURN only to enter the transaction by mortgage number. When a customer number is entered, the system displays the customer information. The following is a sample of the display.

The system then displays the prompt:

Mortgage Number: [ ]

Enter the mortgage number and press RETURN. The system then displays the mortgage information as follows:

The system then displays the prompt:

Transaction Code: [ ]

Enter the desired transaction code and press RETURN. After the transaction code is specified, the system displays a transaction distribution window on the screen as follows:

If the distribution is correct as shown, enter "Y" and press RETURN. Otherwise, enter an "N" to change the distribution. Press CANCEL to cancel the transaction.

At this point, four other options are available:

1. To enter a transaction for a different mortgage for this customer, enter 99 and press RETURN. The system returns to the customer display and requests another mortgage number.

2. To enter a transaction for another customer, press RETURN only. The system clears the screen and displays the Customer Number prompt.

3. To view the transaction ledger for this mortgage, enter 97 and press RETURN.

4. To make changes to this mortgage, enter 96 and press RETURN.

This procedure is used to review the current status of mortgage loan activity. This procedure displays a list of all the various transaction types and shows the number and amount of each transaction type entered thus far today and for the previous day. Also, the display shows the loan balance as of the last transaction and as of the last close of business.

From the Mortgage Loan menu, enter 12 for Activity Summary. The system automatically displays the activity summary on the screen as follows:

The display takes more than one screen, so press RETURN to page through it. After viewing the Activity Summary screen, press RETURN to return to the Mortgage Loan menu.

The Change Accrual Date procedure changes the accrual dates in the system control record. This procedure is only used at installation time prior to entering mortgages and transactions for first day processing.

CAUTION: Changing the accrual dates can effect the bank accruals. Therefore, only use this procedure as directed.

From the Mortgage Loan menu, enter 13 for Change Accrual Date. The system displays:

LAST ACCRUE DATE: MM/DD/YYYY [ ]

NEXT ACCRUE DATE: MM/DD/YYYY [ ]

The dates that are displayed are the current dates that exist in the system control record.

To change the last accrue date, perform a DELETE to position to the beginning of the field. Then enter the correct date in MM/DD/YYYY format.

To change the next accrue date, perform a DELETE again to position to the beginning of the field. Then enter the correct date in MM/DD/YYYY format.

The system displays the prompt:

ARE YOU SURE?

If your entries are correct, enter YES and press RETURN. The system displays the message CHANGED momentarily and then returns to the Mortgage Loan menu.

NOTE: This procedure only changes the dates in the control record, not the current active date in the system. To change the active system date, you must return to the BANCADO main menu (selection 99) and then return to the Mortgage Loan menu.

To terminate the procedure without changing the dates, press RETURN only. The system returns to the Mortgage Loan menu.

This procedure changes the rates on variable interest rate mortgages according to the RATE CODE field in the mortgage loan record and prints a record of the changes. The rate change takes effect when the Transaction Journal is next run as an update. Since a non-update option is available, the report may be run at any time to determine what effect a proposed rate change would have without actually changing any interest rates.

From the Mortgage Loan menu, enter 14 for Change Variable Rates. The system displays:

CHANGE VARIABLE RATES

For Mortgages with Rate Code: [ ]

Change the rate to:

Or increase (decrease) the rate by:

To a maximum rate of:

Should any participant rate be changed too? (Y/N):

Print report only? (Y/N):

Enter the rate code assigned to the mortgages for which you wish to change rates and press RETURN.

The system positions the cursor to the Change the Rate prompt. The system waits for the entry of the new rate for the mortgages with the code entered above. Enter the new rate in the 99.9999 format. If you want an increase or decrease in the rate, press RETURN without making an entry.

If no new rate is entered, the system positions to the Increase (Decrease) the Rate prompt. If you wish to increase the rate on all mortgages with the rate code entered, enter the increase in the percentage rate in the format 99.9999. If you wish to decrease the rate, precede the entry with a minus sign (-).

The system next positions the cursor to the Maximum Rate prompt. If there is no maximum rate for the rate code specified, simply press RETURN without entering a maximum. Otherwise, enter the maximum rate in the format 99.9999.

Next, the cursor is positioned to the Participant Rate prompt. Enter a Y or an N depending on the action required regarding any participant rates in the affected mortgages.

When the cursor is positioned to the Print Report Only prompt, enter "Y" to print the rate change report without actually changing any rates on the file. Enter "N" to print the report while the file is being changed.

Upon completion of the last entry, the system begins to print the report as shown on the following page and returns to the Mortgage Loan menu. Note that the heading report indicates whether or not the file has actually been changed by specifying either "Update Run" or "Non-update Run" on each page.

The Mortgage Loan system produces a variety of reports. Most reports can be generated on an optional basis, with the exception of the Transaction Journal. The Transaction Journal must be generated as an update run at the end of each day after all activity has been entered. When this report is generated as an update, the system date is advanced and the necessary interest and insurance calculations are made.

Throughout this section you will be asked to select a particular function from REPORTS portion of the Mortgage Loan menu. The following is an example of this portion of the menu.

20. Transaction Journal

21. Trial Balance

22. Participation Register

23. Past Due Report

24. Paid Out Report

25. New & Extended Report

26. Escrow Reports

27. Call Report

28. Print Amortization

29. Delinquency Report

30. Change Print Size

This report is a journal of the transactions entered for the current day. Optionally, this procedure updates the interest accrual for the day in the Mortgage Loan file.

Normally, a Transaction Journal is printed once each day, and at least one update run per day is required for proper interest accrual. Because the file update portion of the procedure is optional, a Transaction Journal can be produced without the update option at any time during the day to indicate the current status of transaction activity for the day.

From the Mortgage Loan menu, enter 20 for Transaction Journal. If the system date is not the same as the next scheduled accrual date, the system starts to print the Transaction Journal and displays the Mortgage Loan menu.

When the system date is the correct accrual date, the system displays the prompt:

Is this an update run? (Y/N): [ ]

To update the interest accrued for the day, enter a "Y" and press RETURN. The system displays the prompt:

Today is MM/DD/YYYY. Enter the next working date: [ ]

Enter the next date that the bank will be open. The system then determines the number of days for which interest is to be accrued.

To cut off a month, quarter, or year in the middle of a weekend, you can run a separate update for the portion of the weekend after the cutoff in order to obtain an accurate cutoff on accruals.

After the date is specified, the system prints the Transaction Journal.

CAUTION: If, for some reason, the report does not complete and an update run has been requested, you must not restart the procedure. You must reload backup files and start the procedure from the beginning.

To print the Transaction Journal without updating the accrual date, enter an "N" in response to the Is This An Update Run? prompt.

The system starts to print the report as shown below and displays the Installment Loan menu.

This report prints a Trial Balance of all outstanding mortgage loans. The Trial Balance can be generated in the following sequences:

• Active Mortgages by Name
• Active Mortgages by Customer Number
• Active Mortgages by Mortgage Number
• Active Mortgages by Name within Type
• Active Mortgages by Customer Number within Type
• Active Mortgages by Mortgage Number within Type
• All Mortgages by Name
• All Mortgages by Customer Number
• All Mortgages by Mortgage Number
• All Mortgages by Name within Type
• All Mortgages by Customer Number within Type
• All Mortgages by Mortgage Number within Type

Bank totals are printed at the end of the report. For reports that are printed in customer number or name sequence, sub-totals are printed for each customer.

Normally, a trial balance is printed after the Transaction Journal procedure performs an update. Thus, the Trial Balance is run at the close of business each day, and the report can be saved for bank records.

Because the Trial Balance procedure does not update any disk files, the report can be printed any time during the day. When the procedure is run prior to the Transaction Journal update run, the principal balances shown on the report are current as of the time of the run, but the interest balances are current as of the close of the preceding business day.

From the Mortgage Loan menu, enter 21 for Trial Balance. After selection of 21, the system requests the sequence in which to print the report, as follows:

Enter the number of the desired sequence and press RETURN.

The system starts to print the Trial Balance in the specified sequence and displays the Mortgage Loan menu.

This procedure prints a Participation Register with balance and transaction totals for the month for each participant.

From the Mortgage Loan menu, enter 22 for Participation Register. After selection of 22, the system requests the sequence in which to print the report

1. Customer Name

2. Mortgage Number

3. Customer Number

Enter the number of the desired sequence and press RETURN.

The system starts to print the Participation Register and displays the Mortgage Loan menu on the screen.

This report lists all Mortgage Loans that are one or more days past due as specified by the computer operator at the time the report is run. The past-due mortgages can be sorted by customer name or by assigned officer. There is also a special report of those mortgages becoming delinquent on the date the report is run.

Bank past due totals are printed at the end of the report. If the report is sorted by customer, past due sub-totals are printed for each customer with multiple past due loans. If the report is sorted by officer, past due sub-totals are printed for each officer.

Mortgages and totals are printed in the following categories:

1 to 30 days past due

31 to 60 days past due

61 to 90 days past due

91 to 120 days past due

Over 120 days past due

From the Mortgage Loan menu, enter 23 for the Past Due Report. After selection of 23, request the type of report as follows:

Report type: [ ]

1. Alphabetic Past Due Report

2. Officer Past Due Report

3. New Past Due Report

Enter the number of the desired type and press RETURN.

Except for the Officer Past Due Report, the system displays

Spread B-Balance or P-Payments

Enter "B" if Mortgage Balances are to be spread to the various categories. Enter "P" if the delinquent payment amounts are to be spread. (For the Officer Past Due Report, payment amounts are automatically spread.)

The system displays:

Past-due loans were due prior to:

Enter the date in MM/DD/YYYY format and press RETURN.

The system starts to print the report as shown below and displays the Mortgage Loan menu.

This report lists all mortgage loans that were paid off either today or so far this month. The operator selects which payoff period is to printed.

This report can be printed at any time after a Transaction Journal update. Normally, it is printed at the end of each business day and at the end of each month.

From the Mortgage Loan menu, enter 24 for Paid Out Report. After selection of 24, the system requests which period is to be reported, as follows:

DAILY OR MONTHLY REPORT? (D OR M) [ ]

Enter D to list all notes paid off today; enter M to list all notes paid off this month. Press RETURN.

The system starts to print the report as shown below and displays the Mortgage Loan menu.

This report lists all mortgage loans that were entered either today or so far this month. The operator selects which period is to be printed.

This report can be printed at any time. Normally, it is printed at the end of each business day prior to the Transaction Journal update and at the end of each month.

From the Mortgage Loan menu, enter 25 for the New Mortgage Report. After selection of 25, the system requests which period is to be reported as follows:

Do you want a Daily or Monthly Report? (D/M): [ ]

Enter "D" to list all new mortgages that were entered today or enter "M" for all new mortgages entered so far this month and press RETURN.

The system begins to print the report as shown below and the Mortgage Loan Menu is displayed.

Escrow reports are available for the proper management of individual escrow accounts. From the Mortgage Loan menu, select menu item number 26 for Escrow Reports and press RETURN.

The system will then ask which escrow report is required as follows:

1. Escrow Balance Report

2. Escrow Analysis Report

3. Payments from Escrow Report

Enter number of required report: [ ]

The Escrow Balance Report (selection 1) prints a Trial Balance of current escrow balances. The Escrow Analysis Report (selection 2) analyzes each mortgage on file to determine that the current escrow balance plus scheduled escrow payments will be sufficient to pay upcoming payments from escrow and recommends customer payment changes. The Payments from Escrow Report (selection 3) prepares a list of tax and insurance payments to be made during the coming month.

Enter the selection of the report required and press RETURN. The system will begin to print the requested report and return to the Mortgage Loan menu.

The Call Report prints loan totals (excluding participant amounts) by Federal Reserve call code. This report includes a past due spread by call code.

The Call Code report can be generated whenever a request is made for the information.

From the Mortgage Loan menu, enter 27 for Call Report. After selection of 27, the system begins printing the Call Report and displays the Mortgage Loan menu.

This procedure is used to print amortization schedules for mortgage loans. It can print complete schedules for new loans not yet on the system or remaining schedules for loans already in existence.

To initiate the procedure, select item number 28 from the Mortgage Loan menu and press RETURN. The system will display the following form on the screen:

The cursor is positioned after the name of your institution in the Lender Name field. Make sure that the lender name is correct and press RETURN. Then enter the Customer Number and press RETURN. If a customer with the number entered is on file, that customer's name and address will be displayed. Otherwise, you will have to key the name and address data. Press RETURN after each field requested.

Enter the Mortgage Loan Number and press RETURN. If a mortgage loan for the loan number entered is already on file, the current information will be displayed from the mortgage loan file. Otherwise, you will have to enter data in resp9onse to each of the prompts as follows:

Mortgage Amount: Enter the amount you wish amortized. This may be the current balance of the mortgage rather than the original amount.

Note Date: Enter the date the amortization is to begin in the format MM/DD/YYYY. If the schedule is for the remainder of an existing loan, this will be the date of the last payment.

Annual Percentage Rate: Enter the interest rate the customer is to pay in the format 99.9999%.

First Payment Date: Enter the date that the first payment will be due in the format MM/DD/YYYY.

Mortgage Insurance Rate: Enter the annual rate for Mortgage Insurance in the format of 99.9999%.

Payment per Year: Enter the number of payments to be schedule per year. e.g. 12 for monthly payments, 4 for quarterly payment, etc.

Options: The following prompts will appear as necessary. In no case will all of them appear for the same amortization schedule request.

Enter a "D" for a double-spaced schedule:

Type "D" for double spacing. Otherwise press RETURN.

Enter a "C" if the computer is to calculate the payment amount:

Type "C" if the payment amount has not been established. Otherwise press RETURN.

Enter the number of payments:

Type the total number of payments remaining on the loan.

Enter the payment amount:

Type the pre-established payment amount.

Enter a "P" if the payment amount entered is principal only and you want a fixed-principal schedule:

Fixed-principal schedules require a payment consisting of a fixed amount of principal plus interest. The payment amount will therefore decrease throughout the schedule as the interest amount decreases due to the decreasing balance.

If you want the note paid off after a certain number of payments, enter how many, otherwise press RETURN:

Entering a payment number in this field will cause a balloon payment equal to the remaining balance to be scheduled with that payment.

Enter an "A" for annual insurance calculation:

If you enter an "A" the mortgage insurance payment amount will be the same for each twelve month period and then be recalculated based on the scheduled balance at that time. If you press RETURN without entering an "A" the mortgage insurance payment will be recalculated for each payment based on the scheduled balance on the payment date and will therefore decrease with every payment.

Enter a "P" for a participation schedule:

If participant principal and interest figures are to be printed for each payment enter a "P". Otherwise press RETURN.

Enter a "C" to have the computer calculate the participant payment:

Type "C" if the participant payment amount has not been established. Otherwise press RETURN.

Enter the participant amount:

Enter the balance of the amount of the loan sold.

Enter the participant payment:

Enter the amount of each scheduled payment to be forwarded to the participant and press RETURN.

Enter the participant rate:

Enter the annual interest rate to be paid to the participant. This rate is included in the Annual Percentage Rate, not in addition to it.

Enter a "p" to have the participant paid off first:

If all principal payments received are to be applied to the participant balance until it is zero, enter a "P". Otherwise press RETURN and principal payments will be split between the bank and the participant using the same ratio as the bank and participant balance.

There are nnn days between the note date and the first payment. Enter a "D" if you want interest on the first payment figured on a daily basis:

If you want a normal periodic interest charge applied to the first payment period even though it is not a normal length, press RETURN without making an entry. Enter a "D" and press RETURN if you want the first payment's interest charged for the actual number of days in the period.

After responses have been made to all applicable prompts, the system will begin printing the schedule and will return to the Mortgage Loan menu. An example of an amortization schedule is shown below.

The Delinquency Management Report is a summary listing of delinquent mortgages by office and type. With delinquencies listed as percentages of various totals, it is a useful tool in determining problem areas of mortgage collection.

From the Mortgage Loan menu, enter 29 for Delinquency Report. The system will display:

Press RETURN to proceed: [ ]

Press RETURN and the system will start to print the report and display the Mortgage Loan menu.

The Mortgage Loan system produces customer notices that are sent directly to the customer.

Advance, Late, Delinquency and Automatic Payment notices are normally produced once a week. Payment Coupons are normally produced annually.

The Mortgage Statements are normally generated once a year, at the end of the year.

Throughout this section you will be asked to select a particular function from the CUSTOMER NOTICES portion of the Mortgage Loan menu. The following is an example of this portion of the menu:

40. Advance Notices

41. Late Notices

42. Delinquency Notices

43. Automatic Payment Notices

44. Payment Coupons

45. Mortgage Statements

13.5.1 ADVANCE MORTGAGE PAYMENT NOTICES

INSERT SAMPLE ADVANCE MORTGAGE LOAN PAYMENT NOTICE HERE

13.5.2 MORTGAGE LOAN LATE NOTICES

INSERT SAMPLE MORTGAGE LOAN LATE NOTICE HERE

13.5.3 MORTGAGE LOAN DELINQUENCY NOTICES

INSERT SAMPLE MORTGAGE LOAN DELINQUENCY NOTICE HERE

13.5.4 AUTOMATIC MORTGAGE PAYMENT NOTICES

INSERT SAMPLE MORTGAGE LOAN AUTOMATIC PAYMENT REPORT HERE

13.5.5 MORTGAGE LOAN PAYMENT COUPONS

INSERT SAMPLE MORTGAGE LOAN COUPONS HERE.

6. MORTGAGE LOAN STATEMENTS

INSERT SAMPLE MORTGAGE LOAN STATEMENT HERE.

5. MORTGAGE LOAN FILE INQUIRIES

1. Customer/Loan Inquiry
2. Display Ledger
3. Print Ledger

13.6.1 CUSTOMER/LOAN INQUIRY

INSERT SAMPLE INQUIRY SCREEN HERE

INSERT SAMPLE MORTGAGE LOAN INQUIRE HERE

2. DISPLAY MORTGAGE LOAN LEDGER

The Display Ledger procedure displays the current year's account activity for a particular customer of for a single mortgage loan.

From the Mortgage Loan Menu, enter a 6 for Display Ledger and press RETURN. After the selection of item 6, the system displays the prompt:

Customer/Mortgage Number: []

Enter the number of the customer or mortgage to be displayed and press RETURN. The system then displays the first page of the ledger on the screen. The following is an example of the information displayed.

INSERT SAMPLE MORTGAGE LOAN LEDGER DISPLAY HERE

 

After viewing the data, press RETURN to view the next page of the ledger or to return to the Display Ledger prompts after the last page. You may bypass viewing any remaining pages of the ledger by pressing the CANCEL or ESCAPE key at any time.

The ledger for an individual mortgage may also be viewed by entering a transaction code 97 from the mortgage loan inquiry screen. If a ledger is displayed in this manner, pressing CANCEL at the end of a page or pressing RETURN after the final page will cause the system to return to the mortgage loan display.

 

3. PRINT MORTGAGE LOAN LEDGER

INSERT SAMPLE PRINTED MORTGAGE LOAN LEDGER HERE

6. UTILITIES

0. Display File Status
1. Compress File
2. Edit Control Records
3. Change Year-to-date Interest
4. Delete Paid Mortgages
5. Print and Purge Old History
6. Build Lookup File
7. Just Ask
8. Change Applications

1. DISPLAY FILE STATUS

This utility produces a display of information about a mortgage loan data file. This information can be used to determine if the file needs to be compressed or resized. In exceptional cases, the information may also indicate that data records have been lost. An example of a file status display is shown below.

INSERT A FILE STATUS DISPLAY HERE

 

2. COMPRESS FILE

Routine file editing procedures such as deleting records and changing record lengths can create temporarily unusable storage space in a data file. As a consequence, the time required to retrieve records and the likelihood of overflowing the file are increased. The Compress File Utility rearranges data space, reclaiming most of the unusable area.

The Display File Status Utility (Section 13.7.1) is available to indicate whether a file needs compression. However, there is no harm in compressing a file which does not actually need it, and compression is generally run as a routine maintenance procedure. Some BANCADO application programs compress files automatically as noted in this manual.

File compression is one of the operations that can damage data if interrupted by the operator or by hardware failure. It is mandatory to obtain a backup immediately prior to compressing a file.

NOTE: Sort work files cannot be compressed.

To compress Mortgage Loan files, select item number 2 from the Mortgage Loan BANCADO Utilities Menu and press RETURN.

The system displays:

FILE COMPRESSION

ENTER FILE NO. []

Enter the number of the desired file. The files you may compress are as follows:

1 - Customer Information File

2 - Mortgage Description File

3 - Escrow File

4 - Mortgage Accounting File

7 - Mortgage Transaction File

8 - Name Lookup File

9 - Mortgage Number Lookup File

The system compresses the file. Upon completion, the system displays:

DONE

Press RETURN to use this utility again or perform an ESCAPE function to return to the Mortgage Loan Menu.

 

3. EDIT MORTGAGE LOAN CONTROL RECORDS

This utility is normally used only by a BANCADO representative during system installation and during program updates. It is used to create and/or update special control records which contain control information such as balance and transaction totals and are maintained in the transaction file, file 7.

To change the control records, select item number 3 for Edit Control Records from the Mortgage Loan BANCADO Utilities Menu and press RETURN. The system displays the current bank totals. For each item, press RETURN to accept the value or DELETE to enter a new value. The following is a sample of the display:

INSERT SAMPLE EDIT BANK CONTROL TOTALS SCREEN HERE

After all of the bank totals have been entered, the system displays the transaction codes and descriptions. For each item, press RETURN to accept the code or enter a new code. The following screen is a sample of the display:

INSERT SAMPLE EDIT TRANSACTION CONTROL RECORD SCREEN HERE

When all modifications are complete, press RETURN to return to the Mortgage Loan Menu.

 

4. CHANGE MORTGAGE LOAN YEAR-TO-DATE INTEREST

Although the capability to change year-to-date interest figures is available through the normal Change Mortgage Loan function, this procedure is provided because there may be a need to load year-to-date interest figures for all mortgage loans at conversion time and this procedure is much easier to use.

To perform the Change Year-to-date Interest function, select item number 4 from the Mortgage Loan BANCADO Utilities Menu and press RETURN. The system will display the following screen:

INSERT SAMPLE CHANGE YTD INTEREST SCREEN HERE

Enter the mortgage loan number and press RETURN. The system will display the customer's name and the amounts for the specified mortgage. The system will request "Net Change" amounts for each of the fields shown. Any or all of the amounts may be preceded by a minus sign to decrease the figure on file unless the resulting amount would be negative. To leave a filed unchanged, press RETURN without an entry.

To proceed to the next mortgage without making a change, press the CANCEL key. To terminate the procedure and return to the Mortgage Loan Menu, perform an ESCAPE.

 

5. DELETE PAID MORTGAGES

13.7.6 PRINT AND PURGE MORTGAGE LOAN HISTORY

7. BUILD MORTGAGE LOAN LOOKUP FILE