DIM_OBP_COLLATERAL_REALESTATE_PROPERTY_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..DIM_OBP_COLLATERAL_REALESTATE_PROPERTY

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 ADVERSE_ARREARS_COMMENTS CHARACTER VARYING(2000) 2000
6 DOC_DESCRIPTION CHARACTER VARYING(2000) 2000
7 AREA_OF_LAND NUMERIC(24,0) 19
8 BUILDING_SIZE NUMERIC(24,0) 19
9 NUMBER_OF_GARAGES DOUBLE PRECISION 8
10 NUMBER_OF_STORIES DOUBLE PRECISION 8
11 OTHER_ROOM CHARACTER VARYING(20) 20
12 DIMENSION_LENGTH NUMERIC(24,0) 19
13 DIMENSION_WIDTH NUMERIC(24,0) 19
14 LAND_SIZE DOUBLE PRECISION 8
15 PURCHASE_DATE TIMESTAMP 8
16 ROOF_TYPE CHARACTER VARYING(20) 20
17 WALL_MATERIAL CHARACTER VARYING(20) 20
18 YEAR_BUILT DOUBLE PRECISION 8
19 AREA_UNIT_CODE CHARACTER VARYING(20) 20
20 UNDERCONSTRUCTION_FLAG CHARACTER VARYING(1) 1
21 INCOME_PRODUCING_FLAG CHARACTER VARYING(1) 1
22 RESTRICTED_FLAG CHARACTER VARYING(1) 1
23 BASEL_USE_TYPE CHARACTER VARYING(50) 50
24 LEASE_NUMBER CHARACTER VARYING(10) 10
25 LEASE_DATE TIMESTAMP 8
26 LEASE_MATURITY_DATE TIMESTAMP 8
27 LEASE_RENT_PAID_DATE TIMESTAMP 8
28 LEASE_TERM DOUBLE PRECISION 8
29 LEASE_TERM_DAYS DOUBLE PRECISION 8
30 LEASE_TERM_MONTHS DOUBLE PRECISION 8
31 LANDLORD_NAME CHARACTER VARYING(50) 50
32 LANDLORD_ADDRESS CHARACTER VARYING(300) 300
33 COMMERCIAL_LEASE_MATURITY_DATE TIMESTAMP 8
34 COMMERCIAL_LEASE_RENT_PAID_DATE TIMESTAMP 8
35 NUMBER_OF_BEDROOMS NUMERIC(20,0) 19
36 PRIMARY_RESIDENCE_FLAG CHARACTER VARYING(1) 1
37 OCCUPANCY_TYPE CHARACTER VARYING(20) 20
38 NATURE_TYPE CHARACTER VARYING(10) 10
39 COLLATERAL_VALUTION_INDEX DOUBLE PRECISION 8
40 VALUTION_INDEX DOUBLE PRECISION 8
41 AUTO_CONSOLE CHARACTER VARYING(3) 3
42 BUSINESS_END_OF_DAY_DATE DATE 4
43 IS_CURRENT_FOR_END_OF_DAY CHARACTER VARYING(1) 1
44 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
45 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8
46 IS_CURRENT CHARACTER VARYING(1) 1
47 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
48 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
49 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8