FCT_CMPGN_EXTERNAL_CONTACT_HISTORY

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE CHARACTER VARYING(20) 20
2 CUSTOMER_NUMBER CHARACTER VARYING(255) 255
3 GCIS_CUSTOMER_NUMBER CHARACTER VARYING(255) 255
4 BRAND CHARACTER VARYING(255) 255
5 CONTACT_DATE TIMESTAMP 8
6 CONTACT_STATUS_ID CHARACTER VARYING(5) 5
7 CAMPAIGN_CODE CHARACTER VARYING(255) 255
8 CELL_CODE CHARACTER VARYING(255) 255
9 CELL_NAME CHARACTER VARYING(255) 255
10 CONTROL_FLAG CHARACTER VARYING(2) 2
11 POLICY_ACCOUNT_NUMBER CHARACTER VARYING(255) 255
12 TREATMENT_CODE CHARACTER VARYING(255) 255
13 MARKETING_STRATEGY CHARACTER VARYING(255) 255
14 CHANNEL CHARACTER VARYING(20) 20