FCT_BNK_MORTG_INS_ARREARS_RPT
Description
Target Objects (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | INSURANCE_COMPANY_CODE | CHARACTER VARYING(80) | 80 |
| 2 | POLICY_NUMBER | CHARACTER VARYING(254) | 254 |
| 3 | BORROWER_SURNAME | CHARACTER VARYING(250) | 250 |
| 4 | BORROWER_FIRSTNAME | CHARACTER VARYING(50) | 50 |
| 5 | LOAN_ACCOUNT_NUMBER | CHARACTER VARYING(40) | 40 |
| 6 | PERIOD_DT | TIMESTAMP | 8 |
| 7 | SCHEDULED_PYMT_AMT | NUMERIC(38,18) | 19 |
| 8 | PAYMENT_FREQUENCY | CHARACTER VARYING(7) | 7 |
| 9 | TOTAL_ARREARS_AMT | NUMERIC(38,16) | 19 |
| 10 | APPROX_MNTHS_IN_ARREARS | INTEGER | 4 |
| 11 | CURRENT_INS_LOAN_BALANCE | NUMERIC(38,16) | 19 |
| 12 | COLLECTION_CASE_TYPE_DESCR | CHARACTER VARYING(60) | 60 |
| 13 | COLLECTION_CASE_STATUS_DESCR | CHARACTER VARYING(60) | 60 |
| 14 | HARDHSIP_ASSIST_OFFERED | CHARACTER VARYING(3) | 3 |