|
Name |
|
|
Comment |
PREDISPATCH_FCAS_REQ shows Predispatch Constraint tracking for Regional FCAS Requirements. |
|
Source PREDISPATCH_FCAS_REQ updates with each pre-dispatch run (half hourly) Volume Approximately 2,000 rows per day. Note The PERIODID columns in tables PREDISPATCHCONSTRAINT and PREDISPATCH_FCAS_REQ have no consistent relationship with the other PERIODID values in the other tables in the PRE-DISPATCH package (such as PREDISPATCHPRICE). AEMO and many Participants appreciate the data model is inconsistent, but the cost of changing existing systems has been judged as being unjustifiable. An additional field DATETIME was added to allow joins between these data sets. |
|
Name |
|
BIDTYPE |
|
DATETIME |
|
GENCONID |
|
REGIONID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
PREDISPATCHSEQNO |
VARCHAR2(20) |
|
PreDispatch Sequence number |
|
RUNNO |
NUMBER(3,0) |
|
Case Run number |
|
INTERVENTION |
NUMBER(2,0) |
|
Intervention Flag |
|
PERIODID |
VARCHAR2(20) |
|
Unique period identifier, in the format yyyymmddpp. The period (pp) is 01 to 48, with 01 corresponding to the half-hour ending at 04:30am. |
|
GENCONID |
VARCHAR2(20) |
X |
Generic Constraint ID - Join to table GenConData |
|
REGIONID |
VARCHAR2(10) |
X |
Region ID |
|
BIDTYPE |
VARCHAR2(10) |
X |
Bid Type Identifier |
|
GENCONEFFECTIVEDATE |
DATE |
|
Generic Constraint EffectiveDate - Join to table GenConData |
|
GENCONVERSIONNO |
NUMBER(3,0) |
|
Generic Constraint Version number - Join to table GenConData |
|
MARGINALVALUE |
NUMBER(16,6) |
|
Marginal Value of generic constraint |
|
DATETIME |
DATE |
X |
Date and Time of trading interval |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
BASE_COST |
NUMBER(18,8) |
|
The base cost of the constraint for this service, before the regulation/contingency split |
|
ADJUSTED_COST |
NUMBER(18,8) |
|
The adjusted cost of the constraint for this service, before the regulation/contingency split |
|
ESTIMATED_CMPF |
NUMBER(18,8) |
|
An estimated value for the constraint CMPF, based on dispatched data |
|
ESTIMATED_CRMPF |
NUMBER(18,8) |
|
An estimated value for the constraint CRMPF, based on dispatched data |
|
RECOVERY_FACTOR_CMPF |
NUMBER(18,8) |
|
Estimated recovery factor for CMPF based recovery |
|
RECOVERY_FACTOR_CRMPF |
NUMBER(18,8) |
|
Estimated recovery factor for CRMPF based recovery |
|
|
|