NOTE: All data to be presented as text, but to contain numeric content so that the file can be statistically analyses by the LGA following uploading and parsing.
First record to state licensee name, all selection parameters used for the data extract and any offset between Timestamp and CET applicable to records.
Last record to list relevant field headings used and act as an end of file indicator.
Fields to be TAB delimited
| TIMESTAMP | YYYY-MM-DDThh:mm:ss (as per ISO 8601) |
| PLAYER_ID | NNNNNNN (as found in Gaming transaction files) |
| REG_NATION | CC (as per ISO 3166-1 alpha-2 international codes) |
| REG_DOB | YYYY-MM-DDThh:mm:ss (as per ISO 8601) |
| LAST_LOGIN | YYYY-MM-DDThh:mm:ss (as per ISO 8601) |
| CURRENCY | CCC (see ISO-4217, convertable currencies only) |
| BET_IN_MONTH | NNNNNNN (use decimal point format) |
| BALANCE_MONTH_END | NNNNNNN (use decimal point format) |
| PENDING_TRANSFER | NNNNNNN (use decimal point format) |
| CASINO_CHIPS_VALUE | NNNNNNN (use decimal point format) |
TIMESTAMP when record was extracted
PLAYER_ID to show the unique player identifier as used in the betting transaction
REG_NATION is to hold the official nation code of the players registered address
REG_DOB is to hold the date of birth declared by the player at registration
LAST_LOGIN when player last accessed their account regardless of their action
CURRENCY is that relevant to each players account in the gaming system
BET_IN_MONTH to show sale value of bets contracted in month by player
BALANCE_MONTH_END is to show the value of the players account including all deposits, wins, transfers, adjustments, bonuses completed by month end.
PENDING_TRANSFER should show credits not yet available for use by the players in the gaming system due to delay in clearing. Chargebacks to be shown as negative amount in this field if not yet reflected in BALANCE_MONTH_END
CASINO_CHIPS_VALUE and POKER_ROOM_VALUE are to be used if the operator runs a "sub-wallet" for such games which stores part of the player funds between sessions. If not relevant, these fields can be left out of the file entirely.
