OCH24_HST_S_CONTACT_XM

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 ATTRIB_01 CHARACTER VARYING(100) 100
39 ATTRIB_02 CHARACTER VARYING(100) 100
40 ATTRIB_03 CHARACTER VARYING(30) 30
41 ATTRIB_04 CHARACTER VARYING(30) 30
42 ATTRIB_05 CHARACTER VARYING(30) 30
43 ATTRIB_06 CHARACTER VARYING(30) 30
44 ATTRIB_07 CHARACTER VARYING(30) 30
45 ATTRIB_34 CHARACTER VARYING(50) 50
46 ATTRIB_35 CHARACTER VARYING(50) 50
47 ATTRIB_36 CHARACTER VARYING(50) 50
48 ATTRIB_37 CHARACTER VARYING(50) 50
49 ATTRIB_38 CHARACTER VARYING(50) 50
50 ATTRIB_39 CHARACTER VARYING(50) 50
51 ATTRIB_40 CHARACTER VARYING(50) 50
52 ATTRIB_41 CHARACTER VARYING(50) 50
53 ATTRIB_42 CHARACTER VARYING(50) 50
54 ATTRIB_43 CHARACTER VARYING(50) 50
55 ATTRIB_44 CHARACTER VARYING(100) 100
56 ATTRIB_45 CHARACTER VARYING(100) 100
57 ATTRIB_46 CHARACTER VARYING(100) 100
58 ATTRIB_47 CHARACTER VARYING(255) 255
59 DB_LAST_UPD_SRC CHARACTER VARYING(50) 50
60 X_ADDRESS CHARACTER VARYING(250) 250
61 X_BU_NAME CHARACTER VARYING(100) 100
62 X_CHANNEL_TYPE CHARACTER VARYING(30) 30
63 X_CONSENT_ENTITY CHARACTER VARYING(100) 100
64 X_CREATED_SYS CHARACTER VARYING(100) 100
65 X_DEAR_NAME CHARACTER VARYING(30) 30
66 X_DELETED_BY CHARACTER VARYING(100) 100
67 X_ELECTRONIC_CONSENT CHARACTER(1) 1
68 X_EMAIL CHARACTER VARYING(100) 100
69 X_EMAL_FLG CHARACTER(1) 1
70 X_FREQUENCY CHARACTER VARYING(30) 30
71 X_FRIDAY_FLAG CHARACTER(1) 1
72 X_ID_NUMBER CHARACTER VARYING(255) 255
73 X_INT_ID CHARACTER VARYING(100) 100
74 X_LANG_CD CHARACTER VARYING(30) 30
75 X_LAST_UPD_DT TIMESTAMP 8
76 X_LAST_UPD_SYS CHARACTER VARYING(100) 100
77 X_NAME CHARACTER VARYING(100) 100
78 X_NAME_STATUS CHARACTER VARYING(30) 30
79 X_PER_TITLE_SUFFIX CHARACTER VARYING(30) 30
80 X_PHONE CHARACTER VARYING(50) 50
81 X_PHONE_FLG CHARACTER(1) 1
82 X_POST_FLG CHARACTER(1) 1
83 X_PREFERRED_BRANCH CHARACTER VARYING(30) 30
84 X_PRODUCT_NAME CHARACTER VARYING(30) 30
85 X_RECORD_STATUS_CD CHARACTER VARYING(30) 30
86 X_ROLE_CD CHARACTER VARYING(30) 30
87 X_SATURDAY_FLAG CHARACTER(1) 1
88 X_SMS_FLG CHARACTER(1) 1
89 X_SUNDAY_FLAG CHARACTER(1) 1
90 X_USRD_ID_NUM CHARACTER VARYING(255) 255
91 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
92 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
93 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
94 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
95 X_MKTG_CONSENT_MOD_DT TIMESTAMP 8
96 X_REL_NAME_MODIFIED_DATE TIMESTAMP 8
97 X_SEGMENT_CD CHARACTER VARYING(50) 50
98 X_SHARED_INFO CHARACTER VARYING(1) 1
99 X_VIC_COMMPREF_FLG CHARACTER VARYING(15) 15
100 X_VIC_CONPOINT_FLG CHARACTER VARYING(15) 15
101 X_VICTIM_CON_FLG CHARACTER VARYING(15) 15
102 X_VICTIM_ID_FLG CHARACTER VARYING(15) 15