/
OSS: Components & Inspection Detail Export

OnlineRME Help System

OSS: Components & Inspection Detail Export

Oct 13, 2013

This is a data export.  The data exported comes from inspection data submitted for Septic Inspections.

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 OSS Inspection Report Data that is associated with the ATU.  If you select any other component questions, your results will be NULL.  Additionally, when you select OSS Inspection 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 Inspection 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. Master ID (This is the report ID)

  15. Inspection 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