Table: PARTICIPANTACCOUNT

PARTICIPANTACCOUNT

Name

PARTICIPANTACCOUNT

Comment

PARTICIPANTACCOUNT shows financial details on participants.


Description

PARTICIPANTACCOUNT data is confidential to the relevant participant.

Source

PARTICIPANTACCOUNT updates as new participants register or existing participants change details.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

PARTICIPANTID


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

ACCOUNTNAME

VARCHAR2(80)

 

Name of the account

PARTICIPANTID

VARCHAR2(10)

X

Unique participant identifier

ACCOUNTNUMBER

VARCHAR2(16)

 

Account number

BANKNAME

VARCHAR2(16)

 

Bank name

BANKNUMBER

NUMBER(10,0)

 

Bank number

BRANCHNAME

VARCHAR2(16)

 

Branch name

BRANCHNUMBER

NUMBER(10,0)

 

Branch number

BSBNUMBER

VARCHAR2(20)

 

BSB number

NEMMCOCREDITACCOUNTNUMBER

NUMBER(10,0)

 

AEMO credit account number

NEMMCODEBITACCOUNTNUMBER

NUMBER(10,0)

 

AEMO debit account number

AUTHORISEDBY

VARCHAR2(15)

 

User authorising record

AUTHORISEDDATE

DATE

 

Authorised date

EFFECTIVEDATE

DATE

 

Date record authorised

LASTCHANGED

DATE

 

Last date and time record changed

ABN

VARCHAR2(20)

 

Australian Business Number