Map
Apply semantic labels to your data columns to create a common language across all your source systems. The Map module transforms disparate column names into standardized semantic terms that enable accurate matching and unified reporting.Why Semantic Mapping Matters
Every system has its own naming conventions. One system calls it “PatientFirstName,” another calls it “first_nm,” and a third uses “fname.” Without a common vocabulary, these systems can’t communicate effectively. Semantic mapping solves this by:- Creating a unified vocabulary across all data sources
- Enabling accurate matching by aligning equivalent fields
- Supporting consistent reporting and analytics
- Preserving the relationship between source and canonical data
What You Can Do
Assign Semantic Labels
Map source columns to standardized labels like FirstName, LastName, DateOfBirth, SSN.
Set Primary Keys
Designate which column uniquely identifies records in each source table.
Visual Mapping Interface
Drag and drop labels onto columns with an intuitive visual interface.
Bulk Operations
Apply labels to multiple columns at once for faster configuration.
Semantic Label Categories
Identity
FirstName, LastName, MiddleName, Suffix, DateOfBirth, SSN, MRN
Contact
Email, Phone, MobilePhone, Address, City, State, ZipCode
Demographics
Gender, Race, Ethnicity, Language, MaritalStatus
Clinical
DiagnosisCode, ProcedureCode, ProviderNPI, FacilityID
Financial
InsuranceID, MemberID, GroupNumber, PayerName
Custom Labels
Organization-specific labels for unique data elements
Key Capabilities
Intelligent Suggestions
skyMDM analyzes column names and sample data to suggest likely semantic labels. Columns named “dob” or “birth_date” are automatically suggested for DateOfBirth.Label Validation
The system validates that mapped labels are compatible with the underlying data types and provides warnings for potential mismatches.Cross-Source Alignment
View how labels are mapped across all your source tables to ensure consistency and identify gaps in your semantic model.Version Control
Mapping configurations are versioned, allowing you to track changes and roll back if needed.Business Impact
Accurate Matching
Semantic alignment ensures matching algorithms compare the right fields.
Unified Reporting
Consistent labels enable cross-source analytics and reporting.
Faster Onboarding
New data sources are integrated faster with standardized mapping.
Who Benefits
- Data Architects: Design and maintain the enterprise semantic model
- Data Engineers: Quickly map new data sources to existing standards
- Analytics Teams: Query across sources using consistent field names
- Integration Teams: Reduce mapping errors when connecting systems