DIM_BNK_SLN_ORIGINAL_FLAGS

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 TIMESTAMP 8
4 ORIG_QUALITY_STANDARD_FLAG CHARACTER VARYING(1) 1
5 ORIG_QUALITY_STANDARD_DATE TIMESTAMP 8
6 ORIG_QUALITY_REASONS CHARACTER VARYING(100) 100
7 ORIG_QUALITY_REASONS_DATE TIMESTAMP 8
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(80) 80
12 ORIG_APP_CAPTURE_USER_WB CHARACTER VARYING(40) 40
13 ORIG_APP_CAPTURE_USER_DATE TIMESTAMP 8
14 ORIG_SALES_OFFICER_ID CHARACTER VARYING(254) 254
15 ORIG_SALES_OFFICER_NAME CHARACTER VARYING(80) 80
16 ORIG_SALES_OFFICER_WB CHARACTER VARYING(40) 40
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(4) 4
23 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
24 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
25 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8