These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Parent-Teacher Communication
- Data model
The tables behind Parent-Teacher Communication
Parent-Teacher Communication ships with 14 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 14
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Case work
School conversations holds the numbered case and current revision; communication events holds child detail.
Review and evidence
Evidence documents, review decisions, follow up actions and state history preserve verification, decisions, assigned work and transitions.
Execution
Operation runs, operation steps and execution attempts track the run, ordered work and provider attempts.
Configuration
Organizations, People, school communities and source mappings define operating context and source transformation.
Every table, by feature
- Conversation cases2
- Communication events2
- Evidence and review3
- Delivery operations4
- Follow-up and corrections3
- School community setup4
- Shared and settings1
- School conversations
Requests, conversations and cases submitted for a school community.
Linked to Organizations, People, School communities - State history
Immutable workflow-written status transition history for each case.
Linked to School conversations, People
- Communication events
Observation-level communication event, document and line detail captured against a school conversation.
Linked to School conversations - School conversations
Requests, conversations and cases submitted for a school community.
Linked to Organizations, People, School communities
- Evidence documents
Uploaded and verified supporting documents and source evidence.
Linked to School conversations, People - Review decisions
Independent reviewer decisions recorded against an exact source revision.
Linked to School conversations, People - School conversations
Requests, conversations and cases submitted for a school community.
Linked to Organizations, People, School communities
- Operation runs
Workflow-maintained execution runs with operation key, input hash and persisted result reference.
Linked to School conversations - Operation steps
Ordered steps inside an operation run with input, output and external receipt state.
Linked to Operation runs - Execution attempts
Each recorded attempt to execute an approved action for a school conversation.
Linked to School conversations - School conversations
Requests, conversations and cases submitted for a school community.
Linked to Organizations, People, School communities
- Follow up actions
Assigned outstanding actions, corrections and outstanding requests for a case.
Linked to School conversations, People - State history
Immutable workflow-written status transition history for each case.
Linked to School conversations, People - School conversations
Requests, conversations and cases submitted for a school community.
Linked to Organizations, People, School communities
- Organizations
Agencies, departments and school organizations that own school communities and conversations.
- People
Staff, officers, reviewers and assigned team members.
Linked to Organizations - School communities
Published school-community definitions, programmes and entitlements offered by an organization.
Linked to Organizations - Source mappings
Reviewed field mappings and transform rules between source payloads and target fields.
Linked to School communities
Keys and references
A school conversations record links to an Organization, Owner and Definition. Communication events references its Parent case. Evidence documents, review decisions, follow up actions, execution attempts, operation runs and state history reference the source case. Operation steps links to its Run. Review decisions records source revision; operation runs also records source revision so the operation can be checked against the approved version. Provider reference and external receipt id help reconcile an external result.
Migration order
- Load Organizations and the People assigned to them.
- Load school communities and applicable source mappings.
- Import school conversations with stable case numbers, owners and definitions.
- Link communication events and evidence documents to their cases.
- Reconcile review decisions, follow up actions and retained state history where historical evidence exists.
- Bring in operation runs, operation steps and execution attempts only with matching source revisions and references.
Set up Parent-Teacher Communication your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.