OBP24_FLX_LM_COLLATERAL_ALL_B
Description
Synonyms
SDSNZP05_BANK..CBP_OBP_FLX_LM_COLLATERAL_ALL_B
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 | ADDRESS_LINE1 | CHARACTER VARYING(35) | 35 |
| 28 | ADDRESS_LINE2 | CHARACTER VARYING(35) | 35 |
| 29 | ADDRESS_LINE3 | CHARACTER VARYING(35) | 35 |
| 30 | ADDRESS_LINE4 | CHARACTER VARYING(35) | 35 |
| 31 | ADDRESS_CITY | CHARACTER VARYING(50) | 50 |
| 32 | ADDRESS_STATE | CHARACTER VARYING(30) | 30 |
| 33 | ADDRESS_COUNTRY | CHARACTER VARYING(30) | 30 |
| 34 | ADDRESS_ZIP | CHARACTER VARYING(30) | 30 |
| 35 | CREATED_BY | CHARACTER VARYING(254) | 254 |
| 36 | CREATION_DATE | TIMESTAMP | 8 |
| 37 | LAST_UPDATED_BY | CHARACTER VARYING(254) | 254 |
| 38 | LAST_UPDATE_DATE | TIMESTAMP | 8 |
| 39 | OBJECT_VERSION_NUMBER | INTEGER | 4 |
| 40 | OBJECT_STATUS_FLAG | CHARACTER(1) | 1 |
| 41 | DOMAIN_OBJECT_EXTN | CHARACTER VARYING(100) | 100 |
| 42 | DEDUPE_TEXT | CHARACTER VARYING(2000) | 2000 |
| 43 | DOC_CHECKLIST_ID | CHARACTER VARYING(40) | 40 |
| 44 | PARENT_COLLATERALS | CHARACTER VARYING(120) | 120 |
| 45 | ADDRESS_LINE5 | CHARACTER VARYING(120) | 120 |
| 46 | ADDRESS_LINE6 | CHARACTER VARYING(120) | 120 |
| 47 | ADDRESS_LINE7 | CHARACTER VARYING(120) | 120 |
| 48 | ADDRESS_LINE8 | CHARACTER VARYING(120) | 120 |
| 49 | ADDRESS_LINE9 | CHARACTER VARYING(120) | 120 |
| 50 | ADDRESS_LINE10 | CHARACTER VARYING(120) | 120 |
| 51 | ADDRESS_LINE11 | CHARACTER VARYING(120) | 120 |
| 52 | ADDRESS_LINE12 | CHARACTER VARYING(120) | 120 |
| 53 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 54 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 55 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 56 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |