NEM Schema
Index
Initializing search
NEM Schema
Introduction
Guide
Guide
Data scope
Tables
Understanding the Market Structure
Official Documentation
Where is the Data?
How to download the data?
How to Preprocess the Data?
How to Query and Understand the Data
Common Queries
I Feel Your Pain
Further Reading
Schemas
Schemas
Tables
Tables
ADG_DETAIL
AGGREGATE_DISPATCH_GROUP
ANCILLARY_RECOVERY_SPLIT
APCCOMP
APCCOMPAMOUNT
APCCOMPAMOUNTTRK
APEVENT
APEVENTREGION
AREA
AUCTION
AUCTION_CALENDAR
AUCTION_IC_ALLOCATIONS
AUCTION_REVENUE_ESTIMATE
AUCTION_REVENUE_TRACK
AUCTION_RP_ESTIMATE
AUCTION_TRANCHE
AVERAGEPRICE30
BANK_GUARANTEE
BIDDAYOFFER
BIDDAYOFFER_D
BIDDUIDDETAILS
BIDDUIDDETAILSTRK
BIDOFFERFILETRK
BIDOFFERPERIOD
BIDPEROFFER
BIDPEROFFER_D
BIDTYPES
BIDTYPESTRK
BILLADJUSTMENTS
BILLINGAPCCOMPENSATION
BILLINGAPCRECOVERY
BILLINGASPAYMENTS
BILLINGASRECOVERY
BILLINGCALENDAR
BILLINGCPDATA
BILLINGCPSUM
BILLINGCUSTEXCESSGEN
BILLINGDAYTRK
BILLINGEXCESSGEN
BILLINGFEES
BILLINGFINANCIALADJUSTMENTS
BILLINGGENDATA
BILLINGINTERRESIDUES
BILLINGINTERVENTION
BILLINGINTERVENTIONREGION
BILLINGINTRARESIDUES
BILLINGIRAUCSURPLUS
BILLINGIRAUCSURPLUSSUM
BILLINGIRFM
BILLINGIRNSPSURPLUS
BILLINGIRNSPSURPLUSSUM
BILLINGIRPARTSURPLUS
BILLINGIRPARTSURPLUSSUM
BILLINGPRIORADJUSTMENTS
BILLINGREALLOC
BILLINGREALLOC_DETAIL
BILLINGREGIONEXPORTS
BILLINGREGIONFIGURES
BILLINGREGIONIMPORTS
BILLINGRESERVERECOVERY
BILLINGRESERVEREGIONRECOVERY
BILLINGRESERVETRADER
BILLINGRESERVETRADERREGION
BILLINGRUNTRK
BILLINGSMELTERREDUCTION
BILLING_APC_COMPENSATION
BILLING_APC_RECOVERY
BILLING_CASHSEC_INTEREST_PAY
BILLING_CO2E_PUBLICATION
BILLING_CO2E_PUBLICATION_TRK
BILLING_CSP_DEROGATION_AMOUNT
BILLING_DAILY_ENERGY_SUMMARY
BILLING_DIRECTION_RECONCILIATN
BILLING_DIRECTION_RECON_OTHER
BILLING_DIR_FINAL_AMOUNT
BILLING_DIR_FINAL_RECOVERY
BILLING_DIR_PROV_AMOUNT
BILLING_DIR_PROV_RECOVERY
BILLING_DIR_RECOVERY_DETAIL
BILLING_EFTSHORTFALL_AMOUNT
BILLING_EFTSHORTFALL_DETAIL
BILLING_ENERGY_GENSET_DETAIL
BILLING_ENERGY_TRANSACTIONS
BILLING_ENERGY_TRAN_SAPS
BILLING_FCAS_REG_AMT
BILLING_FCAS_REG_RESIDAMT
BILLING_FPP
BILLING_GST_DETAIL
BILLING_GST_SUMMARY
BILLING_IRSR_NSP_ALLOCATION
BILLING_MR_PAYMENT
BILLING_MR_RECOVERY
BILLING_MR_SHORTFALL
BILLING_MR_SUMMARY
BILLING_NMAS_MANUAL_PAYMENT
BILLING_NMAS_MANUAL_RECOVERY
BILLING_NMAS_TST_PAYMENTS
BILLING_NMAS_TST_RECOVERY
BILLING_NMAS_TST_RECVRY_RBF
BILLING_NMAS_TST_RECVRY_TRK
BILLING_RES_TRADER_PAYMENT
BILLING_RES_TRADER_RECOVERY
BILLING_SECDEPOSIT_APPLICATION
BILLING_SECDEP_INTEREST_PAY
BILLING_SECDEP_INTEREST_RATE
BILLING_SUBST_DEMAND
BILLING_SUBST_RUN_VERSION
BILLING_WDR
BILLING_WDR_DETAIL
BILLINTERVENTIONRECOVERY
BILLINTERVENTIONREGIONRECOVERY
BILLRESERVETRADERPAYMENT
BILLRESERVETRADERRECOVERY
BILLSMELTERRATE
BILLWHITEHOLE
CASH_SECURITY
CO2EII_AVAILABLE_GENERATORS
CO2EII_RESULTS_SUMMARY
CONNECTIONPOINT
CONNECTIONPOINTDETAILS
CONNECTIONPOINTOPERATINGSTA
CONSTRAINTRELAXATION OCD
CONTRACTAGC
CONTRACTGOVERNOR
CONTRACTLOADSHED
CONTRACTREACTIVEPOWER
CONTRACTRESERVEFLAG
CONTRACTRESERVETHRESHOLD
CONTRACTRESERVETRADER
CONTRACTRESTARTSERVICES
CONTRACTRESTARTUNITS
CONTRACTUNITLOADING
CONTRACTUNITUNLOADING
DAYOFFER
DAYOFFER_D
DAYTRACK
DEFAULTDAYOFFER
DEFAULTOFFERTRK
DEFAULTPEROFFER
DELTAMW
DEMANDOPERATIONALACTUAL
DEMANDOPERATIONALFORECAST
DISPATCHABLEUNIT
DISPATCHBIDTRK
DISPATCHBLOCKEDCONSTRAINT
DISPATCHCASESOLUTION
DISPATCHCASESOLUTION BNC
DISPATCHCASE_OCD
DISPATCHCONSTRAINT
DISPATCHINTERCONNECTORRES
DISPATCHLOAD
DISPATCHLOAD BNC
DISPATCHOFFERTRK
DISPATCHPRICE
DISPATCHREGIONSUM
DISPATCHTRK
DISPATCH_AGC_DATA
DISPATCH_CONSTRAINT_FCAS_OCD
DISPATCH_FCAS_REQ
DISPATCH_FCAS_REQ_CONSTRAINT
DISPATCH_FCAS_REQ_RUN
DISPATCH_INTERCONNECTION
DISPATCH_LOCAL_PRICE
DISPATCH_MNSPBIDTRK
DISPATCH_MR_SCHEDULE_TRK
DISPATCH_PRICE_REVISION
DISPATCH_ROOFTOP_PV_FCST_TRK
DISPATCH_UNIT_CONFORMANCE
DISPATCH_UNIT_SCADA
DUALLOC
DUDETAIL
DUDETAILSUMMARY
EMSMASTER
FCAS_REGU_USAGE_FACTORS
FCAS_REGU_USAGE_FACTORS_TRK
FORCEMAJEURE
FORCEMAJEUREREGION
FPP_CONSTRAINT_FREQ_MEASURE
FPP_CONTRIBUTION_FACTOR
FPP_EST_COST
FPP_EST_PERF_COST_RATE
FPP_EST_RESIDUAL_COST_RATE
FPP_FCAS_SUMMARY
FPP_FORECAST_DEFAULT_CF
FPP_FORECAST_RESIDUAL_DCF
FPP_HIST_PERFORMANCE
FPP_HIST_REGION_PERFORMANCE
FPP_P5_FWD_EST_COST
FPP_P5_FWD_EST_RESIDUALRATE
FPP_PD_FWD_EST_COST
FPP_PD_FWD_EST_RESIDUALRATE
FPP_PERFORMANCE
FPP_RCR
FPP_REGION_FREQ_MEASURE
FPP_RESIDUAL_CF
FPP_RESIDUAL_PERFORMANCE
FPP_RUN
FPP_UNIT_MW
FPP_USAGE
GDINSTRUCT
GENCONDATA
GENCONSET
GENCONSETINVOKE
GENCONSETTRK
GENERICCONSTRAINTRHS
GENERICEQUATIONDESC
GENERICEQUATIONRHS
GENMETER
GENUNITMTRINPERIOD
GENUNITS
GENUNITS_UNIT
GST_BAS_CLASS
GST_RATE
GST_TRANSACTION_CLASS
GST_TRANSACTION_TYPE
INSTRUCTIONSUBTYPE
INSTRUCTIONTYPE
INTCONTRACT
INTCONTRACTAMOUNT
INTCONTRACTAMOUNTTRK
INTERCONNECTOR
INTERCONNECTORALLOC
INTERCONNECTORCONSTRAINT
INTERCONNMWFLOW
INTERMITTENT_CLUSTER_AVAIL
INTERMITTENT_CLUSTER_AVAIL_DAY
INTERMITTENT_DS_PRED
INTERMITTENT_DS_RUN
INTERMITTENT_FORECAST_TRK
INTERMITTENT_GEN_FCST
INTERMITTENT_GEN_FCST_DATA
INTERMITTENT_GEN_FCST_P5_PRED
INTERMITTENT_GEN_FCST_P5_RUN
INTERMITTENT_GEN_FCST_PRED
INTERMITTENT_GEN_FCST_RUN
INTERMITTENT_GEN_LIMIT
INTERMITTENT_GEN_LIMIT_DAY
INTERMITTENT_GEN_SCADA
INTERMITTENT_P5_PRED
INTERMITTENT_P5_RUN
INTRAREGIONALLOC
IRFMAMOUNT
IRFMEVENTS
LOSSFACTORMODEL
LOSSMODEL
MARKETFEE
MARKETFEEDATA
MARKETFEETRK
MARKETNOTICEDATA
MARKETNOTICETYPE
MARKETSUSPENSION
MARKETSUSREGION
MARKET_FEE_CAT_EXCL
MARKET_FEE_CAT_EXCL_TRK
MARKET_FEE_EXCLUSION
MARKET_FEE_EXCLUSIONTRK
MARKET_PRICE_THRESHOLDS
MARKET_SUSPEND_REGIME_SUM
MARKET_SUSPEND_REGION_SUM
MARKET_SUSPEND_SCHEDULE
MARKET_SUSPEND_SCHEDULE_TRK
MAS_CP_CHANGE
MAS_CP_MASTER
MCC_CASESOLUTION
MCC_CONSTRAINTSOLUTION
METERDATA
METERDATATRK
METERDATA_AGGREGATE_READS
METERDATA_GEN_DUID
METERDATA_INDIVIDUAL_READS
METERDATA_INTERCONNECTOR
METERDATA_SAPS
METERDATA_TRK
METERDATA_WDR_READS
MMS_DATA_MODEL_AUDIT
MNSP_BIDOFFERPERIOD
MNSP_DAYOFFER
MNSP_FILETRK
MNSP_INTERCONNECTOR
MNSP_OFFERTRK
MNSP_PARTICIPANT
MNSP_PEROFFER
MR_DAYOFFER_STACK
MR_EVENT
MR_EVENT_SCHEDULE
MR_PEROFFER_STACK
MTPASACONSTRAINTSOLUTION_D
MTPASAINTERCONNECTORSOLUTION_D
MTPASAREGIONSOLUTION_D
MTPASA_CASERESULT
MTPASA_CASESOLUTION
MTPASA_CASE_SET
MTPASA_CONSTRAINTRESULT
MTPASA_CONSTRAINTSOLUTION
MTPASA_CONSTRAINTSUMMARY
MTPASA_DUIDAVAILABILITY
MTPASA_INTERCONNECTORRESULT
MTPASA_INTERCONNECTORSOLUTION
MTPASA_INTERMITTENT_AVAIL
MTPASA_INTERMITTENT_LIMIT
MTPASA_LOLPRESULT
MTPASA_OFFERDATA
MTPASA_OFFERFILETRK
MTPASA_REGIONAVAILABILITY
MTPASA_REGIONAVAIL_TRK
MTPASA_REGIONITERATION
MTPASA_REGIONRESULT
MTPASA_REGIONSOLUTION
MTPASA_REGIONSUMMARY
MTPASA_RESERVELIMIT
MTPASA_RESERVELIMITSOLUTION
MTPASA_RESERVELIMIT_REGION
MTPASA_RESERVELIMIT_SET
NEGATIVE_RESIDUE
NETWORK_EQUIPMENTDETAIL
NETWORK_OUTAGECONSTRAINTSET
NETWORK_OUTAGEDETAIL
NETWORK_OUTAGESTATUSCODE
NETWORK RATING
NETWORK_REALTIMERATING
NETWORK_STATICRATING
NETWORK_SUBSTATIONDETAIL
OARTRACK
OFFERAGCDATA
OFFERASTRK
OFFERFILETRK
OFFERGOVDATA
OFFERLSHEDDATA
OFFERRESTARTDATA
OFFERRPOWERDATA
OFFERULOADINGDATA
OFFERUNLOADINGDATA
OVERRIDERRP
P5MIN_BLOCKEDCONSTRAINT
P5MIN_CASESOLUTION
P5MIN_CONSTRAINTSOLUTION
P5MIN_FCAS_REQUIREMENT
P5MIN_FCAS_REQ_CONSTRAINT
P5MIN_FCAS_REQ_RUN
P5MIN_INTERCONNECTORSOLN
P5MIN_INTERMITTENT_FCST_TRK
P5MIN_INTERSENSITIVITIES
P5MIN_LOCAL_PRICE
P5MIN_PRICESENSITIVITIES
P5MIN_REGIONSOLUTION
P5MIN_ROOFTOP_PV_FCST_TRK
P5MIN_SCENARIODEMAND
P5MIN_SCENARIODEMANDTRK
P5MIN_UNITSOLUTION
PARTICIPANT
PARTICIPANTACCOUNT
PARTICIPANTCATEGORY
PARTICIPANTCATEGORYALLOC
PARTICIPANTCLASS
PARTICIPANTCREDITDETAIL
PARTICIPANTNOTICETRK
PARTICIPANT_BANDFEE_ALLOC
PASACASESOLUTION
PASACONSTRAINTSOLUTION
PASAINTERCONNECTORSOLUTION
PASAREGIONSOLUTION
PASA_CONTINGENCY_DEFINITION
PASA_DUID_SUBSTATION_MAPPING
PASA_INTERCONNECTOR_BOUNDARY
PASA_INTERCONNECTOR_MAPPING
PASA_INTERZONAL_BOUNDARY
PASA_INTERZONAL_MAPPING
PASA_SUBSTATION_ZONE_MAPPING
PASA_ZONE_REGION_MAPPING
PD7DAY_CASESOLUTION
PD7DAY_CONSTRAINTSOLUTION
PD7DAY_INTERCONNECTORSOLUTION
PD7DAY_MARKET_SUMMARY
PD7DAY_PRICESOLUTION
PDPASA_CASESOLUTION
PDPASA_CONSTRAINTSOLUTION
PDPASA_DUIDAVAILABILITY
PDPASA_FNM_CASESOLUTION
PDPASA_FNM_CONSTRAINTSOLUTION
PDPASA_FNM_DUIDAVAILABILITY
PDPASA_FNM_INTERCONNECTORSOLN
PDPASA_FNM_INTERZONALSOLUTION
PDPASA_FNM_REGIONSOLUTION
PDPASA_FNM_REGIONSUMMARY
PDPASA_FNM_ZONESOLUTION
PDPASA_FNM_ZONESUMMARY
PDPASA_INTERCONNECTORSOLN
PDPASA_REGIONSOLUTION
PD_FCAS_REQ_CONSTRAINT
PD_FCAS_REQ_RUN
PD_INTERMITTENT_FCST_TRK
PD_ROOFTOP_PV_FCST_TRK
PERDEMAND
PEROFFER
PEROFFER_D
PMS_GROUP
PMS_GROUPNMI
PMS_GROUPSERVICE
PREDISPATCHBIDTRK
PREDISPATCHBLOCKEDCONSTRAINT
PREDISPATCHCASESOLUTION
PREDISPATCHCONSTRAINT
PREDISPATCHINTERCONNECTORRES
PREDISPATCHINTERSENSITIVITIES
PREDISPATCHLOAD
PREDISPATCHOFFERTRK
PREDISPATCHPRICE
PREDISPATCHPRICESENSITIVITIES
PREDISPATCHREGIONSUM
PREDISPATCHSCENARIODEMAND
PREDISPATCHSCENARIODEMANDTRK
PREDISPATCH_FCAS_REQ
PREDISPATCH_LOCAL_PRICE
PREDISPATCH_MNSPBIDTRK
PRUDENTIALCOMPANYPOSITION
PRUDENTIALRUNTRK
REALLOCATION
REALLOCATIONDETAILS
REALLOCATIONINTERVAL
REALLOCATIONINTERVALS
REALLOCATIONS
REGION
REGIONAPC
REGIONAPCINTERVALS
REGIONFCASRELAXATION OCD
REGIONSTANDINGDATA
REGION_AREA
RESDEMANDTRK
RESERVE
RESIDUECONTRACTPAYMENTS
RESIDUEFILETRK
RESIDUE_BID_TRK
RESIDUE_CONTRACTS
RESIDUE_CON_DATA
RESIDUE_CON_ESTIMATES_TRK
RESIDUE_CON_FUNDS
RESIDUE_FUNDS_BID
RESIDUE_PRICE_BID
RESIDUE_PRICE_FUNDS_BID
RESIDUE_PUBLIC_DATA
RESIDUE_TRK
ROOFTOP_PV_ACTUAL
ROOFTOP_PV_ACTUAL_PRED
ROOFTOP_PV_ACTUAL_RUN
ROOFTOP_PV_FCST_P5_PRED
ROOFTOP_PV_FCST_P5_RUN
ROOFTOP_PV_FCST_PRED
ROOFTOP_PV_FCST_RUN
ROOFTOP_PV_FORECAST
SECDEPOSIT_INTEREST_RATE
SECDEPOSIT_PROVISION
SETAGCPAYMENT
SETAGCRECOVERY
SETAPCCOMPENSATION
SETAPCRECOVERY
SETCFG_PARTICIPANT_MPF
SETCFG_PARTICIPANT_MPFTRK
SETCFG_SAPS_SETT_PRICE
SETCFG_WDRRR_CALENDAR
SETCFG_WDR_REIMBURSE_RATE
SETCPDATA
SETCPDATAREGION
SETFCASCOMP
SETFCASRECOVERY
SETFCASREGIONRECOVERY
SETGENDATA
SETGENDATAREGION
SETGOVPAYMENT
SETGOVRECOVERY
SETINTERVENTION
SETINTERVENTIONRECOVERY
SETINTRAREGIONRESIDUES
SETIRAUCSURPLUS
SETIRFMRECOVERY
SETIRNSPSURPLUS
SETIRPARTSURPLUS
SETIRSURPLUS
SETLOCALAREAENERGY
SETLOCALAREATNI
SETLSHEDPAYMENT
SETLSHEDRECOVERY
SETLULOADPAYMENT
SETLULOADRECOVERY
SETLUNLOADPAYMENT
SETLUNLOADRECOVERY
SETMARKETFEES
SETREALLOCATIONS
SETRESERVERECOVERY
SETRESERVETRADER
SETRESTARTPAYMENT
SETRESTARTRECOVERY
SETRPOWERPAYMENT
SETRPOWERRECOVERY
SETSMALLGENDATA
SETVICBOUNDARYENERGY
SETVICENERGYFIGURES
SETVICENERGYFLOW
SET_ANCILLARY_SUMMARY
SET_APC_COMPENSATION
SET_APC_RECOVERY
SET_CSP_DEROGATION_AMOUNT
SET_CSP_SUPPORTDATA_CONSTRAINT
SET_CSP_SUPPORTDATA_ENERGYDIFF
SET_CSP_SUPPORTDATA_SUBPRICE
SET_ENERGY_GENSET_DETAIL
SET_ENERGY_REGION_SUMMARY
SET_ENERGY_TRANSACTIONS
SET_ENERGY_TRAN_SAPS
SET_FCAS_CLAWBACK_REQ
SET_FCAS_CLAWBACK_RUN_TRK
SET_FCAS_CLAWBACK_UNITSOLN
SET_FCAS_PAYMENT
SET_FCAS_RECOVERY
SET_FCAS_REGULATION_TRK
SET_FCAS_REG_AMOUNT
SET_FCAS_REG_DEF_AMT
SET_FCAS_REG_DEF_RESIDAMT
SET_FCAS_REG_RESIDAMT
SET_FPP
SET_IRSR_DIRECTIONAL_LINK
SET_IRSR_LOOP_NETTRADE_AMOUNT
SET_IRSR_LOOP_NSP_ALLOCATION
SET_IRSR_LOOP_REGION_SUMMARY
SET_MR_PAYMENT
SET_MR_RECOVERY
SET_NMAS_MANUAL_PAYMENT
SET_NMAS_RECOVERY
SET_NMAS_RECOVERY_RBF
SET_RECOVERY_ENERGY
SET_RUN_PARAMETER
SET_SUBSTITUTE_DEMAND
SET_SUBST_RUN_VERSION
SET_WDR_RECON_DETAIL
SET_WDR_TRANSACT
SPDCONNECTIONPOINTCONSTRAINT
SPDINTERCONNECTORCONSTRAINT
SPDREGIONCONSTRAINT
SRA_CASH_SECURITY
SRA_FINANCIAL_AUCPAY_DETAIL
SRA_FINANCIAL_AUCPAY_SUM
SRA_FINANCIAL_AUC_MARDETAIL
SRA_FINANCIAL_AUC_MARGIN
SRA_FINANCIAL_AUC_RECEIPTS
SRA_FINANCIAL_RUNTRK
SRA_OFFER_PRODUCT
SRA_OFFER_PROFILE
SRA_PRUDENTIAL_CASH_SECURITY
SRA_PRUDENTIAL_COMP_POSITION
SRA_PRUDENTIAL_EXPOSURE
SRA_PRUDENTIAL_RUN
SSM_CONTRACT_UNIT_AVAIL
SSM_ENABLEMENT_COSTS
SSM_ENABLEMENT_PERIOD
SSM_INDICATIVE_ROLL_DUID
SSM_INDICATIVE_ROLL_REGION
SSM_INSTRUCTION
SSM_SCHEDULE
SSM_SCHEDULED_AVAILABILITY
STADUALLOC
STATION
STATIONOPERATINGSTATUS
STATIONOWNER
STATIONOWNERTRK
STPASA_CASESOLUTION
STPASA_CONSTRAINTSOLUTION
STPASA_DUIDAVAILABILITY
STPASA_FNM_CASESOLUTION
STPASA_FNM_CONSTRAINTSOLUTION
STPASA_FNM_DUIDAVAILABILITY
STPASA_FNM_INTERCONNECTORSOLN
STPASA_FNM_INTERZONALSOLUTION
STPASA_FNM_REGIONSOLUTION
STPASA_FNM_REGIONSUMMARY
STPASA_FNM_ZONESOLUTION
STPASA_FNM_ZONESUMMARY
STPASA_INTERCONNECTORSOLN
STPASA_REGIONSOLUTION
STPASA_SYSTEMSOLUTION
STPASA_UNITSOLUTION
TRADINGINTERCONNECT
TRADINGLOAD
TRADINGPRICE
TRADINGREGIONSUM
TRANSMISSIONLOSSFACTOR
VALUATIONID
VOLTAGE_INSTRUCTION
VOLTAGE_INSTRUCTION_TRK
Special Tables
Special Tables
Price Setter Files
Participant Registration List
Nemde Outputs
Four Second Scada Top
Packages
Packages
ANCILLARY_SERVICES
ASOFFER
BIDS
BILLING_CONFIG
BILLING_RUN
CONFIGURATION
DEMAND_FORECASTS
DISPATCH
FORCE_MAJEURE
FPP
GD_INSTRUCT
GENERIC_CONSTRAINT
HISTORICAL TABLES
IRAUCTION
MARKET_CONFIG
MARKET_NOTICE
MCC_DISPATCH
METER_DATA
MTPASA
NETWORK
P5MIN
PARTICIPANT_REGISTRATION
PD7DAY
PDPASA
PRE_DISPATCH
PRUDENTIALS
RESERVE_DATA
SETTLEMENT_CONFIG
SETTLEMENT_DATA
STPASA_SOLUTION
SYSTEM_SECURITY_MANAGEMENT
TRADING_DATA
VOLTAGE_INSTRUCTIONS
Manifests
Manifests
About
About
About Author
Feedback
Legal Junk
Index
