What the staff console holds
In plain wordsTechnical detail
| Stored in | Details | Why | Kept for | Schedule row |
|---|---|---|---|---|
| staff_profiles | agreement_ref, agreement_from, digest_hour, tz, last_seen_at, seat_removed_at | A staff person's agreement reference, their console settings and when they were last at the desk, so that nobody works here unpaid and unseen urgent work is noticed. | 3 years after access ends. | Not listed yet |
| staff_member_notes | body, case_ticket | Staff-written facts about a member, for continuity between cases. Never shown to the member; produced by hand, redacted, when a request calls for it. | 730 days from writing, or until the account is erased. | Not listed yet |
| staff_attestations | title_key, kind, evidence_kind, evidence_id, observed | What the editor signed for whom: the basis of a title granted from typed evidence. | While the title stands; 3 years after withdrawal. The sentence is blanked when the account is erased. | Not listed yet |
| staff_school_requests | domain, school_name, state_code | A college someone asked us to add: its name as typed and the ending of its addresses, with how many people asked. The people are in staff_school_askers; this row holds no address and no network data. | The name is blanked when the request is decided; the row is kept 12 months. | Row K8 |
| staff_school_askers | email, school_name, city, state_code, note, tell, tell_since | Someone who asked us to add their college: their email, the college's name, the city and state they typed and an optional note, so a person can look at the request and write to them once if it is added. No network data. Only staff see it. | Until the request is answered: deleted when it is declined, closed as already listed or lapses after 60 days. When the college is added the row stays only until the email 'Your college is on Tillyard now' has gone, at most 14 days. | Row K10 |
| staff_data_requests | ticket, kind, from_label, member_id, note | Showing that a request about someone's data was handled: who asked in a few words, the member it concerns, and what was done. | 3 years after closing. | Not listed yet |
| staff_duty_log | staff_id, note | Which staff person did which upkeep duty and when. | 3 years. | Not listed yet |
| staff_setup_codes | staff_id, code_hash, made_by, made_at, expires_at | A one-time code the owner gives a console account for its first sign-in while the site cannot send email: only a keyed hash of the code, who it is for and who made it. | Until it is used or replaced, or 7 days. | Not listed yet |
| staff_switch_timers | set_by | Which staff person set a switch to turn back by itself. | Until the switch turns back. | Not listed yet |
| staff_board_seats | staff_id, office | Which trustee holds which office (secretary, treasurer, trustee), so each can do what the regulations give that office and nothing more. | While the trustee holds the office; the log keeps who held it. | Not listed yet |
| staff_board_meetings | held_on, place, guests, notice | The board's meetings: the day, where, how notice was given and the names of guests who were there. | Permanent, with the minutes (the board's document retention policy). | Not listed yet |
| staff_board_attendance | staff_id, present | Which trustees were at a meeting, to show a quorum. | Permanent, with the minutes. | Not listed yet |
| staff_board_minutes | body, file_key, snapshot_json, created_by | The minutes of each meeting, every version, as typed words or a PDF, with what was frozen when each was approved. | Permanent (Ohio requires minutes, R.C. 1702.15). | Not listed yet |
| staff_board_resolutions | title, body, moved_by, seconded_by, recorded_by | The matters the board voted on, who moved and who seconded. | Permanent, with the minutes. | Not listed yet |
| staff_board_votes | staff_id, vote | How each trustee voted, or that they stepped out for the matter. | Permanent, with the minutes. | Not listed yet |
| staff_board_conflicts | staff_id, matter, nature | An interest a trustee declared at a meeting, and whether they stepped out. | Permanent, with the minutes. | Not listed yet |
| staff_board_documents | title, note, file_key, uploaded_by | The board's documents shelf: the articles, the regulations, policies, the EIN and IRS letters, insurance. The files are in private storage. | Permanent for governing documents and insurance policies; the others as the board's document retention policy says. Nothing is deleted by the site. | Not listed yet |
| staff_board_coi | staff_id, answers, typed_name, ink | Each trustee's signed yearly conflict-of-interest statement: the answers about their interests, the typed name and the drawn signature. | Seven years after the year it covers. The board removes it by its routine; the site does not delete it by itself yet. | Not listed yet |
| staff_board_expenses | payee, purpose, claimant_id, receipt_key, recorded_by, decided_by, decline_note | What the board spent: to whom, for what, who recorded and who approved, with the receipt in private storage. | Seven years (receipts, invoices and expense reports). The board removes it by its routine; the site does not delete it by itself yet. | Not listed yet |
| staff_board_expense_approvals | staff_id, approved_at | Which trustees approved an expense, and when. | Seven years, with the expense. | Not listed yet |
| staff_board_donations | donor, amount_cents, note, acknowledged_on, void_note | Gifts that came in, with the donor's name as given (or none), so each can be thanked in writing and counted. No address or payment detail. | Seven years after the gift. The board removes it by its routine; the site does not delete it by itself yet. | Not listed yet |
| staff_board_reviews | reviewed_by, typed_name, note | The treasurer's signed monthly review of the bank statement and the expense log. | Seven years. The board removes it by its routine; the site does not delete it by itself yet. | Not listed yet |