OBP24_HST_FLX_LM_CVAL_REQUEST_H

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

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