You can use these blocking conditions with activities.
Activity Status Blocking Condition
Activity Status |
|
Condition name |
[appt_status] |
Condition type |
Activity |
Description |
Checks activity status |
Valid values/format |
started , completed , suspended , etc. |
Case sensitive? |
No |
Suggested functions |
IN , NOT IN |
Customer Number Blocking Condition
Account Number |
|
Condition name |
[customer_number] |
Condition type |
Activity |
Description |
Checks the account number |
Valid values/format |
text |
Activity Type Blocking Condition
Activity Type |
|
Condition name |
[appt_type] |
Condition type |
Activity |
Description |
Checks the activity type |
Valid values/format |
regular , reopened , prework ,
multiday_activity , multiday_activity_segment |
Case sensitive? |
No |
Suggested functions |
IN , NOT IN |
Activity Time of Assignment blocking condition
Activity Time of Assignment |
|
Condition name |
[atime_of_assignment] |
Condition type |
Activity |
Description |
Checks the time the activity is assigned in the time zone of
the assigned resource. |
Valid values/format |
YYYY-MM-DD HH24:MI:SS |
Suggested functions |
IS NULL , IS NOT NULL , CONTAINS , DOESN'T CONTAIN , < , > |
Example 1 |
Condition: 'Time of assignment' CONTAINS '2012-05-21' Result: Blocks all activities that were assigned during '2012-05-21' |
Example 2 |
Condition: 'Time of assignment' < '2012-05-21' Result: Blocks all activities that were
assigned before '2012-05-21' |
Activity Time of Booking Blocking Condition
Activity Time of Booking |
|
Condition name |
[atime_of_booking] |
Condition type |
Activity |
Description |
Checks the time the activity is booked in the time zone of
the assigned resource. |
Valid values/format |
YYYY-MM-DD , HH24:MI:SS |
Suggested functions |
IS NULL , IS NOT NULL , CONTAINS , DOESN'T CONTAIN , < , > |
Example 1 |
Condition: 'Time of booking' CONTAINS '2012-05-21' Result: Blocks all activities that were booked
during '2012-05-21' |
Example 2 |
Condition: 'Time of booking' < '2012-05-21' Result: Blocks all activities
that were booked before '2012-05-21' |
Activity Work Type Blocking Condition
Activity Type |
|
Condition name |
[aworktype] |
Condition type |
Activity |
Description |
Checks the activity work type |
Valid values/format |
Activity type IDs |
Notes |
This condition can be used with both activity types and their
groups. |
Address Blocking Condition
Address |
|
Condition name |
[caddress] |
Condition type |
Activity |
Description |
Checks the activity address |
Valid values/format |
text |
Calendar Days from Activity Assignment blocking condition
Calendar Days from Activity Assignment |
|
Condition name |
[calendar_days_from_activity_assignment] |
Condition type |
Activity |
Description |
Calculated as the number of calendar days from the activity
assignment date to the current date of the resource. |
Valid values/format |
integer >= 0 |
Suggested functions |
IN , NOT IN , < , > , <= , >= |
Example 1 |
Condition: 'Calendar days from activity assignment'
<= 1 Result: Blocks all activities
that were assigned yesterday (1) or today (0) . |
Notes |
Both dates have the same time zone difference. |
Calendar Days from Activity Booking blocking condition
Calendar Days from Activity Booking |
|
Condition name |
[calendar_days_from_activity_booking] |
Condition type |
Activity |
Description |
Calculated as the number of calendar days from the activity
booking date to the current date of the resource the activity is assigned
to. |
Valid values/format |
integer >= 0 |
Suggested functions |
IN , NOT IN , < , > , <= , >= |
Example 1 |
Condition: 'Calendar days from activity booking'
<= 1 Result: Blocks all activities that were booked or created yesterday
(1) or today (0) . |
Notes |
Both dates have the same time zone difference. |
Capacity Categories blocking condition
Capacity Categories |
|
Condition name |
[activity_capacity_categories] |
Condition type |
Activity |
Description |
Selects activities that belong to the given capacity category. |
Valid values/format |
Capacity category IDs |
Suggested functions |
IN - the activity belongs to all provided
categories. NOT IN - the activity belongs to none
of the categories provided in the list. |
Notes |
The same rules apply as in Quota Management. |
City blocking condition
City |
|
Condition name |
[ccity] |
Condition type |
Activity |
Description |
Checks the city of the activity location. |
Valid values/format |
text |
Coordinate Status blocking condition
Coordinate Status |
|
Condition name |
[acoord_status] |
Condition type |
Activity |
Description |
Checks whether or not the current activity coordinates were
found |
Valid values/format |
found , not_found , invalid |
Coordinate X blocking condition
Coordinate X |
|
Condition name |
[acoord_x] |
Condition type |
Activity |
Description |
Checks the longitude of the activity location |
Valid values/format |
A longitude value, such as 37.40562 or -79.42639 |
Coordinate Y blocking condition
Coordinate Y |
|
Condition name |
[acoord_y] |
Condition type |
Activity |
Description |
Checks the latitude of the activity location |
Valid values/format |
A latitude value, such as 22.831438 |
Days from Activity Assignment blocking condition
Days from Activity Assignment |
|
Condition name |
[days_from_activity_assignment] |
Condition type |
Activity |
Description |
The number of full days elapsed between the time the activity
was assigned and the current time. |
Valid values/format |
integer >= 0 |
Suggested functions |
IN , NOT IN , < , > , <= , >= |
Example |
Condition: 'Days from activity assignment' =
0 Result: Blocks all activities assigned within the
last 24 hours. If the current time is '2012-09-27 08:28:22 ', the condition will return the activity that was assigned on '2012-09-26 19:17:00 '. |
Days from Activity Booking blocking condition
Days from Activity Booking |
|
Condition name |
[days_from_activity_booking] |
Condition type |
Activity |
Description |
The number of full days elapsed between the time the activity
was booked and the current time. |
Valid values/format |
integer >= 0 |
Suggested functions |
IN , NOT IN , < , > , <= , >= |
Example |
Condition: 'Days from activity booking' = 0
Result: Blocks all activities booked within
the last 24 hours. If the current time is '2012-09-27
08:28:22 ', the condition will return the activity
that was booked on '2012-09-26 19:17:00 '. |
Days to Activity blocking condition
Days to Activity |
|
Condition name |
[days_to_appt] |
Condition type |
Activity |
Description |
Returns the number of days from the message creation to the
activity. |
Valid values/format |
integer >= 0 |
Suggested functions |
IN , NOT IN |
Activity Scheduled? blocking condition
Activity Scheduled? |
|
Condition name |
[is_activity_scheduled] |
Condition type |
Activity |
Description |
Checks if the activity is scheduled |
Valid values/format |
1 or <empty> |
Suggested functions |
IS NULL , IS NOT NULL |
Notes |
This condition cannot be used in the cancel activity scenario. This constraint is related to the two-phase nature of
the Cancel non-scheduled activity action.This action
consists of two steps: 1. Making the activity scheduled (moving it to the current day). 2. Performing thecancel action. According to this scenario, the launch condition is invoked
when the activity is already scheduled . Therefore,
the condition is always false . |
Message Language blocking condition
Message Language |
|
Condition name |
[clanguage] |
Condition type |
Activity |
Description |
Checks the language of the message to be sent to the customer |
Valid values/format |
Language IDs |
Suggested functions |
IS NULL , IS NOT NULL |
Notes |
This condition is true for both segmentable activities and
individual segments which can be distinguished by the value of the Type field. For segmentable activities the Type value is multiday_activity , while for segments
it is multiday_activity_segments . |
Customer Name blocking condition
Name |
|
Condition name |
[cname] |
Condition type |
Activity |
Description |
Checks the customer name |
Valid values/format |
text |
Not Ordered Activity blocking condition
Not Ordered Activity |
|
Condition name |
[all_day_flag] |
Condition type |
Activity |
Description |
Checks if the activity is not ordered |
Valid values/format |
1 or <empty> |
Suggested functions |
IS NULL , IS NOT NULL |
Pending Activity Order blocking condition
Pending Activity Order |
|
Condition name |
[pending_activity_order] |
Condition type |
Activity |
Description |
Checks the offset of a pending activity from the start of the
route to which this activity belongs |
Valid values/format |
integer >= -1 |
Suggested functions |
IN , NOT IN , < , > , <= , >= |
Example |
Condition: 'Pending activity order' = 1 Result: Blocks the first pending activity in the route. |
Notes |
The following logic applies:– "1..." pending ordered activity
in the route (offset from the route start)– "1" pending ordered in
the bucket– "1" pending ordered non-scheduled activity– "-1" pending
not ordered activity– "0" started, completed, canceled, notdone, suspended
activity |
Phone blocking condition
Phone |
|
Condition name |
[phone] |
Condition type |
Activity |
Description |
Checks the customer's phone number |
Valid values/format |
text |
Notes |
Takes into account whether the contact can be used with messages. |
Email Address blocking condition
Email Address |
|
Condition name |
[email] |
Condition type |
Activity |
Description |
Checks the customer's email address |
Valid values/format |
text |
Notes |
Takes into account whether the contact can be used with messages. |
Cellular Phone blocking condition
Cellular Phone |
|
Condition name |
[cell] |
Condition type |
Activity |
Description |
Checks the customer's cell phone number |
Valid values/format |
text |
Notes |
Takes into account whether the contact can be used with messages. |
Points blocking condition
Points |
|
Condition name |
[apoints] |
Condition type |
Activity |
Description |
Checks the number of points assigned to the activity |
Valid values/format |
integer |
Position in Route blocking condition
Position in Route |
|
Condition name |
[position_in_route] |
Condition type |
Activity |
Description |
Checks the activity position in the route |
Valid values/format |
integer |
Reminder blocking condition
Reminder |
|
Condition name |
[cmessagetime] |
Condition type |
Activity |
Description |
Checks the number of minutes before the Notification
base when reminder notification is to be generated |
Valid values/format |
integer |
SLA Start blocking condition
SLA Start |
|
Condition name |
[sla_window_start] |
Condition type |
Activity |
Description |
Checks the start of the activity SLA window |
Valid values/format |
YYYY-MM-DD , HH24:MI:SS |
SLA End blocking condition
SLA End |
|
Condition name |
[sla_window_end] |
Condition type |
Activity |
Description |
Checks the end of the activity SLA window |
Valid values/format |
YYYY-MM-DD , HH24:MI:SS |
Service Window End blocking condition
Service Window End |
|
Condition name |
[service_window_end] |
Condition type |
Activity |
Description |
Checks the end of the activity service window |
Valid values/format |
HH24:MI |
Service Window Start blocking condition
Service Window Start |
|
Condition name |
[service_window_start] |
Condition type |
Activity |
Description |
Checks the start of the activity service window |
Valid values/format |
HH24:MI |
Start blocking condition
Start |
|
Condition name |
[eta] |
Condition type |
Activity |
Description |
Checks if the activity has an ETA |
Valid values/format |
HH24:MI:SS |
Suggested functions |
IS NULL , IS NOT NULL |
State blocking condition
State |
|
Condition name |
[state] |
Condition type |
Activity |
Description |
Checks the area name of the activity (state, county, land,
etc.) |
Valid values/format |
text |
Time Slot blocking condition
Time Slot |
|
Condition name |
[time_slot] |
Condition type |
Activity |
Description |
Checks the label of the activity time slot |
Time Zone blocking condition
Time Zone |
|
Condition name |
[c_zid] |
Condition type |
Activity |
Description |
Checks the activity time zone |
Valid values/format |
Time zone IDs |
Time Notified blocking condition
Time Notified |
|
Condition name |
[time_delivered] |
Condition type |
Activity |
Description |
Checks the start time of arrival interval communicated to the
customer |
Valid values/format |
HH24:MI |
Suggested functions |
IS NULL , IS NOT NULL |
Notes |
This condition works both for a single activity and a visit.
If the message is based on a visit, it refers to the visit's field
instead of the activity's field. |
Travel Area blocking condition
Travel Area |
|
Condition name |
[atravelarea] |
Condition type |
Activity |
Description |
Checks the activity travel area |
Valid values/format |
Travel area IDs |
Traveling Time blocking condition
Traveling Time |
|
Condition name |
[travel] |
Condition type |
Activity |
Description |
Checks the travel time from the previous activity/location
to the current activity |
Valid values/format |
integer |
Work Order blocking condition
Work Order |
|
Condition name |
[appt_number] |
Condition type |
Activity |
Description |
Checks the activity work skills |
Valid values/format |
Work skill IDs |
Suggested functions |
IS NULL - The activity doesn't require any
work skills. IS NOT NULL - The activity requires
at least one work skill. IN - The activity requires
all the provided work skills. NOT IN - The activity
requires none of the provided work skills. |
Example 1 |
Activity #1 work skills: Install IPTV (1) , English (10) Activity #2 work skills: Install IPTV (1), Spanish (11) Condition: Activity work skill IN (1) R |
Example 2 |
Condition: Activity work skill IN (1, 10) Condition: Activity work skill NOT IN (1,10 Result: <NONE> |
Notes |
Groups of work skills are also supported. In this case a group
is handled as any work skill it includes. |
ZIP/Postal Code blocking condition
ZIP/Postal Code |
|
Condition name |
[czip] |
Condition type |
Activity |
Description |
Checks ZIP (postal code) |
Valid values/format |
text |
Time Delivered End blocking condition
Time Delivered End |
|
Condition name |
[ctime_delivered_end] |
Condition type |
Activity |
Description |
Checks the end time of arrival interval communicated to the
customer |
Valid values/format |
YYYY-MM-DD , HH24:MI:SS |
Suggested functions |
IS NULL , IS NOT NULL |
Time Delivered Start blocking condition
Time Delivered Start |
|
Condition name |
[ctime_delivered_start] |
Condition type |
Activity |
Description |
Checks the start time of arrival interval communicated to the
customer |
Valid values/format |
YYYY-MM-DD , HH24:MI:SS |
Suggested functions |
IS NULL , IS NOT NULL |
Delivery Window End blocking condition
Delivery Window End |
|
Condition name |
[delivery_window_end] |
Condition type |
Activity |
Description |
Checks the delivery window end |
Valid values/format |
HH24:MI:SS |
Delivery Window Start blocking condition
Delivery Window Start |
|
Condition name |
[delivery_window_start] |
Condition type |
Activity |
Description |
Checks the delivery window start |
Valid values/format |
HH24:MI:SS |