RDM_AAI_NZ_MASTER_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 USER_KEY NATIONAL CHARACTER VARYING(20) 20
11 USRPFR NATIONAL CHARACTER VARYING(10) 10
12 EMPLOYEE_CODE NATIONAL CHARACTER VARYING(20) 20
13 PROTECT_ID NATIONAL CHARACTER VARYING(8) 8
14 CCR_ID NATIONAL CHARACTER VARYING(8) 8
15 USERAGENT_CODE NATIONAL CHARACTER VARYING(250) 250
16 USERAGENT_NAME NATIONAL CHARACTER VARYING(250) 250
17 USERAGENT_ID INTEGER 4
18 USER_SEQUENCE NUMERIC(31,0) 19
19 START_DATE TIMESTAMP 8
20 END_DATE TIMESTAMP 8
21 GROUP_1 NATIONAL CHARACTER VARYING(30) 30
22 GROUP_2 NATIONAL CHARACTER VARYING(30) 30
23 GROUP_3 NATIONAL CHARACTER VARYING(30) 30
24 GROUP_4 NATIONAL CHARACTER VARYING(30) 30
25 GROUP_5 NATIONAL CHARACTER VARYING(30) 30
26 GROUP_6 NATIONAL CHARACTER VARYING(30) 30
27 ENTERDATETIME TIMESTAMP 8
28 ENTERUSERNAME NATIONAL CHARACTER VARYING(100) 100
29 ENTERVERSIONNUMBER INTEGER 4
30 LASTCHGDATETIME TIMESTAMP 8
31 LASTCHGUSERNAME NATIONAL CHARACTER VARYING(100) 100
32 LASTCHGVERSIONNUMBER INTEGER 4
33 VALIDATIONSTATUS NATIONAL CHARACTER VARYING(250) 250
34 CDC_SRC_SYSTEM_CODE CHARACTER(4) 4
35 CDC_RECORD_TYPE CHARACTER(14) 14
36 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
37 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8