fct_bnk_crai_complaints_insight

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
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 subcategory12 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 reference1 character varying 450
20 reference2 character varying 450
21 reference3 character varying 450
22 escalation_date timestamp without time zone
23 reopen_date timestamp without time zone
24 resolution_1 character varying 450
25 resolution_2 character varying 450
26 level2_escalation_date character varying 600
27 level3_escalation_date character varying 600
28 effective_end_date timestamp without time zone
29 effective_start_date timestamp without time zone