RDM_PRODUCT_DIMENSION_5

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