Home
Disclaimer
This document is made available to you on the foll
List of packages
Description of the model MMS Data Model v5.0 Oracl
Notes
Each table description has a Note providing some i
Visibility
Package: CONFIGURATION
List of tables
Diagram: Entities: Configuration
Table: MMS_DATA_MODEL_AUDIT
Package: ANCILLARY_SERVICES
List of tables
Diagram: Entities: Ancillary Services
Table: CONTRACTAGC
Table: CONTRACTLOADSHED
Table: CONTRACTREACTIVEPOWER
Table: CONTRACTRESTARTSERVICES
Table: CONTRACTRESTARTUNITS
Package: ASOFFER
List of tables
Diagram: Entities: Ancillary Service Contracts
Table: OFFERAGCDATA
Table: OFFERASTRK
Table: OFFERLSHEDDATA
Table: OFFERRESTARTDATA
Table: OFFERRPOWERDATA
Package: BIDS
List of tables
Diagram: Entities: Bids
Table: BIDDAYOFFER
Table: BIDDAYOFFER_D
Table: BIDOFFERFILETRK
Table: BIDOFFERPERIOD
Table: BIDPEROFFER
Table: BIDPEROFFER_D
Table: MNSP_BIDOFFERPERIOD
Table: MNSP_DAYOFFER
Table: MNSP_FILETRK
Table: MNSP_OFFERTRK
Table: MNSP_PEROFFER
Table: MTPASA_OFFERDATA
Table: MTPASA_OFFERFILETRK
Package: BILLING_CONFIG
List of tables
Diagram: Entities: Billing Config
Table: BILLINGCALENDAR
Table: GST_BAS_CLASS
Table: GST_RATE
Table: GST_TRANSACTION_CLASS
Table: GST_TRANSACTION_TYPE
Table: SECDEPOSIT_INTEREST_RATE
Table: SECDEPOSIT_PROVISION
Package: BILLING_RUN
List of tables
Diagram: Entities: Billing Run
Table: BILLING_APC_COMPENSATION
Table: BILLING_APC_RECOVERY
Table: BILLING_CO2E_PUBLICATION
Table: BILLING_CO2E_PUBLICATION_TRK
Table: BILLING_DAILY_ENERGY_SUMMARY
Table: BILLING_DIRECTION_RECON_OTHER
Table: BILLING_DIRECTION_RECONCILIATN
Table: BILLING_EFTSHORTFALL_AMOUNT
Table: BILLING_EFTSHORTFALL_DETAIL
Table: BILLING_GST_DETAIL
Table: BILLING_GST_SUMMARY
Table: BILLING_MR_PAYMENT
Table: BILLING_MR_RECOVERY
Table: BILLING_MR_SHORTFALL
Table: BILLING_MR_SUMMARY
Table: BILLING_NMAS_TST_PAYMENTS
Table: BILLING_NMAS_TST_RECOVERY
Table: BILLING_NMAS_TST_RECVRY_RBF
Table: BILLING_NMAS_TST_RECVRY_TRK
Table: BILLING_RES_TRADER_PAYMENT
Table: BILLING_RES_TRADER_RECOVERY
Table: BILLING_SECDEP_INTEREST_PAY
Table: BILLING_SECDEP_INTEREST_RATE
Table: BILLING_SECDEPOSIT_APPLICATION
Table: BILLINGAPCCOMPENSATION
Table: BILLINGAPCRECOVERY
Table: BILLINGASPAYMENTS
Table: BILLINGASRECOVERY
Table: BILLINGCPDATA
Table: BILLINGDAYTRK
Table: BILLINGFEES
Table: BILLINGFINANCIALADJUSTMENTS
Table: BILLINGGENDATA
Table: BILLINGINTERRESIDUES
Table: BILLINGINTRARESIDUES
Table: BILLINGIRAUCSURPLUS
Table: BILLINGIRAUCSURPLUSSUM
Table: BILLINGIRFM
Table: BILLINGIRNSPSURPLUS
Table: BILLINGIRNSPSURPLUSSUM
Table: BILLINGIRPARTSURPLUS
Table: BILLINGIRPARTSURPLUSSUM
Table: BILLINGPRIORADJUSTMENTS
Table: BILLINGREALLOC
Table: BILLINGREALLOC_DETAIL
Table: BILLINGREGIONEXPORTS
Table: BILLINGREGIONFIGURES
Table: BILLINGREGIONIMPORTS
Table: BILLINGRUNTRK
Table: BILLINGSMELTERREDUCTION
Table: BILLRESERVETRADERPAYMENT
Table: BILLRESERVETRADERRECOVERY
Table: BILLWHITEHOLE
Package: DEMAND_FORECASTS
List of tables
Diagram: Entities: Demand Forecasts
Table: DEMANDOPERATIONALACTUAL
Table: DEMANDOPERATIONALFORECAST
Table: INTERMITTENT_CLUSTER_AVAIL
Table: INTERMITTENT_CLUSTER_AVAIL_DAY
Table: INTERMITTENT_DS_PRED
Table: INTERMITTENT_DS_RUN
Table: INTERMITTENT_GEN_FCST
Table: INTERMITTENT_GEN_FCST_DATA
Table: INTERMITTENT_GEN_LIMIT
Table: INTERMITTENT_GEN_LIMIT_DAY
Table: INTERMITTENT_P5_PRED
Table: INTERMITTENT_P5_RUN
Table: MTPASA_INTERMITTENT_AVAIL
Table: MTPASA_INTERMITTENT_LIMIT
Table: PERDEMAND
Table: RESDEMANDTRK
Table: ROOFTOP_PV_ACTUAL
Table: ROOFTOP_PV_FORECAST
Package: DISPATCH
List of tables
Diagram: Entities: Dispatch
Table: CONSTRAINTRELAXATION_OCD
Table: DISPATCH_CONSTRAINT_FCAS_OCD
Table: DISPATCH_FCAS_REQ
Table: DISPATCH_INTERCONNECTION
Table: DISPATCH_LOCAL_PRICE
Table: DISPATCH_MNSPBIDTRK
Table: DISPATCH_MR_SCHEDULE_TRK
Table: DISPATCH_PRICE_REVISION
Table: DISPATCH_UNIT_CONFORMANCE
Table: DISPATCH_UNIT_SCADA
Table: DISPATCHBLOCKEDCONSTRAINT
Table: DISPATCHCASESOLUTION
Table: DISPATCHCONSTRAINT
Table: DISPATCHINTERCONNECTORRES
Table: DISPATCHLOAD
Table: DISPATCHOFFERTRK
Table: DISPATCHPRICE
Table: DISPATCHREGIONSUM
Table: INTERMITTENT_FORECAST_TRK
Table: NEGATIVE_RESIDUE
Package: FORCE_MAJEURE
List of tables
Diagram: Entities: Force Majeure
Table: APEVENT
Table: APEVENTREGION
Table: IRFMAMOUNT
Table: IRFMEVENTS
Table: MARKET_SUSPEND_REGIME_SUM
Table: MARKET_SUSPEND_REGION_SUM
Table: MARKET_SUSPEND_SCHEDULE
Table: MARKET_SUSPEND_SCHEDULE_TRK
Table: OVERRIDERRP
Table: REGIONAPC
Table: REGIONAPCINTERVALS
Package: GD_INSTRUCT
List of tables
Diagram: Entities: GD Instruct
Table: GDINSTRUCT
Table: INSTRUCTIONSUBTYPE
Table: INSTRUCTIONTYPE
Package: GENERIC_CONSTRAINT
List of tables
Diagram: Entities: Generic Constraints
Table: EMSMASTER
Table: GENCONDATA
Table: GENCONSET
Table: GENCONSETINVOKE
Table: GENCONSETTRK
Table: GENERICCONSTRAINTRHS
Table: GENERICEQUATIONDESC
Table: GENERICEQUATIONRHS
Table: SPDCONNECTIONPOINTCONSTRAINT
Table: SPDINTERCONNECTORCONSTRAINT
Table: SPDREGIONCONSTRAINT
Package: IRAUCTION
List of tables
Diagram: Entities: IRAuction
Table: AUCTION
Table: AUCTION_CALENDAR
Table: AUCTION_IC_ALLOCATIONS
Table: AUCTION_REVENUE_ESTIMATE
Table: AUCTION_REVENUE_TRACK
Table: AUCTION_RP_ESTIMATE
Table: AUCTION_TRANCHE
Table: RESIDUE_BID_TRK
Table: RESIDUE_CON_DATA
Table: RESIDUE_CON_ESTIMATES_TRK
Table: RESIDUE_CON_FUNDS
Table: RESIDUE_CONTRACTS
Table: RESIDUE_FUNDS_BID
Table: RESIDUE_PRICE_BID
Table: RESIDUE_PRICE_FUNDS_BID
Table: RESIDUE_PUBLIC_DATA
Table: RESIDUE_TRK
Table: RESIDUECONTRACTPAYMENTS
Table: RESIDUEFILETRK
Table: SRA_CASH_SECURITY
Table: SRA_FINANCIAL_AUC_MARDETAIL
Table: SRA_FINANCIAL_AUC_MARGIN
Table: SRA_FINANCIAL_AUC_RECEIPTS
Table: SRA_FINANCIAL_AUCPAY_DETAIL
Table: SRA_FINANCIAL_AUCPAY_SUM
Table: SRA_FINANCIAL_RUNTRK
Table: SRA_OFFER_PRODUCT
Table: SRA_OFFER_PROFILE
Table: SRA_PRUDENTIAL_CASH_SECURITY
Table: SRA_PRUDENTIAL_COMP_POSITION
Table: SRA_PRUDENTIAL_EXPOSURE
Table: SRA_PRUDENTIAL_RUN
Table: VALUATIONID
Package: MARKET_CONFIG
List of tables
Diagram: Entities: Market Standing Data
Table: BIDTYPES
Table: BIDTYPESTRK
Table: INTERCONNECTOR
Table: INTERCONNECTORALLOC
Table: INTERCONNECTORCONSTRAINT
Table: INTRAREGIONALLOC
Table: LOSSFACTORMODEL
Table: LOSSMODEL
Table: MARKET_PRICE_THRESHOLDS
Table: REGION
Table: REGIONSTANDINGDATA
Table: TRANSMISSIONLOSSFACTOR
Package: MARKET_NOTICE
List of tables
Diagram: Entities: Market Notices
Table: MARKETNOTICEDATA
Table: MARKETNOTICETYPE
Table: PARTICIPANTNOTICETRK
Package: METER_DATA
List of tables
Diagram: Entities: Meter Data
Table: METERDATA_AGGREGATE_READS
Table: METERDATA_INDIVIDUAL_READS
Table: METERDATA_INTERCONNECTOR
Table: METERDATA_TRK
Package: MREVENT
List of tables
Diagram: Entities: MR Events
Table: MR_DAYOFFER_STACK
Table: MR_EVENT
Table: MR_EVENT_SCHEDULE
Table: MR_PEROFFER_STACK
Package: MTPASA
List of tables
Diagram: Entities: MT PASA
Table: MTPASA_CASERESULT
Table: MTPASA_CONSTRAINTRESULT
Table: MTPASA_CONSTRAINTSUMMARY
Table: MTPASA_DUIDAVAILABILITY
Table: MTPASA_INTERCONNECTORRESULT
Table: MTPASA_LOLPRESULT
Table: MTPASA_REGIONAVAIL_TRK
Table: MTPASA_REGIONAVAILABILITY
Table: MTPASA_REGIONITERATION
Table: MTPASA_REGIONRESULT
Table: MTPASA_REGIONSUMMARY
Package: P5MIN
List of tables
Diagram: Entities: P5MIN
Table: P5MIN_BLOCKEDCONSTRAINT
Table: P5MIN_CASESOLUTION
Table: P5MIN_CONSTRAINTSOLUTION
Table: P5MIN_INTERCONNECTORSOLN
Table: P5MIN_INTERSENSITIVITIES
Table: P5MIN_LOCAL_PRICE
Table: P5MIN_PRICESENSITIVITIES
Table: P5MIN_REGIONSOLUTION
Table: P5MIN_SCENARIODEMAND
Table: P5MIN_SCENARIODEMANDTRK
Table: P5MIN_UNITSOLUTION
Package: PARTICIPANT_REGISTRATION
List of tables
Diagram: Entities: Participant Registration
Table: BIDDUIDDETAILS
Table: BIDDUIDDETAILSTRK
Table: DISPATCHABLEUNIT
Table: DUALLOC
Table: DUDETAIL
Table: DUDETAILSUMMARY
Table: GENMETER
Table: GENUNITS
Table: GENUNITS_UNIT
Table: MNSP_INTERCONNECTOR
Table: MNSP_PARTICIPANT
Table: PARTICIPANT
Table: PARTICIPANTACCOUNT
Table: PARTICIPANTCATEGORY
Table: PARTICIPANTCATEGORYALLOC
Table: PARTICIPANTCLASS
Table: PARTICIPANTCREDITDETAIL
Table: STADUALLOC
Table: STATION
Table: STATIONOPERATINGSTATUS
Table: STATIONOWNER
Table: STATIONOWNERTRK
Package: PRE_DISPATCH
List of tables
Diagram: Entities: Predispatch
Table: PREDISPATCH_FCAS_REQ
Table: PREDISPATCH_LOCAL_PRICE
Table: PREDISPATCH_MNSPBIDTRK
Table: PREDISPATCHBLOCKEDCONSTRAINT
Table: PREDISPATCHCASESOLUTION
Table: PREDISPATCHCONSTRAINT
Table: PREDISPATCHINTERCONNECTORRES
Table: PREDISPATCHINTERSENSITIVITIES
Table: PREDISPATCHLOAD
Table: PREDISPATCHOFFERTRK
Table: PREDISPATCHPRICE
Table: PREDISPATCHPRICESENSITIVITIES
Table: PREDISPATCHREGIONSUM
Table: PREDISPATCHSCENARIODEMAND
Table: PREDISPATCHSCENARIODEMANDTRK
Package: RESERVE_DATA
List of tables
Diagram: Entities: Reserve Data
Table: MTPASA_RESERVELIMIT
Table: MTPASA_RESERVELIMIT_REGION
Table: MTPASA_RESERVELIMIT_SET
Table: RESERVE
Package: SETTLEMENT_CONFIG
List of tables
Diagram: Entities: Settlement Config
Table: ANCILLARY_RECOVERY_SPLIT
Table: MARKET_FEE_CAT_EXCL
Table: MARKET_FEE_CAT_EXCL_TRK
Table: MARKET_FEE_EXCLUSION
Table: MARKET_FEE_EXCLUSIONTRK
Table: MARKETFEE
Table: MARKETFEEDATA
Table: MARKETFEETRK
Table: PARTICIPANT_BANDFEE_ALLOC
Table: REALLOCATION
Table: REALLOCATIONINTERVAL
Table: SETCFG_PARTICIPANT_MPF
Table: SETCFG_PARTICIPANT_MPFTRK
Package: SETTLEMENT_DATA
List of tables
Diagram: Entities: Settlement Data
Table: DAYTRACK
Table: SET_ APC_COMPENSATION
Table: SET_ APC_RECOVERY
Table: SET_ANCILLARY_SUMMARY
Table: SET_FCAS_PAYMENT
Table: SET_FCAS_RECOVERY
Table: SET_FCAS_REGULATION_TRK
Table: SET_MR_PAYMENT
Table: SET_MR_RECOVERY
Table: SET_NMAS_RECOVERY
Table: SET_NMAS_RECOVERY_RBF
Table: SET_RUN_PARAMETER
Table: SETAGCPAYMENT
Table: SETAGCRECOVERY
Table: SETCPDATA
Table: SETCPDATAREGION
Table: SETFCASCOMP
Table: SETFCASREGIONRECOVERY
Table: SETGENDATA
Table: SETGENDATAREGION
Table: SETINTERVENTION
Table: SETINTERVENTIONRECOVERY
Table: SETINTRAREGIONRESIDUES
Table: SETIRAUCSURPLUS
Table: SETIRFMRECOVERY
Table: SETIRNSPSURPLUS
Table: SETIRPARTSURPLUS
Table: SETIRSURPLUS
Table: SETLOCALAREAENERGY
Table: SETLOCALAREATNI
Table: SETLSHEDPAYMENT
Table: SETLSHEDRECOVERY
Table: SETLULOADRECOVERY
Table: SETLUNLOADPAYMENT
Table: SETLUNLOADRECOVERY
Table: SETMARKETFEES
Table: SETREALLOCATIONS
Table: SETRESERVERECOVERY
Table: SETRESTARTPAYMENT
Table: SETRESTARTRECOVERY
Table: SETRPOWERPAYMENT
Table: SETRPOWERRECOVERY
Table: SETSMALLGENDATA
Table: SETVICBOUNDARYENERGY
Table: SETVICENERGYFIGURES
Table: SETVICENERGYFLOW
Package: STPASA_SOLUTION
List of tables
Diagram: Entities: ST PASA Solution
Table: STPASA_CASESOLUTION
Table: STPASA_CONSTRAINTSOLUTION
Table: STPASA_INTERCONNECTORSOLN
Table: STPASA_REGIONSOLUTION
Package: TRADING_DATA
List of tables
Diagram: Entities: Trading Data
Table: AVERAGEPRICE30
Table: TRADINGINTERCONNECT
Table: TRADINGLOAD
Table: TRADINGPRICE
Table: TRADINGREGIONSUM
Package: HISTORICAL TABLES
List of tables
Diagram: Entities: Historical Tables
Table: APCCOMP
Table: APCCOMPAMOUNT
Table: APCCOMPAMOUNTTRK
Table: BILLADJUSTMENTS
Table: BILLING_CSP_DEROGATION_AMOUNT
Table: BILLINGCPSUM
Table: BILLINGCUSTEXCESSGEN
Table: BILLINGEXCESSGEN
Table: BILLINGINTERVENTION
Table: BILLINGINTERVENTIONREGION
Table: BILLINGRESERVERECOVERY
Table: BILLINGRESERVEREGIONRECOVERY
Table: BILLINGRESERVETRADER
Table: BILLINGRESERVETRADERREGION
Table: BILLINTERVENTIONRECOVERY
Table: BILLINTERVENTIONREGIONRECOVERY
Table: BILLSMELTERRATE
Table: CONNECTIONPOINT
Table: CONNECTIONPOINTDETAILS
Table: CONNECTIONPOINTOPERATINGSTA
Table: CONTRACTGOVERNOR
Table: CONTRACTRESERVEFLAG
Table: CONTRACTRESERVETHRESHOLD
Table: CONTRACTRESERVETRADER
Table: CONTRACTUNITLOADING
Table: CONTRACTUNITUNLOADING
Table: DAYOFFER
Table: DAYOFFER_D
Table: DEFAULTDAYOFFER
Table: DEFAULTOFFERTRK
Table: DEFAULTPEROFFER
Table: DELTAMW
Table: DISPATCHBIDTRK
Table: DISPATCHCASE_OCD
Table: DISPATCHCASESOLUTION_BNC
Table: DISPATCHLOAD_BNC
Table: DISPATCHTRK
Table: FORCEMAJEURE
Table: FORCEMAJEUREREGION
Table: GENUNITMTRINPERIOD
Table: INTCONTRACT
Table: INTCONTRACTAMOUNT
Table: INTCONTRACTAMOUNTTRK
Table: INTERCONNMWFLOW
Table: MARKETSUSPENSION
Table: MARKETSUSREGION
Table: MAS_CP_CHANGE
Table: MAS_CP_MASTER
Table: METERDATA
Table: METERDATA_GEN_DUID
Table: METERDATATRK
Table: MTPASA_CASE_SET
Table: MTPASA_CASESOLUTION
Table: MTPASA_CONSTRAINTSOLUTION
Table: MTPASA_INTERCONNECTORSOLUTION
Table: MTPASA_REGIONSOLUTION
Table: MTPASA_RESERVELIMITSOLUTION
Table: MTPASACONSTRAINTSOLUTION_D
Table: MTPASAINTERCONNECTORSOLUTION_D
Table: MTPASAREGIONSOLUTION_D
Table: OARTRACK
Table: OFFERFILETRK
Table: OFFERGOVDATA
Table: OFFERULOADINGDATA
Table: OFFERUNLOADINGDATA
Table: PASACASESOLUTION
Table: PASACONSTRAINTSOLUTION
Table: PASAINTERCONNECTORSOLUTION
Table: PASAREGIONSOLUTION
Table: PEROFFER
Table: PEROFFER_D
Table: PREDISPATCHBIDTRK
Table: REALLOCATIONDETAILS
Table: REALLOCATIONINTERVALS
Table: REALLOCATIONS
Table: REGIONFCASRELAXATION_OCD
Table: SET_CSP_DEROGATION_AMOUNT
Table: SET_CSP_SUPPORTDATA_CONSTRAINT
Table: SET_CSP_SUPPORTDATA_ENERGYDIFF
Table: SET_CSP_SUPPORTDATA_SUBPRICE
Table: SETAPCCOMPENSATION
Table: SETAPCRECOVERY
Table: SETFCASRECOVERY
Table: SETGOVPAYMENT
Table: SETGOVRECOVERY
Table: SETLULOADPAYMENT
Table: SETRESERVETRADER
Table: STPASA_SYSTEMSOLUTION
Table: STPASA_UNITSOLUTION
Package: PDPASA
List of tables
Diagram: Entities: PD PASA
Table: PDPASA_CASESOLUTION
Table: PDPASA_CONSTRAINTSOLUTION
Table: PDPASA_INTERCONNECTORSOLN
Table: PDPASA_REGIONSOLUTION
Package: PRUDENTIALS
List of tables
Diagram: Entities:Prudentials
Table: PRUDENTIALCOMPANYPOSITION
Table: PRUDENTIALRUNTRK
Package: MCC_DISPATCH
List of tables
Diagram: Entities: MCC_Dispatch
Table: MCC_CASESOLUTION
Table: MCC_CONSTRAINTSOLUTION
Package: NETWORK
List of tables
Diagram: Entities: NETWORK
Table: NETWORK_EQUIPMENTDETAIL
Table: NETWORK_OUTAGECONSTRAINTSET
Table: NETWORK_OUTAGEDETAIL
Table: NETWORK_OUTAGESTATUSCODE
Table: NETWORK_RATING
Table: NETWORK_REALTIMERATING
Table: NETWORK_STATICRATING
Table: NETWORK_SUBSTATIONDETAIL
Package: VOLTAGE_INSTRUCTIONS
List of tables
Diagram: Entities: Voltage Instructions
Table: VOLTAGE_INSTRUCTION
Table: VOLTAGE_INSTRUCTION_TRK
List of tables