eTariff Viewer

Public

1 September 2015

eTariff Viewer 

Federal Energy Regulatory Commission
eTariff Viewer 

Public

2 September 2015

TABLE OF CONTENTS

Overview of Order No. 714 ................................................................................................ 3

What is a Tariff? ................................................................................................................. 3

Disclaimer........................................................................................................................... 3

eTariff Viewer..................................................................................................................... 4

Tariff Section Details.......................................................................................................... 8

View/Export Tariff............................................................................................................ 13

Tariff Printing Techniques................................................................................................ 17

Tariff Section Details-Quick Print.................................................................................... 20

Tariff Section Details-Export to RTF ............................................................................... 22

View All Activity.............................................................................................................. 25

Tariff Section Search ........................................................................................................ 26

Retrieving Tariff Records in XML Format ........................................................................ 32

DATA DICTONARY....................................................................................................... 35

XML Schema for etariff Export........................................................................................ 44
eTariff Viewer

Public

3 September 2015

Overview of Order No. 714

Issued on September 19, 2008, Order No. 714, the Federal Energy Regulatory 

Commission revised its regulations to require that, effective October 1, 2010, all 

tariffs and tariff revisions and rate change applications for the public utilities, 

natural gas pipelines, oil pipelines and power administrations be filed 

electronically according to a set of standards developed in conjunction with the 

North American Energy Standards Board. This rule is part of the Commission’s 

efforts to comply with the Paperwork Reduction Act, the Government Paperwork 

Elimination Act (GPEA), and the E-Government Act of 2002 by developing the 

capability to file electronically with the Commission via the Internet.

ORDER NO. 714 FINAL RULE (Issued September 19, 2008-FERCNet

What is a Tariff? 

A Tariff is a compilation of Terms and Conditions of Service, rates and schedules, 

contracts and a copy of each form of service agreement, of a particular regular 

entity, as required by the various statutes and Commission Regulation. 

Requirements

eTariff Viewer is optimized for Internet Explorer version 8 or higher. The 

Silverlight browser plug-in is required to view tariff record text. Several browsers 

do not support the Silverlight browser plug-in including Chrome and Windows 10 

Edge.

Disclaimer 

The tariff viewer is being provided to help the public review tariff provisions 

electronically. The rendition of the tariff provisions and the status of these 

provisions are based on the best efforts of Commission staff, but do not 

necessarily represent the rates or terms and conditions of service on file at any 

particular point in time. Reference should be made to the Commission orders to 

establish the filed rates or terms and conditions of service.
eTariff Viewer 

Public

4 September 2015

eTariff Viewer

The eTariff Viewer allows the public access to view the status of Tariffs which 

have been submitted to FERC. 

Follow the steps below to access the eTariff viewer. 

1. Enter http://www.ferc.gov in the browser address field. The following 

page displays.

Figure 1 – FERC Web Site
eTariff Viewer

Public

5 September 2015

2. Click on the eTariff Viewer link located at the top right corner of the 

screen as shown in Figure 1. The eTariff Viewer will display as 

shown in Figure 2. 

Figure 2 – eTariff Viewer Screen

To find a specific Tariff or set of Tariffs, use filters to narrow the choices. The Table 

below lists the available options for each drop down menu. 

Tariff Program  Electric MBR

 Electric TCS

 NGA Gas

 NGPA Gas

 Oil 

 Power Administration

 Select Program – if not changed, equal to ALL 

Programs
eTariff Viewer 

Public

6 September 2015

Tariff Status  Cancelled- Tariff no longer effective

 Effective- An active Tariff

 Pending- A Tariff filed with FERC for the first time, 

but not action has been taken. 

 -- Select Status – if not changed, equal to Effective 

and Pending

Company Name Enter the name or partial name of the company in which to view 

Tariffs. 

NOTE: Company name changes are kept in the system and when

entering a name on this screen all versions of that name will display 

on the Tariff list screen. 

Tariff Title Enter the Title or partial title of the Tariff – may be left blank

3. Select the appropriate parameters and click the Find Tariffs button or 

press Enter on the keyboard. 

4. The results will display. 

NOTE: In the Tariff Title or Company Name fields you may enter a 

partial name to obtain the results. 
eTariff Viewer

Public

7 September 2015

5. Click on any column header to sort from that column. 

Figure 3 - Tariff List Sort by Program 

6. Click the All Tariffs Button to view all tariffs with no filters and to refresh. 
eTariff Viewer 

Public

8 September 2015

Tariff Section Details

To view complete details of the section including metadata of the section follow 

the steps below. 

1. Click on a specific Tariff Title Link from the Tariff List Screen. 

Figure 4 – Tariff List Screen
eTariff Viewer

Public

9 September 2015

2. The selected company’s tariff will appear. The Company Name is 

followed by the Tariff Title.

Figure 5 – Tariff Results

NOTE: If there were changes made to a company name on a 

specific date the system will keep a record of all company name

changes and display the name reflected on the selected date. 

3. The Tariff’s section titles shown on the Section list are as of the date 

selected. The default date is today’s date.

4. Select a different date from the calendar if you want to view a 

different date. 
eTariff Viewer 

Public

10 September 2015

Figure 6 – Calendar Drop Down

5. Select one of the buttons as described below. 

Figure 7 - Tariff Browser Button Selection 

• List All Sections-Lists all sections of the tariff ever filed 

regardless of whether those sections are effective on the 

effective date provided. 

• Find – Click to locate the tariffs associated with the date 

indicated in the date field. 

6. The right side of the screen reflects the history of the selected section 

from the left side of the screen. 

7. Click on the specific tariff record’s Status link to view the section.

Figure 8 - Tariff Browser Screen showing Sections and History 
eTariff Viewer

Public

11 September 2015

8. The Tariff Section Details Screen displays. 

IMPORTANT: If you do not have the application of Silverlight 4

installed Internet Explorer version 8 or higher, then you will receive the 

following message on the Tariff Section Details Screen. NOTE: some 

browsers do not support the Silverlight browser plug-in, including Chrome 

and Windows 10 Edge.

Figure 9 - Tariff Section Details Screen Showing Error Message

9. Click on the Install Now button to install the Silverlight application. 
eTariff Viewer 

Public

12 September 2015

Figure 10 – Microsoft Silverlight Download Message

10. Close the browser after installing the application. Repeat steps 2 and 3

above. The sections detail screen will now load Microsoft Silverlight

and display the document in the following format. 

Figure 11 – Tariff Section Details Screen with Silverlight 
eTariff Viewer

Public

13 September 2015

View/Export Tariff 

NOTE: The export and print features described below will only work for section 

content that the companies provided in Rich Text Format (RTF). Section content 

that the companies provided in Portable Document Format (PDF) cannot be 

exported or printed using these features.

The link at the top of the screen will allow you to view and export specific 

sections.

Figure 12 – Tariff Browser Screen with View/Export Tariff Circled 

1. Click the View/Export Tariff link, circled in Figure 12 to view the 

sections or options of the tariff that you wish to view or select for 

printing. 
eTariff Viewer 

Public

14 September 2015

Figure 13 – Tariff/View Export Screen

2. Select the section on the right and any applicable options on the left. 

3. Change the date for a different effective date of section if applicable. 

4. Click the Update Button to refresh the new date. 

5. Select either View/Export only sections or View/Export entire tariff. 

If you select View/Export entire tariff you do not have to select any 

specific sections. 
eTariff Viewer

Public

15 September 2015

Figure 14 –Export Screen showing View Options

6. Click the View/Export to RTF button to view before printing. You will 

have the option to open or Save the file. 

Figure 15 - File Download Dialogue Box

7. Click Open to view the file. The Tariff section or Tariff will display in 

Microsoft Word or the software the user has associated with RTF files. 
eTariff Viewer 

Public

16 September 2015

Figure 16 - Tariff Section Displayed

8. The document can be saved, edited or printed. 
eTariff Viewer

Public

17 September 2015

Tariff Printing Techniques

In some cases it may be necessary to print a section of a tariff or page of a tariff in 

Landscape mode instead of portrait mode to accurately print a rate schedule table. 

To print a section of a Tariff in landscape mode perform the following steps. 

1. Highlight the text from the page that is to be changed to landscape. 

Figure 17 - Selected Text

2. Select Page/Set-up from the File menu in Microsoft Word. 
eTariff Viewer 

Public

18 September 2015

Figure 18 - Page Set-Up Menu

3. Select Landscape. 

Figure 19 – Page Set-Up Dialogue Box
eTariff Viewer

Public

19 September 2015

4. Click Ok. The selected section is now in Landscape. 

5. The page of the text selected will become landscape instead of portrait. 

6. Click the Close button to return back to the Tariff Browser Screen. 
eTariff Viewer 

Public

20 September 2015

Tariff Section Details-Quick Print

1. Click the Quick Print button from the Tariff Section Details Page. The 

Print Dialogue Box Displays.

Figure 20 – Tariff Section Showing Quick Print Button 
eTariff Viewer

Public

21 September 2015

NOTE: If the section is in PDF Format the PDF will show below the text. 

Figure 21- Print Dialogue Box

2. Click the Print Button to print the Tariff Section. 

3. Click the Close Button to close the window and return to the Tariff Browser 

Screen. 
eTariff Viewer 

Public

22 September 2015

Tariff Section Details-Export to RTF

From the Tariff section Details you can also Export to RTF which will export the 

tariff or section into Microsoft Word or the software the user has associated with 

RTF files. 

1. Click on the Export to RTF button. 

Figure 22- Tariff Section Details Displayed 
eTariff Viewer

Public

23 September 2015

2. Click open or Save when the File download dialogue box displays. 

Figure 23 - File Download Dialogue Box 

3. Click Open to display the document. Save or print the document. 
eTariff Viewer 

Public

24 September 2015

Figure 24 - Document displayed in Microsoft Word
eTariff Viewer

Public

25 September 2015

View All Activity

1. Click the All Activity link to view all Activity for a selected tariff 

record. 

Figure 25 – All Activity Link

The link will take the user to the Section Activity page:

Figure 26- Section Activity Screen

The Section Activity page shows additional information, including intermediate 

tariff status and tariff record action conditions, the date the action occurred, FERC 

order information and FERC order date. 
eTariff Viewer 

Public

26 September 2015

Tariff Section Search 

1. Click the Tariff Section Search button in the Tariff List screen to access 

additional data fields used to locate Tariffs or Tariff Sections. 

Figure 27 - Tariff Section Search Button

2. Select from Selected Tariffs chosen from the Tariff Titles on the right or 

click the All Tariffs radio button to select from the parameters shown 

below. 

Figure 28 - Tariff Section Search Screen 
eTariff Viewer

Public

27 September 2015

Tariff Program Options

Field Description

Electric MRB

Electric TCS and MBR

NGA Gas 

NGPA Gas 

Oil

Power Administration 

Tariff Status Options

Field Description

Cancelled Tariff no longer effective

Effective An active Tariff

Pending A Tariff filed with FERC for the first time,

but no action has yet been taken. 
eTariff Viewer 

Public

28 September 2015

Section Status Options 

Field Description

Accepted The Tariff section has been accepted by 

FERC at a specific point in time. 

Conditionally/Accepted The Tariff section is accepted conditioned 

upon the final Commission action.

OBE The Tariff section is Overtaken by Events

Conditionally/Effective The Tariff section is effective conditioned 

upon the final Commission action.

Pending Filed with FERC, but no action yet taken. 

Effective Tariff section Accepted by FERC and 

effective at a given instance in time.

Rejected Tariff section rejected by the Commission. 

Superseded Tariff section that was accepted and 

effective at a given instance in time, by no 

longer effective.

Suspended Tariff section suspended by the 

Commission.

Tolled Action on the Tariff section is deferred The 

Tolled section is not subject to a statutory 

action date.

Withdrawn Tariff section was removed by the 

company before it was processed.
eTariff Viewer

Public

29 September 2015

Additional Fields

Company Name Enter Company you are searching on for 

the Tariff

Tariff Title Enter the name of the Tariff (optional)

From Date Click in this field to pull up a calendar. 

Date range of the selected Tariff. Default 

of no entry is ALL.

To Date Click in this field to pull up a calendar. 

Section Title Enter the word(s) to be searched for in the 

Section Title. These are simple word or 

phrase searches only. 

Section Text Enter the word(s) to be searched for in the 

Section Text. These are simple word or 

phrase searches only.

Docket Number Enter the Docket Number. New: The 

Docket number can either be a short label 

or a complete Docket number, ex. ER10-

11 or ER10-00011-000. 

3. Enter the appropriate information in the fields provided.

4. Click in the box to the left of the appropriate company name.

5. Click the Search Sections Button on the bottom left corner of the 

screen. 

6. The Tariff related to the selected criteria displays on the bottom of the 

page. (Shown in Figure 29 below)
eTariff Viewer 

Public

30 September 2015

Figure 29 – Tariff Section Search Results

7. Click on a Section Title under the Section Title column at the bottom of 

the page. The Tariff Section Details Screen displays. 
eTariff Viewer

Public

31 September 2015

Figure 30 - Tariff Section Details Screen

8. Click the Close button to return to the Tariff List. 
eTariff Viewer 

Public

32 September 2015

Retrieving Tariff Records in XML Format

The Commission provides as a service to the public the ability to download 

currently effective tariff records of a particular tariff. The purpose of the service is 

to assist required filers who lose or lose access to their tariff data base to access 

the Commission’s tariff data base and retrieve enough of their tariff data to 

continue making valid filings with the Commission. In addition, parties may use 

this feature to create new tariff data bases or tariff filings. All the data that is 

provided through this feature is public information and may be found in eLibrary. 

Please review the disclaimer above and on the Commission’s eTariff Viewer web 

site.

The XML Column on the Tariff list screen allows viewing of the Tariff Filing 

XML file. 

1. Click the XML link on the right side of the screen. 

Figure 31 - Tariff List Showing XML Column

2. The XML dialogue box will display.
eTariff Viewer

Public

33 September 2015

Figure 32 – Export to XML Screen 

3. Click one or more Status to include in the XML file. 

4. Click the Export to XML button. The File Download box appears. 

Figure 33 - XML Dialogue Box 
eTariff Viewer 

Public

34 September 2015

Figure 34 - XML Tariff Export File

7. It is the responsibility of the party downloading the tariff data to extract 

the data from the XML file and load that data in the data base and/or 

tariff management software of the user’s choice. 
eTariff Viewer For Official Use Only

Public

35 September 2015 

DATA DICTONARY

The following Data Tables make up the Data Dictionary for electronic export of Tariff Records from the Commission’s electronic tariff 

data base. Conceptually, the purpose of the tables are to provide the Tariff Record Content Data - the actual “text” or “content” of the 

tariff, rate schedule, or service agreement along with its associated metadata, necessary to recreate an electronic tariff such that an 

applicant can continue to perform business with the Commission in the event of a loss of their tariff data or the creation of a new 

electronic tariff proposal.

• Filing Data - describes the overall filing.

• Tariff Record Content Data - the actual “text” or “content” of the tariff, rate schedule, or service agreement along with its 

associated metadata

The data elements’ definitions are identical to those provided in the Implementation Guide for Electronic Filing of Parts 35, 154, 284, 

300, and 341 Tariff Filings, unless otherwise indicated by italic font. 

The data elements contained in the data table is presented in the order in which they appear in the XML schema.
eTariff Viewer 

Public

36 September 2015

Filing Data

This data defines the data necessary to be provided with each Tariff Filing.

Business Name

(1)

Element Name

(2)

Definition of Data Element

(3)

Field Format

(length)

(4)

Valid Values

(5)

Usage 

Responsibility

Conditions 

(6)

Schema Version schema_version The version of the XML schema 

used to create the specific Tariff 

Record export.

Numeric (10) Any number 

between 1 and 

2,147,483,648

Required.

Tariff Identifier tariff_id A unique identifier for the Tariff 

Submitter’s database assigned by 

the Tariff Submitter as it pertains to 

the database being modified by the 

Tariff Filing. This can be any value 

in the allowable range of numbers, 

but it must be unique for each Tariff 

Submitter’s database. A Tariff 

Submitter may have more than one 

active database.

Numeric (10) Any number 

between 1 and 

2,147,483,648

Required. 

Assigned and provided by the Tariff Submitter.

The Tariff Identifier of the database cannot

change.

Tariff Title tariff_title The name of the database assigned 

by the Tariff Submitter. 

Alphanumeric 

(100) 

Free form text. Required only when creating a new database. 

After the initial submission, the Tariff Identifier is 

used, and this data element may be left blank.

Assigned and provided by the Tariff Submitter. 

The Tariff Title of the database cannot change.
eTariff Viewer For Official Use Only

Public

37 September 2015 

Business Name

(1)

Element Name

(2)

Definition of Data Element

(3)

Field Format

(length)

(4)

Valid Values

(5)

Usage 

Responsibility

Conditions 

(6)

Company Identifier company_id A FERC-designated Company 

Identifier code used to identify an 

entity required to submit Tariff 

Filings to FERC pursuant to Title 18 

Code of Federal Regulations Parts 

35, 154, 284, 300, 341 or other 

Parts as required by FERC.

Alphanumeric (10) Free form text Required. 

Assigned by FERC and provided in the Tariff 

Filing by the Tariff Submitter.

Tariff Export Date tariff_export_date Date the tariff record export file was 

created

Date (17) YYYY-MMDDThh:mmZA tariff data base is dynamic. The Commission’s 

tariff data base contents can change at any time 

and on any day throughout the year. 

“T” stands for time value start and 'Z' stands for 

universal time.

Schema Version schema_version The version of the XML schema 

used to create the specific Tariff 

Filing.

Numeric (10) Any number 

between 1 and 

2,147,483,648

Required.

Export Schema 

Version

export_schema_version The version of the XML schema 

used to create the specific Tariff 

Record export file.

Numeric (10) Any number 

between 1 and 

2,147,483,648

Not required to re-establish a tariff record data 

base. Provided to distinguish between different 

etariffExport.xsd. 
eTariff Viewer 

Public

38 September 2015

Tariff Record Content Data

This provides the data for each Tariff Record.

Business Name

(1)

Element Name

(2)

Definition of Data Element

(3)

Field Format

(length)

(4)

Valid Values

(5)

Usage 

Responsibility

Conditions 

(6)

Tariff Record 

Identifier

record_id An identifier for the Tariff Record 

within a given database that will 

not change as a result of revisions 

to the content of the Tariff Record 

(with same or different effective 

dates). No two different Tariff 

Records in the same database 

may have the same Tariff Record 

Identifier.

Numeric (10) Any number 

between 1 and 

2,147,483,648

Required. 

Assigned by the Tariff Submitter. 

Each Tariff Record in the database has an 

associated Tariff Record Identifier number that 

does not change with each revision within a given 

database. 

The Tariff Record Identifier is not used for 

collation and does not have to be assigned 

sequentially.

Option Code option_code An identifier that designates the 

alternative Tariff Record option 

being submitted. An identifier that 

designates the primary Tariff 

Record as “A” and designates all 

alternative Tariff Record options 

being submitted, if any, 

sequentially in alphabetic order. 

Character (1) "A" thru "Z" 

allowed.

Required. 

Provided by the Tariff Submitter.

Default (no more than one option is provided) is 

“A”. 

Tariff Record Title record_title The name of the Tariff Record 

contents. 

Alphanumeric (60) Free form text. Required, if Tariff Record is a first-level Parent or 

in a Whole Document Format. 

Optional in other cases. 

Assigned by the Tariff Submitter. 

This field may be used in a database generated 

Table of Contents.
eTariff Viewer For Official Use Only

Public

39 September 2015 

Business Name

(1)

Element Name

(2)

Definition of Data Element

(3)

Field Format

(length)

(4)

Valid Values

(5)

Usage 

Responsibility

Conditions 

(6)

Record Content 

Description

record_content_desc Textual description of the Tariff 

Record. 

Alphanumeric (25) Free form text. Required. 

Assigned by the Tariff Submitter. 

This field may be used in a database generated 

Table of Contents.

Record Version 

Number

record_version_num A representation of the version 

(designation) of the Tariff Record.

Alphanumeric (10) x.y.z

x = revision 

number

y = substitute 

number

z = “squeezed” 

number

Conditional based on Type of Filing. 

This information is not used to determine actual 

status of a Tariff Record. It is not used in any 

automated fashion other than display (possibly in 

the table of contents). This data is provided for 

ease of business and FERC referencing only.

Record Narrative 

Name

record_narrative_name An additional narrative description 

of the Tariff Record.

Alphanumeric 

(254)

Free form text Optional.

Tariff Record 

Collation Value

collation_value A value that will determine the sort 

order in which the Tariff Records 

are merged.

Numeric (25) Any number 

between 1 and 

2,147,483,648

Required.

Assigned by the Tariff Submitter. 

Tariff Record 

Parent Identifier

record_parent_id Provides the hierarchical structure 

to identify the higher-level part of 

the database to which this Tariff 

Record belongs. 

Numeric (10) Any number 

between 0 and 

2,147,483,648 

Required. 

Assigned by the Tariff Submitter. If the Tariff 

Submitter chooses not to use the functionality of 

this field, they must still populate the field with “0”. 

Otherwise, the value must be a valid Tariff 

Record Identifier. 
eTariff Viewer 

Public

40 September 2015

Business Name

(1)

Element Name

(2)

Definition of Data Element

(3)

Field Format

(length)

(4)

Valid Values

(5)

Usage 

Responsibility

Conditions 

(6)

Tariff Record 

Proposed Effective 

Date

proposed_effective_date The proposed effective date for 

the specified Tariff Record.

Date (10) YYYY-MM-DD Required. 

Assigned by the Tariff Submitter.

Record Effective 

Priority Order

priority_order A positive integer that directs 

which of multiple changes of a 

given Tariff Record (the same 

Tariff Record Identifier) proposed 

to go into effect on the same day, 

will take precedence, i.e., the 

Tariff Record with the highest 

numeric value will supersede any 

other Tariff Records with the same 

Record Identifier also proposed to 

be effective for that day.

Numeric (10) Any number 

between 1 and 

2,147,483,648

Required. 

Assigned by the Tariff Submitter. 

Default value should allow for priority values 

below and above the Tariff Record of a specific 

Tariff Record Proposed Effective Date initial 

value (for example: 500). The value must be 

unique for a specific Tariff Record for a specific 

Tariff Record Proposed Effective Date.

When the current database is assembled for a 

particular effective date and there are multiple 

Tariff Records with the same Record Identifier 

and the same effective date, the approved Tariff 

Record for that effective date with the highest 

Record Effective Priority Order number will be the

effective Tariff Record.

Record Content 

Type Code

record_content_type_code The version of the software used 

to create the specific Tariff 

Record.

Numeric (10) See list of 

codes posted @ 

www.ferc.gov

Conditional based on Type of Filing and/or 

structure of database. 

Provided by the Tariff Submitter. 

Record Binary Data record_binary_data The actual Tariff Record content. Binary (10 MB) Binary Base64 

bit encoded file 

content

Conditional based on Type of Filing and/or 

structure of database. 

Provided by the Tariff Submitter.

Record Plain Text record_plain_text The plain text version of the 

content of the Record Binary Data. 

Formatting and other binary 

values are stripped from this 

content. 

Alphanumeric (10 

MB) 

Free form text Conditional based on Type of Filing and/or 

structure of database. 

Provided by the Tariff Submitter.
eTariff Viewer For Official Use Only

Public

41 September 2015 

Business Name

(1)

Element Name

(2)

Definition of Data Element

(3)

Field Format

(length)

(4)

Valid Values

(5)

Usage 

Responsibility

Conditions 

(6)

Record Change 

Type

record_change_type A description of the type of change 

being requested. 

Alphanumeric (15) See Code 

Values 

Dictionary

Required.

Assigned by the Tariff Submitter. Used to identify 

the appropriate Tariff Record maintenance action. 

Some Type of Filings restrict the choice of 

Record Change Types. 

Filing Identifier filing_id A unique identifier for the subject 

Tariff Filing for the Tariff 

Submitter. 

Numeric (10) Any number 

between 1 and 

2,147,483,648

Required. 

Assigned and provided by the Tariff Submitter. 

This can be any value in the valid range of 

numbers, but it must be unique across all Tariff 

Filings for a specific Tariff Submitter.

Filing Title / 

Description

filing_title The title given to the Tariff Filing 

by the Tariff Submitter.

Alphanumeric (80) Free form text. Not required to re-establish a tariff record data 

base. This data provided only for providing a 

user with a visual key for the Tariff Record.

Type of Filing Code filing_type A code that identifies the specific 

FERC defined type of Tariff Filing 

as set forth in Title 18 Code of 

Federal Regulations Parts 35, 

154, 284, 300, 341 or other Parts 

as required by the Commission 

(e.g., initial, compliance, 

surcharge, etc.). The Type of 

Filing will dictate the data 

requirements for the subject filing

Numeric (10) See list of 

codes posted @ 

www.ferc.gov

Required. 
eTariff Viewer 

Public

42 September 2015

Business Name

(1)

Element Name

(2)

Definition of Data Element

(3)

Field Format

(length)

(4)

Valid Values

(5)

Usage 

Responsibility

Conditions 

(6)

Associated Filing 

Identifier

associated_filing_id The Tariff Filing Identifier 

associated with a previously filed 

Tariff Record which the subject 

Tariff Record replaces. 

Note: This is used in conjunction 

with the Associated Record 

Identifier and the Associated 

Option Code (below).

Numeric (10) Number 

between 1 and

2,147,483,648 

used by the 

Tariff Submitter 

in a previous 

Tariff Filing

Conditional. 

Assigned by the Tariff Submitter.

This is not applicable to all Type of Filings. 

Where the Type of Filings permits or requires its 

use, it must refer to a previous Tariff Filing, and 

the value should be that previous Tariff Filing's 

Filing Identifier. 

Associated Record 

Identifier

associated_record_id This is used to associate the 

specific content with a previously 

filed Tariff Record. For example, 

withdrawal Tariff Filings must 

identify the content being 

requested to be withdrawn.

Note: This is used in conjunction 

with the Associated Filing 

Identifier (above) and the 

Associated Option Code

(below).

Numeric (10) Number 

between 1 and

2,147,483,648 

used by the 

Tariff Submitter 

for the targeted 

Tariff Record 

Identifier

Conditional. 

Assigned by the Tariff Submitter.

This is not applicable to all Type of Filings. 

Where it is used, it must refer to a Tariff Record 

Identifier in the associated filing.

Associated Option 

Code

associated_option_code An identifier that designates the 

alternative associated record 

option of a previously filed Tariff 

Record. 

Note: This is used in conjunction 

with the Associated Filing 

Identifier and the Associated 

Record Identifier (above).

Character (1) "A" thru "Z" 

used by the 

Tariff Submitter 

for the targeted 

Tariff Record 

Identifier

Conditional. 

Assigned by the Tariff Submitter.

Where it is used, the value should be the 

applicable Option Code value for the Associated 

Record Identifier.
eTariff Viewer For Official Use Only

Public

43 September 2015 

Business Name

(1)

Element Name

(2)

Definition of Data Element

(3)

Field Format

(length)

(4)

Valid Values

(5)

Usage 

Responsibility

Conditions 

(6)

Record Current 

Status

record_current_status Tariff record status as of the Tariff 

Export Date.

Alphanumeric (15) Pending

Tolled

Conditionally 

Accepted

Conditionally 

Effective

Accepted

Effective

Suspended

Required

Current Effective 

Date

current_effective_date If the FERC Action Status for the 

Tariff Record is Pending, then the 

date is Tariff Record Proposed 

Effective Date. If the FERC Action 

Status for the Tariff Record is 

Accepted or Suspended, the date 

is that provided by Commission 

order. 

Date (10) YYYY-MM-DD

FERC Order Date ferc_order_date Date the FERC Order issued. Date (10) YYYY-MM-DD Provide if available.

FERC Action 

Status

ferc_action_status The status of the Tariff Record 

before the Commission.

Alphanumeric (15) Pending

Accepted

Suspended

Suspension Motion suspend_motion An indication of whether or not the 

Tariff Records should 

automatically go into effect at the 

end of the applicable suspension 

period.

Character (1) "Y" or "N" Conditional based off of Type of Filing. 

Provided by the Tariff Submitter. 
eTariff Viewer 

Public

44 September 2015

XML Schema for etariff Export

Set forth below is Version 1 of the XML schema for the eTariff export that will be used to export tariff records from the 

Commission’s tariff data base:

<?xml version="1.0" encoding="utf-8"?>

<xs:schema xmlns="http://ferc.gov/etariffExport.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" targetNamespace="http://ferc.gov/etariffExport.xsd"

elementFormDefault="qualified" id="ferc_tariff_filing">

<xs:element name="document">

<xs:complexType>

<xs:choice>

<xs:element name="ferc_filing_data" maxOccurs="unbounded">

<xs:complexType>

<xs:sequence>

<xs:element name="tariff_id" type="xs:integer" nillable="true"/>

<xs:element name="tariff_title" type="xs:string" nillable="true"/>

<xs:element name="company_id" type="xs:string" nillable="true"/>

<!-- tariff_export_date format yyyy-mm-ddThh:mmZ , T stands for time value start and 'Z' stands 

for universal time-->

<xs:element name="tariff_export_date" type="xs:dateTime" nillable="true"/>

<xs:element name="schema_version" type="xs:string" nillable="true"/>

<xs:element name="export_schema_version" type="xs:string" nillable="true"/>

<xs:element name="record_data" minOccurs="0" maxOccurs="unbounded">

<xs:complexType>

<xs:sequence>

<xs:element name="record_id" type="xs:integer" nillable="true"/>

<xs:element name="option_code" type="xs:string" nillable="true"/>

<xs:element name="record_title" type="xs:string" nillable="true"/>

<xs:element name="record_content_desc" type="xs:string"

nillable="true"/>

<xs:element name="record_version_num" type="xs:string"

nillable="true"/>

<xs:element name="record_narrative_name" type="xs:string"

nillable="true"/>

<xs:element name="collation_value" type="xs:integer" nillable="true"/>

<xs:element name="record_parent_id" type="xs:integer"

nillable="true"/>
eTariff Viewer For Official Use Only

Public

45 September 2015 

<xs:element name="proposed_effective_date" type="xs:date"

nillable="true"/>

<xs:element name="priority_order" type="xs:integer" nillable="true"/>

<xs:element name="record_content_type_code" type="xs:integer"

nillable="true"/>

<xs:element name="record_binary_data" type="xs:base64Binary"

nillable="true"/>

<xs:element name="record_plain_text" type="xs:string" nillable="true"/>

<xs:element name="record_change_type" type="xs:string"

nillable="true"/>

<xs:element name="filing_id" type="xs:integer" nillable="true"/>

<xs:element name="filing_title" type="xs:string" nillable="true"/>

<xs:element name="filing_type" type="xs:integer" nillable="true"/>

<xs:element name="associated_filing_id" type="xs:integer"

nillable="true"/>

<xs:element name="associated_record_id" type="xs:integer"

nillable="true"/>

<xs:element name="associated_option_code" type="xs:string"

nillable="true"/>

<xs:element name="record_current_status" type="xs:string"

nillable="true"/>

<xs:element name="current_effective_date" type="xs:date"

nillable="true"/>

<xs:element name="ferc_order_date" type="xs:date" nillable="true"/>

<xs:element name="ferc_action_status" type="xs:string"

nillable="true"/>

<xs:element name="suspend_motion" type="xs:string" nillable="true"/>

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:choice>

</xs:complexType>

</xs:element>

</xs:schema>