FCT_BNK_QRM_COLLATERAL_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

Collateral Extract consumed by QRM, showing collateral details are collateral ID grain

Synonyms

SDSNZP02_BANK..UBAR_FCT_BNK_QRM_COLLATERAL_INSIGHT

Columns
# Name Data Type Length
1 COLLATERAL_ID CHARACTER VARYING(18) 18
2 COLLATERAL_TYPE CHARACTER VARYING(50) 50
3 COLLATERAL_CATEGORY CHARACTER VARYING(50) 50
4 COLLATERAL_SUB_CATEGORY CHARACTER VARYING(50) 50
5 COLLATERAL_DESCRIPTION CHARACTER VARYING(255) 255
6 BANK_HAIRCUT_VALUE SMALLINT 2
7 CATEGORIZED_HAIRCUT_VALUE SMALLINT 2
8 BEGIN_DATE TIMESTAMP 8
9 END_DATE TIMESTAMP 8
10 REVIEW_DATE TIMESTAMP 8
11 REVALUATION_REQUIRED CHARACTER VARYING(1) 1
12 REVALUATION_DATE TIMESTAMP 8
13 AVAILABLE_FLAG CHARACTER VARYING(1) 1
14 CATEGORIZATION_VALUE DOUBLE PRECISION 8
15 CCY_CODE CHARACTER VARYING(3) 3
16 OWNER_ESTIMATED_VALUE DOUBLE PRECISION 8
17 CAPITALIZATION_VALUE DOUBLE PRECISION 8
18 BANK_VALUE_RELIED_ON DOUBLE PRECISION 8
19 MARKET_VALUE DOUBLE PRECISION 8
20 BANK_VALUE DOUBLE PRECISION 8
21 REPOSSESS_REQUIRED CHARACTER VARYING(1) 1
22 CONTRACT_OF_SALE_VALUE DOUBLE PRECISION 8
23 CONTRACT_OF_SALE_DATE TIMESTAMP 8
24 OWNERSHIP_TYPE CHARACTER VARYING(1) 1
25 EXCLUSIVE_CHARGE CHARACTER VARYING(1) 1
26 VALUATION_FREQUENCY CHARACTER VARYING(20) 20
27 DEDUPE_TEXT CHARACTER VARYING(5) 5
28 ADDRESS_LINE1 CHARACTER VARYING(35) 35
29 ADDRESS_LINE2 CHARACTER VARYING(35) 35
30 ADDRESS_LINE3 CHARACTER VARYING(35) 35
31 ADDRESS_LINE4 CHARACTER VARYING(35) 35
32 ADDRESS_CITY CHARACTER VARYING(50) 50
33 ADDRESS_STATE CHARACTER VARYING(30) 30
34 ADDRESS_COUNTRY CHARACTER VARYING(30) 30
35 ADDRESS_ZIP CHARACTER VARYING(30) 30
36 OBJECT_STATUS_FLAG CHARACTER(1) 1
37 COMMENTS CHARACTER VARYING(3000) 3000