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.
- Environmental Compliance
- Data model
The tables behind Environmental Compliance
Environmental Compliance ships with 15 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
- 15
- Features
- 6
- Change it
- Add fields and tables in Proto
How the model is organised
Operating scope:
Organizations contain business units and team members; team members link to Users.
Risk and control:
Business units have Risks; Risks have Controls with named team members as owners.
Assessment work:
Assessments link to Organizations, business units and team members, then contain assessment tests and permit measurements.
Correction:
Findings link to Assessments and Controls, and lead to corrective actions and Retests.
Review trail:
Record attachments, review decisions and operation receipts link to Assessments.
Every table, by feature
- Organization and unit scope6
- Risks and controls6
- Assessment testing6
- Permit measurements6
- Findings and remediation6
- Review and evidence6
- Organizations
Regulated organizations owning permits and compliance scope.
- Business units
Physical or operating units where permits and monitoring apply.
Linked to Organizations - Team members
Named people holding compliance roles within an organization.
Linked to Organizations, Users - Users
Users
Linked to Users - Assessments
Compliance assessment periods covering planned tests and review.
Linked to Organizations, Team members, Business units - Permit measurements
Permit readings logged against an assessment for exceedance review.
Linked to Assessments, Organizations
- Business units
Physical or operating units where permits and monitoring apply.
Linked to Organizations - Risks
Scored environmental risks per business unit with scale version.
Linked to Business units, Team members - Controls
Controls mitigating a risk, with owner and effective date.
Linked to Risks, Team members - Assessment tests
Individual evidence-based control tests within an assessment.
Linked to Assessments, Controls - Findings
Issues raised from failed or inconclusive control testing.
Linked to Assessments, Controls - Retests
Independent retests that verify corrective action effectiveness.
Linked to Findings, Team members
- Assessments
Compliance assessment periods covering planned tests and review.
Linked to Organizations, Team members, Business units - Assessment tests
Individual evidence-based control tests within an assessment.
Linked to Assessments, Controls - Controls
Controls mitigating a risk, with owner and effective date.
Linked to Risks, Team members - Findings
Issues raised from failed or inconclusive control testing.
Linked to Assessments, Controls - Corrective actions
Remediation work assigned against a finding.
Linked to Findings, Team members - Retests
Independent retests that verify corrective action effectiveness.
Linked to Findings, Team members
- Permit measurements
Permit readings logged against an assessment for exceedance review.
Linked to Assessments, Organizations - Assessments
Compliance assessment periods covering planned tests and review.
Linked to Organizations, Team members, Business units - Organizations
Regulated organizations owning permits and compliance scope.
- Record attachments
Supporting evidence files linked to an assessment.
Linked to Assessments, Team members - Review decisions
Independent reviewer decisions recorded per source revision.
Linked to Assessments, Team members - Operation receipts
Durable receipts for each guarded operation attempt.
Linked to Assessments
- Findings
Issues raised from failed or inconclusive control testing.
Linked to Assessments, Controls - Corrective actions
Remediation work assigned against a finding.
Linked to Findings, Team members - Retests
Independent retests that verify corrective action effectiveness.
Linked to Findings, Team members - Assessment tests
Individual evidence-based control tests within an assessment.
Linked to Assessments, Controls - Controls
Controls mitigating a risk, with owner and effective date.
Linked to Risks, Team members - Assessments
Compliance assessment periods covering planned tests and review.
Linked to Organizations, Team members, Business units
- Record attachments
Supporting evidence files linked to an assessment.
Linked to Assessments, Team members - Review decisions
Independent reviewer decisions recorded per source revision.
Linked to Assessments, Team members - Operation receipts
Durable receipts for each guarded operation attempt.
Linked to Assessments - Assessments
Compliance assessment periods covering planned tests and review.
Linked to Organizations, Team members, Business units - Permit measurements
Permit readings logged against an assessment for exceedance review.
Linked to Assessments, Organizations - Team members
Named people holding compliance roles within an organization.
Linked to Organizations, Users
Keys and references
Keep organization and unit codes stable as records move through review. An assessment’s record number identifies its period; its Organization, Counterparty and Owner references identify the operating context. Permit measurements use Parent to reach that assessment. Review decisions record source revision and operation receipts record expected revision, allowing the team to compare a decision or attempt with the version it addressed.
Migration order
- Load Organizations and Users, then team members and business units.
- Load Risks and Controls with their unit and owner references.
- Load Assessments and their planned period, organization, owner and unit.
- Load assessment tests, permit measurements and record attachments under each assessment.
- Load Findings, corrective actions and Retests with their source relationships.
- Bring in review decisions and operation receipts with their revision and parent references.
Set up Environmental Compliance your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.