DIM_OBP_COLLATERAL_REF

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 COLLATERAL_TYPE CHARACTER VARYING(50) 50
2 COLLATERAL_CATEGORY CHARACTER VARYING(50) 50
3 IS_INSURABLE CHARACTER VARYING(1) 1
4 IS_VALUTION_REQUIRED CHARACTER VARYING(1) 1
5 IS_TITLE_SEARCH_REQUIRED CHARACTER VARYING(1) 1
6 REGISTRATION_REQUIRED_FLAG CHARACTER VARYING(1) 1
7 STAMPING_REQUIRED_FLAG CHARACTER VARYING(1) 1
8 VALUTION_VALIDITY_DAYS SMALLINT 2
9 TITLE_SEARCH_VALIDITY_DAYS SMALLINT 2
10 REVAL_FREQUENCY CHARACTER VARYING(24) 24
11 ASSESSED_VALUES CHARACTER VARYING(24) 24
12 CHARGE_TYPE CHARACTER VARYING(24) 24
13 IS_CHARGE_APPLICABLE CHARACTER VARYING(1) 1
14 RULE_ID CHARACTER VARYING(50) 50
15 COLLATERAL_EXPIRY_NOTICE_DAYS SMALLINT 2
16 OBJECT_STATUS CHARACTER VARYING(1) 1
17 BANK_VALUE_HAIRCUT INTEGER 4
18 CATEGORIZATION_HAIRCUT INTEGER 4
19 BUSINESS_END_OF_DAY_DATE DATE 4