1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
5 <class>ActionSchedule
</class>
6 <name>civicrm_action_schedule
</name>
7 <comment>Table to store the reminders.
</comment>
11 <title>Action Schedule ID
</title>
12 <type>int unsigned
</type>
13 <required>true
</required>
21 <autoincrement>true
</autoincrement>
28 <comment>Name of the action(reminder)
</comment>
36 <comment>Title of the action(reminder)
</comment>
40 <name>recipient
</name>
43 <comment>Recipient
</comment>
45 <label>Recipient
</label>
52 <comment>Is this the recipient criteria limited to OR in addition to?
</comment>
54 <label>Limit To
</label>
57 <required>true
</required>
61 <name>entity_value
</name>
64 <comment>Entity value
</comment>
65 <serialize>SEPARATOR_TRIMMED
</serialize>
67 <label>Entity value
</label>
72 <name>entity_status
</name>
75 <comment>Entity status
</comment>
76 <serialize>SEPARATOR_TRIMMED
</serialize>
78 <label>Entity Status
</label>
83 <name>start_action_offset
</name>
84 <type>int unsigned
</type>
85 <comment>Reminder Interval.
</comment>
88 <label>Start Action Offset
</label>
93 <name>start_action_unit
</name>
96 <comment>Time units for reminder.
</comment>
98 <callback>CRM_Core_SelectValues::getRecurringFrequencyUnits
</callback>
103 <label>Start Action Unit
</label>
107 <name>start_action_condition
</name>
110 <comment>Reminder Action
</comment>
112 <label>Start Action condition
</label>
117 <name>start_action_date
</name>
120 <comment>Entity date
</comment>
122 <label>Start Action Date
</label>
127 <name>is_repeat
</name>
128 <title>Repeat?
</title>
131 <required>true
</required>
135 <name>repetition_frequency_unit
</name>
138 <comment>Time units for repetition of reminder.
</comment>
140 <callback>CRM_Core_SelectValues::getRecurringFrequencyUnits
</callback>
145 <label>Repetition Frequency Unit
</label>
149 <name>repetition_frequency_interval
</name>
150 <type>int unsigned
</type>
152 <comment>Time interval for repeating the reminder.
</comment>
154 <label>Repetition Frequency Interval
</label>
159 <name>end_frequency_unit
</name>
162 <comment>Time units till repetition of reminder.
</comment>
164 <callback>CRM_Core_SelectValues::getRecurringFrequencyUnits
</callback>
169 <label>End Frequency Unit
</label>
173 <name>end_frequency_interval
</name>
174 <type>int unsigned
</type>
175 <comment>Time interval till repeating the reminder.
</comment>
177 <label>End Frequency Interval
</label>
183 <name>end_action
</name>
186 <comment>Reminder Action till repeating the reminder.
</comment>
188 <label>End Action
</label>
193 <name>end_date
</name>
196 <comment>Entity end date
</comment>
198 <label>End Date
</label>
203 <name>is_active
</name>
204 <title>Schedule is Active?
</title>
207 <required>true
</required>
208 <comment>Is this option active?
</comment>
212 <name>recipient_manual
</name>
213 <title>Recipient Manual
</title>
216 <comment>Contact IDs to which reminder should be sent.
</comment>
217 <serialize>COMMA
</serialize>
221 <name>recipient_listing
</name>
222 <title>Recipient Listing
</title>
225 <comment>listing based on recipient field.
</comment>
229 <name>body_text
</name>
230 <title>Reminder Text
</title>
231 <type>longtext
</type>
232 <comment>Body of the mailing in text format.
</comment>
236 <name>body_html
</name>
237 <title>Reminder HTML
</title>
238 <type>longtext
</type>
239 <comment>Body of the mailing in html format.
</comment>
243 <name>sms_body_text
</name>
244 <title>SMS Reminder Text
</title>
245 <type>longtext
</type>
246 <comment>Content of the SMS text.
</comment>
251 <title>Reminder Subject
</title>
254 <comment>Subject of mailing
</comment>
258 <name>record_activity
</name>
259 <title>Record Activity for Reminder?
</title>
262 <required>true
</required>
263 <comment>Record Activity for this reminder?
</comment>
267 <name>mapping_id
</name>
268 <title>Reminder Mapping
</title>
271 <comment>Name/ID of the mapping to use on this table
</comment>
275 <name>group_id
</name>
276 <title>Group ID
</title>
277 <type>int unsigned
</type>
278 <comment>FK to Group
</comment>
280 <table>civicrm_group
</table>
281 <keyColumn>id
</keyColumn>
282 <labelColumn>title
</labelColumn>
291 <name>group_id
</name>
292 <table>civicrm_group
</table>
294 <onDelete>SET NULL
</onDelete>
297 <name>msg_template_id
</name>
298 <title>Message Template ID
</title>
299 <type>int unsigned
</type>
300 <comment>FK to the message template.
</comment>
302 <label>Message Template
</label>
306 <name>msg_template_id
</name>
307 <table>civicrm_msg_template
</table>
309 <onDelete>SET NULL
</onDelete>
312 <name>sms_template_id
</name>
313 <title>SMS Template ID
</title>
314 <type>int unsigned
</type>
315 <comment>FK to the message template.
</comment>
317 <label>SMS Template
</label>
321 <name>sms_template_id
</name>
322 <table>civicrm_msg_template
</table>
324 <onDelete>SET NULL
</onDelete>
327 <name>absolute_date
</name>
328 <title>Fixed Date for Reminder
</title>
330 <comment>Date on which the reminder be sent.
</comment>
334 <name>from_name
</name>
335 <title>Reminder from Name
</title>
338 <comment>Name in
"from" field
</comment>
342 <name>from_email
</name>
343 <title>Reminder From Email
</title>
346 <comment>Email address in
"from" field
</comment>
351 <title>Message Mode
</title>
352 <default>"Email"</default>
355 <comment>Send the message as email or sms or both.
</comment>
357 <optionGroupName>msg_mode
</optionGroupName>
365 <name>sms_provider_id
</name>
366 <title>SMS Provider ID
</title>
367 <type>int unsigned
</type>
371 <label>SMS Provider
</label>
375 <name>sms_provider_id
</name>
376 <table>civicrm_sms_provider
</table>
378 <onDelete>SET NULL
</onDelete>
382 <name>used_for
</name>
385 <comment>Used for repeating entity
</comment>
387 <label>Used For
</label>
392 <name>filter_contact_language
</name>
395 <comment>Used for multilingual installation
</comment>
397 <label>Filter Contact Language
</label>
402 <name>communication_language
</name>
405 <comment>Used for multilingual installation
</comment>
407 <label>Communication Language
</label>
412 <name>created_date
</name>
413 <title>Created Date
</title>
414 <uniqueName>action_schedule_created_date
</uniqueName>
415 <type>timestamp
</type>
416 <comment>When was the scheduled reminder created.
</comment>
417 <required>false
</required>
418 <export>true
</export>
419 <default>CURRENT_TIMESTAMP
</default>
423 <name>modified_date
</name>
424 <type>timestamp
</type>
425 <comment>When the reminder was created or modified.
</comment>
426 <required>false
</required>
427 <default>CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
</default>
429 <label>Modified Date
</label>
432 <readonly>true
</readonly>
435 <name>effective_start_date
</name>
436 <title>Effective start date
</title>
437 <uniqueName>action_schedule_effective_start_date
</uniqueName>
438 <type>timestamp
</type>
439 <comment>Earliest date to consider start events from.
</comment>
440 <required>false
</required>
441 <export>true
</export>
445 <name>effective_end_date
</name>
446 <title>Effective end date
</title>
447 <uniqueName>action_schedule_effective_end_date
</uniqueName>
448 <type>timestamp
</type>
449 <comment>Latest date to consider end events from.
</comment>
450 <required>false
</required>
451 <export>true
</export>