OCH24_HST_S_CONTACT_FNXM

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ROW_ID CHARACTER VARYING(15) 15
2 CREATED TIMESTAMP 8
3 CREATED_BY CHARACTER VARYING(15) 15
4 LAST_UPD TIMESTAMP 8
5 LAST_UPD_BY CHARACTER VARYING(15) 15
6 MODIFICATION_NUM BIGINT 8
7 CONFLICT_ID CHARACTER VARYING(15) 15
8 PAR_ROW_ID CHARACTER VARYING(15) 15
9 NAME CHARACTER VARYING(100) 100
10 TYPE CHARACTER VARYING(30) 30
11 ATTRIB_08 CHARACTER(1) 1
12 ATTRIB_09 CHARACTER(1) 1
13 ATTRIB_10 CHARACTER(1) 1
14 ATTRIB_11 CHARACTER(1) 1
15 ATTRIB_12 TIMESTAMP 8
16 ATTRIB_13 TIMESTAMP 8
17 ATTRIB_14 NUMERIC(22,7) 19
18 ATTRIB_15 NUMERIC(22,7) 19
19 ATTRIB_16 NUMERIC(22,7) 19
20 ATTRIB_17 NUMERIC(22,7) 19
21 ATTRIB_18 NUMERIC(22,7) 19
22 ATTRIB_19 NUMERIC(22,7) 19
23 ATTRIB_20 NUMERIC(22,7) 19
24 ATTRIB_21 NUMERIC(22,7) 19
25 ATTRIB_22 NUMERIC(22,7) 19
26 ATTRIB_23 NUMERIC(22,7) 19
27 ATTRIB_24 NUMERIC(22,7) 19
28 ATTRIB_25 NUMERIC(22,7) 19
29 ATTRIB_26 TIMESTAMP 8
30 ATTRIB_27 TIMESTAMP 8
31 ATTRIB_28 TIMESTAMP 8
32 ATTRIB_29 TIMESTAMP 8
33 ATTRIB_30 TIMESTAMP 8
34 ATTRIB_31 TIMESTAMP 8
35 ATTRIB_32 TIMESTAMP 8
36 ATTRIB_33 TIMESTAMP 8
37 DB_LAST_UPD TIMESTAMP 8
38 WATCH_END_DT TIMESTAMP 8
39 WATCH_START_DT TIMESTAMP 8
40 ATTRIB_01 CHARACTER VARYING(100) 100
41 ATTRIB_02 CHARACTER VARYING(100) 100
42 ATTRIB_03 CHARACTER VARYING(30) 30
43 ATTRIB_04 CHARACTER VARYING(30) 30
44 ATTRIB_05 CHARACTER VARYING(30) 30
45 ATTRIB_06 CHARACTER VARYING(30) 30
46 ATTRIB_07 CHARACTER VARYING(30) 30
47 ATTRIB_34 CHARACTER VARYING(50) 50
48 ATTRIB_35 CHARACTER VARYING(50) 50
49 ATTRIB_36 CHARACTER VARYING(50) 50
50 ATTRIB_37 CHARACTER VARYING(50) 50
51 ATTRIB_38 CHARACTER VARYING(50) 50
52 ATTRIB_39 CHARACTER VARYING(50) 50
53 ATTRIB_40 CHARACTER VARYING(50) 50
54 ATTRIB_41 CHARACTER VARYING(50) 50
55 ATTRIB_42 CHARACTER VARYING(50) 50
56 ATTRIB_43 CHARACTER VARYING(50) 50
57 ATTRIB_44 CHARACTER VARYING(100) 100
58 ATTRIB_45 CHARACTER VARYING(100) 100
59 ATTRIB_46 CHARACTER VARYING(100) 100
60 ATTRIB_47 CHARACTER VARYING(255) 255
61 ATTRIB_48 CHARACTER VARYING(30) 30
62 ATTRIB_49 CHARACTER VARYING(30) 30
63 ATTRIB_50 CHARACTER VARYING(30) 30
64 ATTRIB_51 CHARACTER VARYING(30) 30
65 ATTRIB_52 CHARACTER VARYING(30) 30
66 ATTRIB_53 CHARACTER VARYING(30) 30
67 ATTRIB_54 CHARACTER VARYING(30) 30
68 ATTRIB_55 CHARACTER VARYING(30) 30
69 ATTRIB_56 CHARACTER VARYING(30) 30
70 ATTRIB_57 CHARACTER VARYING(30) 30
71 DB_LAST_UPD_SRC CHARACTER VARYING(50) 50
72 WATCHLIST_CD CHARACTER VARYING(30) 30
73 WATCH_ACTVTD_BY_ID CHARACTER VARYING(15) 15
74 X_BU_NAME CHARACTER VARYING(100) 100
75 X_CREATED_BY CHARACTER VARYING(100) 100
76 X_CREATED_SYS CHARACTER VARYING(100) 100
77 X_DELETED_BY CHARACTER VARYING(100) 100
78 X_INT_ID CHARACTER VARYING(100) 100
79 X_LAST_UPD_BY CHARACTER VARYING(100) 100
80 X_LAST_UPD_SYS CHARACTER VARYING(100) 100
81 X_RECORD_END_DT TIMESTAMP 8
82 X_RECORD_STATUS_CD CHARACTER VARYING(30) 30
83 X_ROLE_ID CHARACTER VARYING(2) 2
84 X_RULE_ID CHARACTER VARYING(255) 255
85 X_VER_STATUS_AGENCY CHARACTER VARYING(255) 255
86 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
87 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
88 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
89 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8