OnlineRME Help System

Pump: Components & Inspection Detail Export

Owned by Former user (Deleted)
Oct 13, 2013
1 min read

  

This is a data export.  The data exported comes from pump data submitted for Tank Pump Reports.

All fields are optional, however based upon some selections, limits will be set on what data will be produced. For example, if you select:

You can only select Pump Report Data that is associated with the ATU.  If you select any other component questions, your results will be NULL.  Additionally, when you select PUMP Report Data - the Start and End dates are required.

Data Provided within the Export:

Component Export Only:

  1. Jurisdiction ID
  2. Component
  3. Component Type
  4. Property Address
  5. City
  6. County
  7. State
  8. Manufacturer
  9. Model
  10. Serial Number
  11. Property Owner
  12. Owner Mail Address
  13. Owner Mail City
  14. Owner Mail State
  15. Owner Mail Zip

Component Export with Pump Report Detail:

  1. Jurisdiction ID
  2. Component
  3. Component Type
  4. Property Address
  5. City
  6. County
  7. State
  8. Manufacturer
  9. Model
  10. Serial Number
  11. Question
  12. Answer (to Question)
  13. Deficient (0 = No, 1 = Yes)
  14. Pump ID (This is the report ID)
  15. Pump Date
  16. Lock Date
  17. System Status (Overall Status)
  18. Entity Name (Inspection Company)
  19. Property Owner
  20. Owner Mail Address
  21. Owner Mail City
  22. Owner Mail State
  23. Owner Mail Zip
  24. Component Inspection Status