Skip universal navigation

New York State Universal header

Skip to main content

Inventory reporting column headings

On all of the inventory reporting forms, please do not use any commas, decimals, dollar signs, or any other punctuation. (The first line on all of the templates is an example.)

Explanation of column headings for 4.1 mass file:

Column Description
Company_id 6 digit company code
As_of_Yr Inventory reported as of year
Acct_Num 8 digit account number used by ORPTS
Comp_Acct Company account number if different than ORPTS account number
Swis_code 6 digit code for each municipality
Comp_Td Company tax district, not required
Cost_Incu Cost incurred by – C for company, O for other
Bal_Sheet Single digit 1 through 9. A complete listing of balance sheet numbers can be found here:
Plant_type Left blank
Install_Yr Year the inventory was installed
Hw_Grs_Srv Public surviving or additions, dollar amount with no commas, cents, or dollar signs
Hw_Retire Any public retirements listed here
Pv_Grs_Srv Private surviving or additions, dollar amount with no commas, cents, or dollar signs
Pv_Retire Any private retirements listed here


For the 4.6 Mass Form for Transmission Pipeline Companies:

Column

Description

Pl_Diam Pipeline diameter
Pl_Hw_Feet Feet of pipeline in public right of way
Pl_Pv_Feet Feet of pipeline in private


For the 2.1 Structure file:

Column Description
Location 6 digit location code, company generated
Facility 3 digit facility code, company generated
Sub_fac 2 digit code, company generated, can be zero filled


For the 5.1 Balance File:

Column Description
Personal Amount of balance in personal property
Hway_Real Amount of balance in the public right of way
Prvt_Real Amount of balance in private
Total_amt Total of highway and private


Contact us

If you require any further clarification, please contact a member of the Utility Reporting Unit:

Rebecca Bellard 518-530-4071
Lori Monell 518-530-4047
Jeremy Kergel 518-530-4049
Tony Moscatiello 518-530-4073
Yin Su 518-530-4070
Alan Kresge 518-530-4077
Updated: