What Grants holds
In plain wordsTechnical detail
| Stored in | Details | Why | Kept for | Schedule row |
|---|---|---|---|---|
| grants_proposals | member_id, title, question, why_public, method, data_plan, data_share, publication_plan, conflicts, timeline_json, budget_json, roles_json, irb_college, irb_note, requested_cents | Your research proposal: the question, the method, the timeline, the budget and where you will publish. Reviewers read it once you send it. It is public if you list it or it is funded. | A draft is deleted 12 months after you last changed it, and a declined proposal 12 months after the decision. A funded proposal is kept seven years after the grant ends. | Row D13 |
| grants_team | member_id, role, message, show_name | Who asked to join a research project, what they wrote to the lead, and whether they agreed to be named if it is funded. | Deleted 12 months after a request is declined or you leave the team, when the project is deleted, or when you delete your account. | Row D14 |
| grants_reviews | staff_id, scores_json, comment, conflict_kind, conflict_note | A reviewer's scores and comment on a proposal, or the conflict of interest they declared. It is also how a person who steps aside from a proposal they were to decide is recorded. | Kept as long as the proposal it is about. | Row D15 |
| grants_decisions | reason, outcome | The decision on your proposal and the reasons written for you. | Kept as long as the proposal it is about. | Row D15 |
| grants_grants | member_id, awarded_cents, show_name, result_title, result_url, data_url, closing_note | A grant you hold: the amount, whether your name may be shown, and the link to your published results. The amount, budget, spending and reports are public. | Kept seven years after the grant ends, and not erased when you delete your account, because it is a financial record. | Row D16 |
| grants_expenses | amount_cents, spent_on, what, receipt_key, receipt_type, receipt_bytes | What you spent a grant on, with a receipt if you attached one. Receipts are files that only you and staff can open. | Kept seven years after the grant ends, with the receipts, and not erased when you delete your account, because it is a financial record. | Row D17 |
| grants_reports | done_text, next_text, problems_text, unspent_note | Your progress and final reports. Staff read them; the ones they accept are public. | Kept seven years after the grant ends. | Row D18 |
| grants_payments | amount_cents, sent_on, how, note | The payments staff marked as sent for your grant. | Kept seven years after the grant ends, and not erased when you delete your account, because it is a financial record. | Row D19 |
| grants_signatures | typed_name, ink, ink_hash, doc_hash, show_name, tax_ack, account, member_id, esign_at, signed_at | The record that you and Tillyard's owner signed the grant agreement: the name you typed, the signature you drew, the time, your account, and a fingerprint of the exact text. | Kept seven years after the grant ends, and not erased when you delete your account, because it is the signed agreement. | Row D16 |
| grants_insiders | label, member_id, staff_id, mail_mac | Who is marked as a trustee, officer, staff member or family member, so they cannot apply for a grant, join a team or receive grant money, and a relative cannot read or decide one. An email address is kept only as a coded fingerprint. | Kept while the person is on the list, and deleted 12 months after they are taken off. | Row D20 |