Statistics

Shared Services ▲

Reference Data ▼

Org Hierarchy

Legacy

#	Table	Rows
1	Customer.Customers
2	Customer.Organizations
3	Customer.OrganizationPrograms
4	Customer.SystemParameters
5	Customer.SystemParameters (config columns)

Modern

Table	Rows
org_nodes (customer)
org_nodes (facility)
org_node_closure (derived org tree materialization)
org_nodes (program)
org_nodes (customer with config)
config_definitions

Note: config_definitions (modern) can be lower than the configurable column count in Customer.SystemParameters (legacy). The migration only emits a config_definitions row for a key when at least one customer had a non-null value for that column. Columns that were NULL for every customer in legacy were dropped — they don't appear in config_definitions and aren't keys in any customer's org_nodes.config JSONB. If a future need arises to use one of those keys, it can be added directly to JSONB on any node (and registered in config_definitions) without any database schema change.

Role Assignments

Legacy

#	Table	Rows
1	Customer.OrganizationProgramStaff (active)
2	Customer.OrganizationProgramStaff (inactive)

Modern

Table	Rows
assignments (active)
assignments (inactive)
role_assignment_archive
assignments (is_deleted)

Identity

Legacy

#	Table	Rows
1	Contact.Persons
2	Contact.SystemUsers
3	Patient.ContactPhones
4	Patient.ContactEMailAddresses
5	Patient.ContactAddresses
6	Contact.UserSettings

Modern

Table	Rows
persons
system_users
system_users (legacy_password_enc set)
system_users (legacy_password_enc NULL)
phones
email_addresses
addresses

Patient

Legacy

#	Table	Rows
1	Patient.Patients
2	Patient.Diagnosis
3	Patient.Medications
4	Patient.Allergies
5	Patient.Hospitalizations
6	Patient.Insurances
7	Patient.Contacts
8	Patient.Providers
9	Patient.A1CReadingValues
10	Patient.Schedule
11	Patient.ReferralProfile
12	Patient.UploadedFiles

Modern

Table	Rows
patients
diagnoses
medications
allergies
hospitalizations
insurances
emergency_contacts
providers
lab_results
patient_schedule
referral_profile
patient_files
patient_changes

Notification

Legacy

#	Table	Rows
1	Contact.Conversations
2	Contact.Messages
3	Contact.EMailMessages
	Total Messages (rows 2+3)
4	Cases.AdditionalEMailNotifications
5	Cases.StaffNotifications
6	Cases.AdditionalNotificationSchedules
7	Cases.MobileNotificationQueue
8	Customer.NotificationGroups
9	Customer.NotificationGroupMembers

Modern

#	Table	Rows
1	notification.conversations
2	notification.messages
3	notification.notification_preferences
4	notification.notification_rules
5	notification.notification_groups
6	notification.case_team_members

Clinical Portal ▼