|
Name |
|
|
Comment |
APCCOMP is to set out Administered Price Cap (APC) compensation periods for a participant. |
|
APCCOMP is public data, and is available to all participants. Source APCCOMP is empty until an Administered Price Cap event occurs. Not in use - never used |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
APCID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
APCID |
VARCHAR2(10) |
X |
APC event identifier. |
|
REGIONID |
VARCHAR2(10) |
|
Region |
|
STARTDATE |
DATE |
|
Settlement start date |
|
STARTPERIOD |
NUMBER(3,0) |
|
Settlement start period (1-48) |
|
ENDDATE |
DATE |
|
Settlement end date |
|
ENDPERIOD |
NUMBER(3,0) |
|
Settlement end period (1-48) |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
APCCOMPAMOUNT shows the Administered Price Cap (APC) compensation amount. |
|
Confidential to participants. Source Updated with settlement positive and issued with daily data.
Not in use - never used |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
APCID |
|
PARTICIPANTID |
|
PERIODID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
APCID |
VARCHAR2(10) |
X |
APC Identifier |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version number |
|
PERIODID |
NUMBER(6,0) |
X |
Offset from start date and period in APCCOMP table. |
|
AMOUNT |
NUMBER(15,5) |
|
Compensation audit. |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
APCCOMPAMOUNTTRK sets out the relevant Administered Price Cap (APC) period for compensation purposes. Use the APCCOMPAMOUNTTRK table in conjunction with APCAMOUNT. |
|
Public Source Updated with settlement posting and issued with daily data. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
APCID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
APCID |
VARCHAR2(10) |
X |
APC Identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version number |
|
AUTHORISEDBY |
VARCHAR2(10) |
|
Authorised by |
|
AUTHORISEDDATE |
DATE |
|
Authorised date |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
BIDPEROFFER shows period-based Energy and Ancillary Service bid data. BIDPEROFFER is a child table of BIDDAYOFFER. |
|
The new ancillary service arrangements require availability and prices for each Frequency Control Ancillary Service to be bid on a similar basis to energy. Three new tables facilitate ancillary service bidding. The new tables (BIDOFFERFILETRK, BIDDAYOFFER and BIDPEROFFER) are similar in structure to energy bidding tables (OFFERFILETRK, DAYOFFER and PEROFFER). The significant differences with the new tables are: · The OFFERDATE field reflects the time the bid was loaded and this field alone provides the key for versioning of bids. The VERSIONNO field is retained for participant use as information only. · The new tables support bids for multiple services. The BIDTYPE field defines the service to which the bid applies. · There are no default bids. In the absence of a bid for a specific settlement date, the latest bid submitted for a previous settlement date applies. BIDPEROFFER data is confidential to the submitting participant until made public after 4am the next day. Source BIDPEROFFER updates as energy and ancillary service bids are processed. BIDPEROFFER includes all accepted energy and ancillary service bids. Volume Approximately 72,000,000 records per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
BIDTYPE |
|
DUID |
|
OFFERDATE |
|
PERIODID |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable Unit identifier |
|
BIDTYPE |
VARCHAR2(10) |
X |
Bid Type Identifier |
|
SETTLEMENTDATE |
DATE |
X |
Market date starting at 04:05 |
|
OFFERDATE |
DATE |
X |
Offer date |
|
PERIODID |
NUMBER(22,0) |
X |
Period ID |
|
VERSIONNO |
NUMBER(22,0) |
|
Version number of offer |
|
MAXAVAIL |
NUMBER(12,6) |
|
Maximum availability for this BidType in this period |
|
FIXEDLOAD |
NUMBER(12,6) |
|
Fixed unit output MW (Energy Bids Only) A value of zero means no fixed load so the unit is dispatched according to bid and market (rather than zero fixed load) |
|
ROCUP |
NUMBER(6,0) |
|
MW/min for raise (Energy Bids Only) |
|
ROCDOWN |
NUMBER(6,0) |
|
MW/Min for lower (Energy Bids Only) |
|
ENABLEMENTMIN |
NUMBER(6,0) |
|
Minimum Energy Output (MW) at which this ancillary service becomes available (AS Only) |
|
ENABLEMENTMAX |
NUMBER(6,0) |
|
Maximum Energy Output (MW) at which this ancillary service can be supplied (AS Only) |
|
LOWBREAKPOINT |
NUMBER(6,0) |
|
Minimum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only) |
|
HIGHBREAKPOINT |
NUMBER(6,0) |
|
Maximum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only) |
|
BANDAVAIL1 |
NUMBER(22,0) |
|
Availability at price band 1 |
|
BANDAVAIL2 |
NUMBER(22,0) |
|
Availability at price band 2 |
|
BANDAVAIL3 |
NUMBER(22,0) |
|
Availability at price band 3 |
|
BANDAVAIL4 |
NUMBER(22,0) |
|
Availability at price band 4 |
|
BANDAVAIL5 |
NUMBER(22,0) |
|
Availability at price band 5 |
|
BANDAVAIL6 |
NUMBER(22,0) |
|
Availability at price band 6 |
|
BANDAVAIL7 |
NUMBER(22,0) |
|
Availability at price band 7 |
|
BANDAVAIL8 |
NUMBER(22,0) |
|
Availability at price band 8 |
|
BANDAVAIL9 |
NUMBER(22,0) |
|
Availability at price band 9 |
|
BANDAVAIL10 |
NUMBER(22,0) |
|
Availability at price band 10 |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
PASAAVAILABILITY |
NUMBER(12,0) |
|
Allows for future use for energy bids, being the physical plant capability including any capability potentially available within 24 hours |
|
MR_CAPACITY |
NUMBER(6,0) |
|
Mandatory Restriction Offer amount |
|
Name |
|
|
Comment |
|
|
BILLADJUSTMENTS is confidential, and is available only to the relevant participant. Source Ad hoc |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
ADJBILLRUNNO |
|
ADJCONTRACTYEAR |
|
ADJWEEKNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
|
|
BILLRUNNO |
NUMBER(3,0) |
|
The sequential number of a billing run |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
PARTICIPANTTYPE |
VARCHAR2(10) |
|
Participant type Generator/Customer |
|
ADJCONTRACTYEAR |
NUMBER(4,0) |
X |
The contract year of the new revised billing run for this adjustment |
|
ADJWEEKNO |
NUMBER(3,0) |
X |
Week number of the new revised billing run for this adjustment |
|
ADJBILLRUNNO |
NUMBER(3,0) |
X |
Billing run number of the new revised billing run for this adjustment |
|
PREVAMOUNT |
NUMBER(16,6) |
|
Prior account |
|
ADJAMOUNT |
NUMBER(16,6) |
|
The total bill figure for the new revised billing run |
|
LASTCHANGED |
DATE |
|
|
|
LRS |
NUMBER(15,5) |
|
|
|
PRS |
NUMBER(15,5) |
|
|
|
OFS |
NUMBER(15,5) |
|
|
|
IRN |
NUMBER(15,5) |
|
Interest rate applying to the new amount |
|
IRP |
NUMBER(15,5) |
|
Interest rate applying to the principal amount |
|
INTERESTAMOUNT |
NUMBER(15,5) |
|
The total interest payable for this adjustment |
|
Name |
|
|
Comment |
CSP derogation amounts with respect to participant allocated payment |
|
Source BILLING_CSP_DEROGATION_AMOUNT is populated by the posting of a billing run. Volume An indicative maximum is one record inserted per billing run, or 11 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
AMOUNT_ID |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4) |
X |
Billing contract year |
|
WEEKNO |
NUMBER(3) |
X |
Billing week number |
|
BILLRUNNO |
NUMBER(3) |
X |
Billing run number |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
The participant allocated the payment amount for the derogation |
|
AMOUNT_ID |
VARCHAR2(20) |
X |
Amount identifier represented as a string, from "ta1" through to "ta6" (or "ta8" for a lymmco derogation result) |
|
DEROGATION_AMOUNT |
NUMBER(18,8) |
|
Derogation amount associated with the amount identifier |
|
LASTCHANGED |
DATE |
|
Last changed date for the record |
|
Name |
|
|
Comment |
BILLING_MR_PAYMENT shows aggregate payments on a dispatchable unit/MR Event basis for accepted MR capacity |
|
BILLING_MR_PAYMENT data is confidential, and is available only to the relevant participant. Source Ad hoc - MR events only. Volume 3500 rows per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
DUID |
|
MR_DATE |
|
REGIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Billing Contract Year |
|
WEEKNO |
NUMBER(3,0) |
X |
Billing Week number |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Billing Run number |
|
MR_DATE |
DATE |
X |
Trading Date of Mandatory Restriction event; Mandatory Restriction imposition date |
|
REGIONID |
VARCHAR2(10) |
X |
Unique Region Identifier |
|
PARTICIPANTID |
VARCHAR2(10) |
|
Unique Participant identifier |
|
DUID |
VARCHAR2(10) |
X |
Unique identifier for DUID / MNSP LinkID |
|
MR_AMOUNT |
NUMBER(16,6) |
|
Payment amount by AEMO |
|
LASTCHANGED |
DATE |
|
Date/Time record inserted/modified |
|
Name |
|
|
Comment |
BILLING_MR_RECOVERY shows aggregate recovery charges on a dispatchable unit / MR Event basis for spot market income from dispatch of MR capacity. |
|
BILLING_MR_RECOVERY data is confidential, and is available only to the relevant participant. Source Ad hoc - MR events only. Volume 3500 rows per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
DUID |
|
MR_DATE |
|
REGIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Billing Contract Year |
|
WEEKNO |
NUMBER(3,0) |
X |
Billing Week number |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Billing Run number |
|
MR_DATE |
DATE |
X |
Trading Date of Mandatory Restriction event; Mandatory Restriction imposition date |
|
REGIONID |
VARCHAR2(10) |
X |
Unique Region Identifier |
|
PARTICIPANTID |
VARCHAR2(10) |
|
Unique Participant identifier |
|
DUID |
VARCHAR2(10) |
X |
Unique identifier for DUID / MNSP LinkID |
|
MR_AMOUNT |
NUMBER(16,6) |
|
Payment amount to AEMO |
|
LASTCHANGED |
DATE |
|
Date/Time record inserted/modified |
|
Name |
|
|
Comment |
BILLING_MR_SHORTFALL shows aggregate MR shortfall payments (or recovery charges) to each participant in the region for the MR event. |
|
BILLING_MR_SHORTFALL data is confidential, and is available only to the relevant participant. Source Ad hoc - MR events only. Volume 400 rows per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
MR_DATE |
|
PARTICIPANTID |
|
REGIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Billing Contract Year |
|
WEEKNO |
NUMBER(3,0) |
X |
Billing Week number |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Billing Run number |
|
MR_DATE |
DATE |
X |
Trading Date of Mandatory Restriction event; Mandatory Restriction imposition date |
|
REGIONID |
VARCHAR2(10) |
X |
Unique Region Identifier |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique Participant Identifier |
|
AGE |
NUMBER(16,6) |
|
The adjusted gross energy for the market customer in the restricted region for the duration of the mandatory restriction event (MWh) |
|
RSA |
NUMBER(16,6) |
|
Restriction Shortfall amount payable to AEMO for a mandatory restriction period |
|
LASTCHANGED |
DATE |
|
Date/Time record inserted/modified |
|
Name |
|
|
Comment |
BILLING_MR_SUMMARY shows aggregate payment/recovery and shortfall figures for an MR Event. |
|
BILLING_MR_SUMMARY data is public to all participants. Source Ad hoc - MR events only. Volume 200 rows per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
MR_DATE |
|
REGIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Billing Contract Year |
|
WEEKNO |
NUMBER(3,0) |
X |
Billing Week number |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Billing Run number |
|
MR_DATE |
DATE |
X |
Trading Date of Mandatory Restriction event; Mandatory Restriction imposition date |
|
REGIONID |
VARCHAR2(10) |
X |
Unique Region Identifier |
|
TOTAL_PAYMENTS |
NUMBER(16,6) |
|
Total payments by AEMO |
|
TOTAL_RECOVERY |
NUMBER(16,6) |
|
Total payments to AEMO |
|
TOTAL_RSA |
NUMBER(16,6) |
|
Total Restriction Shortfall Amount |
|
AAGE |
NUMBER(16,6) |
|
The aggregate of then adjusted gross energy of all the market customer in the restricted region for the duration of the mandatory restriction period (MWh) |
|
LASTCHANGED |
DATE |
|
Date/Time record inserted/modified |
|
Name |
|
|
Comment |
Billing result table for reserve trader contract payments |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTID |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
PAYMENT_TYPE |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4) |
X |
Billing contract year |
|
WEEKNO |
NUMBER(3) |
X |
Billing week number |
|
BILLRUNNO |
NUMBER(3) |
X |
Billing run number |
|
CONTRACTID |
VARCHAR2(20) |
X |
Reserve trader contract identifier |
|
PAYMENT_TYPE |
VARCHAR2(40) |
X |
Payment type for the reserve trader contract payment amount |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
Participant identifier associated with the contract |
|
PAYMENT_AMOUNT |
NUMBER(18,8) |
|
Payment amount to the participant |
|
Name |
|
|
Comment |
Billing result table for reserve trader contract recovery |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
REGIONID |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4) |
X |
Billing contract year |
|
WEEKNO |
NUMBER(3) |
X |
Billing week number |
|
BILLRUNNO |
NUMBER(3) |
X |
Billing run number |
|
REGIONID |
VARCHAR2(20) |
X |
Region id for the aggregated recovery amount |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
Participant identifier |
|
RECOVERY_AMOUNT |
NUMBER(18,8) |
|
Payment amount to be recovered from the participant |
|
Name |
|
|
Comment |
BILLINGCPSUM shows adjustments for a billing run by participant. |
|
BILLINGCPSUM data is confidential to the relevant participant. Source Weekly update with billing run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
PARTICIPANTTYPE |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
PARTICIPANTTYPE |
VARCHAR2(10) |
X |
Participant type Generator/Customer |
|
PREVIOUSAMOUNT |
NUMBER(16,6) |
|
Previous amount billed |
|
ADJUSTEDAMOUNT |
NUMBER(16,6) |
|
Adjusted amount billed |
|
ADJUSTMENTWEEKNO |
NUMBER(3,0) |
|
Week no of adjustment |
|
ADJUSTMENTRUNNO |
NUMBER(3,0) |
|
Run no of adjustment |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
BILLINGCUSTEXCESSGEN shows excess generation payments for each participant cutover. |
|
Source Obsolete; was updated with relevant settlement runs. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
SETTLEMENTDATE |
DATE |
X |
Calendar Settlement Date |
|
PERIODID |
NUMBER(3,0) |
X |
Half hourly trading period that excess generation is for |
|
EXCESSGENPAYMENT |
NUMBER(16,6) |
|
Payment by Customer for Excess Generation |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
Name |
|
|
Comment |
BILLINGEXCESSGEN shows the excess generation cost by period for each participant. |
|
Source Obsolete; was updated weekly with each billing run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
SETTLEMENTDATE |
DATE |
X |
Calendar settlement date record becomes effective |
|
PERIODID |
NUMBER(3,0) |
X |
Settlement interval within the settlement date (1-48) starting at 00:30 |
|
EXCESSENERGYCOST |
NUMBER(15,5) |
|
Cost of excess energy attributed to this customer |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
Name |
|
|
Comment |
BILLINGINTERVENTION shows billing intervention recovery details. |
|
BILLINGINTERVENTION is confidential to the relevant participant. Source Updated when reserve trading occurs in a billing run, such as during an Administered Price Cap event. View is empty until such an event occurs. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
MARKETINTERVENTION |
NUMBER(15,5) |
|
Intervention Amounts paid to Generator for Market Recovery for region |
|
TOTALINTERVENTION |
NUMBER(15,5) |
|
Total Intervention Amounts paid to Generator |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
BILLINGINTERVENTIONREGION shows recovery charges for region intervention. |
|
BILLINGINTERVENTIONREGION is confidential to the relevant participant. Source BILLINGINTERVENTIONREGION is updated with relevant settlement runs, such as containing an Administered Price Cap. BILLINGINTERVENTIONREGION is empty until such an event occurs. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
REGIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
REGIONID |
VARCHAR2(10) |
X |
Region ID |
|
REGIONINTERVENTION |
NUMBER(15,5) |
|
Recovery amount for that region |
|
LASTCHANGED |
DATE |
|
Last changed date |
|
Name |
|
|
Comment |
BILLINGRESERVERECOVERY shows Market Reserve recovery details for each participant in a bill run. |
|
BILLINGRESERVERECOVERY data is Confidential to participant. Source BILLINGRESERVERECOVERY updates when reserve trading occurs in a billing run, such as during an Administered Price Cap event. BILLINGRESERVERECOVERY is empty until such an event occurs. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
MARKETRESERVE |
NUMBER(15,5) |
|
Amount Retailer pays for Reserve Trader Contracts with Market Recovery |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
BILLINGRESERVEREGIONRECOVERY shows Billing Region Reserve region recovery details for each participant (by region). |
|
BILLINGRESERVEREGIONRECOVERY data is confidential to the relevant participant. Source BILLINGRESERVEREGIONRECOVERY updates when reserve trading occurs in a billing run, such as during an Administered Price Cap event. View is empty until such an event occurs. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
REGIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier for region recovery. |
|
REGIONRESERVE |
NUMBER(15,5) |
|
Amount Retailer pays for Reserve Trader Contracts with Region Recovery |
|
LASTCHANGED |
DATE |
|
|
|
Name |
|
|
Comment |
BILLINGRESERVETRADER shows Billing Market Reserve TRADER payment details to Generators. |
|
BILLINGRESERVETRADER data is Confidential to the relevant participant. Source BILLINGRESERVETRADER updates when reserve trading occurs in a billing run, such as during an Administered Price Cap event. View is empty until such an event occurs. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
MARKETRESERVE |
NUMBER(15,5) |
|
Reserve Trader Amounts paid to Generator for Market Recovery |
|
TOTALRESERVE |
NUMBER(15,5) |
|
Total Reserve Trader Amounts paid to Generator |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
TOTALCAPDIFFERENCE |
NUMBER(15,5) |
|
|
|
Name |
|
|
Comment |
BILLINGRESERVETRADERREGION shows Billing Region Reserve Trader payment details. |
|
BILLINGRESERVETRADERREGION data is confidential to the relevant participant. Source BILLINGRESERVETRADERREGION updates when reserve trading occurs in a billing run, such as during an Administered Price Cap event. View is empty until such an event occurs. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
REGIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
REGIONRESERVE |
NUMBER(15,5) |
|
Reserve Trader Amounts paid to Generator for Region Recovery |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
BILLINGSMELTERREDUCTION shows the smelter reduction payment (only applies to participants with Victorian customer connection points). |
|
BILLINGSMELTERREDUCTION data is confidential to the relevant participant. Source BILLINGSMELTERREDUCTION is populated by the posting of a billing run where the participant has Victorian customer connectionpoints. Volume One record inserted per billing run, or 11 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
PARTICIPANTID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(22,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(22,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(22,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
RATE1 |
NUMBER(15,6) |
|
Rate in $/MWh |
|
RA1 |
NUMBER(15,6) |
|
Payment |
|
RATE2 |
NUMBER(15,6) |
|
Rate in $/MWh |
|
RA2 |
NUMBER(15,6) |
|
Payment |
|
TE |
NUMBER(15,6) |
|
Tabulated Energy |
|
PCSD |
NUMBER(15,6) |
|
Victorian Demand as defined by Code Chapter 9 definitions |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
BILLINTERVENTIONRECOVERY shows billing market intervention recovery details for each participant. |
|
BILLINTERVENTIONRECOVERY data is confidential to the relevant participant. Source BILLINTERVENTIONRECOVERY updates when reserve trading occurs in a billing run, such as during an Administered Price Cap event. View is empty until such an event occurs. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
MARKETINTERVENTION |
NUMBER(15,5) |
|
Amount Retailer pays for Intervention with Market Recovery |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
BILLINTERVENTIONREGIONRECOVERY shows billing region intervention recovery details for each participant by region. |
|
BILLINTERVENTIONREGIONRECOVERY data is confidential to the relevant participant. Source BILLINTERVENTIONREGIONRECOVERY updates when reserve trading occurs in a billing run, such as during an Administered Price Cap event. View is empty until such an event occurs. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
REGIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
REGIONINTERVENTION |
NUMBER(15,5) |
|
Amount retailer pays for intervention with Region Recovery |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
BILLSMELTERRATE is standing data, setting out the rates used in smelter reduction calculations. |
|
BILLSMELTERRATE is public data, and is available to all participants. Source BILLSMELTERRATE updates infrequently, when inserting new annual rates. Volume Two records inserted per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONTRACTYEAR |
|
EFFECTIVEDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Calendar settlement date record becomes effective |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version no of the record for the given effective date |
|
CONTRACTYEAR |
NUMBER(22,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
RAR1 |
NUMBER(6,2) |
|
Smelter rate 1 |
|
RAR2 |
NUMBER(6,2) |
|
Smelter rate 2 |
|
AUTHORISEDDATE |
DATE |
|
Authorised date |
|
AUTHORISEDBY |
VARCHAR2(10) |
|
Who authorised |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
CONNECTIONPOINT shows all valid connection points and their type. Transmission loss factors are available for all connection points in TRANSMISSIONLOSSFACTOR. |
|
CONNECTIONPOINT data is confidential to each relevant participant Source CONNECTIONPOINT updates for new connection points as required. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONNECTIONPOINTID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONNECTIONPOINTID |
VARCHAR2(10) |
X |
Connection Point Identifier |
|
CONNECTIONPOINTNAME |
VARCHAR2(80) |
|
Connection point full description |
|
CONNECTIONPOINTTYPE |
VARCHAR2(20) |
|
Connection point type. transmission, distribution, station, genunit, or interconnector |
|
ADDRESS1 |
VARCHAR2(80) |
|
Connection point location |
|
ADDRESS2 |
VARCHAR2(80) |
|
Connection point location |
|
ADDRESS3 |
VARCHAR2(80) |
|
Connection point location |
|
ADDRESS4 |
VARCHAR2(80) |
|
Not Used |
|
CITY |
VARCHAR2(40) |
|
City |
|
STATE |
VARCHAR2(10) |
|
State of Australia |
|
POSTCODE |
VARCHAR2(10) |
|
Post Code |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
CONNECTIONPOINTDETAILS is obsolete, since it was never populated by Participants accessing AEMO's Oracle Interface. |
|
CONNECTIONPOINTDETAILS data is confidential to each participant included in details. Source CONNECTIONPOINTDETAILS updates periodically, such as for Transmission Loss Factor (TLF) changes |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONNECTIONPOINTID |
|
EFFECTIVEDATE |
|
VERSIONNO |
|
Name |
|
METERDATAPROVIDER |
|
NETWORKSERVICEPROVIDER |
|
FINRESPORGAN |
|
Name |
|
CONNECTIONPOINTID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Effective date of record |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version no of record for given effective date |
|
CONNECTIONPOINTID |
VARCHAR2(10) |
X |
Connection point identifier |
|
REGIONID |
VARCHAR2(10) |
|
Region Identifier |
|
TRANSMISSIONCPTID |
VARCHAR2(10) |
|
Associated transmission connection point id for a distribution connection point |
|
METERDATAPROVIDER |
VARCHAR2(10) |
|
The MDA providing meter data for this connection point |
|
TRANSMISSIONLOSSFACTOR |
NUMBER(7,5) |
|
The transmission level loss factor for this connection point |
|
DISTRIBUTIONLOSSFACTOR |
NUMBER(7,5) |
|
The distribution level loss factor for a distribution connection point |
|
NETWORKSERVICEPROVIDER |
VARCHAR2(10) |
|
The Network Service Provider |
|
FINRESPORGAN |
VARCHAR2(10) |
|
Financially responsible organisation |
|
NATIONALMETERINSTALLID |
NUMBER(7,5) |
|
National Meter Id |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
User authorising record |
|
AUTHORISEDDATE |
DATE |
|
Date record authorised |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
INUSE |
VARCHAR2(1) |
|
Status flag. |
|
LNSP |
VARCHAR2(10) |
|
Local Electricity Network Service Provider |
|
MDA |
VARCHAR2(10) |
|
Metering Data Agent for connection point. |
|
ROLR |
VARCHAR2(10) |
|
Retailer of last resort. |
|
RP |
VARCHAR2(10) |
|
Responsible party. |
|
AGGREGATEDDATA |
VARCHAR2(1) |
|
Aggregate flag. |
|
VALID_TODATE |
DATE |
|
Date of validity. |
|
LR |
VARCHAR2(10) |
|
Local Retailer |
|
Name |
|
|
Comment |
CONNECTIONPOINTOPERATINGSTA shows whether a connection point is active or not. |
|
CONNECTIONPOINTOPERATINGSTA data is confidential to each relevant participant. Source CONNECTIONPOINTOPERATINGSTA updates periodically with changes in connection point status, such as for Transmission Loss Factor (TLF) changes. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONNECTIONPOINTID |
|
EFFECTIVEDATE |
|
VERSIONNO |
|
Name |
|
CONNECTIONPOINTID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Effective date of record |
|
VERSIONNO |
NUMBER(3,0) |
X |
|
|
CONNECTIONPOINTID |
VARCHAR2(10) |
X |
Connection point identifier |
|
OPERATINGSTATUS |
VARCHAR2(16) |
|
Active or inactive indicator |
|
AUTHORISEDDATE |
DATE |
|
Date record authorised |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
User authorising record |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
CONTRACTGOVERNOR became unused when Ancillary Services Review was implemented in 2001. For more details, see Change Notice 126. |
|
Confidential to participant Source Not in Use - discontinued 30/09/2001: was updated only where there was a contract variation. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(10) |
X |
Contract Identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Contract Version No. |
|
STARTDATE |
DATE |
|
Starting Date of Contract |
|
ENDDATE |
DATE |
|
Termination Date of Contract |
|
PARTICIPANTID |
VARCHAR2(10) |
|
Unique participant identifier |
|
DUID |
VARCHAR2(10) |
|
Dispatchable Unit ID |
|
CCPRICE |
NUMBER(10,2) |
|
Compensation Cap |
|
LOWER60SECBREAKPOINT |
NUMBER(9,6) |
|
Limit Equation Lower 60 Second Breakpoint MW |
|
LOWER60SECMAX |
NUMBER(9,6) |
|
Limit Equation Lower 60 Second Maximum MW |
|
LOWER6SECBREAKPOINT |
NUMBER(9,6) |
|
Limit Equation Lower 6 Second Breakpoint MW |
|
LOWER6SECMAX |
NUMBER(9,6) |
|
Limit Equation Lower 6 Second Maximum MW |
|
RAISE60SECBREAKPOINT |
NUMBER(9,6) |
|
Limit Equation Raise 60 Second Breakpoint MW |
|
RAISE60SECCAPACITY |
NUMBER(9,6) |
|
Limit Equation Raise 60 Second Capacity MW |
|
RAISE60SECMAX |
NUMBER(9,6) |
|
Limit Equation Raise 60 Second Maximum MW |
|
RAISE6SECBREAKPOINT |
NUMBER(9,6) |
|
Limit Equation Raise 6 Second Breakpoint MW |
|
RAISE6SECCAPACITY |
NUMBER(9,6) |
|
Limit Equation Raise 6 Second Capacity MW |
|
RAISE6SECMAX |
NUMBER(9,6) |
|
Limit Equation Raise 6 Second Maximum MW |
|
PRICE6SECRAISEMANDATORY |
NUMBER(16,6) |
|
Not used |
|
QUANT6SECRAISEMANDATORY |
NUMBER(16,6) |
|
Not used |
|
PRICE6SECRAISECONTRACT |
NUMBER(16,6) |
|
Contract Price for 6 Second Raise |
|
QUANT6SECRAISECONTRACT |
NUMBER(16,6) |
|
Contract Quantity for 6 Second Raise |
|
PRICE60SECRAISEMANDATORY |
NUMBER(16,6) |
|
Not used |
|
QUANT60SECRAISEMANDATORY |
NUMBER(16,6) |
|
Not used |
|
PRICE60SECRAISECONTRACT |
NUMBER(16,6) |
|
Contract Price for 60 Second Raise |
|
QUANT60SECRAISECONTRACT |
NUMBER(16,6) |
|
Contract Quantity for 60 Second Raise |
|
PRICE6SECLOWERMANDATORY |
NUMBER(16,6) |
|
Not used |
|
QUANT6SECLOWERMANDATORY |
NUMBER(16,6) |
|
Not used |
|
PRICE6SECLOWERCONTRACT |
NUMBER(16,6) |
|
Contract Price for 6 Second Lower |
|
QUANT6SECLOWERCONTRACT |
NUMBER(16,6) |
|
Contract Quantity for 6 Second Lower |
|
PRICE60SECLOWERMANDATORY |
NUMBER(16,6) |
|
Not used |
|
QUANT60SECLOWERMANDATORY |
NUMBER(16,6) |
|
Not used |
|
PRICE60SECLOWERCONTRACT |
NUMBER(16,6) |
|
Contract Price for 60 Second Lower |
|
QUANT60SECLOWERCONTRACT |
NUMBER(16,6) |
|
Contract Quantity for 60 Second Lower |
|
DEADBANDUP |
NUMBER(4,2) |
|
Raise Deadband |
|
DEADBANDDOWN |
NUMBER(4,2) |
|
Lower Deadband |
|
DROOP6SECRAISEBREAKPOINT |
NUMBER(9,6) |
|
Droop Equation Raise 6 Second Breakpoint |
|
DROOP6SECRAISECAPACITY |
NUMBER(9,6) |
|
Droop Equation Raise 6 Second Capacity |
|
DROOP6SECRAISEMAX |
NUMBER(9,6) |
|
Droop Equation Raise 6 Second Maximum |
|
DROOP60SECRAISEBREAKPOINT |
NUMBER(9,6) |
|
Droop Equation Raise 60 Second Breakpoint |
|
DROOP60SECRAISECAPACITY |
NUMBER(9,6) |
|
Droop Equation Raise 60 Second Capacity |
|
DROOP60SECRAISEMAX |
NUMBER(9,6) |
|
Droop Equation Raise 60 Second Maximum |
|
DROOP6SECLOWERBREAKPOINT |
NUMBER(9,6) |
|
Droop Equation Lower 6 Second Breakpoint |
|
DROOP6SECLOWERMAX |
NUMBER(9,6) |
|
Droop Equation Lower 6 Second Maximum |
|
DROOP60SECLOWERBREAKPOINT |
NUMBER(9,6) |
|
Droop Equation Lower 60 Second Breakpoint |
|
DROOP60SECLOWERMAX |
NUMBER(9,6) |
|
Droop Equation Lower 60 Second Maximum |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
User Name |
|
AUTHORISEDDATE |
DATE |
|
Date Contract was authorised |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
CONTRACTRESERVEFLAG has never been or will be used. It was to show a period by period flag for regional or market recovery of reserve trading contract amounts. |
|
CONTRACTRESERVEFLAG data is confidential to the relevant participant. Source CONTRACTRESERVEFLAG updates when we want to enter a reserve contract. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
PERIODID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(10) |
X |
Reserve Trader Contract Identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Reserve Trader Contract Version |
|
PERIODID |
NUMBER(3,0) |
X |
Calendar settlement date period identifier, i.e. period 1 is 00:30 |
|
RCF |
CHAR(1) |
|
Reserve Recovery Flag |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
CONTRACTRESERVETHRESHOLD shows reserve contract threshold details for enabling, usage and availability thresholds and rates for reserve trader contracts. |
|
CONTRACTRESERVETHRESHOLD data is confidential to the relevant participant. Source CONTRACTRESERVETHRESHOLD updates when reserve contracts are first entered or updated. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(10) |
X |
Contract Identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Contract Version |
|
CRA |
NUMBER(16,6) |
|
Availability Rate $ |
|
CRE |
NUMBER(16,6) |
|
Enabling Rate $ |
|
CRU |
NUMBER(16,6) |
|
Usage Rate $ |
|
CTA |
NUMBER(16,6) |
|
Availability Threshold MW/h |
|
CTE |
NUMBER(16,6) |
|
Enabling Threshold MW/h |
|
CTU |
NUMBER(16,6) |
|
Usage Threshold MW/h |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
User name |
|
AUTHORISEDDATE |
DATE |
|
Date contract was authorised |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
CONTRACTRESERVETRADER shows reserve trader contract details. Version numbers do not apply as contracts exist for specified purposes. |
|
CONTRACTRESERVETRADER data is confidential to the relevant participant. Source CONTRACTRESERVETRADER updates when reserve trader activities occur. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(10) |
X |
Reserve Trader Contract Identifier |
|
DUID |
VARCHAR2(10) |
|
Dispatchable Unit ID |
|
STARTDATE |
DATE |
|
Starting Date of Contract |
|
ENDDATE |
DATE |
|
Terminate Date of contract |
|
STARTPERIOD |
NUMBER(3,0) |
|
Starting period of contract |
|
ENDPERIOD |
NUMBER(3,0) |
|
Terminate period of contract based on calendar date. |
|
DEREGISTRATIONDATE |
DATE |
|
De-registration date of contract; Not Used |
|
DEREGISTRATIONPERIOD |
NUMBER(3,0) |
|
De-registration period of contract; Not Used |
|
PARTICIPANTID |
VARCHAR2(10) |
|
Unique participant identifier |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
REGIONID |
VARCHAR2(10) |
|
Region Identifier |
|
Name |
|
|
Comment |
CONTRACTUNITLOADING became unused when Ancillary Services Review was implemented in 2001. For more details, see Change Notice 126. |
|
CONTRACTUNITLOADING is confidential to participants. Source CONTRACTUNITLOADING is not in Use - discontinued 30/09/2001; was updated only where there was a contract variation. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(10) |
X |
Contract Identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Contract Version No. |
|
STARTDATE |
DATE |
|
Starting Date of Contract |
|
ENDDATE |
DATE |
|
Termination Date of Contract |
|
PARTICIPANTID |
VARCHAR2(10) |
|
Unique participant identifier |
|
DUID |
VARCHAR2(10) |
|
Dispatchable Unit ID |
|
RPRICE |
NUMBER(10,2) |
|
Enabling Price |
|
SUPRICE |
NUMBER(10,2) |
|
Usage Price |
|
CCPRICE |
NUMBER(10,2) |
|
Compensation Cap |
|
ACR |
NUMBER(10,2) |
|
Available Control Range |
|
BS |
NUMBER(10,2) |
|
Block Size of Unit |
|
PP |
NUMBER(10,2) |
|
Estimated Price for supply |
|
EU |
NUMBER(10,2) |
|
Estimated Power consumption of unit when enabled for RGUL |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
User Name |
|
AUTHORISEDDATE |
DATE |
|
Date Contract was authorised |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
CONTRACTUNITUNLOADING shows Ancillary Service contract data for rapid generator unit unloading. |
|
CONTRACTUNITUNLOADING data is confidential to relevant participants. Source CONTRACTUNITUNLOADING updates only where there is a contract variation. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
VERSIONNO |
|
Name |
|
PARTICIPANTID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(10) |
X |
Contract Identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Contract Version No. |
|
STARTDATE |
DATE |
|
Starting Date of Contract |
|
ENDDATE |
DATE |
|
Termination Date of Contract |
|
PARTICIPANTID |
VARCHAR2(10) |
|
Unique participant identifier |
|
DUID |
VARCHAR2(10) |
|
Dispatchable Unit ID |
|
RPRICE |
NUMBER(10,2) |
|
Enabling Price |
|
SUPRICE |
NUMBER(10,2) |
|
Usage Price |
|
CCPRICE |
NUMBER(10,2) |
|
Compensation Cap |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
User Name |
|
AUTHORISEDDATE |
DATE |
|
Date Contract was Authorised |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
DAYOFFER sets out the participants’ daily components of participant bid containing details applying for the whole day (such as prices, daily energy constraint and fast start profiles). |
|
DAYOFFER data is confidential to the submitting participant until made public after 4am the next day. The table DAYOFFER_D is quite distinct, with same field names (see DAYOFFER_D). |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
DUID |
|
OFFERDATE |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
DUID |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Market date starting at 04:00am |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable unit identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version no. for given offer date |
|
OFFERDATE |
DATE |
X |
Offer date of data |
|
SELFCOMMITFLAG |
VARCHAR2(1) |
|
Not used |
|
DAILYENERGYCONSTRAINT |
NUMBER(12,6) |
|
Maximum energy available from Energy Constrained Plant. |
|
ENTRYTYPE |
VARCHAR2(20) |
|
Daily or Rebid |
|
CONTINGENCYPRICE |
NUMBER(9,2) |
|
Not used |
|
REBIDEXPLANATION |
VARCHAR2(64) |
|
Explanation for all rebids and inflexibilities |
|
BANDQUANTISATIONID |
NUMBER(2,0) |
|
Not used |
|
PRICEBAND1 |
NUMBER(9,2) |
|
Price for Availability Band 1 |
|
PRICEBAND2 |
NUMBER(9,2) |
|
Price for Availability Band 2 |
|
PRICEBAND3 |
NUMBER(9,2) |
|
Price for Availability Band 3 |
|
PRICEBAND4 |
NUMBER(9,2) |
|
Price for Availability Band 4 |
|
PRICEBAND5 |
NUMBER(9,2) |
|
Price for Availability Band 5 |
|
PRICEBAND6 |
NUMBER(9,2) |
|
Price for Availability Band 6 |
|
PRICEBAND7 |
NUMBER(9,2) |
|
Price for Availability Band 7 |
|
PRICEBAND8 |
NUMBER(9,2) |
|
Price for Availability Band 8 |
|
PRICEBAND9 |
NUMBER(9,2) |
|
Price for Availability Band 9 |
|
PRICEBAND10 |
NUMBER(9,2) |
|
Price for Availability Band 10 |
|
MAXRAMPUP |
NUMBER(9,2) |
|
Not used |
|
MAXRAMPDOWN |
NUMBER(9,2) |
|
Not used |
|
MINIMUMLOAD |
NUMBER(6,0) |
|
Minimum MW load fast start plant in MW |
|
T1 |
NUMBER(6,0) |
|
Time to synchronise in minutes |
|
T2 |
NUMBER(6,0) |
|
Time to minimum load in minutes |
|
T3 |
NUMBER(6,0) |
|
Time at minimum load in minutes |
|
T4 |
NUMBER(6,0) |
|
Time to shutdown in minutes |
|
NORMALSTATUS |
VARCHAR2(3) |
|
ON/OFF for loads |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
MR_FACTOR |
NUMBER(16,6) |
|
Mandatory Restriction Price Scaling Factor |
|
Name |
|
|
Comment |
DAYOFFER_D sets out the participants’ daily components of participant bid containing just the latest details (such as prices, daily energy constraint and fast start profiles). |
|
Not in Use - discontinued 16/11/2003 DAYOFFER data was confidential to the submitting participant until made public after 4am the next day. The table DAYOFFER is quite distinct, with same field names (see DAYOFFER). |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
DUID |
|
OFFERDATE |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
DUID |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Market date starting at 04:00am |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable unit identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version no. for given offer date |
|
OFFERDATE |
DATE |
X |
Offer date of data |
|
SELFCOMMITFLAG |
VARCHAR2(1) |
|
Not used |
|
DAILYENERGYCONSTRAINT |
NUMBER(12,6) |
|
Maximum energy available from Energy Constrained Plant. |
|
ENTRYTYPE |
VARCHAR2(20) |
|
Daily or Rebid |
|
CONTINGENCYPRICE |
NUMBER(9,2) |
|
Not used |
|
REBIDEXPLANATION |
VARCHAR2(64) |
|
Explanation for all rebids and inflexibilities |
|
BANDQUANTISATIONID |
NUMBER(2,0) |
|
Not used |
|
PRICEBAND1 |
NUMBER(9,2) |
|
Price for Availability Band 1 |
|
PRICEBAND2 |
NUMBER(9,2) |
|
Price for Availability Band 2 |
|
PRICEBAND3 |
NUMBER(9,2) |
|
Price for Availability Band 3 |
|
PRICEBAND4 |
NUMBER(9,2) |
|
Price for Availability Band 4 |
|
PRICEBAND5 |
NUMBER(9,2) |
|
Price for Availability Band 5 |
|
PRICEBAND6 |
NUMBER(9,2) |
|
Price for Availability Band 6 |
|
PRICEBAND7 |
NUMBER(9,2) |
|
Price for Availability Band 7 |
|
PRICEBAND8 |
NUMBER(9,2) |
|
Price for Availability Band 8 |
|
PRICEBAND9 |
NUMBER(9,2) |
|
Price for Availability Band 9 |
|
PRICEBAND10 |
NUMBER(9,2) |
|
Price for Availability Band 10 |
|
MAXRAMPUP |
NUMBER(9,2) |
|
Not used |
|
MAXRAMPDOWN |
NUMBER(9,2) |
|
Not used |
|
MINIMUMLOAD |
NUMBER(6,0) |
|
Minimum MW load fast start plant in MW |
|
T1 |
NUMBER(6,0) |
|
Time to synchronise in minutes |
|
T2 |
NUMBER(6,0) |
|
Time to minimum load in minutes |
|
T3 |
NUMBER(6,0) |
|
Time at minimum load in minutes |
|
T4 |
NUMBER(6,0) |
|
Time to shutdown in minutes |
|
NORMALSTATUS |
VARCHAR2(3) |
|
ON/OFF for loads |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
MR_FACTOR |
NUMBER(6,0) |
|
Mandatory Restriction Price Scaling Factor |
|
Name |
|
|
Comment |
DEFAULTDAYOFFER shows day-based details of participants’ default bids unit for the same day. |
|
Source Obsolete; was updated only when participant changed their default bid. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
DUID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Market date starting at 04:30 |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable unit Identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version No for given offer date |
|
SELFCOMMITFLAG |
VARCHAR2(1) |
|
Not used |
|
DAILYENERGYCONSTRAINT |
NUMBER(12,6) |
|
Maximum energy available from Energy Constrained Plant. |
|
ENTRYTYPE |
VARCHAR2(20) |
|
Daily or Rebid |
|
CONTINGENCYPRICE |
NUMBER(9,2) |
|
Not used |
|
REBIDEXPLANATION |
VARCHAR2(64) |
|
Explanation for all rebids and inflexibilities |
|
BANDQUANTISATIONID |
NUMBER(2,0) |
|
Not used |
|
PRICEBAND1 |
NUMBER(9,2) |
|
Price for Availability Band 1 |
|
PRICEBAND2 |
NUMBER(9,2) |
|
Price for Availability Band 2 |
|
PRICEBAND3 |
NUMBER(9,2) |
|
Price for Availability Band 3 |
|
PRICEBAND4 |
NUMBER(9,2) |
|
Price for Availability Band 4 |
|
PRICEBAND5 |
NUMBER(9,2) |
|
Price for Availability Band 5 |
|
PRICEBAND6 |
NUMBER(9,2) |
|
Price for Availability Band 6 |
|
PRICEBAND7 |
NUMBER(9,2) |
|
Price for Availability Band 7 |
|
PRICEBAND8 |
NUMBER(9,2) |
|
Price for Availability Band 8 |
|
PRICEBAND9 |
NUMBER(9,2) |
|
Price for Availability Band 9 |
|
PRICEBAND10 |
NUMBER(9,2) |
|
Price for Availability Band 10 |
|
MAXRAMPUP |
NUMBER(9,2) |
|
Not used |
|
MAXRAMPDOWN |
NUMBER(9,2) |
|
Not used |
|
MINIMUMLOAD |
NUMBER(6,0) |
|
Minimum stable load |
|
T1 |
NUMBER(6,0) |
|
Time to synchronise in minutes |
|
T2 |
NUMBER(6,0) |
|
Time to minimum load in minutes |
|
T3 |
NUMBER(6,0) |
|
Time at minimum load in minutes |
|
T4 |
NUMBER(6,0) |
|
Time to shut down in minutes |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
DEFAULTOFFERTRK shows the file names of default offers submitted for each unit. |
|
Source Obsolete; was updated only when participant changed their default bid. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
DUID |
|
EFFECTIVEDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable Unit Identifier |
|
EFFECTIVEDATE |
DATE |
X |
Market date default offer file is effective |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version no of file for this date |
|
FILENAME |
VARCHAR2(40) |
|
Load File identifier |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
User authorising record |
|
AUTHORISEDDATE |
DATE |
|
Date record authorised |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
DEFAULTPEROFFER shows half hourly period-based data in the default bid for each Dispatchable Unit, such as period availability, rate of change and band quantities. |
|
Source Obsolete; was updated only when participant changes their default bid. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
DUID |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Market date starting at 04:30 |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable Unit Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Market data. Trading Interval number |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version no of the offer file. |
|
SELFDISPATCH |
NUMBER(9,6) |
|
Not used |
|
MAXAVAIL |
NUMBER(12,6) |
|
Maximum planned availability MW |
|
FIXEDLOAD |
NUMBER(9,6) |
|
Fixed unit output MW. A value of zero means no fixed load so the unit is dispatched according to bid and market (rather than zero fixed load) |
|
ROCUP |
NUMBER(6,0) |
|
Rate of change up MW/min |
|
ROCDOWN |
NUMBER(6,0) |
|
Rate of change down MW/min |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
BANDAVAIL1 |
NUMBER(6,0) |
|
Availability at price band 1 |
|
BANDAVAIL2 |
NUMBER(6,0) |
|
Availability at price band 2 |
|
BANDAVAIL3 |
NUMBER(6,0) |
|
Availability at price band 3 |
|
BANDAVAIL4 |
NUMBER(6,0) |
|
Availability at price band 4 |
|
BANDAVAIL5 |
NUMBER(6,0) |
|
Availability at price band 5 |
|
BANDAVAIL6 |
NUMBER(6,0) |
|
Availability at price band 6 |
|
BANDAVAIL7 |
NUMBER(6,0) |
|
Availability at price band 7 |
|
BANDAVAIL8 |
NUMBER(6,0) |
|
Availability at price band 8 |
|
BANDAVAIL9 |
NUMBER(6,0) |
|
Availability at price band 9 |
|
BANDAVAIL10 |
NUMBER(6,0) |
|
Availability at price band 10 |
|
PASAAVAILABILITY |
NUMBER(12,0) |
|
The physical plant capability including any capability potentially available within 24 hours. |
|
Name |
|
|
Comment |
DELTAMW sets out the Frequency Control Ancillary Services (FCAS) requirement to be provided locally within each region and each half-hour period in a market day. Two fields specify Frequency Controlled Ancillary Services requirements to be provided locally for the new regulation ancillary services. |
|
Change Notice 324 (for the FCAS Constraint enhancements project) means that Dispatch no longer utilises the static FCAS requirements defined in the DELTAMW and RESERVE tables. These tables are replaced with constraint data as a source of FCAS requirements. The name of the table derives from the now obsolete delta MW for participant factors in Queensland. Source DELTAMW updates result from action by operational control staff, generally once a day. Not in Use - discontinued 16/11/2003 |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Market date starting at 04:30 |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version No of record for this date |
|
REGIONID |
VARCHAR2(10) |
X |
Differentiates this region from all other regions |
|
PERIODID |
NUMBER(2,0) |
X |
Market trading interval from 1 to 48 starting at 04:30 |
|
DELTAMW |
NUMBER(6,0) |
|
Not Used |
|
LOWER5MIN |
NUMBER(6,0) |
|
Lower 5 min local share requirement |
|
LOWER60SEC |
NUMBER(6,0) |
|
Lower 60 sec local share requirement |
|
LOWER6SEC |
NUMBER(6,0) |
|
Lower 6 sec local share requirement |
|
RAISE5MIN |
NUMBER(6,0) |
|
Raise 5 minute local share requirement |
|
RAISE60SEC |
NUMBER(6,0) |
|
Raise 60 sec local share requirement |
|
RAISE6SEC |
NUMBER(6,0) |
|
Raise 6 sec local share requirement |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
RAISEREG |
NUMBER(6,0) |
|
Raise Regulation local share requirement |
|
LOWERREG |
NUMBER(6,0) |
|
Lower Regulation local share requirement |
|
Name |
|
|
Comment |
DISPATCHBIDTRK shows the bid tracking, including the bid version used in each dispatch run for each unit. DISPATCHBIDTRK is the audit trail of the bid actually used in each dispatch. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
DUID |
|
OFFEREFFECTIVEDATE |
|
OFFERVERSIONNO |
|
RUNNO |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
|
DUID |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Market date starting at 04:05 |
|
RUNNO |
NUMBER(3,0) |
X |
Dispatch run no from 1 to 288 (as per bid) |
|
OFFEREFFECTIVEDATE |
DATE |
X |
Effective date of offer used |
|
OFFERVERSIONNO |
NUMBER(3,0) |
X |
Version no of offer used |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable unit identifier |
|
BIDTYPE |
VARCHAR2(10) |
|
Bid type (daily, default or rebid) |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
DISPATCHCASE_OCD shows the key data to indicate when an over-constrained dispatch (OCD) re-run actually occurred. One record per over-constrained dispatch interval. |
|
The DISPATCHCASE_OCD data is public. Source The occurrences of Over-constrained dispatch (OCD) or binding intra-regional network constraints (BNC) re-runs are ad hoc, with significant dependencies on the configuration or events in the physical power system. Potentially updated every 5 minutes. Volume Rows per day: ~2 Mb per month: <1 The estimates on the number of rows are based on a 1% occurrence rate for OCD runs. Note Due to the close dependency with the dispatch process, the OCD and BNC data models use a “CaseSolution” key table in the same manner as the DISPATCHCASESOLUTION table. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
RUNNO |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
End date and time of the dispatch interval |
|
RUNNO |
NUMBER(3,0) |
X |
Dispatch run no; always 1 |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
DISPATCHCASESOLUTION_BNC was discontinued on 30 September 2009. Prior: DISPATCHCASESOLUTION_BNC is the key data to indicate when a binding intra-regional network constraints (BNC) re-run actually occurred. |
|
DISPATCHCASESOLUTION_BNC was discontinued on 30 September 2009. In accordance with the "Arrangements for Managing Risks Associated with Transmission Network Congestion" set of rule changes the Dispatch Binding Network Constraints re-run was discontinued on September 30, 2009. Source The occurrences of Over-constrained dispatch (OCD) or binding intra-regional network constraints (BNC) re-runs are ad hoc, with significant dependencies on the configuration or events in the physical power system. Potentially updated every 5 minutes. Volume Rows per day: ~72 Mb per month: 25% of DISPATCHCASESOLUTION The estimates on the number of rows are based on a 25% occurrence rate for BNC runs. Note Due to the close dependency with the dispatch process, the OCD and BNC data models use a “CaseSolution” key table in the same manner as DISPATCHCASESOLUTION. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
INTERVENTION |
|
RUNNO |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
End date and time of the dispatch interval |
|
RUNNO |
NUMBER(3,0) |
X |
Dispatch run no; always 1 |
|
INTERVENTION |
NUMBER(2,0) |
X |
Manual intervention flag |
|
CASESUBTYPE |
VARCHAR2(3) |
|
always BNC |
|
SOLUTIONSTATUS |
NUMBER(2,0) |
|
If non-zero indicated one of the following conditions: |
|
SPDVERSION |
NUMBER(10,3) |
|
Current version of SPD |
|
STARTPERIOD |
VARCHAR2(20) |
|
Period identifier of first interval of the case (yyyymmddppp) |
|
NONPHYSICALLOSSES |
NUMBER(1,0) |
|
Non-Physical Losses algorithm invoked occurred during this run |
|
TOTALOBJECTIVE |
NUMBER(27,10) |
|
The Objective function from the LP |
|
TOTALAREAGENVIOLATION |
NUMBER(15,5) |
|
Total Region Demand violations |
|
TOTALINTERCONNECTORVIOLATION |
NUMBER(15,5) |
|
Total interconnector violations |
|
TOTALGENERICVIOLATION |
NUMBER(15,5) |
|
Total generic constraint violations |
|
TOTALRAMPRATEVIOLATION |
NUMBER(15,5) |
|
Total ramp rate violations |
|
TOTALUNITMWCAPACITYVIOLATION |
NUMBER(15,5) |
|
Total unit capacity violations |
|
TOTAL5MINVIOLATION |
NUMBER(15,5) |
|
Total of 5 minute ancillary service region violations |
|
TOTALREGVIOLATION |
NUMBER(15,5) |
|
Total of Regulation ancillary service region violations |
|
TOTAL6SECVIOLATION |
NUMBER(15,5) |
|
Total of 6 second ancillary service region violations |
|
TOTAL60SECVIOLATION |
NUMBER(15,5) |
|
Total of 60 second ancillary service region violations |
|
TOTALENERGYCONSTRVIOLATION |
NUMBER(15,5) |
|
|
|
TOTALENERGYOFFERVIOLATION |
NUMBER(15,5) |
|
Total of unit summated offer band violations |
|
TOTALASPROFILEVIOLATION |
NUMBER(15,5) |
|
Total of ancillary service trader profile violations |
|
TOTALFASTSTARTVIOLATION |
NUMBER(15,5) |
|
Total of fast start trader profile violations |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
DISPATCHLOAD_BNC was discontinued on 30 September 2009. Prior: DISPATCHLOAD_BNC gives binding intra-regional network constraints (BNC) re-run dispatch results for all scheduled generating units. DISPATCHLOAD_BNC has a similar structure to DISPATCHLOAD but does not repeat input type data (e.g. InitialMW, AGCStatus) since these values are available from DISPATCHLOAD. |
|
DISPATCHLOAD_BNC was discontinued on 30 September 2009. In accordance with the "Arrangements for Managing Risks Associated with Transmission Network Congestion" set of rule changes the Dispatch Binding Network Constraints re-run was discontinued on September 30, 2009. Source The occurrences of Over-constrained dispatch (OCD) or binding intra-regional network constraints (BNC) re-runs are ad hoc, with significant dependencies on the configuration or events in the physical power system. Potentially updated every 5 minutes. DISPATCHLOAD_BNC shows data produced every 5 minutes for all units when they have over-constrained dispatch, with own data being confidential until the next day. Volume Rows per day: ~14000 Mb per month: 25% of DISPATCHLOAD The basis of estimation on the number of rows is on a 25% occurrence rate for BNC runs Note A flag exists for each ancillary service type such that a unit trapped or stranded in one or more service type can be immediately identified. The flag is defined as follows:
|
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
DUID |
|
INTERVENTION |
|
RUNNO |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
|
DUID |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
End date and time of the dispatch interval |
|
RUNNO |
NUMBER(3,0) |
X |
Dispatch run no; always 1 |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable unit identifier |
|
INTERVENTION |
NUMBER(2,0) |
X |
Intervention flag if intervention run |
|
CONNECTIONPOINTID |
VARCHAR2(12) |
|
Connection point identifier for DUID |
|
DISPATCHMODE |
NUMBER(2,0) |
|
Dispatch mode for fast start plant (0 to 4). |
|
TOTALCLEARED |
NUMBER(15,5) |
|
Target MW for end of period |
|
RAISEREG |
NUMBER(15,5) |
|
Raise Regulation reserve target |
|
RAISE5MIN |
NUMBER(15,5) |
|
Raise 5 min reserve target |
|
RAISE60SEC |
NUMBER(15,5) |
|
Raise 60 sec reserve target |
|
RAISE6SEC |
NUMBER(15,5) |
|
Raise 6 sec reserve target |
|
LOWERREG |
NUMBER(15,5) |
|
Lower Regulation reserve target |
|
LOWER5MIN |
NUMBER(15,5) |
|
Lower 5 min reserve target |
|
LOWER60SEC |
NUMBER(15,5) |
|
Lower 60 sec reserve target |
|
LOWER6SEC |
NUMBER(15,5) |
|
Lower 6 sec reserve target |
|
RAISEREGFLAGS |
NUMBER(3,0) |
|
Raise Reg status flag |
|
RAISE5MINFLAGS |
NUMBER(3,0) |
|
Raise 5min status flag |
|
RAISE60SECFLAGS |
NUMBER(3,0) |
|
Raise 60sec status flag |
|
RAISE6SECFLAGS |
NUMBER(3,0) |
|
Raise 6sec status flag |
|
LOWERREGFLAGS |
NUMBER(3,0) |
|
Lower Reg status flag |
|
LOWER5MINFLAGS |
NUMBER(3,0) |
|
Lower 5min status flag |
|
LOWER60SECFLAGS |
NUMBER(3,0) |
|
Lower 60sec status flag |
|
LOWER6SECFLAGS |
NUMBER(3,0) |
|
Lower 6sec status flag |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
DISPATCHTRK is no longer used. DISPATCHTRK was the cross-reference between each dispatch run and SPD case run. DISPATCHTRK may be available on the InfoServer but not replicated to participant databases as it contains data duplicated in other tables. |
|
This is a public table, and is available to all participants. Source No longer used; discontinued 30/09/2001 |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
RUNNO |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Market date and time starting at 04:05 |
|
RUNNO |
NUMBER(3,0) |
X |
Dispatch run no, normally 1. |
|
REASON |
VARCHAR2(64) |
|
Reason code (if rerun) |
|
SPDRUNNO |
NUMBER(3,0) |
|
Case identifier for LP Solver |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
FORCEMAJEURE used to set out the start and end dates / periods of any force majeure event. FORCEMAJEURE is not used. |
|
FORCEMAJEURE is a public table, and is available to all participants. Source FORCEMAJEURE is not used; was updated if a force majeure event was recorded. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
FMID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
FMID |
VARCHAR2(10) |
X |
Force Majeure Identifier |
|
STARTDATE |
DATE |
|
Start Date for this event |
|
STARTPERIOD |
NUMBER(3,0) |
|
Start Trading Interval for event |
|
ENDDATE |
DATE |
|
End Date for this event |
|
ENDPERIOD |
NUMBER(3,0) |
|
End Trading Interval for this event |
|
APCSTARTDATE |
DATE |
|
APC Start Date |
|
STARTAUTHORISEDBY |
VARCHAR2(15) |
|
User authorising start |
|
ENDAUTHORISEDBY |
VARCHAR2(15) |
|
User authorising end of event |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
FORCEMAJEUREREGION used to set out regions impacted by a force majeure event. This table is not used. |
|
FORCEMAJEUREREGION is public data, and is available to all participants. Source FORCEMAJEUREREGION is not used; was updated if a force majeure event was recorded. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
FMID |
|
REGIONID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
FMID |
VARCHAR2(10) |
X |
Force Majeure ID |
|
REGIONID |
VARCHAR2(10) |
X |
Differentiates this region from all other regions |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
GENUNITMTRINPERIOD shows meter reading by period for each generator meter. GENUNITMTRINPERIOD covers generated power flowing into the system. It is used to calculate settlement values. |
|
GENUNITMTRINPERIOD data is confidential to the relevant participant. Source GENUNITMTRINPERIOD updated only when new meter reading files are submitted by MDAs. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONNECTIONPOINTID |
|
LOCAL_RETAILER |
|
MDA |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
STATIONID |
|
Name |
Data Type |
Mandatory |
Comment |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
SETTLEMENTDATE |
DATE |
X |
Trading date of meter data submitted |
|
VERSIONNO |
NUMBER(6,0) |
X |
Version no of the record for the given effective date |
|
CONNECTIONPOINTID |
VARCHAR2(10) |
X |
Connection Point NMI |
|
PERIODID |
NUMBER(3,0) |
X |
Period number where 1 period ending 00:30 EST |
|
GENUNITID |
VARCHAR2(10) |
|
Physical unit ID |
|
STATIONID |
VARCHAR2(10) |
|
Station Identifier |
|
IMPORTENERGYVALUE |
NUMBER(16,6) |
|
Energy sent to the pool (MWh) |
|
EXPORTENERGYVALUE |
NUMBER(16,6) |
|
Energy received from the pool (MWh) |
|
IMPORTREACTIVEVALUE |
NUMBER(16,6) |
|
Reactive power sent to the network |
|
EXPORTREACTIVEVALUE |
NUMBER(16,6) |
|
Reactive power received from the network |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
MDA |
VARCHAR2(10) |
X |
Relevant Metering Data Agent |
|
LOCAL_RETAILER |
VARCHAR2(10) |
X |
Local Retailer for this NMI |
|
Name |
|
|
Comment |
INTCONTRACT shows intervention contract details. These are specific to each intervention. |
|
INTCONTRACT became unused when Ancillary Services Review was implemented in 2001. Confidential to participant Source INTCONTRACT is unused; was updated as required. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(10) |
X |
Intervention Contract Identifier |
|
PARTICIPANTID |
VARCHAR2(10) |
|
Unique participant identifier |
|
DUID |
VARCHAR2(10) |
|
Dispatchable Unit ID |
|
STARTDATE |
DATE |
|
Starting Date of Contract |
|
ENDDATE |
DATE |
|
Terminate Date of contract |
|
STARTPERIOD |
NUMBER(3,0) |
|
Starting period of contract |
|
ENDPERIOD |
NUMBER(3,0) |
|
Terminate period of contract in trading interval |
|
DEREGISTRATIONDATE |
DATE |
|
Not Used |
|
DEREGISTRATIONPERIOD |
NUMBER(3,0) |
|
Not Used |
|
LASTCHANGED |
DATE |
|
Last changed date/time |
|
REGIONID |
VARCHAR2(10) |
|
Region Identifier |
|
Name |
|
|
Comment |
INTCONTRACTAMOUNT shows intervention contract amounts. |
|
INTCONTRACTAMOUNT became unused when Ancillary Services Review was implemented in 2001. Confidential to participant Source INTCONTRACTAMOUNT updated with intervention contracts settlement calculations. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
PERIODID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(10) |
X |
Intervention Contract Identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Intervention Contract Version |
|
PERIODID |
NUMBER(3,0) |
X |
Period Identifier based on calendar settlement date - YYYYMMDDPP. |
|
AMOUNT |
NUMBER(16,6) |
|
Intervention Amount for Trading Interval |
|
RCF |
CHAR(1) |
|
Regional Recovery Flag |
|
LASTCHANGED |
DATE |
X |
Last date and time record changed |
|
Name |
|
|
Comment |
INTCONTRACTAMOUNTTRK shows the latest valid version of each intervention contract. |
|
INTCONTRACTAMOUNTTRK became unused when Ancillary Services Review was implemented in 2001. INTCONTRACTAMOUNTTRK is confidential to relevant participant Source INTCONTRACTAMOUNTTRK is unused; was updated for contract changes / creation only. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(10) |
X |
Intervention Contract Identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Intervention Contract Version |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
User name |
|
AUTHORISEDDATE |
DATE |
|
Date contract was authorised |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
INTERCONNMWFLOW shows Metered Interconnector flow data. INTERCONNMWFLOW shows the meter data provided by Meter Data Providers to MSATS. |
|
INTERCONNMWFLOW data is public, available to all participants. Source INTERCONNMWFLOW updates weekly. Volume The volume depends on number of interconnectors and number of loads (versions) from MSATS per settlement run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
INTERCONNECTORID |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date (based on Trading day, not dispatch day - i.e. period 1 ends 00:30) |
|
VERSIONNO |
NUMBER(6,0) |
X |
Meter Data Version number |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Interconnector Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Settlement Period identifier (half hour period) |
|
IMPORTENERGYVALUE |
NUMBER(15,6) |
|
Imported Energy value (MWh) |
|
EXPORTENERGYVALUE |
NUMBER(15,6) |
|
Exported Energy value (MWh) |
|
LASTCHANGED |
DATE |
|
Record creation timestamp |
|
Name |
|
|
Comment |
MARKETSUSPENSION is obsolete from 2017 End of Year DM4.27 Release. |
|
MARKETSUSPENSION is public data, so is available to all participants. Source MARKETSUSPENSION updates only if market is suspended. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
SUSPENSIONID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SUSPENSIONID |
VARCHAR2(10) |
X |
Unique identifier for suspension |
|
STARTDATE |
DATE |
|
Start date of suspension |
|
STARTPERIOD |
NUMBER(3,0) |
|
Start trading interval of suspension |
|
ENDDATE |
DATE |
|
End Date of suspension |
|
ENDPERIOD |
NUMBER(3,0) |
|
End trading interval of suspension |
|
REASON |
VARCHAR2(64) |
|
Reason for suspension |
|
STARTAUTHORISEDBY |
VARCHAR2(15) |
|
User authorising start |
|
ENDAUTHORISEDBY |
VARCHAR2(15) |
|
User authorising end |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
MARKETSUSREGION is obsolete from 2017 End of Year DM4.27 Release. |
|
MARKETSUSREGION is public data, so is available to all participants. Source MARKETSUSREGION updates only if market is suspended. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
REGIONID |
|
SUSPENSIONID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SUSPENSIONID |
VARCHAR2(10) |
X |
Unique identifier of suspension |
|
REGIONID |
VARCHAR2(10) |
X |
Differentiates this region from all other regions |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
MAS_CP_CHANGE records pending changes to the current MAS configuration. |
|
Obsolete; Replaced by MSATS Source MAS_CP_CHANGE updates daily with each MAS export. Note Expiry date: When the Expiry date on a change record is reached, the change record is deleted. Meter Read Date: only used in specific circumstances. For more details, refer to MAS documentation. The meter read date is not cleared if it becomes unusable (e.g. due to change of Metering Type or the passage of time). |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
NMI |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
NMI |
VARCHAR2(10) |
X |
National Metering Identifier |
|
STATUS_FLAG |
VARCHAR2(1) |
|
Active/Inactive flag |
|
CP_OLD_SECURITY_CODE |
VARCHAR2(4) |
|
Old Security Code |
|
CP_NEW_SECURITY_CODE |
VARCHAR2(4) |
|
New Security Code |
|
OLD_LOCAL_NETWORK_PROVIDER |
VARCHAR2(10) |
|
Old Local Network Provider |
|
OLD_LOCAL_RETAILER |
VARCHAR2(10) |
|
Old Local Retailer |
|
OLD_FINANCIAL_PARTICIPANT |
VARCHAR2(10) |
|
Old FRMP |
|
OLD_METERING_DATA_AGENT |
VARCHAR2(10) |
|
Old Metering Data Agent |
|
OLD_RETAILER_OF_LAST_RESORT |
VARCHAR2(10) |
|
Old Retailer of Last Resort |
|
OLD_RESPONSIBLE_PERSON |
VARCHAR2(10) |
|
Old Responsible Person |
|
NEW_LOCAL_NETWORK_PROVIDER |
VARCHAR2(10) |
|
New Local Network Provider |
|
NEW_LOCAL_RETAILER |
VARCHAR2(10) |
|
New Local Retailer |
|
NEW_FINANCIAL_PARTICIPANT |
VARCHAR2(10) |
|
New FRMP |
|
NEW_METERING_DATA_AGENT |
VARCHAR2(10) |
|
New Metering Data Agent |
|
NEW_RETAILER_OF_LAST_RESORT |
VARCHAR2(10) |
|
New Retailer of Last Resort |
|
NEW_RESPONSIBLE_PERSON |
VARCHAR2(10) |
|
New Responsible Person |
|
OLD_LNSP_OK |
VARCHAR2(1) |
|
Old LNSP approval flag |
|
OLD_LR_OK |
VARCHAR2(1) |
|
Old LR approval flag |
|
OLD_FRMP_OK |
VARCHAR2(1) |
|
Old FRMP approval flag |
|
OLD_MDA_OK |
VARCHAR2(1) |
|
Old MDA approval flag |
|
OLD_ROLR_OK |
VARCHAR2(1) |
|
Old ROLR approval flag |
|
OLD_RP_OK |
VARCHAR2(1) |
|
Old RP approval flag |
|
NEW_LNSP_OK |
VARCHAR2(1) |
|
New LNSP approval flag |
|
NEW_LR_OK |
VARCHAR2(1) |
|
New LR approval flag |
|
NEW_FRMP_OK |
VARCHAR2(1) |
|
New FRMP approval flag |
|
NEW_MDA_OK |
VARCHAR2(1) |
|
New MDA approval flag |
|
NEW_ROLR_OK |
VARCHAR2(1) |
|
New ROLR approval flag |
|
NEW_RP_OK |
VARCHAR2(1) |
|
New RP approval flag |
|
PRUDENTIAL_OK |
VARCHAR2(1) |
|
Prudential check flag |
|
INITIAL_CHANGE_DATE |
DATE |
|
Initial change date |
|
CURRENT_CHANGE_DATE |
DATE |
|
Current change date |
|
CP_NAME |
VARCHAR2(30) |
|
Connection point name |
|
CP_DETAIL_1 |
VARCHAR2(30) |
|
Connection point detail 1 |
|
CP_DETAIL_2 |
VARCHAR2(30) |
|
Connection point detail 2 |
|
CITY_SUBURB |
VARCHAR2(30) |
|
Connection point City/Suburb |
|
STATE |
VARCHAR2(3) |
|
State of Australia |
|
POST_CODE |
VARCHAR2(4) |
|
Connection point postcode |
|
TX_NODE |
VARCHAR2(4) |
|
Connection point TNI |
|
AGGREGATE_DATA |
VARCHAR2(1) |
|
Aggregate data Flag (YIN) |
|
AVERAGE_DAILY_LOAD_KWH |
NUMBER(8,0) |
|
Average Daily load in KWh |
|
DISTRIBUTION_LOSS |
NUMBER(5,4) |
|
Distribution loss factors |
|
OLD_LSNP_TEXT |
VARCHAR2(30) |
|
Old LNSP text field (LNSP misspelt in name) |
|
OLD_LR_TEXT |
VARCHAR2(30) |
|
Old LR text field |
|
OLD_FRMP_TEXT |
VARCHAR2(30) |
|
Old FRMP text field |
|
OLD_MDA_TEXT |
VARCHAR2(30) |
|
Old MDA text field |
|
OLD_ROLR_TEXT |
VARCHAR2(30) |
|
Old ROLR text field |
|
OLD_RP_TEXT |
VARCHAR2(30) |
|
Old RP text field |
|
NEW_LSNP_TEXT |
VARCHAR2(30) |
|
New LNSP text field (LNSP misspelt in name) |
|
NEW_LR_TEXT |
VARCHAR2(30) |
|
New LR text field |
|
NEW_FRMP_TEXT |
VARCHAR2(30) |
|
New FRMP text field |
|
|
|