Computed columns

This section contains a list of the computed columns created by the Universal Calculation Library for the lp_calc block, as well as the data each column contains.

The Universal Calculation Library makes many calculations to arrive at the final data summaries it outputs. All columns computed by the library are prefixed with the text: mbs_calc_.
Note: This prefix is omitted from the column names in this dictionary for brevity and clarity of the naming convention.
Note: To see which columns are added prior to the final summaries, use the notab input.

Column definitions

prev_bal
The balance from the previous month.
prev_inv_bal
The investor balance from the previous month.
prev_last_int_p
The P&I from the previous month.
prev_loss_amt
The loss from the previous month.
loss_ch_amt
The change in loss from the previous month.
cum_loss_loan
The Cumulative loss on the loan.
active
A loan is considered active when the exception field is not equal to 6.
mod_loss
mod_loss is a boolean column indicating whether the loss on the loan was due to a modification.
isjudicial
Contains a boolean value indicating whether a state requires a judge to intervene before foreclosure.
last_loss
The loss on the loan at the time of payoff.
payoff_date
Adjusts the payoff_d column to the first of the month.
orig_year
The year the loan originated in the format: YYYY.
orig_month
The month and year the loan originated in the format: YYYYMM.
age
The number of months between the orig_month and the current month.
comb_ltv_clean
The comb_ltv_clean column is the maximum value of comb_ltv and ltv.
is_pmi
The loan has a PMI.
is_seclien
The loan is a second lien.
is_io
The loan is an Interest Only loan.
io_period_months
Contains the IO Period as extracted from the loan type description.
io_end
The date of the last IO month.
prod_type_clean
A description of the product type based on the interest type.
hpa
The hpa is the home price appreciation calculated as the percent change in the selected HPI index between origination and the current date.
Type Flag Columns
The UCL creates a number of flag columns that indicate the type of loan based on rate or life span. The following columns will contain a 1 for loans which fit the description and a 0 for loans that do not:
  • type_fixed
  • type_mta
  • type_arm
  • type_2yr
  • type_3yr
  • type_5yr
  • type_7yr
  • type_10yr