OBP24_HST_FLX_LM_CVAL_REQUEST_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_HST_FLX_LM_CVAL_REQUEST_B

Columns
# Name Data Type Length
1 VALUATION_REFERENCE_NUM CHARACTER VARYING(20) 20
2 COLLATERAL_ID CHARACTER VARYING(40) 40
3 RELATED_REFERENCE_CODE CHARACTER VARYING(20) 20
4 VALUATION_REQUEST_DATE TIMESTAMP 8
5 VALUATION_TYPE CHARACTER VARYING(3) 3
6 RELATED_CONTRACT_AMOUNT DOUBLE PRECISION 8
7 RELATED_CONTRACT_CCY_CODE CHARACTER VARYING(6) 6
8 VALUATION_PURPOSE CHARACTER VARYING(5) 5
9 VALUATION_MODE CHARACTER VARYING(3) 3
10 VALUATION_PRIORITY CHARACTER VARYING(5) 5
11 REQUESTOR_COMMENTS CHARACTER VARYING(2000) 2000
12 VALUATION_TRN_TYPE CHARACTER VARYING(5) 5
13 REQUEST_SOURCE_TYPE CHARACTER VARYING(9) 9
14 MINIMUM_NUMBER_OF_VALUERS DOUBLE PRECISION 8
15 CREATED_BY CHARACTER VARYING(254) 254
16 LAST_UPDATED_BY CHARACTER VARYING(254) 254
17 CREATE_DATE TIMESTAMP 8
18 LAST_UPDATE_DATE TIMESTAMP 8
19 VERSION_NUM DOUBLE PRECISION 8
20 DOMAIN_OBJECT_EXTN CHARACTER VARYING(25) 25
21 SOURCED_BY CHARACTER VARYING(20) 20
22 SOURCING_ENTITY_ID CHARACTER VARYING(40) 40
23 SOURCING_ENTITY_NAME CHARACTER VARYING(50) 50
24 SUBDIV_CONS_COLL_FLAG CHARACTER VARYING(1) 1
25 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
26 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
27 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
28 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8