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>
12 <type>int unsigned
</type>
13 <uniqueName>grant_id
</uniqueName>
14 <title>Grant ID
</title>
15 <required>true
</required>
16 <comment>Unique Grant id
</comment>
22 <autoincrement>true
</autoincrement>
25 <name>contact_id
</name>
26 <type>int unsigned
</type>
27 <uniqueName>grant_contact_id
</uniqueName>
28 <title>Contact ID
</title>
30 <required>true
</required>
31 <comment>Contact ID of contact record given grant belongs to.
</comment>
34 <type>EntityRef
</type>
38 <name>contact_id
</name>
39 <table>civicrm_contact
</table>
42 <onDelete>CASCADE
</onDelete>
45 <name>application_received_date
</name>
46 <title>Application received date
</title>
47 <uniqueName>grant_application_received_date
</uniqueName>
51 <comment>Date on which grant application was received by donor.
</comment>
54 <type>Select Date
</type>
55 <formatType>activityDate
</formatType>
59 <name>decision_date
</name>
60 <title>Decision date
</title>
61 <uniqueName>grant_decision_date
</uniqueName>
63 <comment>Date on which grant decision was made.
</comment>
67 <type>Select Date
</type>
68 <formatType>activityDate
</formatType>
72 <name>money_transfer_date
</name>
73 <uniqueName>grant_money_transfer_date
</uniqueName>
74 <title>Grant Money transfer date
</title>
76 <comment>Date on which grant money transfer was made.
</comment>
80 <type>Select Date
</type>
81 <formatType>activityDate
</formatType>
85 <name>grant_due_date
</name>
87 <title>Grant Report Due Date
</title>
88 <comment>Date on which grant report is due.
</comment>
92 <type>Select Date
</type>
93 <formatType>activityDate
</formatType>
97 <name>grant_report_received
</name>
98 <title>Grant report received
</title>
100 <comment>Yes/No field stating whether grant report was received by donor.
</comment>
101 <import>true
</import>
104 <type>CheckBox
</type>
108 <name>grant_type_id
</name>
109 <type>int unsigned
</type>
110 <title>Grant Type
</title>
112 <optionGroupName>grant_type
</optionGroupName>
117 <export>true
</export>
118 <required>true
</required>
119 <comment>Type of grant. Implicit FK to civicrm_option_value in grant_type option_group.
</comment>
123 <name>index_grant_type_id
</name>
124 <fieldName>grant_type_id
</fieldName>
128 <name>amount_total
</name>
129 <title>Total Amount
</title>
131 <required>true
</required>
132 <dataPattern>/^\d+(\.\d{
2})?$/
</dataPattern>
133 <import>true
</import>
134 <comment>Requested grant amount, in default currency.
</comment>
141 <name>amount_requested
</name>
142 <title>Amount Requested
</title>
144 <dataPattern>/^\d+(\.\d{
2})?$/
</dataPattern>
145 <comment>Requested grant amount, in original currency (optional).
</comment>
152 <name>amount_granted
</name>
153 <title>Amount granted
</title>
155 <dataPattern>/^\d+(\.\d{
2})?$/
</dataPattern>
156 <import>true
</import>
157 <comment>Granted amount, in default currency.
</comment>
164 <name>currency
</name>
165 <title>Grant Currency
</title>
168 <required>true
</required>
169 <comment>3 character string, value from config setting or input via user.
</comment>
172 <table>civicrm_currency
</table>
173 <keyColumn>name
</keyColumn>
174 <labelColumn>full_name
</labelColumn>
175 <nameColumn>name
</nameColumn>
176 <abbrColumn>symbol
</abbrColumn>
183 <name>currency
</name>
186 <default>NULL
</default>
187 <comment>3 character string, value from config setting or input via user.
</comment>
192 <name>rationale
</name>
194 <title>Grant Rationale
</title>
195 <comment>Grant rationale.
</comment>
197 <type>TextArea
</type>
201 <import>true
</import>
205 <name>status_id
</name>
206 <type>int unsigned
</type>
207 <title>Grant Status
</title>
208 <uniqueName>grant_status_id
</uniqueName>
209 <required>true
</required>
210 <import>true
</import>
211 <export>false
</export>
212 <comment>Id of Grant status.
</comment>
214 <optionGroupName>grant_status
</optionGroupName>
222 <name>index_status_id
</name>
223 <fieldName>status_id
</fieldName>
227 <name>financial_type_id
</name>
228 <title>Financial Type
</title>
229 <type>int unsigned
</type>
230 <default>NULL
</default>
232 <table>civicrm_financial_type
</table>
233 <keyColumn>id
</keyColumn>
234 <labelColumn>name
</labelColumn>
236 <comment>FK to Financial Type.
</comment>
240 <name>financial_type_id
</name>
241 <table>civicrm_financial_type
</table>
243 <onDelete>SET NULL
</onDelete>