What Interns holds
In plain wordsTechnical detail
| Stored in | Details | Why | Kept for | Schedule row |
|---|---|---|---|---|
| interns_applications | member_id, why, built, state_code, f1, f1_school_ok, team_first, team_second | Deciding who takes part in a term. Only the program director reads it. | A declined application is deleted after 90 days. Others are deleted 12 months after the term ends. | Row E34 |
| interns_places | member_id, team_key, learn, duties_json, done_json | Your team, your plan and your ticks for the term. | Kept 12 months after the term ends, then the plan text is cleared. | Row E35 |
| interns_checkins | note, help | Your weekly notes, for you, your lead and the program director. | Deleted 12 months after the term ends, or when you delete your account. | Row E36 |
| interns_hours | day, minutes, what | The hours you write down yourself, so you can ask your school for credit. Nobody checks them. | Deleted 12 months after the term ends, or when you delete your account. | Row E37 |
| interns_signatures | typed_name, member_id, staff_id, doc_hash, signed_at, esign_at | The record that you and the program director signed the agreement: the name typed, the time, the account and a fingerprint of the exact text. | Kept for as long as the agreement could matter. The typed name is erased if you delete your account; the fingerprint and times stay. | Row E38 |
| interns_interest | member_id, created_at | Who asked to be told when applications open, so we can write to them once. | Deleted 12 months after you ask, or once we have written to you, or when you take yourself off the list or delete your account. | Row E43 |
| interns_leads | member_id, team_key, status | Who the program director asked to lead a team as a volunteer, and what they said. | Deleted 12 months after the term ends. | Row E39 |