Statistics
Reminder: Modern database counts require the SSM tunnel to be open.
Run AWS_PROFILE=amc-test-sso bash scripts/db-tunnel.sh 5432 from the shared-services repository before collecting.
Collect
Reference Data ▼ Org Hierarchy
Legacy
# Table Rows 1
Customer.Customers
2
Customer.Organizations
3
Customer.OrganizationPrograms
4
Customer.SystemParameters
Modern
Table Rows org_nodes (customer) org_nodes (facility) org_node_closure programs config_definitions
Role Assignments
Legacy
# Table Rows 1
Customer.OrganizationProgramStaff (active)
2
Customer.OrganizationProgramStaff (inactive)
Modern
Table Rows role_assignments (active) role_assignments (inactive)
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 phones email_addresses addresses user_settings
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
Modern
Table Rows patients diagnoses medications allergies hospitalizations insurances emergency_contacts providers lab_results patient_schedule referral_profile
Notification
Legacy
# Table Rows 1
Contact.Conversations
2
Contact.Messages
3
Contact.EMailMessages
Total Messages (rows 2+3)
4
Cases.AdditionalEMailNotifications
5
Cases.StaffNotifications
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