Name |
|
Comment |
Identifies the set of connections associated with a node. There are up to four. Up to two for each facility/node combination. |
Name |
ConnectionPointId |
EffectiveDate |
FacilityId |
FlowDirection |
NodeId |
VersionDateTime |
Name |
Data Type |
Mandatory |
Comment |
FacilityId |
NUMBER(10,0) |
X |
Unique Facility Identifier |
EffectiveDate |
DATE |
X |
Effective date of the record |
VersionDateTime |
DATE |
X |
Version timestamp of the record |
NodeId |
NUMBER(10,0) |
X |
Unique Node Identifier |
ConnectionPointId |
NUMBER(10,0) |
X |
Unique connection point identifier. |
FlowDirection |
VARCHAR2(20) |
X |
Direction of flow for the submission record. Must be one of ‘RECEIPT’ or ‘DELIVERY’ |
IsExempt |
NUMBER(1,0) |
|
Submissions are not required if this is set to 1. |
HasAggregationPriority |
NUMBER(1,0) |
|
If 1, this will be used for aggregating. |
ConnectionPointName |
VARCHAR2(200) |
|
Name of the Connection point |
Mirn |
VARCHAR2(20) |
|
Meter Installation Registration Number – (MIRN). Unique identifier for the Victorian DTS delivery or supply point, used to retrieve the Daily Actual Flow and Nomination and Forecast from DWGM. |
HasForecast |
NUMBER(1,0) |
|
Used to determine the MIRN required for Nomination and Forecast from DWGM. |
CONNECTIONPOINTSHORTNAME |
VARCHAR2(30) |
|
An abbreviation of the connection point name |
EXEMPTIONDESCRIPTION |
VARCHAR2(200) |
|
Description of the exemption |
|
|
|