⊞
🔍   Search
🔔
⚙
❓
GO
🏢 A New Leaf — Facilities
Home
Inspection Records
Deficiencies
Reports
Power BI
← Portfolio 🎭 Interactive Demo Enterprise Facilities Audit & Compliance Engine — Click any row to inspect details
Facilities Management
📋 Inspection Records
🏢 Facility Registry
⚠️ Deficiencies
📄 Checklist Items
📁 Document Library
Reports
📊 Compliance Dashboard
📈 Power BI Report
📬 Audit Archive
Architecture
📦 Dataverse Model
Settings
⚙️ Site Settings
Facilities Management › Inspection Records
📋 Inspection Records 12 Items
Monthly facility compliance audits — May 2026 cycle  ·  Auto-generated PDF reports upon approval
94%
Avg Compliance
12
Facilities
9
Fully Compliant
2
Needs Attention
3
Open Deficiencies
Filters: Month: May 2026 ✕ Status: All ✕ + Add filter Sorted by: Inspection Date ↓
Facility Name ↓ Type Inspector Inspection Date Compliance % Status Open Deficiencies Report
📦
Dataverse Data Model — Facilities Audit & Compliance Engine
Parallel Dataverse implementation of the SharePoint architecture · 5 custom tables · Publisher prefix: mka_ · Power Apps Model-Driven App + Power BI DirectQuery
5
Custom Tables
42
Columns
5
Relationships
4
Business Rules
🏢mka_facilityCore
🔑 mka_facilityidUniqueIdentifier
mka_namenvarchar(200)
mka_typeOptionSet
mka_addressnvarchar(500)
🔗 mka_manageridLookup → systemuser
mka_statusOptionSet
mka_nextinspectiondateDateTime
📋mka_inspectionrecordInspection
🔑 mka_inspectionrecordidUniqueIdentifier
🔗 mka_facilityidLookup → mka_facility
mka_inspectiondateDateTime
🔗 mka_inspectoridLookup → systemuser
mka_overallscoreDecimal
mka_statusOptionSet
🔗 mka_approveridLookup → systemuser
mka_approvedonDateTime
☑️mka_checklistitemChecklist
🔑 mka_checklistitemidUniqueIdentifier
mka_namenvarchar(300)
mka_categoryOptionSet
mka_weightDecimal
mka_isfailurecriticalBoolean
mka_regulatoryrefnvarchar(100)
📝mka_inspectionresponseResponse
🔑 mka_inspectionresponseidUniqueIdentifier
🔗 mka_inspectionrecordidLookup → mka_inspectionrecord
🔗 mka_checklistitemidLookup → mka_checklistitem
mka_responseOptionSet
mka_scoreDecimal
mka_notesnvarchar(1000)
⚠️mka_deficiencyDeficiency
🔑 mka_deficiencyidUniqueIdentifier
🔗 mka_inspectionrecordidLookup → mka_inspectionrecord
🔗 mka_facilityidLookup → mka_facility
mka_descriptionnvarchar(2000)
mka_severityOptionSet
mka_correctiveactionnvarchar(2000)
mka_duedateDateTime
mka_statusOptionSet
Table Relationships
mka_facility1 : Nmka_inspectionrecord— all inspections per facility
mka_inspectionrecord1 : Nmka_inspectionresponse— checklist answers
mka_checklistitem1 : Nmka_inspectionresponse— reusable items across inspections
mka_inspectionrecord1 : Nmka_deficiency— deficiencies per inspection
mka_facility1 : Nmka_deficiency— open deficiencies per facility
Business Rules & Automation
⚡
Score rollup: weighted average of mka_inspectionresponse.mka_score auto-calculated to mka_overallscore
BR
⚡
Critical failure lock: any critical checklist failure forces overall status to Non-Compliant regardless of score
BR
⚡
Next inspection date auto-set to +30 days on approval
BR
🔌
Post-approval plugin: triggers Power Automate to generate PDF report + archive to SharePoint Compliance Library
Plugin
ℹ️ Click any row to view inspection details, deficiencies, and approval status  ·  PDF reports are auto-generated upon final approval via Power Automate