ext_bnk_crai_complaint

Database

prod_bank_wealth

Schema

sdsrsp01_bank

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 complaint_id character varying 100
2 gcis_party_id character varying 512
3 role_type character varying 50
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 150
8 status character varying 150
9 complaint_level character varying 20
10 progress character varying 150
11 product character varying 150
12 category character varying 150
13 subcategory character varying 150
14 subcategory2 character varying 150
15 source character varying 150
16 reference_type_1 character varying 50
17 reference_type_2 character varying 50
18 reference_type_3 character varying 50
19 escalation_date timestamp without time zone
20 reopen_date timestamp without time zone
21 resolution_1 character varying 150
22 resolution_2 character varying 150
23 level2_escalation_date timestamp without time zone
24 level3_escalation_date timestamp without time zone
25 account_id_number character varying 24
26 monthend_date date