Download:
pdf |
pdfData Dictionary | RM16-17-000
Updated August 2021
Data Dictionary for Order 860
Table of Contents
Filing Information....................................................................................................................................................... 2
mbr_authorizations ................................................................................................................................................... 3
mbr_category_status ................................................................................................................................................. 5
mbr_mitigations......................................................................................................................................................... 7
mbr_self_limitations .................................................................................................................................................. 8
mbr_operating_reserves ......................................................................................................................................... 10
entities_to_entities .................................................................................................................................................. 12
entities_to_genassets .............................................................................................................................................. 15
entities_to_ppas ...................................................................................................................................................... 19
entities_to_vertical_assets ...................................................................................................................................... 25
indicative_pss .......................................................................................................................................................... 27
indicative_mss ......................................................................................................................................................... 30
SQL Format Types .................................................................................................................................................... 34
1
Data Dictionary | RM16-17-000
Updated August 2021
Basic information about a Seller’s market-based rate authority
(gray rows auto-populated by database system)
Filing Information
#
Attribute
Description
Identifier Type
Nullable
SQL Type
Format
1
mbr_filing_id
Primary Key
NA
INTEGER
NA
2
reporting_entity_cid_cd
Unique, table-specific, record
identifier autogenerated by the
database system on submission.
Functions to uniquely identify each
row in a given table.
Company Identifier of the reporting
entity.
Foreign Key (CID)
NA
CHARACTER(7)
CXXXXXX
3
mbr_submission_fk
Foreign Key
(submissions)
NA
INTEGER
NA
4
TestFiling
CHARACTER(5)
reporting_entity_cid
Options List:
• true
• false
Foreign Key (CID)
N
5
The unique identifier for the
submission assigned by, and
integrated with, FERC Online (e.g.
eFiling Submission Report)
Indicates whether this is a test
submission that will not be inserted
into the database.
Company Identifier of the MBR
Seller making this submission.
N
CHARACTER(7)
6
eRegEmail
N
CHARACTER
VARYING
eRegistered email of the MBR Seller
making this submission.
CXXXXXX
Validations
Must match an active
Company Identifier
registered with FERC.
These identifiers can be
found using General
Search, found here.
Must match an active
Company Identifier
registered with FERC. Can
be found using General
Search, found here.
Must be a valid
eRegistered email address,
allowed to make the MBR
submission on behalf of
the reporting_entity_cid.
2
Data Dictionary | RM16-17-000
Updated August 2021
Basic information about a Seller’s market-based rate authority
(gray rows auto-populated by database system)
mbr_authorizations
#
Attribute
Description
Identifier
Type
Primary Key
Nullable
SQL Type
Format
1
mbr_authorization_id
2
reporting_entity_cid_cd
Unique, table-specific, record
identifier autogenerated by the
database system on submission.
Functions to uniquely identify
each row in a given table.
Company Identifier of the
reporting entity.
NA
INTEGER
NA
Foreign Key
(CID)
NA
CHARACTER(7)
CXXXXXX
3
mbr_submission_fk
Foreign Key
(submissions)
NA
INTEGER
NA
4
active_date
NA
DATE
YYYY-MM-DD
(ANSI)
5
inactive_date
NA
DATE
NA
INTEGER
YYYY-MM-DD
(ANSI)
NA
6
updated_record_id
7
record_type_cd
N
CHARACTER(6)
NA
8
reference_id
Identifier of existing record
being updated.
Y
INTEGER
9
authorization_docket_number
Docket number of the order
first granting the reporting
entity market-based rate
authorization.
N
CHARACTER
VARYING(15)
The unique identifier for the
submission assigned by, and
integrated with, FERC Online
(e.g. eFiling Submission Report)
Date that this record became
active in the database.
Date that this record became
inactive in the database.
Superseding identifier for the
record being updated.
Indicates whether this is a new
submission or a submission to
update an existing record.
Options List:
• New
• Update
Validations
Must match an active Company
Identifier registered with FERC. These
identifiers can be found using General
Search, found here.
Must either be “New” or “Update” if
information is included in this table.
Required if record_type_cd is
“Update.” Must match an existing
entry from the “MBR Authorization ID”
column in the MBR Authorization
Submitted Data Table, found here.
XXXX-X-XXX;
XXXX-XX-XXX;
XXXX-XXXXXX; or
XXXX-XXXXXXX
3
Data Dictionary | RM16-17-000
Updated August 2021
Basic information about a Seller’s market-based rate authority
(gray rows auto-populated by database system)
mbr_authorizations
#
Attribute
Description
10
authorization_effective_date
11
cancellation_docket_number
12
cancellation_effective_date
Identifier
Type
Nullable
SQL Type
Format
Validations
Date the reporting entity's
market-based rate authorization
became effective. If the
reporting entity’s market-based
rate authorization has not yet
been accepted, enter the
proposed effective date.
Docket number of the order
accepting the cancellation of
the reporting entity's marketbased rate authorization.
N
DATE
YYYY-MM-DD
(ANSI)
Valid date
Y
CHARACTER
VARYING(15)
Effective date of the
cancellation of the reporting
entity's market-based rate
authorization.
Y
DATE
XXXX-X-XXX;
XXXX-XX-XXX;
XXXX-XXXXXX; or
XXXX-XXXXXXX
YYYY-MM-DD
(ANSI)
Valid date
Value must be ≥
authorization_effective_date
4
Data Dictionary | RM16-17-000
Updated August 2021
The Seller’s Category status in all six market-based rate regions
(gray rows auto-populated by database system)
mbr_category_status
#
Attribute
Description
Identifier Type
Nullable
SQL Type
Format
1
cat_status_id
Primary Key
NA
INTEGER
NA
2
reporting_entity_cid_cd
Unique, table-specific,
record identifier
autogenerated by the
database system on
submission. Functions to
uniquely identify each row
in a given table.
Company Identifier of the
reporting entity.
Foreign Key (CID)
NA
CHARACTER(7)
CXXXXXX
3
mbr_submission_fk
Foreign Key
(submissions)
NA
INTEGER
NA
4
active_date
NA
DATE
5
inactive_date
NA
DATE
6
updated_record_id
The unique identifier for the
submission assigned by, and
integrated with, FERC Online
(e.g. eFiling Submission
Report)
Date that this specific record
became active in the
database.
Date that this specific record
became inactive in the
database.
Superseding Identifier for
the record being updated.
NA
INTEGER
YYYYMM-DD
(ANSI)
YYYYMM-DD
(ANSI)
NA
7
record_type_cd
Options List:
• New
• Update
N
CHARACTER(6)
NA
8
reference_id
Indicates whether this is a
new submission or a
submission to update an
existing record.
Identifier of existing record
being updated.
Y
INTEGER
9
region_cd
Region identifier.
Options List:
NW – Northwest
SW – Southwest
CE – Central
SPP – Southwest
Power Pool
NE – Northeast
SE – Southeast
N
CHARACTER(3)
NA
Validations
Must match an active Company Identifier registered with
FERC. These identifiers can be found using General
Search, found here.
Must either be “New” or “Update” if information is
included in this table.
Required if record_type_cd is “Update.” Must match an
existing entry from the “Cat Status ID” column in the MBR
Category Status Submitted Data Table, found here.
Must match a valid region code from the Options List.
This list is also available in the Region Lookup Table,
found here.
5
Data Dictionary | RM16-17-000
Updated August 2021
The Seller’s Category status in all six market-based rate regions
(gray rows auto-populated by database system)
mbr_category_status
#
Attribute
Description
Identifier Type
Nullable
SQL Type
Format
Validations
10 cat_status_in_region_fk
Category status in region.
Options List:
1 - Category 1
2 - Category 2
3 - No MBR
authority in the
region
N
INTEGER
NA
Must match a valid entry from the Options List. This list is
also available in the Category Status in Region Lookup
Table, found here.
11 cat_status_effective_date
Effective date of tariff where
this category status was
implemented.
Y
DATE
YYYYMM-DD
(ANSI)
Valid date
Required if cat_status_in_region_fk is “1” or “2.”
6
Data Dictionary | RM16-17-000
Updated August 2021
Listing of the markets/BAAs where the Seller is mitigated
(gray rows auto-populated by database system)
mbr_mitigations
#
Attribute
Description
Identifier Type
Nullable
SQL Type
Format
1
mbr_mitigations_id
Primary Key
NA
INTEGER
NA
2
reporting_entity_cid_cd
Unique, table-specific, record
identifier autogenerated by the
database system on submission.
Functions to uniquely identify each
row in a given table.
Company Identifier of the reporting
entity.
Foreign Key (CID)
NA
CHARACTER(7)
CXXXXXX
3
mbr_submission_fk
Foreign Key
(submissions)
NA
INTEGER
NA
4
active_date
The unique identifier for the
submission assigned by, and
integrated with, FERC Online (e.g.,
eFiling Submission Report).
Date that this specific record became
active in the database.
NA
DATE
YYYY-MM-DD
(ANSI)
5
inactive_date
Date that this specific record became
inactive in the database.
NA
DATE
YYYY-MM-DD
(ANSI)
6
updated_record_id
NA
INTEGER
NA
7
record_type_cd
Superseding identifier for the record
being updated.
Indicates whether this is a new
submission or a submission to update
an existing record.
N
CHARACTER(6)
NA
8
reference_id
Identifier of existing record being
updated
Y
INTEGER
9
Balancing_Authority_cd
Identifier for the market/BAA where
the reporting entity is mitigated.
N
CHARACTER
VARYING(5)
NA
10
mitigation_narrative
Narrative description of the mitigation
specifying type of mitigation, etc.
Y
CHARACTER
VARYING(MAX)
NA
11
mitigation_effective_date
N
DATE
12
mitigation_end_date
Effective date of tariff where the
mitigation was implemented.
Effective date of tariff where the
mitigation was removed.
Y
DATE
YYYY-MM-DD
(ANSI)
YYYY-MM-DD
(ANSI)
Options List:
• New
• Update
Foreign Key
(Balancing
Authority Areas)
Validations
Must match an active Company Identifier
registered with FERC. These identifiers can
be found using General Search, found here.
Must either be “New” or “Update” if
information is included in this table.
Required if record_type_cd is “Update.”
Must match an existing entry from the “MBR
Mitigation ID” column in the MBR Mitigations
Submitted Data Table, found here.
Must match an entry from the “Balancing
Authority CD” column of the BAA Lookup
Table, found here.
Valid date
Valid date
Value must be ≥ mitigation_effective_date.
7
Data Dictionary | RM16-17-000
Updated August 2021
Listing of the regions and/or BAAs where the Seller has limited its own market-based rate authority through its tariff
(gray rows auto-populated by database system)
mbr_self_limitations
#
Attribute
Description
Identifier Type
Nullable
SQL Type
Format
1
mbr_self_limitations_id
Primary Key
NA
INTEGER
NA
2
reporting_entity_cid_cd
Unique, table-specific, record
identifier autogenerated by the
database system on submission.
Functions to uniquely identify each
row in a given table.
Company Identifier of the reporting
entity.
Foreign Key (CID)
NA
CHARACTER(7)
CXXXXXX
3
mbr_submission_fk
Foreign Key
(submissions)
NA
INTEGER
NA
4
active_date
The unique identifier for the
submission assigned by, and
integrated with, FERC Online (e.g.,
eFiling Submission Report).
Date that this specific record
became active in the database.
NA
DATE
YYYY-MM-DD
(ANSI)
5
inactive_date
Date that this specific record
became inactive in the database.
NA
DATE
YYYY-MM-DD
(ANSI)
6
updated_record_id
Superseding identifier for the
record being updated.
NA
INTEGER
NA
7
record_type_cd
Indicates whether this is a new
submission or a submission to
update an existing record.
N
CHARACTER(6)
NA
8
reference_id
Identifier of existing record being
updated.
Y
INTEGER
Options List:
• New
• Update
Validations
Must match an active Company
Identifier registered with FERC.
These identifiers can be found
using General Search, found here.
Must either be “New” or
“Update” if information is
included in this table.
Required if record_type_cd is
“Update.” Must match an
existing entry from the “MBR Self
Limitations ID” column in the
MBR Self Limitations Submitted
Data Table, found here.
8
Data Dictionary | RM16-17-000
Updated August 2021
Listing of the regions and/or BAAs where the Seller has limited its own market-based rate authority through its tariff
(gray rows auto-populated by database system)
mbr_self_limitations
#
Attribute
Description
Identifier Type
Nullable
SQL Type
Format
Validations
9
region_cd
Identifier for the region where the
reporting entity is authorized to
transact at market-based rates.
Report a region to indicate that the
reporting entity is authorized to
transact at market-based rates in
all markets/BAAs within the region.
Y
CHARACTER
VARYING(3)
Must match a valid region code
from the Options List. This list is
also available in the Region
Lookup Table, found here.
10
Balancing_Authority_cd
Identifier for the market/BAA
where the reporting entity is
authorized to transact at marketbased rates.
Options List:
NW –
Northwest
SW – Southwest
CE – Central
SPP – Southwest
Power Pool
NE – Northeast
SE - Southeast
Foreign Key
(Balancing
Authority Areas)
Y
CHARACTER
VARYING(5)
Must match an entry from the
“Balancing Authority CD” column
of the BAA Lookup Table, found
here.
11
self_limit_effective_date
Effective date of tariff where the
self-limitation was implemented.
N
DATE
YYYY-MM-DD
(ANSI)
Valid date
12
self_limit_end_date
Effective date of tariff where the
self-limitation was removed.
Y
DATE
YYYY-MM-DD
(ANSI)
Valid date
Value must be ≥
self_limit_effective_date
9
Data Dictionary | RM16-17-000
mbr_operating_reserves
Updated August 2021
Listing of the markets/BAAs where the Seller is authorized to sell operating reserves (including RTO/ISOs and Third Party Ancillary Services)
(gray rows auto-populated by database system)
#
Attribute
Description
Identifier Type
Nullable
SQL Type
Format
1
mbr_operating_reserves_id
Primary Key
NA
INTEGER
NA
2
reporting_entity_cid_cd
Unique, table-specific, record
identifier autogenerated by
the database system on
submission. Functions to
uniquely identify each row in a
given table.
Company Identifier of the
reporting entity.
Foreign Key (CID)
NA
CHARACTER(7)
CXXXXXX
3
mbr_submission_fk
Foreign Key
(submissions)
NA
INTEGER
NA
4
active_date
The unique identifier for the
submission assigned by, and
integrated with, FERC Online
(e.g., eFiling Submission
Report).
Date that this specific record
became active in the database.
NA
DATE
YYYY-MM-DD
(ANSI)
5
inactive_date
NA
DATE
YYYY-MM-DD
(ANSI)
6
updated_record_id
NA
INTEGER
NA
7
record_type_cd
N
CHARACTER(6)
NA
Date that this specific record
became inactive in the
database.
Superseding identifier for the
record being updated.
Indicates whether this is a new
submission or a submission to
update an existing record.
Options List:
• New
• Update
Validations
Must match an active Company
Identifier registered with FERC.
These identifiers can be found
using General Search, found
here.
Must either be “New” or
“Update” if information is
included in this table.
10
Data Dictionary | RM16-17-000
mbr_operating_reserves
Updated August 2021
Listing of the markets/BAAs where the Seller is authorized to sell operating reserves (including RTO/ISOs and Third Party Ancillary Services)
(gray rows auto-populated by database system)
#
Attribute
Description
8
reference_id
Identifier of existing record
being updated.
9
Balancing_Authority_cd
Identifier for the market/BAA
where the reporting entity is
authorized to sell operating
reserves.
10
or_authorization_effective_
date
11
or_authorization_end_date
Effective date of tariff
specifying when seller was
authorized to sell operating
reserves.
Effective date of tariff when
the operating reserve
authorization was removed.
Identifier Type
Foreign Key
(Balancing
Authority Areas)
Nullable
SQL Type
Format
Validations
Y
INTEGER
Required if record_type_cd is
“Update.” Must match an
existing entry from the “MBR
Operating Reserves ID” column in
the MBR Operating Reserves
Submitted Data Table, found
here.
N
CHARACTER
VARYING(5)
N
DATE
YYYY-MM-DD
(ANSI)
If making sales of Third-Party
Ancillary Services, must match an
entry from the “Balancing
Authority CD” column of the BAA
Lookup Table, found here.
Valid date
Y
DATE
YYYY-MM-DD
(ANSI)
Valid date
Value must be ≥
or_authorization_effective_date
11
Data Dictionary | RM16-17-000
Updated August 2021
Mapping of reporting entities to ultimate upstream affiliates
(gray rows auto-populated by database system)
entities_to_entities
#
Attribute
Description
Identifier Type
Nullable
SQL Type
Format
Validations
1
entities_entities_id
Primary Key
NA
INTEGER
NA
2
reporting_entity_cid_cd
Unique, table-specific, record identifier
autogenerated by the database system on
submission. Functions to uniquely identify
each row in a given table.
Company Identifier of the reporting entity.
Foreign Key (CID)
NA
CHARACTER(7)
CXXXXXX
3
mbr_submission_fk
Foreign Key
(submissions)
NA
INTEGER
NA
4
active_date
The unique identifier for the submission
assigned by, and integrated with, FERC
Online (e.g., eFiling Submission Report).
Date that this specific record became
active in the database.
NA
DATE
YYYY-MMDD (ANSI)
Valid date
5
inactive_date
Date that this specific record became
inactive in the database.
NA
DATE
YYYY-MMDD (ANSI)
Valid date
6
updated_record_id
Superseding identifier for the record being
updated.
NA
INTEGER
NA
7
record_type_cd
Indicates whether this is a new submission
or a submission to update an existing
record.
N
CHARACTER
(6)
NA
8
reference_id
Identifier of existing record being updated.
Y
INTEGER
Must match an active Company
Identifier registered with FERC.
These identifiers can be found using
General Search, found here.
value must be ≥ active_date
Options List:
• New
• Update
Must either be “New” or “Update” if
information is included in this table.
Required if record_type_cd is
“Update.” Must match an existing
entry from the “Entities to
Entities ID” column of the Entities to
Entities Submitted Data Table,
found here.
12
Data Dictionary | RM16-17-000
Updated August 2021
Mapping of reporting entities to ultimate upstream affiliates
(gray rows auto-populated by database system)
entities_to_entities
#
Attribute
Description
Identifier Type
Nullable
SQL Type
9
reportable_entity_
ID_type_CD
Options List:
• CID
• LEI
• GID
N
CHARACTER
(3)
Must be “CID,” “LEI,” or “GID.”
10
reportable_entity_
ID
User selects one of the three identifier
types it will provide for these 2 fields:
-Company Identifier/CID of the Reportable
Entity. (Required if available.)
-Legal Entity Identifier/LEI of the
Reportable Entity. (Required if available
and CID is not available.)
-FERC generated ID/GID of the Reportable
Entity. (Required if CID and LEI are not
available.)
CID, LEI, or GID for the entity being
reported.
Foreign Key (CID)
Foreign Key (LEI)
Foreign Key (GID)
N
CHARACTER
(7)
CHARACTER
(20)
CHARACTER
(10)
Must match an active record
identifier. These identifiers can be
found using General Search, found
here.
Y
CHARACTER
VARYING
(15)
Y
CHARACTER
(3)
11
Blanket_Auth_
Docket_Number
12
Utility_ID_
Type_CD
Note: this field is used to identify affiliate
relationships to generate the Asset
Appendix, other than when a Utility_ID is
submitted. When provided, the Utility_ID
field is used to establish the downstream
affiliate relationships for Asset Appendix
generation and the reportable_entity_ID is
used to identify the Ultimate Upstream
Affiliate.
Docket number wherein the Reportable
Entity received a of the section 203(a)(2)
blanket authorization. This field should be
left blank if this does not apply.
User selects one of the three identifier
types it will provide for these 2 fields: Company Identifier/CID of the Reportable
Entity. (Required if available.) -Legal Entity
Identifier/LEI of the Reportable Entity.
(Required if available and CID is not
available.) -FERC generated ID/GID of the
Reportable Entity. (Required if CID and LEI
are not available.)
Options List
•
CID
•
LEI
•
GID
Format
XXXX-X-XXX;
XXXX-XXXXX;
XXXX-XXXXXX; or
XXXX-XXXXXXX
Validations
Required if the Reportable Entity
received a 203(a)(2) blanket
authorization. Otherwise, should be
left blank.
Required if the Reportable Entity
received a 203(a)(2) blanket
authorization.
Otherwise, should be left blank.
If submitted, must be “CID,” “LEI,”
or “GID.”
13
Data Dictionary | RM16-17-000
Updated August 2021
Mapping of reporting entities to ultimate upstream affiliates
(gray rows auto-populated by database system)
entities_to_entities
#
Attribute
Description
Identifier Type
Nullable
SQL Type
13
Utility_ID
CID, LEI, or GID for the entity whose
securities were acquired pursuant to the
blanket authorization. This field should be
left blank if this does not apply.
Foreign Key (CID)
Foreign Key (LEI)
Foreign Key (GID)
Y
CHARACTER
(7)
CHARACTER
(20)
CHARACTER
(10)
14
15
relationship_
start_date
relationship_
end_date
Note: when provided, this field is used to
establish downstream affiliate
relationships to generate the Asset
Appendix. The reportable_entity_ID is
used to identify the Ultimate Upstream
Affiliate.
Date relationship to the Reportable Entity
(field 10) started.
Date relationship to the Reportable Entity
(field 10) ended.
N
DATE
Y
DATE
Format
Validations
Required if the Reportable Entity
received a 203(a)(2) blanket
authorization.
Otherwise, should be left blank.
Must match an active record
identifier.
These identifiers can be found using
General Search, found here.
YYYY-MMDD (ANSI)
YYYY-MMDD (ANSI)
Valid date
Valid date
Value must be ≥ relationship_start_
date
14
Data Dictionary | RM16-17-000
Updated August 2021
Mapping of reporting entities to generator assets
(gray rows auto-populated by database system)
entities_to_genassets
#
Attribute
Description
Identifier Type
Nullable
SQL Type
Format
1
entities_genassets_id
Primary Key
NA
INTEGER
NA
2
reporting_entity_cid_cd
Unique, table-specific, record identifier
autogenerated by the database system
on submission. Functions to uniquely
identify each row in a given table.
Company Identifier of the reporting
entity.
Foreign Key
(CID)
NA
CHARACTER(7)
CXXXXXX
3
mbr_submission_fk
Foreign Key
(submissions)
NA
INTEGER
NA
4
active_date
The unique identifier for the submission
assigned by, and integrated with, FERC
Online (e.g., eFiling Submission Report).
Date that this specific record became
active in the database.
NA
DATE
YYYY-MMDD (ANSI)
Valid date
5
inactive_date
Date that this specific record became
inactive in the database.
NA
DATE
YYYY-MMDD (ANSI)
Valid date
Value must be ≥ active_date
6
updated_record_id
Superseding identifier for the record
being updated.
NA
INTEGER
NA
7
EIA_fk
Y
INTEGER
NA
8
record_type_cd
Populated only when the
gen_asset_type_fk is “EIA,” for internal
tracking purposes.
Indicates whether this is a new
submission or a submission to update
an existing record.
N
CHARACTER(6)
NA
9
reference_id
If updating an existing record, provides
a link to the existing record.
10
generation_asset_type_id
User selects whether it will identify the
generator using EIA information or a
FERC-generated Asset ID.
Options List:
• New
• Update
Y
Options List:
1- EIA
2- Asset ID
N
Validations
Must match an active Company
Identifier registered with FERC. These
identifiers can be found using General
Search, found here.
Must either be “New” or “Update” if
information is included in this table.
Required if record_type_cd is
“Update.” Must match an existing
entry from the “Entities Genassets ID”
column in the Entities to Gen Assets
Submitted Data Table, found here.
INTEGER
15
Data Dictionary | RM16-17-000
Updated August 2021
Mapping of reporting entities to generator assets
(gray rows auto-populated by database system)
entities_to_genassets
#
Attribute
Description
Identifier Type
Nullable
SQL Type
Format
Validations
11
eia_plant_code
"Plant Code" assigned to the plant as
found in the EIA-860 data.
Foreign Key
(EIA)
Y
CHARACTER
VARYING (5)
NA
Required if
“generation_asset_type_id” is “1”
(EIA).
Must match a valid entry from the
“Plant Code” column in the EIA Lookup
Table, found here.
EIA data hierarchy:
Plant Code -> Generator ->Unit
e.g. Plant code = 123
EIA data is uploaded into the EIA
Lookup Table annually from the EIA
external source.
12
eia_ generator_id
"Generator ID" assigned to the
generator as found in the EIA-860 data.
Foreign Key
(EIA)
Y
CHARACTER
VARYING (5)
EIA data hierarchy:
Plant Code -> Generator ->Unit
eia_unit_code
EIA data hierarchy:
Plant Code -> Generator ->Unit
e.g. Plant code = 200
Generator ID = 3
Unit Code = ABC
Though nullable, this information is
required if “generation_asset_type_id”
is “1” (EIA) and the Generator is
relevant to the asset appendix.
Must match a valid entry from the
“Generator ID” column in the EIA
Lookup Table, found here.
e.g. Plant code = 200
Generator ID = 3
13
NA
"Unit Code" assigned to linked
generators (e.g. combined cycle) as
found in the EIA-860 data (if applicable).
Foreign Key
(EIA)
Y
CHARACTER
VARYING(7)
EIA data is uploaded into the EIA
Lookup Table annually from the EIA
external source.
Though nullable, this information is
required if “generation_asset_type_id”
is “1” (EIA) and the Unit is relevant to
the asset appendix
Must match a valid entry from the
“Unit Code” column in the EIA Lookup
Table, found here.
EIA data is uploaded into the EIA
Lookup Table annually from the EIA
external source
16
Data Dictionary | RM16-17-000
Updated August 2021
Mapping of reporting entities to generator assets
(gray rows auto-populated by database system)
entities_to_genassets
#
Attribute
Description
Identifier Type
Nullable
SQL Type
Format
Validations
14
ferc_asset_Gen_code
The FERC Asset ID assigned to the asset.
Asset IDs can be obtained by filers for
assets that do not have EIA codes.
Foreign Key
(Asset ID)
Y
CHARACTER(10)
FAXXXXXXX
X
15
entity_ID_type_CD
Options List:
• CID
• LEI
• GID
N
CHARACTER(3)
16
entity_ID
User selects one of the three identifier
types it will provide for these 2 fields:
-Company Identifier/CID of the
reportable entity. (Required if
available.)
-Legal Entity Identifier/LEI of the
reportable entity. (Required if
available and CID is not available.)
-FERC generated ID/GID of the
reportable entity. (Required if CID and
LEI are not available.)
CID, LEI, or GID for the entity that owns
and/or controls the generator being
reported.
Required if
“generation_asset_type_id” is “2”
(Asset ID).
Must match a valid entry in the “Gen
Code” column of the Gen Asset table,
found here.
Must be “CID,” “LEI,” or “GID.”
N
CHARACTER(7)
CHARACTER(20)
CHARACTER(10)
Must match an active record identifier.
These identifiers can be found using
General Search, found here.
17
relationship_type_fk
Indicator of whether an ownership or
control relationship is being reported.
Foreign Key
(CID)
Foreign Key
(LEI)
Foreign Key
(GID)
Options List:
1 – Ownership
2 – Control
3 – Both Own
and Control
N
INTEGER(1)
Must match a valid entry from the
Options List. This list is also available in
the Relationship Type Lookup Table,
found here.
18
relationship_start_date
Date the reported relationship with the
generation asset began.
N
DATE
YYYY-MMDD (ANSI)
Valid date
19
relationship_end_date
Date the reported relationship with the
generation asset ended.
Y
DATE
YYYY-MMDD (ANSI)
Valid date
Value should be ≥
relationship_start_date
17
Data Dictionary | RM16-17-000
Updated August 2021
Mapping of reporting entities to generator assets
(gray rows auto-populated by database system)
entities_to_genassets
#
Attribute
Description
Identifier Type
Nullable
SQL Type
20
physical_location_
Balancing_Authority_cd
Identifier for the market/BAA where the
generator is physically located.
N
CHARACTER
VARYING(5)
Must match an entry from the
“Balancing Authority CD” column of
the BAA Lookup Table, found here.
21
telemetered_location_
Balancing_Authority_cd
N
CHARACTER
VARYING(5)
Must match an entry from the
“Balancing Authority CD” column of
the BAA Lookup Table, found here.
22
cap_rating_adjusted
Identifier for the market/BAA that is the
destination (sink) market/BAA of
remote generation or where a
generator is pseudo-tied or committed
with long term transmission rights (i.e.
where this generation should be studied
in an MBR submittal).
De-rated capacity value for the
generator. (See adj_rating_options_fk).
Foreign Key
(Balancing
Authority
Areas)
Foreign Key
(Balancing
Authority
Areas)
N
NUMERIC(6,2)
Must be a positive number.
23
adj_rating_options_fk
N
INTEGER(1)
Must match a valid entry from the
Options List. This list is also available in
the Rating Adjust Options Lookup
Table, found here.
24
alt_methodology_used
Y
CHARACTER
VARYING(MAX)
Required if adj_rating_options_fk is “5”
(Alternative). Otherwise, must be Null
25
amount
N
NUMERIC(6,2)
NA
26
explanatory_notes
Y
CHARACTER
VARYING(MAX)
NA
The de-rating methodology used to
calculate the value reported in
cap_rating_adjusted. (See P 266 of
FERC Order No. 816 for more
information on the allowed
methodologies.)
The description of the de-rated capacity
methodology of the asset, if it does not
conform the other rating options.
This should only be reported when
adj_rating_options_fk is “5”
(Alternative).(See FERC Order No. 816 at
P 106)
Capacity (in MW) of the generator that
is attributed to the reporting entity or
non-MBR affiliate. This can differ from
the cap_rating_adjusted field if the
reported entity is not entitled to the full
output of the facility.
Optional narrative description.
Options List:
1- Nameplate
2- Seasonal
3- 5-yr Unit
4- 5-yr EIA
5- Alternative
Format
Validations
Must be a non-negative number.
18
Data Dictionary | RM16-17-000
entities_to_ppas
Updated August 2021
Mapping of reporting entities (or their non-mbr affiliates) to their long-term power purchase agreements
(gray rows auto-populated by database system)
#
1
Attribute
entities_ppa_id
Description
Unique, table-specific, record identifier
autogenerated by the database system
on submission. Functions to uniquely
identify each row in a given table.
Company Identifier of the reporting
entity.
Identifier Type
Primary Key
Nullable
NA
SQL Type
INTEGER
Format
NA
Validations
2
reporting_entity_cid_cd
Foreign Key
(CID)
NA
CHARACTER(7)
CXXXXXX
Must match an active Company
Identifier registered with FERC.
These identifiers can be found
using General Search, found here.
3
mbr_submission_fk
The unique identifier for the submission
assigned by, andintegrated with, FERC
Online (e.g., eFiling Submission Report).
Date that this specific record became
active in the database.
Date that this specific record became
inactive in the database.
Superseding identifier for the record
being updated.
Populated only when the
gen_asset_type_fk is “EIA,” for internal
tracking purposes.
Indicates whether this is a new
submission or a submission to update an
existing record.
Foreign Key
(submissions)
NA
INTEGER
NA
4
active_date
NA
DATE
NA
DATE
NA
INTEGER
YYYY-MM-DD
(ANSI)
YYYY-MM-DD
(ANSI)
NA
5
inactive_date
6
updated_record_id
7
EIA_fk
NA
INTEGER
NA
8
record_type_cd
N
CHARACTER(6)
NA
9
reference_id
If updating an existing record, provides a
link to the existing record.
10
entity_id_type_cd
User selects one of the three identifier
types it will provide for these 2 fields:
-Company Identifier/CID of the
reportable entity. (Required if
available.)
-Legal Entity Identifier/LEI of the
reportable entity. (Required if
available and CID is not available.)
-FERC generated ID/GID of the
reportable entity. (Required if CID and
LEI are not available.)
Options List:
• New
• Update
Y
Options List:
• CID
• LEI
• GID
N
CHARACTER(3)
Must either be “New” or “Update”
if information is included in this
table.
Required if record_type_cd is
“Update.” Must match an existing
entry from the “Entities PPA ID”
column in the Entities to PPAs
Submitted Data Table, found here.
Must be “CID,” “LEI,” or “GID.”
19
Data Dictionary | RM16-17-000
entities_to_ppas
Updated August 2021
Mapping of reporting entities (or their non-mbr affiliates) to their long-term power purchase agreements
(gray rows auto-populated by database system)
#
11
Attribute
entity _id
Description
CID, LEI, or GID of the entity for whom
the PPA is being reported.
12
date_of_last_change
13
ppa_agreement_id
Identifier Type
Foreign Key
(CID)
Foreign Key
(LEI)
Foreign Key
(GID)
Nullable
N
SQL Type
CHARACTER(7)
CHARACTER(20)
CHARACTER(10)
Format
Validations
Must match an active record
identifier. These identifiers can be
found using General Search, found
here.
(If submission type is “Update”) the date
the change that is being reported
occurred.
Y
DATE
YYYY-MM-DD
(ANSI)
Valid date
An identifier chosen by the reporting
entity that can be used to refer to the
PPA, if needed. When possible, the
reporting entity should use the identifier
used in EQR Field 20.
Y
CHARACTER(30)
NA
Required if record_type_cd is
“Update.”
If record_type_cd is “New,” the
submitted identifier should not
have previously been used by this
reporting entity.
If record_type_cd is “Update,” the
submitted identifier must be an
identifier previously submitted by
this reporting entity.
14
counterparty_ID_ type_CD
15
counterparty_ID
User selects one of the three identifier
types it will provide for these 2 fields:
-Company Identifier/CID of the
reportable entity. (Required if
available).
-Legal Entity Identifier/LEI of the
reportable entity. (Required if
available and CID is not available).
-FERC generated ID/GID of the
reportable entity. (Required if CID and
LEI are not available).
CID, LEI, or GID for the counterparty of
the PPA.
Options List:
• CID
• LEI
• GID
N
CHARACTER (3)
Must be “CID,” “LEI,” or “GID.”
Foreign Key
(CID)
Foreign Key
(LEI)
Foreign Key
(GID)
N
CHARACTER(7)
CHARACTER(20)
CHARACTER(10 )
Must match an active record
identifier. Can be found using
General Search, found here.
20
Data Dictionary | RM16-17-000
entities_to_ppas
#
16
Attribute
ppa_type_fk
17
supply_type_fk
Updated August 2021
Mapping of reporting entities (or their non-mbr affiliates) to their long-term power purchase agreements
(gray rows auto-populated by database system)
Description
Identifies whether the reporting entity
or its non-MBR affiliate is the purchaser
or seller of energy/capacity.
The source of supply for the PPA. If
“Other” is selected, provide an
explanation in the explanatory_notes
field.
Identifier Type
Options List:
1 - Purchase
2 - Sale
Options List:
1 - Generator
Specific
2 - Slice of
System
3 - Portfolio
4 - Other
Nullable
N
SQL Type
INTEGER (1)
N
INTEGER
Format
Validations
Must be either “1” (Purchase) or
“2” (Sale).
Must match a valid entry from the
Options List.
This list is also available in the
Supply Type Lookup Table, found
here.
18
generation_asset_type_id
User selects whether it will identify the
generator using EIA Information or a
FERC-generated Asset ID.
Options List:
1 - EIA
2 - Asset ID
Y
INTEGER
Required if supply_type_fk is “1”
(Generator Specific).
19
eia_plant_code
“Plant Code” assigned to the plant as
found in the EIA-860 data.
Foreign Key
(EIA)
Y
CHARACTER
VARYING (MAX of
EIA Code)
Required if supply_type_fk is
“Generator Specific” and
generation_asset_type_id is “1”
(EIA)
EIA data hierarchy:
Plant Code -> Generator ->
Unit
e.g., Plant code = 123
Must match a valid " Plant Code”
from EIA Search for the given EIA
Plant Code and Generator.
EIA data is uploaded into the
EIA Search Table annually from the
EIA external source.
21
Data Dictionary | RM16-17-000
entities_to_ppas
#
20
Attribute
eia_generator_id
Updated August 2021
Mapping of reporting entities (or their non-mbr affiliates) to their long-term power purchase agreements
(gray rows auto-populated by database system)
Description
“Generator ID” assigned to the
generator as found in the EIA-860 data
(if applicable).
Identifier Type
Foreign Key
(EIA)
Nullable
Y
SQL Type
CHARACTER
VARYING (MAX of
EIA Code)
Format
EIA data hierarchy:
Plant Code -> Generator ->
Unit
e.g., Plant code = 200
Generator ID = 3
21
eia_unit_code
EIA data hierarchy:
Plant Code -> Generator ->
Unit
Must match a valid "Generator ID”
from EIA Search for the given EIA
Plant Code and Generator.
“Unit Code” assigned to linked
generators (e.g., combined cycle) as
found in the EIA-860 data (if applicable).
Foreign Key
(EIA)
Y
EIA data is uploaded into the
EIA Search Table annually from the
EIA external source.
Though nullable, this information is
required if supply_type_fk is
“Generator Specific,” the
generation_asset_type_id is “1”
(EIA) , and the Unit is relevant to
the asset appendix.
CHARACTER
VARYING (MAX of
EIA Code)
e.g., Plant code = 200
Generator ID = 3
Unit Code FK = ABC
22
ferc_asset_Gen_code
23
start_date
24
scheduled_end_date
Validations
Though nullable, this information is
required if supply_type_fk is
“Generator Specific,”
generation_asset_type_id is “1”
(EIA), and the Generator is relevant
to the asset appendix.
Must match a valid "Unit Code”
from EIA Search for the given EIA
Plant Code and Generator.
The FERC Asset ID assigned to the asset.
Asset IDs can be obtained by filers for
assets that do not have EIA codes.
(Needed if supply_type_fk is "1"
(Generator Specific); and
generation_asset_type_id is "2" (Asset
ID)).
The contractual start date of the PPA.
The date the PPA is scheduled to end (if
known).
Foreign Key
(Asset ID)
Y
EIA data is uploaded into the
EIA Search Table annually from the
EIA external source.
Required if supply_type_fk is “1”
(Generator Specific) and
generation_asset_type_id is “2”
(Asset ID).
INTEGER (10)
N
DATE
Y
DATE
YYYY-MM-DD
(ANSI)
YYYY-MM-DD
(ANSI)
Must provide a valid Gen Code
from Gen Assets Search.
Valid date
Valid date
Value must be ≥ start_date.
22
Data Dictionary | RM16-17-000
entities_to_ppas
Updated August 2021
Mapping of reporting entities (or their non-mbr affiliates) to their long-term power purchase agreements
(gray rows auto-populated by database system)
#
25
Attribute
actual_end_date
Description
If the PPA has ended, the date the PPA
ended.
26
amount
27
amount_adjusted
The megawatt (MW) amount of the PPA.
If the PPA is for capacity, provide the
specified amount, in MW. For energyonly PPAs, convert the units into MW
equivalents using the formula set forth
in Order No. 816 at PP 140-144, and FN
178.
The de-rated capacity value of the PPA.
Identifier Type
Nullable
Y
SQL Type
DATE
N
NUMERIC(6,2)
Y
NUMERIC(6,2)
Y
INTEGER(1)
This should only be reported when when
supply_type_fk is “1” (Generator
Specific) and there is a de-rated capacity
amount in the PPA.
28
29
adj_rating_options_fk
alt_methodology_used
The de-rating methodology used to
calculate the de-rated capacity value
reported in the amount_adjusted field.
(See P 266 of FERC Order No. 816 for
more information on the allowed
methodologies.)
The description of the de-rated capacity
methodology of the asset, if it does not
conform the other rating options.
This should only be reported when
adj_rating_options_fk is “5”
(Alternative). (See FERC Order No. 816
at P 106.)
Options List:
1 - Nameplate
2 - Seasonal
3 - 5-yr Unit
4 - 5-yr EIA
5 - Alternative
Format
YYYY-MM-DD
(ANSI)
Validations
Valid date
Value must be ≥ start_date
Must be a non-negative number.
Null if supply_type_fk is not “1”
(Generator Specific) OR if there are
no de-rating adjustments.
Must be a positive number less
than or equal to the nameplate
capacity of the corresponding
generator.
Null if supply_type_fk is not “1”
(Generator Specific). Required if
supply_type_fk is “1” (Generator
Specific).
This list is also available in the
Rating Adjust Options Lookup
Table, found here.
Y
CHARACTER
VARYING(MAX)
Required if supply_type_fk is “1”
(Generator Specific) and
adj_rating_options_fk is "5"
(Alternative).
Otherwise, must be Null.
23
Data Dictionary | RM16-17-000
entities_to_ppas
#
30
31
32
33
34
Attribute
source_balancing_
authority_cd
source_balancing_
authority_hub_cd
sink_balancing_
authority_cd
sink_balancing_
authority_hub_cd
explanatory_notes
Updated August 2021
Mapping of reporting entities (or their non-mbr affiliates) to their long-term power purchase agreements
(gray rows auto-populated by database system)
Description
Identifier for the market/BAA where the
energy/capacity is sourced. If the
energy/capacity is sourced at a hub,
provide the identifier corresponding to
“Hub” and provide a value for
source_balancing_authority_hub_cd.
May be the point of receipt BAA
(PORBA) in a contract.
Identifier for the hub where the
energy/capacity will source(needed if
sink_balancing_authority_cd is "Hub").
Identifier for the market/BAA where the
energy/capacity will sink. If the
energy/capacity will sink at a hub,
provide the identifier corresponding to
“Hub” and provide a value for
sink_balancing_authority_hub_cd.
May be the point of delivery (PODBA) in
a contract.
Identifier for the hub where the
energy/capacity will sink (needed If
sink_balancing_authority_cd is "Hub").
Optional narrative description of any
unique qualities of this PPA not captured
elsewhere.
Identifier Type
Foreign Key
(Balancing
Authority
Areas)
Nullable
Y
Foreign Key
(Hubs)
Y
SQL Type
CHARACTER
VARYING(5)
Format
Validations
Required if ppa_type_fk is “2”
(Sale).
Must match an entry from the
“Balancing Authority CD” column of
the BAA Lookup Table, found here.
Foreign Key
(Balancing
Authority
Areas)
Y
Foreign Key
(Hubs)
Y
CHARACTER
VARYING(11)
CHARACTER
VARYING(5)
Required if ppa_type_fk is
“2” (Sale) and
source_balancing_authority_cd
is “Hub.”
Must match an entry from the “Hub
CD” column of the Hub Lookup
Table, found here.
Required if ppa_type_fk is “1”
(Purchase).
Must match an entry from the
“Balancing Authority CD” column of
the BAA Lookup Table, found here.
Y
CHARACTER
VARYING(11)
CHARACTER
VARYING(MAX)
Required if ppa_type_fk is “1”
(Purchase) and
sink_balancing_authority_cd
is “Hub.”
Must match an entry from the “Hub
CD” column of the Hub Lookup
Table, found here.
Required if supply_type_fk is “5”
(Alternative).
24
Data Dictionary | RM16-17-000
Updated August 2021
Mapping of reporting entities (or their non-mbr affiliates) to their vertical assets
(gray rows auto-populated by database system)
entities_to_vertical_assets
#
Attribute
Description
Identifier Type
Nullable
SQL Type
Format
1
Entities_to_vertical_assets_id
Unique, table-specific, record identifier
autogenerated by the database system on
submission. Functions to uniquely identify
each row in a given table.
Primary Key
NA
INTEGER
NA
2
reporting_entity_cid_cd
Company Identifier of the reporting entity.
Foreign Key (CID)
NA
CHARACTER(7)
CXXXXXX
3
mbr_submission_fk
Foreign Key
(submissions)
NA
INTEGER
NA
4
active_date
The unique identifier for the submission
integrated with FERC Online (e.g., eFiling
Submission Report).
Date that this specific record became active in
the database.
NA
DATE
5
inactive_date
Date that this specific record became inactive
in the database.
NA
DATE
6
updated_record_id
Superseding identifier for the record being
updated.
NA
INTEGER
YYYYMM-DD
(ANSI)
YYYYMM-DD
(ANSI)
NA
7
record_type_cd
Indicates whether this is a new submission or
a submission to update an existing record.
N
CHARACTER(6)
NA
8
reference_id
If updating an existing record, provides a link
to the existing record.
Options List:
• New
• Update
Y
Validations
Must match an active Company
Identifier registered with FERC.
These identifiers can be found
using General Search, found here.
Must either be “New” or “Update”
if information is included in this
table.
Required if record_type_cd is
“Update.” Must match an existing
entry from the “Vertical Assets ID”
column in the Entities to Vertical
Assets Submitted Data Table,
found here.
25
Data Dictionary | RM16-17-000
Updated August 2021
Mapping of reporting entities (or their non-mbr affiliates) to their vertical assets
(gray rows auto-populated by database system)
entities_to_vertical_assets
#
Attribute
Description
Identifier Type
Nullable
SQL Type
9
entity _ID
User selects one of the three identifier types
it will provide for these 2 fields:
-Company Identifier/CID of the reportable
entity. (Required if available.)
-Legal Entity Identifier/LEI of the reportable
entity. (Required if available and CID is not
available.)
-FERC generated ID/GID of the reportable
entity. (Required if CID and LEI are not
available.)
CID, LEI, or GID that owns, operates, or
controls the vertical asset.
Foreign Key (CID)
Foreign Key (LEI)
Foreign Key (GID)
N
CHARACTER(7)
CHARACTER(20)
CHARACTER(10)
Must match an active record
identifier. Can be found using
General Search, found here.
Options List:
• CID
• LEI
• GID
Options List:
N
CHARACTER(3)
Must be “CID,” “LEI,” or “GID.”
N
INTEGER
The filer is required to submit one
record for each vertical asset type
they possess in the relevant BAA.
10 entity_ID_type_CD
11 vertical_asset_type_fk
The type of vertical asset being reported.
Ex: An entity has 3 Transmission Assets in the
PJM BAA. They are only required to submit
one record for that particular BAA to show
that they possess that type of asset.
12 Balancing_Authority_cd
Identifier for the market/BAA where the
vertical asset is located.
13 relationship_start_date
1- Transmission
Asset
2- Intrastate
Pipeline
3- Gas Storage
4- Gas
Distribution
5- Other Input
Foreign Key
(Balancing
Authority Areas)
Format
Validations
This list is also available in the
Vertical Asset Type Lookup Table,
found here.
N
CHARACTER
VARYING(5)
Date the reported relationship with the
vertical asset began.
N
DATE
14 relationship_end_date
Date the reported relationship with the
vertical asset ended.
Y
DATE
15 explanatory_notes
Optional narrative description.
Y
CHARACTER
VARYING(MAX)
YYYYMM-DD
(ANSI)
YYYYMM-DD
(ANSI)
Must match an entry from the
“Balancing Authority CD” column
of the BAA Lookup Table, found
here.
Valid date
Valid date
Value must be ≥ start_date
26
Data Dictionary | RM16-17-000
Updated August 2021
Market-based rate pivotal supplier screen inputs
(gray rows auto-populated by database system)
indicative_pss
#
Attribute
Description
Identifier Type
Nullable
SQL Type
Format
1
indicative_pss_id
Primary Key
NA
INTEGER
NA
2
reporting_entity_cid_
cd
Unique, table-specific, record
identifier autogenerated by the
database system on submission.
Functions to uniquely identify each
row in a given table.
Company Identifier of the reporting
entity.
Foreign Key (CID)
NA
CHARACTER
(7)
CXXXXX
X
3
mbr_submission_fk
Foreign Key (submissions)
NA
INTEGER
NA
4
study_type_cd
The unique identifier for the
submission integrated with FERC
Online (e.g., eFiling Submission
Report).
Flag indicating whether the entity is
submitting this screen for the first
time or amending/replacing a
previously submitted screen.
N
CHARACTER
(6)
5
study_amended_
reference_fk
Options List:
• New (entity is submitting this screen for the
first time)
• Update (entity is revising its own previously
submitted screen)
Foreign Key (PSS)
Y
INTEGER
*Supplied
after new
record is
accepted*
(If study_type is “Update”) The ID
of the study (from the PSS) to be
amended/replaced.
Validations
Must match an active
Company Identifier
registered with FERC. These
identifiers can be found
using General Search, found
here.
Must either be “New” or
“Update” if information is
included in this table.
NA
Required if study_type_cd is
“Update.”
Must match an existing
record identifier in the
Indicative PSS Submitted
Data Table, found here. This
identifier will be the first
column in the table
titled”Indicative PSS Study
ID” of a previous
submission.
*** This should match a PSS
which belongs to the filing
company CID ***
27
Data Dictionary | RM16-17-000
Updated August 2021
Market-based rate pivotal supplier screen inputs
(gray rows auto-populated by database system)
indicative_pss
#
Attribute
Description
Identifier Type
Nullable
SQL Type
Format
Validations
6
pss_study_reference_
fk
If the submitted screen relies on a
previously submitted screen,
provide the reference ID of the
screen that it relies on.
Foreign Key (PSS)
Y
INTEGER
NA
Required if the submitted
PSS screen relies on a
previously submitted PSS
screen.
Must match an existing
entry from the “Indicative
PSS Study ID” column in the
Indicative PSS Submitted
Data Table, found here.
7
study_end_year
8
study_area_
balancing_authority_
cd
9
scenario_type
The year that the data year of the
submitted screen ends. For
example, if your study uses the data
year December 1, 2015 to
November 30, 2016, the
study_end_year is “2016.”
Identifier for the market/BAA or
submarket that is being studied.
Indicator of whether the submitted
screen is a base case scenario or a
sensitivity analysis.
N
CHARACTER
(4)
YYYY
Must be a current or
historical year.
Foreign Key (Balancing Authority Areas)
N
CHARACTER
VARYING(5)
NA
Must match an entry from
the “Balancing Authority
CD” column of the BAA
Lookup Table, found here.
Options List:
1 - Base Case
2 - Sensitivity Analysis
N
INTEGER
NA
Must be either “1” (Base
case) or “2” (Sensitivity
Analysis).
28
Data Dictionary | RM16-17-000
Updated August 2021
Market-based rate pivotal supplier screen inputs
(gray rows auto-populated by database system)
indicative_pss
#
Attribute
Description
Identifier Type
Nullable
SQL Type
Format
Validations
10
study_parameter
The complete listing of all the
parameters which are to be
submitted as part of the Pivotal
Supplier Indicative Screen.
1 - Seller Installed Capacity
2 - Seller Remote Capacity
3 - Seller LT Firm Purchases from Inside
4 - Seller LT Firm Purchases from Outside
5 - Seller LT Firm Sales
6 - Seller Uncommitted Capacity Imports
7 - Non-Affiliate Installed Capacity
8 - Non-Affiliate Remote Capacity
9 - Non-Affiliate LT Firm Purchases from Inside
10 - Non-Affiliate LT Firm Purchases from
Outside
11 - Non-Affiliate LT Firm Sales
12 - Non-Affiliate Uncommitted Capacity
Imports
13 - Study Area Reserve Requirement
14 - Reserve Requirement Attributable to Seller
15 - Total Uncommitted Supply
16 - Study Area Annual Peak Load
17 - Average Daily Peak Native Load in Peak
Month
18 - Amount of Average Daily Peak Native Load
Attributable to Seller
19 - Wholesale Load
20 - Net Uncommitted Supply
21 - Seller Uncommitted Capacity
22 - Result (0 for Fail, 1 for Pass)
23 - Total Imports
24 - Seller Percent of SIL
25 - Non-Affiliate Percent of SIL
26 - SIL Value
27 - SIL Limit Exceeded (0 for No, 1 for Yes)
N
INTEGER
NA
Must provide a
corresponding
study_parameter_value for
each of these Study
Parameters.
11
study_parameter_
value
N
NUMERIC
(8,2)
NA
Values should comply with
the rules governing the
market-based rate program.
12
study_parameter_
reference
The numeric value associated with
each parameter of the Pivotal
Supplier Indicative Screen.
(Optional) Narrative description of
the data source used to determine
study parameter value.
Y
CHARACTER
VARYING
(MAX)
NA
29
Data Dictionary | RM16-17-000
Updated August 2021
Market-based rate market share screen inputs
(gray rows auto-populated by database system)
indicative_mss
#
1
Attribute
indicative_mss_id
2
reporting_entity_cid_
cd
3
mbr_submission_fk
4
study_type_cd
5
study_amended_
reference_fk
Description
Unique, table-specific, record
identifier autogenerated by the
database system on submission.
Functions to uniquely identify
each row in a given table.
Company Identifier of the
reporting entity.
Identifier Type
Primary Key
Nullable
NA
SQL Type
INTEGER
Format
NA
Validations
Foreign Key (CID)
NA
CHARACTER(7)
CXXXXXX
Must match an active Company
Identifier registered with FERC. These
identifiers can be found using General
Search, found here.
The unique identifier for the
submission integrated with
FERC Online (e.g., eFiling
Submission Report).
Flag indicating whether the
entity is submitting this screen
for the first time or
updating/replacing a previously
submitted screen.
(If study_type_cd is “Update”)
The serial number of the study
(from the MSS) to be
amended/replaced.
Foreign Key (submissions)
NA
INTEGER
NA
Options List:
• New (entity is submitting this
screen for the first time)
• Update (entity is revising its own
previously submitted screen)
Foreign Key (MSS)
N
INTEGER
NA
Must either be “New” or “Update” if
information is included in this table.
Y
INTEGER
*Will be
supplied later
after new
record is
accepted*
NA
Required if study_type_cd is “Update”
Must match an existing record
identifier in the Indicative MSS
Submitted Data Table, found here.
This identifier will be the first column
in the table titled”Indicative MSS
Study ID” of a previous submission.
*** This should match a MSS which
belongs to the filing company CID ***
6
mss_study_reference_
fk
If the submitted screen relies on
a previously submitted screen,
provide the reference ID of the
screen that it relies on.
Foreign Key (MSS)
Y
INTEGER
NA
Required if the submitted MSS screen
relies on a previously submitted MSS
screen.
Must match an existing entry from the
“Indicative MSS Study ID” column in
the Indicative MSS Submitted Data
Table, found here.
30
Data Dictionary | RM16-17-000
Updated August 2021
Market-based rate market share screen inputs
(gray rows auto-populated by database system)
indicative_mss
#
7
Attribute
study_end_year
Description
The year that the data year of
the submitted screen ends. For
example, if your study uses the
data year December 1, 2015 to
November 30, 2016, the
study_end_year is “2016”).
Identifier for the market/BAA or
submarket that is being studied.
Identifier Type
Nullable
N
SQL Type
CHARACTER(4)
8
study_area_balancing_
authority_cd
9
10
Format
YYYY
Validations
Must be a current or historical year.
Foreign Key (Balancing Authority
Areas)
N
CHARACTER(5)
Must match an entry from the
“Balancing Authority CD” column of
the BAA Lookup Table, found here.
scenario_type
Indicator of whether the
submitted screen is a base case
scenario or a sensitivity analysis.
Options List:
1 – Base Case
2 – Sensitivity Analysis
N
INTEGER
Must be either “1” (Base Case) or “2”
(Sensitivity Analysis).
season
The relevant season.
Options List:
1 – Winter
2 – Spring
3 – Summer
4 – Fall
N
INTEGER
Must match a valid entry from the
Options List.
31
Data Dictionary | RM16-17-000
indicative_mss
#
11
Attribute
study_parameter
Description
The listing of all the parameters
which are to be submitted as
part of the Market Share
Indicative Screen.
Updated August 2021
Market-based rate market share screen inputs
(gray rows auto-populated by database system)
Identifier Type
Nullable SQL Type
1 - Seller Installed Capacity
N
INTEGER
2 - Seller Remote Capacity
3 - Seller LT Firm Purchases from Inside
4 - Seller LT Firm Purchases from Outside
5 - Seller LT Firm Sales
6 - Seller Seasonal Planned Outages
7 - Seller Uncommitted Capacity Imports
8 - Average Peak Native Load in the Season
9 - Average Peak Native Load Attributable to
Seller
10 - Average Peak Native Load Attributable
to Non-Affiliates
11 - Study Area Reserve Requirement
12 - Study Area Reserve Requirement
Attributable to Seller
13 - Study Area Reserve Requirement
Attributable to Non-Affiliates
14 - Non-Affiliate Installed Capacity
15 - Non-Affiliate Remote Capacity
16 - Non-Affiliate LT Firm Purchases from
Inside
17 - Non-Affiliate LT Firm Purchases from
Outside
18 - Non-Affiliate LT Firm Sales
19 - Non-Affiliate Seasonal Planned Outages
20 - Non-Affiliate Uncommitted Capacity
Imports
21 - Total Competing Supply
22 - Seller Uncommitted Capacity
23 - Total Seasonal Uncommitted Capacity
24 - Seller’s Market Share
25 - Result (0 for Fail, 1 for Pass)
26 - Total Imports
27 - Seller Percent of SIL
28 - Non-Affiliate Percent of SIL
29 - SIL Value
30 - SIL Limit Exceeded (0 for No, 1 for Yes)
Format
Validations
Must provide a corresponding
study_parameter_value for each of
the Study Parameters, in every
season.
32
Data Dictionary | RM16-17-000
Updated August 2021
indicative_mss
#
12
Attribute
study_parameter_value
13
study_parameter_
reference
Description
The numeric value associated
with each parameter of the
Market Share Indicative Screen.
(Optional) Narrative description
of the data source used to
determine study parameter
value.
Identifier Type
Market-based rate market share screen inputs
(gray rows auto-populated by database system)
Nullable SQL Type
N
NUMERIC (8,2)
Y
Format
Validations
Values should comply with the rules
governing the market-based rate
program.
CHARACTER
VARYING(MAX)
33
Data Dictionary | RM16-17-000
Updated August 2021
SQL Format Types
Definition
Example
Integer
Character (size)
A whole number that is not a fraction
A FIXED length string (can contain letters, numbers, and special
characters). The size in parentheses specifies the column length in
characters (in numbers).
A VARIABLE length string (can contain letters, numbers, and special
characters). The size in parentheses specifies the maximum column
length in characters (in numbers).
A date. Format: YYYY-MM-DD
1, 2, 3…n
This is an example of a string
Any number within the length limits. The size in parentheses specifies
the maximum length of the number – the decimals in parentheses
specifies the maximum amount of decimals in the number.
Numeric(4,2) – 12.34
Character Varying (size)
Date
yyyy-mm-dd
Numeric (size,decimals)
This is an example of a string with
numbers (1, 2, 3…n) and special
characters (%, !, etc.)
2021-01-20
Numeric(6,4) – 1234.56
34
| File Type | application/pdf |
| Author | Ryan Stertz |
| File Modified | 2021-08-31 |
| File Created | 2021-08-31 |