obp24_hst_flx_or_submission_summary_b

Database

prod_bank_wealth

Schema

sor_obp

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 submission_id character varying 150
2 entity_name character varying 300
3 keyasstring character varying 300
4 posting_date timestamp without time zone
5 summary_text character varying 6000
6 resturl character varying 150
7 application_branch character varying 30
8 data_entry_branch character varying 30
9 submission_date timestamp without time zone
10 creation_date timestamp without time zone
11 total_request_amount double precision 53
12 total_request_amount_ccy character varying 9
13 total_approved_amount double precision 53
14 total_approved_amount_ccy character varying 9
15 party_names character varying 6000
16 sourced_by character varying 30
17 application_id character varying 150
18 application_status character varying 150
19 submission_status character varying 150
20 business_unit character varying 120
21 market_entity character varying 120
22 application_description character varying 6000
23 initiated_by character varying 120
24 application_status_state_type character varying 150
25 application_amounts character varying 6000
26 entity_status character varying 3
27 is_ipa character varying 3
28 cdc_source_system_code character varying 12
29 cdc_record_type character varying 48
30 cdc_commit_timestamp timestamp without time zone
31 cdc_extract_timestamp timestamp without time zone