obp24_hst_flx_sh_schedule_period

Database

prod_bank_wealth

Schema

sor_obp

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 schedule_code character varying 120
2 schedule_type_name character varying 360
3 stage_num bigint 64
4 stage_name character varying 360
5 stage_start_date timestamp without time zone
6 stage_end_date timestamp without time zone
7 principal_repayment_amt double precision 53
8 stage_term bigint 64
9 capitalized_arrears_amt double precision 53
10 rollover_interest_amt double precision 53
11 installment_rule_id character varying 120
12 installment_amt double precision 53
13 first_installment_date timestamp without time zone
14 installment_num bigint 64
15 installment_freq character varying 90
16 calender_plan_id bigint 64
17 interest_amt double precision 53
18 first_interest_charge_date timestamp without time zone
19 interest_freq character varying 90
20 interest_repayments_num bigint 64
21 service_charge_code character varying 60
22 service_charge_amt double precision 53
23 first_service_charge_date timestamp without time zone
24 charge_freq bigint 64
25 charge_num bigint 64
26 penalty_freq character varying 90
27 interest_freq_comp character varying 90
28 first_comp_date timestamp without time zone
29 interest_freq_rest character varying 90
30 first_rest_period_date timestamp without time zone
31 penalty_freq_comp character varying 90
32 arrear_comp_freq character varying 90
33 end_period_treatment_code character varying 90
34 coa_rule_code bigint 64
35 coa_freq bigint 64
36 year_base_type_code bigint 64
37 year_base_for_interest bigint 64
38 year_base_for_fee bigint 64
39 interest_cap_frq character varying 90
40 first_interest_cap_date timestamp without time zone
41 fee_cap_frq character varying 90
42 first_fee_cap_date timestamp without time zone
43 min_due_plan_id bigint 64
44 billing_grace_days bigint 64
45 term_validation_rule_code bigint 64
46 billing_grace_cycle bigint 64
47 installment_date_day_part_num bigint 64
48 currency_code character varying 9
49 periodic_fee_treatment_type character varying 90
50 amount_type character varying 120
51 schedule_id character varying 120
52 cdc_source_system_code character varying 12
53 cdc_record_type character varying 48
54 cdc_commit_timestamp timestamp without time zone
55 cdc_extract_timestamp timestamp without time zone