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 email the Utility Reporting Unit.
Page last reviewed or updated: