2014-1Q: (v001): SAND: Display SAND Status on Subscriber Record

Two updates have been made in the SIMPLer system to the display of customer SAND status.

1) Updates to Subscriber Record:

The following updates have been made to display of "SAND status" on a subscriber record:

a) The "status" field on a subscriber record will now show SAND status i.e an indication of whether or not a customer is under the notifying/throttling/disconnection/automated topups process as a result of Subscribe Auto Notify/Disconnect. See fig. 1 for location of SAND status.

Fig. 1: SAND Status Display


The following terms may appear on the SAND status field:
  • SAND: Clear: The customer is not under any SAND processes at the moment.
  • SAND Invoice: Notified: The customer has past due invoices and has been notified by email once or more than once that this is the case.  The customer has not yet been disconnected.
  • SAND Invoice: Throttled: The customer has past due invoices and is now receiving limited speeds.
  • SAND Invoice: Disconnected: The customer has past due invoices and has been disconnected for this reason. 
  • SAND Lodgement: Notified: The customer has a failed payment and has been notified by email once or more than once that this is the case.  The customer has not yet been disconnected.
  • SAND Lodgement: Disconnected: The customer has a failed payment and has been disconnected for this reason.
  • SAND Traffic: Notified: The customer has exceeded their assigned traffic limit and has received email notifications to explain that this is the case.
  • SAND Traffic: Overage: The customer has exceeded their assigned traffic limit and has received an automatic overage topup.
  • SAND Traffic: Throttled: The customer has exceeded their assigned traffic limit and is now receiving limited speeds.
  • SAND Traffic: Disconnected: The customer has exceeded their assigned traffic limit and has been disconnected. 
b) If you need more details on the status of notifications/disconnections you can hover over the SAND status and see a box detailing the processes underway as per fig. 2.

Fig. 2: Notification/disconnection Details

If a process is clear (i.e notifications have not been sent out/ disconnection has not been executed) the dots will show in GREEN.

If a process is underway (i.e notifications have been sent/customers have been disconnected) the dots will show in RED.

In the case of Fig. 2, the customer has received their first notification that their invoice is past due, but the remaining processes are clear.

2) Updates to SEPA EFT Debits Page:

The following updates have been made to the SEPA EFT Debits page (i.e the page where files are created to upload to European banks for Direct Debit payments)

a) Customer SAND status is displayed as per fig. 3.


Fig. 3: SEPA EFT Debits Page - display of SAND status.


To see more details hover over the status as per fig. 4. In this case, the customer has been notified and disconnected for lodgement failure.

Fig. 4: Hover over SAND status.


b) There is now the ability to filter customers on the SEPA EFT Debits page by their SAND status.  i.e you can now exclude any customers "under SAND" from the Direct Debit run if desired.  See fig. 5.

Fig. 5: Filter by SAND status.


  • All: See on the list all customers regardless of SAND status.
  • Under SAND: Display ONLY customers who have been notified/throttled/disconnected/received an automatic overage topup.
  • Clear: Display ONLY customers who are not under ANY part of the SAND process: (i.e notified/throttled/disconnected/received an automatic overage topup.)



Azotel | River House | Blackpool Park | Cork | Ireland
US +1-312-239-0680 | IE +353-21-234-8100 | UK +44-207-193-4170 | SA +27-11-083-6900
Comments