Sirius Case Management
Sirius is the case management system of the OPG.
Tables referenced here:
- analytics_export.digitallpa_channel
- poa.complaints
- poa.investigation
- public.addresses
- public.assignee_teams
- public.assignees
- public.caseitem_document
- public.caseitem_task
- public.caseitem_warning
- public.cases
- public.documents
- public.pa_applicants
- public.person_caseitem
- public.person_document
- public.person_research_preferences
- public.person_task
- public.person_warning
- public.persons
- public.supervision_level_log
- public.tasks
- public.warnings
- supervision.annual_report_letter_status
- supervision.annual_report_lodging_details
- supervision.annual_report_logs
- supervision.annual_report_type_assignments
- supervision.assurance
- supervision.bond_providers
- supervision.bonds
- supervision.death_notifications
- supervision.deputy_important_information
- supervision.firm
- supervision.order_deputy
- supervision.supervision_notes
- supervision.visitor
- supervision.visits
- supervision_finance.billing_period
- supervision_finance.fee_reduction
- supervision_finance.finance_client
- supervision_finance.invoice
- supervision_finance.ledger
- supervision_finance.ledger_allocation