1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
5 <name>civicrm_grant
</name>
6 <comment>This table stores information about grants given to a contact.
</comment>
11 <type>int unsigned
</type>
12 <uniqueName>grant_id
</uniqueName>
13 <title>Grant ID
</title>
14 <required>true
</required>
15 <comment>Unique Grant id
</comment>
21 <autoincrement>true
</autoincrement>
24 <name>contact_id
</name>
25 <type>int unsigned
</type>
26 <uniqueName>grant_contact_id
</uniqueName>
27 <title>Contact ID
</title>
29 <required>true
</required>
30 <comment>Contact ID of contact record given grant belongs to.
</comment>
33 <type>EntityRef
</type>
37 <name>contact_id
</name>
38 <table>civicrm_contact
</table>
41 <onDelete>CASCADE
</onDelete>
44 <name>application_received_date
</name>
45 <title>Application received date
</title>
49 <comment>Date on which grant application was received by donor.
</comment>
52 <type>Select Date
</type>
53 <formatType>activityDate
</formatType>
57 <name>decision_date
</name>
58 <title>Decision date
</title>
60 <comment>Date on which grant decision was made.
</comment>
64 <type>Select Date
</type>
65 <formatType>activityDate
</formatType>
69 <name>money_transfer_date
</name>
70 <uniqueName>grant_money_transfer_date
</uniqueName>
71 <title>Grant Money transfer date
</title>
73 <comment>Date on which grant money transfer was made.
</comment>
77 <type>Select Date
</type>
78 <formatType>activityDate
</formatType>
82 <name>grant_due_date
</name>
84 <title>Grant Due Date
</title>
85 <comment>Date on which grant report is due.
</comment>
89 <type>Select Date
</type>
90 <formatType>activityDate
</formatType>
94 <name>grant_report_received
</name>
95 <title>Grant report received
</title>
97 <comment>Yes/No field stating whether grant report was received by donor.
</comment>
101 <type>CheckBox
</type>
105 <name>grant_type_id
</name>
106 <type>int unsigned
</type>
107 <title>Grant Type
</title>
109 <optionGroupName>grant_type
</optionGroupName>
114 <export>true
</export>
115 <required>true
</required>
116 <comment>Type of grant. Implicit FK to civicrm_option_value in grant_type option_group.
</comment>
120 <name>index_grant_type_id
</name>
121 <fieldName>grant_type_id
</fieldName>
125 <name>amount_total
</name>
126 <title>Total Amount
</title>
128 <required>true
</required>
129 <dataPattern>/^\d+(\.\d{
2})?$/
</dataPattern>
130 <import>true
</import>
131 <comment>Requested grant amount, in default currency.
</comment>
138 <name>amount_requested
</name>
139 <title>Amount Requested
</title>
141 <dataPattern>/^\d+(\.\d{
2})?$/
</dataPattern>
142 <comment>Requested grant amount, in original currency (optional).
</comment>
149 <name>amount_granted
</name>
150 <title>Amount granted
</title>
152 <dataPattern>/^\d+(\.\d{
2})?$/
</dataPattern>
153 <import>true
</import>
154 <comment>Granted amount, in default currency.
</comment>
161 <name>currency
</name>
162 <title>Grant Currency
</title>
165 <required>true
</required>
166 <comment>3 character string, value from config setting or input via user.
</comment>
169 <table>civicrm_currency
</table>
170 <keyColumn>name
</keyColumn>
171 <labelColumn>full_name
</labelColumn>
172 <nameColumn>name
</nameColumn>
179 <name>currency
</name>
182 <default>NULL
</default>
183 <comment>3 character string, value from config setting or input via user.
</comment>
188 <name>rationale
</name>
190 <title>Grant Rationale
</title>
191 <comment>Grant rationale.
</comment>
193 <type>TextArea
</type>
197 <import>true
</import>
201 <name>status_id
</name>
202 <type>int unsigned
</type>
203 <title>Grant Status
</title>
204 <uniqueName>grant_status_id
</uniqueName>
205 <required>true
</required>
206 <import>true
</import>
207 <export>false
</export>
208 <comment>Id of Grant status.
</comment>
210 <optionGroupName>grant_status
</optionGroupName>
218 <name>index_status_id
</name>
219 <fieldName>status_id
</fieldName>
223 <name>financial_type_id
</name>
224 <title>Financial Type
</title>
225 <type>int unsigned
</type>
226 <default>NULL
</default>
228 <table>civicrm_financial_type
</table>
229 <keyColumn>id
</keyColumn>
230 <labelColumn>name
</labelColumn>
232 <comment>FK to Financial Type.
</comment>
236 <name>financial_type_id
</name>
237 <table>civicrm_financial_type
</table>
239 <onDelete>SET NULL
</onDelete>