OCH24_HST_S_PER_COMM_ADDR

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 ADDR CHARACTER VARYING(100) 100
9 COMM_MEDIUM_CD CHARACTER VARYING(30) 30
10 PER_ID CHARACTER VARYING(15) 15
11 DB_LAST_UPD TIMESTAMP 8
12 YEARLY_END_DT TIMESTAMP 8
13 YEARLY_START_DT TIMESTAMP 8
14 COMM_USE_TYPE_CD CHARACTER VARYING(30) 30
15 DB_LAST_UPD_SRC CHARACTER VARYING(50) 50
16 INTEGRATION_ID CHARACTER VARYING(30) 30
17 NAME CHARACTER VARYING(50) 50
18 X_AREA_CD CHARACTER VARYING(10) 10
19 X_BU_NAME CHARACTER VARYING(100) 100
20 X_CONTACT_NAME CHARACTER VARYING(150) 150
21 X_COUNTRY_CD CHARACTER VARYING(30) 30
22 X_CREATED_BY CHARACTER VARYING(100) 100
23 X_CREATED_SYS CHARACTER VARYING(100) 100
24 X_DELETED_BY CHARACTER VARYING(100) 100
25 X_EMAIL_CON_PT CHARACTER VARYING(30) 30
26 X_EMAIL_STATUS_CD CHARACTER VARYING(30) 30
27 X_LAST_UPD_BY CHARACTER VARYING(100) 100
28 X_LAST_UPD_DT TIMESTAMP 8
29 X_LAST_UPD_SYS CHARACTER VARYING(100) 100
30 X_PH_NUM CHARACTER VARYING(30) 30
31 X_PHONE_CON_PT CHARACTER VARYING(30) 30
32 X_PRIMARY_FLG CHARACTER(1) 1
33 X_PURPOSE CHARACTER VARYING(30) 30
34 X_RECORD_END_DT TIMESTAMP 8
35 X_RECORD_STATUS_CD CHARACTER VARYING(30) 30
36 X_SMS_AUTH_FLG CHARACTER(1) 1
37 X_STATUS_CD CHARACTER VARYING(30) 30
38 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
39 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
40 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
41 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
42 X_EMAIL_MODIFIED_DATE TIMESTAMP 8
43 X_VICTIM_ALTPHN_FLG CHARACTER VARYING(15) 15
44 X_VICTIM_COMMADDR_FLG CHARACTER VARYING(15) 15