FCT_BNK_RMRT_ACCT_ACCOUNT_INSIGHT
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | MEMBER | CHARACTER VARYING(7) | 7 |
| 2 | DATA_MONTH | CHARACTER VARYING(200) | 200 |
| 3 | LOAN_NBR | CHARACTER VARYING(9) | 9 |
| 4 | ACCOUNT_KEY | CHARACTER VARYING(10) | 10 |
| 5 | EXISTING_CUSTOMER | CHARACTER VARYING(3) | 3 |
| 6 | PRODUCT_DESCRIPTION | CHARACTER VARYING(40) | 40 |
| 7 | ACCOUNT_TYPE | CHARACTER VARYING(1) | 1 |
| 8 | ACCOUNT_CATEGORY | NATIONAL CHARACTER VARYING(100) | 100 |
| 9 | LOAN_PURPOSE_RMRT | CHARACTER VARYING(4) | 4 |
| 10 | REPAYMENT_TYPE | CHARACTER VARYING(5) | 5 |
| 11 | INTEREST_RATE | CHARACTER VARYING(3) | 3 |
| 12 | LAST_CREDIT_DECISION | CHARACTER VARYING(200) | 200 |
| 13 | PAYMENTS | NUMERIC(20,2) | 19 |
| 14 | REPAYMENT_DUE | NUMERIC(20,2) | 19 |
| 15 | LOAN_EXPIRY | CHARACTER VARYING(200) | 200 |
| 16 | LOW_DOC | CHARACTER VARYING(1) | 1 |
| 17 | ORIGINATING_CHANNEL | CHARACTER VARYING(3) | 3 |
| 18 | LVR_LATEST | NUMERIC(20,2) | 19 |
| 19 | LVR_CURRENT | NUMERIC(20,2) | 19 |
| 20 | OUTSTANDING | NUMERIC(20,2) | 19 |
| 21 | CREDIT_LIMIT | NUMERIC(20,2) | 19 |
| 22 | STATUS | CHARACTER VARYING(3) | 3 |
| 23 | PAYMENTS_AHEAD | CHARACTER VARYING(2) | 2 |
| 24 | IMPAIRED | CHARACTER VARYING(1) | 1 |
| 25 | HARDSHIP | CHARACTER VARYING(1) | 1 |
| 26 | MORTGAGEE_IN_POSSESSION | CHARACTER VARYING(1) | 1 |
| 27 | MIP_DATE | CHARACTER VARYING(200) | 200 |
| 28 | FIRST_HOME_BUYER | CHARACTER VARYING(1) | 1 |
| 29 | CONFORMING_LOAN | CHARACTER VARYING(1) | 1 |
| 30 | NEW_SETTLEMENT | CHARACTER VARYING(1) | 1 |
| 31 | ACCOUNT_APPLICATION_KEY | CHARACTER VARYING(20) | 20 |