FCT_VOC_SUMMARY

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SURVEY_ITEM_UNIQUE_ID CHARACTER VARYING(200) 200
2 SURVEY_ID CHARACTER VARYING(50) 50
3 BRAND_EXPERIENCE CHARACTER VARYING(20) 20
4 SURVEY_DATE DATE 4
5 EVENT_ID INTEGER 4
6 EVENT_SUB_ID INTEGER 4
7 PRODUCT_EXPERIENCE CHARACTER VARYING(100) 100
8 POLICY_TYPE CHARACTER VARYING(256) 256
9 SURVEY_NAME CHARACTER VARYING(200) 200
10 OVERALLSATISFACTION_REASON CHARACTER VARYING(10000) 10000
11 IMPROVEMENTSUGGESTION CHARACTER VARYING(10000) 10000
12 SEGMENT CHARACTER VARYING(255) 255
13 NPS CHARACTER VARYING(100) 100
14 NPS_CATEGORY NATIONAL CHARACTER VARYING(64) 64
15 OVERALL_SATISFACTION CHARACTER VARYING(100) 100
16 CSAT_CATEGORY NATIONAL CHARACTER VARYING(64) 64
17 EXPECTATIONS CHARACTER VARYING(100) 100
18 EXPECTATIONS_CATEGORY NATIONAL CHARACTER VARYING(64) 64
19 REPURCHASE CHARACTER VARYING(100) 100
20 REPURCHASE_LIKELIHOOD NATIONAL CHARACTER VARYING(64) 64
21 ANONQ CHARACTER VARYING(100) 100
22 INTERACTION_TYPE NATIONAL CHARACTER VARYING(100) 100
23 REPORT_CHANNEL NATIONAL CHARACTER VARYING(100) 100
24 REPORT_PROCESS NATIONAL CHARACTER VARYING(100) 100