FCT_CMPGN_RESPONSE_STATUS

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 RESPONSE_DATE TIMESTAMP 8
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 CONTACT_STATUS_ID CHARACTER VARYING(5) 5
14 RESPONSE_TYPE CHARACTER VARYING(40) 40
15 FLEX_CHAR_01 CHARACTER VARYING(100) 100
16 FLEX_CHAR_02 CHARACTER VARYING(100) 100
17 FLEX_NUM_01 NUMERIC(19,0) 19
18 FLEX_NUM_02 NUMERIC(19,0) 19
19 FLEX_DATE_01 DATE 4
20 FLEX_DATE_02 DATE 4
21 MARKETING_STRATEGY CHARACTER VARYING(255) 255
22 CHANNEL CHARACTER VARYING(20) 20