FCT_BNK_VERIFICATION_OFFICER_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 LENDER_USER_ID CHARACTER VARYING(254) 254
2 LENDER_NAME CHARACTER VARYING(201) 201
3 BRANCH_NAME CHARACTER VARYING(105) 105
4 REGION CHARACTER VARYING(240) 240
5 CHANNEL CHARACTER VARYING(14) 14
6 VERIFICATION_OFFICER_USER_ID CHARACTER VARYING(254) 254
7 VERIFICATION_OFFICER_NAME CHARACTER VARYING(201) 201
8 SUBMISSION_ID CHARACTER VARYING(50) 50
9 APPLICATION_ID CHARACTER VARYING(50) 50
10 COLLATERAL_ID CHARACTER VARYING(18) 18
11 APPLICATION_SUBMISSION_DATE TIMESTAMP 8
12 PRODUCT_GROUP CHARACTER VARYING(50) 50
13 VERIFICATION_DATE TIMESTAMP 8
14 VERIFICATION_TASK CHARACTER VARYING(36) 36
15 VERIFICATION_NAME CHARACTER VARYING(54) 54
16 DECISION_OUTCOME CHARACTER VARYING(50) 50
17 NUMBER_OF_DECLINES BIGINT 8
18 DECLINE_REASON CHARACTER VARYING(2000) 2000