HOG_CCI_DATA_ALL
Description
Synonyms
SDSNZP02_BANK..BNKNIC_HOG_CCI_DATA_ALL
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | KEY_ACCT | NUMERIC(9,0) | 19 |
| 2 | LOAN_NBR | CHARACTER VARYING(9) | 9 |
| 3 | LOAN_PROD | CHARACTER VARYING(100) | 100 |
| 4 | ORIG_INS_AMT | NUMERIC(31,2) | 19 |
| 5 | POLICY_EXPIRE_DATE | DATE | 4 |
| 6 | PREMIUM_AMOUNT | NUMERIC(31,2) | 19 |
| 7 | INS_CANCEL_DATE | DATE | 4 |
| 8 | INS_CALC_TYPE | CHARACTER VARYING(100) | 100 |
| 9 | INS_SEQ_NO | CHARACTER VARYING(100) | 100 |
| 10 | NAME_OF_INSURED | CHARACTER VARYING(200) | 200 |
| 11 | POLICY_EFF_DATE | DATE | 4 |
| 12 | INS_COVER_CODE | CHARACTER VARYING(100) | 100 |
| 13 | POLICY_STATUS | CHARACTER VARYING(100) | 100 |
| 14 | SUM_INS_AMT | NUMERIC(31,2) | 19 |
| 15 | FUND_UTILISED | CHARACTER VARYING(100) | 100 |
| 16 | STATE_OF_JURSDCTN | CHARACTER VARYING(100) | 100 |