FCT_BNK_LOAN_ORIGINATION_2_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 CHANNEL CHARACTER VARYING(10) 10
2 APPLICATION_ID CHARACTER VARYING(50) 50
3 SUBMISSION_ID CHARACTER VARYING(50) 50
4 LODGED_DT TIMESTAMP 8
5 LODGED_MT BIGINT 8
6 LODGED_PERIOD CHARACTER VARYING(200) 200
7 LODGED_PERIOD_DESC CHARACTER VARYING(403) 403
8 APPROVED_DT TIMESTAMP 8
9 APPROVED_MT BIGINT 8
10 APPROVED_PERIOD CHARACTER VARYING(200) 200
11 DECLINED_DT TIMESTAMP 8
12 DECLINED_PERIOD CHARACTER VARYING(200) 200
13 SETTLED_DT TIMESTAMP 8
14 SETTLED_MT BIGINT 8
15 SETTLED_PERIOD CHARACTER VARYING(200) 200
16 WITHDRAWN_DT TIMESTAMP 8
17 WITHDRAWN_PERIOD CHARACTER VARYING(200) 200
18 LODGED_COUNT INTEGER 4
19 APPROVED_COUNT INTEGER 4
20 SETTLED_COUNT INTEGER 4
21 DECLINED_COUNT INTEGER 4
22 WITHDRAWN_COUNT INTEGER 4