OBP24_HST_FLX_OR_CD_SUBMISSIONS_H

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DECISION_ID CHARACTER VARYING(50) 50
2 SUBMISSION_ID CHARACTER VARYING(50) 50
3 DECISION_BY CHARACTER VARYING(40) 40
4 ENTITY_TYPE CHARACTER VARYING(50) 50
5 STAGE_TYPE CHARACTER VARYING(50) 50
6 DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
7 DECISION_DATE TIMESTAMP 8
8 RSN_REF_ID CHARACTER VARYING(210) 210
9 MAN_DECISION_STATUS CHARACTER VARYING(50) 50
10 AUTH_DECISION_STATUS CHARACTER VARYING(50) 50
11 CREDIT_MEMO_REQ CHARACTER(1) 1
12 CREDIT_MEMO_ID CHARACTER VARYING(50) 50
13 SUB_CALL_REF_NUM CHARACTER VARYING(50) 50
14 DOWNSELL_STATUS CHARACTER VARYING(50) 50
15 DECISION_COMMENTS CHARACTER VARYING(254) 254
16 OVERVIEW_REQ CHARACTER(1) 1
17 OVERVIEW_DONE CHARACTER(1) 1
18 OVERVIEW_COMMENTS CHARACTER VARYING(254) 254
19 OVERVIEW_DATE TIMESTAMP 8
20 WORKITEM_ID CHARACTER VARYING(50) 50
21 APPROVER_ID CHARACTER VARYING(50) 50
22 FRAUD_STATUS_TYPE CHARACTER VARYING(50) 50
23 FRAUD_REASON CHARACTER VARYING(50) 50
24 MANUAL_FRAUD_STATUS CHARACTER VARYING(50) 50
25 COMMENTS CHARACTER VARYING(50) 50
26 CONDITION_WAIVED CHARACTER(1) 1
27 COVENANT_WAIVED CHARACTER(1) 1
28 VALUATION_WAIVED CHARACTER(1) 1
29 VERIFICATION_WAIVED CHARACTER(1) 1
30 AGGREGATE_LIMIT DOUBLE PRECISION 8
31 PERSONAL_AAA_AGGR DOUBLE PRECISION 8
32 PERSONAL_EXCESS DOUBLE PRECISION 8
33 CREATED_BY CHARACTER VARYING(254) 254
34 CREATION_DATE TIMESTAMP 8
35 LAST_UPDATED_BY CHARACTER VARYING(254) 254
36 LAST_UPDATE_DATE TIMESTAMP 8
37 OBJECT_VERSION_NUMBER INTEGER 4
38 OBJECT_STATUS CHARACTER(1) 1
39 DECISION_EXPIRY_DATE TIMESTAMP 8
40 OUTSIDE_AMOUNT_PRE_LOAN DOUBLE PRECISION 8
41 OUTSIDE_AMOUNT_PRE_LOAN_CCY CHARACTER VARYING(5) 5
42 OUTSIDE_AMOUNT_POST_LOAN DOUBLE PRECISION 8
43 OUTSIDE_AMOUNT_POST_LOAN_CCY CHARACTER VARYING(5) 5
44 WITHIN_AMOUNT_PRE_LOAN DOUBLE PRECISION 8
45 WITHIN_AMOUNT_PRE_LOAN_CCY CHARACTER VARYING(5) 5
46 WITHIN_AMOUNT_POST_LOAN DOUBLE PRECISION 8
47 WITHIN_AMOUNT_POST_LOAN_CCY CHARACTER VARYING(5) 5
48 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
49 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
50 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
51 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8