FCT_COMPLAINTS_INSIGHT
Description
Synonyms
SDSNZP02_BANK..AS516_FCT_COMPLAINTS_INSIGHT
SDSNZP02_BANK..EFS_FCT_COMPLAINTS_INSIGHT
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | COMPLAINT_ID | CHARACTER VARYING(100) | 100 |
| 2 | COMPLAINT_LEVEL | CHARACTER VARYING(20) | 20 |
| 3 | STATUS | CHARACTER VARYING(150) | 150 |
| 4 | PROGRESS | CHARACTER VARYING(150) | 150 |
| 5 | COMPLAINT_DESCRIPTION | CHARACTER VARYING(2000) | 2000 |
| 6 | PRODUCT | CHARACTER VARYING(150) | 150 |
| 7 | BRAND | CHARACTER VARYING(150) | 150 |
| 8 | CATEGORY | CHARACTER VARYING(150) | 150 |
| 9 | SUBCATEGORY | CHARACTER VARYING(150) | 150 |
| 10 | SUBCATEGORY12 | CHARACTER VARYING(150) | 150 |
| 11 | SOURCE | CHARACTER VARYING(150) | 150 |
| 12 | REFERENCE_TYPE_1 | CHARACTER VARYING(50) | 50 |
| 13 | REFERENCE1 | CHARACTER VARYING(150) | 150 |
| 14 | REFERENCE_TYPE_2 | CHARACTER VARYING(50) | 50 |
| 15 | REFERENCE2 | CHARACTER VARYING(150) | 150 |
| 16 | REFERENCE_TYPE_3 | CHARACTER VARYING(50) | 50 |
| 17 | REFERENCE3 | CHARACTER VARYING(150) | 150 |
| 18 | OWNER | CHARACTER VARYING(150) | 150 |
| 19 | BU_NAME | CHARACTER VARYING(150) | 150 |
| 20 | LODGED_DEPARTMENT | CHARACTER VARYING(150) | 150 |
| 21 | COUNT_OF_BREACHES | INTEGER | 4 |
| 22 | CREATED_DATE | DATE | 4 |
| 23 | CREATED_BY | CHARACTER VARYING(150) | 150 |
| 24 | COMPLAINT_MADE_DATE | DATE | 4 |
| 25 | COMPLAINT_CLOSED_DATE | DATE | 4 |
| 26 | ESCALATION_DATE | DATE | 4 |
| 27 | REOPEN_DATE | TIMESTAMP | 8 |
| 28 | RECEIVED_DATE | TIMESTAMP | 8 |
| 29 | RESOLUTION_1 | CHARACTER VARYING(150) | 150 |
| 30 | RESOLUTION_2 | CHARACTER VARYING(150) | 150 |
| 31 | CUST_NUM | NUMERIC(19,0) | 19 |
| 32 | ROLE_TYPE | CHARACTER VARYING(50) | 50 |
| 33 | SRC_SYS_ID | CHARACTER VARYING(5) | 5 |
| 34 | EFFECTIVE_START_DATE | TIMESTAMP | 8 |
| 35 | EFFECTIVE_END_DATE | TIMESTAMP | 8 |
| 36 | LEVEL2_ESCALATION_DATE | DATE | 4 |
| 37 | LEVEL3_ESCALATION_DATE | DATE | 4 |