RDM_PRODUCT_DIMENSION_10

Database

SDSNZS01_RDM

Schema

CDCPADM_RDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ID INTEGER 4
2 MUID CHARACTER VARYING(4000) 4000
3 VERSIONNAME NATIONAL CHARACTER VARYING(50) 50
4 VERSIONNUMBER INTEGER 4
5 VERSION_ID INTEGER 4
6 VERSIONFLAG NATIONAL CHARACTER VARYING(50) 50
7 NAME NATIONAL CHARACTER VARYING(250) 250
8 CODE NATIONAL CHARACTER VARYING(250) 250
9 CHANGETRACKINGMASK INTEGER 4
10 SYSTEM_CO_CODE NATIONAL CHARACTER VARYING(250) 250
11 SYSTEM_CO_NAME NATIONAL CHARACTER VARYING(250) 250
12 SYSTEM_CO_ID INTEGER 4
13 SYSTEM NATIONAL CHARACTER VARYING(12) 12
14 COMPANY_NO NUMERIC(31,0) 19
15 POLICY_PREFIX_CODE NATIONAL CHARACTER VARYING(3) 3
16 CB1_CODE NATIONAL CHARACTER VARYING(3) 3
17 SUBCLASS NATIONAL CHARACTER VARYING(3) 3
18 A_SOURCE_KEY1 NATIONAL CHARACTER VARYING(8) 8
19 A_SOURCE_KEY2 NATIONAL CHARACTER VARYING(3) 3
20 COGEN_PRODUCTCODE NATIONAL CHARACTER VARYING(4) 4
21 MAPPED_CODE NATIONAL CHARACTER VARYING(250) 250
22 MAPPED_NAME NATIONAL CHARACTER VARYING(250) 250
23 MAPPED_ID INTEGER 4
24 RISKGRP NATIONAL CHARACTER VARYING(2) 2
25 PROD_STRUCT8 NATIONAL CHARACTER VARYING(12) 12
26 PROD_STRUCT7 NATIONAL CHARACTER VARYING(4) 4
27 PROD_STRUCT6_CODE NATIONAL CHARACTER VARYING(250) 250
28 PROD_STRUCT6_NAME NATIONAL CHARACTER VARYING(250) 250
29 PROD_STRUCT6_ID INTEGER 4
30 PROD_STRUCT5 NATIONAL CHARACTER VARYING(45) 45
31 PROD_STRUCT4 NATIONAL CHARACTER VARYING(40) 40
32 PROD_STRUCT3 NATIONAL CHARACTER VARYING(40) 40
33 PROD_STRUCT2 NATIONAL CHARACTER VARYING(30) 30
34 PROD_STRUCT1 NATIONAL CHARACTER VARYING(25) 25
35 PACKAGE_STRUCT2_CODE NATIONAL CHARACTER VARYING(250) 250
36 PACKAGE_STRUCT2_NAME NATIONAL CHARACTER VARYING(250) 250
37 PACKAGE_STRUCT2_ID INTEGER 4
38 PACKAGE_STRUCT1 NATIONAL CHARACTER VARYING(12) 12
39 REPORTING_PRODUCT_CODE NATIONAL CHARACTER VARYING(250) 250
40 REPORTING_PRODUCT_NAME NATIONAL CHARACTER VARYING(250) 250
41 REPORTING_PRODUCT_ID INTEGER 4
42 P_CODE NATIONAL CHARACTER VARYING(6) 6
43 RATINGGROUP_CODE NATIONAL CHARACTER VARYING(250) 250
44 RATINGGROUP_NAME NATIONAL CHARACTER VARYING(250) 250
45 RATINGGROUP_ID INTEGER 4
46 SUMINSUREDCODE_CODE NATIONAL CHARACTER VARYING(250) 250
47 SUMINSUREDCODE_NAME NATIONAL CHARACTER VARYING(250) 250
48 SUMINSUREDCODE_ID INTEGER 4
49 SEC_BRAND NATIONAL CHARACTER VARYING(2) 2
50 POL_ITEM_COV NATIONAL CHARACTER VARYING(2) 2
51 COMMENT NATIONAL CHARACTER VARYING(188) 188
52 PRODUCT_KEY NATIONAL CHARACTER VARYING(100) 100
53 CLAIMS_L1 NATIONAL CHARACTER VARYING(100) 100
54 CLAIMS_L2_CODE NATIONAL CHARACTER VARYING(250) 250
55 CLAIMS_L2_NAME NATIONAL CHARACTER VARYING(250) 250
56 CLAIMS_L2_ID INTEGER 4
57 ENTERDATETIME TIMESTAMP 8
58 ENTERUSERNAME NATIONAL CHARACTER VARYING(100) 100
59 ENTERVERSIONNUMBER INTEGER 4
60 LASTCHGDATETIME TIMESTAMP 8
61 LASTCHGUSERNAME NATIONAL CHARACTER VARYING(100) 100
62 LASTCHGVERSIONNUMBER INTEGER 4
63 VALIDATIONSTATUS NATIONAL CHARACTER VARYING(250) 250
64 CDC_SRC_SYSTEM_CODE CHARACTER(4) 4
65 CDC_RECORD_TYPE CHARACTER(14) 14
66 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
67 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8