FCT_ASIC516_SALES_INCREASE_DASHBOARD_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 PORTFOLIO_DATE TIMESTAMP 8
2 AGGREGATOR_NAME NATIONAL CHARACTER VARYING(250) 250
3 BROKER_NAME CHARACTER VARYING(511) 511
4 UNIQUE_IDENTIFIER CHARACTER VARYING(255) 255
5 A_CODE CHARACTER VARYING(19) 19
6 LICENSE_TYPE NATIONAL CHARACTER VARYING(15) 15
7 PREVIOUS_YEAR_PORTFOLIO_SIZE NUMERIC(38,4) 19
8 PREVIOUS_YEAR_PORTFOLIO_COUNT NUMERIC(38,0) 19
9 CURRENT_YEAR_PORTFOLIO_SIZE NUMERIC(38,4) 19
10 CURRENT_YEAR_PORTFOLIO_COUNT NUMERIC(38,0) 19
11 DATA_REFRESH_TIMESTAMP TIMESTAMP 8