obp24_hst_flx_or_cd_submissions

Database

prod_bank_wealth

Schema

sor_obp

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 decision_id character varying 150
2 submission_id character varying 150
3 decision_by character varying 120
4 entity_type character varying 150
5 stage_type character varying 150
6 decision_status_type character varying 150
7 decision_date timestamp without time zone
8 rsn_ref_id character varying 630
9 man_decision_status character varying 150
10 auth_decision_status character varying 150
11 credit_memo_req character varying 3
12 credit_memo_id character varying 150
13 sub_call_ref_num character varying 150
14 downsell_status character varying 150
15 decision_comments character varying 762
16 overview_req character varying 3
17 overview_done character varying 3
18 overview_comments character varying 762
19 overview_date timestamp without time zone
20 workitem_id character varying 150
21 approver_id character varying 150
22 fraud_status_type character varying 150
23 fraud_reason character varying 150
24 manual_fraud_status character varying 150
25 comments character varying 150
26 condition_waived character varying 3
27 covenant_waived character varying 3
28 valuation_waived character varying 3
29 verification_waived character varying 3
30 aggregate_limit double precision 53
31 personal_aaa_aggr double precision 53
32 personal_excess double precision 53
33 created_by character varying 762
34 creation_date timestamp without time zone
35 last_updated_by character varying 762
36 last_update_date timestamp without time zone
37 object_version_number integer 32
38 object_status character varying 3
39 decision_expiry_date timestamp without time zone
40 outside_amount_pre_loan double precision 53
41 outside_amount_pre_loan_ccy character varying 15
42 outside_amount_post_loan double precision 53
43 outside_amount_post_loan_ccy character varying 15
44 within_amount_pre_loan double precision 53
45 within_amount_pre_loan_ccy character varying 15
46 within_amount_post_loan double precision 53
47 within_amount_post_loan_ccy character varying 15
48 cdc_source_system_code character varying 12
49 cdc_record_type character varying 48
50 cdc_commit_timestamp timestamp without time zone
51 cdc_extract_timestamp timestamp without time zone