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.