OCH24_HST_S_ADDR_PER

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 ADDR_NAME CHARACTER VARYING(100) 100
10 ALIGNMENT_FLG CHARACTER(1) 1
11 DISA_CLEANSE_FLG CHARACTER(1) 1
12 GEOCD_VALID_FLG CHARACTER(1) 1
13 LOCATION_FLG CHARACTER(1) 1
14 NAME_LOCK_FLG CHARACTER(1) 1
15 PREMISE_FLG CHARACTER(1) 1
16 SYNC_SUCCESS_FLG CHARACTER(1) 1
17 VERIFIED_FLG CHARACTER(1) 1
18 ACTIVE_FLG CHARACTER(1) 1
19 ALTITUDE NUMERIC(22,7) 19
20 DB_LAST_UPD TIMESTAMP 8
21 END_DT TIMESTAMP 8
22 EXT_SYS_SYNC_TS TIMESTAMP 8
23 INFO_RECORD_DT TIMESTAMP 8
24 LATITUDE NUMERIC(22,7) 19
25 LONGITUDE NUMERIC(22,7) 19
26 MSA BIGINT 8
27 START_DT TIMESTAMP 8
28 ADDR CHARACTER VARYING(200) 200
29 ADDRESSEE CHARACTER VARYING(100) 100
30 ADDR_LINE_2 CHARACTER VARYING(100) 100
31 ADDR_LINE_3 CHARACTER VARYING(100) 100
32 ADDR_LINE_4 CHARACTER VARYING(100) 100
33 ADDR_LINE_5 CHARACTER VARYING(100) 100
34 ADDR_MAIL_CD CHARACTER VARYING(30) 30
35 ADDR_NUM CHARACTER VARYING(30) 30
36 ADDR_SUB_CD CHARACTER VARYING(30) 30
37 ADDR_TYPE_CD CHARACTER VARYING(30) 30
38 AIA_INTEG1_ID CHARACTER VARYING(500) 500
39 AIA_INTEG_ID CHARACTER VARYING(150) 150
40 BILLACCT_ID CHARACTER VARYING(15) 15
41 CITY CHARACTER VARYING(50) 50
42 COMMENTS CHARACTER VARYING(255) 255
43 COUNTRY CHARACTER VARYING(30) 30
44 COUNTRY_REGION CHARACTER VARYING(100) 100
45 COUNTY CHARACTER VARYING(50) 50
46 CROSS_ST CHARACTER VARYING(100) 100
47 DB_LAST_UPD_SRC CHARACTER VARYING(50) 50
48 DESCRIPTOR CHARACTER VARYING(100) 100
49 DISTRICT CHARACTER VARYING(50) 50
50 EMAIL_ADDR CHARACTER VARYING(100) 100
51 EXT_SYS_SYNC_MSG CHARACTER VARYING(250) 250
52 FAX_PH_NUM CHARACTER VARYING(40) 40
53 GEOCD_FAIL_DESC CHARACTER VARYING(250) 250
54 GEOCODE_STATUS_CD CHARACTER VARYING(30) 30
55 INTEGRATION2_ID CHARACTER VARYING(30) 30
56 INTEGRATION3_ID CHARACTER VARYING(30) 30
57 INTEGRATION_ID CHARACTER VARYING(30) 30
58 LANDLORD_NAME CHARACTER VARYING(100) 100
59 LANDLORD_PH_NUM CHARACTER VARYING(40) 40
60 METRO_AREA CHARACTER VARYING(100) 100
61 MISC_ADDR_LINE CHARACTER VARYING(100) 100
62 OWNERSHIP_CD CHARACTER VARYING(30) 30
63 PAR_ADDR_ID CHARACTER VARYING(15) 15
64 PER_ID CHARACTER VARYING(15) 15
65 PH_NUM CHARACTER VARYING(40) 40
66 PROVINCE CHARACTER VARYING(50) 50
67 RURAL_ROUTE_NUM CHARACTER VARYING(10) 10
68 STATE CHARACTER VARYING(10) 10
69 TIME_ZONE_CD CHARACTER VARYING(30) 30
70 UTM_EASTING CHARACTER VARYING(30) 30
71 UTM_NORTHING CHARACTER VARYING(30) 30
72 VERIFY_STATUS_MSG CHARACTER VARYING(100) 100
73 WORLD_AREA CHARACTER VARYING(100) 100
74 ZIPCODE CHARACTER VARYING(30) 30
75 ZIPCODE_EXT CHARACTER VARYING(4) 4
76 X_ACCOUNT_ID CHARACTER VARYING(15) 15
77 X_ADDR_LINE_4 CHARACTER VARYING(120) 120
78 X_ADDR_LINE_5 CHARACTER VARYING(120) 120
79 X_BU_NAME CHARACTER VARYING(100) 100
80 X_CONTACT_ID CHARACTER VARYING(15) 15
81 X_CREATED_BY CHARACTER VARYING(100) 100
82 X_CREATED_SYS CHARACTER VARYING(100) 100
83 X_DEDUP_ADDR1 CHARACTER VARYING(360) 360
84 X_DELETED_BY CHARACTER VARYING(30) 30
85 X_DLV_TYPE_CD CHARACTER VARYING(30) 30
86 X_DPID CHARACTER VARYING(30) 30
87 X_HOLD_END_DT TIMESTAMP 8
88 X_HOLD_MAIL CHARACTER(1) 1
89 X_HOLD_START_DT TIMESTAMP 8
90 X_LAST_UPD_BY CHARACTER VARYING(100) 100
91 X_LAST_UPD_DT TIMESTAMP 8
92 X_LAST_UPD_SYS CHARACTER VARYING(100) 100
93 X_LIVING_SINCE_DATE TIMESTAMP 8
94 X_LVL_NUM CHARACTER VARYING(120) 120
95 X_MAIL_STATUS_CD CHARACTER VARYING(30) 30
96 X_OCCUPANCY_CD CHARACTER VARYING(30) 30
97 X_PRIMARY_FLAG CHARACTER(1) 1
98 X_PRINT_ADDR_LINE_1 CHARACTER VARYING(100) 100
99 X_PRINT_ADDR_LINE_2 CHARACTER VARYING(100) 100
100 X_PRINT_ADDR_LINE_3 CHARACTER VARYING(100) 100
101 X_PROPERTY_NUM CHARACTER VARYING(120) 120
102 X_REASON_CD CHARACTER VARYING(30) 30
103 X_RECORD_END_DT TIMESTAMP 8
104 X_RECORD_STATUS_CD CHARACTER VARYING(30) 30
105 X_RELATION_TYPE_CD CHARACTER VARYING(30) 30
106 X_STOP_MAIL CHARACTER(1) 1
107 X_STREET_TYPE_CD CHARACTER VARYING(30) 30
108 X_STREET_TYPE_SUFF CHARACTER VARYING(30) 30
109 X_UNIT_NUM CHARACTER VARYING(120) 120
110 X_UNIT_TYPE_CD CHARACTER VARYING(30) 30
111 X_USER_VLDN_DATE TIMESTAMP 8
112 X_VALIDN_DATE TIMESTAMP 8
113 X_VALIDN_STAT_CD CHARACTER VARYING(30) 30
114 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
115 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
116 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
117 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
118 X_VICTIM_ADDR_FLG CHARACTER VARYING(15) 15