FERC-549D Data Dictionary

C. Proposed FERC-549D Data Dictionary and Reporting Units. (Note: all field numbers correspond to the Table of Data Elements)

Field No.	Field Category	Field Sub-Category	Field Name	Required (Y/N)	Value	Staff Suggested Definition	Reg. (Commission Requirement)*
1	CO ID DATA	COMPANY	Filing Company- Legal Name of Intrastate/ Hinshaw Company	Y	Unrestricted text (100 characters)	Name of the company filing this report.
2	CO ID DATA	COMPANY	FERC ID	Y	Number with up to 6 digits.	FERC Designated ID for filing company that was obtained from FERC.
3	CO ID DATA	REPORT ID	Report is Original / Resubmission	Y	O-Original R-Resubmission	Identify if the report is an Original or a Resubmission.
4	CO ID DATA	REPORT ID	Submission Date	Y	YYYYMMDD	The first 4 numbers represent the year (e.g., 2010). The 5th and 6th numbers represent the month. The last two numbers represent the day.
5	CO ID DATA	REPORT ID	Report is to confirm transport ration of gas under § 284.122	Y	Y-Yes N-No	Identify if the filer transported gas under § 284.122 during the quarter. If yes, complete all fields as necessary, if no complete fields 1 through 18.
6	CO ID DATA	REPORT ID	Filing Calendar Year & Quarter	Y	YYYYMM	The first 4 numbers represent the year (e.g., 2010). The last 2 numbers represent the last month of the quarter (e.g., 03= 1st quarter; 06= 2nd quarter; 09= 3rd quarter; 12= 4th quarter.)
7	CO ID DATA	CONTACT	Filing Company- Contact Name	Y	Unrestricted text (50 characters)	Name of the person who will answer questions regarding the filing and/or electronically files.
8	CO ID DATA	CONTACT	Filing Company- Contact Title	Y	Unrestricted text (50 characters)	Title of the contact identified in field #7.
9	CO ID DATA	CONTACT	Filing Company- Contact Phone No.	Y	Unrestricted text (20 characters)	Phone Number for the filing contact identified in field #7.
10	CO ID DATA	CONTACT	Filing Company- Contact E-Mail Address	Y	Unrestricted text (100 characters)	E-Mail address for the contact identified in field #7.
11	CO ID DATA	COMPANY	Filing Company- Street Address	Y	Unrestricted text (150 characters)	Address for the filing company identified in field #1.
12	CO ID DATA	COMPANY	Filing Company- City	Y	Unrestricted text (50 characters)	City for the filing company identified in field #1.
13	CO ID DATA	COMPANY	Filing Company- State	Y	Restricted text (2 characters)	State for the filing company identified in field #1.
14	CO ID DATA	COMPANY	Filing Company- Zip	Y	Restricted text (10 characters)	Zip or postal code for the filing company identified in field #1.
15	CO ID DATA	COMPANY	Filing Company- Country Name	Y	Unrestricted text (50 characters)	Country for the filing company identified in field #1.
16	CO ID DATA	SIGNATORY	Signing Official Title	Y	Unrestricted text (50 characters)	Title of the company officer who attests to the accuracy of the filing.	§284.126(b)(viii)
17	CO ID DATA	SIGNATORY	Signing Official Signature	Y	Unrestricted text (50 characters)	Name of the company officer who attests to the accuracy of the filing by confirming that "I am duly authorized to verify, execute, and file with the Federal Energy Regulatory Commission the foregoing Quarterly Intrastate Report and that the statements and facts contained therein are true, correct, and accurate to the best of my knowledge." Typing in the name of the signing official is an acceptable electronic signature in accordance with 18 CFR §385.2005(c) of the Commission’s regulations.	§284.126(b)(viii)
18	CO ID DATA	SIGNATORY	Date Signed	Y	YYYYMMDD	The first 4 numbers represent the year (e.g., 2010). The 5th and 6th numbers represent the month. The last two numbers represent the day.	§284.126(b)(viii)
19	SHIPPER ID DATA	SHIPPER DATA	Name of Shipper Receiving Service	Y	Unrestricted text (100 characters)	Enter full legal name.	§284.126(b)(i)
20	SHIPPER ID DATA	SHIPPER DATA	Shipper Identification Number	Y	Unrestricted text (9 characters)	Shipper ID - Use the unique Data Universal Numbering System (D-U-N-S®) Number assigned by the Dun & Bradstreet Corporation and accepted by the North American Energy Standards Board (NAESB) as the common code for the shipper.	§284.126(b)(i)
21	SHIPPER ID DATA	SHIPPER DATA	Affiliate (Y/N)	Y	Y-Yes N -No	Companies or persons that directly or indirectly, through one or more intermediaries, control, or are controlled by, or under common control of the company in question.	§284.126(b)(i)
22	SHIPPER ID DATA	TYPE OF SERVICE PERFORMED	Rate Schedule Designation	Y	Unrestricted text (100 characters)	Examples of Rate Schedule designation: FTS=Firm Transportation Service; FSS=Firm Storage Service; ITS=Interruptible Transportation Service; ISS=Interruptible Storage Service; P/L=Parking / Lending Service; and Other.	§284.126(b)(iii)
23	SHIPPER ID DATA	TYPE OF SERVICE PERFORMED	Type of Service Performed - Transportation / Storage / Parking-Lending / Other (Specify)	Y	T-Transportation S-Storage P/L-Parking /Lending O-Other (Specify)	Other includes wheeling, hub services, imbalance services, pooling service, title transfer tracking service, penalties, surcharges or other charges, etc.	§284.126(b)(iii)
24	SHIPPER ID DATA	TYPE OF SERVICE PERFORMED	Firm / Interruptible	Y	F-Firm I-Interruptible	Service on a firm basis means that the service is not subject to a prior claim by another customer or another class of service and receives the same priority as any other class of firm service. Service on an interruptible basis means that the capacity used to provide the service is subject to a prior claim by another customer or another class of service and receives a lower priority than such other class of service.	§284.126(b)(ii); §284.7 and §284.9
25	SHIPPER ID DATA	TYPE OF SERVICE PERFORMED	Docket where rates were approved	Y	Unrestricted text (20 characters)	FERC docket number where rates were approved. For Intrastate pipelines the designation is usually PR or SA.	§284.126(b)(iii)
26	SHIPPER ID DATA	SHIPPER DATA	Contract Identification Number	Y	Unrestricted text (20 characters)	Number that is assigned by the pipeline/ storage company to the shipper	§284.126(b)(i)
27	SHIPPER ID DATA	SHIPPER DATA	Beginning date of current contract term	Y	YYYYMM	The first 4 numbers represent the year (e.g., 2009). The last 2 numbers represent the last month of the quarter (e.g., 03 - March; 06- June; 09 - September; and 12 - December).	§284.126(b)(vi)
28	SHIPPER ID DATA	SHIPPER DATA	Ending date of current contract term	Y	YYYYMM	The first 4 numbers represent the year (e.g., 2009). The last 2 numbers represent the last month of the quarter (e.g., 03 - March; 06- June; 09 - September; and 12 - December).	§284.126(b)(vi)
29	SHIPPER ID DATA	RECEIPT / DELIVERY POINTS	Primary Receipt Point Name	Y	Unrestricted text (100 characters)	The term "Receipt Point" shall mean either (a) a Headstation, (b) the Point of Injection/Withdrawal, or (c) a point on Pipeline's Pipeline System that Shipper and Pipeline shall agree upon, where Gas enters facilities owned by Transporter, and is metered. If more than one primary receipt point in an individual rate schedule category, please indicate each additional point in a footnote or comment field.	§284.126(b)(iv)
30	SHIPPER ID DATA	RECEIPT / DELIVERY POINTS	Primary Receipt Industry Common Code	Y	Number with up to 9 digits.	Point Identification Code - Use the North American Energy Standards Board/Petroleum Information Corporation (NAESB/PI) Data Reference Number, a one-to-nine digit number also assigned by IHS (successor to PI). If more than one primary delivery point in an individual rate schedule category, please indicate each additional point in a footnote or comment field.	§284.126(b)(iv)
31	SHIPPER ID DATA	RECEIPT / DELIVERY POINTS	Primary Delivery Point Name	Y	Unrestricted text (100 characters)	The term "Delivery Point" shall mean either (a) a Headstation, (b) the Point of Injection/Withdrawal, or (c) a point on Pipeline's Pipeline System that Shipper and Pipeline shall agree upon, where Gas exits facilities owned by Pipeline, and is metered. If more than one primary delivery point in an individual rate schedule category, please indicate each additional point in a footnote or comment field.	§284.126(b)(iv)
32	SHIPPER ID DATA	RECEIPT / DELIVERY POINTS	Primary Delivery Industry Common Code	Y	Number with up to 9 digits.	Point Identification Code - Use the North American Energy Standards Board/Petroleum Information Corporation (NAESB/PI) Data Reference Number, a one-to-nine digit number also assigned by IHS (successor to PI). If more than one primary delivery point in an individual rate schedule category, please indicate each additional point in a footnote or comment field.	§284.126(b)(iv)
33	RATES	CONTRACT RESERVATION RATES	Contract Reservation Rate - Peak Day	Required if field #20 if F-Firm	Number with up to 6 decimals.	The rate charged under the current contract for peak day capacity. If there is more than one rate for the transaction, provide the average rate and include the various rates in a footnote or comment field.	§284.126(b)(iii)
34	RATES	CONTRACT RESERVATION RATES	Contract Reservation Rate - Peak Day (Rate Units)	Required if field #33 is filled out.	See Column (1) of Appendix Page 12.	The rate unit for the Peak Day Contract Reservation Rate.	§284.126(b)(iii)
35	RATES	CONTRACT RESERVATION RATES	Contract Reservation Rate - Annual Volume	Required if field #20 if F-Firm	Number with up to 6 decimals.	The rate charged under the current contract to reserve annual volume capacity. If there is more than one rate for the transaction, provide the average rate and include the various rates in a footnote or comment field.	§284.126(b)(iii)
36	RATES	CONTRACT RESERVATION RATES	Contract Reservation Rate - Annual Volume (Rate Units)	Required if field #35 is filled out.	See Column (2) of Appendix Page 12.	The rate unit for the Annual Volume Contract Reservation Rate.	§284.126(b)(iii)
37	RATES	CONTRACT USAGE RATES	Contract Usage Rate - Transported	At least one of the fields # 37, 39, 41, or 43 is required.	Number with up to 6 decimals.	The usage rate charged under the current contract for transportation service. If there is more than one rate for the transaction, provide the average rate and include the various rates in a footnote or a comment field.	§284.126(b)(iii)
38	RATES	CONTRACT USAGE RATES	Contract Usage Rate - Transported (Rate Units)	Required if field #37 is filled out.	See Column (3) of Appendix Page 12.	The rate unit for the Transported Contract Usage Rate.	§284.126(b)(iii)
39	RATES	CONTRACT USAGE RATES	Contract Usage Rate - Injected	At least one of the fields # 37, 39, 41, or 43 is required.	Number with up to 6 decimals.	The usage rate charged under the current contract for injection service. If there is more than one rate for the transaction, provide the average rate and include the various rates in a footnote or a comment field.	§284.126(b)(iii)
40	RATES	CONTRACT USAGE RATES	Contract Usage Rate - Injected (Rate Units)	Required if field #39 is filled out.	See Column (4) of Appendix Page 12.	The rate unit for the Injected Contract Usage Rate.	§284.126(b)(iii)
41	RATES	CONTRACT USAGE RATES	Contract Usage Rate - Withdrawn	At least one of the fields # 37, 39, 41, or 43 is required.	Number with up to 6 decimals.	The usage rate charged under the current contract for withdrawal service. If there is more than one rate for the transaction, provide the average rate and include the various rates in a footnote or a comment field.	§284.126(b)(iii)
42	RATES	CONTRACT USAGE RATES	Contract Usage Rate - Withdrawn (Rate Units)	Required if field #41 is filled out.	See Column (5) of Appendix Page 12.	The rate unit for the Withdrawn Contract Usage Rate.	§284.126(b)(iii)
43	RATES	CONTRACT USAGE RATES	Contract Usage Rate - Storage/Lending Service [Initial Day or Single One-Part Rate]	At least one of the fields # 37, 39, 41, or 43 is required.	Number with up to 6 decimals.	The usage rate charged under the current contract for storage / lending service for the initial day of service or the rate if there is a single one-part rate. If there is more than one rate for the transaction, provide the average rate and include the various rates in a footnote or a comment field.	§284.126(b)(iii)
44	RATES	CONTRACT USAGE RATES	Contract Usage Rate - Storage/Lending Service [Consecutive Days]	N	Number with up to 6 decimals.	The usage rate charged under the current contract for storage / lending service for each consecutive day of service. If there is more than one rate for the transaction, provide the average rate and include the various rates in a footnote or a comment field.	§284.126(b)(iii)
45	RATES	CONTRACT USAGE RATES	Contract Usage Rate - Storage/Lending Service (Rate Units)	Required if field #43 is filled out.	See Column (6) of Appendix Page 12.	The rate unit for the Storage / Lending Service Contract Usage Rate.	§284.126(b)(iii)
46	RATES	CONTRACT USAGE RATES	Other Contract Charges (explain in a footnote or a comment field)	N	Explain in a footnote or a comment field.	Include any additional charges billed under the current contract not included above.	§284.126(b)(iii)
47	BILLING UNITS	RESERVATION QUANTITIES	Contract Reservation Quantity - Peak Day Delivery	N	Number with up to 3 decimals.	The level of peak capacity reserved under the current contract. Volumes should not be adjusted for discounts.	§284.126(b)(v)
48	BILLING UNITS	RESERVATION QUANTITIES	Contract Reservation Quantity - Peak Day Delivery (Billing Units)	Required if field #47 is filled out.	See Column (7) of Appendix Page 13.	The billing unit for the Contract Reservation Rate for Peak Day Capacity.	§284.126(b)(v)
49	BILLING UNITS	RESERVATION QUANTITIES	Contract Reservation Quantity - Annual Volume	N	Number with up to 3 decimals.	The maximum level of annual volume reserved under the current contract. Volumes should not be adjusted for discounts.	§284.126(b)(v)
50	BILLING UNITS	RESERVATION QUANTITIES	Contract Reservation Quantity - Annual Volume (Billing Units)	Required if field #49 is filled out.	See Column (8) of Appendix Page 13.	The billing unit for the Contract Reservation Rate for Annual Volume Capacity.	§284.126(b)(v)
51	BILLING UNITS	USAGE QUANTITIES	Usage Quantity - Volumes Transported	At least one of the fields # 51, 53, 55, or 57 is required.	Number with up to 3 decimals.	The level of transportation usage reported for the quarter. Volumes should not be adjusted for discounts.	§284.126(b)(vii)
52	BILLING UNITS	USAGE QUANTITIES	Usage Quantity - Volumes Transported (Billing Units)	Required if field #51 is filled out.	See Column (9) of Appendix Page 13.	The billing unit for the Contract Usage Rate for gas transported.	§284.126(b)(vii)
53	BILLING UNITS	USAGE QUANTITIES	Usage Quantity - Volumes Injected	At least one of the fields # 51, 53, 55, or 57 is required.	Number with up to 3 decimals.	The level of gas injection reported for the quarter. Volumes should not be adjusted for discounts.	§284.126(b)(vii)
54	BILLING UNITS	USAGE QUANTITIES	Usage Quantity - Volumes Injected (Billing Units)	Required if field #53 is filled out.	See Column (10) of Appendix Page 13.	The billing unit for the Contract Usage Rate for gas injected.	§284.126(b)(vii)
55	BILLING UNITS	USAGE QUANTITIES	Usage Quantity - Volumes Withdrawn	At least one of the fields # 51, 53, 55, or 57 is required.	Number with up to 3 decimals.	The level of gas withdrawal reported for the quarter. Volumes should not be adjusted for discounts.	§284.126(b)(vii)
56	BILLING UNITS	USAGE QUANTITIES	Usage Quantity - Volumes Withdrawn (Billing Units)	Required if field #55 is filled out.	See Column (11) of Appendix Page 13.	The billing unit for the Contract Usage Rate for gas withdrawn.	§284.126(b)(vii)
57	BILLING UNITS	USAGE QUANTITIES	Usage Quantity - Storage/Lending Service for Initial Day or Total for Service with Single One-Part Rate	At least one of the fields # 51, 53, 55, or 57 is required.	Number with up to 3 decimals.	The daily average level of gas using the storage / lending service for the initial day of service or the total if there is a one-part rate. Volumes should not be adjusted for discounts.	§284.126(b)(vii)
58	BILLING UNITS	USAGE QUANTITIES	Usage Quantity - Storage/Lending Service for Consecutive Days of Service	N	Number with up to 3 decimals.	The daily average level of gas using the storage / lending service for consecutive days of service. Volumes should not be adjusted for discounts.	§284.126(b)(vii)
59	BILLING UNITS	USAGE QUANTITIES	Usage Quantity - Storage/Lending Service (Billing Units)	Required if field #57 is filled out.	See Column (12) of Appendix Page 13.	The billing unit for the Contract Usage Rate for gas storage / lending service.	§284.126(b)(vii)
60	BILLING UNITS	USAGE QUANTITIES	Usage Quantity for Other Charges (explain in a footnote or a comment field)	N	Number with up to 3 decimals.	The amount of billing units associated with Other Charges.	§284.126(b)(vii)
61	REVENUES	RESERVATION REVENUES	Reservation Revenues related to Peak Day Delivery	Required if either fields # 33 or 47 is filled out.	Whole number with no decimals.	The amount of revenue from the peak day contract reservation rate.	§284.126(b)(vii)
62	REVENUES	RESERVATION REVENUES	Reservation Revenues related to Peak Day Delivery	Required if either fields # 35 or 49 is filled out.	Whole number with no decimals.	The amount of revenue from the annual volume contract reservation rate.	§284.126(b)(viii)
63	REVENUES	USAGE REVENUES	Usage Revenues related to Volumes Transported	Required if either fields # 37 or 51 is filled out.	Whole number with no decimals.	The amount of revenue from gas transported.	§284.126(b)(viii)
64	REVENUES	USAGE REVENUES	Usage Revenues related to Volumes Injected	Required if either fields # 39 or 53 is filled out.	Whole number with no decimals.	The amount of revenue from gas injected.	§284.126(b)(viii)
65	REVENUES	USAGE REVENUES	Usage Revenues related to Volumes Withdrawn	Required if either fields # 41 or 55 is filled out.	Whole number with no decimals.	The amount of revenue from gas withdrawn.	§284.126(b)(viii)
66	REVENUES	USAGE REVENUES	Revenues related to Storage/Lending Service	Required if either fields # 43 or 57 is filled out.	Whole number with no decimals.	The amount of revenue from gas storage / lending service.	§284.126(b)(viii)
67	REVENUES	USAGE REVENUES	Revenues from Other Charges (explain in a footnote or a comment field)	Required if field # 45 is filled out.	Whole number with no decimals.	The amount of revenue from Other Charges under the contract.	§284.126(b)(viii)
68	REVENUES	TOTAL REVENUES	Total Revenues	Y	Whole number with no decimals.	The total amount of revenue charged for services as permitted in the SOC.	§284.126(b)(viii)

RATE UNITS FOR DATA DICTIONARY
(1)	(2)	(3)	(4)	(5)	(6)
Contract Reservation Rate - Peak Day	Contract Reservation Rate - Annual Volume	Contract Usage Rate - Transported	Contract Usage Rate - Injected	Contract Usage Rate - Withdrawn	Storage / Lending Service
$/Dth-day	$/Dth-day	$/Dth	$/Dth	$/Dth	$/Dth-day
$/Dth-mo.	$/Dth-mo.	$/MMBtu	$/MMBtu	$/MMBtu	$/Dth
$/Dth	$/Dth	$/th	$/th	$/th	$/MMBtu-day
$/MMBtu-day	$/MMBtu-day	$/Mcf	$/Mcf	$/Mcf	$/MMBtu
$/MMBtu-mo.	$/MMBtu-mo.	¢/Dth	¢/Dth	¢/Dth	$/th-day
$/MMBtu	$/MMBtu	¢/MMBtu	¢/MMBtu	¢/MMBtu	$/th
$/th-day	$/th-day	¢/th	¢/th	¢/th	$/Mcf-day
$/th-mo.	$/th-mo.	¢/Mcf	¢/Mcf	¢/Mcf	$/Mcf
$/th	$/th				¢/Dth-day
$/Mcf-day	$/Mcf-day				¢/Dth
$/Mcf-mo.	$/Mcf-mo.				¢/MMBtu-day
$/Mcf	$/Mcf				¢/MMBtu
¢/Dth-day	¢/Dth-day				¢/th-day
¢/Dth-mo.	¢/Dth-mo.				¢/th
¢/Dth	¢/Dth				¢/Mcf-day
¢/MMBtu-day	¢/MMBtu-day				¢/Mcf
¢/MMBtu-mo.	¢/MMBtu-mo.
¢/MMBtu	¢/MMBtu
¢/th-day	¢/th-day
¢/th-mo.	¢/th-mo.
¢/th	¢/th
¢/Mcf-day	¢/Mcf-day
¢/Mcf-mo.	¢/Mcf-mo.
¢/Mcf	¢/Mcf

BILLING UNITS FOR DATA DICTIONARY
(7)	(8)	(9)	(10)	(11)	(12)
Contract Reservation Rate - Peak Day	Contract Reservation Rate - Annual Volume	Contract Usage Rate - Transported	Contract Usage Rate - Injected	Contract Usage Rate - Withdrawn	Storage / Lending Service
Dth-day	Dth-day	Dth	Dth	Dth	Dth
Dth-mo.	Dth-mo.	MMBtu	MMBtu	MMBtu	MMBtu
Dth	Dth	th	th	th	th
MMBtu-day	MMBtu-day	Mcf	Mcf	Mcf	Mcf
MMBtu-mo.	MMBtu-mo.
MMBtu	MMBtu
th-day	th-day
th-mo.	th-mo.
th	th
Mcf-day	Mcf-day
Mcf-mo.	Mcf-mo.
Mcf	Mcf
Revenues should be reported in whole numbers.

Proposed FERC-549D Appendix Page 9