RDM_GINZ_AGENT_ANALYSIS_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 AGENT_NUMBER NUMERIC(31,0) 19
11 SOURCESYST_CODE NATIONAL CHARACTER VARYING(250) 250
12 SOURCESYST_NAME NATIONAL CHARACTER VARYING(250) 250
13 SOURCESYST_ID INTEGER 4
14 COMPANY_CODE NATIONAL CHARACTER VARYING(250) 250
15 COMPANY_NAME NATIONAL CHARACTER VARYING(250) 250
16 COMPANY_ID INTEGER 4
17 CPID_PRT_CODE NATIONAL CHARACTER VARYING(250) 250
18 CPID_PRT_NAME NATIONAL CHARACTER VARYING(250) 250
19 CPID_PRT_ID INTEGER 4
20 ANALYSIS_CODE_01_CODE NATIONAL CHARACTER VARYING(250) 250
21 ANALYSIS_CODE_01_NAME NATIONAL CHARACTER VARYING(250) 250
22 ANALYSIS_CODE_01_ID INTEGER 4
23 ANALYSIS_CODE_02_CODE NATIONAL CHARACTER VARYING(250) 250
24 ANALYSIS_CODE_02_NAME NATIONAL CHARACTER VARYING(250) 250
25 ANALYSIS_CODE_02_ID INTEGER 4
26 ANALYSIS_CODE_03_CODE NATIONAL CHARACTER VARYING(250) 250
27 ANALYSIS_CODE_03_NAME NATIONAL CHARACTER VARYING(250) 250
28 ANALYSIS_CODE_03_ID INTEGER 4
29 ANALYSIS_CODE_04_CODE NATIONAL CHARACTER VARYING(250) 250
30 ANALYSIS_CODE_04_NAME NATIONAL CHARACTER VARYING(250) 250
31 ANALYSIS_CODE_04_ID INTEGER 4
32 ANALYSIS_CODE_05_CODE NATIONAL CHARACTER VARYING(250) 250
33 ANALYSIS_CODE_05_NAME NATIONAL CHARACTER VARYING(250) 250
34 ANALYSIS_CODE_05_ID INTEGER 4
35 ANALYSIS_CODE_06_CODE NATIONAL CHARACTER VARYING(250) 250
36 ANALYSIS_CODE_06_NAME NATIONAL CHARACTER VARYING(250) 250
37 ANALYSIS_CODE_06_ID INTEGER 4
38 ANALYSIS_CODE_07_CODE NATIONAL CHARACTER VARYING(250) 250
39 ANALYSIS_CODE_07_NAME NATIONAL CHARACTER VARYING(250) 250
40 ANALYSIS_CODE_07_ID INTEGER 4
41 ANALYSIS_CODE_08_CODE NATIONAL CHARACTER VARYING(250) 250
42 ANALYSIS_CODE_08_NAME NATIONAL CHARACTER VARYING(250) 250
43 ANALYSIS_CODE_08_ID INTEGER 4
44 ANALYSIS_CODE_09_CODE NATIONAL CHARACTER VARYING(250) 250
45 ANALYSIS_CODE_09_NAME NATIONAL CHARACTER VARYING(250) 250
46 ANALYSIS_CODE_09_ID INTEGER 4
47 ANALYSIS_CODE_10_CODE NATIONAL CHARACTER VARYING(250) 250
48 ANALYSIS_CODE_10_NAME NATIONAL CHARACTER VARYING(250) 250
49 ANALYSIS_CODE_10_ID INTEGER 4
50 ANALYSIS_CODE_11_CODE NATIONAL CHARACTER VARYING(250) 250
51 ANALYSIS_CODE_11_NAME NATIONAL CHARACTER VARYING(250) 250
52 ANALYSIS_CODE_11_ID INTEGER 4
53 ANALYSIS_CODE_12_CODE NATIONAL CHARACTER VARYING(250) 250
54 ANALYSIS_CODE_12_NAME NATIONAL CHARACTER VARYING(250) 250
55 ANALYSIS_CODE_12_ID INTEGER 4
56 ANALYSIS_CODE_13_CODE NATIONAL CHARACTER VARYING(250) 250
57 ANALYSIS_CODE_13_NAME NATIONAL CHARACTER VARYING(250) 250
58 ANALYSIS_CODE_13_ID INTEGER 4
59 ANALYSIS_CODE_14_CODE NATIONAL CHARACTER VARYING(250) 250
60 ANALYSIS_CODE_14_NAME NATIONAL CHARACTER VARYING(250) 250
61 ANALYSIS_CODE_14_ID INTEGER 4
62 ANALYSIS_CODE_15_CODE NATIONAL CHARACTER VARYING(250) 250
63 ANALYSIS_CODE_15_NAME NATIONAL CHARACTER VARYING(250) 250
64 ANALYSIS_CODE_15_ID INTEGER 4
65 ANALYSIS_CODE_16_CODE NATIONAL CHARACTER VARYING(250) 250
66 ANALYSIS_CODE_16_NAME NATIONAL CHARACTER VARYING(250) 250
67 ANALYSIS_CODE_16_ID INTEGER 4
68 ANALYSIS_CODE_17_CODE NATIONAL CHARACTER VARYING(250) 250
69 ANALYSIS_CODE_17_NAME NATIONAL CHARACTER VARYING(250) 250
70 ANALYSIS_CODE_17_ID INTEGER 4
71 ANALYSIS_CODE_18_CODE NATIONAL CHARACTER VARYING(250) 250
72 ANALYSIS_CODE_18_NAME NATIONAL CHARACTER VARYING(250) 250
73 ANALYSIS_CODE_18_ID INTEGER 4
74 ANALYSIS_CODE_19_CODE NATIONAL CHARACTER VARYING(250) 250
75 ANALYSIS_CODE_19_NAME NATIONAL CHARACTER VARYING(250) 250
76 ANALYSIS_CODE_19_ID INTEGER 4
77 ANALYSIS_CODE_20_CODE NATIONAL CHARACTER VARYING(250) 250
78 ANALYSIS_CODE_20_NAME NATIONAL CHARACTER VARYING(250) 250
79 ANALYSIS_CODE_20_ID INTEGER 4
80 ENTERDATETIME TIMESTAMP 8
81 ENTERUSERNAME NATIONAL CHARACTER VARYING(100) 100
82 ENTERVERSIONNUMBER INTEGER 4
83 LASTCHGDATETIME TIMESTAMP 8
84 LASTCHGUSERNAME NATIONAL CHARACTER VARYING(100) 100
85 LASTCHGVERSIONNUMBER INTEGER 4
86 VALIDATIONSTATUS NATIONAL CHARACTER VARYING(250) 250
87 CDC_SRC_SYSTEM_CODE CHARACTER(4) 4
88 CDC_RECORD_TYPE CHARACTER(14) 14
89 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
90 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8