DIM_OBP_SLN_ORIGINAL_FLAGS_UPL_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 APPLICATION_ID CHARACTER VARYING(50) 50
2 ORIG_PREAPPROVED_FLAG CHARACTER VARYING(1) 1
3 ORIG_PREAPPROVED_DATE CHARACTER VARYING(1) 1
4 ORIG_QUALITY_STANDARD_FLAG CHARACTER VARYING(1) 1
5 ORIG_QUALITY_STANDARD_DATE CHARACTER VARYING(1) 1
6 ORIG_QUALITY_REASONS CHARACTER VARYING(1) 1
7 ORIG_QUALITY_REASONS_DATE CHARACTER VARYING(1) 1
8 ORIG_CDTL_APPROVAL_DT TIMESTAMP 8
9 ORIG_UCDTL_APPROVAL_DT TIMESTAMP 8
10 ORIG_APP_CAPTURE_USER_ID CHARACTER VARYING(254) 254
11 ORIG_APP_CAPTURE_USER_NAME CHARACTER VARYING(50) 50
12 ORIG_APP_CAPTURE_USER_WB CHARACTER VARYING(1) 1
13 ORIG_APP_CAPTURE_USER_DATE TIMESTAMP 8
14 ORIG_SALES_OFFICER_ID CHARACTER VARYING(254) 254
15 ORIG_SALES_OFFICER_NAME CHARACTER VARYING(50) 50
16 ORIG_SALES_OFFICER_WB CHARACTER VARYING(1) 1
17 ORIG_SALES_OFFICER_DATE TIMESTAMP 8
18 ORIG_SALES_BRANCH CHARACTER VARYING(10) 10
19 ORIG_SALES_BRANCH_DATE TIMESTAMP 8
20 ORIG_SETTLEMENT_BRANCH CHARACTER VARYING(240) 240
21 ORIG_SETTLEMENT_BRANCH_DATE TIMESTAMP 8
22 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
23 CDC_RECORD_TYPE CHARACTER VARYING(6) 6
24 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
25 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8