Database Mis Report Format

Document Sample
Database Mis Report Format Powered By Docstoc
					                                                                                              Report
Report ID
(Master List                                                               Zonal/Nodal
Number)        Report Name                                Specifications   Classification
               Day Ahead Market Market Operating Day
COMS - 800
               Extract
                                                          DAM MODE         Nodal
               Day Ahead Market Consolidated Operating
NP12 - 177
               Day Extract
                                                          DAM CODE         Nodal


               Real Time Market Consolidated Operating
NP12 - 747
               Day Extract

                                                          RTM CODE         Nodal


NP12 - 749     Real Time Market Operating Day Extract

                                                          RTM MODE         Nodal

                                                                           Zonal/Nodal
ZP12 - 465     Public Reference Data Extract
                                                                           (modify existing
                                                          PRDE             for Nodal)


NP12 - 753     Settlement Inputs Data Extract

                                                          SID              Nodal

NP9 - 515      Market Participant Dispute Extract
                                                          MP Disputes      Nodal

NP9 - 598      Settlement Calendar Extract
                                                          Calendar         Nodal

COMS - 801     Settlements Late Fee Extract
                                                          Late Fees        Nodal
COMS - 802     CRR Auction Revenue Distribution Extract
                                                          CARD             Nodal




               ESI ID Service History & Usage Extract -
ZP12 - 245
               Daily
                                                                           Zonal/Nodal
                                                                           (modify existing
                                                          727 Daily        for Nodal)
                     ESI ID Service History & Usage Extract -
ZP12 - 247                                                                             Zonal/Nodal
                     Supplemental
                                                                                       (modify existing
                                                                727 Supp               for Nodal)



Coms - 438           Provide all ESIID Extract Records
                                                                                       Zonal/Nodal
                                                                                       (modify existing
                                                                WS-ESIID Ext Records   for Nodal)

                                                                                       Zonal/Nodal
Coms - 452           Provide Public Data Extract
                                                                                       (modify existing
                                                                WS-Dim Data            for Nodal)


                     Verify Records Used in Data Aggregation
Coms - 440
                     For a Trade Date                                                  Zonal/Nodal
                                                                                       (modify existing
                                                                WS-Data Agg Records    for Nodal)


ZP12 - 246           ESI ID Service History & Usage - Initial                          Zonal/Nodal
                                                                                       (modify existing
                                                                727 Initial            for Nodal)



                                      KEY/LEGEND
Green Tabs = List of all COMS/EDW Reports by Category
Orange Tab = Master List of reports in workbook
Details of Nodal Reports & Extracts, Master Table List and Extract Scheduler Example

Blue Tabs = Phase 1 Extracts
Red Tabs = Phase 2 Extracts
                   Report Identification

                                                               Business Process Classification
Product Definition                          Protocol           Retail/Data Agg/Settlements
Data used in the DAM settlement
calculation made available to Market
Participants for shadow settling            NP 12.3 (c)                    Settlements
Data used in the DAM settlement
calculation made available to Market        NP 12.3 (c)
Participants for shadow settling            NP 5.7.4 (3)                   Settlements
Load and generation data aggregation
and settlement and billing inputs and       P 11.5.2.2
outputs provided by approved settlement     P 11.5.1.1
operating day that are CERTIFIED bill       NP 12.3 c
determinants                                P 11.6.2.4             Data Aggregation/Settlements
Load and generation data aggregation
and settlement and billing inputs and       P 11.5.2.2
outputs provided by approved settlement     P 11.5.1.1
operating day that are MARKET WIDE          NP 12.3 c
bill determinants                           P 11.6.2.4             Data Aggregation/Settlements
This extract includes all dimensional
market level tables that are included in
the ESIID Service History & Usage           NP 12.3 (c)
Extract (SCR727).                           NP 12.4.4.2.3.2.    Retail/Data Aggregation/Settlements
This extract provides the day-after
operating day public and private
settlement input data, and public load
forecast data 2 days prior to an
operating day, on a daily basis.            NP 12.3 (c)                    Settlements

Reporting Capability for Disputes.
Publish report of status of all disputes.   NP 9.8.6                       Settlements
Settlement Calendar. Publish
Settlement Calendar for each operating
day.                                        NP 9.2.1                       Settlements
Includes the daily late fee calculations
that are included on a monthly late fee
invoice                                     NP 12.3 (c)                    Settlements
Includes the monthly allocations of CRR
Auction Revenues                            NP 12.3 (c)                    Settlements

This data extract provides transparency
to Market Participants for ESI ID level
data that ERCOT utilizes in market          P 12.4.4.2.3.2.
settlement and provides Market              Retail Market
Participants with the data needed to        Guide - section
develop shadow settlement systems.          7.1.3
The level of transparency also serve        SCR 740                           Retail
                                            P 12.4.4.2.3.2.
                                            Retail Market
                                            Guide - section
This is a supplemental 727 extract to       7.1.3
deliver missing data from prior 727 runs SCR 740              Retail
This data request is used to assist
market participants in verifying both
market participant specific tables and
public tables within the SCR 727 ESIID
Service History & Usage extract as of a
particular point in time.                   SCR 740           Retail
Provides the following public data tables
for records I own for the point in time
provided: REP, TDSP, MRE, PGC,
STATION, STSH, PFCL                         SCR 740           Retail
This data request is used to assist
market participants in verifying records
used in the data aggregation process for
owned ESIIDs/UIDESIIDs as of a
particular point in time for a particular
trade date (Operating Day).                 SCR 740           Retail
                                            P 12.4.4.2.3.2.
                                            Retail Market
                                            Guide - section
This extract delivers initial ESIID data to 7.1.3
a newly opted-in market participant         SCR 740           Retail
Data/
Generating    Protocol         Report Posting
Source        Security Level   Layout(s) / Format(s)
  Lodestar/
                  Secure             CSV, XML
    ODS

  Lodestar/
                  Certified          CSV, XML
    ODS


  Lodestar/
                  Certified          CSV, XML
    ODS



  Lodestar/
                  Secure             CSV, XML
    ODS



  Lodestar/
                  Secure             CSV, XML
    ODS



  Lodestar/
                  Certified          CSV, XML
    ODS



 Siebel/ODS       Certified          CSV, XML


  Lodestar/
                   Public            CSV, XML
    ODS

  Lodestar/
                  Certified          CSV, XML
    ODS
  Lodestar/
                  Certified          CSV, XML
    ODS



  Lodestar/
                  Certified             CSV
    ODS
Lodestar/
            Certified     CSV
  ODS




Lodestar/
            Certified   CSV, XML
  ODS



Lodestar/
            Certified   CSV, XML
  ODS



Lodestar/
            Certified   CSV, XML
  ODS




Lodestar/
            Certified     CSV
  ODS
All Zonal Reports/Extracts and Applications listed below will continue to be made available and posted on the TML or ERCOT.com until the
                                                                                                    on the reports above is detailed below

                        Retail Data Services                                                 Zonal: Will Retire Data Services
867 Received on Cancelled Service Orders (RCSO) Report                   Load Estimation Counts
Siebel Service Order - CR (Daily)                                        Default Profile ESIID
Siebel Service Order - TDSP (Daily)                                      Load Estimation Counts
Siebel Service Order - CR (Full)                                         Load Estimation Volume
Siebel Service Order - TDSP (Full)                                       Load Estimation Volume
Mapping Status Reject Report                                             McCamey Area Flowgate Directional Network Elements
MIMO Exceptions                                                          Zonal Operational Constraints (OC1) - Daily
Missing 867 Report                                                       Data Aggregation Daily Postings
Pending Cancel with Exception Report                                     Generation Extract - Daily
Potential Load Loss                                                      Generation Extract - Initial
Switcher Report                                                          Generation Extract - Trade Date
Texas Market Test Plan Guide                                             Load Extract - Daily
Texas SET Guides                                                         Load Extract - Initial
Siebel Service Order - CR (Weekly)                                       Load Extract - Trade Date
Siebel Service Order - TDSP (Weekly)                                     Missing Consumption Report
MarkeTrak Bulk Submissions Report                                        WS and NWS IDR Proxy Dates
867_03 Error Report (867_03 Activity Report)                             Market Shadow Prices Extract
Historical Consumption Data Request                                      Resettlement Channel 4 Market Totals
997 Report                                                               Resettlement Channel 5 Market Totals
Transaction Flow Diagrams for Customer Registration                      Resettlement Channel 6 Market Totals
Find ESIID                                                               Resettlement Channel 7 Market Totals
TDSP ESIID extract - Initial                                             Resettlement Channel 8 Market Totals
TDSP ESIID extract - Weekly                                              Resettlement Channel 9 Market Totals
Find Transaction                                                         Settlement & Billing Extract - Daily
Texas SET Change Controls                                                Settlement & Billing Extract - Initial
Texas SET Change Control Process Documents                               Settlement & Billing Extract - Trade Date
Texas SET Change Control Standards                                       Settlement Input Data Extract
Texas SET Implementation Guides                                          OOMC and LC Energy Payments
                                                                         Interzonal Congestion Cost
                                                                         TDSP Transmission Loss Factors - Actual
                                                                         TDSP Transmission Loss Factors - Forecasted
                                                                         TDSP Distribution Loss Factors - Actual
                                                                         TDSP Distribution Loss Factors - Forecasted
                                                                         Disclosure of Local Congestion - IEQ
                                                                         Disclosure of Local Congestion - INS
                                                                         Details of Reliability Must Run Costs
                                                                         McCamey Area Geographical Map and One-Line Diagram
                                                                         Participant Invoice
                                                                         Zonal Settlement Statement
                                                                         Settlement Calendar
                                                                         Settlements Charge Matrix
                                                                         True-Up Market Totals




                     Report/Extract/Application                        Posting Location(s)                Report ID
867 Received on Cancelled Service Orders (RCSO) Report                         TML                                     226
Siebel Service Order - CR (Daily)                                              TML                                     109
Siebel Service Order - TDSP (Daily)                                            TML                                     109
Siebel Service Order - CR (Full)                                               TML                                     109
Siebel Service Order - TDSP (Full)                                             TML                                     109
Mapping Status Reject Report                                                   TML                                     217
MIMO Exceptions                                                                TML                                     230
Missing 867 Report                                                                 TML      219
Pending Cancel with Exception Report                                               TML      218
Potential Load Loss                                                                TML      235
Switcher Report                                                                 ERCOT.com
Texas Market Test Plan Guide                                                    ERCOT.com
Texas SET Guides                                                                ERCOT.com
Siebel Service Order - CR (Weekly)                                                 TML      109
Siebel Service Order - TDSP (Weekly)                                               TML      109
MarkeTrak Bulk Submissions Report                                                  TML      237
867_03 Error Report (867_03 Activity Report)                                       FTP
Historical Consumption Data Request
997 Report                                                                         TML      236
Transaction Flow Diagrams for Customer Registration                             ERCOT.com
Find ESIID                                                                         TML
TDSP ESIID extract - Initial                                                    ERCOT.com   203
TDSP ESIID extract - Weekly                                                     ERCOT.com   203
Find Transaction                                                                   TML
Texas SET Change Controls                                                       ERCOT.com
Texas SET Change Control Process Documents                                      ERCOT.com
Texas SET Change Control Standards                                              ERCOT.com
Texas SET Implementation Guides                                                 ERCOT.com
Load Estimation Counts                                                            TML       227
Default Profile ESIID                                                             TML       221
Load Estimation Counts                                                            TML       227
Load Estimation Volume                                                            TML       228
Load Estimation Volume                                                            TML       228
McCamey Area Flowgate Directional Network Elements
Zonal Operational Constraints (OC1) - Daily
Data Aggregation Daily Postings                                                   TML       205
Generation Extract - Daily                                                        TML       102
Generation Extract - Initial                                                      TML       102
Generation Extract - Trade Date                                                   TML       102
Load Extract - Daily                                                              TML       103
Load Extract - Initial                                                            TML       103
Load Extract - Trade Date - Functionality no longer exists in Zonal               TML       103
Missing Consumption Report                                                        TML         9
WS and NWS IDR Proxy Dates                                                        TML        15
Market Shadow Prices Extract                                                      TML       104
Resettlement Channel 4 Market Totals
Resettlement Channel 5 Market Totals
Resettlement Channel 6 Market Totals
Resettlement Channel 7 Market Totals
Resettlement Channel 8 Market Totals
Resettlement Channel 9 Market Totals
Settlement & Billing Extract - Daily                                              TML       101
Settlement & Billing Extract - Initial                                            TML       101
Settlement & Billing Extract - Trade Date - Functionality no longer exists in
Zonal                                                                             TML       101
Settlement Input Data Extract                                                     TML       238
OOMC and LC Energy Payments
Interzonal Congestion Cost
TDSP Transmission Loss Factors - Actual                                                       23
TDSP Transmission Loss Factors - Forecasted                                                   26
TDSP Distribution Loss Factors - Actual                                                     1008
TDSP Distribution Loss Factors - Forecasted                                                   13
Disclosure of Local Congestion - IEQ                                                         234
Disclosure of Local Congestion - INS                                                         233
Details of Reliability Must Run Costs
McCamey Area Geographical Map and One-Line Diagram                              ERCOT.com
Participant Invoice                                                        TML    22
Zonal Settlement Statement                                                 TML
Settlement Calendar                                                        TML
Settlements Charge Matrix
True-Up Market Totals
Provide CMZONE assignments for a trade date                                TML
Provide ESIID account records                                              TML
Provide ESIIDs I own for a trade date                                      TML
Provide ESIIDs where Non-IDR usage data not loaded for a trade date        TML
Provide Non-IDR transaction data for ESIIDs I own                          TML
Provide Non-IDR usage data for a trade date                                TML
Provide Non-IDR usage data for ESIIDs I own                                TML
Provide public data extract (Modified for Nodal)                           TML
Load Profile ID Exceptions
Auxillary Backcasted Load Profiles Extract (No longer provided in Zonal)         1020
Auxillary Backcasted Load Profiles (Historical)
EPS Metering Design Proposal form
Provisional Approval Posting for EPS Metering Facilities
Applications for Temporary Exemption from Compliance to Metering
Protocols and Decision
Guidelines for Temporary Exemption from Compliance to Metering Protocols
Total Reimbursable Cost
Bill Determinant List
Weather Responsiveness Change Report                                               18
Public Reference Data Extract (Modified for Nodal)                               1009
TDSP Approved Distribution Loss Factors - Methodology
Forecasted Load Profiles                                                          12
IDR Requirement Report                                                             8
Load Profile Decision Tree (Included in LPG)
MP Requests for Changes to Load Profiles
New Load Profile Request
Profile Data Evaluation Report
Backcasted Load Profiles (Historical)
Backcasted Profiles Extract                                                        4
Load Profile Validation Test Reports
Weather Zone Assignments to ESI IDs (Included in LPG)
Load Profile Models
Weather-related Changes to Transmission Contingency List
Planned Service Four Coincident Peak Calculations
Recorder ID Extract - Daily                                                TML
Resource ID Extract - Daily                                                TML
Resource ID Extract - Initial                                              TML
Provide ESIIDs where IDR usage data not loaded for a trade date            TML
Provide ESIID extract records for Logical Keys                             TML
Provide ESIIDs where IDR usage data not loaded for a trade date            TML
Provide IDR transaction data for ESIIDs I own                              TML
Provide IDR usage data for particular ESIIDs I own                         TML
Missing Consumption                                                        TML
IDR Protocol Compliance Report                                             TML
Market Data Transparency                                                   TML
n the TML or ERCOT.com until their retirement date. Detailed information on posting locations, Report IDs and Retirement Information
e reports above is detailed below.

Retire Data Services                                                    Zonal/Nodal Data Services: No Change
                                            Provide CMZONE assignments for a trade date
                                            Provide ESIID account records
                                            Provide ESIIDs I own for a trade date
                                            Provide ESIIDs where Non-IDR usage data not loaded for a trade date
                                            Provide Non-IDR transaction data for ESIIDs I own
 al Network Elements                        Provide Non-IDR usage data for a trade date
 1) - Daily                                 Provide Non-IDR usage data for ESIIDs I own
                                            Load Profile ID Exceptions
                                            Auxillary Backcasted Load Profiles (Historical)
                                            EPS Metering Design Proposal form
                                            Provisional Approval Posting for EPS Metering Facilities
                                            EPS Meter Point Exemptions Posting
                                            Guidelines for Considering EPS Metering Facility Exemptions
                                            Total Reimbursable Cost
                                            Bill Determinant List
                                            Weather Responsiveness Change Report
                                            TDSP Approved Distribution Loss Factors - Methodology
otals                                       Forecasted Load Profiles
otals                                       IDR Requirement Report
otals                                       MP Requests for Changes to Load Profiles
otals                                       New Load Profile Request
otals                                       Profile Data Evaluation Report
otals                                       Backcasted Load Profiles (Historical)
                                            Backcasted Profiles Extract
                                            Load Profile Validation Test Reports
e Date                                      Load Profile Models
                                            Weather-related Changes to Transmission Contingency List
                                            Planned Service Four Coincident Peak Calculations
                                            Recorder ID Extract - Daily
- Actual                                    Resource ID Extract - Daily
- Forecasted                                Resource ID Extract - Initial
Actual                                      Provide ESIIDs where IDR usage data not loaded for a trade date
 orecasted                                  Provide ESIID extract records for Logical Keys
EQ                                          Provide ESIIDs where IDR usage data not loaded for a trade date
NS                                          Provide IDR transaction data for ESIIDs I own
 ts                                         Provide IDR usage data for particular ESIIDs I own
 and One-Line Diagram                       Missing Consumption
                                            IDR Protocol Compliance Report
                                            Market Data Transparency




                   Retirement Date
                                      Zonal/Nodal Modify Existing Extracts
                                                                                    Business
                                                                    Project      Requirements
                                Name                               Delivering:      Due Date
Public Reference Data Extract                                     EDW            2/29/2008
Provide all ESIID extract records                                 EDW            5/15/2008
Provide Public Data                                               EDW            5/15/2008
Provide Data Aggregation Records                                  EDW            5/15/2008
ESI ID Service History & Usage - Daily                            EDW            5/15/2008
ESI ID Service History & Usage - Initial                          EDW            5/15/2008
ESI ID Service History & Usage - Supplemental                     EDW            5/15/2008



Note: Details of the following extracts in the COMS - Market Data Transparency Specifications document.
                                                 Nodal Reports
                                                                               Business
                                                                Project      Requirements
                               Name:                            Delivering:    Due Date
ERCOT Summary Dispute Report                                    COMS        9/1/2008
Monthly RUC Make Whole & Clawback Payment Report                COMS        9/1/2008
Monthly Energy Deployed by RMR Units Report                     COMS        9/1/2008
Default Profile ESIID Report                                    COMS        9/1/2008
Load Estimation Counts Report - Public                          COMS        9/1/2008
Load Estimation Volume Report - Public                          COMS        9/1/2008
Load Estimation Counts Report - Certified                       COMS        9/1/2008
Load Estimation Volume Report - Certified                       COMS        9/1/2008
Actual Transmission Loss Factors Report                         COMS        9/1/2008
Forecasted Distribution Loss Factors Report                     COMS        9/1/2008
Forecasted Transmission Loss Factors Report                     COMS        9/1/2008
Actual Distribution Loss Factors Report                         COMS        9/1/2008
Data Aggregation Daily Postings Report                          COMS        9/1/2008
WS and NWS IDR Proxy Dates Report                               COMS        9/1/2008
Annual Distribution Loss Factors Report                         COMS        9/1/2008
Monthly Transmission Loss Factors Methodology Report            COMS        9/1/2008
Capacity Factors By Resource                                    COMS        9/1/2008
UFE Analysis Report                                             COMS        9/1/2008
ERO Fee By LSE Report                                           COMS        9/1/2008
Calculation of Point to Point Option Values in DAM              COMS        9/1/2008
                                                                    Nodal Extracts
                                                                                                  Business
                                                                                 Project        Requirements
               EDS                                 Name:                         Delivering:      Due Date
            TBD            Day Ahead Market Consolidated Operating Day Extract   EDW           2/29/2008
            TBD            Day Ahead Market Market Operating Day Extract         EDW           2/29/2008
            TBD            Real Time Market Consolidated Operating Day Extract   EDW           2/29/2008
            TBD            Real Time Market Market Operating Day Extract         EDW           2/29/2008
            TBD            Settlement Input Data Extract                         EDW           2/29/2008
            TBD            Market Participant Dispute Extract                    EDW           5/15/2008
            TBD            Settlement Calendar Extract                           EDW           5/15/2008
                           Settlements Late Fee Extract                          EDW           5/15/2008
                           CRR Auction Revenue Distribution (CARD) Extract       EDW           5/15/2008

Specifications document.



            EDS
            TBD
            TBD
            TBD
            TBD
            TBD
            TBD
            TBD
            TBD
            TBD
            TBD
            TBD
            TBD
            TBD
            TBD
            TBD
            TBD
            TBD
            TBD
            TBD
            TBD
EDS
TBD
TBD
TBD
TBD
TBD
TBD
TBD
TBD
TBD
STATUS:                             COMPLETE as of 03/03/08

Name:                               Day Ahead Market Consolidated Operating Day Extract                                 Business Notes:
Basic Info                                                                                                              - Extract scheduler:
 Master List Number:                NP 12 -177                                                                            **will need to have an option for XML or CSV
 Business Contact:                  J. Lavas                                                                              **will opt in the MP for DAM CODE and RTM CODE in the same scheduling request
 Short Name:                        DAM CODE                                                                            - Extract run is triggered by settlement approval
 Report or Extract:                 Extract                                                                             - Needs to run about the same time as DAM MODE, so the extracts are published close in time to one another
 Data Source:                       Lodestar                                                                            - All interval and scalar records must be sent with the corresponding header record - this must have a validation check before publishing the
 Generating System:                 ODS                                                                                 extract
 Archival System:                   MIR
 Posting Format(s):                 ZIP                                                                                 STATEMENTSCHEDULE table important notes:
 File Format(s):                    XML, CSV                                                                            *UIDSTATEMENTSCHED joins to INTERVAL and SCALAR tables except for market input
 Display or Delivery System:        MIS Certified                                                                       *UIDMARKET joins to MARKET and defines RTM or DAM
 MP Recipient(s):                   QSE, CRR                                                                            *OPERATINGDATE used for MKTINPUTINTERVAL table to pull 'approved' inputs since there is no UIDSTATEMENTSCHED
 DEWG SLA Level:                    1                                                                                   *STATUS = 'A' should trigger the extract process and use the LSTIME for PIT
 Data based on Approval?:           YES
 Dynamic or Chronological?:         Dynamic                                                                             BILLDETERMINANT table important notes:
 Protocol Reference:                NP 12.3 (c)                                                                         *UIDBILLDETERMINANT joins back to ALL header tables
                                    NP 5.7.4 (3)                                                                        *PUBLICEXTRACT is populated with 'Y'/'N'/'I'; 'I' is not sent in any extract; 'Y' is sent to ALL MPs; 'N' is sent to only the MPs defined in the
MIS Info                                                                                                                header record
 MIS Folder Name:                   Day Ahead Market Consolidated Operating Day Extract                                 *BILLDETERMTYPECODE specifies the table location of the billdeterminant (i.e. MKTINT, CRRINT, CRRSCA, etc)
 MIS Report ID:                     11112
 MIS File Display Name Format(s):   ZIP file:                                                                           - File names are named using the STATEMENTSCHEDULE table:
                                    ext.(MM-DD-YYYY HH24:MI:SS).CODE_DAM_(operating day                                 CODE - extract running
                                    [yyyymmdd]_DunsNumber_RunTypeRunNumber_InternalFileType).zip                        DAM - extract running; STATEMENTSCHEDULE.UIDMARKET = '2' for DAM
                                    Files within Zip File:                                                              Operating day - STATEMENTSCHEDULE.OPERATINGDATE in yyyymmdd format
                                    DunsNumber_Tablename_CODE_RTM(operating day                                         Dunsnumber - MP duns
                                    [yyyymmdd]_RunTypeRunNumber).XML or .CSV                                            RunTypeRunNumber - concatenates STATEMENTSCHEDULE.SETTLEMENTTYPE and RUNNUMBER
                                    ~~All information comes from statement schedule table for the approved record       Internalfiletype - csv or xml - this is NOT included on the name of the internal file .csv or .xml


 MIS Display Lifespan:              30 days
 Files post in order on MIS?:       NO - post trade dates as they are approved and available
 MIS DDL Version(s):                EDW Settlements Draft DDL
                                    XMLXSD
 Landing Page:                      Settlements - Certified
 Portlet:                           Settlements Report/Extract (Certified)
Schedule Info
 Frequency:                         Daily
 Days of Week:                      Mon - Sun
 Generation Time of Day:            Dynamic - Keys off of STATEMENT SCHEDULE when status is changed to 'A' for
                                    settlement type DAM; verify replication heartbeat is greater than the PIT for the
                                    approval in LODSTAR schema; post no later than 48 hours of the statement posting
                                    deadline <this is not protocol, it is business requirement>

 PITS Range Logic:                  PIT = STATEMENTSCHEDULE.LSTIME when STATUS = 'A'
 Trade Date Range Logic:            Single Trade Date per extract, 00:00:00 - 23:59:59
 Available on Extract Scheduler?:   YES
Project Info                        EDW
Business Requirements Due Date      2/29/2008

EDS Delivery Date                   6/15/2008
Table List: See Master List Tab for Detailed Column Information   Coding information
SCHEMA                               TABLENAME
                                                                  Using the defined PIT on all tables; join CRROUTPUTHEADER to CRROUTPUTINTERVAL and CRROUTPUTSCALAR using
                                                                  UIDCRROUTPUTHEADER; use QSECODE to join to QSE table for the DUNSNUMBER of the QSE recipient; use
NODAL                                CRROUTPUTHEADER              CRRACCTHLDRCODE to join to CRRACCTHOLDER table for the DUNSNUMBER of the CRRACCTHLDR recipient;

                                                                  Using the defined PIT on all tables; join STATEMENTSCHEDULE to CRROUTPUTINTERVAL using UIDSTATEMENTSCHED for the
                                                                  STATUS = 'A' record and UIDMARKET = '2' for 'DAM'; join from CRROUTPUTINTERVAL to CRROUTPUTHEADER using
                                                                  UIDCRROUTPUTHEADER and then join CRROUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the
NODAL                                CRROUTPUTINTERVAL            CRROUTPUT records where the BILLDETERMINANT.PUBLICEXTRACT = 'N'; pull the interval record, then the header record

                                                                  Using the defined PIT on all tables; join STATEMENTSCHEDULE to CRROUTPUTSCALAR using UIDSTATEMENTSCHED for the
                                                                  STATUS = 'A' record and UIDMARKET = '2' for 'DAM'; join from CRROUTPUTSCALAR to CRROUTPUTHEADER using
                                                                  UIDCRROUTPUTHEADER and then join CRROUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the
NODAL                                CRROUTPUTSCALAR              CRROUTPUT records where the BILLDETERMINANT.PUBLICEXTRACT = 'N'; pull the scalar record, then the header record
                                                                  Using the defined PIT on all tables; join DAMOUTPUTHEADER to DAMOUTPUTINTERVAL using UIDDAMOUTPUTHEADER; use QSECODE to
NODAL                                DAMOUTPUTHEADER              join to QSE table for the DUNSNUMBER of the QSE recipient;
                                                                  Using the defined PIT on all tables; join STATEMENTSCHEDULE to DAMOUTPUTINTERVAL using UIDSTATEMENTSCHED for the STATUS = 'A'
                                                                  record and UIDMARKET = '2' for 'DAM' and where MKTINPUTHEADER.UIDMARKET = '2'; join from DAMOUTPUTINTERVAL to
                                                                  DAMOUTPUTHEADER using UIDDAMOUTPUTHEADER and then join DAMOUTPUTHEADER to BILLDETERMINANT using
                                                                  UIDBILLDETERMINANT and pull the DAMOUTPUT records where the BILLDETERMINANT.PUBLICEXTRACT = 'N'; pull the interval record, then
NODAL                                DAMOUTPUTINTERVAL            the header record

                                                                  Using the defined PIT on all tables; join MKTINPUTHEADER to MKTINPUTINTERVAL using UIDMKTINPUTHEADER; use QSECODE to join to QSE
                                                                  table for the DUNSNUMBER of the QSE recipient; use CRRACCTHLDRCODE to join to CRRACCTHOLDER table for the DUNSNUMBER of the
                                                                  CRRACCTHOLDER recipient; join MKTINPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the MKTINPUT records
NODAL                                MKTINPUTHEADER               where BILLDETERMINANT.PUBLICEXTRACT = 'N' and MKTINPUTHEADER.UIDMARKET = '2' for 'DAM'
                                                                  Using the defined PIT on all tables; join MKTINPUTINTERVAL to MKTINPUTHEADER using UIDMKTINPUTHEADER and pull records for
                                                                  STARTTIME = STATEMENTSCHEDULE.OPERATINGDATE where STATUS = 'A' and UIDMARKET = '2' and BILLDETERMTYPECODE = 'MKTINT'; pull
NODAL                                MKTINPUTINTERVAL             the interval record, then the header record
                                                                  Using the defined PIT on all tables; join MKTINPUTSCALAR to MKTINPUTHEADER using UIDMKTINPUTHEADER and pull records for
                                                                  STARTTIME = STATEMENTSCHEDULE.OPERATINGDATE where STATUS = 'A' and UIDMARKET = '2' and BILLDETERMTYPECODE = 'MKTSCA'; pull
NODAL                                MKTINPUTSCALAR               the scalar record, then the header record
NODAL                                MKTINPUTSTATUS               Created by parsing the interval table;
                                                                  Using the defined PIT on all tables; join PREPROCESSHEADER to PREPROCESSINTERVAL and PREPROCESSSCALAR using
NODAL                                PREPROCESSHEADER             UIDPREPROCHEADER; use QSECODE to join to QSE table for the DUNSNUMBER of the QSE recipient

                                                                  Using the defined PIT on all tables; join STATEMENTSCHEDULE to PREPROCESSINTERVAL using UIDSTATEMENTSCHED for the
                                                                  STATUS = 'A' record and UIDMARKET = '2' for 'DAM'; join from PREPROCESSINTERVAL to PREPROCESSHEADER using
                                                                  UIDPREPROCHEADER and then join PREPROCESSHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the
NODAL                                PREPROCESSINTERVAL           PREPROCESS records where the BILLDETERMINANT.PUBLICEXTRACT = 'N'; pull the interval record, then the header record
NODAL                                PREPROCESSSTATUS             Created by parsing the interval table;

                                                                  Using the defined PIT on all tables; STATEMENTSCHEDULE.OPERATINGDATE = TRUNC(TELEMETERRESSTATUS.TRANSITIONTIME); use
NODAL                                TELEMETERRESSTATUS           QSECODE to join to QSE table for the DUNSNUMBER Of the QSE recipient;
STATUS:                             COMPLETE as of 03/03/08

Name:                               Day Ahead Market Market Operating Day Extract                               Business Notes:
Basic Info                                                                                                      - This is not a scheduled extract, so extract scheduler will not have an entry for it.
 Master List Number:                COMS - 800                                                                   - Generate same time as DAM CODE
 Short Name:                        DAM MODE                                                                    - DAM CODE/MODE need to post as close together as possible because they are used together
 Business Contact:                  J. Lavas                                                                    - No MP Specific data is sent in this extract
 Report or Extract:                 Extract                                                                     - Both a CSV and XML data files need to be posted for each run. There will be 2 zip files posted for each run.
 Data Source:                       Lodestar                                                                    - All interval and scalar records must be sent with the corresponding header record - this must have a validation check before
                                    ODS                                                                         publishing the extract
 Generating System:
 Archival System:                   MIR
                                                                                                                STATEMENTSCHEDULE table important notes:
 Posting Format(s):                 ZIP
                                                                                                                *UIDSTATEMENTSCHED joins to INTERVAL and SCALAR tables except for market input
 File Format(s):                    XML, CSV
                                                                                                                *UIDMARKET joins to MARKET and defines RTM or DAM
 Display or Delivery System:        MIS Secure
                                                                                                                *OPERATINGDATE used for MKTINPUTINTERVAL table to pull 'approved' inputs since there is no UIDSTATEMENTSCHED
 MP Recipient(s):                   QSE, CRRAH, LSE, PGC                                                        *STATUS = 'A' should trigger the extract process and use the LSTIME for PIT
 DEWG SLA Level:                    1
 Data based on Approval?:           YES                                                                         BILLDETERMINANT table important notes:
 Dynamic or Chronological?:         Dynamic                                                                     *UIDBILLDETERMINANT joins back to ALL header tables
 Protocol Reference:                NP 12.3 (c )                                                                *PUBLICEXTRACT is populated with 'Y'/'N'/'I'; 'I' is not sent in any extract; 'Y' is sent to ALL MPs; 'N' is sent to only the MPs defined
                                    NP 5.7.4 (3)                                                                in the header record
MIS Info                                                                                                        *BILLDETERMTYPECODE specifies the table location of the billdeterminant (i.e. MKTINT, CRRINT, CRRSCA, etc)
 MIS Folder Name:                   Day Ahead Market Market Operating Day Extract
  MIS Report ID:                    11111
 MIS File Display Name Format(s):   CSV ZIP file:                                                               - File names are named using the STATEMENTSCHEDULE table:
                                    ext.(MM-DD-YYYY HH24:MI:SS).MODE_DAM_(operating day                         CODE - extract running
                                    yyyymmdd]_DunsNumber_RunTypeRunNumber_csv).zip                              DAM - extract running; STATEMENTSCHEDULE.UIDMARKET = '2' for DAM
                                                                                                                Operating day - STATEMENTSCHEDULE.OPERATINGDATE in yyyymmdd format
                                    Files within Zip File:
                                                                                                                Dunsnumber - MP duns
                                    DunsNumber_Tablename_MODE_DAM(operating day
                                                                                                                RunTypeRunNumber - concatenates STATEMENTSCHEDULE.SETTLEMENTTYPE and RUNNUMBER
                                    [yyyymmdd]_RunTypeRunNumber).XML or .CSV                                    Internalfiletype - csv or xml - this is NOT included on the name of the internal file .csv or .xml
                                    XML ZIP file:
                                    ext.(MM-DD-YYYY HH24:MI:SS).MODE_DAM_(operating day
                                    yyyymmdd]_DunsNumber_RunTypeRunNumber_xml).zip
                                    Files within Zip File:
                                    Tablename_MODE_RTM(operating day
                                    [yyyymmdd]_DunsNumber_RunTypeRunNumber).XML or .CSV
                                    ~~All information comes from statement schedule table for the
                                    approved record


 MIS Display Lifespan:              30 days
 Files post in order on MIS?:       NO - post trade dates as they are approved and available
 MIS DDL Version(s):                EDW Settlements Draft DDL
                                    XMLXSD
 Landing Page:                      Settlements - Secure
 Portlet:                           Settlements Report/Extract (Secure)
Schedule Info
 Frequency:                         Daily
 Days of Week:                      Mon - Sun
 Generation Time of Day:            Dynamic - Keys off of STATEMENT SCHEDULE when status is changed to 'A'
                                    for settlement type DAM; verify replication heartbeat is greater than the
 PITS Range Logic:                  PIT = STATEMENTSCHEDULE.LSTIME when STATUS = 'A'
 Trade Date Range Logic:            Single Trade Date per extract, 00:00:00 - 23:59:59
 Available on Extract Scheduler?:   NO
Project Info                        EDW
Business Requirements Due Date      2/29/2008
EDS Delivery Date                   6/15/2008
                                                                  Coding information
Table List: See Master List Tab for Detailed Column Information
                                                                  Using the defined PIT on all tables; join CRROUTPUTHEADER to CRROUTPUTINTERVAL and CRROUTPUTSCALAR using
SCHEMA                                    TABLENAME               UIDCRROUTPUTHEADER;
                                                                  Using the defined PIT on all tables; join STATEMENTSCHEDULE to CRROUTPUTINTERVAL using UIDSTATEMENTSCHED
                                                                  for the STATUS = 'A' record and UIDMARKET = '2' for 'DAM'; join from CRROUTPUTINTERVAL to CRROUTPUTHEADER
                                                                  using UIDCRROUTPUTHEADER and then join CRROUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT
                                                                  and pull the CRROUTPUT records where the BILLDETERMINANT.PUBLICEXTRACT = 'Y'; pull the interval record, then the
NODAL                                     CRROUTPUTHEADER         header record
                                                                  Using the defined PIT on all tables; join STATEMENTSCHEDULE to CRROUTPUTSCALAR using UIDSTATEMENTSCHED for
                                                                  the STATUS = 'A' record and UIDMARKET = '2' for 'DAM'; join from CRROUTPUTSCALAR to CRROUTPUTHEADER using
                                                                  UIDCRROUTPUTHEADER and then join CRROUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and
                                                                  pull the CRROUTPUT records where the BILLDETERMINANT.PUBLICEXTRACT = 'Y'; pull the scalar record, then the
NODAL                                     CRROUTPUTINTERVAL       header record

NODAL                                     CRROUTPUTSCALAR         Using the defined PIT on all tables; join DAMOUTPUTHEADER to DAMOUTPUTINTERVAL using UIDDAMOUTPUTHEADER;

                                                                  Using the defined PIT on all tables; join STATEMENTSCHEDULE to DAMOUTPUTINTERVAL using UIDSTATEMENTSCHED for the
                                                                  STATUS = 'A' record and UIDMARKET = '2' for 'DAM' and where MKTINPUTHEADER.UIDMARKET = '2'; join from
                                                                  DAMOUTPUTINTERVAL to DAMOUTPUTHEADER using UIDDAMOUTPUTHEADER and then join DAMOUTPUTHEADER to
                                                                  BILLDETERMINANT using UIDBILLDETERMINANT and pull the DAMOUTPUT records where the BILLDETERMINANT.PUBLICEXTRACT
NODAL                                     DAMOUTPUTHEADER         = 'Y'; pull the interval record, then the header record
                                                                  Using the defined PIT on all tables; join MKTINPUTHEADER to MKTINPUTINTERVAL using UIDMKTINPUTHEADER; join
                                                                  MKTINPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the MKTINPUT records where
NODAL                                     DAMOUTPUTINTERVAL       BILLDETERMINANT.PUBLICEXTRACT = 'Y' and MKTINPUTHEADER.UIDMARKET = '2' for 'DAM'
                                                                  Using the defined PIT on all tables; join MKTINPUTINTERVAL to MKTINPUTHEADER using UIDMKTINPUTHEADER and pull records
                                                                  for STARTTIME = STATEMENTSCHEDULE.OPERATINGDATE where STATUS = 'A' and UIDMARKET = '2' and BILLDETERMTYPECODE =
NODAL                                     MKTINPUTHEADER          'MKTINT'; pull the interval record, then the header record
                                                                  Using the defined PIT on all tables; join MKTINPUTSCALAR to MKTINPUTHEADER using UIDMKTINPUTHEADER and pull records for
                                                                  STARTTIME = STATEMENTSCHEDULE.OPERATINGDATE where STATUS = 'A' and UIDMARKET = '2' and BILLDETERMTYPECODE =
NODAL                                     MKTINPUTINTERVAL        'MKTSCA'; pull the scalar record, then the header record
NODAL                                     MKTINPUTSCALAR          Created by parsing the interval table;
                                                                  Using the defined PIT on all tables; join PREPROCESSHEADER to PREPROCESSINTERVAL and PREPROCESSSCALAR using
NODAL                                     MKTINPUTSTATUS          UIDPREPROCHEADER;
                                                                  Using the defined PIT on all tables; join STATEMENTSCHEDULE to PREPROCESSINTERVAL using UIDSTATEMENTSCHED
                                                                  for the STATUS = 'A' record and UIDMARKET = '2' for 'DAM'; join from PREPROCESSINTERVAL to PREPROCESSHEADER
                                                                  using UIDPREPROCHEADER and then join PREPROCESSHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and
                                                                  pull the PREPROCESS records where the BILLDETERMINANT.PUBLICEXTRACT = 'Y'; pull the interval record, then the
NODAL                                     PREPROCESSHEADER        header record
NODAL                                     PREPROCESSINTERVAL      Created by parsing the interval table;
NODAL                                     PREPROCESSSTATUS
STATUS:                             COMPLETE as of 03/03/08

Name:                               Real Time Market Consolidated Operating Day Extract                                 Business Notes:
Basic Info                                                                                                              - Extract scheduler:
 Master List Number:                NP 12 -747                                                                            **will need to have an option for XML or CSV
 Short Name:                        RTM CODE                                                                              **will opt in the MP for DAM CODE and DAM MODE in the same scheduling request
 Business Contact:                  J. Lavas                                                                            - Extract run is triggered by settlement approval
 Report or Extract:                 Extract                                                                             - Needs to run about the same time as DAM MODE, so the extracts are published close in time to one another
 Data Source:                       Lodestar                                                                            - All interval and scalar records must be sent with the corresponding header record - this must have a validation
 Generating System:                 ODS                                                                                 check before publishing the extract
 Archival System:                   MIR
 Posting Format(s):                 ZIP                                                                                 STATEMENTSCHEDULE table important notes:
 File Format(s):                    CSV , XML                                                                           *UIDSTATEMENTSCHED joins to INTERVAL and SCALAR tables except for market input
 Display or Delivery System:        MIS Certified                                                                       *UIDMARKET joins to MARKET and defines RTM or DAM
 MP Recipient(s):                   LSE, PGC, QSE, CRR                                                                  *OPERATINGDATE used for MKTINPUTINTERVAL table to pull 'approved' inputs since there is no
 DEWG SLA Level:                    1                                                                                   UIDSTATEMENTSCHED
                                                                                                                        *STATUS = 'A' should trigger the extract process and use the LSTIME for PIT
 Data based on Approval?:           YES
 Dynamic or Chronological?:         Dyanmic
                                                                                                                        BILLDETERMINANT table important notes:
 Protocol Reference:                NP 12.3 - no delivery timing defined
                                                                                                                        *UIDBILLDETERMINANT joins back to ALL header tables
                                    P 11.5.2.2 - Post within forty-eight (48) hours of finalizing the data for
                                                                                                                        *PUBLICEXTRACT is populated with 'Y'/'N'/'I'; 'I' is not sent in any extract; 'Y' is sent to
                                    Settlement Statements                                                               ALL MPs; 'N' is sent to only the MPs defined in the header record
                                    P 11.5.1.1 - Post within forty-eight (48) hours of finalizing the data for          *BILLDETERMTYPECODE specifies the table location of the billdeterminant (i.e. MKTINT,
                                    Settlement Statements                                                               CRRINT, CRRSCA, etc)
                                    P 11.6.2.4
MIS Info                                                                                                                - File names are named using the STATEMENTSCHEDULE table:
 MIS Folder Name:                   Real Time Market Consolidated Operating Day Extract                                 CODE - extract running
 MIS Report ID:                     11113
                                                                                                                        RTM - extract running; STATEMENTSCHEDULE.UIDMARKET = '1' for RTM
 MIS File Display Name Format(s):   Zip File:                                                                           Operating day - STATEMENTSCHEDULE.OPERATINGDATE in yyyymmdd format
                                    ext.(MM-DD-YYYY HH24:MI:SS).CODE_RTM_(operating day                                 Dunsnumber - MP duns
                                    yyyymmdd]_DunsNumber_RunTypeRunNumber_InternalFileType).zip                         RunTypeRunNumber - concatenates STATEMENTSCHEDULE.SETTLEMENTTYPE and
                                    Files within Zip File:                                                              RUNNUMBER
                                    DunsNumber_Tablename_CODE_RTM(operating day                                         Internalfiletype - csv or xml - this is NOT included on the name of the internal file .csv or .xml
                                    [yyyymmdd]_RunTypeRunNumber).XML or .CSV
                                    ~~All information comes from statement schedule table for the approved
                                    record
 MIS Display Lifespan:              30 days
 Files post in order on MIS?:       NO
 MIS DDL Version(s):                EDW Settlements Draft DDL
                                    XMLXSD
 Landing Page:                      Settlements - Certified
 Portlet:                           Settlements Report/Extract (Certified)
Schedule Info
 Frequency:                         Daily
 Days of Week:                      Mon - Sun
 Generation Time of Day:            Dynamic - Keys off of STATEMENT SCHEDULE when status is changed to 'A' for
                                    settlement type DAM; verify replication heartbeat is greater than the PIT for the
                                    approval in LODSTAR schema; post no later than 48 hours of the statement posting
                                    deadline <this is not protocol, it is business requirement>

 PITS Range Logic:                  PIT = STATEMENTSCHEDULE.LSTIME when STATUS = 'A'
 Operating Day Range Logic:         Single Trade Date per extract, 00:00:00 - 23:59:59
 Available on Extract Scheduler?:   YES
Project Info                        EDW
Business Requirements Due Date      2/29/2008
EDS Delivery Date                   6/15/2008
                                                                  Coding information
Table List: See Master List Tab for Detailed Column Information
                                                                  Using the defined PIT on all tables; join AGGOUTPUTHEADER to AGGOUTPUTINTERVAL and
                                                                  AGGOUTPUTSCALAR using UIDAGGOUTPUTHEADER; use QSECODE to join to QSE table for the
                                                                  DUNSNUMBER of the QSE recipient; use PGCCODE to join to PGC table for the DUNSNUMBER of the
SCHEMA                                     TABLENAME              PGC recipient;
                                                                  Using the defined PIT on all tables; join STATEMENTSCHEDULE to AGGOUTPUTINTERVAL using
                                                                  UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                                                                  AGGOUTPUTINTERVAL to AGGOUTPUTHEADER using UIDAGGOUTPUTHEADER and then join
                                                                  AGGOUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the AGGOUTPUT
                                                                  records where the BILLDETERMINANT.PUBLICEXTRACT = 'N'; pull the interval record, then the
NODAL                                      AGGOUTPUTHEADER        header record
                                                                  Using the defined PIT on all tables; join STATEMENTSCHEDULE to AGGOUTPUTSCALAR using
                                                                  UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                                                                  AGGOUTPUTSCALAR to AGGOUTPUTHEADER using UIDAGGOUTPUTHEADER and then join
                                                                  AGGOUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the AGGOUTPUT
                                                                  records where the BILLDETERMINANT.PUBLICEXTRACT = 'N'; pull the scalar record, then the header
NODAL                                      AGGOUTPUTINTERVAL      record
                                                                  Using the defined PIT on all tables; join CRROUTPUTHEADER to CRROUTPUTINTERVAL and
                                                                  CRROUTPUTSCALAR using UIDCRROUTPUTHEADER; use QSECODE to join to QSE table for the
                                                                  DUNSNUMBER of the QSE recipient; use CRRACCTHLDRCODE to join to CRRACCTHOLDER table for
NODAL                                      AGGOUTPUTSCALAR        the DUNSNUMBER of the CRRACCTHLDR recipient;
                                                                  Using the defined PIT on all tables; join STATEMENTSCHEDULE to CRROUTPUTINTERVAL using
                                                                  UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                                                                  CRROUTPUTINTERVAL to CRROUTPUTHEADER using UIDCRROUTPUTHEADER and then join
                                                                  CRROUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the CRROUTPUT
                                                                  records where the BILLDETERMINANT.PUBLICEXTRACT = 'N'; pull the interval record, then the
NODAL                                      CRROUTPUTHEADER        header record
                                                                  Using the defined PIT on all tables; join STATEMENTSCHEDULE to CRROUTPUTSCALAR using
                                                                  UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                                                                  CRROUTPUTSCALAR to CRROUTPUTHEADER using UIDCRROUTPUTHEADER and then join
                                                                  CRROUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the CRROUTPUT
                                                                  records where the BILLDETERMINANT.PUBLICEXTRACT = 'N'; pull the scalar record, then the header
NODAL                                      CRROUTPUTINTERVAL      record

                                                                  Using the defined PIT on all tables; join DAIOUTPUTHEADER to DAIOUTPUTINTERVAL and
                                                                  DAIOUTPUTSCALAR using UIDDAIOUTPUTHEADER; use QSECODE to join to QSE table for the
                                                                  DUNSNUMBER of the QSE recipient; use REPCODE to join to REP table for the DUNSNUMBER of the
NODAL                                      CRROUTPUTSCALAR        REP recipient; use PGCCODE to join to PGC table for the DUNSNUMBER of the PGC recipient
                                                                  Using the defined PIT on all tables; join STATEMENTSCHEDULE to DAIOUTPUTINTERVAL using
                                                                  UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                                                                  DAIOUTPUTINTERVAL to DAIOUTPUTHEADER using UIDDAIOUTPUTHEADER and then join
                                                                  DAIOUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the DAIOUTPUT
                                                                  records where the BILLDETERMINANT.PUBLICEXTRACT = 'N'; pull the interval record, then the
NODAL                                      DAIOUTPUTHEADER        header record
                             Using the defined PIT on all tables; join STATEMENTSCHEDULE to DAIOUTPUTSCALAR using
                             UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                             DAIOUTPUTSCALAR to DAIOUTPUTHEADER using UIDDAIOUTPUTHEADER and then join
                             DAIOUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the DAIOUTPUT
                             records where the BILLDETERMINANT.PUBLICEXTRACT = 'N'; pull the scalar record, then the header
NODAL   DAIOUTPUTINTERVAL    record
                             Using the defined PIT on all tables; join LLSOUTPUTHEADER to LLSOUTPUTINTERVAL and
                             LLSOUTPUTSCALAR using UIDLLSOUTPUTHEADER; use QSECODE to join to QSE table for the
                             DUNSNUMBER of the QSE recipient; use REPCODE to join to REP table for the DUNSNUMBER of the
NODAL   DAIOUTPUTSCALAR      REP recipient
                             Using the defined PIT on all tables; join STATEMENTSCHEDULE to LLSOUTPUTINTERVAL using
                             UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                             LLSOUTPUTINTERVAL to LLSOUTPUTHEADER using UIDLLSOUTPUTHEADER and then join
                             LLSOUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the DAIOUTPUT
                             records where the BILLDETERMINANT.PUBLICEXTRACT = 'N'; pull the interval record, then the
NODAL   LLSOUTPUTHEADER      header record
                             Using the defined PIT on all tables; join MKTINPUTHEADER to MKTINPUTINTERVAL using
                             UIDMKTINPUTHEADER; use QSECODE to join to QSE table for the DUNSNUMBER of the QSE
                             recipient; use CRRACCTHLDRCODE to join to CRRACCTHOLDER table for the DUNSNUMBER of the
                             CRRACCTHOLDER recipient; join MKTINPUTHEADER to BILLDETERMINANT using
                             UIDBILLDETERMINANT and pull the MKTINPUT records where BILLDETERMINANT.PUBLICEXTRACT =
NODAL   LLSOUTPUTINTERVAL    'N' and MKTINPUTHEADER.UIDMARKET = '1' for 'RTM'
                             Using the defined PIT on all tables; join MKTINPUTINTERVAL to MKTINPUTHEADER using
                             UIDMKTINPUTHEADER and pull records for STARTTIME = STATEMENTSCHEDULE.OPERATINGDATE
                             where STATUS = 'A' and UIDMARKET = '1' and BILLDETERMTYPECODE = 'MKTINT'; pull the interval
NODAL   MKTINPUTHEADER       record, then the header record
                             Using the defined PIT on all tables; join MKTINPUTSCALAR to MKTINPUTHEADER using
                             UIDMKTINPUTHEADER and pull records for STARTTIME = STATEMENTSCHEDULE.OPERATINGDATE
                             where STATUS = 'A' and UIDMARKET = '1' and BILLDETERMTYPECODE = 'MKTSCA'; pull the scalar
NODAL   MKTINPUTINTERVAL     record, then the header record
NODAL   MKTINPUTSCALAR       Created by parsing the interval table;
                             Using the defined PIT on all tables; join PREPROCESSHEADER to PREPROCESSINTERVAL and
                             PREPROCESSSCALAR using UIDPREPROCHEADER; use QSECODE to join to QSE table for the
NODAL   MKTINPUTSTATUS       DUNSNUMBER of the QSE recipient
                             Using the defined PIT on all tables; join STATEMENTSCHEDULE to PREPROCESSINTERVAL using
                             UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                             PREPROCESSINTERVAL to PREPROCESSHEADER using UIDPREPROCHEADER and then join
                             PREPROCESSHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the PREPROCESS
                             records where the BILLDETERMINANT.PUBLICEXTRACT = 'N'; pull the interval record, then the
NODAL   PREPROCESSHEADER     header record
NODAL   PREPROCESSINTERVAL   Created by parsing the interval table;
                             Using the defined PIT on all tables; join RTMOUTPUTHEADER to RTMOUTPUTINTERVAL and
                             RTMOUTPUTSCALAR using UIDRTMOUTPUTHEADER; use QSECODE to join to QSE table for the
NODAL   PREPROCESSSTATUS     DUNSNUMBER of the QSE recipient
                             Using the defined PIT on all tables; join STATEMENTSCHEDULE to RTMOUTPUTINTERVAL using
                             UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                             RTMOUTPUTINTERVAL to RTMOUTPUTHEADER using UIDRTMOUTPUTHEADER and then join
                             RTMOUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the RTMOUTPUT
                             records where the BILLDETERMINANT.PUBLICEXTRACT = 'N'; pull the interval record, then the
NODAL   RTMOUTPUTHEADER      header record
                             Using the defined PIT on all tables; join STATEMENTSCHEDULE to RTMOUTPUTSCALAR using
                             UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                             RTMOUTPUTSCALAR to RTMOUTPUTHEADER using UIDRTMOUTPUTHEADER and then join
                             RTMOUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the RTMOUTPUT
                             records where the BILLDETERMINANT.PUBLICEXTRACT = 'N'; pull the scalar record, then the header
NODAL   RTMOUTPUTINTERVAL    record
NODAL   RTMOUTPUTSCALAR      Created by parsing the interval table;
                             Using the defined PIT on all tables; join RUCOUTPUTHEADER to RUCOUTPUTINTERVAL and
                             RUCOUTPUTSCALAR using UIDRUCOUTPUTHEADER; use QSECODE to join to QSE table for the
NODAL   RTMOUTPUTSTATUS      DUNSNUMBER of the QSE recipient
                             Using the defined PIT on all tables; join STATEMENTSCHEDULE to RUCOUTPUTINTERVAL using
                             UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                             RUCOUTPUTINTERVAL to RUCOUTPUTHEADER using UIDRUCOUTPUTHEADER and then join
                             RUCOUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the RUCOUTPUT
                             records where the BILLDETERMINANT.PUBLICEXTRACT = 'N'; pull the interval record, then the
NODAL   RUCOUTPUTHEADER      header record
                             Using the defined PIT on all tables; join STATEMENTSCHEDULE to RUCOUTPUTSCALAR using
                             UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                             RUCOUTPUTSCALAR to RUCOUTPUTHEADER using UIDRUCOUTPUTHEADER and then join
                             RUCOUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the RUCOUTPUT
                             records where the BILLDETERMINANT.PUBLICEXTRACT = 'N'; pull the scalar record, then the header
NODAL   RUCOUTPUTINTERVAL    record
NODAL   RUCOUTPUTSCALAR      Created by parsing the interval table;
                             Using the defined PIT on all tables; STATEMENTSCHEDULE.OPERATINGDATE =
                             TRUNC(TELEMETERRESSTATUS.TRANSITIONTIME); use QSECODE to join to QSE table for the DUNSNUMBER Of
NODAL   RUCOUTPUTSTATUS      the QSE recipient;
NODAL   TELEMETERRESSTATUS
STATUS:                             COMPLETE as of 03/03/08

Name:                               Real Time Market Market Operating Day Extract                                   Business Notes:
Basic Info                                                                                                          - This is not a scheduled extract, so extract scheduler will not have an entry for it.
 Master List Number:                NP 12 - 749                                                                      - Generate same time as RTM CODE
 Short Name:                        RTM MODE                                                                        - Two extracts need to post as close together as possible because they are used together
 Business Contact:                  J. Lavas                                                                        - No MP Specific data is sent in this extract
 Report or Extract:                 Extract                                                                         - Both a CSV and XML data files need to be posted for each run. There will be 2 zip files posted for each
 Data Source:                       Lodestar                                                                        run.
 Generating System:                 ODS                                                                             - All interval and scalar records must be sent with the corresponding header record - this must have a
 Archival System:                   MIR                                                                             validation check before publishing the extract
 Posting Format(s):                 ZIP
 File Format(s):                    CSV, XML
                                                                                                                    STATEMENTSCHEDULE table important notes:
 Display or Delivery System:        MIS Secure
                                                                                                                    *UIDSTATEMENTSCHED joins to INTERVAL and SCALAR tables except for market input
 MP Recipient(s):                   QSE, LSE, CRRAH, PGC, TDSP
                                                                                                                    *UIDMARKET joins to MARKET and defines RTM or DAM
 DEWG SLA Level:                    1
                                                                                                                    *OPERATINGDATE used for MKTINPUTINTERVAL table to pull 'approved' inputs since there is no
 Data based on Approval?:           YES
 Dynamic or Chronological?:         Dyanmic                                                                         UIDSTATEMENTSCHED
 Protocol Reference:                NP 12.3 (c)- no delivery timing defined                                         *STATUS = 'A' should trigger the extract process and use the LSTIME for PIT
                                    P 11.5.2.2 - Post within forty-eight (48) hours of finalizing the data
                                    for Settlement Statements                                                       BILLDETERMINANT table important notes:
                                    P 11.5.1.1 - Post within forty-eight (48) hours of finalizing the data          *UIDBILLDETERMINANT joins back to ALL header tables
                                    for Settlement Statements                                                       *PUBLICEXTRACT is populated with 'Y'/'N'/'I'; 'I' is not sent in any extract; 'Y' is sent to ALL MPs; 'N' is
                                    P 11.6.2.4                                                                      sent to only the MPs defined in the header record
MIS Info                                                                                                            *BILLDETERMTYPECODE specifies the table location of the billdeterminant
 MIS Folder Name:                   Real Time Market Market Operating Day Extract                                   (i.e. MKTINT, CRRINT, CRRSCA, etc)
 MIS Report ID:                     11114
 MIS File Display Name Format(s):   CSV ZIP file:
                                    ext.(MM-DD-YYYY HH24:MI:SS).MODE_RTM_(operating day                             - File names are named using the STATEMENTSCHEDULE table:
                                    [yyyymmdd]_DunsNumber_RunTypeRunNumber_csv).zip                                 CODE - extract running
                                    Files within Zip File:                                                          RTM - extract running; STATEMENTSCHEDULE.UIDMARKET = '1' for RTM
                                    DunsNumber_Tablename_MODE_RTM(operating day                                     Operating day - STATEMENTSCHEDULE.OPERATINGDATE in yyyymmdd format
                                    [yyyymmdd]_RunTypeRunNumber).csv                                                Dunsnumber - MP duns
                                    XML ZIP file:                                                                   RunTypeRunNumber - concatenates STATEMENTSCHEDULE.SETTLEMENTTYPE
                                    ext.(MM-DD-YYYY HH24:MI:SS).MODE_RTM(operating day                              and RUNNUMBER
                                    yyyymmdd]_DunsNumber_RunTypeRunNumber).zip                                      Internalfiletype - csv or xml - this is NOT included on the name of the internal file .csv or .xml
                                    Files within Zip File:
                                    Tablename_MODE_RTM(operating day
                                    [yyyymmdd]_DunsNumber_RunTypeRunNumber).xml
                                    ~~All information comes from statement schedule table for the
 MIS Display Lifespan:              approved record
                                    30 days
 Files post in order on MIS?:       NO
 MIS DDL Version(s):                EDW Settlements Draft DDL
                                    XMLXSD
  Landing Page:                     Settlements - Secure
  Portlet:                          Settlements Report/Extract (Secure)
Schedule Info
  Frequency:                        Daily
  Days of Week:                     Mon-Sun
  Generation Time of Day:           Dynamic - Keys off of STATEMENT SCHEDULE when status is changed to 'A' for
                                    settlement type DAM; verify replication heartbeat is greater than the PIT for
                                    the approval in LODSTAR schema; post no later than 48 hours of the
                                    statement posting deadline <this is not protocol, it is business requirement>

 PITS Range Logic:                  PIT = STATEMENTSCHEDULE.LSTIME when STATUS = 'A'
 Trade Date Range Logic:            Single Trade Date per extract, 00:00:00 - 23:59:59
 Available on Extract Scheduler?:   NO
Project Info                        EDW
Business Requirements Due Date      2/29/2008
EDS Delivery Date                   6/15/2008
                                                                  Coding information
Table List: See Master List Tab for Detailed Column Information
                                                                  Using the defined PIT on all tables; join AGGOUTPUTHEADER to AGGOUTPUTINTERVAL and
SCHEMA                                     TABLENAME              AGGOUTPUTSCALAR using UIDAGGOUTPUTHEADER;
                                                                  Using the defined PIT on all tables; join STATEMENTSCHEDULE to AGGOUTPUTINTERVAL using
                                                                  UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                                                                  AGGOUTPUTINTERVAL to AGGOUTPUTHEADER using UIDAGGOUTPUTHEADER and then join
                                                                  AGGOUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the AGGOUTPUT
                                                                  records where the BILLDETERMINANT.PUBLICEXTRACT = 'Y'; pull the interval record, then the header
NODAL                                      AGGOUTPUTHEADER        record
                                                                  Using the defined PIT on all tables; join STATEMENTSCHEDULE to AGGOUTPUTSCALAR using
                                                                  UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                                                                  AGGOUTPUTSCALAR to AGGOUTPUTHEADER using UIDAGGOUTPUTHEADER and then join
                                                                  AGGOUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the AGGOUTPUT
                                                                  records where the BILLDETERMINANT.PUBLICEXTRACT = 'Y'; pull the scalar record, then the header
NODAL                                      AGGOUTPUTINTERVAL      record
                                                                  Using the defined PIT on all tables; join CRROUTPUTHEADER to CRROUTPUTINTERVAL and
NODAL                                      AGGOUTPUTSCALAR        CRROUTPUTSCALAR using UIDCRROUTPUTHEADER;
                                                                  Using the defined PIT on all tables; join STATEMENTSCHEDULE to CRROUTPUTINTERVAL using
                                                                  UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                                                                  CRROUTPUTINTERVAL to CRROUTPUTHEADER using UIDCRROUTPUTHEADER and then join
                                                                  CRROUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the CRROUTPUT
                                                                  records where the BILLDETERMINANT.PUBLICEXTRACT = 'Y'; pull the interval record, then the header
NODAL                                      CRROUTPUTHEADER        record
                                                                  Using the defined PIT on all tables; join STATEMENTSCHEDULE to CRROUTPUTSCALAR using
                                                                  UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                                                                  CRROUTPUTSCALAR to CRROUTPUTHEADER using UIDCRROUTPUTHEADER and then join
                                                                  CRROUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the CRROUTPUT
                                                                  records where the BILLDETERMINANT.PUBLICEXTRACT = 'Y'; pull the scalar record, then the header
NODAL                                      CRROUTPUTINTERVAL      record
                                                                  Using the defined PIT on all tables; join DAIOUTPUTHEADER to DAIOUTPUTINTERVAL and
NODAL                                      CRROUTPUTSCALAR        DAIOUTPUTSCALAR using UIDDAIOUTPUTHEADER;
                                                                  Using the defined PIT on all tables; join STATEMENTSCHEDULE to DAIOUTPUTINTERVAL using
                                                                  UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                                                                  DAIOUTPUTINTERVAL to DAIOUTPUTHEADER using UIDDAIOUTPUTHEADER and then join
                                                                  DAIOUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the DAIOUTPUT
                                                                  records where the BILLDETERMINANT.PUBLICEXTRACT = 'Y'; pull the interval record, then the header
NODAL                                      DAIOUTPUTHEADER        record
                                                                  Using the defined PIT on all tables; join STATEMENTSCHEDULE to DAIOUTPUTSCALAR using
                                                                  UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                                                                  DAIOUTPUTSCALAR to DAIOUTPUTHEADER using UIDDAIOUTPUTHEADER and then join
                                                                  DAIOUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the DAIOUTPUT
                                                                  records where the BILLDETERMINANT.PUBLICEXTRACT = 'Y'; pull the scalar record, then the header
NODAL                                      DAIOUTPUTINTERVAL      record
                                                                  Using the defined PIT on all tables; join LLSOUTPUTHEADER to LLSOUTPUTINTERVAL and
                                                                  LLSOUTPUTSCALAR using UIDLLSOUTPUTHEADER; use QSECODE to join to QSE table for the
                                                                  DUNSNUMBER of the QSE recipient; use REPCODE to join to REP table for the DUNSNUMBER of the REP
NODAL                                      DAIOUTPUTSCALAR        recipient
                                                                  Using the defined PIT on all tables; join STATEMENTSCHEDULE to LLSOUTPUTINTERVAL using
                                                                  UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                                                                  LLSOUTPUTINTERVAL to LLSOUTPUTHEADER using UIDLLSOUTPUTHEADER and then join
                                                                  LLSOUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the DAIOUTPUT
                                                                  records where the BILLDETERMINANT.PUBLICEXTRACT = 'Y'; pull the interval record, then the header
NODAL                                      LLSOUTPUTHEADER        record
                                                                  Using the defined PIT on all tables; join MKTINPUTHEADER to MKTINPUTINTERVAL using
                                                                  UIDMKTINPUTHEADER; use QSECODE to join to QSE table for the DUNSNUMBER of the QSE recipient;
                                                                  use CRRACCTHLDRCODE to join to CRRACCTHOLDER table for the DUNSNUMBER of the
                                                                  CRRACCTHOLDER recipient; join MKTINPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT
                                                                  and pull the MKTINPUT records where BILLDETERMINANT.PUBLICEXTRACT = 'Y' and
NODAL                                      LLSOUTPUTINTERVAL      MKTINPUTHEADER.UIDMARKET = '1' for 'RTM'
                             Using the defined PIT on all tables; join MKTINPUTINTERVAL to MKTINPUTHEADER using
                             UIDMKTINPUTHEADER and pull records for STARTTIME = STATEMENTSCHEDULE.OPERATINGDATE
                             where STATUS = 'A' and UIDMARKET = '1' and BILLDETERMTYPECODE = 'MKTINT'; pull the interval
NODAL   MKTINPUTHEADER       record, then the header record
                             Using the defined PIT on all tables; join MKTINPUTSCALAR to MKTINPUTHEADER using
                             UIDMKTINPUTHEADER and pull records for STARTTIME = STATEMENTSCHEDULE.OPERATINGDATE
                             where STATUS = 'A' and UIDMARKET = '1' and BILLDETERMTYPECODE = 'MKTSCA'; pull the scalar
NODAL   MKTINPUTINTERVAL     record, then the header record
NODAL   MKTINPUTSCALAR       Created by parsing the interval table;
                             Using the defined PIT on all tables; join PREPROCESSHEADER to PREPROCESSINTERVAL and
NODAL   MKTINPUTSTATUS       PREPROCESSSCALAR using UIDPREPROCHEADER;
                             Using the defined PIT on all tables; join STATEMENTSCHEDULE to PREPROCESSINTERVAL using
                             UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                             PREPROCESSINTERVAL to PREPROCESSHEADER using UIDPREPROCHEADER and then join
                             PREPROCESSHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the PREPROCESS
                             records where the BILLDETERMINANT.PUBLICEXTRACT = 'Y'; pull the interval record, then the header
NODAL   PREPROCESSHEADER     record
NODAL   PREPROCESSINTERVAL   Created by parsing the interval table;
                             Using the defined PIT on all tables; join RTMOUTPUTHEADER to RTMOUTPUTINTERVAL and
NODAL   PREPROCESSSTATUS     RTMOUTPUTSCALAR using UIDRTMOUTPUTHEADER;
                             Using the defined PIT on all tables; join STATEMENTSCHEDULE to RTMOUTPUTINTERVAL using
                             UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                             RTMOUTPUTINTERVAL to RTMOUTPUTHEADER using UIDRTMOUTPUTHEADER and then join
                             RTMOUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the RTMOUTPUT
                             records where the BILLDETERMINANT.PUBLICEXTRACT = 'Y'; pull the interval record, then the header
NODAL   RTMOUTPUTHEADER      record
                             Using the defined PIT on all tables; join STATEMENTSCHEDULE to RTMOUTPUTSCALAR using
                             UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                             RTMOUTPUTSCALAR to RTMOUTPUTHEADER using UIDRTMOUTPUTHEADER and then join
                             RTMOUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the RTMOUTPUT
                             records where the BILLDETERMINANT.PUBLICEXTRACT = 'Y'; pull the scalar record, then the header
NODAL   RTMOUTPUTINTERVAL    record
NODAL   RTMOUTPUTSCALAR      Created by parsing the interval table;
                             Using the defined PIT on all tables; join RUCOUTPUTHEADER to RUCOUTPUTINTERVAL and
NODAL   RTMOUTPUTSTATUS      RUCOUTPUTSCALAR using UIDRUCOUTPUTHEADER;
                             Using the defined PIT on all tables; join STATEMENTSCHEDULE to RUCOUTPUTINTERVAL using
                             UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                             RUCOUTPUTINTERVAL to RUCOUTPUTHEADER using UIDRUCOUTPUTHEADER and then join
                             RUCOUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the RUCOUTPUT
                             records where the BILLDETERMINANT.PUBLICEXTRACT = 'Y'; pull the interval record, then the header
NODAL   RUCOUTPUTHEADER      record
                             Using the defined PIT on all tables; join STATEMENTSCHEDULE to RUCOUTPUTSCALAR using
                             UIDSTATEMENTSCHED for the STATUS = 'A' record and UIDMARKET = '1' for 'RTM'; join from
                             RUCOUTPUTSCALAR to RUCOUTPUTHEADER using UIDRUCOUTPUTHEADER and then join
                             RUCOUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the RUCOUTPUT
                             records where the BILLDETERMINANT.PUBLICEXTRACT = 'Y'; pull the scalar record, then the header
NODAL   RUCOUTPUTINTERVAL    record
NODAL   RUCOUTPUTSCALAR      Created by parsing the interval table;
NODAL   RUCOUTPUTSTATUS
STATUS:                             COMPLETE as of 03/03/08

Name:                               Public Reference Data Extract
Basic Info
 Master List Number:                ZP 12 - 465
 Short Name:                        PRDE
 Business Contact:                  J. Lavas
 Report or Extract:                 Extract
 Data Source:                       Lodestar
 Generating System:                 ODS
 Archival System:                   MIR
 Posting Format(s):                 ZIP
 File Format(s):                    CSV, XML
 Display or Delivery System:        MIS Secure, TML
 MP Recipient(s):                   LSE, TDSP, QSE, PGC, CRRAH
 DEWG SLA Level:                    1
 Data based on Approval?:           n/a
 Dynamic or Chronological?:         Chronological
 Protocol Reference:                in support of DAM & RTM CODE/MODE, SCR 727, Late Fees,
                                    SID NP 12.3.(c)
MIS Info
 MIS Folder Name:                   Public Reference Data Extract
 MIS/TML Report ID:                 1009
 MIS File Display Name Format(s):   Zip File Name:
                                    ext.mm-dd-yyyy hh24:mi:ss.PRDE_Extract_csv.zip
                                    ext.mm-dd-yyyy hh24:mi:ss.PRDE_Extract_xml.zip
                                    Files within Zip File:
                                    Tablename-DD-MMM-YYYY.CSV or .XML - the date
                                    represents the run date of the extract
 MIS Display Lifespan:              1 day - only most current extract is posted
 Files post in order on MIS?:       n/a
 MIS DDL Version(s):                EDW PRDE Draft DDL
                                    XMLXSD
 Landing Page:                      Settlements - Settlements Secure
                                    Data Aggregation - Data Aggregation Secure
                                    Retail - Retail Secure
 Portlet:                           Settlements - Settlements Report/Extract (Secure)
                                    Data Aggregation - Data Aggregation Report/Extract
                                    (Secure)
                                    Retail - Retail Report/Extract (Secure)
Schedule Info
 Frequency:                         Daily
 Days of Week:                      Mon-Sun
 Generation Time of Day:
 PITS Range Logic:                  Same logic as current extract - No change due to impacts to
                                    SCR727 & Settlement Extracts
 Trade Date Range Logic:            n/a
 Available on Extract Scheduler?:   no
Project Info                        EDW
Business Requirements Due Date             2/29/2008
EDS Delivery Date                          6/15/2008


Table List: See Master List Tab for Detailed Column Information
SCHEMA                                    TABLENAME
NODAL                                      ASMARKET
LODSTAR                                    BILLDETERMINANT
LODSTAR                                    CCCONFIGURATION
LODSTAR                                    CCPLANT
LODSTAR                                    CMZONE
NODAL                                      CRRACCTHOLDER
NODAL                                      CRRAUCTION
LODSTAR                                    DCTIE
NODAL                                      ELEMENT
LODSTAR                                    FACTOR
LODSTAR                                    FACTORVALUE
NODAL                                      FLOWGATE
LODSTAR                                    GENERATOR
LODSTAR                                    GENERATORSITE
LODSTAR                                    LOSSCLASS
NODAL                                      MKTCONSTRAINT
LODSTAR                                    MRE
LODSTAR                                    NOIE
LODSTAR                                    PGC
LODSTAR                                    PROFILECLASS
LODSTAR                                    PROFILECUT
LODSTAR                                    PROFILETYPE
LODSTAR                                    QSE
LODSTAR                                    REP
NODAL                                      RESOURCENODAL
NODAL                                      RUCPROCESS
LODSTAR                                    SETTLEMENTPOINT
LODSTAR                                    SETLPOINTTYPE
LODSTAR                                    SETLPOINTHISTORY
NODAL                                      STARTTYPE
LODSTAR                                    STATION
LODSTAR                                    STATIONSERVICEHIST
LODSTAR                                    TDSP
LODSTAR                                    UFEZONE
LODSTAR                                    UOM
Business Notes:
-No change in PIT logic from current, just add new tables
- Must add XML file format
-Add new tables to existing COUNT file
-Continue to produce PRDE count files for all tables in extract
STATUS:                                     COMPLETE as of 03/03/08

Name:                                       Settlement Inputs Data Extract
Basic Info
 Master List Number:                        NP 12 - 753
 Short Name:                                SID
 Business Contact:                          J. Lavas
 Data Source:                               Lodestar
 Generating System:                         ODS
 Archival System:                           MIR
 Report or Extract:                         Extract
 Posting Format(s):                         ZIP
 File Format(s):                            CSV, XML
 Display or Delivery System:                MIS Certified
 MP Recipient(s):                           QSE, CRR
 DEWG SLA Level:                            1
 Data based on Approval?:                   NO
 Dynamic or Chronological?:                 Chronological
 Protocol Reference:                        NP 12.3 (C)
MIS Info
 MIS Folder Name:                           Settlement Inputs Data Extract
 MIS Report ID:                             11133
 MIS File Display Name Format(s):           Zip File Name:
                                            ext.(MM-DD-YYYY HH24:MI:SS).SID_Daily_csv.zip
                                            ext.(MM-DD-YYYY HH24:MI:SS).SID_Daily_xml.zip
                                            Files within Zip File:
                                            Tablename_SID(DunsNumber).csv OR .xml
 MIS Display Lifespan:                      30 days
 Files post in order on MIS?:               YES
 MIS DDL Version(s):                        EDW Settlements Draft DDL
                                            XMLXSD
  Landing Page:                             Settlements - Certified
  Portlet:                                  Settlements Report/Extract (Certified)
Schedule Info
  Frequency:                                Daily
  Days of Week:                             Mon-Sun
  Generation Time of Day:                   early AM
  PITS Range Logic:                         use p_curr for records with PITSTART between sysdate-1,
                                            00:00 - 23:59
 Trade Date Range Logic:                    n/a
 Available on Extract Scheduler?:           YES
Project Info                                EDW
Business Requirements Due Date              2/29/2008
EDS Delivery Date                           6/15/2008



Table List: See Master List Tab for Detailed Column Information
SCHEMA:   TABLENAME:
LODSTAR   SID_MKTINPUTHEADER

LODSTAR   SID_MKTINPUTINTERVAL

LODSTAR   SID_MKTINPUTSCALAR
LODSTAR   SID_MKTINPUTSTATUS
Business Notes:
-include DAM & RTM inputs with both public and private values in the certified file
- whatever data is available in the system at the time of the run for the previous 000000-235959 goes in
extract
- run daily
- this is not trade date specific
- any S&B inputs that were changed or inserted should go to MPs
- not based on settlement approval
- Before extract runs verify Heartbeat in both Lodstar & NDL schemas.
- to determine record recipients:
MKTINPUTHEADER.UIDBILLDETERMINANT = BILLDETERMINANT.UIDBILLDETERMINANT
BILLDETERMINANT.PUBLICEXTRACT <> 'I' AND BILLDETERMTYPECODE will be MKTINT or MKTSCA
 ~ PUBLICEXTRACT = 'Y' goes in all recipient files - MKTINPUTHEADER.QSE and CRRACCTHOLDERCODE will
be null
 ~ PUBLICEXTRACT = 'N' goes in MP specific files
 ~ MP defined on MKTINPUTHEADER in QSECODE (join to Lodstar.QSE for duns) and
CRRACCTHOLDERCODE (joins to Lodstar.CRRACCTHOLDER for duns)
MKTINPUTINTERVAL is parsed into:
 ~ MKTINTERVAL - numeric INT001 - INT100
 ~ MKTINPUTSTATUS - char STATUS001- STATUS100

*An extract should be created for every day. If there is an issue, every day's expected
publishing must be created and posted.




Coding information
Using the defined PIT on all tables; join MKTINPUTHEADER to MKTINPUTINTERVAL using UIDMKTINPUTHEADER; use
QSECODE to join to QSE table for the DUNSNUMBER of the QSE recipient; use CRRACCTHLDRCODE to join to
CRRACCTHOLDER table for the DUNSNUMBER of the CRRACCTHOLDER recipient; join MKTINPUTHEADER to
BILLDETERMINANT using UIDBILLDETERMINANT and pull the MKTINPUT records where
BILLDETERMINANT.PUBLICEXTRACT = 'N' for MP specific files and = 'Y' for all MP files
Using the defined PIT on all tables; join MKTINPUTINTERVAL to MKTINPUTHEADER using UIDMKTINPUTHEADER ;
pull the interval record, then the header record
Using the defined PIT on all tables; join MKTINPUTSCALAR to MKTINPUTHEADER using UIDMKTINPUTHEADER; pull
the scalar record, then the header record
Created by parsing the interval table;
STATUS:                             COMPLETE as of 5/30/08

Name:                               Market Participant Dispute Extract
Basic Info
 Master List Number:                NP 9 -515
 Short Name:                        MP Dispute
 Business Contact:                  J. Lavas
 Report or Extract:                 Extract
 Data Source:                       Siebel
 Generating System:                 ODS
 Archival System:                   MIR
 Posting Format(s):                 ZIP
 File Format(s):                    CSV, XML
 Display or Delivery System:        MIS Certified
 MP Recipient(s):                   QSE, CRR
 DEWG SLA Level:
 Data based on Approval?:           NO
 Dynamic or Chronological?:         Chronological
 Protocol Reference:                NP 9.8.6
MIS Info
 MIS Folder Name:                   Market Participant Dispute Extract
 MIS Report ID:                     11115
 MIS File Display Name Format(s):   ZIP File Name:
                                    ext.(MM-DD-YYYY HH24:MI:SS).MPDispute_csv.zip
                                    ext.(MM-DD-YYYY HH24:MI:SS).MPDispute_xml.zip
                                    Files within Zip File:
                                    Dunsnumber_MPDispute.csv OR .xml

 MIS Display Lifespan:              1 day - only most current extract is posted
 Files post in order on MIS?:       n/a
 MIS DDL Version(s):                EDW MP Dispute Draft DDL
                                    XMLXSD
  Landing Page:                     Settlements - Certified
  Portlet:                          Settlements Report/Extract (Certified)
Schedule Info
  Frequency:                        Daily
  Days of Week:                     Mon-Sun
  Generation Time of Day:           Run to post prior to 5 PM
  PITS Range Logic:                 current pits with a heartbeat > midnight of current day

 Trade Date Range Logic:            n/a
 Available on Extract Scheduler?:   YES
Project Info                        EDW
Business Requirements Due Date      5/15/2008
EDS Delivery Date                   9/1/2008

                                                                                              DDL Comments
Required Fields:                    Database Schema.Table Name.Field
Dispute Number                      siebel.s_srv_req.sr_num
MP Account Name                     siebel.s_org_ext.name                                     join to table/field with MP ty
MP Account Number (DUNS)            siebel.s_org_ext.duns_num
Market Type (RTM, DAM, CRR)               siebel.cx_ercot_dispute_deadline.x_market
Dispute Type                              siebel.s_srv_req.sr_area
Dispute Sub Type                          siebel.s_srv_req.sr_sub_area
Charge Type                               siebel.s_srv_req_xm.attrib_04

Description                               siebel.s_srv_req.sr_title                            From Lodestar STATEMENTS
                                          siebel.cx_ercot_dispute_deadline.x_operating_date;
Operating Day                             siebel.s_srv_req_xm.attrib_32
Start Operating Date                      siebel.s_srv_req_xm.attrib_33
End Op Date                               siebel.s_srv_req_xm.attrib_13
Beginning Interval                        siebel.s_srv_req_xm.attrib_12                        INVOICEDATE from INVOICES
Invoice Date                              siebel.cx_ercot_dispute_deadline.x_invoice_date      INVOICECYCLECODE from IN
Invoice Type                              siebel.cx_ercot_dispute_deadline.x_invoice_type      Siebel Generated Field
Created Date                              siebel.cx_ercot_dispute_deadline.created
Closed Date                               siebel.s_srv_req.act_close_dt
Resolution Code (Granted, granted w/
exception, denied, null)                  siebel.s_srv_req.resolution_cd
Status (not started, open, closed,
withdrawn, ADR)                           siebel.s_srv_req.sr_stat_id
Dispute Due Date                          siebel.cx_ercot_dispute_deadline.x_disp_due_date
Planned Resolution Date                   siebel.s_srv_req.exp_close_dt
Resolution Date                           siebel.s_srv_req_xm.attrib_26
Dispute Amount                            siebel.s_srv_req_xm.ATTRIB_25
Resolution Amount                         siebel.s_srv_req_xm.attrib_40
Amount Award                              siebel.s_srv_req.x_award_amt
Contact First Name                        siebel.s_contact.fst_name
Contact Last Name                         siebel.s_contact.last_name
Contact Email Address (eService)          siebel.s_contact.email_addr
Contact Business Phone                    siebel.s_contact.work_ph_num
Expiration of confidentiality Rule flag   siebel.s_srv_req.x_ecrif                             calculated when not null
Attachment Flag                           siebel.s_contact.par_row_id


Dsipute Deadlines and Due Dates
MARKET                                    SETTLEMENT/INVOICE TYPE
                                                                                                    Post date of the Settlem
  Non RTM Statement Dispute Deadline
                                            ALL
                                                                                                             Post Date of t
                                            Initial
                                            Final                                                                Post Date
    RTM Statement Dispute Deadline          True Up                                                         Post Date of t
                                            Resettlement PRIOR to True Up                                 Post date of the
                                            Resettlement AFTER True Up                                           Post Date
Exceptions: Confidentiality Flag Expiration Dispute Deadline Date                                                  Dispute
                  = 'Y'                     Dispute Due Date                                                       Dispute
                                            ALL
  Non RTM Statement Dispute Due Date
                                                                                                             Post Date of t
                                          Initial
                                          Final
     RTM Statement Dispute Due Date                                                                                 Dispute
                                          True Up
                                          Resettlement                                           If the Dispute is received w
                                                                                                 Settlement Statement the
                                                                                               Statement + 25 Business Da
                              If the Dispute is received w
                              Settlement Statement the
Exceptions:   RTM Initial   Statement + 25 Business Da
                              Change in the Post Date s
  NOTE:       ALL
       Business Notes:
       -daily extract should provide all settlement dispute data records for MP for
       all statuses, including all disputes closed or withdrawn within the last 120
       days




DDL Comments


join to table/field with MP type = QSE or CRR
From Lodestar STATEMENTSCHEDULE table OPERATINGDATE




INVOICEDATE from INVOICESCHEDULE table
INVOICECYCLECODE from INVOICESCHEDULE table
Siebel Generated Field




calculated when not null




                                  CALCULATION
     Post date of the Settlement/Resettlement Statement + 10 Business Days

              Post Date of the True Up Statement - 20 Business Days

                  Post Date of the Statement + 10 Business Days
             Post Date of the True Up Statement - 20 Business Days
           Post date of the Resettlement Statement + 10 Business Days
                  Post Date of the Statement + 10 Business Days
                    Dispute Deadline Date + 10 Business Days
                    Dispute Deadline Date + 10 Business Days


              Post Date of the True Up Statement - 10 Business Days

                    Dispute Deadline Date + 10 Business Days
  If the Dispute is received within 15 Business Days of the Post Date of the Initial
  Settlement Statement then the Dispute Due Date = Post Date of the RTM Initial
Statement + 25 Business Days for inclusion of the RTM Final Settlement Statement
  If the Dispute is received within 15 Business Days of the Post Date of the Initial
  Settlement Statement then the Dispute Due Date = Post Date of the RTM Initial
Statement + 25 Business Days for inclusion of the RTM Final Settlement Statement
  Change in the Post Date should re-trigger all impacted Deadline and Due Dates
STATUS:                             COMPLETE as of 5/30/08


Name:                               Settlement Calendar Extract                                                                                             Business Notes:
Basic Info                                                                                 -Use naming convention for settlement type as used in the Settlement Statement, CODE/MODE; One available posting of the calendar with the
 Master List Number:                NP 9 - 598                                             most current data should be posted; when data is updated, previous calendar should be overwritten.; Invoice date will be populated on each
 Short Name:                        Calendar                                               record CRR monthly and CRR annually – no invoice date will be initially populated in the calendar; Monthly has 6 cuts and is available first
 Business Contact:                  J. Lavas                                               business day following the initial of last day of month
 Report or Extract:                 Extract                                                For NP 9.1.2(2), need to have a notice sent, as well as the calendar update;
                                                                                            select INVS.TRANSACTIONID Type
 Data Source:                       Lodestar
                                                                                                ,TO_DATE('','MM/DD/YYYY') AS OPERATINGDATE
 Generating System:                 ODS
                                                                                                ,INVS.TIMEPERIOD
 Archival System:                   MIR
                                                                                                ,TO_DATE('','MM/DD/YYYY') AS BATCHDATE
 Posting Format(s):                 ZIP
                                                                                                ,INVS.VERSION
 File Format(s):                    CSV, XML                                                    ,INVS.INVOICEDATE
 Display or Delivery System:        MIS Public & ERCOT.com                                      ,INVS.INVOICEDUEDATE
 MP Recipient(s):                   PUBLIC                                                      ,INVS.INVOICEPAYOUTDATE
 DEWG SLA Level:                                                                                ,TO_DATE('','MM/DD/YYYY') AS ISSUEDATE
 Data based on Approval?:           NO                                                          ,TO_DATE('','MM/DD/YYYY') AS DISPUTEDATE
 Dynamic or Chronological?:         Chronological                                               ,INVS.LSUSER
 Protocol Reference:                NP 9.1.2 (1)                                                ,INVS.LSTIME
MIS Info                                                                                   from NINTIN1.INVOICESCHEDULE INVS
 MIS Folder Name:                   Settlement Calendar Extract                            UNION
 MIS Report ID:                     11116                                                  SELECT SC.SETTLEMENTTYPE
 MIS File Display Name Format(s):   CSV ZIP file:                                               ,SC.OPERATINGDATE
                                    ext.(MM-DD-YYYY                                             ,TO_DATE('','MM/DD/YYYY') AS TIMEPERIOD
                                    HH24:MI:SS).SettlementCalendar_csv.zip                      ,SC.BATCHDATE
                                                                                                ,'' AS VERSION
                                    XML ZIP file:                                               ,SC.INVOICEDATE
                                    ext.(MM-DD-YYYY                                             ,TO_DATE('','MM/DD/YYYY') AS INVOICEDUEDATE
                                    HH24:MI:SS).SettlementCalendar_xml.zip                      ,TO_DATE('','MM/DD/YYYY') AS INVOICEPERIOD
                                                                                                ,TO_DATE('','MM/DD/YYYY') AS ISSUEDATE
                                                                                                ,TO_DATE('','MM/DD/YYYY') AS DISPUTEDATE
 MIS Display Lifespan:              Only most current extract                                   ,SC.LSUSER
 Files post in order on MIS?:       n/a                                                         ,SC.LSTIME
 MIS DDL Version(s):                EDW Calendar Draft DDL                                 FROM NINTIN1.STATEMENTSCHEDULE SC
                                    XMLXSD                                                 o One record per operating day, run type, channel – unique key
 Landing Page:                      Settlements - Public                                   o For invoicing and CRR monthly/annual auctions, the unique key for the record...Add a uidcalendar field to the ddl which would be populated
 Portlet:                           Settlements Report/Extract (Public)                    by
Schedule Info                                                                                UIDSTATEMENTSCHED, UIDINVOICESCHED
 Frequency:                         Daily                                                  o What fields does the CRR and invoicing use? Where is this data stored in L*? 12/20 – CRR and invoicing is not operating day specific
 Days of Week:                      Mon-Sun                                                o DDL - Operating Day, Run Date CHANGE to batchdate, Run Type, Channel, Settlement Statement posting date, Invoice posting Date,
 Generation Time of Day:            No later than 3 PM to post before 5 PM                 Payment due date (pay in), Payment Process Date (pay out), Dispute Date Deadline, Last Updated Date
 PITS Range Logic:                  current pits                                           o DDL - Do not include: batchtimestamp, batchuserid, userid, usertimestamp, status, approvalready or runnumber
                                                                                           o Statement posting date will keep the Protocol posting date unless it is posted late
 Trade Date Range Logic:            n/a
                                                                                           o For CRR invoice in settlement calendar extract this is just a different version/type of invoice; channel/version is still pulled from stmtschedule
 Available on Extract Scheduler?:   NO
                                                                                           and invoiceschedule
Project Info                        EDW
Business Requirements Due Date      5/15/2008
EDS Delivery Date                   9/1/2008



Column                              Database Schema.Table Name.Field                                                               DDL Comments
                                    ndlstar.statementschedule.settlementtype/ndlst    Data from the settlementtype field in the statementschedule and the transactionid field from the
Settlement Type                     ar.invoiceschedule.transactionid                  invoiceschedule tables
Operating Date                      ndlstar.statementschedule.operatingdate           Invoices will be null
Batch Date                          ndlstar.statementschedule.batchdate               Invoices will be null
Channel                             ndlstar.statementschedule.savechannel
Market                              ndlstar.statementschedule.uidmarket
                                    ndlstar.statementschedule.invoicedate/ndlstar.i
Invoice Date                        nvoiceschedule.invoicedate
Invoice Due Date                    ndlstar.invoiceschedule.invoiceduedate            Statements will be null
Invoice Payout Date                 ndlstar.invoiceschedule.invoicepayoutdate         Statements will be null
                                    siebel.cx_ercot_dispute_deadline.x_operating_
Dispute Deadline Date               date
                                    ndlstar.statementschedule.lstime/ndlstar.invoic
Last Updated Date                   eschedule.lstime
Time Period                         ndlstar.invoiceschedule.timeperiod                Statements will be null
Version                             ndlstar.invoiceschedule.version
                                    ndlstar.statementschedule.postdate/ndlstar.inv
PostDate                            oiceschedule.postdate                            metadata change in process for invoice schedule table



EXAMPLE:
                                          Operating Date (for Statements)                                                       Version (for Invoices)                                                                                               Dispute
                                             Time Period (for Invoices)                                                     Save Channel (for Statements)                                                               Invoice Payout               Deadline
             Settlement Type               (To be called Operating Date)                         Batch Date                    (To Be Called Version)                       Invoice Date             Invoice Due Date        Date        PostDate      Date

                                                                                                                              Statement Version Number               The date in which the Op Day
                  DAM                               Operating Date                       System Date of calculation                (1, 2, 3, 4, etc.)                 and Version will be Invoiced         null              null        Post Date

                                                                                                                              Statement Version Number               The date in which the Op Day
            DAM Resettlement                        Operating Date                       System Date of calculation                (1, 2, 3, 4, etc.)                 and Version will be Invoiced         null              null        Post Date

                                                                                                                              Statement Version Number               The date in which the Op Day
                RTM Initial                         Operating Date                       System Date of calculation                (1, 2, 3, 4, etc.)                 and Version will be Invoiced         null              null        Post Date

                                                                                                                              Statement Version Number               The date in which the Op Day
                RTM Final                           Operating Date                       System Date of calculation                (1, 2, 3, 4, etc.)                 and Version will be Invoiced         null              null        Post Date

                                                                                                                              Statement Version Number               The date in which the Op Day
               RTM Trueup                           Operating Date                       System Date of calculation                (1, 2, 3, 4, etc.)                 and Version will be Invoiced         null              null        Post Date

                                                                                                                             Statement Version Number        The date in which the Op Day
            RTM Resettlement                        Operating Date                       System Date of calculation                (1, 2, 3, 4, etc.)         and Version will be Invoiced                 null              null        Post Date
                                                                                                                          Channel of the Operating Day being
               DAM Invoice              Operating Day that is being Invoiced                         null                              Invoiced                       Issue Date                      Money In Date     Money Out Date   Post Date
               RTM Invoice                               null                                        null                                 null                        Issue Date                      Money In Date     Money Out Date   Post Date
             RTM Uplift Invoice                          null                                        null                                 null                        Issue Date                      Money In Date     Money Out Date   Post Date
           DAM Late Fee Invoice              Month that is being Invoiced                            null                                 null                        Issue Date                      Money In Date     Money Out Date   Post Date
           RTM Late Fee Invoice              Month that is being Invoiced                            null                                 null                        Issue Date                      Money In Date     Money Out Date   Post Date
            CRR Auction Invoice         Month or year Auction Revenues are
                                       Month for whichthat is being Invoiced                         null                         Annual or Monthly                   Issue Date                      Money In Date     Money Out Date   Post Date
              CARD Invoice                            Invoiced                                       null                        After Initial or Final               Issue Date                      Money In Date     Money Out Date   Post Date
                                      Month for which CRR Balancing Account is
    CRR Balancing Account Invoice                     Invoiced                                       null                Either after Initials, Finals, or Trueups            Issue Date              Money In Date     Money Out Date   Post Date
           MISC Invoice                                  null                                        null                                    null                             Issue Date              Money In Date     Money Out Date   Post Date
STATUS:                             COMPLETE as of 5/30/08

Name:                               Settlements Late Fee Extract
Basic Info
 Master List Number:                COMS - 801
 Short Name:                        Late Fee Extract
 Business Contact:                  J. Lavas
 Report or Extract:                 Extract
 Data Source:                       Lodestar
 Generating System:                 ODS
 Archival System:                   MIR
 Posting Format(s):                 ZIP
 File Format(s):                    CSV, XML
 Display or Delivery System:        MIS Certified
 MP Recipient(s):                   CRR, QSE
 DEWG SLA Level:
 Data based on Approval?:           YES
 Dynamic or Chronological?:         Dyanmic - Keys off of INVOICESCHEDULE
 Protocol Reference:                NP 12.3 (c)
MIS Info
 MIS Folder Name:                   Settlements Late Fee Extract
 MIS Report ID:                     11117
 MIS File Display Name Format(s):   Zip File:
                                    ext.(MM-DD-YYYY
                                    HH24:MI:SS).LateFee_DAM_DUNSNUMBER_INVOICEID_csv
                                    OR xml.zip
                                    ext.(MM-DD-YYYY
                                    HH24:MI:SS).LateFee_RTM_DUNSNUMBER_INVOICEID_csv
                                    OR xml.zip
 MIS Display Lifespan:
 Files post in order on MIS?:       YES
 MIS DDL Version(s):                EDW Late Fees Draft DDL
                                    XMLXSD
  Landing Page:                     Settlements - Certified
  Portlet:                          Settlements Report/Extract (Certified)
Schedule Info
  Frequency:                        Monthly
  Days of Week:                     Triggered off of Late Fee Invoice which is due the 10th day
                                    after the end of the month (or the next business day if it is a
                                    holiday or weekend)
 Generation Time of Day:
 PITS Range Logic:                  current pits with a heartbeat > midnight of current day
 Trade Date Range Logic:            Prior calendar month
 Available on Extract Scheduler?:   YES
Project Info                        EDW
Business Requirements Due Date      5/15/2008
EDS Delivery Date                   9/1/2008



Column                                              Database Schema.Table Name.Field
BatchDate                           ndlstar.latefee.batchdate
MarketCode                  ndlstar.market.marketcode
AccountID                   ndlstar.qse.uidaccount
TimePeriod                  ndlstar.latefee.timeperiod
Amount                      ndlstar.latefee.amount
Invoice Date                ndlstar.latefee.invoicedate/ndlstar.invoiceschedule.invoicedate
Invoice Due Date            ndlstar.latefee.invoiceduedate/ndlstar.invoiceschedule.invoiceduedate
Invoice ID                  ndlstar.latefee.invoiceid

Invoice Cycle Code          ndlstar.invoiceschedule.invoicecyclecode

Due Date Detail             ndlstar.latefee.duedatedetail

Invoice ID Detail           ndlstar.latefee.invoiceiddetail

Invoice Balance Detail      ndlstar.latefee.invbalancedetail

Invoice Cycle Detail        ndlstar.latefee.uidinvscheddetail




Rate                        ndlstar.latefee.rate


Total Outstanding Balance   ndlstar.latefee.totaloutbalance


Counter Entity Account ID   ndlstar.latefee.cntrentuidaccount




Counter Entity Invoice ID   ndlstar.latefee.cntrentinvoiceid



Counter Entity Charge       ndlstar.latefee.cntrentcharge
Last Updated Date           ndlstar.latefee.lstime/ndlstar.invoiceschedule.lstime
                                                         Business Notes:
Includes the daily late fee calculations that are included on a monthly late fee invoice
What triggers the extract to run? Based on Status = 'A' for UIDINVOICESCHED row
• DAM approved, which sends where uidmarket = DAM and the join is on the uidinvoiceschedule for invoiceschedule table
• RTM will be uidmarket = RTM
• Base on the previous 24 hours, so example, run at 5PM, look for approvals for prior month where status = ‘A’ for late fee
invoice type, if so then bundle all uidmarkets approved into one file
• Info updated daily for monthly extract for the approved DAM and RTM Late Fee invoice




DDL Comments
The date ERCOT assesed a latefee CH or CR
The market code. 'DAM' for Day Ahead or 'RTM' for Real-Time.
The Account ID for the MP receiving a Late Fee CH or CR
Denotes the month in which the Late Fee CH or CR was asseseed. This date will
Late fee charge or credit amount
The date the Late Fee is invoiced on the DAM Late Fee Invoice
The date the DAM Late Fee Invoice is due to ERCOT
Unique number assigned to each DAM or RTM Late Fee Invoice

Unique code identifier that represents the billing cycle for the DAM Late Fee Invoice

The due date of the MPs DAM invoice with an outstanding charge or credit balance

The Invoice ID of the MPs DAM invoice with an outstanding charge or credit balance

The Remaining outstanding Credit or Charge Balance of the MPs DAM invoice
The Invoice Cycle Code of the MPs DAM invoice with an outstanding charge or credit
balance

Rate used to calculate late fee charges and credits. For Outstanding DAM Charge
Invoices: Rate = Invoice Balance Detail * (Prime Rate + Late Fee Factor )/Number of
Days in Year. For Outstanding DAM Credit Invoices: Rate = Invoice Balance Detail/Total
Outstanding Balance

The Outstanding Balance Sum of ALL MPs for a given DAM invoice cycle for all DAM
Credit Invoices, will only be populated for Late Fee Credit records
Account # of the DAM Invoice Recipient who did not pay their Charge DAM Invoice in
full and was assessed a Late Fee Charge, will only be populated for Late Fee Credit
records


Invoice ID that was assessed a Late Fee Charge or Credit. For DAM Late Fee Charges,
this will reflect the Invoice ID of the DAM Invoice that was not paid in full. For DAM
Late Fee Credits, this will reflect the Invoice ID of the short-paid DAM Invoice of the
Counter Entity who did not pay their DAM Invoice in full and was assessed a DAM Late
Fee Charge for which this DAM Late Fee Credit was calculated.

DAM Late Fee Charge calculated for the DAM Charge Invoice Recipient that did not
pay their Invoice in full and to which the DAM Late Fee credit is assessed, will only be
populated for Late Fee Credit records
e fee invoice
HED row
 the uidinvoiceschedule for invoiceschedule table

als for prior month where status = ‘A’ for late fee

Late Fee invoice
STATUS:                                    COMPLETE as of 5/30/08

Name:                                      CRR Auction Revenue Distribution (CARD) Extract
Basic Info
 Master List Number:                       COMS - 802
 Short Name:                               CARD Extract
 Business Contact:                         J. Lavas
 Report or Extract:                        Extract
 Data Source:                              Lodestar
 Generating System:                        ODS
 Archival System:                          MIR
 Posting Format(s):                        ZIP
 File Format(s):                           CSV, XML
 Display or Delivery System:               MIS Certified
 MP Recipient(s):                          CRR
 DEWG SLA Level:
 Data based on Approval?:                  YES
 Dynamic or Chronological?:                Dyanmic - Keys off of INVOICESCHEDULE
 Protocol Reference:                       NP 12.3 (c)
MIS Info
 MIS Folder Name:                          CRR Auction Revenue Distribution (CARD) Extract
 MIS Report ID:                            11118
 MIS File Display Name Format(s):          ZIP file:
                                           ext.(MM-DD-YYYY HH24:MI:SS).CARD.zip
                                           Files within Zip File:
                                           DunsNumber_Tablename_CARD.XML or .CSV
 MIS Display Lifespan:
 Files post in order on MIS?:              YES
 MIS DDL Version(s):                       EDW CARD Draft DDL
                                           XMLXSD
  Landing Page:                            Settlements - Certified
  Portlet:                                 Settlements Report/Extract (Certified)
Schedule Info
  Frequency:                               Monthly
  Days of Week:                            Triggered off of CARD Invoice .Status = 'A' for
                                           INVOICESCHED
 Generation Time of Day:
 PITS Range Logic:                         current pits with a heartbeat > midnight of current
                                           day
 Trade Date Range Logic:                   Prior calendar month
 Available on Extract Scheduler?:          YES
Project Info                               EDW
Business Requirements Due Date             5/15/2008
EDS Delivery Date                          9/1/2008

Table List: See Master List Tab for Detailed Column Information
SCHEMA                                     TABLENAME

NODAL                                      AGGOUTPUTHEADER
NODAL                AGGOUTPUTSCALAR

NODAL                CRROUTPUTHEADER




NODAL                CRROUTPUTSCALAR




Column                             Database Schema.Table Name.Field
UIDBILLDETERMINANT   ndlstar.billdeterminant.uidbilldeterminant
BILLDETERMCODE       ndlstar.billdeterminant.billdetermcode
BILLDETERMTYPECODE   ndlstar.billdeterminant.billdetermtypecode
PUBLICEXTRACT        ndlstar.billdeterminant.publicextract
BILLDETERMNAME       ndlstar.billdeterminant.billdetermname
Start Time           ndlstar.billdeterminant.starttime
Stop Time            ndlstar.billdeterminant.stoptime
Savechannel          ndlstar.invoiceschedule.version
                                         Business Notes:
-extract file mapping columns pulled from invoice prototype supplied by settlements;generated and
posted after the payment_delivered date for prior months (time_period) data

What triggers the extract to run? Approval of invoiceschedule record of CARD invoice, where status
= ‘A’

Tables
o CRROUTPUTHEADER, CRROUTPUTSCALAR, AGGOUTPUTHEADER, AGGOUTPUTSCALAR
--same data set as in Settlements DDL. Seperate DDL is not needed.
o CRR output scalar join to invoiceschedule using uid
  o When the card invoice is approved, the uid for the card record is pop
    on the scalar records that need to be sent
STATEMENTSCHED.UIDMARKET = '3' for CRR

billdeterminant type code (process group for CARD Extracts 'process members (BD)' in the table for




                                       Coding information

Using the defined PIT on all tables; join AGGOUTPUTHEADER to AGGOUTSCALAR using
UIDAGGOUTPUTHEADER
Using the defined PIT on all tables; join INVOICECHEDULE to AGGOUTPUTSCALAR using
UIDINVOICESCHED for the STATUS = 'A' record and UIDMARKET = '3' for 'CRR'; join from
AGGOUTPUTSCALAR to AGGOUTPUTHEADER using UIDAGGOUTPUTHEADER and then join
AGGOUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the AGGOUTPUT
records where the BILLDETERMINANT.PUBLICEXTRACT = 'N'; pull the scalar record, then the header
record
Using the defined PIT on all tables; join CRROUTPUTHEADER to CRROUTPUTSCALAR using
UIDCRROUTPUTHEADER
Using the defined PIT on all tables; join INVOICESCHEDULE to CRROUTPUTSCALAR using
UIDINVOICESCHED for the STATUS = 'A' record and UIDMARKET = '3' for 'CRR''; join from
CRROUTPUTSCALAR to CRROUTPUTHEADER using UIDCRROUTPUTHEADER and then join
CRROUTPUTHEADER to BILLDETERMINANT using UIDBILLDETERMINANT and pull the CRROUTPUT
records where the BILLDETERMINANT.PUBLICEXTRACT = 'N; pull the scalar record, then the header
record




DDL Comments
STATUS:                             COMPLETE as of 5/30/08

Name:                               ESI ID Service History & Usage Extract - Daily
Basic Info
 Master List Number:                ZP12 - 245
 Short Name:                        727 Daily Extract
 Business Contact:                  J. Lavas
 Report or Extract:                 Extract
 Data Source:                       Lodestar
 Generating System:                 ODS
 Archival System:                   MIR
 Format(s):                         ZIP, CSV, XML
 Display or Delivery System:        MIS Certified
 MP Recipient(s):                   LSE, TDSP
 DEWG SLA Level:                    1
 Protocol Reference:                P 12.4.4.2.3.2.
                                    Retail Market Guide - section 7.1.3
                                    SCR 740
TML Info
 Post on TML or MIS?:               BOTH - Modified version will post in both locations

 TML Report ID:                     224
 TML Folder Name:                   ESIID Extract
MIS Info
 MIS Report ID:                     210
 MIS Folder Name:                   ESI ID Service History & Usage - Daily
 MIS Display Lifespan:              30 days
 MIS File Display Name Format:      ext.(MM-DD-YYYY HH24:MI:SS).ESIID.zip
 File post in order on MIS?:        YES
 MIS DDL Version(s):                Same DDL as Zonal for ESIID Extract
                                    XMLXSD
  Landing Page:                     Retail - Certified
  Portlet:                          Retail Report/Extract (Certified)
Schedule Info
  Frequency:                        Daily
  Days of Week:
  Generation Time of Day:
  PITS Range Logic:                 current pits with a heartbeat > midnight of current
                                    day
 Trade Date Range Logic:            n/a
 Available on Extract Scheduler?:   YES
Project Info                        EDW
Business Requirements Due Date      5/15/2008
EDS Delivery Date                   9/1/2008
Business Notes:
-Add new dimensional tables for Settlement Points:
SETTLEMENTPOINT, SETLPOINTTYPE, SETLPOINTHISTORY

MPs will need to baseline these tables using PRDE. Daily changes will be
included in the extract just as they are for other dimensional tables.

***Updates to COPS, RMS and DEWG, so MPs can update their DDLs.

Draft DDL

Code should add tables and the PITS logic of the extract should be the same
as it is today
STATUS:                             COMPLETE as of 5/30/08

Name:                               ESI ID Service History & Usage Extract - Supplemental

Basic Info
 Master List Number:                ZP12 - 247
 Short Name:                        727 Supp
 Business Contact:                  J. Lavas
 Report or Extract:                 Extract
 Data Source:                       Lodestar
 Generating System:                 ODS
 Archival System:                   MIR
 Format(s):                         ZIP, CSV
 Display or Delivery System:        MIS Certified, TML Private, API
 MP Recipient(s):                   TDSP, LSE
 DEWG SLA Level:                    n/a
 Protocol Reference:                P 12.4.4.2.3.2.
                                    Retail Market Guide - section 7.1.3
                                    SCR 740
TML/MIS Info
 Post on TML or MIS?:               BOTH - Modified version will post in both locations

 TML Report ID:                     224
 TML Folder Name:                   ESIID Extract
MIS Info
 MIS Report ID:                     210
 MIS Folder Name:                   ESI ID Service History & Usage - Daily
 Same version as TML?:              YES
 MIS Display Lifespan:              30 days
 MIS File Display Name Format(s):   ext.(MM-DD-YYYY HH24:MI:SS).ESIID Supp.zip
 File post in order on MIS?:        YES
 MIS DDL Version(s):                Same DDL as Zonal for ESIID Extract
                                    XMLXSD
  Landing Page:                     Retail - Certified
  Portlet:                          Retail Report/Extract (Certified)
Schedule Info
  Frequency:                        As Requested
  Days of Week:
  Generation Time of Day:
  PITS Range Logic:                 current pits with a heartbeat > midnight of current
                                    day
 Trade Date Range Logic:            n/a
 Available on Extract Scheduler?:   YES
Project Info                        EDW
Business Requirements Due Date      5/15/2008
EDS Delivery Date                   9/1/2008
Business Notes:
-Add new dimensional tables for Settlement Points:
SETTLEMENTPOINT, SETLPOINTTYPE, SETLPOINTHISTORY

MPs will need to baseline these tables using PRDE. Daily changes will be
included in the extract just as they are for other dimensional tables.

***Updates to COPS, RMS and DEWG, so MPs can update their DDLs.

Draft DDL

Code should add tables and the PITS logic of the extract should be the
same as it is today




THIS EXTRACT IS USED ONLY WHEN DATA REPAIRS/PATCHES NEED TO
OCCUR IN THE MARKET.
STATUS:                                        COMPLETE as of 5/30/08

Name:                                          Provide Public Data Extract
Basic Info
 Master List Number:                           COMS - 452
 Short Name:                                   WS - PRDE
 Business Contact:                             J. Lavas
 Report or Extract:                            Web Service
 Data Source:                                  Lodestar
 Generating System:                            ODS
 Archival System:                              MIR
 Format(s):                                    csv, xml
 Display or Delivery System:                   MIS Certified, TML Private, API
 MP Recipient(s):                              TDSP, LSE
 DEWG SLA Level:                               n/a
 Protocol Reference:                           P 12.4.4.2.3.2.
                                               Retail Market Guide - section 7.1.3
                                               SCR 740
TML Info
 Post on TML or MIS?:                          BOTH - Modified version will post in both locations

 TML Report ID:
 TML Folder Name:                              Market Data Transparency; Data Request - Status
MIS Info
 MIS Report ID:                                1007
 MIS Folder Name:                              Market Data Transparency; Data Request - Status
 MIS File Display Name Format(s):
 MIS Display Lifespan:                         14 dats
 MIS DDL Version(s):                           Same DDL as Zonal for MDT
                                               XMLXSD
 Landing Page:                                 Retail - Certified
 Portlet:                                      Retail Data Request
                                               Retail Report/Extract (Certified)
Schedule Info
  Frequency:                                   On Demand
  Days of Week:
  Generation Time of Day:                      As needed
  PITS Range Logic:                            As requested
  Trade Date Range Logic:                      As requested
  Available on Extract Scheduler?:             No
Project Info                                   EDW
Business Requirements Due Date                 5/15/2008
EDS Delivery Date                              9/1/2008



Complete List of ALL MDT Web Services
Provide ESIID Account Records
Provide ESIIDs I Own for a Trade Date
Provide CMZONE Assignments for a Trade Date
Provide NON-IDR Transaction Data for ESIIDs I Own
Provide IDR Transaction Data for ESIIDs I Own
Provide NON-IDR Usage Data for a Trade Date
Provide ESIIDs Where NON-IDR Usage Data Not Loaded for a Trade Date
Provide IDR Usage Data for a Trade Date
Provide ESIIDs Where IDR Usage Data Not Loaded for a Trade Date
Provide NON-IDR Usage Data for ESIIDs I Own
Provide IDR Usage Data for ESIIDs I Own
Verify Records Used in Data Aggregation for a Trade Date
Provide All ESIID Extract Records
Provide ESIID Extract Records for Logical Keys
Provide Public Data Extract
Business Notes:
-Add new dimensional tables for Settlement Points:
SETTLEMENTPOINT, SETLPOINTTYPE, SETLPOINTHISTORY

***Updates to COPS, RMS and DEWG, so MPs can update their DDLs.

Draft XSDs, etc.

Code should add tables and the PITS logic of the extract should be the
same as it is today
STATUS:                                         COMPLETE as of 5/30/08

Name:                                           Provide all ESIID Extract Records
Basic Info
 Master List Number:                            Coms - 438
 Short Name:                                    WS-ESIID Ext Records
 Business Contact:                              J. Lavas
 Report or Extract:                             Web Service
 Data Source:                                   Lodestar
 Generating System:                             ODS
 Archival System:                               MIR
 Format(s):                                     csv, xml
 Display or Delivery System:                    MIS Certified, TML Private, API
 MP Recipient(s):                               LSE, TDSP
 DEWG SLA Level:                                n/a
 Protocol Reference:                            P 12.4.4.2.3.2.
                                                Retail Market Guide - section 7.1.3
                                                SCR 740
TML Info
 Posted on TML?:                                BOTH - Modified version will post in both locations

 TML Report ID:
 TML Report Explorer Folder:                    Market Data Transparency; Data Request - Status
MIS Info
 MIS Report ID:                                 1007
 MIS Folder Name:                               Market Data Transparency; Data Request - Status
 MIS File Display Name Format(s):
 MIS Display Lifespan:                          14 days
 MIS DDL Version(s):                            Same DDL as Zonal for MDT
                                                XMLXSD
 Landing Page:                                  Retail - Certified
 Portlet:                                       Retail Data Request
                                                Retail Report/Extract (Certified)
Schedule Info
  Frequency:                                    On Demand
  Days of Week:
  Generation Time of Day:                       As needed
  PITS Range Logic:                             As requested
  Trade Date Range Logic:                       As requested
  Available on Extract Scheduler?:              No
Project Info                                    EDW
Business Requirements Due Date                  5/15/2008
EDS Delivery Date                               9/1/2008



Complete List of ALL MDT Web Services
Provide ESIID Account Records
Provide ESIIDs I Own for a Trade Date
Provide CMZONE Assignments for a Trade Date
Provide NON-IDR Transaction Data for ESIIDs I Own
Provide IDR Transaction Data for ESIIDs I Own
Provide NON-IDR Usage Data for a Trade Date
Provide ESIIDs Where NON-IDR Usage Data Not Loaded for a Trade Date
Provide IDR Usage Data for a Trade Date
Provide ESIIDs Where IDR Usage Data Not Loaded for a Trade Date
Provide NON-IDR Usage Data for ESIIDs I Own
Provide IDR Usage Data for ESIIDs I Own
Verify Records Used in Data Aggregation for a Trade Date
Provide All ESIID Extract Records
Provide ESIID Extract Records for Logical Keys
Provide Public Data Extract
Business Notes:
-Add new dimensional tables for Settlement Points:
SETTLEMENTPOINT, SETLPOINTTYPE, SETLPOINTHISTORY

***Updates to COPS, RMS and DEWG, so MPs can update.

Draft XSD, etc.

Code should add tables and the PITS logic of the WS should be the same
as it is today
STATUS:                                  INCOMPLETE

Name:                                    ESI ID Service History & Usage - Initial
Basic Info
 Master List Number:                     ZP12 - 246
 Short Name:                             727 Initial Extract
 Business Contact:                       J. Lavas
 Report or Extract:                      Extract
 Data Source:                            Lodestar
 Generating System:                      ODS
 Archival System:                        MIR
 Format(s):                              ZIP, CSV
 Display or Delivery System:             MIS Certified, TML Private, API
 MP Recipient(s):                        TDSP, LSE
 DEWG SLA Level:                         n/a
 Protocol Reference:                     P 12.4.4.2.3.2.
                                         Retail Market Guide - section 7.1.3
                                         SCR 740
TML/MIS Info
 Post on TML or MIS?:                    BOTH - Modified version will post in both locations

  TML Report ID:                         223
  TML Folder Name:                       ESIID Extract
  MIS Report ID:                         11120
  MIS Folder Name:                       ESI ID Service History & Usage - Daily
  MIS Display Lifespan:                  30 days
  MIS DDL Version(s):                    1 - Same a zonal?
  Available on MIS Extract Scheduler?:   YES
  Landing Page:                          Retail - Retail Information Certified
MIS Info
  Post to MIS?:
  Same version as TML?:
  MIS Report ID:
  MIS Content Inventory Folder:
  MIS File Display Name Format(s):
  MIS Display Lifespan:
  MIS DDL Version(s):
Schedule Info
  Frequency:
  Days of Week:
  Generation Time of Day:
  PITS Range Logic:
  Trade Date Range Logic:
  Available on Extract Scheduler?:
Project Info                             EDW
Business Requirements Due Date           5/15/2008
EDS Delivery Date                        9/1/2008
Business Notes:
-Add new dimensional tables for Settlement Points:
SETTLEMENTPOINT, SETLPOINTTYPE, SETLPOINTHISTORY

MPs will need to baseline these tables using PRDE. Daily changes will be
included in the extract just as they are for other dimensional tables.

***Updates to COPS, RMS and DEWG, so MPs can update their DDLs.

Draft DDL

Code should add tables and the PITS logic of the extract should be the
same as it is today

***To be disincluded because SIR 11847 will be implemented which will
allow rebaseline of initial information.
STATUS:                                  INCOMPLETE

Name:                                    Verify Records Used in Data Aggregation for a Trade
                                         Date
Basic Info
  Master List Number:                    Coms - 440
  Short Name:                            WS-Data Agg Records
  Business Contact:                      J. Lavas
  Report or Extract:                     Web Service
  Data Source:                           Lodestar
  Generating System:                     ODS
  Archival System:                       MIR
  Format(s):                             csv, xml
  Display or Delivery System:            MIS Certified, TML Private, API
  MP Recipient(s):                       LSE, TDSP
  DEWG SLA Level:
  Protocol Reference:                    SCR 740
TML Info
  Posted on TML?:
  TML Report ID:
  TML Report Explorer Folder:
MIS Info
  Post to MIS?:
  Same version as TML?:
  MIS Report ID:                         11123
  MIS Content Inventory Folder:
  MIS File Display Name Format(s):
  MIS Display Lifespan:
  MIS DDL Version(s):
  Available on MIS Extract Scheduler?:
  Landing Page:                          Retail - Retail Information Certified
Schedule Info
  Frequency:
  Days of Week:
  Generation Time of Day:
  PITS Range Logic:
  Trade Date Range Logic:
  Available on Extract Scheduler?:
Project Info                             EDW
Business Requirements Due Date           5/15/2008
EDS Delivery Date                        9/1/2008
Business Notes:
Table Name:          Schema:
AGGOUTPUTHEADER      NODAL
AGGOUTPUTINTERVAL    NODAL
AGGOUTPUTSCALAR      NODAL
ASMARKET             NODAL
BILLDETERMINANT      LODSTAR
CCPLANT              LODSTAR
CCCONFIGURATION      LODSTAR
CMZONE               LODSTAR
CRRACCOUNTHOLDER     NODAL
CRRAUCTION           NODAL
CRROUTPUTHEADER      NODAL
CRROUTPUTINTERVAL    NODAL
CRROUTPUTSCALAR      NODAL
DAIOUTPUTHEADER      NODAL
DAIOUTPUTINTERVAL    NODAL
DAMOUTPUTHEADER      NODAL
DAMOUTPUTINTERVAL    NODAL
DCTIE                LODSTAR
ELEMENT              NODAL
FACTOR               LODSTAR
FACTORVALUE          LODSTAR
FLOWGATE             NODAL
GENERATOR            LODSTAR
GENERATORSITE        LODSTAR
LLSOUTPUTHEADER      NODAL
LLSOUTPUTINTERVAL    NODAL
LOADRESOURCES        LODSTAR
LOSSCLASS            LODSTAR
MKTCONSTRAINT        NODAL
MKTINPUTHEADER       NODAL
MKTINPUTINTERVAL     NODAL
MKTINPUTSCALAR       NODAL
MKTINPUTSTATUS       NODAL
MRE                  LODSTAR
NOIE                 LODSTAR
PGC                  LODSTAR
PREPROCESSHEADER     NODAL
PREPROCESSINTERVAL   NODAL
PREPROCESSSTATUS     NODAL
PROFILECLASS         LODSTAR
PROFILECUT           LODSTAR
PROFILETYPE          LODSTAR
QSE                  LODSTAR
REP                  LODSTAR
RESOURCEID           LODSTAR
RESOURCENODAL        NODAL
RTMOUTPUTHEADER      NODAL
RTMOUTPUTINTERVAL    NODAL
RTMOUPUTSCALAR       NODAL
RTMOUTPUTSTATUS        NODAL
RUCOUTPUTHEADER        NODAL
RUCOUTPUTINTERVAL      NODAL
RUCOUTPUTSCALAR        NODAL
RUCOUTPUTSTATUS        NODAL
RUCPROCESS             NODAL
SETTLEMENTPOINT        LODSTAR
SETLPOINTTYPE          LODSTAR
SETLPOINTHISTORY       LODSTAR
SID_MKTINPUTHEADER     NODAL
SID_MKTINPUTINTERVAL   NODAL
SID_MKTINPUTSCALAR     NODAL
SID_MKTINPUTSTATUS     NODAL
STARTTYPE              NODAL
STATION                LODSTAR
STATIONSERVICEHIST     LODSTAR
TDSP                   LODSTAR
TELEMETERRESSTATUS     NODAL
UFEZONE                LODSTAR
UOM                    LODSTAR
Column Name:
UIDBILLDETERMINANT    BILLDETERMCODE   PUBLICEXTRACT   BILLDETERMTYPECODE
                220   ACTLOSSFACT      Y               MKTINT
                249   CSCI             Y               ZONAL
                261   DCINADD          Y               ZONAL
                262   DCINADI          Y               ZONAL
                263   DCMET            Y               ZONAL
                264   DCMETD           Y               ZONAL
                265   DCMETI           Y               ZONAL
                266   DCSA             Y               ZONAL
                267   DCSCHEDD         Y               ZONAL
                268   DCSCHEDI         Y               ZONAL
                269   DISTLOSSFACT     Y               MKTINT
                290   FI               Y               ZONAL
                291   FORTLOSSFACT     Y               MKTINT
                293   GSITETOT         N               DAIINT
                295   GSPLITPER        N               AGGINT
                297   GTOTDC           N               DAIINT
                299   GTOTUFE          Y               DAIINT
                300   HR               Y               ZONAL
                301   LACTERCOT        Y               DAIINT
                302   LAFF             Y               ZONAL
                318   LARMRAMT         N               RTMINT
                335   LFORERCOT        Y               DAIINT
                340   LIDRTL           Y               DAIINT
                343   LNIDRTL          Y               DAIINT
                352   LRSQSE           N               AGGINT
                353   LSEGDL           N               LLSINT
                354   LSEGTL           N               LLSINT
                355   LSEGUFE          N               LLSINT
                356   LSEGUNADJ        N               LLSINT
                358   LTNOIETL         Y               DAIINT
                360   LTOTERCOT        Y               ZONAL
                361   LTOTQSE          N               DAIINT
                363   LTOTUFE          Y               DAIINT
                364   LTRANSTL         Y               DAIINT
                365   LUFEZONEUFE      Y               DAIINT
                366   MCPCNS           Y               ZONAL
                367   MCPCRD           Y               ZONAL
                368   MCPCRP           Y               ZONAL
                369   MCPCRS           Y               ZONAL
                370   MCPCRU           Y               ZONAL
                371   MCPCSPC          Y               ZONAL
                372   MCPEL            Y               ZONAL
                373   MCPER            Y               ZONAL
                374   MCPESPC          Y               ZONAL
                375   MCPOOMNS         Y               ZONAL
                376   MCPOOMRD         Y               ZONAL
                377   MCPOOMRS         Y               ZONAL
                378   MCPOOMRU         Y               ZONAL
                379   MSFF             Y               ZONAL
                386   NBLOAD           N               LLSINT
                388   NEBFF            Y               ZONAL
396   NPFF               Y   ZONAL
403   NSOTOT             Y   ZONAL
406   NSSAQTOT           Y   ZONAL
432   PCNSAMT            N   DAMINT
462   PCRDAMT            N   DAMINT
467   PCRRAMT            N   DAMINT
472   PCRUAMT            N   DAMINT
483   RDOTOT             Y   ZONAL
486   RDSAQTOT           Y   ZONAL
508   RROTOT             Y   ZONAL
510   RRSAQTOT           Y   ZONAL
513   RUOTOT             Y   ZONAL
516   RUSAQTOT           Y   ZONAL
525   SCFFF              Y   ZONAL
543   TOTUFE             Y   DAIINT
544   TRANSLOSSFACT      Y
545   TTC                Y   ZONAL
565   UF                 Y   ZONAL
566   UFEDNOIE           Y   DAIINT
567   UFEIDR             Y   DAIINT
568   UFENIDR            Y   DAIINT
569   UFETNOIE           Y   DAIINT
570   UFETRANS           Y   DAIINT
571   UNDBF              Y   ZONAL
572   UNDBP              Y   ZONAL
573   UNPTOL             Y   ZONAL
574   UNUPLIM            Y   ZONAL
683   BSBBILLAMTTOT      Y   ZONAL
684   CSCBEBILLAMTTOT    Y   ZONAL
685   CSCRPBILLAMTTOT    Y   ZONAL
686   EIRMRBILLAMTTOT    Y   ZONAL
687   EOOMBILLAMTTOT     Y   ZONAL
688   EOOMDNBILLAMTTOT   Y   ZONAL
689   LANSPCOOMTOT       Y   ZONAL
690   LANSPCTOT          Y   ZONAL
691   LARDPCOOMTOT       Y   ZONAL
692   LARDPCTOT          Y   ZONAL
693   LARRPCOOMTOT       Y   ZONAL
694   LARRPCTOT          Y   ZONAL
695   LARUPCOOMTOT       Y   ZONAL
696   LARUPCTOT          Y   ZONAL
697   LIBILLAMTTOT       Y   ZONAL
698   LPCRPBILLAMTTOT    Y   ZONAL
699   NPRMRBILLAMTTOT    Y   ZONAL
700   PCOOMBILLAMTTOT    Y   ZONAL
701   RIBILLAMTTOT       Y   ZONAL
702   RMREPBILLAMTTOT    Y   ZONAL
703   SBRMRBILLAMTTOT    Y   ZONAL
704   SURMRBILLAMTTOT    Y   ZONAL
705   URCBILLAMTTOT      Y   ZONAL
706   USRPBILLAMTTOT     Y   ZONAL
707   ZPCRPBILLAMTTOT    Y   ZONAL
 876   LTOTERCOT_UNEXEMPT Y   LLSINT
 934   NLRSLTOTQSE        N   AGGINT
 950   NZIDTOT            Y   ZONAL
2029   LREPUFE            N   DAIINT
2030   LRSLSE             N   DAIINT
2033   TCROWNEDERCOT      Y   ZONAL
2034   CSCCREDITBETOT     Y   ZONAL
2035   CSCCREDITRPTOT     Y   ZONAL
2038   CSCRPQSEBILLAMTTOT Y   ZONAL
2039   CSCBEQSEBILLAMTTOT Y   ZONAL
2615   LREPCOMPETITIVE    N   DAIINT
2926   LERCOTCOMPETITIVE  Y   DAIINT
2936   LBEDNBILLAMTTOT    Y   ZONAL
2945   LBEUPBILLAMTTOT    Y   ZONAL
4931   LTOTQSEMONTH       N   DAIINT
5800   MSDBILLAMTTOT      Y   ZONAL
5806   MSRBILLAMTTOT      Y   ZONAL
5810   LUFE               N   DAIINT
5852   LSL                N   MKTINT
5886   BENABILLAMTTOT     Y   ZONAL
5887   BLABILLAMTTOT      Y   ZONAL
5888   ELAOOMBILLAMTTOT   Y   ZONAL
5889   EOOMAGGBILLAMTTOT Y    ZONAL
5890   EOOMDNAGGBILLAMTTOTY   ZONAL
5891   LABULBILLAMTTOT    Y   ZONAL
5892   LAOOMBILLAMTTOT    Y   ZONAL
5893   LARMRBILLAMTTOT    Y   ZONAL
5894   LBEDNAGGBILLAMTTOT Y   ZONAL
5895   LBEUPAGGBILLAMTTOT Y   ZONAL
5896   PCBULBILLAMTTOT    Y   ZONAL
5897   QLAFBILLAMTTOT     Y   ZONAL
5898   UCRPBILLAMTTOT     Y   ZONAL
5899   LDEFUNADJ          N   LLSINT
5900   LHISUNADJ          N   LLSINT
5901   LMTRUNADJ          N   LLSINT
5902   LTDSPUFE           N   DAIINT
5903   NSLRSOBTOT         Y   ZONAL
5906   MNSOTOT            Y   ZONAL
5908   RULRSOBTOT         Y   ZONAL
5911   MRUOTOT            Y   ZONAL
5913   RDLRSOBTOT         Y   ZONAL
5916   MRDOTOT            Y   ZONAL
5918   RRLRSOBTOT         Y   ZONAL
5921   MRROTOT            Y   ZONAL
5937   LTDSPDL            N   DAIINT
5977   HSL                N   MKTINT
5978   INTERVAL_HOLD      Y   ZONAL
6037   LTOTERCOT_4CP      Y   DAIINT
6077   IRS                N   ZONAL
6078   PAM                N   ZONAL
6079   PAMAMT             N   ZONAL
6080   PAMBILLAMT         N   ZONAL
6081   PAMBILLAMTTOT     Y   ZONAL
6082   PAMBILLQTY        N   ZONAL
6083   PAMPRICE          N   ZONAL
6084   PAMQTY            N   ZONAL
6085   POSLI             N   ZONAL
6086   POSLITOT          Y   ZONAL
6087   POSRI             N   ZONAL
6088   POSRITOT          Y   ZONAL
6089   QPAMAMT           N   ZONAL
6090   QPAMBILLAMT       N   ZONAL
6091   QPAMBILLAMTTOT    Y   ZONAL
6092   QPAMBILLQTY       N   ZONAL
6093   QPAMPRICE         N   ZONAL
6094   QPAMQTY           N   ZONAL
6117   GTOTCM            Y   ZONAL
6177   QNSAMT            N   RTMINT
6197   ACTDISTLOSSFACT   Y   MKTINT
6217   LZLRSQSE
6237   AABP              N   MKTINT
6238   ADJBPD            N   MKTINT
6239   ADJVSS            N   MKTINT
6240   AEBP              N   MKTINT
6242   BLTR              N   AGGINT
6243   BLTRAMT           N   RTMINT
6245   BLTRAMTQSETOT     N   RTMINT
6246   BLTRAMTTOT        Y   RTMINT
6248   BP                N   MKTINT
6249   BPDAMT            N   RTMINT
6251   BPDAMTQSETOT      N   RTMINT
6252   BPDAMTTOT         Y   RTMINT
6255   BSSAFLAG          N   MKTINT
6256   BSSAMT            N   RTMINT
6257   BSSAMTQSETOT      N   RTMINT
6258   BSSAMTTOT         Y   RTMINT
6259   BSSARF            N   RTMINT
6261   BSSEH             N   RTMINT
6262   BSSHREAF          N   RTMINT
6264   CRRBACR           N   CRRINT
6265   CRRBACRTOT        Y   CRRINT
6266   CRRCRRSDA         N   CRRINT
6267   CRRCRRSRT         N   CRRINT
6268   CRRNZREV          N   CRRINT
6269   CRRPOSTOT         Y   CRRINT
6270   CRRRAMT           N   CRRINT
6271   CRRRAMTTOT        Y   CRRINT
6272   CRRSAMTOTOT       N   CRRINT
6273   CRRSAMTRS         N   CRRINT
6274   CRRSAMTTOT        Y   CRRINT
6275   CRRSFTVIOL        Y   MKTINT
6276   CRRZREV           N   CRRINT
6277   DAAIEC            N   PREINT
6278   DAAIECAREA        N   PREINT
6279   DAASREV             N   DAMINT
6280   DACONGRENT          N   DAMINT
6281   DACRRCHTOT          Y   CRRINT
6282   DACRRCRTOT          Y   CRRINT
6283   DACRRSAMT           N   CRRINT
6284   DACRRSAMTTOT        Y   CRRINT
6286   DAE                 N   DAMINT
6287   DAEOCPR             N   PREINT
6288   DAEOCPRCAP          N   PREINT
6289   DAEOCQTY            N   PREINT
6290   DAEOCQTYCAP         N   PREINT
6291   DAEP                N   MKTINT
6292   DAEPAMT             N   DAMINT
6293   DAEPAMTQSETOT       N   DAMINT
6294   DAEPAMTTOT          Y   DAMINT
6296   DAEREV              N   DAMINT
6297   DAERS               N   DAMINT
6298   DAES                N   MKTINT
6299   DAESAMT             N   DAMINT
6300   DAESAMTQSETOT       N   DAMINT
6301   DAESAMTTOT          Y   DAMINT
6303   DAESR               N   MKTINT
6304   DAESRCLPR           N   PREINT
6305   DAESRTV             N   DAMINT
6306   DAETOT              Y   DAMINT
6307   DAFGR               N   MKTINT
6308   DAFGRAMT            N   CRRINT
6309   DAFGRAMTOTOT        N   CRRINT
6310   DAFGRAMTTOT         Y   CRRINT
6312   DAFGRDA             N   CRRINT
6313   DAFGRHV             N   CRRINT
6314   DAFGRHVPR           N   CRRINT
6315   DAFGRPR             N   CRRINT
6316   DAFGRTP             N   CRRINT
6317   DAHSL               N   MKTINT
6318   DALSL               N   MKTINT
6319   DAMCOMMITFLAG       N   MKTINT
6320   DAMEO               N   MKTINT
6321   DAMGCOST            N   DAMINT
6322   DAMSELFCOMMITFLAG   N   MKTINT
6323   DAMSUFLAG           N   PREINT
6324   DAMWAMT             N   DAMINT
6325   DAMWAMTQSETOT       N   DAMINT
6326   DAMWAMTRMR          N   DAMINT
6327   DAMWAMTTOT          Y   DAMINT
6329   DAMWENEFLAG         N   PREINT
6330   DAMWRMRREV          N   DAMINT
6331   DAMWRMRREVQSETOT    N   DAMINT
6332   DANSAMT             N   DAMINT
6334   DANSCP              N   MKTINT
6335   DANSCS              N   MKTINT
6336   DANSO               N   MKTINT
6337   DANSONET        N   DAMINT
6338   DANSPR          N   DAMINT
6339   DANSQ           N   DAMINT
6340   DANSQTOT        Y   DAMINT
6341   DANSSQ          N   DAMINT
6342   DAOBL           N   MKTINT
6343   DAOBLAMT        N   CRRINT
6344   DAOBLAMTOTOT    N   CRRINT
6346   DAOBLCHOTOT     N   CRRINT
6347   DAOBLCHTOT      Y   CRRINT
6348   DAOBLCROTOT     N   CRRINT
6349   DAOBLCRTOT      Y   CRRINT
6350   DAOBLDA         N   CRRINT
6351   DAOBLHV         N   CRRINT
6352   DAOBLHVPR       N   CRRINT
6353   DAOBLPR         N   CRRINT
6354   DAOBLR          N   MKTINT
6355   DAOBLRAMT       N   CRRINT
6356   DAOBLRAMTOTOT   N   CRRINT
6358   DAOBLRCHOTOT    N   CRRINT
6359   DAOBLRCHTOT     Y   CRRINT
6360   DAOBLRCROTOT    N   CRRINT
6361   DAOBLRCRTOT     Y   CRRINT
6362   DAOBLRDA        N   CRRINT
6363   DAOBLRHV        N   CRRINT
6364   DAOBLRTP        N   CRRINT
6365   DAOBLTP         N   CRRINT
6366   DAOPT           N   CRRINT
6367   DAOPTAMT        N   CRRINT
6368   DAOPTAMTOTOT    N   CRRINT
6369   DAOPTAMTTOT     N   CRRINT
6371   DAOPTDA         N   CRRINT
6372   DAOPTHV         N   CRRINT
6373   DAOPTHVPR       N   CRRINT
6374   DAOPTPR         N   CRRINT
6375   DAOPTR          N   CRRINT
6376   DAOPTRAMT       N   CRRINT
6377   DAOPTRAMTOTOT   N   CRRINT
6378   DAOPTRAMTTOT    Y   CRRINT
6380   DAOPTRDA        N   CRRINT
6381   DAOPTRHV        N   CRRINT
6382   DAOPTRTP        N   CRRINT
6383   DAOPTTP         N   CRRINT
6384   DARDAMT         N   DAMINT
6386   DARDCP          N   MKTINT
6387   DARDCS          N   MKTINT
6388   DARDO           N   MKTINT
6389   DARDONET        N   DAMINT
6390   DARDPR          N   DAMINT
6391   DARDQ           N   DAMINT
6392   DARDQTOT        Y   DAMINT
6393   DARDSQ          N   DAMINT
6394   DARRAMT            N   DAMINT
6396   DARRCP             N   MKTINT
6397   DARRCS             N   MKTINT
6398   DARRO              N   MKTINT
6399   DARRONET           N   DAMINT
6400   DARRPR             N   DAMINT
6401   DARRQ              N   DAMINT
6402   DARRQTOT           Y   DAMINT
6403   DARRSQ             N   DAMINT
6404   DARTOBLAMT         N   DAMINT
6405   DARTOBLAMTQSETOT   N   DAMINT
6406   DARTOBLAMTTOT      Y   DAMINT
6408   DARUAMT            N   DAMINT
6410   DARUCP             N   MKTINT
6411   DARUCS             N   MKTINT
6412   DARUO              N   MKTINT
6413   DARUONET           N   DAMINT
6414   DARUPR             N   DAMINT
6415   DARUQ              N   DAMINT
6416   DARUQTOT           Y   DAMINT
6417   DARUSQ             N   DAMINT
6418   DASANSQ            N   MKTINT
6419   DASARDQ            N   MKTINT
6420   DASARRQ            N   MKTINT
6421   DASARUQ            N   MKTINT
6422   DASP               N   MKTINT
6423   DASPP              N   MKTINT
6424   DASTARTTYPE        N   MKTINT
6425   DASUO              N   MKTINT
6426   DAWASF             Y   MKTINT
6429   DRF                Y   CRRINT
6431   EBPWAPR            N   MKTINT
6432   EECP               N   MKTSCA
6433   EMRE               N   MKTINT
6434   EMREAMT            N   RTMINT
6435   EMREAMTQSETOT      N   RTMINT
6436   EMREAMTTOT         Y   RTMINT
6438   EMREPR             N   RTMINT
6439   EOCPR              N   PREINT
6440   EOCPRCAP           N   PREINT
6441   EOCQTY             N   PREINT
6442   EOCQTYCAP          N   PREINT
6443   ESACAMT            N   RTMINT
6445   FGRDRPR            N   CRRINT
6446   FGRPAMT            N   CRRINT
6447   FGRSAMT            N   CRRINT
6452   GRCF               N   AGGINT
6453   HASLADJ            N   MKTINT
6454   HASLSNAP           N   MKTINT
6455   HLRS               N   AGGINT
6456   HSLAIECAREA        N   PREINT
6460   LABPDAMT           N   RTMINT
6462   LABSSAMT          N   RTMINT
6464   LACMRNZAMT        N   CRRSCA
6466   LACMRZAMT         N   CRRSCA
6468   LACRRAMT          N   CRRSCA
6469   LADAMWAMT         N   DAMINT
6471   LAEMREAMT         N   RTMINT
6473   LARTRNAMT         N   RTMINT
6475   LARUCAMT          N   RUCINT
6477   LARUCCBAMT        N   RUCINT
6479   LARUCDCAMT        N   RUCINT
6481   LAVSSAMT          N   RTMINT
6483   LERCOTDL          Y   DAIINT
6484   LERCOTUNADJ       Y   DAIINT
6485   LIDRTOT           Y   DAIINT
6486   LNIDRTOT          Y   DAIINT
6487   LRS               N   AGGINT
6488   LSPWTHR           Y   DAIINT
6489   LWTHR             Y   DAIINT
6491   MAXRESPR          Y   CRRINT
6492   MAXRESPRVALUE     N   CRRINT
6493   MAXRESRPR         N   CRRINT
6494   MCPCRR            Y   MKTINT
6495   MEB               N   AGGINT
6496   MEBMP             N   DAIINT
6497   MEO               N   MKTINT
6498   MEPR              N   RUCINT
6500   MINRESPR          Y   CRRINT
6501   MINRESPRVALUE     N   CRRINT
6502   MINRESRPR         N   CRRINT
6503   MLRS              N   AGGSCA
6504   MLRSZ             N   AGGSCA
6505   MONPEAK           Y   AGGSCA
6506   NCDCHR            N   RUCINT
6507   NDRTFGRAMT        N   CRRINT
6508   NDRTFGRAMTOTOT    N   CRRINT
6509   NDRTFGRAMTTOT     Y   CRRINT
6511   NDRTFGRPR         N   MKTINT
6512   NDRTFGRTP         N   CRRINT
6513   NDRTOBLAMT        N   CRRINT
6514   NDRTOBLAMTOTOT    N   CRRINT
6515   NDRTOBLAMTTOT     Y   CRRINT
6517   NDRTOBLRAMT       N   CRRINT
6518   NDRTOBLRAMTOTOT   N   CRRINT
6519   NDRTOBLRAMTTOT    Y   CRRINT
6521   NDRTOBLRTP        N   CRRINT
6522   NDRTOPTAMT        N   CRRINT
6523   NDRTOPTAMTOTOT    N   CRRINT
6524   NDRTOPTAMTTOT     Y   CRRINT
6526   NDRTOPTRAMT       N   CRRINT
6527   NDRTOPTRAMTOTOT   N   CRRINT
6528   NDRTOPTRAMTTOT    Y   CRRINT
6530   NDRTOPTRTP        N   CRRINT
6531   NDRTOPTTP      N   CRRINT
6532   NMRTETOT       N   AGGINT
6533   NMRTETOTMP     N   DAIINT
6534   NMSAMTTOT      N   RTMINT
6535   NSCOST         N   RTMINT
6536   NSCOSTTOT      Y   RTMINT
6537   NSCP           N   RTMINT
6538   NSCS           N   RTMINT
6539   NSFQ           N   RTMINT
6540   NSFQAMT        N   RTMINT
6542   NSFQAMTTOT     Y   RTMINT
6544   NSONET         N   RTMINT
6545   NSPR           Y   RTMINT
6546   NSQTOT         Y   RTMINT
6547   NSRP           N   RTMINT
6548   NSSQ           N   RTMINT
6549   NZFGRPAMT      N   CRRINT
6550   NZFGRSAMT      N   CRRINT
6551   NZOBLPAMT      N   CRRINT
6552   NZOBLSAMT      N   CRRINT
6553   NZOPTPAMT      N   CRRINT
6554   NZOPTSAMT      N   CRRINT
6555   NZPCRROBLAMT   N   CRRINT
6556   NZPCRROPTAMT   N   CRRINT
6557   OBLDRPR        N   CRRINT
6558   OBLPAMT        N   CRRINT
6559   OBLRACT        N   MKTINT
6560   OBLSAMT        N   CRRINT
6565   OPT            N   MKTINT
6566   OPTDRPR        N   CRRINT
6567   OPTPAMT        N   CRRINT
6568   OPTR           N   MKTINT
6569   OPTRACT        N   MKTINT
6570   OPTSAMT        N   CRRINT
6572   PCNS           N   DAMINT
6573   PCNSAMTTOT     Y   DAMINT
6574   PCNSR          N   DAMINT
6575   PCRD           N   DAMINT
6576   PCRDAMTTOT     Y   DAMINT
6577   PCRDR          N   DAMINT
6578   PCRR           N   DAMINT
6579   PCRRAMTTOT     Y   DAMINT
6580   PCRRNZREV      N   CRRSCA
6581   PCRROBLAMT     N   CRRSCA
6582   PCRROPTAMT     N   CRRSCA
6583   PCRRR          N   DAMINT
6584   PCRRZREV       N   CRRSCA
6585   PCRU           N   DAMINT
6586   PCRUAMTTOT     Y   DAMINT
6587   PCRUR          N   MKTINT
6589   QCLAW          N   PREINT
6590   QSEZONLRS      N   AGGINT
6591   RDCOST           N   RTMINT
6592   RDCOSTTOT        Y   RTMINT
6593   RDCP             N   RTMINT
6594   RDCS             N   RTMINT
6595   RDFQ             N   RTMINT
6596   RDFQAMT          N   RTMINT
6598   RDFQAMTTOT       Y   RTMINT
6600   RDONET           N   RTMINT
6601   RDPR             Y   RTMINT
6602   RDQTOT           Y   RTMINT
6603   RDRP             N   RTMINT
6604   RDSQ             N   RTMINT
6605   RMRAAMT          N   RTMINT
6606   RMRAAMTQSETOT    N   RTMINT
6607   RMRAAMTTOT       Y   RTMINT
6609   RMRAFLAG         N   MKTINT
6610   RMRALLOCFLAG     N   PREINT
6611   RMRARF           N   RTMINT
6615   RMRCRF           N   RTMINT
6616   RMRDAEREVTOT     Y   DAMINT
6617   RMRDAESRTVTOT    Y   RTMINT
6618   RMRDAMWREVTOT    Y   DAMINT
6619   RMREAMT          N   RTMINT
6620   RMREAMTQSETOT    N   RTMINT
6621   RMREAMTTOT       Y   RTMINT
6623   RMREH            N   RTMINT
6624   RMRHREAF         N   RTMINT
6625   RMRMFCOST        N   RTMINT
6626   RMRNPAMT         N   RTMINT
6627   RMRNPAMTQSETOT   N   RTMINT
6628   RMRNPAMTTOT      Y   RTMINT
6630   RMRNPFLAG        N   MKTSCA
6631   RMRSBAMT         N   RTMINT
6632   RMRSBAMTQSETOT   N   RTMINT
6633   RMRSBAMTTOT      Y   RTMINT
6635   RMRSBPR          N   RTMINT
6636   RMRSUFQ          N   RTMINT
6637   RRCOST           N   RTMINT
6638   RRCOSTTOT        Y   RTMINT
6639   RRCP             N   RTMINT
6640   RRCS             N   RTMINT
6641   RRFQ             N   RTMINT
6642   RRFQAMT          N   RTMINT
6644   RRFQAMTTOT       Y   RTMINT
6646   RRONET           N   RTMINT
6647   RRPR             Y   RTMINT
6648   RRQ              N   RTMINT
6649   RRQTOT           Y   RTMINT
6650   RRRP             N   RTMINT
6651   RRSQ             N   RTMINT
6653   RTAIEC           N   PREINT
6654   RTAIECAREA       N   PREINT
6655   RTAML              N   AGGINT
6656   RTAMLLZTOT         Y   DAISCA
6657   RTAMLTOT           Y   AGGINT
6658   RTCCAMT            N   RTMINT
6660   RTCCAMTQSETOT      N   RTMINT
6661   RTCCAMTTOT         Y   RTMINT
6663   RTCRRSAMT          N   CRRINT
6665   RTDCEXP            N   MKTINT
6666   RTDCEXPAMT         N   RTMINT
6668   RTDCEXPAMTQSETOT   N   RTMINT
6669   RTDCEXPAMTTOT      Y   RTMINT
6671   RTDCIMP            N   MKTINT
6672   RTDCIMPAMT         N   RTMINT
6674   RTDCIMPAMTQSETOT   N   RTMINT
6675   RTDCIMPAMTTOT      Y   RTMINT
6677   RTDCNEEXP          N   MKTINT
6678   RTEDCIMP           N   MKTINT
6679   RTEDCIMPAMT        N   RTMINT
6680   RTEIAMT            N   RTMINT
6682   RTEIAMTQSETOT      N   RTMINT
6683   RTEIAMTTOT         Y   RTMINT
6685   RTHSLAIEC          N   PREINT
6686   RTICHSL            N   RTMINT
6687   RTMG               N   AGGINT
6688   RTMGCLPR           N   PREINT
6689   RTMGNM             N   AGGINT
6690   RTNSAMT            N   RTMINT
6692   RTNSCP             N   MKTINT
6693   RTNSCS             N   MKTINT
6694   RTNSSQ             N   MKTINT
6695   RTOBL              N   MKTINT
6696   RTOBLAMT           N   CRRINT
6697   RTOBLAMTQSETOT     N   CRRINT
6698   RTOBLAMTTOT        Y   CRRINT
6700   RTOBLPR            N   CRRINT
6701   RTOPT              N   MKTINT
6702   RTOPTAMT           N   CRRINT
6703   RTOPTAMTOTOT       N   CRRINT
6704   RTOPTAMTTOT        Y   CRRINT
6706   RTOPTDA            N   CRRINT
6707   RTOPTHV            N   CRRINT
6708   RTOPTHVPR          N   CRRINT
6709   RTOPTPR            N   CRRINT
6710   RTOPTR             N   CRRINT
6711   RTOPTRAMT          N   CRRINT
6712   RTOPTRAMTOTOT      N   CRRINT
6713   RTOPTRAMTTOT       Y   CRRINT
6715   RTOPTRDA           N   CRRINT
6716   RTOPTRHV           N   CRRINT
6717   RTOPTRTP           N   CRRINT
6718   RTOPTTP            N   CRRINT
6719   RTPCNS             N   RTMINT
6720   RTPCNSAMT         N   RTMINT
6722   RTPCNSAMTQSETOT   N   RTMINT
6723   RTPCNSAMTTOT      Y   RTMINT
6725   RTPCNSR           N   MKTINT
6726   RTPCRD            N   RTMINT
6727   RTPCRDAMT         N   RTMINT
6729   RTPCRDAMTQSETOT   N   RTMINT
6730   RTPCRDAMTTOT      Y   RTMINT
6732   RTPCRDR           N   MKTINT
6733   RTPCRR            N   RTMINT
6734   RTPCRRAMT         N   RTMINT
6736   RTPCRRAMTQSETOT   N   RTMINT
6737   RTPCRRAMTTOT      Y   RTMINT
6739   RTPCRRR           N   MKTINT
6740   RTPCRU            N   RTMINT
6741   RTPCRUAMT         N   RTMINT
6743   RTPCRUAMTQSETOT   N   RTMINT
6744   RTPCRUAMTTOT      Y   RTMINT
6746   RTPCRUR           N   MKTINT
6747   RTQQEP            N   MKTINT
6748   RTQQEPADJ         N   MKTINT
6749   RTQQEPSNAP        N   MKTINT
6750   RTQQES            N   MKTINT
6751   RTQQESADJ         N   MKTINT
6752   RTQQESSNAP        N   MKTINT
6753   RTRDAMT           N   RTMINT
6755   RTRDCP            N   MKTINT
6756   RTRDCS            N   MKTINT
6757   RTRDSQ            N   MKTINT
6758   RTRMPR            N   RTMINT
6759   RTRRAMT           N   RTMINT
6761   RTRRCP            N   MKTINT
6762   RTRRCS            N   MKTINT
6763   RTRRSQ            N   MKTINT
6764   RTRUAMT           N   RTMINT
6766   RTRUCP            N   MKTINT
6767   RTRUCS            N   MKTINT
6768   RTRUSQ            N   MKTINT
6769   RTSANSQ           N   MKTINT
6770   RTSARDQ           N   MKTINT
6771   RTSARRQ           N   MKTINT
6772   RTSARUQ           N   MKTINT
6773   RTSPP             Y   MKTINT
6775   RTVSSAIEC         N   PREINT
6776   RUC               N   MKTINT
6777   RUCCAPADJ         N   RUCINT
6778   RUCCAPCREDIT      N   RUCINT
6779   RUCCAPSNAP        N   RUCINT
6780   RUCCAPTOT         Y   RUCINT
6781   RUCCBAMT          N   RUCINT
6782   RUCCBAMTQSETOT    N   RUCINT
6783   RUCCBAMTTOT       Y   RUCINT
6786   RUCCBFC          N   RUCSCA
6787   RUCCBFR          N   RUCSCA
6788   RUCCPADJ         N   MKTINT
6789   RUCCPSNAP        N   MKTINT
6790   RUCCSADJ         N   MKTINT
6791   RUCCSAMT         N   RUCINT
6792   RUCCSAMTQSETOT   N   RUCINT
6793   RUCCSAMTTOT      Y   RUCINT
6795   RUCCSSNAP        N   MKTINT
6796   RUCD             N   MKTINT
6797   RUCDADJ          N   MKTINT
6798   RUCDCAMT         N   RUCINT
6799   RUCDCAMTQSETOT   N   RUCINT
6800   RUCDCAMTTOT      Y   RUCINT
6803   RUCDFLAG         N   PREINT
6804   RUCDSTARTTYPE    N   PREINT
6805   RUCEXRQC         N   RUCSCA
6807   RUCEXRR          N   RUCSCA
6809   RUCG             N   RUCSCA
6810   RUCGADJ          N   MKTINT
6811   RUCGME           N   RUCINT
6812   RUCGSU           N   RUCINT
6813   RUCHR            N   RUCINT
6814   RUCHSL           N   MKTINT
6815   RUCMEREV         N   RUCSCA
6817   RUCMWAMT         N   RUCINT
6818   RUCMWAMTQSETOT   N   RUCINT
6819   RUCMWAMTRUCTOT   Y   RUCINT
6821   RUCMWAMTTOT      Y   RUCINT
6824   RUCOST           N   RTMINT
6825   RUCOSTTOT        Y   RTMINT
6826   RUCP             N   RTMINT
6827   RUCS             N   RTMINT
6828   RUCSF            N   RUCINT
6829   RUCSFADJ         N   RUCINT
6830   RUCSFRS          N   RUCINT
6831   RUCSFSNAP        N   RUCINT
6832   RUCSFTOT         Y   RUCINT
6833   RUCSUFLAG        N   PREINT
6834   RUFQ             N   RTMINT
6835   RUFQAMT          N   RTMINT
6837   RUFQAMTTOT       Y   RTMINT
6839   RUONET           N   RTMINT
6840   RUPR             Y   RTMINT
6841   RUQTOT           Y   RTMINT
6842   RURP             N   RTMINT
6843   RUSQ             N   RTMINT
6844   SEASMWCAP        N   INTERNAL
6845   SELFCOMMITFLAG   N   PREINT
6849   SSQ              N   MKTINT
6850   SSSK             N   MKTINT
6851   SSSR             N   MKTINT
6852   STARTTYPE          N   MKTINT
6853   STATUSSNAP         N   MKTINT
6854   SUFLAG             N   PREINT
6857   TOFO               N   MKTSCA
6858   TWOS               N   MKTINT
6859   TWTG               N   MKTINT
6860   URLLAG             N   RTMINT
6861   URLLEAD            N   RTMINT
6862   VERIME             N   RUCINT
6865   VOMLSL             N   PREINT
6867   VSSAIECAREA        N   PREINT
6868   VSSEAMT            N   RTMINT
6869   VSSEAMTQSETOT      N   RTMINT
6870   VSSEAMTTOT         Y   RTMINT
6872   VSSENIOL           N   MKTINT
6873   VSSVARAMT          N   RTMINT
6874   VSSVARAMTQSETOT    N   RTMINT
6875   VSSVARAMTTOT       Y   RTMINT
6877   VSSVARIOL          N   MKTINT
6880   VTPSOFLAG          N   MKTSCA
6921   ZFGRPAMT           N   CRRINT
6922   ZFGRSAMT           N   CRRINT
6923   ZOBLPAMT           N   CRRINT
6924   ZOBLSAMT           N   CRRINT
6925   ZOPTPAMT           N   CRRINT
6926   ZOPTSAMT           N   CRRINT
6927   ZPCRROBLAMT        N   CRRINT
6928   ZPCRROPTAMT        N   CRRINT
6929   DAMRTOPTPR         N   CRRINT
6930   DAMRTOPTHVPR       N   CRRINT
6931   DAMRTOPTTP         N   CRRINT
6932   DAMRTOPTDA         N   CRRINT
6933   DAMRTOPTHV         N   CRRINT
6934   DAMRTOPTAMT        N   CRRINT
6935   DAMRTOPTAMTOTOT    N   CRRINT
6936   DAMRTOPTAMTTOT     Y   CRRINT
6937   DAMRTOPTRTP        N   CRRINT
6938   DAMRTOPTRDA        N   CRRINT
6939   DAMRTOPTRHV        N   CRRINT
6940   DAMRTOPTRAMT       N   CRRINT
6941   DAMRTOPTRAMTOTOT   N   CRRINT
6942   DAMRTOPTRAMTTOT    Y   CRRINT
6947   PTPSRSKTOT         Y   CRRINT
6948   FGRTOT             Y   CRRINT
6975   RMRCEFA            N   RTMINT
6978   RTVAR              N   MKTINT
6980   SUO                N   MKTINT
6981   SUPR               N   RUCINT
6982   VERISU             N   RUCINT
6983   VFCLSL             N   PREINT
6984   VOMS               N   PREINT
6985   VSSVARLAG          N   RTMINT
6986   VSSVARLEAD        N   RTMINT
6987   LPROFILETYPE      Y   DAIINT
6990   LARMRAMTQSETOT    N   RTMINT
6991   LARMRAMTTOT       Y   RTMINT
6992   GTOTLZ            Y   DAIINT
6997   DAPERFOP          Y   MKTINT
6998   DAPERFIP          Y   MKTINT
6999   RTPERFIP          Y   MKTINT
7000   RTPERFOP          Y   MKTINT
7001   SARUQ             N   RTMINT
7002   SARDQ             N   RTMINT
7003   SANSQ             N   RTMINT
7004   SARRQ             N   RTMINT
7017   DAMTFLAG          N   PREINT
7018   DAMWAMTCC         N   DAMINT
7037   DAMRTCRRSAMT      N   CRRINT
7039   DACRRSR           N   CRRINT
7040   DACRRSRTAMT       N   CRRINT
7041   DAMCRRCRRSRT      N   CRRINT
7042   DAMRTCRRSAMTTOT   Y   CRRINT
BILLDETERMNAME
ACTUAL TRANSMISSION LOSS FACTOR
CSC IMPACT
DC TIE DAILY VALUES FOR INADVERTENT ENERGY
DC TIE VALUES FOR INADVERTENT ENERGY
DCTIE METER
DC TIE DAILY VALUES FOR THE METER
DC TIE VALUES FOR THE METER
DC TIE SCHEDULE ADJUSTMENT
DC TIE DAILY VALUES FOR SCHEDULES
DC TIE VALUES FOR SCHEDULES
DISTRIBUTION LOSS FACTORS
FUEL INDEX
FORCASTED LOSS FACTOR
GENERATION SITE TOTAL GENERATION
GENERATION SITE TOTALS BY PGC
DC TIE GENERATION TOTALS BY QSE
TOTAL GENERATION BY UFE ZONE
HEAT RATE
ACTUAL ERCOT LOAD
LOAD ADMIN FEE FACTOR
RMR SERVICE CHARGE AMOUNT
ERCOT FORECASTED LOAD
LOAD FOR IDR PREMISES ADJ FOR TRANSMISSION LOSSES
LOAD FOR NIDR PREMISES ADJ FOR TRANSMISSION LOSSES
LOAD RATIO SHARE FOR QSE ERCOT WIDE
LOAD BY SEGMENT ADJUSTED FOR DISTRIBUTION LOSSES
LOAD BY SEGMENT ADJUSTED FOR TRANSMISSION LOSSES
BUCKET LOAD
LOAD BY SEGMENT UNADJUSTED
LOAD FOR TRANSMISSION NOIE PREMISES ADJ FOR TRANSMISSION LOSSES
ERCOT TOTAL LOAD
LOAD TOTALS BY QSE
LOAD TOTAL BY UFE ZONE
LOAD FOR TRANSMISSION PREMISES ADJ FOR TRANSMISSION LOSSES
NET LOAD BY UFE ZONE
MARKET CLEARING PRICE FOR NON-SPINNING RESERVE
MARKET CLEARING PRICE FOR REGULATION DOWN RESERVE
MARKET CLEARING PRICE OF CAPACITY FOR REPLACEMENT RESERVE
MARKET CLEARING PRICE FOR RESPONSIVE RESERVE
MARKET CLEARING PRICE FOR REGULATION UP RESERVE
SHADOW CLEARING PRICE FOR CSC CAPACITY
MARKET CLEARING PRICE FOR LOAD ENERGY
MARKET CLEARING PRICE FOR RESOURCE ENERGY
SHADOW CLEARING PRICE FOR CSC ENERGY
MARKET CLEARING PRICE FOR OOM NON-SPINNING RESERVE
MARKET CLEARING PRICE FOR OOM REGULATION DOWN RESERVE
MARKET CLEARING PRICE FOR OOM RESPONSIVE RESERVE
MARKET CLEARING PRICE FOR OOM REGULATION UP RESERVE
MIS-MATCHED SCHEDULE FEE FACTOR
NOIE BASE LOAD
NON-ERCOT PARTICIPANT BASE FEE FACTOR
RMR NON-PERFORMANCE FEE FACTOR
TOTAL OBLIGATED NON-SPINNING QUANTITY
TOTAL NON-SPINNING SELF ARRANGED QUANTITY
NON SPINNING RESERVE SERVICE PAYMENT AMOUNT
REGULATION DOWN SERVICE PAYMENT AMOUNT
RESPONSIVE RESERVE SERVICE PAYMENT AMOUNT
REGULATION UP SERVICE PAYMENT AMOUNT
TOTAL OBLIGATED REGULATION DOWN QUANTITY
TOTAL REGULATION DOWN SELF ARRANGED QUANTITY
TOTAL OBLIGATED RESPONSIVE RESERVE QUANTITY
TOTAL RESPONSIVE RESERVE SELF ARRANGED QUANTITY
TOTAL OBLIGATED REGULATION UP QUANTITY
TOTAL REGULATION UP SELF ARRANGED QUANTITY
SYSTEM CONGESTION FUND FEE FACTOR
TOTAL UFE LOSSES BY UFE ZONE
TRANSMISSION LOSS FACTORS
TOTAL TRANSFER CAPACITY
UNINSTRUCTED FACTOR
UFE FOR DISTRIBUTION NOIE PREMISES
UFE FOR IDR PREMISES
UFE FOR NIDR PREMISES
UFE FOR TRANSMISSION NOIE PREMISES
UFE FOR TRANSMISSION PREMISES
UNINSTRUCTED DEAD BAND FACTOR
UNINSTRUCTED DEAD BAND PERCENTAGE
UNINSTRUCTED TOLERANCE
UNINSTRUCTED UPPER LIMIT
BLACK START STANDY BILL AMOUNT ERCOT TOTAL
BALANCING ENERGY CSC COSTS BILLAMT ERCOT TOTAL
REPLACEMENT RESERVE SERVICE ZONAL CONGESTION CHARGE BILLAMT TOTA
RMR RESOURCE IMBALANCE PAYMENT BILL AMOUNT ERCOT TOTAL
OOM ENERGY PAYMENT BILLABLE AMOUNT ERCOT TOT
OOM ENERGY DOWN PAYMENT BILLABLE AMOUNT ERCOT TOTAL
TOTAL OOM NON-SPINNING RESERVE CAPACITY LOAD ALLOCATION
TOTAL NON-SPINNING RESERVE CAPACITY LOAD ALLOCATION
TOTAL OOM REGULATION DOWN RESERVE CAPACITY LOAD ALLOCATION
TOTAL REGULATION DOWN RESRVE CAPACITY LOAD ALLOCATION
TOTAL OOM RESPONSIVE RESRVE CAPACITY LOAD ALLOCATION
TOTAL RESPONSIVE RESRVE CAPACITY LOAD ALLOCATION
TOTAL OOM REGULATION UP RESRVE CAPACITY LOAD ALLOCATION
TOTAL REGULATION UP RESRVE CAPACITY LOAD ALLOCATION
LOAD IMBALANCE BILLABLE AMOUNT ERCOT TOTAL
LOCAL REPLACEMENT RESERVE PAYMENT TO PROVIDER BILLAMT ERCOT TOTA
RMR NON-PERFORMANCE BILL AMOUNT ERCOT TOTAL
OOM REPLACEMENT CAPACITY PAYMENT BILLAMT ERCOT TOTAL
RESOURCE IMBALANCE BILLABLE AMOUNT ERCOT TOTAL
PAYMENT TO PROVIDER FOR RMR ENERGY BILL AMOUNT ERCOT TOTAL
RMR STANDBY FEE BILL AMOUNT ERCOT TOTAL
RMR STARTUP AMOUNT FOR UNIT BILL AMOUNT ERCOT TOTAL
UNISTRUCTED RESOURCE CHARGE BILLABLE AMOUNT ERCOT TOTAL
REPLACEMENT RESERVE SERVICE UNDER-SCHEDULED CHARGE BILLAMT TOTAL
ZONAL OR SYS WIDE REPLACEMNT RESERVE CAPACITY PMT ERCOT TOTAL
TOTAL ERCOT LOAD (INCLUDING EXEMPT LOAD)
LOAD TOTALS BY QSE FOR THE NEGATIVE LOAD RATIO RIDDER
REGULATION RESERVE NON-ZONAL INSTRUCTED DEVIATIONS ERCOT TOTAL
LOAD TOTALS BY REP
LOAD RATIO SHARE PER LOAD ENTITY
TOTAL TCR AUCTION AMOUNT PER CSC
TOTAL CSC CREDIT AMOUNT FOR BALANCING ENERGY
TOTAL CSC CREDIT AMOUNT FOR REPLACEMENT RESERVE
REPLACEMENT RESERVE CSC COSTS BILLABLE AMOUNT ERCOT TOTAL
BALANCING ENERGY CSC COSTS BILLABLE AMOUNT ERCOT TOTAL
LOAD TOTALS BY REP FOR COMPETITIVE LOAD
LOAD TOTALS ERCOT WIDE FOR COMPETITIVE LOAD
LOCAL BALANCING ENERGY DOWN BILL AMOUNT ERCOT TOT
LOCAL BALANCING ENERGY UP BILL AMOUNT ERCOT TOT
LOAD TOTALS BY QSE FOR A MONTH
MISMATCHED INTERQSE SCHEDULE DELIVERED BILL AMT TOT
MISMATCHED INTERQSE SCHEDULE RECEIVED BILL AMT TOT
BUCKET UFE AMOUNT
LOW SUSTAINABLE LIMIT
MARKET TOTAL BALANCING ENERGY NEUTRALITY ALLOCATION BILLABLE AMT
MARKET TOTAL BLACK START LOAD ALLOCATION BILLABLE AMOUNT
MARKET TOTAL OOM ENERGY BILLABLE AMOUNT
MARKET TOTAL AGGREGATED OOM ENERGY PAYMENT BILLABLE AMOUNT
MARKET TOTAL AGGREGATED OOM ENERGY DOWN PAYMENT BILLABLE AMOUNT
MARKET TOTAL LOAD ALLOCATION BUL BILLABLE AMOUNT
MARKET TOTAL OOM REPLACEMENT CAPACITY LOAD ALLOCATN BILLABLE AMT
MARKET TOTAL RMR SERVICE CHARGE BILLABLE AMOUNT
MARKET TOTAL AGGREGATED LOCAL BALANCING ENERGY DOWN BILLABLE AMT
MARKET TOTAL AGGREGATED LOCAL BALANCING ENERGY UP BILLABLE AMT
MARKET TOTAL BUL BILLABLE AMOUNT
MARKET TOTAL QSE LOAD ADMIN FEE BILL AMOUNT
MARKET TOTAL REPLACEMENT RESERVE SERVICE UPLIFT BILLABLE AMOUNT
AGGREGATED DEFAULT PROFILE ESTIMATED BASE LOAD
AGGREGATED HISTORICAL ESTIMATED BASE LOAD
AGGREGATED METERED BASE LOAD
UFE ADJUSTED LOAD TOTAL BY TDSP
NON-SPIN LOAD RATIO SHARE OBLIGATION TOTAL
MARKET NON-SPIN OBLIGATION TOTAL
REG. UP LOAD RATIO SHARE OBLIGATION TOTAL
MARKET REG. UP OBLIGATION TOTAL
REG. DOWN LOAD RATIO SHARE OBLIGATION TOTAL
MARKET REG. DOWN OBLIGATION TOTAL
RESP. RESERVE LOAD RATIO SHARE OBLIGATION TOTAL
MARKET RESP. RESERVE OBLIGATION TOTAL
LOAD FOR OPT IN NOIE ADJUSTED FOR DISTRIBUTION LOSSES
HIGH SUSTAINABLE LIMIT
INTERVAL HOLD FLAG
4CP PEAK LOAD
MCSM IMBALANCE RATIO SHARE
MCSM PAYMENT ABOVE ADJ MCPE INPUT
MCSM PAYMENT ABOVE ADJ MCPE AMT
MCSM PAYMENT ABOVE ADJ MCPE BILL AMT
MCSM PAYMENT ABOVE ADJ MCPE BILL AMT ERCOT TOTAL
MCSM PAYMENT ABOVE ADJ MCPE BILL QTY
MCSM PAYMENT ABOVE ADJ MCPE PRICE
MCSM PAYMENT ABOVE ADJ MCPE QTY
MCSM POSITIVE LOAD IMBALANCE
MCSM POSITIVE LOAD IMBALANCE ERCOT TOTAL
MCSM POSITIVE RESOURCE IMBALANCE
MCSM POSITIVE RESOURCE IMBALANCE ERCOT TOTAL
MCSM QSE SHARE OF PAYMENTS AMT
MCSM QSE SHARE OF PAYMENTS BILL AMT
MCSM QSE SHARE OF PAYMENTS BILL AMT ERCOT TOTAL
MCSM QSE SHARE OF PAYMENTS BILL QTY
MCSM QSE SHARE OF PAYMENTS PRICE
MCSM QSE SHARE OF PAYMENTS QTY
GENERATION TOTALS BY CM ZONE
QSE NODAL SURCHARGE FEE AMOUNT
ACTUAL DISTRIBUTION LOSS FACTORS
ESTIMATED ZONAL LOAD RATIO SHARE FOR QSE
ADJUSTED AGGREGATED BASE POINT
BASE POINT DEVIATION ADJUSTMENT
VOLTAGE SUPPORT SERVICE ADJUSTMENT
AGGREGATED EMERGENCY BASE POINT
BLOCK LOAD TRANSFER RESOURCE
BLOCK LOAD TRANSFER RESOURCE AMOUNT
REAL-TIME BLOCK LOAD TRANSFER PAYMENT AMOUNT QSE TOTAL
BLOCK LOAD TRANSFER RESOURCE AMOUNT MARKET TOTAL
BASE POINT
BASE POINT DEVIATION AMOUNT
BASE-POINT DEVIATION CHARGE AMOUNT QSE TOTAL
BASE POINT DEVIATION AMOUNT MARKET TOTAL
BLACK START SERVICE AVAILABILITY FLAG
BLACK START SERVICE AMOUNT
BLACK START SERVICE PAYMENT AMOUNT QSE TOTAL
BLACK START SERVICE AMOUNT QSE TOTAL ERCOT-WIDE
BLACK START SERVICE AVAILABILITY REDUCTION FACTOR
BLACK START SERVICE ELAPSED NUMBER OF HOURS
BSS HOURLY ROLLING EQUIVALENT AVAILABILITY FACTOR
CRR BALANCING ACCOUNT CREDIT
CRR BALANCING ACCOUNT CREDIT TOTAL
CRR CREDIT RATIO SHARE DAY-AHEAD
CRR CREDIT RATIO SHARE REAL-TIME
CRR NON-ZONAL REVUNUE
CRR TOTAL POSITIVE IMPACT
CRR REFUND AMOUNT
CRR REFUND AMOUNT TOTAL
CRR SHORTFALL AMOUNT OWNER TOTAL
CRR SHORTFALL AMOUNT RATIO SHARE
CRR SHORTFALL AMOUNT TOTAL
CRR SFT VIOLATED AMOUNT
CRR ZONAL REVUNUE
DAY-AHEAD AVERAGE INCREMENTAL ENERGY COST
DAY-AHEAD AVERAGE INCREMENTAL ENERGY COST AREA
DAY-AHEAD ANCILLARY SERVICE REVENUE PER QSE & SETTLE POINT
DAY-AHEAD CONGESTION RENT
DAY-AHEAD CRR CHARGE TOTAL
DAY-AHEAD CRR CREDIT TOTAL
DAY-AHEAD CRR OWNERS SHORTFALL CHARGES AMOUNT
DAY-AHEAD CRR SHORTFALL CHARGES AMOUNT TOTAL
DAY-AHEAD CLEARED ENERGY TOTAL FOR QSE
DAY-AHEAD ENERGY OFFER CURVE PRICE
DAY-AHEAD ENERGY OFFER CURVE PRICE CAP
DAY-AHEAD ENERGY OFFER CURVE QUANTITY
DAY-AHEAD ENERGY OFFER CURVE QUANTITY CAP
DAY-AHEAD ENERGY PURCHASE PER QSE PER SETTLE POINT
DAY-AHEAD ENERGY PURCHASED PER QSE PAYMENT PER SETTLE POINT
DAY-AHEAD ENERGY CHARGE AMOUNT QSE TOTAL
DAY-AHEAD ENERGY PURCHASESERCOT TOTAL
DAY-AHEAD ENERGY REVENUES PER QSE RESOURCE & SETTLE POINT
DAY-AHEAD ENERGY PURCHASE RATIO SHARE PER QSE
DAY-AHEAD ENERGY SALE PER QSE PER SETTLE POINT
DAY-AHEAD ENERGY SALE PER QSE PAYMENT PER SETTLE POINT
DAY-AHEAD ENERGY PAYMENT AMOUNT QSE TOTAL
DAY-AHEAD ENERGY SALES PAYMENTS ERCOT TOTAL
DAY-AHEAD ENERGY SALE PER RESOURCE BY QSE
DAY-AHEAD ENERGY SALE OF A RESOURCE CLEARING PRICE
DAY-AHEAD ENERGY SALE REAL-TIME VALUE
DAY-AHEAD ENERGY TOTAL ERCOT WIDE
DAY-AHEAD FGR
DAY-AHEAD FGR AMOUNT
DAY-AHEAD FGR PAYMENTS AMOUNT OWNER TOTAL
DAY-AHEAD FGR AMOUNT TOTAL
DAY-AHEAD FGR DERATED AMOUNT
DAY-AHEAD FGR HEDGE VALUE
DAY-AHEAD FGR HEDGE VALUE PRICE
DAY-AHEAD FGR PRICE
DAY-AHEAD FGR TARGET PAYMENT
DAY-AHEAD HIGH SUSTAINABLE LIMIT
DAY-AHEAD LOW SUSTAINABLE LIMIT
DAY-AHEAD COMMITTED RESOURCE FLAG
DAY-AHEAD MINIMUM ENERGY OFFER
DAY-AHEAD GUARANTEED START COST PER QSE PER RESOURCE
QSE SELF-COMMITTED INTERVALS FOR DAY-AHEAD
DAY-AHEAD STARTUP FLAG PER QSE AND RESOURCE BY HOUR
DAY-AHEAD MAKE-WHOLE AMT PER QSE RESOURCE & SETTLE POINT
DAY-AHEAD MAKE-WHOLE AMT PER QSE
DAY-AHEAD MAKE-WHOLE AMT PER QSE RMR RESOURCE & SETTLE POINT
DAY-AHEAD MAKE-WHOLE AMT ERCOT WIDE
DAY-AHEAD MAKE-WHOLE ENERGY ELIGIBILITY FLAG
DAY-AHEAD MAKE-WHOLE REVENUE QSE RMR RESRCE & SETTLE POINT
DAY-AHEAD MAKE-WHOLE RMR REVENUE FOR QSE
DAY-AHEAD NON-SPIN AMOUNT PER QSE
DAY-AHEAD NON-SPIN CAPACITY PURCHASES
DAY-AHEAD NON-SPIN CAPACITY SALES
DAY-AHEAD NON-SPIN OBLIGATION
DAY-AHEAD NON-SPIN NET OBLIGATION
DAY-AHEAD NON-SPIN PRICE
DAY-AHEAD NON-SPIN QUANTITY PER QSE
DAY-AHEAD NON-SPIN QUANTITY TOTAL
DAY-AHEAD NON SPIN SUPPLIED QUANTITY
DAY-AHEAD OBLIGATIONS
DAY-AHEAD OBLIGATION AMOUNT
DAY-AHEAD PYMNTS AND CHRGS FOR PTP OBL AMNT OWNER TOTAL
DAY-AHEAD OBLIGATION CHARGE OWNER TOTAL
DAY-AHEAD OBLIGATION CHARGE TOTAL
DAY-AHEAD OBLIGATION CREDIT OWNER TOTAL
DAY-AHEAD OBLIGATION CREDIT TOTAL
DAY-AHEAD OBLIGATION DERATED AMOUNT
DAY-AHEAD OBLIGATION HEDGE VALUE
DAY-AHEAD OBLIGATION HEDGE VALUE PRICE
DAY-AHEAD OBLIGATION PRICE FOR SOURCE AND SINK PAIRS
DAY-AHEAD OBLIGATION WITH REFUND
DAY-AHEAD OBLIGATION WITH REFUND AMOUNT
DAY-AHEAD PYMNTS AND CHRGS FOR PTP OBL WITH RFND AMNT OWNER TOT
DAY-AHEAD OBLIGATION WITH REFUND CHARGE OWNER TOTAL
DAY-AHEAD OBLIGATION WITH REFUND CHARGE TOTAL
DAY-AHEAD OBLIGATION WITH REFUND CREDIT OWNER TOTAL
DAY-AHEAD OBLIGATION WITH REFUND CREDIT TOTAL
DAY-AHEAD OBLIGATION WITH REFUND DERATED AMOUNT
DAY-AHEAD OBLIGATION WITH REFUND HEDGE VALUE
DAY-AHEAD OBLIGATION WITH REFUND TARGET PAYMENT
DAY-AHEAD OBLIGATION TARGET PAYMENT
DAY-AHEAD OPTION
DAY-AHEAD OPTION AMOUNT
DAY-AHEAD PAYMENTS FOR PTP OPTIONS AMOUNT OWNER TOTAL
DAY-AHEAD OPTION AMOUNT TOTAL
DAY-AHEAD OPTION DERATED AMOUNT
DAY-AHEAD OPTION HEDGE VALUE
DAY-AHEAD OPTION HEDGE VALUE PRICE
DAY-AHEAD OPTION PRICE
DAY-AHEAD OPTION WITH REFUND
DAY-AHEAD OPTION WITH REFUND AMOUNT
DAY-AHEAD PYMNTS FOR PTP OPTIONS WITH RFND AMNT OWNER TOTAL
DAY-AHEAD OPTION WITH REFUND AMOUNT TOTAL
DAY-AHEAD OPTION WITH REFUND DERATED AMOUNT
DAY-AHEAD OPTION WITH REFUND HEDGE VALUE
DAY-AHEAD OPTION WITH REFUND TARGET PAYMENT
DAY-AHEAD OPTION TARGET PAYMENT
DAY-AHEAD REG-DOWN AMOUNT PER QSE
DAY-AHEAD REG-DOWN CAPACITY PURCHASES
DAY-AHEAD REG-DOWN CAPACITY SALES
DAY_AHEAD REG-DOWN OBLIGATION
DAY-AHEAD REG-DOWN NET OBLIGATION
DAY-AHEAD REG-DOWN PRICE
DAY-AHEAD REG-DOWN QUANTITY PER QSE
DAY-AHEAD REG-DOWN QUANTITY TOTAL
DAY-AHEAD REGULATION DOWN SUPPLIED QUANTITY
DAY-AHEAD RESPONSIVE-RESERVE AMOUNT PER QSE
DAY-AHEAD RESPONSIVE-RESERVE CAPACITY PURCHASES
DAY-AHEAD RESPONSIVE-RESERVE CAPACITY SALES
DAY-AHEAD RESPONSIVE-RESERVE OBLIGATION
DAY-AHEAD RESPONSIVE-RESERVE NET OBLIGATION
DAY-AHEAD RESPONSIVE-RESERVE PRICE
DAY-AHEAD RESPONSIVE-RESERVE QUANTITY PER QSE
DAY-AHEAD RESPONSIVE-RESERVE QUANTITY TOTAL
DAY-AHEAD RESPONSIVE RESERVE SUPPLIED QUANTITY
DAY-AHEAD REAL TIME OBLIGATION PER QSE AND SRC AND SINK PAIRS
DAY-AHEAD PYMNTS AND CHRGS FOR PTP OBL BOUGHT AMNT QSE TOTAL
DAY-AHEAD REAL TIME OBLIGATION TOTAL FOR ERCOT
DAY-AHEAD REGULATION UP SERVICE CHARGE AMOUNT
DAY-AHEAD REG-UP CAPACITY PURCHASES
DAY-AHEAD REG-UP CAPACITY SALES
DAY-AHEAD REG-UP OBLIGATION
DAY-AHEAD REG-UP NET OBLIGATION
DAY-AHEAD REG-UP PRICE
DAY-AHEAD REG-UP QUANTITY PER QSE
DAY-AHEAD REG-UP QUANTITY TOTAL
DAY-AHEAD REGULATION UP SUPPLIED QUANTITY
DAY-AHEAD SELF ARRANGED NON SPIN QUANTITY
DAY-AHEAD SELF ARRANGED REGULATION DOWN QUANTITY
DAY-AHEAD SELF ARRANGED RESPONSIVE RESERVE UP QUANTITY
DAY-AHEAD SELF ARRANGED REGULATION UP QUANTITY
DAY-AHEAD SHADOW PRICE
DAY-AHEAD SETTLEMENT POINT PRICE
DAY-AHEAD STARTUP TYPE
DAY-AHEAD STARTUP OFFER
DAY-AHEAD WEIGHTED AVERAGE SHIFT FACTOR
DERATION FACTOR
EMERGENCY BASE POINT WEIGHTED AVERAGE PRICE
EMERGENCY ELECTRIC CURTAILMENT PLAN FLAG
EMERGENCY ENERGY
EMERGENCY ENERGY AMOUNT BY INTERVAL
PAYMENT FOR EMERGENCY POWER INCREASE AMOUNT QSE TOTAL
EMERGENCY ENERGY AMOUNT
EMERGENCY ENERGY PRICE
REAL-TIME ENERGY OFFER CURVE PRICE
REAL-TIME ENERGY OFFER CURVE PRICE CAP
REAL-TIME ENERGY OFFER CURVE QUANTITY
REAL-TIME ENERGY OFFER CURVE QUANTITY CAP
ERCOT SYSTEM ADMINISTRATION CHARGE AMOUNT
FGR DERATION PRICE
FLOWGATE RIGHT PURCHASE AMOUNT
FLOWGATE RIGHT SALE AMOUNT
GENERATOR RESOURCE CAPACITY
HIGH ANCILLARY SERVICES LIMIT AT ADJUSTMENT PERIOD
HIGH ANCILLARY SERVICES LIMIT AT SNAPSHOT
RTAML LOAD RATIO SHARE (HOURLY)
HIGH SUSTAINABLE LIMIT AVERAGE INCREMENTAL ENERGY COST AREA
BASE-POINT DEVIATION PAYMENT AMOUNT
BLACK START SERVICE CHARGE AMOUNT
LOAD-ALLOCATED CRR MONTHLY REVENUE NON-ZONAL AMOUNT
LOAD-ALLOCATED CRR MONTHLY REVENUE ZONAL AMOUNT
LOAD-ALLOCATED CRR AMOUNT
DAY-AHEAD MAKE-WHOLE CHARGE PER QSE
CHARGE FOR EMERGENCY POWER INCREASE AMOUNT
REAL-TIME REVENUE NEUTRALITY ALLOCATION AMOUNT
RUC MAKE-WHOLE UPLIFT CHARGE AMOUNT
RUC CLAWBACK PAYMENT AMOUNT
RUC DECOMMITMENT CHARGE AMOUNT
 REAL-TIME LOAD ALLOCATED VOLTAGE CHARGE AMOUNT
SUM OF ALL LSEGDL
SUM OF ALL LSEGUNADJ
LOAD FOR IDR PREMISES BY UFE ZONE ADJ FOR UFE
LOAD FOR NIDR PREMISES BY UFE ZONE ADJ FOR UFE
LOAD RATIO SHARE
LOAD BY SETTLEMENT POINT AND WEATHER ZONE ADJ FOR UFE
LOAD BY WEATHER ZONE ADJ FOR UFE
MAXIMUM RESOURCE PRICE FOR SINK
MAXIMUM RESOURCE PRICE FOR RESOURCE TYPE
MAXIMUM RESOURCE PRICE FOR THE RESOURCE
RT MARKET CLEARING PRICE RESPONSIVE RESERVE CAPCITY BY MARKET
METERED ENERGY AT BUS
MEB WITH OWNERSHIP ATTRIBUTES
MINIMUM-ENERGY OFFER PER QSE PER RESOURCE PER SETTLEMENT POINT
MINIMUM-ENERGY PRICE
MINIMUM RESOURCE PRICE FOR SOURCE
MINIMUM RESOURCE PRICE FOR RESOURCE TYPE
MINIMUM RESOURCE PRICE FOR RESOURCE
MONTHLY LOAD RATIO SHARE
LRS FOR PEAK INTERVAL OF THE MONTH BY COMPETITIVE LOAD ZONE
PEAK INTERVAL OF THE MONTH. CREATED FOR INITIAL & FINAL
NUMBER OF CONTINUOUS RUC-DECOMMITTED HOURS
NO DAM REAL-TIME FGR AMOUNT
NO DAM REAL-TIME FGR PAYMENTS AMOUNT OWNER TOTAL
NO DAM REAL-TIME FGR AMOUNT TOTAL
NO DAM REAL-TIME FGR PRICE
NO DAM REAL-TIME FGR TARGET PAYMENT
NO DAM REAL-TIME OBLIGATION AMOUNT
NO DAM REAL-TIME PYMNTS AND CHRGS FOR PTP OBL AMNT OWNER TOTAL
NO DAM REAL-TIME OBLIGATION AMOUNT TOTAL
NO DAM REAL-TIME OBLIGATION WITH REFUND AMOUNT
NO DAM RT PYMNTS AND CHRGS FOR PTP OBL WITH RFND AMNT OWNER TOT
NO DAM REAL-TIME OBLIGATION WITH REFUND AMOUNT TOTAL
NO DAM REAL-TIME OBLIGATION WITH REFUND TARGET PAYMENT
NO DAM REAL-TIME OPTION AMOUNT
NO DAM REAL-TIME PAYMENTS FOR PTP OPTIONS AMOUNT OWNER TOTAL
NO DAM REAL-TIME OPTION AMOUNT TOTAL
NO DAM REAL-TIME OPTION WITH REFUND AMOUNT
NO DAM REAL-TIME PYMNTS FOR PTP OPT WITH RFND AMNT OWNER TOTAL
NO DAM REAL-TIME OPTION WITH REFUND AMOUNT TOTAL
NO DAM REAL-TIME OPTION WITH REFUND TARGET PAYMENT
NO DAM REAL-TIME OPTION TARGET PAYMENT
NET METER REAL-TIME ENERGY TOTAL
NMRTETOT WITH OWNERSHIP ATTRIBUTES
NET METERING SETTLEMENT PAYMENT
RT NON-SPIN COST PER QSE
RT NON-SPIN COST TOTAL
NON-SPIN CAPACITY PURCHASES
NON-SPIN CAPACITY SALES
RT NON-SPIN FAILURE QUANTITY
CHARGE FOR AS CAP REP DUE TO FAILURE TO PROVIDE NON-SPIN AMOUNT
RT NON-SPIN FAILURE TOTAL CHARGES
NON-SPIN OBLIGATION NET PER QSE
NON-SPIN PRICE
NON SPIN QUANTITY TOTAL
NON-SPIN REPLACEMENT PER QSE PER MARKET
NON-SPIN SUPPLIED QUANTITY PER QSE IN DAM
NON-ZONAL INTERM FLOWGATE RIGHT PURCHASE AMOUNT
NON-ZONAL INTERM FLOWGATE RIGHT SALE AMOUNT
NON-ZONAL INTERM PTP OBLIGATION PURCHASE AMOUNT
NON-ZONAL INTERM PTP OBLIGATION SALE AMOUNT
NON-ZONAL INTERM PTP OPTION PURCHASE AMOUNT
NON-ZONAL INTERM PTP OPTION SALE AMOUNT
NON-ZONAL INTERM PCRR PTP OBLIGATION AMOUNT
NON-ZONAL INTERM PCRR PTP OPTION AMOUNT
OBLIGATION DERATION PRICE
PTP OBLIGATION PURCHASE AMOUNT
OBLIGATION WITH REFUND ACTUAL USAGE
PTP OBLIGATION SALE AMOUNT
PTP OPTION
OPTION DERATION PRICE
PTP OPTION PURCHASE AMOUNT
PTP OPTION WITH REFUND
OPTION WITH REFUND ACTUAL USAGE
PTP OPTION SALE AMOUNT
PROCURED CAPACITY NON-SPIN PER QSE IN DAM
DAY-AHEAD NON-SPIN AMOUNT TOTAL
PROCURED CAPACITY NON-SPIN PER RESOURCE
PROCURED CAPACITY REG-DOWN PER QSE IN DAM
DAY-AHEAD REG-DOWN AMOUNT TOTAL
PROCURED CAPACITY REG-DOWN PER RESOURCE
PROCURED CAPACITY RESPONSIVE RESERVE PER QSE IN DAM
DAY-AHEAD REPLACEMENT RESERVE AMOUNT TOTAL
PCRR NON-ZONAL REVUNUE
PCRR PTP OBLIGATION AMOUNT
PCRR PTP OPTION AMOUNT
PROCURED CAPACITY RESPONSIVE RESERVE PER RESOURCE
PCRR ZONAL REVUNUE
PROCURED CAPACITY REG-UP PER QSE IN DAM
DAY-AHEAD REG-UP AMOUNT TOTAL
PROCURED CAPACITY REG-UP PER RESOURCE
QSE CLAWBACK INTERVAL FLAG
QSE LOAD RATIO SHARE ZONAL
RT REG-DOWN COST PER QSE
RT REG-DOWN COST TOTAL
REG-DOWN CAPACITY PURCHASES
REG-DOWN CAPACITY SALES
RT REG-DOWN FAILURE QUANTITY
CHRG FOR AS CAP REP DUE TO FAIL TO PROV REG DOWN AMT
RT REG-DOWN FAILURE TOTAL CHARGES
REG-DOWN OBLIGATION NET PER QSE
REG-DOWN PRICE
REG-DOWN QUANTITY TOTAL
REG-DOWN REPLACEMENT PER QSE PER MARKET
REG-DOWN SUPPLIED QUANTITY PER QSE IN DAM
RMR ADJUSTMENT CHARGE AMOUNT
RMR ADJUSTMENT AMOUNT QSE TOTAL
RMR ADJUSTMENT AMOUNT TOTAL
RELIABILITY MUST RUN AVAILABILITY FLAG
RMR ALLOCATION FLAG
RMR AVAILABILITY REDUCTION FACTOR
RMR CAPACITY REDUCTION FACTOR
DAY-AHEAD ENERGY REVENUES TOTAL FOR RMR UNITS
RMR DAY-AHEAD ENERGY SALE REAL-TIME VALUE MARKET TOTAL
DAY-AHEAD MAKE-WHOLE RMR REVENUES TOTAL
RMR ENERGY AMOUNT
RMR ENERGY PAYMENT AMOUNT QSE TOTAL
RMR ENERGY AMOUNT TOTAL
RMR ELAPSED NUMBER OF HOURS
RMR HOURLY ROLLING EQUIVALENT AVAILABILITY FACTOR
RMR MONTHLY FUEL COST
RMR UNEXCUSED MISCONDUCT CHARGE
RMR CHARGE FOR UNEXCUSED MISCONDUCT AMOUNT QSE TOTAL
RMR NON-PERFORMANCE AMOUNT TOTAL
RELIABILITY MUST RUN NON PERFORMANCE FLAG
RMR STANDBY AMOUNT
RMR STANDBY PAYMENT AMOUNT QSE TOTAL
RMR STANDBY AMOUNT TOTAL
RMR STANDBY PRICE(THE REAL)
RMR STARTUP FUEL QUANTITY(THE REAL)
RT RESPONSIVE RESERVE COST PER QSE
RT RESPONSIVE RESERVE COST TOTAL
RESPONSIVE-RESERVE CAPACITY PURCHASES
RESPONSIVE-RESERVE CAPACITY SALES
RT RESPONSIVE RESERVE FAILURE QUANTITY
CHRG FOR AS CAP REP DUE TO FAIL TO PROVIDE RESP RSRV AMNT
RT RESPONSE RESERVE FAILURE TOTAL CHARGES
RESPONSIVE RESERVE OBLIGATION NET PER QSE
RESPONSIVE RESERVE PRICE
Responsive Reserve QUANTITY
RESPONSE RESERVE QUANTITY TOTAL
RESPONSIVE RESERVE REPLACEMENT PER QSE PER MARKET
RESP RESERVE SUPPLIED QUANTITY PER QSE IN DAM
REAL-TIME AVERAGE INCREMENTAL ENERGY COST
REAL-TIME AVERAGE INCREMENTAL ENERGY COST AREA
REAL-TIME ADJUSTED METERED LOAD
REAL-TIME ADJUSTED METERED LOAD ZONE LOAD MARKET TOTAL
REAL-TIME ADJUSTED METERED LOAD MARKET TOTAL
RTCCAMT
REAL-TIME CNGSTN PYMNT OR CHRG FOR SELF-SCHED AMNT QSE TOTAL
RTCCAMTTOT
REAL-TIME CRR OWNERS SHORTFALL CHARGES AMOUNT
REAL-TIME DCTIE EXPORT
REAL-TIME DCTIE EXPORT AMOUNT
RT ENRGY CHRG FOR DC TIE EXP UNDER OKLA EXMPT AMT QSE TOT
REAL-TIME DCTIE EXPORT MARKET TOTAL AMOUNT
REAL-TIME DCTIE IMPORT
REAL-TIME DCTIE IMPORT AMOUNT
REAL-TIME ENERGY PAYMENT FOR DC TIE IMPORT AMOUNT QSE TOTAL
REAL-TIME DCTIE IMPORT MARKET TOTAL AMOUNT
REAL TIME DX EXPORT FOR NON-EXEMPT QSES
REAL-TIME EMERGENCY DCTIE IMPORT
REAL-TIME EMERGENCY DCTIE IMPORT AMOUNT
REAL-TIME ENERGY IMBALANCE AMOUNT
RT ENERGY IMBALANCE PAYMENT OR CHARGE AMOUNT QSE TOTAL
REAL-TIME ENERGY IMBALANCE AMOUNT MARKET TOTAL
REAL-TIME HIGH SUSTAINABLE LIMIT AVERAGE INCREMENTAL ENERGY COST
REAL-TIME INCREMENTAL COST FOR HSL
REAL-TIME METERED GENERATION
REAL-TIME METERED GENERATION FOR A RESOURCE CLEARING PRICE
REAL-TIME METERED GENERATION FROM NON-MODELED
ANCILLARY SRVC PROCUREMENT NON-SPIN AMT
REAL-TIME NON-SPIN CAPACITY PURCHASES
REAL-TIME NON-SPIN CAPACITY SALES
REAL-TIME NON SPIN SUPPLIED QUANTITY
TEAL-TIME OBLIGATIONS
REAL-TIME PTP OBLIGATION AMOUNT
REAL-TIME PYMNTS AND CHRGS FOR PTP OBL AMNT QSE TOTAL
REAL-TIME PTP OBLIGATION AMOUNT TOTAL
REAL-TIME OBLIGATION PRICE
REAL-TIME OPTION
REAL-TIME OPTION AMOUNT
REAL-TIME PAYMENTS FOR PTP OPTIONS AMOUNT OWNER TOTAL
REAL-TIME OPTION AMOUNT TOTAL
REAL-TIME OPTION DERATED AMOUNT
REAL-TIME OPTION HEDGE VALUE
REAL-TIME OPTION HEDGE VALUE PRICE
REAL-TIME OPTION PRICE
REAL-TIME OPTION WITH REFUND
REAL-TIME OPTION WITH REFUND AMOUNT
REAL-TIME PYMNTS FOR PTP OPTIONS WITH RFND AMNT OWNER TOTAL
REAL-TIME OPTION WITH REFUND AMOUNT TOTAL
REAL-TIME OPTION WITH REFUND DERATED AMOUNT
REAL-TIME OPTION WITH REFUND HEDGE VALUE
REAL-TIME OPTION WITH REFUND TARGET PAYMENT
REAL-TIME OPTION TARGET PAYMENT
REAL-TIME PROCURED CAPACITY FOR NON-SPIN BY QSE AND SASM
RT PROCURED CAPACITY PAYMENT FOR NON-SPIN BY QSE AND SASM
PYMNTS FOR ANCIL SRVC CAP IN SASM NON-SPIN AMT QSE TOTAL
RT PROCURED CAPACITY TOTAL PAYMENTS FOR NON-SPIN
RT PROCURED CAPACITY FOR NON-SPIN BY QSE AND RESOURCE AND SASM
REAL-TIME PROCURED CAPACITY FOR REG-DOWN BY QSE SASM
RT PROCURED CAPACITY PAYMENT FOR REG-DOWN BY QSE SASM
PYMNTS FOR ANCIL SRVC CAP IN SASM REG DOWN AMT QSE TOTAL
RT PROCURED CAPACITY TOTAL PAYMENTS FOR REG-DOWN
REAL-TIME PROCURED CAPACITY FOR REG-DOWN BY QSE, RESOURCE, SASM
RT PROCURED CAPACITY FOR RESPONSIVE RESERVE BY QSE SASM
RT PROCURED CAPACITY PAYMENT FOR RESPONSIVE RESERVE BY QSE SASM
PYMNTS FOR ANCIL SRVC CAP IN SASM RESP RSRV AMT QSE TOTAL
RT PROCURED CAPACITY TOTAL PAYMENTS FOR RESPONSIVE RESERV
RT PROCURED CAPACITY FOR RESPONSIVE RESERVE BY QSE RESOURCE SASM
REAL-TIME PROCURED CAPACITY FOR REG-UP BY QSE AND SASM
RT PROCURED CAPACITY PAYMENT FOR REG-UP BY QSE AND SASM
PYMNTS FOR ANCIL SRVC CAP IN SASM REG UP AMT QSE TOTAL
RT PROCURED CAPACITY TOTAL PAYMENTS FOR REG-UP
REAL-TIME PROCURED CAPACITY FOR REG-UP BY QSE RESOURCE SASM
QSE-TO-QSE ENERGY PURCHASE
QSE-TO-QSE ENERGY PURCHASE AT ADJUSTMENT PERIOD
QSE-TO-QSE ENERGY PURCHASE AT SNAPSHOT
QSE-TO-QSE ENERGY SALE
QSE-TO-QSE ENERGY SALE BY AT ADJUSTMENT PERIOD
QSE-TO-QSE ENERGY SALE AT SNAPSHOT
ANCIL SRVC CAP PROCUREMENT REGULATION DOWN AMT
REAL-TIME REG-DOWN CAPACITY PURCHASES
REAL-TIME REG-DOWN CAPACITY SALES
REAL-TIME REGULATION DOWN SUPPLIED QUANTITY
PRICE FOR RESOURCE METERED ENERGY AT BUS
ANCILLARY SERVICE CAPACITY PROCUREMENT RESP RESERVE AMT
REAL-TIME RESPONSIVE-RESERVE CAPACITY PURCHASES
REAL-TIME RESPONSIVE-RESERVE CAPACITY SALES
REAL-TIME RESPONSIVE RESERVE SUPPLIED QUANTITY
ANCIL SRVC CAP PROCUREMENT REGULATION UP AMOUNT
REAL-TIME REG-UP CAPACITY PURCHASES
REAL-TIME REG-UP CAPACITY SALES
REAL-TIME REGULATION UP SUPPLIED QUANTITY
REAL-TIME SELF ARRANGED NON SPIN QUANTITY
REAL-TIME SELF ARRANGED REGULATION DOWN QUANTITY
REAL-TIME SELF ARRANGED RESPONSIVE RESERVE UP QUANTITY
REAL-TIME SELF ARRANGED REGULATION UP QUANTITY
REAL-TIME SETTLEMENT POINT PRICE
RT VOLTAGE SUPPORT SERVICE AVERAGE INCREMENTAL ENERGY COST
RUC-COMMITMENT
RUC CAPACITY SNAPSHOT DURING ADJUSTMENT PERIOD
RUC CAPACITY CREDIT BY QSE
RUC CAPACITY SNAPSHOT AT TIME OF RUC PROCESS
RUC CAPACITY TOTAL
RUC CLAWBACK CHARGE
RUC CLAWBACK CHARGE AMOUNT QSE TOTAL
RUC CLAWBACK AMOUNT TOTAL
RUC CLAW-BACK FACTOR FOR QSE CLAWBACK INTERVALS
RUC CLAW-BACK FACTOR FOR RUC-COMMITTED HOURS
RUC CAPACITY PURCHASE AT ADJUSTMENT PERIOD
RUC CAPACITY PURCHASE AT SNAPSHOT
RUC CAPACITY SALE AT ADJUSTMENT PERIOD
RUC CAPACITY-SHORT AMOUNT
RUC CAPACITY-SHORT CHARGE AMOUNT QSE TOTAL
RUC CAPACITY-SHORT AMOUNT TOTAL
RUC CAPACITY SALE AT SNAPSHOT
RUC-DECOMMITMENT
RUC DECOMMITMENT ADJUSTMENT
RUC DECOMMITMENT PAYMENT AMOUNT
RUC DECOMMITMENT PAYMENT AMOUNT QSE TOTAL
RUC DECOMMITMENT PAYMENT TOTAL
RUC DE-COMMITMENT FLAG
RUC-DECOMITMENT START TYPE
ENERGY REVENUE LESS COST DURING QSE-CLAWBACK INTERVALS
REVENUE LESS COST ABOVE LSL DURING RUC-COMMITTED HOURS
RUC GUARANTEE
RUC GUARANTEE ADJUSTMENT
RUC GUARANTEE - MINIMUM ENERGY COSTS
RUC GUARANTEE - STARTUP COSTS
RUC HOUR
HIGH SUSTAINED LIMIT AT THE TIME OF RUC PROCESS
RUC MINIMUM-ENERGY REVENUE
RUC MAKE-WHOLE PAYMENT
RUC MAKE-WHOLE PAYMENT AMOUNT QSE TOTAL
RUC MAKE-WHOLE AMOUNT TOTAL PER RUC PROCESS
RUC MAKE-WHOLE AMOUNT TOTAL
RT REG-UP COST PER QSE
RT REG-UP COST TOTAL
REG-UP CAPACITY PURCHASES
REG-UP CAPACITY SALES
RUC SHORTFALL
RUC SHORTFALL AT ADJUSTMENT PERIOD
RUC SHORTFALL RATIO SHARE
RUC SHORTFALL AT SNAPSHOT
RUC SHORTFALL TOTAL
RUC STARTUP FLAG
RT REG-UP FAILURE QUANTITY
CHRG FOR AS CAP REP DUE TO FAIL TO PROV REG UP AMT
RT REG-UP FAILURE TOTAL CHARGES
REG-UP OBLIGATION NET PER QSE
REG-UP PRICE
REG-UP QUANTITY TOTAL
REG-UP REPLACEMENT PER QSE PER MARKET
REG-UP SUPPLIED QUANTITY
SEASONAL MEGAWATT CAPACITY BY RESOURCE
QSE SELF-COMMITTED INTERVALS
SSQ
SELF-SCHEDULE WITH SINK AT SETTLEMENT POINT
SELF-SCHEDULE WITH SOURCE AT SETTLEMENT POINT
START TYPE FLAG
RESOURCE STATUS AT SNAPSHOT
UNIT STARTUP FLAG
TIME OF FORCED OUTAGE
TIME WEIGHTED OUTPUT SCHEDULE
TIME-WEIGHTED TELEMETERED GENERATION
REAL-TIME VOLTAGE SUPPORT UNIT REACTIVE LIMIT LAGGING
REAL-TIME VOLTAGE SUPPORT UNIT REACTIVE LIMIT LEADING
VERIFIABLE MINIMUM-ENERGY COSTS
VARIABLE OPERATION AND MAINTENANCE EXPENSES AT LSL
VOLTAGE SUPPORT SERVICE AVERAGE INCREMENTAL ENERGY COST AREA
VOLTAGE SUPPORT SERVICE ENERGY AMOUNT BY INTERVAL
REAL-TIME VOLTAGE SUPPORT LOST OPPORTUNITY AMT PER QSE
REAL-TIME VOLTAGE SUPPORT LOST OPPORTUNITY AMT
REAL-TIME VOLTAGE SUPPORT SSERVICE ENERGY INSTRUCTION
VOLTAGE SUPPORT SERVICE VAR AMOUNT BY INTERVAL
REAL-TIME VOLTAGE SUPPORT VAR AMOUNT FOR QSE
REAL-TIME VOLTAGE SUPPORT VAR AMOUNT ERCOT
VOLTAGE SUPPORT SERVICE VAR INSTRUCTED OUTPUT LEVEL
VALID THREE-PART SUPPLY OFFER FLAG
ZONAL INTERM FLOWGATE RIGHT PURCHASE AMOUNT
ZONAL INTERM FLOWGATE RIGHT SALE AMOUNT
ZONAL INTERM PTP OBLIGATION PURCHASE AMOUNT
ZONAL INTERM PTP OBLIGATION SALE AMOUNT
ZONAL INTERM PTP OPTION PURCHASE AMOUNT
ZONAL INTERM PTP OPTION SALE AMOUNT
ZONAL INTERM PCRR PTP OBLIGATION AMOUNT
ZONAL INTERM PCRR PTP OPTION AMOUNT
Day-Ahead Real-Time Option Price
Day-Ahead Real-Time Option Hedge Value Price
Day-Ahead Real-Time Option Target Payment
Day-Ahead Real-Time Option Derated Amount
Day-Ahead Real-Time Option Hedge Value
Day-Ahead Real-Time Option Amount
Day-Ahead Real-Time Option Amount Owner Total
Day-Ahead Real-Time Option Amount Total
Day-Ahead Real-Time Option with Refund Target Payment
Day-Ahead Real-Time Option with Refund Derated Amount
Day-Ahead Real-Time Option with Refund Hedge Value
Day-Ahead Real-Time Option with Refund Amount
Day-Ahead Real-Time Option with Refund Amount Owner Total
Day-Ahead Real-Time Option with Refund Amount Total
Point to Point Source and Sink Pair Total
Flowgate Right Total
RMR CONTRACT ESTIMATED FUEL ADDER
REAL-TIME MVARH FOR QSE RESOURCE AND SETLPOINT
STARTUP OFFER PER QSE PER RESOURCE PER SETTLEMENT POINT
STARTUP PRICE PER START
VERIFIABLE STARTUP COSTS
VERIFIED FUEL CONSUMPTION AT LSL
VERIFIABLE OPERATION AND MAINTENANCE EXPENSES PER START
REAL-TIME VOLTAGE SUPPORT UNIT LAGGING MVARH
REAL-TIME VOLTAGE SUPPORT UNIT LEADING MVARH
SUM OF LSEGUFE
LOAD ALLOCATED RMR QSE TOTAL SERVICE CHARGE
LOAD-ALLOCATED RMR AMOUNT TOTAL
TOTAL GENERATION BY LOAD ZONE
PERCENTAGE OF FOP FOR GENERATION ABOVE DALSL
PERCENTAGE OF FIP FOR GENERATION ABOVE DALSL
PERCENTAGE OF FIP FOR GENERATION ABOVE LSL
PERCENTAGE OF FOP FOR GENERATION ABOVE LSL
TOTAL SELF ARRANGED REG-UP QUANTITY PER QSE
TOTAL SELF ARRANGED REG-DOWN QUANTITY PER QSE
TOTAL SELF ARRANGED NON SPIN QUANTITY PER QSE
TOTAL SELF ARRANGED RESPONSIVE RESERVE QUANTITY PER QSE
Day-Ahead Transition Flag
Day-Ahead Make-Whole amt per QSE, CmbCyc Cfg & settle point
DAM Real-Time CRR Shortfall Amount
DAM CRR Short Ratio
Day-Ahead CRR Short Ratio Real-Time Amount
DAM CRR Credit Ratio Share Real-Time
Day-Ahead Real-Time CRR Shortfall Amount Total
All interval tables listed with extracts are designated as INT in
the Bill Determinant table

All scalar tables listed with the extracts are designated as SCA
in the Bill Determinanat Table

To determine if a particular bill determinant for a table listed
with an extract is included in the particular extract, you must
reference the particular Bill Determinant in the Nodal
Protocols.
SDAWG - remove initial; update the user guide to show that when you schedule the code extracts you need to upload PRDE into your data

Index




                                                                                   updates:
                                                                                   consolidated operating day extract (DAM & RTM)
                                                                                   remove 1,3
                                                                                   sp on 5
                                                                                   add correct extract names
                                                                                   late fees
                                                                                   card




Schedule An Extract
you need to upload PRDE into your database.




ed operating day extract (DAM & RTM)


t extract names

				
DOCUMENT INFO
Description: Database Mis Report Format document sample