INT_GI_POLICY_DIM_PRODUCT_HIERARCHY

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRODHIER_KEY BIGINT 8
2 SYSTEM CHARACTER VARYING(50) 50
3 COMPANY_NO INTEGER 4
4 POLICY_PREFIX_CODE CHARACTER VARYING(10) 10
5 CB1_CODE CHARACTER VARYING(10) 10
6 SUBCLASS CHARACTER VARYING(15) 15
7 SOURCE_KEY1 CHARACTER VARYING(20) 20
8 SOURCE_KEY2 CHARACTER VARYING(20) 20
9 PROD_STRUCT1 CHARACTER VARYING(50) 50
10 PROD_STRUCT2 CHARACTER VARYING(50) 50
11 PROD_STRUCT3 CHARACTER VARYING(50) 50
12 PROD_STRUCT4 CHARACTER VARYING(50) 50
13 PROD_STRUCT5 CHARACTER VARYING(50) 50
14 PROD_STRUCT6 CHARACTER VARYING(50) 50
15 PROD_STRUCT7 CHARACTER VARYING(50) 50
16 PROD_STRUCT8 CHARACTER VARYING(50) 50
17 RISKGRP CHARACTER VARYING(50) 50
18 PACKAGE_STRUCT1 CHARACTER VARYING(50) 50
19 PACKAGE_STRUCT2 CHARACTER VARYING(50) 50
20 P_CODE CHARACTER VARYING(50) 50
21 RATINGGROUP CHARACTER VARYING(50) 50
22 REPORTING_PRODUCT CHARACTER VARYING(50) 50
23 SUMINSUREDCODE_NAME CHARACTER VARYING(50) 50
24 CCPP_L1 NATIONAL CHARACTER VARYING(100) 100
25 CCPP_L2 NATIONAL CHARACTER VARYING(100) 100
26 CCPP_L3 NATIONAL CHARACTER VARYING(100) 100
27 CCPP_L4 NATIONAL CHARACTER VARYING(40) 40
28 CCPP_L5 NATIONAL CHARACTER VARYING(250) 250
29 VERSIONNUMBER_PRODDIM INTEGER 4
30 FC_VERSION INTEGER 4
31 FC_RULE INTEGER 4