MIS LOG IN

Extract Data Definitions

A Data Definition Language (DDL) is a standard for commands that define the different structures in a database. DDL files are provided to Market Participants from ERCOT in order to create a database that can be used to store the data received in ERCOT extracts into their own environments. The metadata provided in these files includes tables, columns, data type of each field, descriptions of the data that is to be loaded into each column and any table or character/precision constraints or alterations. As a general standard, DDLs are applied to define extracts that are provided in CSV format. However, some of the DDLs included here define the contents of report information in Excel as well.

Show EMIL Information

EMIL ID GEN-253

Report Type ID 202

Status Active

Generation Frequency Event - As Needed

First Run Date 10-11-2010

Audience Public

Security Classification Public

ECEII N/A

Rule The protocol for each DDL/XSD will be that of the matching individual extract

EMIL Last Updated Date 11-22-2023

Channel Public, EWS

Extract Subscriber N/A

File Type zip, txt

User Guide N/A

XSD Name N/A

DDL Name N/A

Posting Type Document

MIS Posting Location N/A

Display Duration 999999

Market Nodal

Digital Certificate Role N/A

Notification Type N/A

Friendly Name	Posted		Available Files

Search Related Topics

Data Definitions

Extract Data Definitions

Help

Help