RDM_PI_DIM_CONFIG_V

Database

SDSNZS01_RDM

Schema

CDCPADM_RDM

Type

VIEW

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