Instrument table column name changes
Some physical column names in account-data instrument tables are modified to support new functionality and improve nomenclature.
Table 11-3 Instrument table column name changes
| Category | Old column name | New column name |
|---|---|---|
| Balance | ACCRUED_GROSS_AMT | ACCRUED_INTEREST_GROSS |
| Balance | ACCRUED_INTEREST | ACCRUED_INTEREST_NET |
| Derivative | MIN_BAL_AMORT | AMORT_MIN_BAL |
| Interest Rate | INT_TYPE | INTEREST_TIMING_TYPE_CD |
| Mortgage Offset | EXPECTED_BAL | MOA_EXPECTED_BAL |
| Mortgage Offset | EXPECTED_BAL_GROWTH_PCT | MOA_EXPECTED_BAL_GROWTH_PCT |
| Mortgage Offset | LRD_OFFSET_BAL | MOA_LRD_OFFSET_BAL |
| Mortgage Offset | MINIMUM_BALANCE | MOA_MIN_BAL |
| Mortgage Offset | OFFSET_ACCT_NBR | MOA_OFFSET_ACCT_NBR |
| Mortgage Offset | OFFSET_FLG | MOA_OFFSET_FLG |
| Mortgage Offset | OFFSET_PERCENT | MOA_OFFSET_PERCENT |
| Mortgage Offset | ORIG_OFFSET_BAL | MOA_ORG_OFFSET_BAL |
| Negative Amortization | PMT_ADJUST_DATE | NEG_AMRT_PMT_ADJUST_DATE |
| Negative Amortization | PMT_CHG_FREQ | NEG_AMRT_PMT_CHG_FREQ |
| Negative Amortization | PMT_CHG_FREQ_MULT | NEG_AMRT_PMT_CHG_FREQ_MULT |
| Negative Amortization | PMT_DECR_CYCLE | NEG_AMRT_PMT_DECR_CYCLE |
| Negative Amortization | PMT_DECR_LIFE | NEG_AMRT_PMT_DECR_LIFE |
| Negative Amortization | PMT_INCR_CYCLE | NEG_AMRT_PMT_INCR_CYCLE |
| Negative Amortization | PMT_INCR_LIFE | NEG_AMRT_PMT_INCR_LIFE |
| Payment | PMT_FREQ | INT_PMT_FREQ |
| Payment | PMT_FREQ | PRIN_PMT_FREQ |
| Payment | PMT_FREQ_MULT | INT_PMT_FREQ_MULT |
| Payment | PMT_FREQ_MULT | PRIN_PMT_FREQ_MULT |
| Payment | LAST_PAYMENT_DATE | LAST_INT_PAYMENT_DATE |
| Payment | LAST_PAYMENT_DATE | LAST_PRIN_PAYMENT_DATE |
| Payment | NEXT_PAYMENT_DATE | NEXT_INT_PAYMENT_DATE |
| Payment | NEXT_PAYMENT_DATE | NEXT_PRIN_PAYMENT_DATE |
| Payment | ORG_PAYMENT_DATE | ORG_INT_PAYMENT_DATE |
| Payment | ORG_PAYMENT_DATE | ORG_PRIN_PAYMENT_DATE |
| Payment | Not Applicable | BEHAVIOUR_PATTERN_CD |
| Payment | Not Applicable | PMT_PATTERN_CD |
| Payment | REMAIN_NO_PMTS_C | REMAIN_NO_PMTS |
| Repricing | MARGIN_GROSS | INT_RATE_MARGIN_GROSS |
| Repricing | MARGIN | INT_RATE_MARGIN_NET |
| Repricing | Not available | REPRICE_PATTERN_CD |
| Teaser | FIRST_RESET_CAP | TEASER_FIRST_RESET_CAP_RATE |
| Teaser | FIRST_RESET_FLOOR | TEASER_FIRST_RESET_FLOOR_RATE |
| Transfer Rate | ACCRUED_TRANSFER_AMT | ACCRUED_INTEREST_TP |