FCT_CI_COMPLAINT

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 COMPLAINT_CLAIM_ID BIGINT 8
2 COMPLAINT_CREATED_DATE TIMESTAMP 8
3 COMPLAINT_CREATED_DATE_ID INTEGER 4
4 COMPLAINT_MEDIA_INVOLVED_FLAG INTEGER 4
5 COMPLAINT_INCIDENT_DATETIME TIMESTAMP 8
6 COMPLAINT_INCIDENT_DATETIME_ID INTEGER 4
7 COMPLAINT_NUMBER CHARACTER VARYING(50) 50
8 COMPLAINT_ASSIGNMENT_STATUS BIGINT 8
9 COMPLAINT_RESOLUTION_DESCRIPTION CHARACTER VARYING(2000) 2000
10 COMPLAINT_DESCRIPTION CHARACTER VARYING(2000) 2000
11 COMPLAINT_HOW_REPORTED BIGINT 8
12 COMPLAINT_DATE_RECEIVED TIMESTAMP 8
13 COMPLAINT_DATE_RECEIVED_ID INTEGER 4
14 COMPLAINT_RESOLUTION_DATE TIMESTAMP 8
15 COMPLAINT_RESOLUTION_DATE_ID INTEGER 4
16 COMPLAINT_EXPECTED_RESOLUTION CHARACTER VARYING(2000) 2000
17 COMPLAINT_STATUS BIGINT 8
18 COMPLAINT_MEDIA_DESCRIPTION CHARACTER VARYING(2000) 2000
19 COMPLAINT_RELATED_TO_PARTY_NAME BIGINT 8
20 COMPLAINT_COUNT BIGINT 8
21 COMPLAINT_DURATION_DAY INTEGER 4
22 COMPLAINT_CATEGORY_EXTID BIGINT 8
23 COMPLAINT_CATEGORY CHARACTER VARYING(100) 100
24 COMPLAINT_SUB_CATEGORY CHARACTER VARYING(100) 100
25 COMPLAINT_HANDLERS_ID BIGINT 8
26 COMPLAINANTS_CONTACT_ID BIGINT 8
27 PREFERRED_CONTACT_METHOD_ID BIGINT 8
28 PREFERRED_CONTACT_TIME_ID BIGINT 8
29 COMPLAINANTS_COMMENTS CHARACTER VARYING(2000) 2000