Sump Pump Status Logic

The Sump Pump Status indicates whether or not the building sump is connected to the sewer system.

• A "Negative" status indicates a building sump that is not connected to sewer system,
• A "Positive" status is a sump building that is connected to a sewer system.
• A "Suspect" status is a building that may or may not be connected to a sewer system.

The logic used to calculate the Sump Status is as follows:

1. If Sump Pit Type = Sanitary (code type 1), and
   1. If Sump Pit Sealed = No, set the Status = Positive
   2. If Sump Pit Sealed= Unknown, set the Status = Suspect
   3. If neither a nor b are true, set Status = Negative
2. If Sump Pit type = Storm (code type 2), and
   1. If Discharge Point = Sanitary Sewer, set Status = Positive
   2. If Sump Pit Drain = No, set Status = Positive
   3. If Diverter Valve = Yes, set Status = Positive
   4. If Discharge Point = Sump Drain, set Status = Suspect
   5. If Sump Pit Drain = Unknown, set Status = Suspect
   6. If Diverter Valve = Unknown, set Status = Suspect
3. If Sump Pit Type = Combination (code type 3), and
   1. If Discharge Point = Sanitary Sewer, set Status = Positive
   2. If Sump Pit Drain = No, set Status = Positive
   3. If Diverter Valve = Yes, set Status = Positive
   4. If Discharge Point = Sump Drain, set Status = Suspect
   5. If Sump Pit Drain = Unknown, set Status = Suspect
   6. If Diverter Valve = Unknown, set Status = Suspect
4. If Sump Pit Type = Unknown (code type 4), and
   1. If Sump Pit Drain = Yes or Unknown, set Status = Suspect
   2. If Discharge Point = Sanitary Sewer or Unknown, set Status = Suspect
   3. If Diverter Valve = Yes or Unknown, set Status = Suspect
5. If the Status = 0, no other matches were found, set Status = Negative

   Note: All of the logic above is based on field codes and not text fields. If any of your codes have been modified from the original codes set by Lucity™, this logic will not work.