OBP24_HST_CI_CONTACT_PREF

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PER_ID CHARACTER(10) 10
2 DETERMINANT_VALUE CHARACTER VARYING(60) 60
3 CONTACT_POINT_TYPE CHARACTER VARYING(10) 10
4 PURPOSE_TEXT CHARACTER VARYING(120) 120
5 CONTACT_VALUE CHARACTER VARYING(400) 400
6 CONTACT_PREF_TYPE CHARACTER VARYING(10) 10
7 START_DT TIMESTAMP 8
8 END_DT TIMESTAMP 8
9 WKDAY_FROM_TM BIGINT 8
10 WKDAY_TO_TM BIGINT 8
11 WKEND_FROM_TM BIGINT 8
12 WKEND_TO_TM BIGINT 8
13 VERSION INTEGER 4
14 BUS_OBJ_CD CHARACTER(30) 30
15 BO_STATUS_CD CHARACTER(12) 12
16 BO_DATA_AREA CHARACTER VARYING(2000) 2000
17 STATUS_UPD_DTTM TIMESTAMP 8
18 PRIMARY_SW CHARACTER(1) 1
19 PREFERENCE_FREQUENCY CHARACTER VARYING(20) 20
20 CONTACT_RCD_STATUS CHARACTER VARYING(10) 10
21 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
22 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
23 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
24 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8