OBP24_HST_FLX_PM_LN_PRODUCTS_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRODUCT_CODE CHARACTER VARYING(30) 30
2 NSF_BEHAVIOR_TYPE CHARACTER VARYING(1) 1
3 INCLUDE_UNBILL_PENALTY_FLAG CHARACTER(1) 1
4 HOLIDAY_PROCESSING_TYPE CHARACTER VARYING(15) 15
5 RPA_AUTO_DEBIT_FLAG CHARACTER(1) 1
6 AUTO_DEBIT_MAX_RETRY_NUM DOUBLE PRECISION 8
7 AUTO_DEBIT_AMT CHARACTER VARYING(1) 1
8 CHARGE_PENALTY_RETRY_FLAG CHARACTER(1) 1
9 REDRAW_ALLOWED_TYPE CHARACTER VARYING(1) 1
10 SUBSEQUENT_DISBURSEMENT_TYPE CHARACTER VARYING(1) 1
11 DECREASE_LOAN_TERM_TYPE CHARACTER VARYING(1) 1
12 LOAN_TERM_INCREASE_TYPE CHARACTER VARYING(1) 1
13 LOAN_AMT_INCREASE_TYPE CHARACTER VARYING(1) 1
14 ALLOW_REPAY_HOLIDAY_PRD_TYPE CHARACTER VARYING(1) 1
15 PRINCIPAL_OFFSET_ALLOWED_TYPE CHARACTER VARYING(1) 1
16 ALLOW_DOWNWARDS_FLAG CHARACTER(1) 1
17 ALLOW_UPWARDS_FLAG CHARACTER(1) 1
18 DEBT_CONSOLIDATION_MIN_AMT DOUBLE PRECISION 8
19 APPROPRAITION_SEQ CHARACTER VARYING(20) 20
20 FEE_AMOTISATION_METHOD_TYPE CHARACTER VARYING(1) 1
21 COLLECTED_BALANCE_FLAG CHARACTER(1) 1
22 INCOMING_PAYMENTS_FLAG CHARACTER(1) 1
23 ADVANCE_INTEREST_MIN_PERIOD DOUBLE PRECISION 8
24 LONG_OVERDUE_FIRST_FLAG CHARACTER(1) 1
25 PAYOFF_BENEFIT_TYPE CHARACTER VARYING(1) 1
26 FEE_AMORTIZATION_FRQ_TYPE CHARACTER VARYING(1) 1
27 UPDATE_UTILIZATION_FLAG CHARACTER(1) 1
28 WRITTEN_OFF_ACCT_APP_SEQ CHARACTER VARYING(6) 6
29 EPS_SIMULATION_PER_DAYS CHARACTER VARYING(20) 20
30 LOCKIN_PERIOD_UNIT_TYPE CHARACTER VARYING(20) 20
31 LOCKIN_PERIOD_MAX_NUM DOUBLE PRECISION 8
32 RECESSION_PERIOD_DAYS DOUBLE PRECISION 8
33 ACCOUNT_AUTO_CLOSSURE_FLAG CHARACTER(1) 1
34 REFRESH_FIXED_RATE_FLAG CHARACTER(1) 1
35 NOTICE_PERIOD_UNIT_TYPE CHARACTER VARYING(20) 20
36 NOTICE_PERIOD_MAX_NUM DOUBLE PRECISION 8
37 REDRAW_RESERVE_MIN_NUM DOUBLE PRECISION 8
38 DEFAULT_RESCHEDULE_MODE_TYPE CHARACTER VARYING(20) 20
39 MIN_REPAY_HOLIDAY_PERIOD DOUBLE PRECISION 8
40 MAX_REPAY_HOLIDAY_PERIOD DOUBLE PRECISION 8
41 MIN_AMT_PPF DOUBLE PRECISION 8
42 MATURITY_DATE_INTACT_FLAG CHARACTER(1) 1
43 CAP_ECONOMIC_COST_FOR_PPF_FLAG CHARACTER(1) 1
44 DEFAULT_RESCHEDULE_DATE CHARACTER VARYING(30) 30
45 DECREASE_INSTALLMENT_ALWD_FLAG CHARACTER(1) 1
46 PRD_TO_DSPLY_WAIVED_ORIG_FEES DOUBLE PRECISION 8
47 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
48 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
49 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
50 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8