ExternalID Internal Confusion
These documents are the first thing customers receive during a migration, capturing mappings and requirements from day one.
What are Migration Templates?
This reporting platform runs FEX/MAS files and can queue reports for deferred execution.
What is WebFOCUS?
This field appears across all EX tables and anchors nearly every join involving clients.
What is TreatClientID?
This special environment handles production-level migrations with enhanced processing capacity.
What is the Dedicated Migration Server?
This is the name of Michael’s 9-month-old son.
Who is Mattia?
This special note template allows migrated notes from another system to land cleanly inside TREAT.
What is a Migration Note?
These legacy VitalHub reports run on a platform that’s no longer supported but still occasionally discovered in the wild.
What is SSRS?
Every encounter snapshot lives here, making it the go-to table for joining visit context to notes.
What is EX_EncounterSnapshot?
This language powers data cleanup and field extraction inside Mirth Channel Transformers.
What is JavaScript?
This is Ryan’s preferred type of vacation.
What is a cruise?
This table stores unique source-system IDs and ties them to RecordTypeID and RecordInstanceID.
What is TR_RecordExternalID?
Reports referencing items in this folder often implode due to circular dependencies. Boom.
What is Treat Meta?
This duo of fields serves as the bridge linking EX_Workload to its parent record inside the transactional schema.
What are RecordTypeID and RecordID?
When moving channels from DM to the migration server, this environment-specific URL must be updated.
What is the TREAT URL?
This country is Lino’s chosen home after living in several others.
What is Colombia?
This migration area keeps adding new entries—even when the same ExternalID is used—rather than overwriting previous records.
What is Workload?
This WebFOCUS feature lets developers reshape data on the fly before it reaches the final report output.
What is a DEFINE?
Billing charges attach to their parent claims using this shared identifier.
What is Claim ID?
Despite its name, this migration area updates records but never creates new ones.
What is the Waitlist?
This phrase — shared by Sean — is used during Rosh Hashanah.
What is “Shana Tovah u’metukah”?
This table stores the MigrationID value used to track migrated entities.
What is TR_ClientAlternateID?
These temporary data extracts respect user permissions and should be the starting point for secure report development.
What is FOCCACHE?
Frequently seen but rarely joinable without manipulation, this field tells you where a record came from.
What is SourceURI?
This Channel Transformer section defines how incoming CSVs are parsed and interpreted.
What are Message Template Properties?
This historic city is where Steve completed a marathon after joining VitalHub.
What is Istanbul?