RDM_PI_DIM_CONFIG_1

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 DIMENSION_NAME_CODE NATIONAL CHARACTER VARYING(250) 250
10 DIMENSION_NAME_NAME NATIONAL CHARACTER VARYING(250) 250
11 DIMENSION_NAME_ID INTEGER 4
12 COMPANY_NO_CODE NATIONAL CHARACTER VARYING(250) 250
13 COMPANY_NO_NAME NATIONAL CHARACTER VARYING(250) 250
14 COMPANY_NO_ID INTEGER 4
15 DIMCO NATIONAL CHARACTER VARYING(100) 100
16 DIM_KEY1 NATIONAL CHARACTER VARYING(100) 100
17 DIM_KEY2 NATIONAL CHARACTER VARYING(100) 100
18 DIM_KEY3 NATIONAL CHARACTER VARYING(100) 100
19 DIM_KEY4 NATIONAL CHARACTER VARYING(100) 100
20 DIM_KEY5 NATIONAL CHARACTER VARYING(100) 100
21 DIM_KEY6 NATIONAL CHARACTER VARYING(100) 100
22 DIM_KEY7 NATIONAL CHARACTER VARYING(100) 100
23 DIM_KEY8 NATIONAL CHARACTER VARYING(100) 100
24 DIM_KEY9 NATIONAL CHARACTER VARYING(100) 100
25 DIM_KEY10 NATIONAL CHARACTER VARYING(100) 100
26 DIM_LEVEL1 NATIONAL CHARACTER VARYING(100) 100
27 DIM_LEVEL2 NATIONAL CHARACTER VARYING(100) 100
28 DIM_LEVEL3 NATIONAL CHARACTER VARYING(100) 100
29 DIM_LEVEL4 NATIONAL CHARACTER VARYING(100) 100
30 DIM_LEVEL5 NATIONAL CHARACTER VARYING(100) 100
31 DIM_LEVEL6 NATIONAL CHARACTER VARYING(100) 100
32 DIM_LEVEL7 NATIONAL CHARACTER VARYING(100) 100
33 DIM_LEVEL8 NATIONAL CHARACTER VARYING(100) 100
34 DIM_LEVEL9 NATIONAL CHARACTER VARYING(100) 100
35 DIM_LEVEL10 NATIONAL CHARACTER VARYING(100) 100
36 ENTERDATETIME TIMESTAMP 8
37 ENTERUSERNAME NATIONAL CHARACTER VARYING(100) 100
38 ENTERVERSIONNUMBER INTEGER 4
39 LASTCHGDATETIME TIMESTAMP 8
40 LASTCHGUSERNAME NATIONAL CHARACTER VARYING(100) 100
41 LASTCHGVERSIONNUMBER INTEGER 4
42 VALIDATIONSTATUS NATIONAL CHARACTER VARYING(250) 250
43 CDC_SRC_SYSTEM_CODE CHARACTER(4) 4
44 CDC_RECORD_TYPE CHARACTER(14) 14
45 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
46 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8