OBP24_HST_FLX_OR_ORIG_PREFS

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BUSINESS_UNIT CHARACTER VARYING(40) 40
2 MARKET_ENTITY CHARACTER VARYING(40) 40
3 SUBMISSION_EXPIRY_DAYS SMALLINT 2
4 SUBMISSION_EXPIRY_MONTHS SMALLINT 2
5 SUBMISSION_PURGE_DAYS SMALLINT 2
6 SUBMISSION_PURGE_MONTHS SMALLINT 2
7 DECISION_VALIDITY_DAYS SMALLINT 2
8 SUBMISSION_EXPIRY_LEAD_DAYS SMALLINT 2
9 SUBMISSION_EXPIRY_LAG_DAYS SMALLINT 2
10 OFFER_EXPIRY_LEAD_DAYS SMALLINT 2
11 OFFER_EXPIRY_LAG_DAYS SMALLINT 2
12 OBJECT_VERSION_NUMBER DOUBLE PRECISION 8
13 CREATED_BY CHARACTER VARYING(254) 254
14 CREATION_DATE TIMESTAMP 8
15 LAST_UPDATED_BY CHARACTER VARYING(254) 254
16 LAST_UPDATE_DATE TIMESTAMP 8
17 OBJECT_STATUS CHARACTER VARYING(1) 1
18 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
19 LRM_CONDITION_CODE CHARACTER VARYING(8) 8
20 APPLICATION_FORM_DOCUMENT_TYPE CHARACTER VARYING(40) 40
21 CREDIT_MEMO_DOCUMENT_TYPE CHARACTER VARYING(40) 40
22 IPA_SUBMISSION_EXPIRY_DAYS SMALLINT 2
23 IPA_SUBMISSION_EXPIRY_MONTHS SMALLINT 2
24 IPA_VALIDITY_DAYS SMALLINT 2
25 IPA_VALIDITY_MONTHS SMALLINT 2
26 IPA_REQUEST_PURGE_DAYS SMALLINT 2
27 IPA_REQUEST_PURGE_MONTHS SMALLINT 2
28 TERM_SHEET_EXPIRY_LEAD_DAYS SMALLINT 2
29 SUBMISSION_INCOMPLETE_DAYS SMALLINT 2
30 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
31 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
32 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
33 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8