Summary
The SQL pad provides direct access to our database. Being web based you avoid all of the access, firewall and security issues that a normal application SQL tool would entail.
SQL pad is provided by a third party vendor and in conjunction with AWS Redshift it uses Postgres protocols but with some limitations.
SQL commands
The available commands and other documentation are found here:
Content
For data content refer to our knowledge PAGE: market information
How To Access
To open the "SQL Pad" use the URL fcaspays.com and click on the database symbol in the left hand navigation bar.
Next, you will be prompted for your SQLPad login (note that this is different to your FCASpays login). Enter your credentials and Signin.
If you don't have a SQLPad account, then click on 'Sign up' and follow the instructions below.
First time users - sign up
New users of SQLPad will have to sign up for a separate account for SQLPad from your normal fcaspays login.
Go to https://sql.fcaspays.com.au/signup and enter your email address and password and click sign up.
On successful sign up, you will be logged directly into the app.
Error: Email address not whitelisted
If you get an error that 'email address not whitelisted', please contact support@pdview.com.au or send a message via chat and we will add access for your company to be able to sign up.
List of tables and fields in SQLPad
Schema: causerpays
| table_name | column_name |
|---|---|
| dispatchinterconnectorres_raw | dispatchinterval |
| dispatchinterconnectorres_raw | exportgenconid |
| dispatchinterconnectorres_raw | exportlimit |
| dispatchinterconnectorres_raw | fcasexportlimit |
| dispatchinterconnectorres_raw | fcasimportlimit |
| dispatchinterconnectorres_raw | importgenconid |
| dispatchinterconnectorres_raw | importlimit |
| dispatchinterconnectorres_raw | interconnectorid |
| dispatchinterconnectorres_raw | intervention |
| dispatchinterconnectorres_raw | lastchanged |
| dispatchinterconnectorres_raw | local_price_adjustment_export |
| dispatchinterconnectorres_raw | local_price_adjustment_import |
| dispatchinterconnectorres_raw | locally_constrained_export |
| dispatchinterconnectorres_raw | locally_constrained_import |
| dispatchinterconnectorres_raw | marginalloss |
| dispatchinterconnectorres_raw | marginalvalue |
| dispatchinterconnectorres_raw | meteredmwflow |
| dispatchinterconnectorres_raw | mwflow |
| dispatchinterconnectorres_raw | mwlosses |
| dispatchinterconnectorres_raw | record_type |
| dispatchinterconnectorres_raw | report_subtype |
| dispatchinterconnectorres_raw | report_type |
| dispatchinterconnectorres_raw | report_version |
| dispatchinterconnectorres_raw | runno |
| dispatchinterconnectorres_raw | settlementdate |
| dispatchinterconnectorres_raw | violationdegree |
| dispatchload_raw | agcstatus |
| dispatchload_raw | availability |
| dispatchload_raw | connectionpointid |
| dispatchload_raw | dispatchinterval |
| dispatchload_raw | dispatchmode |
| dispatchload_raw | downepf |
| dispatchload_raw | duid |
| dispatchload_raw | initialmw |
| dispatchload_raw | intervention |
| dispatchload_raw | lastchanged |
| dispatchload_raw | lower5min |
| dispatchload_raw | lower5minactualavailability |
| dispatchload_raw | lower5minflags |
| dispatchload_raw | lower60sec |
| dispatchload_raw | lower60secactualavailability |
| dispatchload_raw | lower60secflags |
| dispatchload_raw | lower6sec |
| dispatchload_raw | lower6secactualavailability |
| dispatchload_raw | lower6secflags |
| dispatchload_raw | lowerreg |
| dispatchload_raw | lowerregactualavailability |
| dispatchload_raw | lowerregavailability |
| dispatchload_raw | lowerregenablementmax |
| dispatchload_raw | lowerregenablementmin |
| dispatchload_raw | lowerregflags |
| dispatchload_raw | marginal5minvalue |
| dispatchload_raw | marginal60secvalue |
| dispatchload_raw | marginal6secvalue |
| dispatchload_raw | marginalvalue |
| dispatchload_raw | raise5min |
| dispatchload_raw | raise5minactualavailability |
| dispatchload_raw | raise5minflags |
| dispatchload_raw | raise60sec |
| dispatchload_raw | raise60secactualavailability |
| dispatchload_raw | raise60secflags |
| dispatchload_raw | raise6sec |
| dispatchload_raw | raise6secactualavailability |
| dispatchload_raw | raise6secflags |
| dispatchload_raw | raisereg |
| dispatchload_raw | raiseregactualavailability |
| dispatchload_raw | raiseregavailability |
| dispatchload_raw | raiseregenablementmax |
| dispatchload_raw | raiseregenablementmin |
| dispatchload_raw | raiseregflags |
| dispatchload_raw | rampdownrate |
| dispatchload_raw | rampuprate |
| dispatchload_raw | record_type |
| dispatchload_raw | report_subtype |
| dispatchload_raw | report_type |
| dispatchload_raw | report_version |
| dispatchload_raw | runno |
| dispatchload_raw | semidispatchcap |
| dispatchload_raw | settlementdate |
| dispatchload_raw | totalcleared |
| dispatchload_raw | tradetype |
| dispatchload_raw | upepf |
| dispatchload_raw | violation5mindegree |
| dispatchload_raw | violation60secdegree |
| dispatchload_raw | violation6secdegree |
| dispatchload_raw | violationdegree |
| dispatchregionsum_raw | aggegatedispatcherror |
| dispatchregionsum_raw | aggregatedispatcherror |
| dispatchregionsum_raw | availablegeneration |
| dispatchregionsum_raw | availableload |
| dispatchregionsum_raw | clearedsupply |
| dispatchregionsum_raw | demand_and_nonschedgen |
| dispatchregionsum_raw | demandforecast |
| dispatchregionsum_raw | dispatchablegeneration |
| dispatchregionsum_raw | dispatchableload |
| dispatchregionsum_raw | dispatchinterval |
| dispatchregionsum_raw | excessgeneration |
| dispatchregionsum_raw | initialsupply |
| dispatchregionsum_raw | intervention |
| dispatchregionsum_raw | lastchanged |
| dispatchregionsum_raw | lorsurplus |
| dispatchregionsum_raw | lower5minactualavailability |
| dispatchregionsum_raw | lower5mindispatch |
| dispatchregionsum_raw | lower5minimport |
| dispatchregionsum_raw | lower5minlocaldispatch |
| dispatchregionsum_raw | lower5minlocalprice |
| dispatchregionsum_raw | lower5minlocalreq |
| dispatchregionsum_raw | lower5minlocalviolation |
| dispatchregionsum_raw | lower5minprice |
| dispatchregionsum_raw | lower5minreq |
| dispatchregionsum_raw | lower5minsupplyprice |
| dispatchregionsum_raw | lower5minviolation |
| dispatchregionsum_raw | lower60secactualavailability |
| dispatchregionsum_raw | lower60secdispatch |
| dispatchregionsum_raw | lower60secimport |
| dispatchregionsum_raw | lower60seclocaldispatch |
| dispatchregionsum_raw | lower60seclocalprice |
| dispatchregionsum_raw | lower60seclocalreq |
| dispatchregionsum_raw | lower60seclocalviolation |
| dispatchregionsum_raw | lower60secprice |
| dispatchregionsum_raw | lower60secreq |
| dispatchregionsum_raw | lower60secsupplyprice |
| dispatchregionsum_raw | lower60secviolation |
| dispatchregionsum_raw | lower6secactualavailability |
| dispatchregionsum_raw | lower6secdispatch |
| dispatchregionsum_raw | lower6secimport |
| dispatchregionsum_raw | lower6seclocaldispatch |
| dispatchregionsum_raw | lower6seclocalprice |
| dispatchregionsum_raw | lower6seclocalreq |
| dispatchregionsum_raw | lower6seclocalviolation |
| dispatchregionsum_raw | lower6secprice |
| dispatchregionsum_raw | lower6secreq |
| dispatchregionsum_raw | lower6secsupplyprice |
| dispatchregionsum_raw | lower6secviolation |
| dispatchregionsum_raw | lowerregactualavailability |
| dispatchregionsum_raw | lowerregimport |
| dispatchregionsum_raw | lowerreglocaldispatch |
| dispatchregionsum_raw | lowerreglocalreq |
| dispatchregionsum_raw | lowerreglocalviolation |
| dispatchregionsum_raw | lowerregprice |
| dispatchregionsum_raw | lowerregreq |
| dispatchregionsum_raw | lowerregviolation |
| dispatchregionsum_raw | lrcsurplus |
| dispatchregionsum_raw | netinterchange |
| dispatchregionsum_raw | raise5minactualavailability |
| dispatchregionsum_raw | raise5mindispatch |
| dispatchregionsum_raw | raise5minimport |
| dispatchregionsum_raw | raise5minlocaldispatch |
| dispatchregionsum_raw | raise5minlocalprice |
| dispatchregionsum_raw | raise5minlocalreq |
| dispatchregionsum_raw | raise5minlocalviolation |
| dispatchregionsum_raw | raise5minprice |
| dispatchregionsum_raw | raise5minreq |
| dispatchregionsum_raw | raise5minsupplyprice |
| dispatchregionsum_raw | raise5minviolation |
| dispatchregionsum_raw | raise60secactualavailability |
| dispatchregionsum_raw | raise60secdispatch |
| dispatchregionsum_raw | raise60secimport |
| dispatchregionsum_raw | raise60seclocaldispatch |
| dispatchregionsum_raw | raise60seclocalprice |
| dispatchregionsum_raw | raise60seclocalreq |
| dispatchregionsum_raw | raise60seclocalviolation |
| dispatchregionsum_raw | raise60secprice |
| dispatchregionsum_raw | raise60secreq |
| dispatchregionsum_raw | raise60secsupplyprice |
| dispatchregionsum_raw | raise60secviolation |
| dispatchregionsum_raw | raise6secactualavailability |
| dispatchregionsum_raw | raise6secdispatch |
| dispatchregionsum_raw | raise6secimport |
| dispatchregionsum_raw | raise6seclocaldispatch |
| dispatchregionsum_raw | raise6seclocalprice |
| dispatchregionsum_raw | raise6seclocalreq |
| dispatchregionsum_raw | raise6seclocalviolation |
| dispatchregionsum_raw | raise6secprice |
| dispatchregionsum_raw | raise6secreq |
| dispatchregionsum_raw | raise6secsupplyprice |
| dispatchregionsum_raw | raise6secviolation |
| dispatchregionsum_raw | raiseregactualavailability |
| dispatchregionsum_raw | raiseregimport |
| dispatchregionsum_raw | raisereglocaldispatch |
| dispatchregionsum_raw | raisereglocalreq |
| dispatchregionsum_raw | raisereglocalviolation |
| dispatchregionsum_raw | raiseregprice |
| dispatchregionsum_raw | raiseregreq |
| dispatchregionsum_raw | raiseregviolation |
| dispatchregionsum_raw | regionid |
| dispatchregionsum_raw | rrp |
| dispatchregionsum_raw | runno |
| dispatchregionsum_raw | semischedule_clearedmw |
| dispatchregionsum_raw | semischedule_compliancemw |
| dispatchregionsum_raw | settlementdate |
| dispatchregionsum_raw | totaldemand |
| dispatchregionsum_raw | totalintermittentgeneration |
| dispatchregionsum_raw | uigf |
| duid_bidtype | bidtype |
| duid_bidtype | duid |
| effective_enablement | effective_lower_enablement |
| effective_enablement | effective_raise_enablement |
| effective_enablement | element_no |
| effective_enablement | settlementdate |
| effective_gen_headroom_5min | avg_effective_lower_headroom |
| effective_gen_headroom_5min | avg_effective_raise_headroom |
| effective_gen_headroom_5min | element_no |
| effective_gen_headroom_5min | settlementdate |
| element_interconnector | element_no |
| element_interconnector | has_target |
| element_interconnector | interconnector_name |
| element_load | element_no |
| element_load | load_name |
| elemental | dispatchtype |
| elemental | duid_name |
| elemental | effective_capacity |
| elemental | element_no |
| elemental | fuel_cost |
| elemental | fuel_type |
| elemental | measurement_name |
| elemental | measurement_type |
| elemental | portfolioid |
| elemental | regionid |
| elemental | registered_capacity |
| elemental | station_name |
| elemental | stationid |
| fcas_agc | ace |
| fcas_agc | acefil |
| fcas_agc | aceint |
| fcas_agc | element_no |
| fcas_agc | hz |
| fcas_agc | hzdev |
| fcas_agc | hznom |
| fcas_agc | hzoffset |
| fcas_agc | is_on |
| fcas_agc | quality_ace |
| fcas_agc | quality_acefil |
| fcas_agc | quality_aceint |
| fcas_agc | quality_hz |
| fcas_agc | quality_hzdev |
| fcas_agc | quality_hznom |
| fcas_agc | quality_hzoffset |
| fcas_agc | quality_is_on |
| fcas_agc | quality_time_error_sec |
| fcas_agc | time4sec |
| fcas_agc | time_error_sec |
| fcas_agc_5min | avg_acefil |
| fcas_agc_5min | avg_aceint |
| fcas_agc_5min | avg_hz |
| fcas_agc_5min | avg_hzdev |
| fcas_agc_5min | avg_hzoffset |
| fcas_agc_5min | avg_time_error |
| fcas_agc_5min | element_no |
| fcas_agc_5min | max_acefil |
| fcas_agc_5min | max_aceint |
| fcas_agc_5min | max_hz |
| fcas_agc_5min | max_hzdev |
| fcas_agc_5min | max_hzoffset |
| fcas_agc_5min | max_time_error |
| fcas_agc_5min | min_acefil |
| fcas_agc_5min | min_aceint |
| fcas_agc_5min | min_hz |
| fcas_agc_5min | min_hzdev |
| fcas_agc_5min | min_hzoffset |
| fcas_agc_5min | min_time_error |
| fcas_agc_5min | percent_above5015 |
| fcas_agc_5min | percent_above5050 |
| fcas_agc_5min | percent_below4950 |
| fcas_agc_5min | percent_below4985 |
| fcas_agc_5min | settlementdate |
| fcas_agc_5min | stdev_acefil |
| fcas_agc_5min | stdev_aceint |
| fcas_agc_5min | stdev_hz |
| fcas_agc_5min | stdev_hzdev |
| fcas_agc_5min | stdev_hzoffset |
| fcas_agc_5min | stdev_time_error |
| fcas_cp_raw | element_no |
| fcas_cp_raw | time4sec |
| fcas_cp_raw | value |
| fcas_cp_raw | value_quality |
| fcas_cp_raw | variable_no |
| fcas_dudetail | element_no |
| fcas_dudetail | fcas_service |
| fcas_gen | element_no |
| fcas_gen | instruction_mw |
| fcas_gen | mw |
| fcas_gen | nemde_target |
| fcas_gen | participation_factor |
| fcas_gen | quality_instruction_mw |
| fcas_gen | quality_mw |
| fcas_gen | quality_nemde_target |
| fcas_gen | quality_participation_factor |
| fcas_gen | time4sec |
| fcas_gen_dl | actual_lower_headroom |
| fcas_gen_dl | actual_raise_headroom |
| fcas_gen_dl | availability |
| fcas_gen_dl | effective_lower_enablement |
| fcas_gen_dl | effective_raise_enablement |
| fcas_gen_dl | element_no |
| fcas_gen_dl | initialmw |
| fcas_gen_dl | instruction_mw |
| fcas_gen_dl | lower5min |
| fcas_gen_dl | lower60sec |
| fcas_gen_dl | lower6sec |
| fcas_gen_dl | lowerreg |
| fcas_gen_dl | mw |
| fcas_gen_dl | nemde_target |
| fcas_gen_dl | participation_factor |
| fcas_gen_dl | quality_instruction_mw |
| fcas_gen_dl | quality_mw |
| fcas_gen_dl | quality_nemde_target |
| fcas_gen_dl | quality_participation_factor |
| fcas_gen_dl | raise5min |
| fcas_gen_dl | raise60sec |
| fcas_gen_dl | raise6sec |
| fcas_gen_dl | raisereg |
| fcas_gen_dl | rampdownrate |
| fcas_gen_dl | rampuprate |
| fcas_gen_dl | settlementdate |
| fcas_gen_dl | time4sec |
| fcas_gen_dl | totalcleared |
| fcas_gen_dl | trajectory |
| fcas_gen_dl | trajectory_ramp_mw_per_min |
| fcas_gen_dl_5min | actual_lower_headroom |
| fcas_gen_dl_5min | actual_raise_headroom |
| fcas_gen_dl_5min | availability |
| fcas_gen_dl_5min | avg_abs_trajectory_error |
| fcas_gen_dl_5min | avg_instruction_mw |
| fcas_gen_dl_5min | avg_lower_instruction_mw |
| fcas_gen_dl_5min | avg_lower_negresponse_mw |
| fcas_gen_dl_5min | avg_lower_response_mw |
| fcas_gen_dl_5min | avg_mw |
| fcas_gen_dl_5min | avg_participation_factor |
| fcas_gen_dl_5min | avg_raise_instruction_mw |
| fcas_gen_dl_5min | avg_raise_negresponse_mw |
| fcas_gen_dl_5min | avg_raise_response_mw |
| fcas_gen_dl_5min | avg_trajectory_error |
| fcas_gen_dl_5min | effective_lower_enablement |
| fcas_gen_dl_5min | effective_raise_enablement |
| fcas_gen_dl_5min | element_no |
| fcas_gen_dl_5min | initialmw |
| fcas_gen_dl_5min | lower5min |
| fcas_gen_dl_5min | lower60sec |
| fcas_gen_dl_5min | lower6sec |
| fcas_gen_dl_5min | lowerreg |
| fcas_gen_dl_5min | lowerregactualavailability |
| fcas_gen_dl_5min | max_instruction_mw |
| fcas_gen_dl_5min | max_mw |
| fcas_gen_dl_5min | max_participation_factor |
| fcas_gen_dl_5min | min_instruction_mw |
| fcas_gen_dl_5min | min_mw |
| fcas_gen_dl_5min | min_participation_factor |
| fcas_gen_dl_5min | nemde_target |
| fcas_gen_dl_5min | raise5min |
| fcas_gen_dl_5min | raise60sec |
| fcas_gen_dl_5min | raise6sec |
| fcas_gen_dl_5min | raisereg |
| fcas_gen_dl_5min | raiseregactualavailability |
| fcas_gen_dl_5min | rampdownrate |
| fcas_gen_dl_5min | rampuprate |
| fcas_gen_dl_5min | settlementdate |
| fcas_gen_dl_5min | stdev_instruction_mw |
| fcas_gen_dl_5min | stdev_mw |
| fcas_gen_dl_5min | stdev_participation_factor |
| fcas_gen_dl_5min | totalcleared |
| fcas_gen_dl_5min | trajectory_ramp_mw_per_min |
| fcas_interconnector | element_no |
| fcas_interconnector | mw |
| fcas_interconnector | nemde_target |
| fcas_interconnector | quality_mw |
| fcas_interconnector | quality_nemde_target |
| fcas_interconnector | time4sec |
| fcas_load | element_no |
| fcas_load | mw |
| fcas_load | quality_mw |
| fcas_load | time4sec |
| field_description | field_description |
| field_description | field_name |
| field_description | is_visible |
| field_description | table_name |
| remapped_elements | element_no |
| remapped_elements | measurement_name |
| remapped_elements | measurement_type |
| remapped_elements | remapped_element_no |
| remapped_elements | remapped_measurement_name |
| variables | aemo_varable_name |
| variables | description |
| variables | variable_name |
| variables | variable_no |
| x_vars | basslink_flow |
| x_vars | main_ace_hzdev_param |
| x_vars | main_acefil_param |
| x_vars | main_aceint_param |
| x_vars | main_aggregatedispatcherror |
| x_vars | main_clearedsupply_minus_initial |
| x_vars | main_effective_lower_enablement |
| x_vars | main_effective_raise_enablement |
| x_vars | main_fcast_error |
| x_vars | main_initialsupply |
| x_vars | main_lowerreglocaldispatch |
| x_vars | main_raisereglocaldispatch |
| x_vars | main_semischedule_clearedmw |
| x_vars | main_totalintermittentgeneration |
| x_vars | settlementdate |
| x_vars | tas_ace_hzdev_param |
| x_vars | tas_acefil_param |
| x_vars | tas_aceint_param |
| x_vars | tas_aggregatedispatcherror |
| x_vars | tas_clearedsupply_minus_initial |
| x_vars | tas_effective_lower_enablement |
| x_vars | tas_effective_raise_enablement |
| x_vars | tas_fcast_error |
| x_vars | tas_initialsupply |
| x_vars | tas_lowerreglocaldispatch |
| x_vars | tas_raisereglocaldispatch |
| x_vars | tas_semischedule_clearedmw |
| x_vars | tas_totalintermittentgeneration |