TREAT Data Migration Mysteries
This tier of migration includes only the essential mandatory fields like demographics, enrollments, visits, and profile widgets.
What is Tier 1 migration?
This VitalHub reporting tool uses FEX/MAS files and can display deferred report queues.
What is WebFOCUS?
This SQL operator lets you reference an expression that depends on values from the outer query, often used to clean or reshape fields before selecting.
What is OUTER APPLY?
The section of a Mirth channel where custom code executes to transform inbound HL7 or JSON messages.
What is the channel transformer component?
Profile widgets in TREAT store their fields in tables typically prefixed with these two letters.
What is "ex"?
In Pirouette → TREAT migrations, this type of note acts as a container for historical data points when the original forms can’t be replicated.
What are container notes?
This upcoming modernization effort involves replacing SSRS reports with more maintainable versions using a unified approach in WebFOCUS.
What is the Reporting Catalog Modernization initiative?
This function is used to safely turn dynamic schema/table names into valid SQL identifiers: QUOTENAME(PARSENAME(<table>,2)).
What is the PARSENAME function (with QUOTENAME)?
Mirth Connect uses this scripting language inside transformers for logic like string cleanup and field extraction.
What is JavaScript (E4X)?
This TREAT module allows custom demographic and widget fields to be created during Tier 2 migrations.
What is the Custom Fields module (for demographics and widgets)?
When migrating progress notes for LOFT, this process slowed down as more notes were added because the system needed to search this index to associate the note to the correct encounter.
What is the note-to-encounter cross-reference index (RecordElementIndex)?
This view, built for CTN, combines clients, progress notes, and workload data into a single reporting object with inline lookups for note types and workload text.
What is the CTN unified reporting view?
When optimizing slow views, reducing this characteristic of rows—often inflated by unused columns—can dramatically improve join performance.
What is row width (reducing the number of columns)?
When a transformer contains repeated cleanup logic, replacing multiple scripts with a single reusable block improves this key performance factor.
What is performance (execution speed and maintainability)?
When building automated instructions for new widgets, the first step is turning a plain-text specification into this structured artifact.
What is a structured specification or widget definition (script blueprint)?
For occupancy logic, Mike prefers this rule: if there's no record between known dates, treat the bed as having this status.
What is occupied?
For Nova Scotia ESIA reporting, the biggest challenge is extracting budgeting logic from this source area of TREAT assessments.
What are the budgeting fields in ESIA assessments?
Mike frequently replaces chains of FORMAT(...) in views with this lighter-weight conversion function to reduce CPU usage.
What is CONVERT()?
In Mirth, when merging multiple segments or repeating fields, this data structure (often accessed like a map) holds the parsed message tree.
What is the message map (the 'msg' object representing the message tree)?
Option lists for widgets usually live in this type of lookup table that includes both `CodeDescription` and `CodeValue`.
What is a code lookup table (CodeLookup table)?
This cross-reference table determines which TREAT table a workload or encounter record belongs to by using RecordTypeID and RecordInstanceID.
What is the record cross-reference table (RecordTypeRecordInstanceXRef)?
VitalHub’s long-term analytics vision includes integrating external population-level datasets like ON-MARG after foundational work in this architectural framework is complete.
What is the analytics lakehouse?
This temp-table-driven pattern pre-materializes heavy datasets like `oe_orders` before downstream views, avoiding repeated scanning of large tables.
What is using a #temp table to pre-materialize heavy datasets (the temp table pre-materialization pattern)?
For large migration channels, isolating only transformer sections instead of the entire channel export allows this benefit when coordinating with development or clients.
What is enabling targeted updates and easier collaboration without sharing the full channel export?
Mike’s automation goal for widget generation aims to eliminate this recurring bottleneck — the time spent manually creating new widgets based on textual requirements.
What is the manual time spent creating widgets from textual requirements (manual widget build time)?