BILLSMELTERRATE (Historical table)
BILLSMELTERRATE is standing data, setting out the rates used in smelter reduction calculations.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| EFFECTIVEDATE |
datetime(3)  |
datetime2(0) |
Calendar settlement date record becomes effective |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version no of the record for the given effective date |
| CONTRACTYEAR |
numeric(22, 0) |
smallint |
AEMO Contract Year number starting in week containing 1st January |
| RAR1 |
numeric(6, 2) |
numeric(6, 2) |
Smelter rate 1 |
| RAR2 |
numeric(6, 2) |
numeric(6, 2) |
Smelter rate 2 |
| AUTHORISEDDATE |
datetime(3) |
datetime2(0) |
Authorised date |
| AUTHORISEDBY |
varchar(10) |
varchar(10) |
Who authorised |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLSMELTERRATE_LCX |
nonclustered |
LASTCHANGED |
| BILLSMELTERRATE_PK |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, CONTRACTYEAR |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_BILLSMELTERRATE_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_BILLSMELTERRATE |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, CONTRACTYEAR |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLSMELTERRATE_LCX |
nonclustered |
LASTCHANGED |
| BILLSMELTERRATE_PK |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, CONTRACTYEAR |