OBP24_FLX_LM_CERTIFICATE_TITLE_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COLLATERAL_ID CHARACTER VARYING(18) 18
2 SERIAL_NUM INTEGER 4
3 HELD_ELECTRONICALLY CHARACTER VARYING(40) 40
4 STATUS_DATE TIMESTAMP 8
5 ENCUMBRANCE CHARACTER VARYING(255) 255
6 FOLIO_NUM CHARACTER VARYING(40) 40
7 IDENTIFIER_NUM CHARACTER VARYING(40) 40
8 INSTRUMENT_NUM CHARACTER VARYING(40) 40
9 VOLUME_NUM CHARACTER VARYING(40) 40
10 LOT_DESCRIPTION CHARACTER VARYING(255) 255
11 PARENT_TITLE CHARACTER VARYING(40) 40
12 PARISH CHARACTER VARYING(50) 50
13 PART_OF_LAND CHARACTER VARYING(100) 100
14 PLAN_NUM CHARACTER VARYING(40) 40
15 PLAN_DESC CHARACTER VARYING(2000) 2000
16 TOWN_LOCATION CHARACTER VARYING(50) 50
17 TITLE_STATUS CHARACTER VARYING(20) 20
18 TITLE_AMOUNT DOUBLE PRECISION 8
19 TITLE_CCY_CODE CHARACTER VARYING(3) 3
20 TITLE_REFERENCE CHARACTER VARYING(40) 40
21 DISTRICT_DIVISION CHARACTER VARYING(50) 50
22 TITLE_SECTION CHARACTER VARYING(40) 40
23 BLOCK CHARACTER VARYING(40) 40
24 UNIT CHARACTER VARYING(40) 40
25 COUNTY CHARACTER VARYING(40) 40
26 PLAN_REGISTERED_FLAG CHARACTER VARYING(1) 1
27 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
28 EXTENT_OF_LAND CHARACTER VARYING(40) 40
29 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
30 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
31 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
32 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8