INSERT INTO report_catalogue(report_key,title,scope_levels,required_capability,audience,definition_text,source_text,small_group_threshold,active) VALUES
('cross_membership','Verified cross-membership','province','reports.membership','Authorised Province membership officers','Verified people with active memberships in one, two, or three-or-more Units in the Province at the as-of date. Unverified identities are excluded; no automatic matching occurs.','people.identity_verified_at and unit_members active states grouped by person.',5,1),
('candidate_pipeline','Candidate pipeline','province','candidates.view','Authorised Province candidate officers','Counts recorded candidate stages and overdue reviews by Unit. Candidate names, notes and sponsors are excluded.','unit_candidates stage and review_date joined to Province Units.',5,1),
('finance_aggregates','Finance aggregates','province','finance.read','Authorised Province finance officers','Ledger entry counts, charges, payments, refunds and net balance deltas grouped by Unit and period. Individual transactions and notes are excluded.','immutable finance_ledger_entries amounts and effective_at.',5,1),
('charity_alms_aggregates','Charity and alms aggregates','province','welfare.finance','Authorised Province charity and welfare-finance officers','Recorded financial welfare gestures grouped only by gesture type; private reasons and case identities are excluded.','welfare_gestures amount and gesture_type.',5,1),
('welfare_health','Welfare service health','province','welfare.health','Authorised Province welfare managers','Open, review-due and closed case counts only. No person, case, note, contact or health detail is included.','welfare_cases status and next_review_on.',5,1),
('forms_status','Province forms status','province','returns.view','Authorised Province returns officers','Outstanding, overdue, submitted and closed form cycles grouped by form type. Submission content is excluded.','province_form_cycles and province_form_definitions.',5,1),
('ritual_coverage','Ritual coverage','province','reports.ceremonies','Authorised Province ceremonial officers','Recorded ceremony milestones and active office terms grouped by Order and terminology; no inferred progression is included.','member_milestones and member_offices joined to Province Units.',5,1)
ON DUPLICATE KEY UPDATE title=VALUES(title),required_capability=VALUES(required_capability),definition_text=VALUES(definition_text),source_text=VALUES(source_text),active=VALUES(active);