FCT_CUST_BRAND_CONSOLIDATION_INSIGHT

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE_CURRENT CHARACTER VARYING(10) 10
2 BRAND_CURRENT CHARACTER VARYING(20) 20
3 PRDT_HOLDNG_NUM_CURRENT CHARACTER VARYING(20) 20
4 POLICY_CURRENT CHARACTER VARYING(12) 12
5 POLICY_EXPIRY_DATE TIMESTAMP 8
6 ANNUAL_OR_MONTHLY_CURRENT CHARACTER(1) 1
7 ANNUAL_OR_MONTHLY_OFFERED CHARACTER(1) 1
8 SOURCE_SYSTEM_CODE_OFFERED CHARACTER VARYING(10) 10
9 BRAND_OFFERED CHARACTER VARYING(100) 100
10 PRODUCT_OFFERED CHARACTER VARYING(3) 3
11 PRDT_HOLDNG_NUM_OFFERED CHARACTER VARYING(20) 20
12 POLICY_OFFERED CHARACTER VARYING(12) 12
13 REPLACEMENT_POLICY_NUMBER CHARACTER VARYING(14) 14
14 PRODUCT_TYPE_OFFERED CHARACTER VARYING(9) 9
15 PRODUCT_NAME_OFFERED CHARACTER VARYING(100) 100
16 COVERNOTE_END_DATE TIMESTAMP 8
17 COVERNOTE_STATUS CHARACTER VARYING(1) 1
18 CONVERTED_FLAG CHARACTER VARYING(1) 1
19 PRDT_SYS_CUST_NUM_OFFERED CHARACTER VARYING(30) 30
20 CUST_NUM CHARACTER VARYING(20) 20
21 BUSNESSRC CHARACTER VARYING(4) 4