obp24_hst_ci_case

Database

prod_bank_wealth

Schema

sor_obp

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 case_id character varying 30
2 case_type_cd character varying 36
3 case_status_cd character varying 36
4 per_id character varying 30
5 acct_id character varying 30
6 prem_id character varying 30
7 user_id character varying 765
8 case_cond_flg character varying 12
9 contact_per_id character varying 30
10 contact_meth_flg character varying 12
11 version integer 32
12 comment_long character varying 6000
13 contact_instr character varying 6000
14 phone_type_cd character varying 36
15 phone character varying 72
16 extension character varying 18
17 bo_defn_area character varying 2048
18 cdc_source_system_code character varying 12
19 cdc_record_type character varying 48
20 cdc_commit_timestamp timestamp without time zone
21 cdc_extract_timestamp timestamp without time zone