Source: http://www.docstoc.com/docs/126292302/etariff-ttf091307w4
Timestamp: 2013-12-20 03:10:51
Document Index: 83789027

Matched Legal Cases: ['arts 35', 'arts 35', 'arts 35', 'arts 35', 'arts 35', 'art         164', 'arts 35']

etariff ttf091307w4
Gas / Electric / Oil Coalition Work Paper 3 of 5
NAESB eTariff Technical Task Force Meeting 7/278/23/2007
Updated Proposed Draft Implementation Guide
At the eTariff Technical Task Force (eTTF) meeting on August 23,             Formatted: Font: 14 pt
2007, changes in terminology were suggested. Following is the                Formatted: Justified
previous GEOC Work Paper for the 7/27/07 subcommittee meeting
(Proposed Draft Implementation Guide) as modified to reflect the
terminology changes suggested by the eTTF.              The significant
modifications include, but are not limited to the following:                 Formatted: Font: 14 pt
   Changed all references in the proposed draft implementation      Formatted: Bullets and Numbering
 from “data base” or “Tariff” to “Book”
 from “Record” to “Item”
Formatted: Indent: Left: 1.08&quot;
   Addition of certain data elements necessary for technical        Formatted: Bullets and Numbering
Formatted: Indent: Left: 0.7&quot;
   Re-ordered the data elements to match the order that they        Formatted: Bullets and Numbering
appear in the xml schema
Note:          This work paper is being provided for the eTariff Technical   Formatted: Indent: Left: 0&quot;, Hanging: 1&quot;
Task Force meeting of September 13-14, 2007 solely for
reference purposes. The modifications in terminology still
need to be agreed upon at the eTariff Subcommittee
meeting of October 11-12, 2007. It should also be noted
that these changes have not been agreed to by the GEOC
and are still subject to change.
Implementation Guide for Electronic TariffBook Filing
NAESB WGQ Standards [0.4.z] and WEQ Standard [X]
(Draft Updated 7/278/23/07 by eTariff Technical Task Force)
This Implementation Guide is a framework for a single document incorporating the following
   Table of Contents
A BRIEF explanation of the applicability and purpose of this Implementation Guide – (an
initial draft is provided and still to be finalized)
   Business Process
   Technical Implementation of Business Process (TIBP) which is a narrative
description of the use of the data tables and the process. (A shell is provided
with the start of a list of potential concepts to be included – additional
work needs to be done on this section. )
   Sample Paper – this may contain the flow diagram and an example of a
tariffbook filing (yet to be determined if this needs to be included and if so,
what needs to go in this section)
   Data Tables
There are three data tables (filing data, attachment data and tariff record content data).
For each data element contained in these tables the following are provided:
   the xml meta data field names that will be used in the xml schema;
   the usage and conditions for use of each piece of data
 The field format and valid values for what can be inserted in to each field (e.g.
size of field, whether it is alphanumeric, numeric or just a character, etc.)
(The last two columns (Columns 7 and 8) contain questions and clarifications for
the data elements. Once the data elements have been determined and clearly
defined, the data in these columns could be used as information that could be
contained in the TIBP.)
   Code Values Tables / Reference Tables
These tables contain the actual codes that will be used to fill in the fields for those data
elements where everyone needs to be using the same codes.
(A list of the tables needed is provided and still needs to be completed and
verified against FERC codes.)
   Technical Specifications
This section contains such things as the xml schema, an example of a filing, reference
tables, etc..
(This is currently being worked on in an eTariff Technical Subcommittee).
Topic                         Details                                               Page
Business Process              Technical Implementation of Business Process
Diagram of a TariffBook Filing through a Potential
Glossary of Terms - (see note on that page)
Filing Attachment Data
Tariff Record Book Item Content Data
Code Values / Reference Tables
Code Values for Data Elements
Filing Types, their related codes and
required attachments for each type
For each Filing Type – a list of document
attachments that can be waived
Cross Reference of Filing Types to
Attachment Type Code
Attachment Reference Codes
List of Special Characters that are not
valid for the Supporting Attachment
Technical Specifications of   See outline for suggested topics and the
Web Portal                    Acceptable File Formats
This implementation guide is for use by an entity required to electronically submit
TariffBook Filings to the Federal Energy Regulatory Commission (Commission)
pursuant to Title 18 Code of Federal Regulations Parts 35, 154, 284, 341 or other Parts
as required by the Commission. Following is a guide describing the various
processes/mechanisms, data tables, code values / reference tables, and technical
specifications used in the submission of Tariffs (including OATTS), Rate Schedules,
certain service agreements, Statement of Conditions, rates, and any other material the
Commission requires a Company to file electronically in accordance with NAESB WGQ
Standards [0.4.z] and WEQ Standard [X].
Potential XML Data Flow to FERC
Tariff XML Package to FERC
•Filing Data &amp; metadata
•Attachment Data &amp; Attachment     FERC Firewall
Tariff               metadata
Sheets &amp;
•Tariff Content Data &amp; metadata
and                                                        FERC eTariff
Notice               maintained                                                     database
* FERC will make this information
available through the Public Viewer
* Continue to post your tariff
to your informational postings
website as you do today
Technical Implementation of Business Processes
(AKA Explanation of Business Process)
NOTE: Once the overall business requirements for a web portal have been
established, this section will contain a narrative description of the
applicability and process that matches the diagram and the examples
contained in the Implementation Guide.
Examples of concepts that could be included– not in any order of priority:
   The FERC will receive the whole filing, perform its validations off-line and then
provide e-mail notification to the TariffBook Submitter as to whether the filing is
accepted or rejected and why.
   If the filing does not satisfy the validation checks, the TariffBook Submitter will need
to resubmit a corrected version of the filing in its entirety.
   The following three methods will allow a TariffBook Submitter to place a tariffbook
“out of effect” and put another tariffbook “into effect” such as might be the case
when a TariffBook Submitter wishes to retire First Revised Volume No. 1 which
consists of 1000 records and replace it with Second Revised Volume No. 1 which
consists of 1000 records:
o Replace each and every record of First Revised Volume No. 1 with
superceding record;
o Cancel First Revised Volume No. 1 and, in the same filing, file Second
Revised Volume No. 1; or
o Cancel the database book that contains First Revised Volume No. 1, and
create a new database book for Second Revised Volume No. 1. However,
this approach is not recommended as searches for historical data would
have to cross databasesbooks, and companies would have to make two
filings to accomplish the objective due to a software limitation restricting
tariffbook filings to changes in one tariff databasebook per filing.
Other concepts that could be included:
   Explanation of what makes a TariffBook Filing unique – combination of Company
Identifier, Filing Identifier, Database Book Identifier and possibly others.
   Explanation of Filing Options for Tariff Book Item Records – Whole Document,
Sheet Based, Section Based
   A database book is a compilation of all Tariffs (including OATTS), Rate Schedules,
certain service agreements, Statement of Conditions, rates, and any other material
the Commission requires a Company to file. A TariffBook Submitter may have
more than one Database Book in effect at any time. A Database Book must contain
at least one Book Item Record.
   A Tariff Book Item Record is single occurrence (row) in a database book and may
consist of multiple fields. It can be created on a sheet based, section based, or
whole document – the sheet or section may include multiple pages / sections.
   The data element fields are the individual pieces that make up the TariffBook Filing.
Each will have a defined format, may be required, conditional or optional and may
have restricted values. A data element field may contain text or a document (e.g. a
.pdf file).
   Attachment Data –
o Have to provide attachment data for every attachment submitted.
o Have to provide attachment data for those that are required even if the
TariffBook Submitter is requesting a waiver of that requirement.
o It is not necessary to provide attachment data for optional attachments that
are not submitted
   Explanations of Supporting Attachment Documents
   Explanation of the difference between the data tables, the data elements and how
together they comprise a TariffBook Filing.
   Explanation of how the pieces of a ‘shared’ tariffbook are filed and related to one
   Explanation of how joint filings are made.
   Explanation of how to submit files that are greater than 10 MB (it may be more
appropriate for this to go in the technical specs section)
   Include where appropriate, the written answer provided by FERC to the Pipeline
Segment questions – posted for the June 4, 2007 meeting -
http://www.naesb.org/pdf2/etariff060407w3.doc
Sample (Example) of a TariffBook Filing
Via an Electronic TariffBook Filing Web Portal
NOTE:       This section will include one or more samples of simple tariffbook filings
as they would appear on paper. These examples would be used to
create corresponding samples in the technical specifications section. It
has yet to be determined what examples will be included, if any should be
included at this time. It is NOT necessary to put an example of every
type of eTariff filing.
(Depending on the successful conclusion of the data tables, TIBP and textual
standards/definitions, this section will not be needed in the Implementation
Line             Term                                      Definition
1       Company                  An entity required to submit Tariff Book Filings to the         Proposed
Commission pursuant to Title 18 Code of Federal                 Definition D-1 for
Regulations Parts 35, 154, 284, 341 or other Parts as           ‘TariffBook
required by the Commission.                                     Submitter’.
2       DatabaseBook             A compilation of all Tariffs, OATTS, Rate Schedules,            TIBP
certain service agreements, Statement of Conditions,
rates, and any other material the Commission requires a
Company to file. A Company may have more than one
Database Book in effect at any time. A Database Book
must contain at least one RecordBook Item.
3       Field                    An element of a Book ItemRecord. A Field will have a            TIBP
defined format, may be required, conditional or optional
and may have restricted values. A Field may contain text
or a document (e.g. a .pdf file).
4       RecordBook Item          A single occurrence (row) in a DatabaseBook. A Record           TIBP
Book Item may consist of multiple Fields.
5       Tariff Book Filing or    A compilation of all document(s) and associated data that       Proposed
Filing                   is required to be filed by a Tariff Book Submitter pursuant     Definition D2
to Title 18 Code of Federal Regulations Parts 35, 154,
284, 341 or other Parts as required by the Commission.
6       Tariff Book Item         A sheet, section or complete tariffbook document filed with     Proposed
Record                   the Federal Energy Regulatory Commission.                       Definition D3
7       Type of Filing           The specific Commission defined type of Tariff Book Filing      Data Table –
/ Filing as set forth in Title 18 Code of Federal Regulations   Definition for
Parts 35, 154, 284, 341 or other Parts as required by the       data element
Commission (e.g. initial, compliance, surcharge, etc.). The     Type of Filing /
type of filing will dictate the data requirements for the       Filing Reference
subject filing.                                                 Code
Draft Electronic TariffBook Data Elements and Descriptions
Note:    Columns (7) and (8) are provided for NAESB discussion purposes and will not be retained in the final Implementation Guide adopted by NAESB.
** Additional discussion is required regarding the population of this element (highlighted).
The examples and commentary in Column 7 and the answers in Column 8 need to be verified with the FERC Staff.
The following specify the Data Dictionary for electronic tariffbook filings. Conceptually, an electronic tariffbook filing consists of the following items:
     Filing Data - describes the overall filing.
     Filing Attachment Data - supporting documents required by specific Type of Filing.
     Tariff ContentBook Item Data - the actual tariffbook &quot;text&quot; or &quot;content&quot; of the TariffBook itself with its associated metadata.
This data defines the filing and this data will be provided with each submission.
Line                                                                                                                                                                     Formatted Table
No.                                                                                                              Usage                   Questions /
FERC                                               Definition of Data      Field Format                        Responsibility             Comments           FERC Staff
work      Business Name      Element Name               Element               (length)     Valid Values         Conditions               and Examples         Answer
paper           (1)               (2)                      (3)                   (4)            (5)                 (6)                       (7)               (8)
1        Schema Version      schema_version                                 Alphanumeric                   required                                                        Formatted: Left
Line                                                                                                                                                                                 Formatted Table
No.                                                                                                            Usage                      Questions /
FERC                                            Definition of Data       Field Format                        Responsibility                Comments                  FERC Staff
work     Business Name       Element Name            Element                (length)    Valid Values          Conditions                  and Examples                Answer
paper          (1)                (2)                   (3)                    (4)           (5)                  (6)                          (7)                      (8)
52     Company Identifier   company_id     A FERC-Designated            Numeric (10) Any number       Required.                      Is this the current         This will be
Company Identifier code      This may be  between 1 and    This data element is part      Company No.                 assigned once the   Formatted: Not Highlight
used to identify an entity   aAlphanumeri 2,147,483,648    of the filing identification   assigned by FERC -          company registers
required to submit           c (10)                        key.                           three digit code, the       with FERC.
TariffBook Filings to the                                  Assigned by FERC and           current six digit code or
Commission pursuant to                                     provided in the filing by      the company number
Title 18 Code of Federal                                   the Company.                   used for the distributed
Regulations Parts 35, 154,                                                                software?
284, 341 or other Parts as                                                                a) How will joint filings   a) Identifies
required by the                                                                                be handled?                whose
Commission.                                                                                                               tariffbook is
b) Can multiple                 being
Company                      amended.
Identifiers be           b) Not applicable
entered for one
Filing Identifier?
Line                                                                                                                                                                               Formatted Table
No.                                                                                                               Usage                   Questions /
FERC                                             Definition of Data         Field Format                        Responsibility             Comments                FERC Staff
work     Business Name       Element Name             Element                  (length)     Valid Values         Conditions               and Examples              Answer
paper          (1)                (2)                    (3)                      (4)            (5)                 (6)                       (7)                    (8)
63     Filing Identifier   Filing_id       A unique identifier for the     Numeric (10) Any number    Required.                     a) If Company No. is       a) Yes, it can be
specific filing for the         Possibly     between 1 and This data element is part         164, could the first      any
Company.                        Alphanumeric 2,147,483,648 of the filing identification      filing be 1640001?        standardized
key.                                                        number the
Assigned and provided by                                    company
the Company.                                                wants. Does
This can be any value in                                    chronological.
numbers, but it must be
unique across all filings for b) Alternatively, could    b) Yes
a specific Company.               the date be
incorporated (e.g.
1640403071 or
1640403072?
c) Will this data          c) Yes
element be visible
on the FERC
d) Will it be a piece of   d) Yes
when the tariff book
is re-assembled by
FERC?
e) Will it be available    e) Yes
for use as search
74     Filing              filing_title    The title given to the filing   Alphanumeric Free form text.   Required.                  a) Does alphanumeric a) Yes, printable
Title/Description                   by the filing Company.          (80).                          Assigned and provided by      include special      characters
the Company.                  characters (e.g.     only. XML
This will not be used in      apostrophes)?        UTF-8
FERC’s eTariff database    Example:
and will be used in         “Non-conforming
eLibrary.                  Agreements 03.2007”
or &quot;ACA Filing&quot;
No.                                                                                                            Usage                    Questions /
FERC                                           Definition of Data      Field Format                          Responsibility              Comments                 FERC Staff
work     Business Name    Element Name              Element               (length)      Valid Values          Conditions                and Examples               Answer
paper          (1)             (2)                     (3)                   (4)             (5)                  (6)                        (7)                     (8)
85     Database Book    database_id       A unique identifier for the  Numeric (10)   Any number    Required.                      a) Could be “1” for all a) This is not a          Formatted Table
Identifier       (FERC name =      database book for the                       between 1 and This data element is part          submitting entities.     problem. The
tariff_id)        Company as it pertains to                   2,147,483,648 of the filing identification       Is this a problem or     combination of
the database book being                                   key.                               will the combination     the Company
modified by the filing. This                              Assigned and provided by           of the Company           Identifier, Filing
FERC staff does   can be any value in the                                                                      Identifier and the       Identifier, and
not object to                                                               the Company.
allowable range of                                                                           Database Book            the Database
name change.      numbers, but it must be                                                                      Identifier be used to    Book Identifier
Subject to        unique for each company’s                                                                    differentiate them?      will create the
technical         databasebook. A company                                                                                               uniqueness
reviewbook_id.    may have more than one                                                                                                required.
active databasebook.                                                                     b) If only one            b) Keith Pierce
database book is         transition
Note;                                                                                        “active” at a time,      issue.
eTariff Technical Task                                                                       how does a TSP
Force will review and                                                                        submit overlapping
determine naming                                                                             changes (i.e. during
convention and whether                                                                       a rate case
there is a need to define                                                                    settlement and or
Database.                                                                                    later needing to
submit the revised
rate sheets for a
databasebook)?
c) Will a company         c) Refer to
whose rate               discussion on
schedule is within       Company
an ISO / RTO             Identifier.
OATT fall within the
ITO / RTO
database book or
have its own stand
databasebook? If
Line                                                                                                                                                                           Formatted Table
No.                                                                                                              Usage                  Questions /
FERC                                             Definition of Data        Field Format                        Responsibility            Comments               FERC Staff
work     Business Name    Element Name                Element                 (length)    Valid Values          Conditions              and Examples             Answer
paper          (1)             (2)                       (3)                     (4)           (5)                  (6)                      (7)                   (8)
96     Database Book    database_title       The title or name assigned   Alphanumeric Free form text.   Required for initial, first- a) Does alphanumeric a) Yes, printable
Title            (FERC name =         to each company’s            (100)                          time filings. After the         include special      characters
tariff_title)book_ti databasebook.                                               initial submission, the         characters (e.g.     only. XML
tle                                                                              Database Book Identifier        apostrophes)?        UTF-8
is used.                     Comment:
Assigned and provided by        Needs to have the
the Company.                    ability to be
This name of the database       general, not
book may change but the         specific to one
name of Database Book           tariffbook volume.
ID can not change.           Example:
“Stingray Pipeline
Company THIRD
VOLUME NO. 1” or
&quot;Trunkline Gas
Company, LLC&#39;s
tariffbook&quot; (which
Volume No. 1 and
Volume No. 2).
Line                                                                                                                                                                                             Formatted Table
No.                                                                                                                     Usage                       Questions /
FERC                                            Definition of Data           Field Format                             Responsibility                 Comments                 FERC Staff
work     Business Name      Element Name             Element                    (length)       Valid Values            Conditions                   and Examples               Answer
paper          (1)               (2)                    (3)                        (4)              (5)                    (6)                           (7)                     (8)
107    Type of Filing /   filing_type     The specific Commission           Numeric (10). Refer to              Required.                      a) Could the initial        a) Not applicable
Filing Reference                   defined type of TariffBook                      http://www.ferc       When using the                      choices in the            for Option A
Code                               Filing / Filing as set forth in                 .gov/docs-            component based filing              dropdown menu be
Title 18 Code of Federal                        filing/etariff/fil-   options, chosen on the              based on whether
Regulations Parts 35, 154,                      soft-                 FERC website from a drop            the Company is
284, 341 or other Parts as                      help/etariff-         down menu. Some                     electric, gas, or oil?
required by the                                 rules-table.pdf       examples are:                  b) How will changes to b) Will be
Commission (e.g. initial,                       for the current       1000 (&#167; 35.13(a)(2)(iii) -          the reference             published on
compliance, surcharge,                          list of codes.        Rate Schedule Changes               codes and filing          the FERC
etc.). The type of filing will                  OR the                Other Than Rate                     requirements be           website in a
dictate the data                                Reference             Increases/Compliance                communicated in           data friendly
requirements for the                            Table Section         Filing)                             the electronic            format (both
subject filing                                  (TBD)                                                     tariffbook filing         pdf and data
3200 (&#167;342.2(a) -
Establishing Initial Rates -        system?                   processing file
Cost of Service option)                                       format) or via a
Comment:                       FERC order or
When using the ‘Whole                                         NOPR.
Filing’ option, this code is   The URL reflected in
provided by the Company.       Column 5 for the
acceptable codes may
with the final order and
Guide should include
either a reference to
the URL or a table of
Filing Types, their
related codes and
for each type. This
table would need to be
updated as changes
occur. (See attached
Line                                                                                                                                                                                Formatted Table
No.                                                                                                               Usage                    Questions /
FERC                                           Definition of Data         Field Format                          Responsibility              Comments                FERC Staff
work     Business Name      Element Name            Element                  (length)     Valid Values           Conditions                and Examples              Answer
paper          (1)               (2)                   (3)                      (4)            (5)                   (6)                        (7)                    (8)
118    Point of Contact   poc_fname       First name of the person       Character      Free form text.   Required.                 a) Is it correct that the   a) yes. No, use     Formatted: Highlight
First Name                         (point of contact person)      (30).                            Assigned and provided by      Point of Contact           of obtaining
**                                 initiating the submission of                                    the Company.                  must already be            info via
the filing on the FERC                                          The Point of Contact must     eRegistered?               eRegistration
website. This person will                                       be e-Registered with                                     can be tabled
NOT be on the service list.                                     FERC.                                                    to eTariff
Force meeting.
18 CFR154.4,
18 CFR 35.9
b) Must the logon i.d.    b) ???
user have to be the
c) If so, can the Point c) May be able to
of Contact             populate
information data be    based off
pre-filled by the      corresponding
FERC?                  registered
129    Point of Contact   poc_midinit     Middle initial of the person   Character (1). Free form text.   Optional.                   Same questions as         See answers for
Middle Initial                     (point of contact person)                                       Assigned and provided by    included for Point of     Point of Contact
initiating the submission of                                    the Company.                Contact Person First      First Name.
the filing on the FERC                                                                      Name about pre-filling
website. This person will                                                                   name info.
NOT be on the service list.
1310    Point of Contact   poc_lname       Last name of the person        Character      Free form text. Required.                     Same questions as         See answers for
Last Name                          (point of contact person)      (30).                          Assigned and provided by      included for Point of     Point of Contact
initiating the submission of                                  the Company.                  Contact Person First      First Name.
the filing on the FERC                                                                      Name.
website. This person will
No.                                                                                                                Usage                     Questions /
FERC                                             Definition of Data        Field Format                          Responsibility               Comments                  FERC Staff
work     Business Name        Element Name            Element                 (length)     Valid Values           Conditions                 and Examples                Answer
paper          (1)                 (2)                   (3)                     (4)            (5)                   (6)                         (7)                      (8)
1411    Point of Contact     poc_phone       The phone number of the       Character      Numeric Form      Required.                    Same questions as         See answers for
Phone Number                         person (point of contact      (15)           of                Assigned and provided by     included for Point of     Point of Contact
**                                   person) initiating the                       999999999999      the Company.                 Contact Person First      First Name.
submission of the filing on                  999               The Point of Contact         Name about pre-filling
the FERC website. This                                         Phone number must be e-      name info.
person will NOT be on the                                      Registered with FERC.
Digits are interpreted as:
1512    Point of Contact     poc_email       The email address of the      Alphanumeric Free form text.     Required.                    Same questions as         See answers for
email Address                        person (point of contact      (100).                           Assigned and provided by     included for Point of     Point of Contact
**                                   person) initiating the                                         the Company.                 Contact Person First      First Name.
submission of the filing on                                    The Point of Contact email   Name about pre-filling
the FERC website. This                                         address must be              name info..
person will NOT be on the                                      eRegistered with FERC.
service list. This e-mail
address will receive filing
from the FERC.
1613    Company              auth_fname      First name of the person       Character     Free form text.   Required.                    Same questions as         See answers for
Authorizing Person                   authorizing the subject filing (30).                           Assigned and provided by     included for Point of     Point of Contact
First Name                           pursuant to &#167;154.4 (b) (2)                                     the Company.                 Contact Person First      First Name.
**                                   of Title 18 CFR. This                                          The Company Authorizing      Name about pre-filling
person will be on the                                          Person must be e-            name info.
service list.                                                  Registered with FERC         a) Will the header and    a)
the current filing
1714    Company              auth_midinit    Middle initial of the person Character (1). Free form text.    Optional.                    Same questions as         See answers for
Authorizing Person                   authorizing the subject filing                                 Assigned and provided by     included for Point of     Point of Contact
Middle Initial                       pursuant to &#167;154.4 (b) (2)                                     the Company.                 Contact Person First      First Name.
of Title 18 CFR. This                                                                       Name about pre-filling
person will be on the                                                                       name info.
No.                                                                                                                 Usage                   Questions /
FERC                                              Definition of Data        Field Format                          Responsibility             Comments               FERC Staff
work     Business Name       Element Name              Element                 (length)     Valid Values           Conditions               and Examples             Answer
paper          (1)                (2)                     (3)                     (4)            (5)                   (6)                       (7)                   (8)
1815    Company              auth_lname       Last name of the person        Character     Free form text.   Required.                  Same questions as        See answers for
Authorizing Person                    authorizing the subject filing (30).                           Assigned and provided by   included for Point of    Point of Contact
Last Name                             pursuant to &#167;154.4 (b) (2)                                     the Company.               Contact Person First     First Name.
of Title 18 CFR. This                                                                     Name about pre-filling
person will be on the                                                                     name info.
19a    Company              auth_title       The company title of the     Character                         Required.                  This element added to
Authorizing Person   (FERC name not   person authorizing the       (30)                              The Company Authorizing    comply with
Title                provided)        subject filing pursuant to                                     Person Title must be       Regulations.
**                                    &#167;154.4 (b) (2) of Title 18                                     eRegistered with FERC.     a) Is this a data      a) Yes
CFR. This person will be                                       Assigned and provided by       element that FERC
on the service list.                                           the Company.                   will add to its
b) Same question as    b) See answers
included for Point     for Point of
of Contact Person      Contact First
First Name about       Name.
pre-filling name
1916    Company              auth_email       The email address of the     Alphanumeric Free form text.       Required.                 Same question as         See answers for
Authorizer/Signer    (FERC name =     person authorizing the       (100).                            Assigned and provided by   included for Point of    Point of Contact
email                signer_email)    subject filing pursuant to                                     the Company.               Contact Person First     First Name.
**                                    &#167;154.4 (b) (2) of Title 18                                     The Company                Name about pre-filling
CFR. This person will be                                       Authorizer/Signer email    name info.
on the service list.                                           must be eRegistered with
Line                                                                                                                                                                                        Formatted Table
No.                                                                                                                  Usage                    Questions /
FERC                                               Definition of Data         Field Format                         Responsibility              Comments                  FERC Staff
work     Business Name       Element Name               Element                  (length)     Valid Values          Conditions                and Examples                Answer
paper          (1)                (2)                      (3)                      (4)            (5)                  (6)                        (7)                      (8)
2017    Associated Filing   assoc_filing_id   The Filing Identifier for the   Numeric (10)   Any number    Conditional.                  a) What does                a) It ties the
Identifier                            previous filing to which the    (Possibly      between 1 and Assigned and provided by          “associated” mean?          current filing to
subject filing pertains (i.e.   alpha          2,147,483,648 the Company.                                                  a previous
associated).                    numeric)                     This is not applicable to all                                 filing, such as
filing types. Where it is                                     a compliance
used, it must refer to a                                      filing to the
previous filing, and the                                      corresponding
value should be that                                          initial filing.
previous filing&#39;s &quot;filing_id&quot; b) What if the subject      b) the regulations
value.                            filing pertains to          do not allow
An example might be the           more than one               for more than
subject filing is a               unconsolidated              one. Clarify
compliance (or                    previous filing(s)?         with Keith
withdrawal) filing and the                                    PiercePick the
previous, applicable filing                                   most logical
to which it pertains must                                     one.
be identified in this field.  c) If we are complying      c) same answer
Will not be required when         with a previous             as in b) above
the filing will create a new      order it would              Clarify with
docket.                           pertain and could           Keith Pierce.
relate to more than
one filing (could all   Note: per FERC
be under one            staff 6/4/07, the
docket number).         issue in b) and c)
Therefore, is it        may be a general
possible to             issue that FERC
associate more          needs to address
than one filing?
Identifiers could
 Compliance filings
Line                                                                                                                                                                                      Formatted Table
No.                                                                                                                 Usage                      Questions /
FERC                                              Definition of Data         Field Format                         Responsibility                Comments                FERC Staff
work     Business Name       Element Name              Element                  (length)    Valid Values           Conditions                  and Examples              Answer
paper          (1)                (2)                     (3)                      (4)           (5)                   (6)                          (7)                    (8)
2118    Fee Reference       FeePay_confirm_ The confirmation number          ??Blank or a free form text&quot;   Conditional based off of a) In 18 CFR 154 it    a) There are still
CodePayment         code            for the associated fee that      confirmation                   Type of Filing               says there are no     some types of
Confirmation Code                   has been previously              numberAlpha                    Provided by the Company.     longer any fees.      filings that
submitted via                    numeric (20?)                                               Do the fees           require a fee.
www.pay.gov, as                                                                              referenced here
applicable.                                                                                  apply to a segment
b) Is this to say      b) This is the
whether a fee was     confirmation
submitted or what     number for the
kind of fee or        fee that has
something else?       already been
www.pay.gov
c) Why was it added? c) see a) above
d) How does a fee get d) The fee is not
attached?             attached here.
2219    Suspension Motion suspend_motion      An indication of whether or    Alphanumeric &quot;Y&quot; or &quot;N&quot;        Conditional based off of     a.) Since this is only      a) Not required
not the Tariff RecordsBook     (1)                            Type of Filing.                  for use in gas             for electrics or
Items should automatically                                    Provided by the Company.         filings, will the          oil.
go into effect at the end of                                  If the value is “N”, at the      electric industry
the applicable suspension                                     end of the suspension            submitters be
period.                                                       period, a separate filing is     required to fill this
required to place the Tariff     in with a ‘N’?
RecordsBook Items into
FERC                                              Definition of Data         Field Format                         Responsibility             Comments                FERC Staff
work     Business Name       Element Name              Element                  (length)      Valid Values         Conditions               and Examples              Answer
paper          (1)                (2)                     (3)                      (4)             (5)                 (6)                       (7)                    (8)
The following shaded data elements are not
included in the xml schema
19b    Additional          comm_fname_1      First name of additional       Character                       Optional.                  a) Can FERC               a) FERC Staff is
Communication       comm_fname_2      designee(s) for                (30) per entry                  Assigned and provided by      accommodate 3             willing to
First Name          comm_fname_3      communication for the                                          the Company.                  additional names?         discuss within
**                  (FERC name not    subject filing. This person                                    The Additional                                          the FERC
provided)         will be on the service list.                                   Communication                                           capabilities.
designee(s) must be        b) if these additional    b)
eRegistered with FERC          contacts can be
May submit up to 3             added, will the
entries.                       regulations be
modified to remove
include them in the
transmittal letter?
19c    Additional          comm_midinit_1    Middle initial of additional   Character (1)                   Optional.                  Same question as          See answer for
Communication       comm_midinit _2   designee(s) for                per entry                       Assigned and provided by   included for Additional   Additional
Middle Initial      comm_midinit _3   communication for the                                          the Company.               Communications First      Communications
(FERC name not    subject filing. This person                                    May submit up to 3         Name.                     First Name.
provided)         will be on the service list.                                   entries.
19d    Additional          comm_lname_1      Last name of the additional    Character                       Optional.                  Same question as          See answer for
Communication       comm_lname_2      designee(s) for                (30) per entry                  Assigned and provided by   included for Additional   Additional
Last Name           comm_lname_3      communication for the                                          the Company.               Communications First      Communications
Line                                                                                                                                                                          Formatted Table
No.                                                                                                           Usage                     Questions /
FERC                                          Definition of Data         Field Format                       Responsibility               Comments               FERC Staff
work     Business Name   Element Name              Element                  (length)    Valid Values         Conditions                 and Examples             Answer
paper          (1)            (2)                     (3)                      (4)           (5)                 (6)                         (7)                   (8)
19e    Additional       comm_phone_1     Phone number of the            Numeric (15)   Numeric Form   Required for each            Same question as          See answer for
Communication    comm_phone_2     additional designee(s) for     per entry      of             additional communication     included for Additional   Additional
Phone Number     comm_phone_3     communication for the                         999999999999   designee(s).                 Communications First      Communications
**               (FERC name not   subject filing. This person                   999            The Additional               Name.                     First Name.
provided)        will be on the service list.                                 Communication Phone
Number must be e-
Registered with FERC.
May submit up to 3
19f    Additional       comm_email_1     Additional designee(s) for     Alphanumeric Free form text   Required for each            Same question as          See answer for
Communication    comm_email_2     communication for the          (100) per                     additional communication     included for Additional   Additional
email            comm_email_3     subject filing. This person    entry                         designee(s).                 Communications First      Communications
**               (FERC name not   will be on the service list.                                 The Additional               Name.                     First Name.
provided)                                                                     Communication email
must be e-Registered with
Filing Attachment Data:
This defines data for each supporting document that is either (1) being provided with the filing or (2) for which a waiver is requested
No.                                                                                                             Usage                        Questions /
FERC                            Element                                 Field Format                          Responsibility                  Comments           FERC Staff
work     Business Name           Name      Definition of Data Element      (length)     Valid Values           Conditions                    and Examples         Answer
paper          (1)                 (2)                 (3)                    (4)            (5)                   (6)                            (7)               (8)
24       Company             company_id    A FERC-Designated             Numeric (10)   Any number    Required.                          Same as filing data.   Same as filing
Identifier                        Company Identifier code.                     between 1 and This data element is part                                 data.
2,147,483,648 of the filing identification
Note: FERC
Staff @ 6/4/07
Assigned by FERC and                                   meeting stated
provided in the filing by                              that this may not
the Company.                                           need to be re-
sent but
may want it.
Refer to Line
25       Filing Identifier   filing_id     A unique identifier for the   Numeric (10)   Any number    Required.                Same as filing data.             Same as filing
specific filing for the                      between 1 and Assigned and provided by                                  data.
Company.                                     2,147,483,648 the Company.
This can be any value in                               Staff @ 6/4/07
the valid range of                                     meeting stated
numbers, but it must be                                that this may not
unique across all filings for                          need to be re-
a specific Company.                                    sent but
No.                                                                                                          Usage                Questions /
FERC                        Element                                   Field Format                         Responsibility          Comments        FERC Staff
work     Business Name       Name        Definition of Data Element      (length)     Valid Values          Conditions            and Examples      Answer
paper          (1)             (2)                   (3)                    (4)            (5)                  (6)                    (7)            (8)
25A      Database         database_id  A unique identifier for the    Numeric (10)    Any number    Required.                                     Note: added by
Identifier       (FERC name = database for the Company as                    between 1 and This data element is part                     FERC staff @
tariff_id)   it pertains to the database                    2,147,483,648 of the filing identification                  6/4/07 meeting.
being modified by the filing.                                key.
This can be any value in the                                 Assigned and provided by                      Staff @ 6/4/07
allowable range of numbers,                                  the Company.                                  meeting stated
but it must be unique for each
that this may not
company database. A
need to be re-
company may have more
than one active database.
No.                                                                                                               Usage                       Questions /
FERC                        Element                                   Field Format                              Responsibility                 Comments                  FERC Staff
work    Business Name        Name        Definition of Data Element      (length)     Valid Values               Conditions                   and Examples                Answer
paper         (1)              (2)                   (3)                    (4)            (5)                       (6)                           (7)                      (8)
2620     Attachment       att_ref_code   The FERC assigned             Numeric (10)   Please refer to       Required.                   a) Can there be more            a) No, currently
Reference Code                  reference code for each                      http://www.ferc       Assigned and provided by        than one attachment         if there is more
attachment type.                             .gov/docs-            the Company.                    with the same               than one, than
filing/etariff/fil-                                   reference code in the       the first one has
soft-                 If attachment pertains to a     same filing?                the correct code
help/etariff-         specific document defined                                   and the
rules-table.pdf       for the Type of Filing, the                                 remaining ones
appropriate document        b) Since FERC is willing
for the current                                                                   would be under
reference code must be         to waive notice
list of codes.                                                                    the code for
used. If the attachment is     requirement and has
an &#39;additional&#39; or             been for several years
supplemental document          for electric filings,        FERC Staff
that does not pertain to a     http://www.ferc.gov/doc      willing to look at
specific supporting            s-filing/etariff/fil-soft-   providing way to
document required by the       help/etariff-rules-          have multiple
filing type, and does not      table.pdf, should be         attachments
already have a specific        updated to reflect           having the same
code assigned to it, the       current practice.            code
value should be “0”.        Comment:                        To be reviewed
Note: the code is different The URL reflected in            by eTariff
for each filing type.       Column 5 for the                Technical Task
acceptable codes may            Force.
When using the              need to be updated with
component based filing      the final order and as
options, the Attachment                                     b) To be
Reference Code is chosen                                    addressed in
on the FERC website from The Implementation Guide           Final Rule.
a drop down menu. When should include either a
using the ‘Whole Filing’    reference to the URL or a
option, this code is        table of Attachment
provided by the Company. Reference Codes. This
table needs to be
reviewed for accuracy and
Need an Attachment Type FERC will
Code for the pdf version of provide.
the entire filing.
FERC                         Element                                      Field Format                          Responsibility              Comments                FERC Staff
work     Business Name        Name         Definition of Data Element        (length)     Valid Values           Conditions                and Examples              Answer
paper          (1)              (2)                    (3)                      (4)            (5)                   (6)                        (7)                    (8)
26A21    Attachment        Att_titleatt_des The title description ofgiven to Alphanumeric Free form text.   Required.                a) Does alphanumeric          a) Yes,
Description       c                the attachment submitted by (80).                               Assigned and provided by    include special               printable
the filing Company.                                             the Company.                characters (e.g.              characters
apostrophes)?                 only. XML
This will not be used in                                  UTF-8
FERC’s eTariff database
and will be used in
eLibrary.                b) Will this description be   b) will be in the
used in eLibrary?             future
Note: added by
FERC staff @
6/4/07 meeting.
2722     Attachment       att_waiver_req An indication of whether or      Character (1)   &quot;Y&quot; - waiver is   Conditional on whether      a) Does a waiver         a) No, however,
Waiver Requested uest           not the filing Company is                        requested         the Attachment Reference       document need to be      if the
requesting a waiver for                                            Code allows for a waiver       attached?                document is
&quot;N&quot; or &quot; &quot; -
submission of the document                                         of the attachment.                                      required, the
waiver not                                    Comment:
specified by the Attachment                                                                                                appropriate
requested         Assigned and provided by
Reference Code.                                                                                The Implementation Guide    attachment
should include a table      reference
For each document that is indicating for each Filing    code must
requested to be waived,     Type which attachment       be
the attachment reference documents can be waived.       submitted
code (above) is provided, This table would need to      and then a
and a value of &quot;Y&quot; is       be updated as changes       Waiver
entered here. If an actual occur.                       Requested
document is being                                       code of “Y”
provided, this value should                             should be
be &quot;N&quot; or left empty                                    submitted.
(i.e. “ “).                                             No other
No.                                                                                                          Usage                       Questions /
FERC                       Element                                    Field Format                         Responsibility                 Comments                 FERC Staff
work    Business Name       Name         Definition of Data Element      (length)     Valid Values          Conditions                   and Examples               Answer
paper         (1)             (2)                    (3)                    (4)            (5)                  (6)                           (7)                     (8)
2823     Supporting      docatt_raw_dat This is the actual document    Binary (10 50   Actual         Required if attachment        a) Transmitted in what        a) native           Formatted: Not Highlight
Attachment      a              &#39;content&#39;.                     MB)             document       document is not waived.          format?                       formats as in
Document                                                                      data.                                                                         eLibrary
(see                           Two versions may be        b) Since it is not
questions)                     required. The version in      anticipated that the
pdf, ascii or tab-delimited   TariffBook Submitter   b) The
is required.                  will be expected to       TariffBook
transmit the file as      Submitter
The native format is only
binary data the Field     will be
required for certain types
Format (length) entry     expected to
of attachments that are
needs to be updated to    provide the
required to be filed in
what is expected to be    field in
sent.                     binary as
Provided by the Company.                                well as the
c) What if a single           c) It must be
attachment is larger           broken down
than 10 MB?                    into 2
is 12 MB,
which is &gt;
d) If the two attachments     c) and d) To be
in the answer to c) are       reviewed by
sent, how will the two        the eTariff
parts be associated?          Technical
No.                                                                                                          Usage                      Questions /
FERC                       Element                                     Field Format                        Responsibility                Comments                 FERC Staff
work    Business Name       Name          Definition of Data Element      (length)    Valid Values          Conditions                  and Examples               Answer
paper         (1)             (2)                     (3)                    (4)           (5)                  (6)                          (7)                     (8)
2924     Supporting      docatt_filenam   The complete file name,       Alphanumeric Free form text.   Required if document is     a) Do we include file          a) Yes
Attachment      e                including the extension,      (64).                          not waived.                      name extensions?
Document File                    assigned by the TariffBook                                                                    (e.g., “Transmittal
Assigned and provided by
Name                             Submitter of the Supporting                                                                   Letter.doc”). If yes, the
Attachment Document being                                                                     definition of this data
attached.                                                    This file name will be used      element needs to
to identify the document         include that instruction.
and the extension will be
b) Are spaces allowed in b) To be
file names?                     reviewed by
the eTariff
If a document is being                                         Technical
attached, a valid file name                                    Task Force.
must be entered in this
field. Valid file names
cannot include special      The Implementation Guide
characters such as: ? / * \ should include a table
&quot;&#39;&gt;&lt;                        indicating the special
characters that are not
valid for inclusion in file
names. This table would
need to be updated as
25       Attachment      Att_content_ty   Version of software used to   Numeric (10)                   Required
Content Type    pe_code          create the specific
Code                             Attachment Document.
No.                                                                                                           Usage                    Questions /
FERC                        Element                                    Field Format                         Responsibility              Comments                 FERC Staff
work     Business Name       Name         Definition of Data Element      (length)     Valid Values          Conditions                and Examples               Answer
paper          (1)             (2)                    (3)                    (4)            (5)                  (6)                        (7)                     (8)
3026     Attachment       doc_sec_lvlatt The level of security          Character    &quot;P&quot; - public      Conditional, mandatory     a) The attachments in this    a) No, the           Formatted: Not Highlight
Document         _security_level requested for the specific    Alphanumeric                   when the document is          Filing Attachment Data     maps should be       Formatted: Not Highlight
&quot;B&quot; - public
Security Level                   attached document             (1)                            attached.                     are non-tariffbook         simple or they
corresponding to the                                                                       information. Can this      will be
applicable Attachment                        &quot;M&quot; - privileged                              element also apply to      considered
Reference Code.                              &quot;X&quot; - Critical                                Tariff RecordBook Item     CEII.
The document for which       level data in the Tariff   Regardless of
the security is being        Content Book Item          whether the
requested can not be         Data section (i.e.,        maps are
bundled in with the other    maps)?                     included or not
documents.                                              the security
level is not
tariffbook.          Formatted: Not Highlight
from Keith           Formatted: Not Highlight
applicable –
b) In the Valid Values,          if it is waived   Formatted: Not Highlight
does the waiver refer        then it is
to a waiver of the           considered
security level or a          “pubic”.
Tariff Record ContentBook Item Data
This provides the data for each Tariff Book Record Item (i.e., tariff, rate schedule or non-conforming service agreement, as applicable) of a TariffBook document
that is being submitted for filing.
No.                                                                                                             Usage                      Questions /
FERC       Business                                                      Field Format                         Responsibility                Comments               FERC Staff
work        Name            Element Name    Definition of Data Element      (length)     Valid Values          Conditions                  and Examples             Answer
paper        (1)                 (2)                    (3)                    (4)            (5)                  (6)                          (7)                   (8)
32       Company             company_id     A FERC-Designated             Numeric (10)   Any number      Required.                    Same as filing data.       Same as filing
Identifier                         Company Identifier code.                     between 1 and   Assigned by FERC and                                    data.
2,147,483,648   provided in the filing by
the Company.                                            Note: FERC Staff
@ 6/4/07
meeting stated
sent but technical
submitters may
Refer to Line No.
33       Filing Identifier   filing_id      A unique identifier for the   Numeric (10)   Any number      Required.                     a) Same as filing data.   a) Same as filing
specific filing for the                      between 1 and   Assigned and provided by                                data.
Company.                                     2,147,483,648   the Company.
This can be any value in                                Note: FERC Staff
the valid range of                                      @ 6/4/07
numbers, but it must be                                 meeting stated
unique across all filings for                           that this may not
a specific Company.                                     need to be re-
Line                                                                                                                                                                Formatted Table
No.                                                                                                       Usage               Questions /
FERC       Business                                                Field Format                         Responsibility         Comments            FERC Staff
work        Name      Element Name    Definition of Data Element      (length)      Valid Values         Conditions           and Examples          Answer
paper        (1)           (2)                    (3)                    (4)             (5)                 (6)                   (7)                (8)
34       Database      database_id    A unique identifier for the    Numeric (10)   Any number      Required.             Same as filing data.   Same as filing
Identifier                   database for the Company as                   between 1 and   Assigned by the                              data.
it pertains to the database                   2,147,483,648   Company.
being modified by the filing.                                                                              Note: FERC Staff
This can be any value in the                                                                               @ 6/4/07
allowable range of numbers,                                                                                meeting stated
but it must be unique for each                                                                             that this may not
company database. A                                                                                        need to be re-
company must have no more                                                                                  sent but technical
than one active database.                                                                                  people for
Line                                                                                                                                                                                       Formatted Table
No.                                                                                                                Usage                        Questions /
FERC       Business                                                         Field Format                         Responsibility                  Comments                 FERC Staff
work        Name          Element Name        Definition of Data Element       (length)      Valid Values         Conditions                    and Examples               Answer
paper        (1)               (2)                        (3)                     (4)             (5)                 (6)                            (7)                     (8)
3627     Tariff            record_id          An identifier for the Tariff    Numeric (10)   Any number      Required.                      Are the following two                            Formatted: Not Highlight
RecordBook        (FERC Name =       RecordBook Item within a                       between 1 and   Assigned by the                   examples correct?
Item Identifier   sect_id)book_ite   given database book that will                  2,147,483,648   Company.                       a) Example of non-          a) Yes
m_id               not change as a result of                                                                        sequential Record
revisions to the content of the                                                                  Book Item Identifiers:
Tariff RecordBook Item (with                                   Each Tariff RecordBook
Item in the database book         Sheet No. 143 could
same or different effective                                                                      have Record Book
dates). No two different Tariff                                has an associated Record
Book Item Identifier              Item Identifier 108
RecordBook Items in the                                                                          and Sheet No. 144
same database book may                                         number that does not
change with each revision         could have Record
have the same Record Book                                                                        Book Item Identifier
Item Identifier.                                               within a given
databasebook. To                  109. To insert Sheet
differentiate revisions to        No. 143A between
the Tariff RecordBook             Sheet No. 143 and
Item, the user must rely          Sheet No. 144, Sheet
upon the effective date           No. 143A could have
and Record Book Item              Record Book Item
Effective Priority Order.         Identifier 347.          b) Yes
The Record Book Item           b) Example of revisions
Identifier is not used for        to a Tariff Book Item
collation and does not            Record over time in a
have to be sequential.            given data basebook:
The Company determines            First Revised Sheet
the level of granularity of       No. 143 and Second
the record.                       Revised Sheet No.
The record Book Item can          143 will both have
be sheet based, section           Record Book Item
based or entire document.         Identifier 108. All
Once the level of                 subsequent revisions
granularity is filed,             to Tariff Record Book
subsequent filings must be        Item Sheet No. 143
at the same level and can         will continue to have
not be switched to another        Record Book Item         c) No.
level of granularity without      Identifier 108.             Companies
re-filing entire tariffbook.   c) Won’t the above             are in control
method be too difficult     over the level
to track, especially for    of granularity.
smaller companies?
Line                                                                                                                                                          Formatted Table
No.                                                                                                           Usage                Questions /
FERC      Business                                                     Field Format                         Responsibility          Comments      FERC Staff
work       Name         Element Name     Definition of Data Element       (length)      Valid Values         Conditions            and Examples    Answer
paper       (1)              (2)                     (3)                     (4)             (5)                 (6)                    (7)          (8)
2835     Option         filing_          An identifier that designates  Character (1)   &quot;A&quot; thru &quot;Z&quot;    Required.                                               Formatted Table
DesignationCod optoption_code   the alternative Tariff                         allowed.        Provided by the Company.
e                               RecordBook Item option                                         Default (no options are
being submitted. An identifier                                 provided) is “A”. Options
that designates the primary                                    must increment through
Tariff Record as “A” and                                       alphabet, i.e. a filing
designates all alternative                                     cannot have an &quot;A&quot; and a
Tariff RecordBook Item                                         &quot;C&quot; option without also
options being submitted, if                                    having a &quot;B&quot; option.
any, in alphabetic order.
Line                                                                                                                                                                             Formatted Table
FERC      Business                                                     Field Format                         Responsibility               Comments                    FERC Staff
work       Name      Element Name         Definition of Data Element      (length)     Valid Values          Conditions                 and Examples                  Answer
paper       (1)           (2)                         (3)                    (4)            (5)                  (6)                         (7)                        (8)
3729     Tariff       record_title        The name of the Tariff         Alphanumeric Free form text.   Optional.                   a) Is this the topic         a)                Formatted: Font: 8.5 pt
RecordBook   (FERC Name –        RecordBook Item contents.      (254).                         Assigned by the                  (section) level name
(e.g. “General Terms                      Formatted: Not Highlight
Item Title   sect_tiltle)book_   When the Company database                                     Company.
item_title          book is assembled, this would                                                                  and Conditions” or
Will be used to create a         “Gas Quality”)?                           Formatted: Not Highlight
be printed at the beginning of                                Table of Contents
the record.                                                                               Comment:
Note:                       It might need to be for
To be reviewed by eTariff   company Web sites for
Technical Task Force;       adherence to current
coordinated with e-Tariff   NAESB standards.
Subcommittee defining the   Lines 37 29 and 38 30                          Formatted: Font: 8.5 pt
different filing options.   appear duplicative of one
another. Some options                          Formatted: Font: 8.5 pt
show how these two can
be combined into one and
show how folks who take
different approaches can
use one Field to achieve
1. Entire Document:
2. Entity that includes one
TariffBook Section per
Tariff Book Item
Record: Electric Rate
Schedule No. 5,
3. Entity that includes
multiple Tariff Book                       Formatted: Font: 8.5 pt
Sections per Tariff
RecordBook Item: Gas
Tariff No. 3 Sections 1-
4. Entity that includes one
Tariff Book Sheet per                       Formatted: Font: 8.5 pt
Tariff Book ItemRecord:
: Gas Tariff No. 3, First                   Formatted: Font: 8.5 pt
Revised Sheet No. 54..
Line                                                                                                                                                                                  Formatted Table
No.                                                                                                                 Usage                     Questions /
FERC       Business                                                         Field Format                          Responsibility               Comments                FERC Staff
work        Name         Element Name         Definition of Data Element       (length)      Valid Values          Conditions                 and Examples              Answer
paper        (1)              (2)                         (3)                     (4)             (5)                  (6)                         (7)                    (8)
3830     Tariff           record_num          Textual identifier of the Tariff Alphanumeric Free form text.   Required.                 a) Are the following      a)
RecordBook       (FERC Name –        RecordBook Item. When the (25).                                 Assigned by the              examples valid?                              Formatted: Not Highlight
Item Number      sect_numr)book      Company database book is                                        Company.                     First Revised Sheet
_item_number        assembled, this would be                                        Indicates how you would      143
printed at the beginning of the                                 like this section to show    Sub Second Revised
content.                                                        up in the Table of           Sheet No. 10A.01e.
Contents.                 b) Can the length of this
Note:                         field be expanded to
To be reviewed by eTariff     254 similar to
Technical Task Force;         Record Book
coordinated with e-Tariff     ItemTitle
Subcommittee defining the
different filing options.
3931     Tariff           record_sort         When the Company database Numeric (25). Any number              Required.                      Note: due to technical
RecordBook       (FERC name =        book is reassembled, this               between 1 and                                          issues this needs to                       Formatted: Not Highlight
Item Collation   sect_sort)collati   value will determine the sort           2,147,483,648           Assigned by the                be solely a numeric
Value            on_value            order in which things are                                       Company.                       field.
To be reviewed by eTariff
Technical Task Force;
coordinated with e-Tariff
4032     Alternative      (FERC Name =                                                                        This element added by       This field appears to be
Record Book      alt_sect_numr)                                                                      FERC on its example.        unnecessary given the
Item Number                                                                                                                      Record Number and the
Record Collation Value
formatted as suggested
a) Please provide the       a) FERC willing
definition of this          to discuss
element and explain
Line                                                                                                                                                                                           Formatted Table
No.                                                                                                                     Usage                      Questions /
FERC       Business                                                          Field Format                             Responsibility                Comments                 FERC Staff
work        Name         Element Name       Definition of Data Element          (length)     Valid Values              Conditions                  and Examples               Answer
paper        (1)              (2)                       (3)                        (4)            (5)                      (6)                          (7)                     (8)
4133     Tariff           record_parent     The Record Book Item              Numeric (10)   If the TariffBook   Conditional.                 a) Please explain how this a)                      Formatted: Font: 8.5 pt
RecordBook       (FERC Name –      Identifier for the higher-level                  Submitter           Assigned by the                   element might be used
in a sheet based                              Formatted Table
Item Parent or   sect_parent)boo   part of the tariffbook with                      chooses not to      Company.
Container        k_item_parent_i   which this Tariff RecordBook                     use the                                               tariffbook versus a                           Formatted: Not Highlight
May be used to identify           section based
Identifier       d                 Item belongs. The value                          functionality of    the Volume number of the                                                        Formatted: Font: 8.5 pt
provided, if applicable, must                    this field, they                                      tariffbook.              b)
TariffBook for which this
be a valid Record Book Item                      must still                                       b) If this data element is                         Formatted: Font: 8.5 pt
Tariff RecordBook Item            being used to identify a
Identifier of another Tariff                     populate the        applies.
RecordBook Item.                                 field with “0”.                                       volume of a tariffbook,                       Formatted: Font: 8.5 pt
Sheet based tariffbooks           how is the record for
Otherwise, the      can use this to identify          that Book Item Parent
value must be a                                                                                     Formatted: Font: 8.5 pt
different volumes, i.e.,          Record accomplished? c) No. The Book
valid Record        First Revised Volume No. c) Is the following                  Item Parent       Formatted: Indent: Left: 0&quot;, Hanging: 0.15&quot;
Identifier          1, Original Volume No. 2,       scenario a correct            Record
Second Revised Volume           utilization of this data      Identifier will
No. 1.                          element (not the only         always be the
When a section based            possible                      same for the
tariffbook approach is          implementation)?              next level of
A tariff book has two       data and then
used, may be used to                                                            Formatted: Indent: Left: 0.15&quot;, First line:
volumes: each volume          that next part
identify the section to                                                         0.05&quot;
cover sheet has a Book        is effectively
which the Tariff                                              the “parent” of
Item Parent Record
RecordBook Item is a                                          the
Identifier of 0. The
subpart (i.e. the next level                                  subsequent
cover sheet for Volume
up).                            1 has a Record Book           level of data
Note:                           Item Identifier of 100        and that
To be reviewed by eTariff       and the cover sheet for       concept
Technical Task Force;           Volume 2 has a Record         continues until
coordinated with e-Tariff       Book Item Identifier of       you get to the
200. Changes to a             lowest level of
Tariff RecordBook Item        data.
in Volume 1 will reflect a
Book Item Parent
Record Identifier as 100
and changes to Tariff
Book Item Records in
Volume 2 will have a
Book Item Parent                                Formatted: Font: 8.5 pt
Record Identifier of 200.
Line                                                                                                                                                                        Formatted Table
No.                                                                                                           Usage               Questions /
FERC       Business                                                     Field Format                        Responsibility         Comments                FERC Staff
work        Name         Element Name      Definition of Data Element      (length)     Valid Values         Conditions           and Examples              Answer
paper        (1)              (2)                      (3)                    (4)            (5)                 (6)                   (7)                    (8)
4234     Tariff           Proposed         The proposed effective date   Date (10)      Valid Date      Required.             a) Is there a specific     a) Yes, there will
RecordBook       effective_date   for the specified Tariff                     values.         Assigned by the           data format, i.e.         be a specific
Item Proposed                     RecordBook Item content.                                     Company.                  MMDDYYYY or MM-           format. Will
Effective Date                                                                                                           DD-YYYY, etc.?            be covered in
b) For electric industry    b). eTariff
filings, can                 Technical
“00/00/0000” be used         Task Force to
if the effective date is     come up with
contingent on FERC           some sort of
approval, the closing        a convention
of a plant sale, etc.?       like
12/231/9999.
Line                                                                                                                                                                 Formatted Table
FERC       Business                                                        Field Format                         Responsibility             Comments      FERC Staff
work        Name         Element Name        Definition of Data Element       (length)      Valid Values         Conditions               and Examples    Answer
paper        (1)              (2)                        (3)                     (4)             (5)                 (6)                       (7)          (8)
4335     Record Book      applypriority_or   An indicator that directs which Numeric (10)   Any number      Required.
Item Effective   der                of multiple changes of a given                 between 1 and   Assigned by the
Priority Order                      Tariff RecordBook Item (the                    2,147,483,648   Company.
same Record Book item
Identifier) proposed to go into
effect on the same day, will                                   Default value is ‘1’. The
take precedence, i.e. the                                      value must be unique for a
Tariff RecordBook Item with                                    specific Tariff Book Item
the highest numeric value will                                 Record for a specific
supersede any other Tariff                                     effective date.
RecordsBook Items with the                                     When the current tariff
same Record Book Item                                          book is assembled for a
Identifier also proposed to be                                 particular effective date
effective for that day.                                        and there are multiple
Tariff Book Item Records
with the same Record
Book Item Identifier and
the same effective date,
the approved Tariff
RecordBook Item for that
effective date with the
highest priority number will
be the effective Tariff
RecordBook Item.
No.                                                                                                        Usage                    Questions /
FERC      Business                                                    Field Format                       Responsibility              Comments                FERC Staff
work       Name         Element Name     Definition of Data Element      (length)    Valid Values         Conditions                and Examples              Answer
paper       (1)              (2)                     (3)                    (4)           (5)                 (6)                        (7)                    (8)
4436     Record Book     record_data      The actual Tariff RecordBook Binary64 (10 Actual content   Required.                 a) Does ‘binary’ = native   a) No. It is the
Item Raw Data   (FERC Name =     Item &#39;content’. This Record     MB)           data.                                     file format with         true binary          Formatted: Not Highlight
sect_data)book   Book Item Raw Data would        See questions              Provided by the Company.     extensions (e.g.         version of the
_item_content    apply to a sinlge single sheet,                                                         WORD = .doc or           Record Book
single section, or the whole                               TariffBook Submitter will    EXCEL = .xls)?           Item Plain Text.
tariffbook depending on what                               submit in the Valid Data                              Initially the
granularity the filing Company                             Format of &lt;TBD&gt;.                                      thought is that it
has chosen.                                                                                                      will be html but
such as ASCII, in
Office 2007. May
need certain
to fonts in order
conversion. To
be reviewed by
eTariff Technical
FERC will
b) Can the headers and     documents.           Formatted: Not Highlight
footers as they         b) Yes, it can be
currently exist be        in there. Refer
included in the           to Keith Pierce
Record Book Item          and the eTariff
Raw Data?                 Technical Task
Force need to
Line                                                                                                                                                                                    Formatted Table
No.                                                                                                                 Usage                        Questions /
FERC       Business                                                          Field Format                         Responsibility                  Comments                  FERC Staff
work        Name          Element Name        Definition of Data Element        (length)     Valid Values          Conditions                    and Examples                Answer
paper        (1)               (2)                        (3)                      (4)            (5)                  (6)                            (7)                      (8)
37       Book Item         Book_item_cont Version of software used to         Numeric (10)                    Required.
Content Type      ent_type_code create the specific
4538     Record Book       record_text        The plain text version of the   Alphanumeric Free form text.    Required.                      a) How should certain    a)
Item Plain Text   (FERC Name =       content of the Record Book      (10 MB).                        Submitted by the                  documents, i.e. maps,                     Formatted: Not Highlight
sect_text)book_i   Item Raw Data. Formatting                                       Company.                          be submitted in order
tem_plain_text     and other binary values are                                                                       for FERC to be able
stripped from this content.                                                                       to accomplish this?
b) Will this field be    b) No, the
extracted by FERC        submitter must
from the Record Book     provide this.
4639     Record Book       record_change A description of the type of         Character      see              Required.                      Examples given by
Item Change       (FERC Name = change being requested.               (15)           Implementation   Assigned by the                FERC:                                        Formatted: Not Highlight
Type              sect_change)bo                                                    Guide            Company.                       “NEW&quot;
ok_item_change                                                                     The Implementation Guide       &quot;CHANGE&quot;
_type                                                                              should include a list of the   &quot;CANCELLATION”
valid Record Book Item
Change Types.
a) Are there other types   a)
needed, e.g.
“BASELINE”,
“WITHDRAW” or
PROFORMA”?
Line                                                                                                                                                                                          Formatted Table
No.                                                                                                                      Usage                       Questions /
FERC       Business                                                                Field Format                        Responsibility                 Comments                 FERC Staff
work        Name            Element Name        Definition of Data Element            (length)     Valid Values         Conditions                   and Examples               Answer
paper        (1)                 (2)                        (3)                          (4)            (5)                 (6)                           (7)                     (8)
4740     Associated          associated_filin   The previous filing to which        Numeric (10)   Any number      Conditional.                  Same questions as in          Same as Filing
Filing Identifier   g_id               the subject filing pertains (i.e.                  between 1 and                                 Filing Data.                  Data.
associated).                                       2,147,483,648   Assigned by the
a) It is most likely an       a)
Note that this is used in                                                                            Associated Filing
conjunction with the &quot;assoc_                                       This is not applicable to all     Identifier will be
recordbook_item_id&quot; value                                          filing types. Where it is         related to the entire
and the &quot;assoc_option_code&quot;                                        used, it must refer to a          filing of a particular
(below).                                                           previous filing, and the          Tariff Book Item
value should be that              Record. i.e., 10 Tariff
previous filing&#39;s &quot;filing_id&quot;     Book Item Records
value.                            might change, as
identified in Line 20 17
An example might be that
(Associated Filing
the subject filing is a
Identifier) of the Filing
compliance (or
Data, but the
withdrawal) filing and the
previous, applicable filing
Identifier would be the
to which it pertains must
same for each one.
be identified in this field.
explain the need to
provide it again in the
Tariff RecordBook
Item Content Data.
FERC       Business                                                         Field Format                         Responsibility               Comments                  FERC Staff
work        Name          Element Name       Definition of Data Element        (length)      Valid Values         Conditions                 and Examples                Answer
paper        (1)               (2)                       (3)                      (4)             (5)                 (6)                         (7)                      (8)
4841     Associated        assoc_record_id   This is used to associate the Numeric (10)      Any number      Conditional.                  a) How does this differ  a)
Record Book       (FERC Name =      specific content with a                         between 1 and   Assigned by the                  from the Record Book                    Formatted: Not Highlight
Item Identifier   assoc_sect_id)a   previous filed content item.                    2,147,483,648   Company.                         Item Identifier (Line
ssociated_book    For example, withdrawal                                         This is not applicable to all    3627) and
_item_id          filings must identify the                                       filing types. Where it is        Associated Filing
content being requested to be                                   used, it must refer to a         Identifier data (Line
withdrawn.                                                      Record Book Item ID in           2017) that is already
previous filing, and the         provided elsewhere
Note that this is used in                                       value here should be that        (i.e. If the Record
conjunction with the                                            data&#39;s                           Book Item Identifier
&quot;assoc_filing_id&quot; value                                         &quot; recordbook_item_id&quot;            cannot change, and it
(above) and the                                                 value.                           has already been
&quot;assoc_option_code&quot; (below).                                                                     entered at the
Record Book Item
Data, isn’t this a
info within the same
filing event)?
4942     Associated     associated_opti      An identifier that designates   Character (1)   &quot;A&quot; thru &quot;Z&quot;    Conditional – required       a) How does this differ   a)
Option         on_code              the alternative associated                                      only when an Associated         from Option
DesignationCod                      record option being                                             Filing Identifier is            Designation Code
e                                   submitted.                                                      identified.                     (Line 3528)?
Note that this is used in                                       Assigned by the
conjunction with the                                            Company.
&quot;assoc_filing_id&quot; value and                                     Where it is used, it must
the &quot;assoc_ record_id&quot;                                          refer to correct Option
(above).                                                        Designation Code in a
previous filing, and the
value should be that
previous data&#39;s &quot;filing_opt&quot;
Note: Set forth below are examples items to be contained in this section of the Implementation Guide. Any
data element that has a list of standard code values from which to choose must be included in this
FERC will need to provide the following tables:
 Type of Filings, their related codes and required attachments for each type (See Note Below)
 For each Type of Filing – a list of document attachments that can be waived (See Note Below)
 Cross Reference of Filing Types to Attachment Type Code (See Note Below)
 Attachment Reference Codes (See Note Below)
 List of Special Characters that are not valid for the Supporting Attachment Document File Name
Set forth below, are examples of Code Values tables for the specific data elements that need to be filled in with
standardized responses.
Data Element:          Suspension Motion
Code Value       Code Value Description
N       No, the filing should not become effective without a
separate filing to request such – only applicable to
Y       Yes, the tariffbook item record(s) should go in to
effect at the end of the suspension period. This is
the default code.
Data Element:          Attachment Waiver Requesteds
N       No, a waiver of the attachment is not being
Y       Yes, a waiver of the attachment is being requested.
Data Element:          Option DesignationCode
A       Default for the primary Tariff Book Item Record.
B, C, through Z Subsequent codes used for alternatives and must be
provided in alphabetical order.
Data Element:            Tariff RecordBook Item Change Type
Note: The Pipeline Segment compiled all of this data in one Excel Spreadsheet, which is posted in a separate work paper
(Work Paper 4 of 5 for the April 26, 2007 meeting - http://www.naesb.org/pdf2/etariff042607w14.xls ). Due to its
size, it is best viewed electronically and does not lend itself to easy printing. The information contained within this
spreadsheet is based on the eTariff Filing Rules Listing as published on the FERC website. This spreadsheet is
preliminary in nature and should be considered a concept of how this reference information could be provided.
Technical Specifications for Submission via a Web Portal
Note:This section will address the technical aspect of ‘how’ to submit the tariffbook filing
and is to be completed by the eTariff Technical Subcommittee.
1. Acceptable File Types
a.   Acceptable File Formats, attached (pulled from the NOTICE OF
GUIDELINES FOR SUBMISSION OF CDs, DVDs, AND OTHER
ELECTRONIC MEDIA issued By FERC on April 12, 2007.) See following
attached table, pages 43-44, for acceptable FERC file formats
b.   Define minimum/maximum version requirements
c.   Define process for retiring versions and adding new ones
2. Web Portal - Sample
a. Anatomy of the upload (using sample paper, create a detailed
drawing/description of the process including component details and
how/what is rolled together)
b. Metadata format
1. XML specifications
2. Other ?
c. Create mapping of the sample paper data/metadata to the FERC data
element fields
3. FERC Code Table Download Information
a. Overview (what will be available from the FERC for download)
b. Code values/reference table(s) updates
1. Notification of updates to reference codes
2. Process and location for requesting information from FERC
4. Testing Guidelines
b. Testing Assumptions
c. Testing Goals
d. Testing Execution
e. Ongoing testing ability
f. Feedback mechanism/resolution
a. Scheduled Outages
6. Procedures for submitting a tariffbook filing in the event the Web Portal is
a. Acceptable media types for submitting tariffbook filing via US mail or courier
7. Potential Error Codes
a. Table indicating error codes and details
b. Error Delivery
a. Web Portal – Online – do we need SSL for the session?
b. Any requirements for file upload (encryption?)
Note: How are secure documents processed?
9. Internet Browser Specifications:
The following table was contained in the FERC notice of Submission Guidelines for CDs, DVDs, and Other
Electronic Media dated April 12, 2007 - http://www.ferc.gov/help/submission-guide/electronic-media.asp.
Description                                                                        Suffix
Adobe Portable Document Format (Acrobat 4.x or higher)                             .PDF
Advantica SynerGEE compatible Microsoft Access application MDB file                .MDB                   Formatted: Footnote Reference
Advantica SynerGEE input data set for pipe flow program                            .PD                    Formatted: Footnote Reference
Advantica SynerGEE xy coordinate text file                                         .XY                    Formatted: Footnote Reference
ASCII Comma Separated Value                                                        .CSV
ASCII Text Format                                                                  .TXT
AutoCAD Drawing database                                                           .DWG                   Formatted: Footnote Reference
Corel WordPerfect                                                                  .WPD
ESRI Shape Format (vector format created by the Environmental System
Research Institute) main file                                                      .SHP
Research Institute) index file                                                     .SHX                   Formatted: Footnote Reference
Research Institute) dBase table                                                    .DBF                   Formatted: Footnote Reference
Research Institute) projection file                                                .PRJ                   Formatted: Footnote Reference
ESRI ArcGIS auxiliary file                                                         .AUX                   Formatted: Footnote Reference
ESRI ArcGIS external pyramid layer file used for rapid display of raster
files                                                                              .RRD                   Formatted: Footnote Reference
ESRI ArcMap project file                                                           .MXD                   Formatted: Footnote Reference
ESRI ArcIMS Project file (ArcXML)                                                  .AXL                   Formatted: Footnote Reference
ESRI ArcView spatial bin file for shapefiles                                       .SBN                   Formatted: Footnote Reference
ESRI ArcView spatial bin index file for shapefiles                                 .SBX                   Formatted: Footnote Reference
ESRI plain text file (world file) used to coordinate raster map images             .TWF                   Formatted: Footnote Reference
ESRI ArcGIS MrSid (LizardTech) image raster file                                   .SID                   Formatted: Footnote Reference
ESRI ArcGIS MrSid georeferencing information (world) file                          .SDW                   Formatted: Footnote Reference
Extensible Markup Language                                                         .XML
Graphic Image Format                                                               .GIF
Gregg Engineering WinFlow library file                                             .LIB                   Formatted: Footnote Reference
Gregg Engineering WinFlow output file                                              .LOG                   Formatted: Footnote Reference
Gregg Engineering WinFlow output file                                              .NTP                   Formatted: Footnote Reference
Gregg Engineering WinFlow output file                                              .OVR                   Formatted: Footnote Reference
A detailed description of the content of the file and instructions for the public on how to obtain resources
to view it must be included with the submission in light of National Archives and Records Administration
regulations. This file type must only be submitted with Advantica SynerGEE, AutoCAD, ESRI, WinFlow, or
WinTran files.
Description                                                                     Suffix
Gregg Engineering WinFlow input file                                            .WFP               Formatted: Footnote Reference
Gregg Engineering WinTran time-varying schedule file                            .SCH               Formatted: Footnote Reference
Gregg Engineering WinTran output file                                           .WTO               Formatted: Footnote Reference
Gregg Engineering WinTran output file                                           .WTS               Formatted: Footnote Reference
Joint Photographic Experts Group                                                .JPG
Keyhole Markup Language (xml-based structure for geographic data in an
Earth browser such as Google Earth)                                             .KML               Formatted: Footnote Reference
Lotus                                                                           .WK1, .WK3, .WK4
Microsoft Excel                                                                 .XLS
Microsoft Media Player                                                          .WMV, .WMA
Microsoft Power Point                                                           .PPT, .PPS
Microsoft Word                                                                  .DOC
Motion Picture Experts Group                                                    .MPG               Formatted: Footnote Reference
MP3 audio file (mp3)                                                            .MP3               Formatted: Footnote Reference
RAW Image File (RGB 24-bit Graphics)                                            .RAW
Rich Text Format                                                                .RTF
Tagged Image File Format                                                        .TIF
Waveform sound (Microsoft Windows)                                              .WAV               Formatted: Footnote Reference
Web page file containing Hypertext Markup Language (HTML) markup                .HTM
Windows bitmap                                                                  .BMP
Zip file compressed archive (must not be self-extracting)                       .ZIP
A written transcript and a detailed description of the content of the file must be included with the
submission in light of the Americans with Disabilities Act.
47a81J Categories:
eTariff Compliance
Narrative of the ETariff Filing Process
Pipeline eTariff Proposal
eTariff Company List - Market Based Rates Public Utilities
eTariff Company List - Full List, all eTariff Programs
The NAESB WGQ Producer Segment generally supports the LDC Segment
eTariff Use Case Creator Users Guide
eTariff Technical Task Force (eTTF)
eTariff Company List - Traditional Cost of Service Public Interstate Pipelines under the Natural Gas Act - eTariff Company List
North American Energy Standards Board eTariff Vendor Listing
XML Schema Version 1 Set forth below is Version 1 of the XML Schema that must be used to submit a Tariff Filing through FERC’s eFiling eTariff Portal xs schema id ferc tariff filing tar
bonneville power portland
eTariff_2009-1008-001
OTHER DOCS BY 47a81J
Class/Group: Text Range: - Download Now DOC
scenepowerpoint rev
Personal Reading Record Sheet
IN THE HIGH COURT OF SOUTH AFRICA TRANSVAAL PROVINCIAL - DOC
Please see the associated spreadsheet for character
120050086Immigrationv1211
1st Nine Weeks Kindergarten Revised
DRUG - FREE WORKPLACE
level4 java Pyramid of Letters 2004