PARTICIPANTACCOUNT
PARTICIPANTACCOUNT shows financial details on participants.
Package
PARTICIPANT_REGISTRATION
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PARTICIPANTID |
varchar(10)  |
varchar(10) |
Unique participant identifier |
| ACCOUNTNAME |
varchar(80) |
varchar(80) |
Name of the account |
| ACCOUNTNUMBER |
varchar(16) |
varchar(16) |
Account number |
| BANKNAME |
varchar(16) |
varchar(16) |
Bank name |
| BANKNUMBER |
numeric(10, 0) |
bigint |
Bank number |
| BRANCHNAME |
varchar(16) |
varchar(16) |
Branch name |
| BRANCHNUMBER |
numeric(10, 0) |
bigint |
Branch number |
| BSBNUMBER |
varchar(20) |
varchar(20) |
BSB number |
| NEMMCOCREDITACCOUNTNUMBER |
numeric(10, 0) |
bigint |
AEMO credit account number |
| NEMMCODEBITACCOUNTNUMBER |
numeric(10, 0) |
bigint |
AEMO debit account number |
| AUTHORISEDBY |
varchar(15) |
varchar(15) |
User authorising record |
| AUTHORISEDDATE |
datetime(3) |
datetime2(0) |
Authorised date |
| EFFECTIVEDATE |
datetime(3) |
datetime2(0) |
Date record authorised |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| ABN |
varchar(20) |
varchar(20) |
Australian Business Number |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PARTICIPANTACCOUNT_LCX |
nonclustered |
LASTCHANGED |
| PARTICIPANTACCOUNT_PK |
clustered, unique, primary key |
PARTICIPANTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_PARTICIPANTACCOUNT_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_PARTICIPANTACCOUNT |
clustered, unique, primary key |
PARTICIPANTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PARTICIPANTACCOUNT_LCX |
nonclustered |
LASTCHANGED |
| PARTICIPANTACCOUNT_PK |
clustered, unique, primary key |
PARTICIPANTID |