FCT_BNK_CCI_DATA
Description
Target Objects (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | INS_ID | CHARACTER VARYING(20) | 20 |
| 2 | INSURED_AMOUNT | DOUBLE PRECISION | 8 |
| 3 | NOMINATED_ACCOUNT | CHARACTER VARYING(50) | 50 |
| 4 | PREMIUM_AMOUNT | DOUBLE PRECISION | 8 |
| 5 | ACCOUNT_CLOSURE_DATE | TIMESTAMP | 8 |
| 6 | PLCY_CANCEL_DATE | TIMESTAMP | 8 |
| 7 | COVER_END_DATE | TIMESTAMP | 8 |
| 8 | COVER_START_DATE | TIMESTAMP | 8 |
| 9 | MIN_DATE | TIMESTAMP | 8 |
| 10 | MATURITY_DATE | TIMESTAMP | 8 |
| 11 | REASON | CHARACTER VARYING(7) | 7 |
| 12 | COVER | CHARACTER VARYING(1) | 1 |
| 13 | ACC_CLOSE | CHARACTER VARYING(1) | 1 |
| 14 | CANCEL | CHARACTER VARYING(1) | 1 |
| 15 | BORR_COUNT | BIGINT | 8 |
| 16 | DISB_COV | NUMERIC(38,0) | 19 |