OCH24_HST_S_ASSET_CON

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 ASSET_ID CHARACTER VARYING(15) 15
9 CONTACT_ID CHARACTER VARYING(15) 15
10 RELATION_TYPE_CD CHARACTER VARYING(30) 30
11 BILLPAY_ENBL_FLG CHARACTER(1) 1
12 ATTRIB_08 CHARACTER(1) 1
13 ATTRIB_09 CHARACTER(1) 1
14 ATTRIB_10 CHARACTER(1) 1
15 ATTRIB_11 CHARACTER(1) 1
16 ATTRIB_12 TIMESTAMP 8
17 ATTRIB_13 TIMESTAMP 8
18 ATTRIB_14 NUMERIC(22,7) 19
19 ATTRIB_15 NUMERIC(22,7) 19
20 ATTRIB_16 NUMERIC(22,7) 19
21 ATTRIB_17 NUMERIC(22,7) 19
22 ATTRIB_18 NUMERIC(22,7) 19
23 ATTRIB_19 NUMERIC(22,7) 19
24 ATTRIB_20 NUMERIC(22,7) 19
25 ATTRIB_21 NUMERIC(22,7) 19
26 ATTRIB_22 NUMERIC(22,7) 19
27 ATTRIB_23 NUMERIC(22,7) 19
28 ATTRIB_24 NUMERIC(22,7) 19
29 ATTRIB_25 NUMERIC(22,7) 19
30 ATTRIB_26 TIMESTAMP 8
31 ATTRIB_27 TIMESTAMP 8
32 ATTRIB_28 TIMESTAMP 8
33 ATTRIB_29 TIMESTAMP 8
34 ATTRIB_30 TIMESTAMP 8
35 ATTRIB_31 TIMESTAMP 8
36 ATTRIB_32 TIMESTAMP 8
37 ATTRIB_33 TIMESTAMP 8
38 ATTRIB_48 CHARACTER(1) 1
39 ATTRIB_49 CHARACTER(1) 1
40 ATTRIB_50 CHARACTER(1) 1
41 CERT_FIN_RESP_FLG CHARACTER(1) 1
42 DB_LAST_UPD TIMESTAMP 8
43 EFFECTIVE_DT TIMESTAMP 8
44 END_DT TIMESTAMP 8
45 EXCLUDE_FLG CHARACTER(1) 1
46 GUARANTOR_FLG CHARACTER(1) 1
47 NAMED_INS_FLG CHARACTER(1) 1
48 PAYOR_FLG CHARACTER(1) 1
49 PERCENTAGE NUMERIC(22,7) 19
50 PN_CNTRB_AMT NUMERIC(22,7) 19
51 PN_CNTRB_PCT NUMERIC(22,7) 19
52 PN_CNTRB_ST_DT TIMESTAMP 8
53 PRIOR_YR_CLM_NUM BIGINT 8
54 RATING_DT TIMESTAMP 8
55 RECEIVED_DT TIMESTAMP 8
56 REVOC_FLG CHARACTER(1) 1
57 ADDR_PER_ID CHARACTER VARYING(15) 15
58 ATTRIB_01 CHARACTER VARYING(100) 100
59 ATTRIB_02 CHARACTER VARYING(100) 100
60 ATTRIB_03 CHARACTER VARYING(30) 30
61 ATTRIB_04 CHARACTER VARYING(30) 30
62 ATTRIB_05 CHARACTER VARYING(30) 30
63 ATTRIB_06 CHARACTER VARYING(30) 30
64 ATTRIB_07 CHARACTER VARYING(30) 30
65 ATTRIB_34 CHARACTER VARYING(50) 50
66 ATTRIB_35 CHARACTER VARYING(50) 50
67 ATTRIB_36 CHARACTER VARYING(50) 50
68 ATTRIB_37 CHARACTER VARYING(50) 50
69 ATTRIB_38 CHARACTER VARYING(50) 50
70 ATTRIB_39 CHARACTER VARYING(50) 50
71 ATTRIB_40 CHARACTER VARYING(50) 50
72 ATTRIB_41 CHARACTER VARYING(50) 50
73 ATTRIB_42 CHARACTER VARYING(50) 50
74 ATTRIB_43 CHARACTER VARYING(50) 50
75 ATTRIB_44 CHARACTER VARYING(100) 100
76 ATTRIB_45 CHARACTER VARYING(100) 100
77 ATTRIB_46 CHARACTER VARYING(100) 100
78 ATTRIB_47 CHARACTER VARYING(250) 250
79 BENEF_CD CHARACTER VARYING(30) 30
80 COMMENTS CHARACTER VARYING(250) 250
81 DB_LAST_UPD_SRC CHARACTER VARYING(50) 50
82 DRIVER_CD CHARACTER VARYING(30) 30
83 EMP_APPR_CD CHARACTER VARYING(30) 30
84 ENROLMNT_TYPE_CD CHARACTER VARYING(30) 30
85 GRP_CLASS_ID CHARACTER VARYING(15) 15
86 MEMBER_NUM CHARACTER VARYING(30) 30
87 NAMED_INS_CD CHARACTER VARYING(30) 30
88 OWNER_CD CHARACTER VARYING(30) 30
89 PR_DISCNT_ID CHARACTER VARYING(15) 15
90 SRC_ASSET_ID CHARACTER VARYING(15) 15
91 STATUS_CD CHARACTER VARYING(30) 30
92 X_APPLY_TAX_FLG CHARACTER(1) 1
93 X_LAST_UPD_DT TIMESTAMP 8
94 X_STATUS_CD CHARACTER VARYING(30) 30
95 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
96 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
97 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
98 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8