AI Generated Mapping Results

Source: legacy_hms Target: healthbookai Hospital: CityCare Hospital

AI Mapping generated and saved · 10:57:10 AM

Source Tables

Target Tables

980

Total Columns

812

Mapped Columns

Unmapped Source

Missing Required

87%

Avg Confidence

Filters

Search source table or column

Search target table or column

Filter by Mapping Type

Filter by Review Status

Column Mappings

Source Table	Source Column	Source Type	Target Table	Target Column	Target Type	Mapping Type	Transformation	Confidence	Status
old_patients	patient_code	VARCHAR	patients	patient_uuid	UUID	Generated ID	Generate UUID and keep old code as reference	91%	Needs Review
old_patients	fname	VARCHAR	patients	first_name	VARCHAR	Semantic Match	Rename column	98%	Approved
old_patients	lname	VARCHAR	patients	last_name	VARCHAR	Semantic Match	Rename column	88%	Approved
old_patients	dob	DATE	patients	date_of_birth	DATE	Name Match	Direct mapping	97%	Approved
old_patients	gender	VARCHAR	patients	gender	ENUM	Type Conversion	Normalize gender values	89%	Needs Review
old_patients	mob_no	VARCHAR	patient_contacts	phone_number	VARCHAR	Semantic Match	Rename column	94%	Approved
old_patients	email_id	VARCHAR	patient_contacts	email	VARCHAR	Semantic Match	Rename column	95%	Approved
old_doctors	doctor_code	VARCHAR	doctors	doctor_uuid	UUID	Generated ID	Generate UUID and preserve doctor code	80%	Needs Review
old_appointments	patient_code	VARCHAR	appointments	patient_id	UUID	Foreign Key Mapping	Resolve using patients table	86%	Needs Review
old_billing	total_amt	TEXT	invoices	total_amount	DECIMAL	Type Conversion	Cast TEXT to DECIMAL	83%	Needs Review