Multi-System Reconciliation
Why do standard business intelligence tools fail when analyzing senior living clinical and operational data?
Last reviewed
Direct answer
BI tools display and calculate; they do not decide which source is right. Senior housing & care data comes from clinical, financial, workforce and sales systems that define the same measure differently and update on different clocks. A dashboard built on top of those disagreements shows whichever value its query picked, without saying another system disagrees or who approved the figure.
Why this happens
Clinical data also carries privacy limits and resident-level detail that general BI models are not designed around, so teams often export subsets to spreadsheets, which adds another version.
BI works well once definitions, source authority and reconciliation are settled upstream. The failure is asking the reporting tool to do governance work.
Hypothetical example: an integration copies a stale value
Payroll
Team member: active
The termination has not yet been processed.
HR system (copied from payroll)
Team member: active
The integration copies the value as-is.
Scheduling
Team member: terminated
The manager removed them from the schedule.
- Evidence
- Disagreement
- Authority
- Operator-Controlled Operating Record
- Intelligence
- Execution
Illustrative figures. Coherence before Intelligence.
Two systems agree because one copied the other. Agreement produced by copying is not verification.
The governance question
A conventional technology sequence is integrate, normalize, analyze, automate. A governing sequence is Evidence, Disagreement, Authority, Operator-Controlled Operating Record, Intelligence, Execution. SeniorCRE Intelligence works downstream of operator authority. The difference is that disagreement is surfaced and decided by the operator rather than resolved invisibly by software.
Evidence → Disagreement → Authority → Operator-Controlled Operating Record → SeniorCRE Intelligence → Execution
What good operating infrastructure should do
- Detect disagreements instead of letting the last write win.
- Route conflicts to the person with authority to decide.
- Distinguish rule-based resolution from human determinations.
- Record every reconciliation decision with its lineage.
- Standardize reconciliation rules across the organization.
SeniorCRE perspective
SeniorCRE’s architecture treats integration as a source of evidence and reconciliation as a governed act. Software can apply rules the operator has approved; anything outside those rules goes to a named person, and the decision is recorded. Unified data is not governed truth. Status: the Operator-Controlled Operating Record is designed and not yet implemented in any community. Current capability states and production-entry gates are published in the Evidence Record at the Trust Center; nothing here should be read as a production result.