OBP24_HST_FLX_PM_LN_OFFERS_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 OFFER_CODE CHARACTER VARYING(30) 30
2 ALLOWED_RATE_TYPE CHARACTER VARYING(20) 20
3 FUND_INT_FOR_IOI_FLAG CHARACTER(1) 1
4 PAYOUT_QUOTE_EFS_ALLOWED_FLAG CHARACTER(1) 1
5 QUOTE_TOLERANCE_LIMIT CHARACTER VARYING(1) 1
6 QUOTE_PERCENTAGE_TOLERANCE DOUBLE PRECISION 8
7 QUOTE_GEN_PERMISSIBLE_DAYS CHARACTER VARYING(1) 1
8 BASIS_FOR_PENALTY_TYPE CHARACTER VARYING(2) 2
9 PENALTY_TOLERANCE_IN CHARACTER VARYING(1) 1
10 PENALTY_PERCENTAGE_TOLERANCE DOUBLE PRECISION 8
11 PENALTY_TOLERANCE_AMT DOUBLE PRECISION 8
12 LOCKIN_PERIOD_UNIT_TYPE CHARACTER VARYING(6) 6
13 LOCKIN_PERIOD_MAX_NUM DOUBLE PRECISION 8
14 RECESSION_PERIOD_DAYS DOUBLE PRECISION 8
15 ACCOUNT_AUTO_CLOSSURE_FLAG CHARACTER(1) 1
16 REFRESH_FIXED_RATE_FLAG CHARACTER(1) 1
17 NOTICE_PERIOD_UNIT_TYPE CHARACTER VARYING(6) 6
18 NOTICE_PERIOD_MAX_NUM DOUBLE PRECISION 8
19 REDRAW_RESERVE_MIN_NUM DOUBLE PRECISION 8
20 SCHEDULE_DRAWN_ON_TYPE CHARACTER VARYING(20) 20
21 DEFAULT_RESCHEDULE_MODE_TYPE CHARACTER VARYING(20) 20
22 LOCKED_RATE_FLAG CHARACTER(1) 1
23 MIN_AMT_PPF DOUBLE PRECISION 8
24 MATURITY_DATE_INTACT_FLAG CHARACTER(1) 1
25 CARRY_FWD_RPA_FLAG CHARACTER(1) 1
26 SUBS_DISBURSE_ALLOW_FLAG CHARACTER(1) 1
27 MAX_NO_ACC_PER_CUSTOMER DOUBLE PRECISION 8
28 CHANNEL_MOBILE_BANK_FLAG CHARACTER(1) 1
29 CHANNEL_BRANCH_FLAG CHARACTER(1) 1
30 CHANNEL_INTERNET_BANK_FLAG CHARACTER(1) 1
31 CHANNEL_PHONE_BANK_FLAG CHARACTER(1) 1
32 REVIEW_PRD_LEAD_DAYS DOUBLE PRECISION 8
33 ACCLERATED_PAYMENT_FLAG CHARACTER(1) 1
34 REPAYMENT_REVIEW_DAYS DOUBLE PRECISION 8
35 REPAYMENT_GRACE_DAYS DOUBLE PRECISION 8
36 PRINCIPAL_OFFSET_FLAG CHARACTER(1) 1
37 EPS_SIMULATION_PER_DAYS CHARACTER VARYING(20) 20
38 REDRAW_FLAG CHARACTER(1) 1
39 MIN_TERM_YEARS DOUBLE PRECISION 8
40 MIN_TERM_MONTHS DOUBLE PRECISION 8
41 MAX_TERM_YEARS DOUBLE PRECISION 8
42 MAX_TERM_MONTHS DOUBLE PRECISION 8
43 ALLOWED_TERMS CHARACTER VARYING(60) 60
44 LOCKED_RATE_TO_APPLY_FLAG CHARACTER(1) 1
45 BUFFER_DAYS_FOR_AUTO_CLOSURE DOUBLE PRECISION 8
46 INTEREST_PAY_OFFSET_ALWD_FLAG CHARACTER(1) 1
47 MAX_INT_ONLY_PRD_IN_MONTHS DOUBLE PRECISION 8
48 MAX_NO_ACC_PRINCIPAL_OFFSET DOUBLE PRECISION 8
49 UDM_ALLOWED_FLAG CHARACTER(1) 1
50 REDRAW_FREQUENCY CHARACTER VARYING(30) 30
51 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
52 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
53 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
54 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8