OCH24_HST_S_CONTACT2_FNX

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 DCKING_NUM NUMERIC(22,7) 19
7 MODIFICATION_NUM BIGINT 8
8 CONFLICT_ID CHARACTER VARYING(15) 15
9 PAR_ROW_ID CHARACTER VARYING(15) 15
10 ATTRIB_08 CHARACTER(1) 1
11 ATTRIB_09 CHARACTER(1) 1
12 ATTRIB_10 CHARACTER(1) 1
13 ATTRIB_11 CHARACTER(1) 1
14 ATTRIB_12 TIMESTAMP 8
15 ATTRIB_13 TIMESTAMP 8
16 ATTRIB_14 NUMERIC(22,7) 19
17 ATTRIB_15 NUMERIC(22,7) 19
18 ATTRIB_16 NUMERIC(22,7) 19
19 ATTRIB_17 NUMERIC(22,7) 19
20 ATTRIB_18 NUMERIC(22,7) 19
21 ATTRIB_19 NUMERIC(22,7) 19
22 ATTRIB_20 NUMERIC(22,7) 19
23 ATTRIB_21 NUMERIC(22,7) 19
24 ATTRIB_22 NUMERIC(22,7) 19
25 ATTRIB_23 NUMERIC(22,7) 19
26 ATTRIB_24 NUMERIC(22,7) 19
27 ATTRIB_25 NUMERIC(22,7) 19
28 ATTRIB_26 TIMESTAMP 8
29 ATTRIB_27 TIMESTAMP 8
30 ATTRIB_28 TIMESTAMP 8
31 ATTRIB_29 TIMESTAMP 8
32 ATTRIB_30 TIMESTAMP 8
33 ATTRIB_31 TIMESTAMP 8
34 ATTRIB_32 TIMESTAMP 8
35 ATTRIB_33 TIMESTAMP 8
36 DB_LAST_UPD TIMESTAMP 8
37 ATTRIB_01 CHARACTER VARYING(100) 100
38 ATTRIB_02 CHARACTER VARYING(100) 100
39 ATTRIB_03 CHARACTER VARYING(30) 30
40 ATTRIB_04 CHARACTER VARYING(30) 30
41 ATTRIB_05 CHARACTER VARYING(30) 30
42 ATTRIB_06 CHARACTER VARYING(30) 30
43 ATTRIB_07 CHARACTER VARYING(30) 30
44 ATTRIB_34 CHARACTER VARYING(50) 50
45 ATTRIB_35 CHARACTER VARYING(50) 50
46 ATTRIB_36 CHARACTER VARYING(50) 50
47 ATTRIB_37 CHARACTER VARYING(50) 50
48 ATTRIB_38 CHARACTER VARYING(50) 50
49 ATTRIB_39 CHARACTER VARYING(50) 50
50 ATTRIB_40 CHARACTER VARYING(50) 50
51 ATTRIB_41 CHARACTER VARYING(50) 50
52 ATTRIB_42 CHARACTER VARYING(50) 50
53 ATTRIB_43 CHARACTER VARYING(50) 50
54 ATTRIB_44 CHARACTER VARYING(100) 100
55 ATTRIB_45 CHARACTER VARYING(100) 100
56 ATTRIB_46 CHARACTER VARYING(100) 100
57 ATTRIB_47 CHARACTER VARYING(255) 255
58 ATTRIB_48 CHARACTER VARYING(30) 30
59 ATTRIB_49 CHARACTER VARYING(30) 30
60 ATTRIB_50 CHARACTER VARYING(30) 30
61 ATTRIB_51 CHARACTER VARYING(30) 30
62 ATTRIB_52 CHARACTER VARYING(30) 30
63 ATTRIB_53 CHARACTER VARYING(30) 30
64 ATTRIB_54 CHARACTER VARYING(30) 30
65 ATTRIB_55 CHARACTER VARYING(30) 30
66 ATTRIB_56 CHARACTER VARYING(30) 30
67 ATTRIB_57 CHARACTER VARYING(30) 30
68 DB_LAST_UPD_SRC CHARACTER VARYING(50) 50
69 X_BRK_AGR_HELD_FLG CHARACTER(1) 1
70 X_BRK_CASH_CD CHARACTER VARYING(30) 30
71 X_BRK_DOC_SRV_CD CHARACTER VARYING(30) 30
72 X_DOMICILE CHARACTER VARYING(100) 100
73 X_EMERGENCY_DTL CHARACTER VARYING(255) 255
74 X_ID_NUMBER CHARACTER VARYING(20) 20
75 X_ID_TYPE CHARACTER VARYING(30) 30
76 X_KEY_CONTACT_FLG CHARACTER(1) 1
77 X_NOTES CHARACTER VARYING(200) 200
78 X_POST_SETTL_SRV_CD CHARACTER VARYING(30) 30
79 X_TAX_CLASSIFICATION CHARACTER VARYING(30) 30
80 X_TAX_IDEN_NUM CHARACTER VARYING(100) 100
81 X_TRAIL_REBATE_FLG CHARACTER(1) 1
82 X_USA_ALIEN_RES_NUM CHARACTER VARYING(20) 20
83 X_USA_BEN_OWNER_CAT CHARACTER VARYING(30) 30
84 X_USA_EMPLOYER_ID_NUM CHARACTER VARYING(20) 20
85 X_USA_PASSPORT_CARD_NUM CHARACTER VARYING(20) 20
86 X_USA_PASSPORT_NUM CHARACTER VARYING(20) 20
87 X_USA_PHONE_NUM CHARACTER VARYING(45) 45
88 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
89 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
90 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
91 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8