CI_POT_DIM_PROF_MERGED_COGEN_RES_FINAL

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
3 ACCOUNT1 CHARACTER VARYING(30) 30
5 BRAND CHARACTER VARYING(30) 30
13 DATASET CHARACTER VARYING(5) 5
22 GIO_CHANNELS CHARACTER VARYING(24) 24
30 LARGE_THRESHHOLD DOUBLE PRECISION 8
34 LOB CHARACTER VARYING(22) 22
35 LSP_FLAG CHARACTER VARYING(25) 25
36 MGT_SUMINS_BAND CHARACTER VARYING(1) 1
44 ITEMNO NUMERIC(9,0) 19
47 BDM_NAME CHARACTER VARYING(36) 36
48 BDM_STATE CHARACTER VARYING(23) 23
49 BROKERS CHARACTER VARYING(62) 62
50 CLUSTER CHARACTER VARYING(46) 46
56 SELECT CHARACTER VARYING(23) 23
57 SUB_OCCUPATIONS CHARACTER VARYING(122) 122
58 TIER CHARACTER VARYING(26) 26
59 TYPE CHARACTER VARYING(1) 1
60 VIRTUAL_PRODUCT CHARACTER VARYING(22) 22
69 PRINTTYPE CHARACTER VARYING(21) 21
70 PRODUCT_TYPE CHARACTER VARYING(80) 80
72 RISKSTATE CHARACTER VARYING(1) 1
82 SI_BURGLARY_BAND CHARACTER VARYING(40) 40
84 SI_GLASS_BAND CHARACTER VARYING(35) 35
85 SI_MACHINERY_BAND CHARACTER VARYING(40) 40
86 SI_MONEY_BAND CHARACTER VARYING(40) 40
88 SI_PERSONACC_BAND CHARACTER VARYING(35) 35
90 STATE CHARACTER VARYING(23) 23