1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
3 <base>CRM/Activity
</base>
4 <class>Activity
</class>
5 <name>civicrm_activity
</name>
6 <comment>Other Activity details stored here include contact, location, details.
</comment>
11 <uniqueName>activity_id
</uniqueName>
12 <title>Activity ID
</title>
14 <type>int unsigned
</type>
15 <required>true
</required>
16 <comment>Unique Other Activity ID
</comment>
21 <autoincrement>true
</autoincrement>
24 <name>source_contact_id
</name>
25 <type>int unsigned
</type>
26 <title>Source Contact
</title>
28 <headerPattern>/(activity.)?source(.contact(.id)?)?/i
</headerPattern>
29 <comment>Contact ID of the person scheduling or logging this Activity. Usually the authenticated user.
</comment>
34 <name>source_contact_id
</name>
35 <table>civicrm_contact
</table>
39 <onDelete>SET NULL
</onDelete>
42 <name>UI_source_contact_id
</name>
43 <fieldName>source_contact_id
</fieldName>
48 <name>source_record_id
</name>
49 <type>int unsigned
</type>
50 <title>Source Record
</title>
51 <comment>Artificial FK to original transaction (e.g. contribution) IF it is not an Activity. Table can be figured out through activity_type_id, and further through component registry.
</comment>
55 <name>UI_source_record_id
</name>
56 <fieldName>source_record_id
</fieldName>
60 <name>activity_type_id
</name>
61 <title>Activity Type ID
</title>
63 <type>int unsigned
</type>
64 <required>true
</required>
67 <headerPattern>/(activity.)?type(.id$)/i
</headerPattern>
68 <comment>FK to civicrm_option_value.id, that has to be valid, registered activity type.
</comment>
71 <optionGroupName>activity_type
</optionGroupName>
78 <name>UI_activity_type_id
</name>
79 <fieldName>activity_type_id
</fieldName>
83 <name>target_entity_table
</name>
86 <required>true
</required>
87 <comment>Name of table where item being referenced is stored.
</comment>
92 <name>target_entity_id
</name>
93 <type>int unsigned
</type>
94 <required>true
</required>
95 <comment>Foreign key to the referenced item.
</comment>
101 <uniqueName>activity_subject
</uniqueName>
103 <title>Subject
</title>
105 <comment>The subject/purpose/short description of the activity.
</comment>
106 <import>true
</import>
107 <headerPattern>/(activity.)?subject/i
</headerPattern>
115 <name>scheduled_date
</name>
116 <type>datetime
</type>
117 <comment>Date and time meeting is scheduled to occur.
</comment>
122 <name>activity_date_time
</name>
123 <import>true
</import>
124 <title>Activity Date
</title>
125 <type>datetime
</type>
126 <headerPattern>/(activity.)?date(.time$)?/i
</headerPattern>
127 <comment>Date and time this activity is scheduled to occur. Formerly named scheduled_date_time.
</comment>
129 <type>Select Date
</type>
130 <formatType>activityDateTime
</formatType>
135 <name>due_date_time
</name>
136 <type>datetime
</type>
137 <comment>Date and time this activity is due.
</comment>
142 <name>duration_hours
</name>
143 <type>int unsigned
</type>
144 <comment>Planned or actual duration of meeting - hours.
</comment>
149 <name>duration_minutes
</name>
150 <type>int unsigned
</type>
151 <comment>Planned or actual duration of meeting - minutes.
</comment>
156 <name>duration
</name>
157 <uniqueName>activity_duration
</uniqueName>
158 <title>Duration
</title>
159 <import>true
</import>
160 <type>int unsigned
</type>
161 <headerPattern>/(activity.)?duration(s)?$/i
</headerPattern>
162 <comment>Planned or actual duration of activity expressed in minutes. Conglomerate of former duration_hours and duration_minutes.
</comment>
169 <name>location
</name>
170 <uniqueName>activity_location
</uniqueName>
171 <title>Location
</title>
172 <import>true
</import>
175 <headerPattern>/(activity.)?location$/i
</headerPattern>
176 <comment>Location of the activity (optional, open text).
</comment>
183 <name>phone_id
</name>
184 <type>int unsigned
</type>
185 <title>Phone (called) ID
</title>
186 <comment>Phone ID of the number called (optional - used if an existing phone number is selected).
</comment>
189 <type>EntityRef
</type>
193 <name>phone_id
</name>
194 <table>civicrm_phone
</table>
197 <onDelete>SET NULL
</onDelete>
200 <name>phone_number
</name>
201 <title>Phone (called) Number
</title>
204 <comment>Phone number in case the number does not exist in the civicrm_phone table.
</comment>
212 <uniqueName>activity_details
</uniqueName>
213 <title>Details
</title>
214 <import>true
</import>
215 <type>longtext
</type>
216 <headerPattern>/(activity.)?detail(s)?$/i
</headerPattern>
217 <comment>Details about the activity (agenda, notes, etc).
</comment>
219 <type>RichTextEditor
</type>
228 <title>Status
</title>
229 <values>Scheduled, Completed
</values>
230 <comment>What is the status of this meeting? Completed meeting status results in activity history entry.
</comment>
235 <name>status_id
</name>
236 <uniqueName>activity_status_id
</uniqueName>
237 <title>Activity Status
</title>
238 <import>true
</import>
239 <export>false
</export>
240 <headerPattern>/(activity.)?status(.label$)?/i
</headerPattern>
241 <type>int unsigned
</type>
242 <comment>ID of the status this activity is currently in. Foreign key to civicrm_option_value.
</comment>
245 <optionGroupName>activity_status
</optionGroupName>
252 <name>priority_id
</name>
253 <type>int unsigned
</type>
254 <title>Priority
</title>
255 <comment>ID of the priority given to this activity. Foreign key to civicrm_option_value.
</comment>
258 <optionGroupName>priority
</optionGroupName>
265 <name>parent_id
</name>
266 <title>Parent Activity Id
</title>
267 <type>int unsigned
</type>
268 <comment>Parent meeting ID (if this is a follow-up item). This is not currently implemented
</comment>
272 <name>parent_id
</name>
273 <table>civicrm_activity
</table>
276 <onDelete>CASCADE
</onDelete>
281 <uniqueName>activity_is_test
</uniqueName>
284 <import>true
</import>
285 <headerPattern>/(is.)?test(.activity)?/i
</headerPattern>
292 <name>medium_id
</name>
293 <uniqueName>activity_medium_id
</uniqueName>
294 <title>Activity Medium
</title>
295 <type>int unsigned
</type>
296 <default>NULL
</default>
297 <comment>Activity Medium, Implicit FK to civicrm_option_value where option_group = encounter_medium.
</comment>
299 <optionGroupName>encounter_medium
</optionGroupName>
307 <name>index_medium_id
</name>
308 <fieldName>medium_id
</fieldName>
319 <name>relationship_id
</name>
320 <title>Relationship Id
</title>
321 <type>int unsigned
</type>
322 <default>NULL
</default>
323 <comment>FK to Relationship ID
</comment>
327 <name>relationship_id
</name>
328 <table>civicrm_relationship
</table>
330 <onDelete>SET NULL
</onDelete>
333 <name>is_current_revision
</name>
334 <title>Is this activity a current revision in versioning chain?
</title>
337 <import>true
</import>
338 <headerPattern>/(is.)?(current.)?(revision|version(ing)?)/i
</headerPattern>
341 <type>CheckBox
</type>
345 <name>index_is_current_revision
</name>
346 <fieldName>is_current_revision
</fieldName>
350 <name>original_id
</name>
351 <type>int unsigned
</type>
352 <title>Original Activity ID
</title>
353 <comment>Activity ID of the first activity record in versioning chain.
</comment>
357 <name>original_id
</name>
358 <table>civicrm_activity
</table>
361 <onDelete>CASCADE
</onDelete>
364 <name>UI_original_id
</name>
365 <fieldName>original_id
</fieldName>
371 <uniqueName>activity_result
</uniqueName>
373 <title>Result
</title>
375 <comment>Currently being used to store result id for survey activity, FK to option value.
</comment>
382 <name>is_deleted
</name>
383 <uniqueName>activity_is_deleted
</uniqueName>
384 <title>Activity is in the Trash
</title>
387 <import>true
</import>
388 <headerPattern>/(activity.)?(trash|deleted)/i
</headerPattern>
395 <name>index_is_deleted
</name>
396 <fieldName>is_deleted
</fieldName>
400 <name>campaign_id
</name>
401 <uniqueName>activity_campaign_id
</uniqueName>
402 <type>int unsigned
</type>
403 <title>Campaign
</title>
404 <import>true
</import>
405 <comment>The campaign for which this activity has been triggered.
</comment>
407 <table>civicrm_campaign
</table>
408 <keyColumn>id
</keyColumn>
409 <labelColumn>title
</labelColumn>
413 <type>CheckBox
</type>
417 <name>campaign_id
</name>
418 <table>civicrm_campaign
</table>
420 <onDelete>SET NULL
</onDelete>
423 <name>engagement_level
</name>
424 <uniqueName>activity_engagement_level
</uniqueName>
425 <type>int unsigned
</type>
426 <title>Engagement Index
</title>
427 <import>true
</import>
428 <comment>Assign a specific level of engagement to this activity. Used for tracking constituents in ladder of engagement.
</comment>
430 <optionGroupName>engagement_index
</optionGroupName>
448 <title>Is Starred
</title>
451 <import>true
</import>
452 <comment>Activity marked as favorite.
</comment>
453 <headerPattern>/(activity.)?(star|favorite)/i
</headerPattern>