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.
- Municipal Corporation ERP
- Data model
The tables behind Municipal Corporation ERP
Municipal Corporation ERP 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
Service configuration
Organizations own public services and People; source mappings relate source fields to a service definition.
Case intake
Cases link the organization, assignee and public service definition.
Requirements and evidence
Case requirements and case documents retain the line details and attachments for a case.
Independent review
Decisions link a reviewer and source revision to a case; case state history records transitions.
Delivery and correction
Operation runs, operation steps and execution attempts retain execution detail; follow up actions keep outstanding work assigned.
Every table, by feature
- Service configuration5
- Case intake8
- Requirements and evidence6
- Independent decisions7
- Delivery and corrections7
- Reporting and history12
- Shared and settings1
- Organizations
Agencies, departments and service organizations that own public services and cases.
- People
Staff, officers, reviewers and assigned team members.
Linked to Organizations - Public services
Published service 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 Public services - Cases
Requests, applications and cases submitted for a public service.
Linked to Organizations, People, Public services
- Cases
Requests, applications and cases submitted for a public service.
Linked to Organizations, People, Public services - Case requirements
Observation-level requirement, document and line detail captured against a service application.
Linked to Cases - Case documents
Uploaded and verified supporting documents and source evidence.
Linked to Cases, People - Case state history
Immutable workflow-written status transition history for each case.
Linked to Cases, People - Follow up actions
Assigned outstanding actions, corrections and outstanding requests for a case.
Linked to Cases, People - Organizations
Agencies, departments and service organizations that own public services and cases.
- People
Staff, officers, reviewers and assigned team members.
Linked to Organizations - Public services
Published service definitions, programmes and entitlements offered by an organization.
Linked to Organizations
- Case requirements
Observation-level requirement, document and line detail captured against a service application.
Linked to Cases - Case documents
Uploaded and verified supporting documents and source evidence.
Linked to Cases, People - Cases
Requests, applications and cases submitted for a public service.
Linked to Organizations, People, Public services - Decisions
Independent reviewer decisions recorded against an exact source revision.
Linked to Cases, People - Follow up actions
Assigned outstanding actions, corrections and outstanding requests for a case.
Linked to Cases, People - People
Staff, officers, reviewers and assigned team members.
Linked to Organizations
- Decisions
Independent reviewer decisions recorded against an exact source revision.
Linked to Cases, People - Cases
Requests, applications and cases submitted for a public service.
Linked to Organizations, People, Public services - Case requirements
Observation-level requirement, document and line detail captured against a service application.
Linked to Cases - Case documents
Uploaded and verified supporting documents and source evidence.
Linked to Cases, People - Case state history
Immutable workflow-written status transition history for each case.
Linked to Cases, People - People
Staff, officers, reviewers and assigned team members.
Linked to Organizations - Follow up actions
Assigned outstanding actions, corrections and outstanding requests for a case.
Linked to Cases, People
- Cases
Requests, applications and cases submitted for a public service.
Linked to Organizations, People, Public services - Decisions
Independent reviewer decisions recorded against an exact source revision.
Linked to Cases, People - Operation runs
Workflow-maintained execution runs with operation key, input hash and persisted result reference.
Linked to Cases - 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 Cases - Follow up actions
Assigned outstanding actions, corrections and outstanding requests for a case.
Linked to Cases, People - Case state history
Immutable workflow-written status transition history for each case.
Linked to Cases, People
- Cases
Requests, applications and cases submitted for a public service.
Linked to Organizations, People, Public services - Case requirements
Observation-level requirement, document and line detail captured against a service application.
Linked to Cases - Case documents
Uploaded and verified supporting documents and source evidence.
Linked to Cases, People - Decisions
Independent reviewer decisions recorded against an exact source revision.
Linked to Cases, People - Follow up actions
Assigned outstanding actions, corrections and outstanding requests for a case.
Linked to Cases, People - Case state history
Immutable workflow-written status transition history for each case.
Linked to Cases, People - Operation runs
Workflow-maintained execution runs with operation key, input hash and persisted result reference.
Linked to Cases - 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 Cases - Public services
Published service definitions, programmes and entitlements offered by an organization.
Linked to Organizations - Organizations
Agencies, departments and service organizations that own public services and cases.
- People
Staff, officers, reviewers and assigned team members.
Linked to Organizations
Keys and references
The case number is a human-facing identifier. References link records to the case, service definition, organization and people who acted. A decision’s source revision distinguishes the case version reviewed. Operation keys and source revisions identify execution work, while delivery references connect a completed case to its result. Keep these identifiers when importing or correcting data.
Migration order
- Organizations and people. Prepare organization codes, staff identities and their organization links.
- Services and mappings. Enter public service definitions, effective dates and applicable source mappings.
- Cases and detail. Import cases with their organization, service and assignee, followed by requirements and documents.
- Review and history. Reconcile decisions and state history by case and revision.
- Execution and follow-up. Associate operation runs, steps, attempts and open actions with their source case.
Set up Municipal Corporation ERP your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.