OBP24_HST_FLX_PM_CREDIT_POLICIES_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CREDIT_POLICY_CODE CHARACTER VARYING(30) 30
2 CREDIT_POLICY_DESC CHARACTER VARYING(120) 120
3 ORG_WORKFLOW_BEHAVIOUR_TYPE CHARACTER VARYING(1) 1
4 GROUP_TYPE CHARACTER VARYING(1) 1
5 LINKAGE_TYPE CHARACTER VARYING(1) 1
6 PRODUCT_CLASS CHARACTER VARYING(2) 2
7 INTERNAL_ACCT_CREATION_FLAG CHARACTER VARYING(1) 1
8 EXTERNAL_ACCT_CREATION_FLAG CHARACTER VARYING(1) 1
9 FACILITY_CATEGORY_CODE CHARACTER VARYING(50) 50
10 LOW_DOC_FLAG CHARACTER VARYING(1) 1
11 LVR_VARIATION_TOL SMALLINT 2
12 GENERAL_INSURANCE_REQD_FLAG CHARACTER VARYING(1) 1
13 COV_BY_CONS_PROT_FLAG CHARACTER VARYING(1) 1
14 CREDIT_DEC_PROD_GROUP_CODE CHARACTER VARYING(10) 10
15 BEHAVIOR_DEC_PROD_GROUP_CODE CHARACTER VARYING(10) 10
16 DEBT_SERV_CAL_METH_TYPE CHARACTER VARYING(10) 10
17 NOMINAL_TENOR_IN_MONTHS SMALLINT 2
18 ADDITIONAL_ALLOW_PERIOD_DAYS INTEGER 4
19 LRM_APPLICABLE_FLAG CHARACTER VARYING(1) 1
20 CUST_LRM_LVR_THRESHOLD_AMT NUMERIC(5,2) 19
21 LOW_DOC_LRM_LVR_THRESHOLD_AMT NUMERIC(5,2) 19
22 EMP_LRM_LVR_THRESHOLD_AMT NUMERIC(5,2) 19
23 SPL_COLL_LRM_LVR_THRESHLD_AMT NUMERIC(5,2) 19
24 EFFECTIVE_DATE TIMESTAMP 8
25 WAIVE_ARREARS_FLAG CHARACTER VARYING(1) 1
26 CHANGE_INT_RATE_FLAG CHARACTER VARYING(1) 1
27 RESTRUCTURE_LOAN_FLAG CHARACTER VARYING(1) 1
28 WAIVE_INTEREST_FLAG CHARACTER VARYING(1) 1
29 CHANGE_TERM_FLAG CHARACTER VARYING(1) 1
30 CONSOLIDATE_LOAN_FLAG CHARACTER VARYING(1) 1
31 WAIVE_REPAYMENT_FLAG CHARACTER VARYING(1) 1
32 WAIVE_FEES_FLAG CHARACTER VARYING(1) 1
33 FREEZE_DPD_CALC_FLAG CHARACTER VARYING(1) 1
34 FREEZE_INTEREST_FLAG CHARACTER VARYING(1) 1
35 NO_RELIEF_FLAG CHARACTER VARYING(1) 1
36 CREATED_BY CHARACTER VARYING(254) 254
37 CREATION_DATE TIMESTAMP 8
38 LAST_UPDATED_BY CHARACTER VARYING(254) 254
39 LAST_UPDATED_DATE TIMESTAMP 8
40 OBJECT_STATUS_FLAG CHARACTER VARYING(1) 1
41 OBJECT_VERSION_NUMBER DOUBLE PRECISION 8
42 CREDIT_CUSHION_AMT DOUBLE PRECISION 8
43 CREDIT_CUSHION_PERCENT_NUM DOUBLE PRECISION 8
44 CREDIT_CUSHION_MAX_PERCENT DOUBLE PRECISION 8
45 CCI_APPLICABLE_FLAG CHARACTER VARYING(1) 1
46 POLICY_NAMES CHARACTER VARYING(10) 10
47 ROLLOVER_INTEREST_FLAG CHARACTER VARYING(1) 1
48 ROLLOVER_REPAYMENT_FLAG CHARACTER VARYING(1) 1
49 FREEZE_REPAYMENT_FLAG CHARACTER VARYING(1) 1
50 NUM_OF_DAYS_FRST_DISBRSMNT DOUBLE PRECISION 8
51 NUM_OF_DAYS_FR_ACCOUNT_OPENING DOUBLE PRECISION 8
52 NUM_OF_DAYS_ACCT_OPENING_DIS DOUBLE PRECISION 8
53 CREDIT_CUSHION_MAX_AMT DOUBLE PRECISION 8
54 DEBT_SERVICE_NOMINAL_RATE DOUBLE PRECISION 8
55 REQUESTED_LIMIT_REQD_FLAG CHARACTER VARYING(1) 1
56 INTRST_SENSITIVITY_FLOOR_RATE DOUBLE PRECISION 8
57 INTRST_SENSITIVITY_BUFFER_RATE DOUBLE PRECISION 8
58 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
59 COLLATERAL_REQUIRED CHARACTER VARYING(20) 20
60 INTEREST_REFERSH_REQD_FLAG CHARACTER VARYING(1) 1
61 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
62 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
63 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
64 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8