FCT_BNK_LOAN_ORIGINATION_2_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

OBP Part 2 of Loan Origination Report. Displays the percent of applications at various stages of loan processing

Source Object (CTAS)

SDSNZP05_BANK..FCT_BNK_LOAN_ORIGINATION_2

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