FCT_BNK_LENDING_SERVICES_LODGEMENT_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 NO_LODGED CHARACTER VARYING(20) 20
2 NO_FILES_SHOWSTOPPED CHARACTER VARYING(20) 20
3 NO_OUTSTANDING_SHOWSTOPPED_FILES CHARACTER VARYING(20) 20
4 NO_FILES_SENT_GEN_LS CHARACTER VARYING(20) 20
5 COUNT_NO_LODGED INTEGER 4
6 COUNT_NO_FILES_SHOWSTOPPED INTEGER 4
7 COUNT_NO_OUTSTANDING_SHOWSTOPPED_FILES INTEGER 4
8 COUNT_NO_FILES_SENT_GEN_LS INTEGER 4
9 LODGED_UPDATEDDATE DATE 4
10 FILES_SHOWSTOPPED_UPDATEDDATE DATE 4
11 OUTSTANDING_FILES_SHOWSTOPPED_UPDATEDDATE DATE 4
12 FILES_SENT_GEN_LS_UPDATEDDATE DATE 4
13 MAIN_UPDATEDDATE DATE 4
14 PERIOD_DT TIMESTAMP 8
15 PROTECTEDFORMATTRIBUTE1 CHARACTER VARYING(20) 20