Sump Pump Status Logic

The Sump Pump Status indicates whether or not the building sump is connected to the sewer system. A status set to Negative is a building sump that is not connected to sewer system, Positive is a sump building that is connected, and Suspect is a building that may or may not be connected. 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 or 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 above logic 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.