FCT_ASIC516_COMPLAINT_EXTRACT_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 BROKER_GIVEN_NAMES CHARACTER VARYING(255) 255
2 BROKER_SURNAME CHARACTER VARYING(255) 255
3 LENDER_BROKER_CODE CHARACTER VARYING(19) 19
4 BROKER_STATE CHARACTER VARYING(240) 240
5 AGGREGATOR_NAME NATIONAL CHARACTER VARYING(250) 250
6 UNIQUE_IDENTIFIER CHARACTER VARYING(255) 255
7 REPORTING_DATE TIMESTAMP 8
8 SOURCE_LENDER CHARACTER VARYING(40) 40
9 REFERENCE_NUMBER CHARACTER VARYING(100) 100
10 EDR_COMMENCEMENT DATE 4
11 DETAILS CHARACTER VARYING(10) 10
12 RELATIVE_QUARTER INTEGER 4