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.
- Citizen Service Portal
- Data model
The tables behind Citizen Service Portal
Citizen Service Portal 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
Applications
Service applications belongs to Organizations and public services and names an Owner in People. Application requirements are child lines.
Evidence and review
Evidence documents, review decisions, follow up actions and state history refer to the application. Their person references identify verifiers, reviewers, assignees and actors.
Execution
Operation runs belongs to an application; operation steps belongs to a run. Execution attempts records attempts against the application.
Configuration
Public services belongs to Organizations and can have source mappings. People also belongs to Organizations.
Every table, by feature
- Service applications
Requests, applications and cases submitted for a public service.
Linked to Organizations, People, Public services - Organizations
Agencies, departments and service organizations that own public services and cases.
- Public services
Published service definitions, programmes and entitlements offered by an organization.
Linked to Organizations - People
Staff, officers, reviewers and assigned team members.
Linked to Organizations
- Application requirements
Observation-level requirement, document and line detail captured against a service application.
Linked to Service applications - Service applications
Requests, applications and cases submitted for a public service.
Linked to Organizations, People, Public services - Follow up actions
Assigned outstanding actions, corrections and outstanding requests for a case.
Linked to Service applications, People
- Evidence documents
Uploaded and verified supporting documents and source evidence.
Linked to Service applications, People - Service applications
Requests, applications and cases submitted for a public service.
Linked to Organizations, People, Public services - People
Staff, officers, reviewers and assigned team members.
Linked to Organizations
- Review decisions
Independent reviewer decisions recorded against an exact source revision.
Linked to Service applications, People - Service applications
Requests, applications and cases submitted for a public service.
Linked to Organizations, People, Public services - People
Staff, officers, reviewers and assigned team members.
Linked to Organizations - State history
Immutable workflow-written status transition history for each case.
Linked to Service applications, People
- Service applications
Requests, applications and cases submitted for a public service.
Linked to Organizations, People, Public services - Operation runs
Workflow-maintained execution runs with operation key, input hash and persisted result reference.
Linked to Service applications - 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 service application.
Linked to Service applications
- Service applications
Requests, applications and cases submitted for a public service.
Linked to Organizations, People, Public services - State history
Immutable workflow-written status transition history for each case.
Linked to Service applications, People - Review decisions
Independent reviewer decisions recorded against an exact source revision.
Linked to Service applications, People - Follow up actions
Assigned outstanding actions, corrections and outstanding requests for a case.
Linked to Service applications, People
Keys and references
The application Number identifies the working case. Source revision on a review decision or run connects its outcome to the relevant Revision of service applications. Operation key links operational events and state history. A delivery reference records the resulting service action. Match these values when investigating a correction or uncertain execution.
Migration order
- Create Organizations, People and public services with the appropriate service ownership.
- Add source mappings where an external source needs a reviewed field transform.
- Load service applications with owner and service references, then their application requirements and evidence documents.
- Bring over review decisions, state history and follow up actions with their case and person references.
- Attach operation runs, operation steps and execution attempts to the correct case and source revision.
Set up Citizen Service Portal your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.