OBP24_HST_FLX_OR_SUBMISSION_SUMMARY_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SUBMISSION_ID CHARACTER VARYING(50) 50
2 ENTITY_NAME CHARACTER VARYING(100) 100
3 KEYASSTRING CHARACTER VARYING(100) 100
4 POSTING_DATE TIMESTAMP 8
5 SUMMARY_TEXT CHARACTER VARYING(2000) 2000
6 RESTURL CHARACTER VARYING(50) 50
7 APPLICATION_BRANCH CHARACTER VARYING(10) 10
8 DATA_ENTRY_BRANCH CHARACTER VARYING(10) 10
9 SUBMISSION_DATE TIMESTAMP 8
10 CREATION_DATE TIMESTAMP 8
11 TOTAL_REQUEST_AMOUNT DOUBLE PRECISION 8
12 TOTAL_REQUEST_AMOUNT_CCY CHARACTER VARYING(3) 3
13 TOTAL_APPROVED_AMOUNT DOUBLE PRECISION 8
14 TOTAL_APPROVED_AMOUNT_CCY CHARACTER VARYING(3) 3
15 PARTY_NAMES CHARACTER VARYING(2000) 2000
16 SOURCED_BY CHARACTER VARYING(10) 10
17 APPLICATION_ID CHARACTER VARYING(50) 50
18 APPLICATION_STATUS CHARACTER VARYING(50) 50
19 SUBMISSION_STATUS CHARACTER VARYING(50) 50
20 BUSINESS_UNIT CHARACTER VARYING(40) 40
21 MARKET_ENTITY CHARACTER VARYING(40) 40
22 APPLICATION_DESCRIPTION CHARACTER VARYING(2000) 2000
23 INITIATED_BY CHARACTER VARYING(40) 40
24 APPLICATION_STATUS_STATE_TYPE CHARACTER VARYING(50) 50
25 APPLICATION_AMOUNTS CHARACTER VARYING(2000) 2000
26 ENTITY_STATUS CHARACTER(1) 1
27 IS_IPA CHARACTER(1) 1
28 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
29 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
30 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
31 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8