TRANSMISSIONLOSSFACTOR
TRANSMISSIONLOSSFACTOR shows the Transmission Loss factors applied at each connection point.
Package
MARKET_CONFIG
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| EFFECTIVEDATE |
datetime(3)  |
datetime2(0) |
Effective date of record |
| VERSIONNO |
numeric(22, 0) |
smallint |
Version no of record for given effective date |
| CONNECTIONPOINTID |
varchar(10) |
varchar(10) |
Connection Point ID |
| TRANSMISSIONLOSSFACTOR |
numeric(15, 5) (not nullable) |
numeric(15, 5) (not nullable) |
Used in Bidding, Dispatch and Settlements. For Bidding and Dispatch, where the DUID is a BDU with DISPATCHTYPE of BIDIRECTIONAL, the TLF for the load component of the BDU. For Settlements, where dual TLFs apply, the primary TLF is applied to all energy (load and generation) when the Net Energy Flow of the ConnectionPointID in the interval is negative (net load). |
| REGIONID |
varchar(10) |
varchar(10) |
Region Identifier |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Record creation timestamp |
| SECONDARY_TLF |
numeric(18, 8) |
numeric(18, 8) |
Used in Bidding, Dispatch and Settlements, only populated where Dual TLFs apply. For Bidding and Dispatch, the TLF for the generation component of a BDU, when null the TRANSMISSIONLOSSFACTOR is used for both the load and generation components. For Settlements, the secondary TLF is applied to all energy (load and generation) when the Net Energy Flow of the ConnectionPointID in the interval is positive (net generation). |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| TRANSMISSIONLOSSFACTOR_LCX |
nonclustered |
LASTCHANGED |
| TRANSMISSIONLOSSFACTOR_PK |
clustered, unique, primary key |
CONNECTIONPOINTID, EFFECTIVEDATE, VERSIONNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_TRANSMISSIONLOSSFACTOR_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_TRANSMISSIONLOSSFACTOR |
clustered, unique, primary key |
CONNECTIONPOINTID, EFFECTIVEDATE, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| TRANSMISSIONLOSSFACTOR_LCX |
nonclustered |
LASTCHANGED |
| TRANSMISSIONLOSSFACTOR_PK |
clustered, unique, primary key |
CONNECTIONPOINTID, EFFECTIVEDATE, VERSIONNO |