| 1 |
complaint_id |
character varying |
300 |
| 2 |
gcis_party_id |
integer |
32 |
| 3 |
role_type |
character varying |
150 |
| 4 |
complaint_made_date |
timestamp without time zone |
|
| 5 |
received_date |
timestamp without time zone |
|
| 6 |
complaint_closed_date |
timestamp without time zone |
|
| 7 |
brand |
character varying |
450 |
| 8 |
status |
character varying |
450 |
| 9 |
complaint_level |
character varying |
60 |
| 10 |
progress |
character varying |
450 |
| 11 |
product |
character varying |
450 |
| 12 |
category |
character varying |
450 |
| 13 |
subcategory |
character varying |
450 |
| 14 |
subcategory2 |
character varying |
450 |
| 15 |
source |
character varying |
450 |
| 16 |
reference_type_1 |
character varying |
150 |
| 17 |
reference_type_2 |
character varying |
150 |
| 18 |
reference_type_3 |
character varying |
150 |
| 19 |
escalation_date |
timestamp without time zone |
|
| 20 |
reopen_date |
timestamp without time zone |
|
| 21 |
resolution_1 |
character varying |
450 |
| 22 |
resolution_2 |
character varying |
450 |
| 23 |
level2_escalation_date |
timestamp without time zone |
|
| 24 |
level3_escalation_date |
timestamp without time zone |
|
| 25 |
account_id_number |
character varying |
72 |
| 26 |
monthend_date |
date |
|