|
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 |
|
|
|