FCT_OBP_COLLATERAL

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

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 BOOLEAN 1
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 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
38 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
39 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
40 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
41 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8
42 COMMENTS CHARACTER VARYING(3000) 3000
43 IS_CURRENT_FOR_END_OF_DAY CHARACTER VARYING(1) 1
44 BUSINESS_END_OF_DAY_DATE DATE 4
45 IS_CURRENT CHARACTER VARYING(1) 1