RDM_PRODUCT_PORTFOLIO_MAPPING_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 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 COMPANY NATIONAL CHARACTER VARYING(100) 100
11 SOURCESYSTEM NATIONAL CHARACTER VARYING(100) 100
12 PRODUCT NATIONAL CHARACTER VARYING(100) 100
13 CLASS NATIONAL CHARACTER VARYING(100) 100
14 SUBCLASS NATIONAL CHARACTER VARYING(100) 100
15 PORTFOLIO NATIONAL CHARACTER VARYING(100) 100
16 SUBPORTFOLIO NATIONAL CHARACTER VARYING(100) 100
17 CPID NATIONAL CHARACTER VARYING(100) 100
18 ENTERDATETIME TIMESTAMP 8
19 ENTERUSERNAME NATIONAL CHARACTER VARYING(100) 100
20 ENTERVERSIONNUMBER INTEGER 4
21 LASTCHGDATETIME TIMESTAMP 8
22 LASTCHGUSERNAME NATIONAL CHARACTER VARYING(100) 100
23 LASTCHGVERSIONNUMBER INTEGER 4
24 VALIDATIONSTATUS NATIONAL CHARACTER VARYING(250) 250
25 CDC_SRC_SYSTEM_CODE CHARACTER(4) 4
26 CDC_RECORD_TYPE CHARACTER(14) 14
27 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
28 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8