1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
3 <base>CRM/Campaign
</base>
4 <class>Campaign
</class>
5 <name>civicrm_campaign
</name>
6 <comment>Campaign Details.
</comment>
11 <title>Campaign ID
</title>
12 <type>int unsigned
</type>
13 <required>true
</required>
14 <comment>Unique Campaign ID.
</comment>
20 <autoincrement>true
</autoincrement>
25 <title>Campaign Name
</title>
28 <required>true
</required>
29 <comment>Name of the Campaign.
</comment>
39 <title>Campaign Title
</title>
42 <comment>Title of the Campaign.
</comment>
51 <name>description
</name>
52 <title>Campaign Description
</title>
59 <comment>Full description of Campaign.
</comment>
64 <name>start_date
</name>
65 <title>Campaign Start Date
</title>
67 <headerPattern>/^start|(s(tart\s)?date)$/i
</headerPattern>
68 <comment>Date and time that Campaign starts.
</comment>
71 <type>Select Date
</type>
78 <title>Campaign End Date
</title>
80 <headerPattern>/^end|(e(nd\s)?date)$/i
</headerPattern>
81 <comment>Date and time that Campaign ends.
</comment>
84 <type>Select Date
</type>
90 <name>campaign_type_id
</name>
91 <title>Campaign Type
</title>
92 <type>int unsigned
</type>
93 <default>NULL
</default>
94 <comment>Campaign Type ID.Implicit FK to civicrm_option_value where option_group = campaign_type
</comment>
97 <optionGroupName>campaign_type
</optionGroupName>
105 <name>UI_campaign_type_id
</name>
106 <fieldName>campaign_type_id
</fieldName>
111 <name>status_id
</name>
112 <title>Campaign Status
</title>
113 <type>int unsigned
</type>
114 <default>NULL
</default>
115 <comment>Campaign status ID.Implicit FK to civicrm_option_value where option_group = campaign_status
</comment>
116 <import>true
</import>
118 <optionGroupName>campaign_status
</optionGroupName>
126 <name>UI_campaign_status_id
</name>
127 <fieldName>status_id
</fieldName>
132 <name>external_identifier
</name>
134 <title>Campaign External ID
</title>
136 <headerPattern>/external\s?id/i
</headerPattern>
137 <dataPattern>/^\d{
11,}$/
</dataPattern>
138 <comment>Unique trusted external ID (generally from a legacy app/datasource). Particularly useful for deduping operations.
</comment>
139 <import>true
</import>
146 <name>UI_external_identifier
</name>
147 <unique>true
</unique>
148 <fieldName>external_identifier
</fieldName>
153 <name>parent_id
</name>
154 <title>Parent Campaign
</title>
155 <type>int unsigned
</type>
156 <default>NULL
</default>
157 <comment>Optional parent id for this Campaign.
</comment>
158 <import>true
</import>
161 <type>Autocomplete-Select
</type>
165 <name>parent_id
</name>
166 <table>civicrm_campaign
</table>
169 <onDelete>SET NULL
</onDelete>
173 <name>is_active
</name>
174 <title>Is Campaign Active?
</title>
177 <comment>Is this Campaign enabled or disabled/cancelled?
</comment>
180 <type>CheckBox
</type>
185 <name>created_id
</name>
186 <type>int unsigned
</type>
187 <title>Campaign Created By
</title>
188 <comment>FK to civicrm_contact, who created this Campaign.
</comment>
192 <name>created_id
</name>
193 <table>civicrm_contact
</table>
196 <onDelete>SET NULL
</onDelete>
200 <name>created_date
</name>
201 <type>datetime
</type>
202 <title>Campaign Created Date
</title>
203 <comment>Date and time that Campaign was created.
</comment>
206 <type>Select Date
</type>
211 <name>last_modified_id
</name>
212 <type>int unsigned
</type>
213 <title>Campaign Modified By
</title>
214 <comment>FK to civicrm_contact, who recently edited this Campaign.
</comment>
218 <name>last_modified_id
</name>
219 <table>civicrm_contact
</table>
222 <onDelete>SET NULL
</onDelete>
226 <name>last_modified_date
</name>
227 <type>datetime
</type>
228 <title>Campaign Modified Date
</title>
229 <comment>Date and time that Campaign was edited last time.
</comment>
233 <name>goal_general
</name>
235 <title>Campaign Goals
</title>
236 <comment>General goals for Campaign.
</comment>
239 <type>RichTextEditor
</type>
243 <name>goal_revenue
</name>
245 <comment>The target revenue for this campaign.
</comment>