common.users

Field	Type	Null	Default	Key	Extra	Comment
usr_id	int(11)	NO		PRI	auto_increment
usr_sfax_acc_id	int(11)	NO		MUL
usr_email	varchar(80)	YES		UNI		User E-Mail
usr_fname	varchar(40)	NO		MUL
usr_mname	varchar(40)	NO		MUL
usr_lname	varchar(40)	NO		MUL
usr_suffix	varchar(10)	NO		MUL
usr_credentials	varchar(20)	NO
usr_is_dev	char(1)	NO	0	MUL		Indicates that user is a developer
usr_title	varchar(40)	NO
usr_password	varchar(60)	NO				User password
usr_password_bcrypt	varchar(60)	NO				User password bcrypt
usr_salt	varchar(10)	NO				User salt - not used when usr_password is bcrypt.
usr_timezone	varchar(40)	NO
usr_timeout_seconds	varchar(6)	NO
usr_pw_reset	varchar(10)	NO
usr_pw_reset_expiry_dt	datetime	YES				Stores the date and time of when the reset token expires
usr_last_login	varchar(10)	NO
usr_last_password_change	varchar(10)	NO
usr_email_reset_counter	tinyint(1)	NO	1
usr_invited	varchar(10)	NO		MUL
usr_invited_usr_id	int(11)	NO
usr_reverified	int(11)	YES	0			Indicates step of reverification process
usr_email_verify	varchar(10)	YES	0			Token to verify e-mail address
usr_email_verify_exp	timestamp	YES	CURRENT_TIMESTAMP			Time verify email will expire
usr_disabled	char(1)	NO	0	MUL
usr_portal_access	char(1)	NO		MUL
usr_system_access	char(1)	NO		MUL
usr_provider_stats	char(1)	NO	0	MUL
usr_system_stats	char(1)	NO	0	MUL
usr_pat_stats	char(1)	NO	0	MUL
usr_leads_stats	char(1)	NO	0	MUL
usr_login_stats	char(1)	NO	0	MUL
usr_customers_stats	char(1)	NO	0	MUL
usr_enc_stats	char(1)	NO	0	MUL
usr_contracts	char(1)	NO		MUL
usr_email_notifications_messaging	char(1)	NO	1	MUL
usr_email_notifications_precerts	char(1)	NO	0	MUL		Indicates that user should receive emails regarding precerts
usr_email_notifications_tasks	char(1)	NO	0			Indicates that user should receive emails regarding tasks
usr_cell_phone	varchar(40)	NO				A cell phone number that can be used to reach this user.
usr_apersona_contact_method	int(11)	NO	0			Indicates how this user should be contacted by apersona. 0 - email, 1 - text, 2 - call, 3 - bypass
usr_id_ext	varchar(15)	NO
usr_sso_uuid	varchar(36)	YES		UNI
usr_salesforce_opt_in	tinyint(1)	YES	0			User has opted in to Salesforce.
usr_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
usr_created	timestamp	YES	CURRENT_TIMESTAMP

References

Local Column

References

usr_id

Table	Column
Azalea.employees	emp_usr_id
AzaleaStats.error_reports	err_usr_id
AzaleaStats.login_events	loge_usr_id
EFaxes.efax_accounts_map	efam_usr_id
Loinc.loinc_codes_frequency	lcf_usr_id
Messaging.messages_access	mxs_usr_id
Messaging.messages_access_new	mxs_usr_id
Messaging.messages_contacts	mc_usr_id
Messaging.messages_contacts	mc_target_usr_id
Messaging.messages_groups_members	mgm_usr_id
Messaging.messages_labels	ml_usr_id
_1.audits	aud_usr_id
_1.audits	aud_spoofing_usr_id
_1.audits	aud_web_usr_id
_1.audits_archive	aud_usr_id
_1.audits_archive	aud_spoofing_usr_id
_1.audits_archive	aud_web_usr_id
_1.audits_new	aud_usr_id
_1.audits_new	aud_spoofing_usr_id
_1.audits_new_archive	aud_usr_id
_1.audits_new_archive	aud_spoofing_usr_id
_1.billing_reports_queue	brq_usr_id
_1.card_connect_profiles	cconp_usr_id
_1.chart_changes	cc_usr_id
_1.charts_care_plan	ccp_assigned_usr_id
_1.charts_stored_notes_access	chsna_usr_id
_1.charts_stored_notes_frequency	chsnf_usr_id
_1.client_configs	cc_usr_id
_1.clinical_alerts_access	caa_usr_id
_1.clinical_interventions	ci_creator_usr_id
_1.clinical_interventions	ci_modifier_usr_id
_1.clinical_interventions	ci_enabler_usr_id
_1.clinical_interventions	ci_disabler_usr_id
_1.clinical_interventions_review_map	cirm_disabled_usr_id
_1.clinical_interventions_review_map	cirm_creator_usr_id
_1.clinical_interventions_users_map	cium_usr_id
_1.closed_periods	clp_usr_id
_1.closed_periods_daily	clpd_usr_id
_1.daily_close_schedules	dcs_usr_id
_1.documents_folders	dfol_usr_id
_1.encounters_claims_files	ecf_usr_id
_1.encounters_soap_templates_access	esta_usr_id
_1.encounters_soap_templates_frequency	estf_usr_id
_1.encounters_stored_notes_access	esna_usr_id
_1.encounters_stored_notes_frequency	esnf_usr_id
_1.encounters_stored_notes_patients_frequency	esnpf_usr_id
_1.erx_notification_counts	erx_not_usr_id
_1.erx_web_users	erx_users_usr_id
_1.feature_requests	fea_usr_id
_1.groups_members	gms_usr_id
_1.handouts	hand_usr_id
_1.health_maintenance_associations	hma_usr_id
_1.invoices_periods	invper_usr_id
_1.lab_orders_signed	losig_signed_by_usr_id
_1.labels	lbl_usr_id
_1.ledger	led_usr_id
_1.models_updates	mdu_usr_id
_1.notes	not_usr_id
_1.notes	not_mod_usr_id
_1.nuance_config	ncf_usr_id
_1.patient_access_restriction	patar_usr_id
_1.patient_amendments	pa_creator_usr_id
_1.patient_amendments	pa_apprv_usr_id
_1.patient_next_of_kin	pnk_created_by_usr_id
_1.patient_portal_requests	ppr_usr_id
_1.patients_document_assembly	pda_usr_id
_1.patients_handouts	phs_usr_id
_1.patients_icd9_problems	pip_diagnosed_by_usr_id
_1.patients_icd9_problems	pip_resolved_by_usr_id
_1.patients_icd9_problems	pip_created_by_usr_id
_1.patients_immunizations	pim_admin_usr_id
_1.patients_immunizations	pim_entered_by_usr_id
_1.patients_inventory	pinv_administered_usr_id
_1.patients_inventory	pinv_created_by_usr_id
_1.patients_payment_methods	patpm_usr_id
_1.patients_popup_receivers	ppr_usr_id
_1.patients_referrals	pref_assigned_usr_id
_1.patients_statements	pst_usr_id
_1.patients_stored_messages	psm_modified_usr_id
_1.physician_order_delegation_users_map	phyodum_usr_id
_1.physicians	phy_usr_id
_1.pi_user_access_map	pi_access_usr_id
_1.precerts_comments	prc_usr_id
_1.precerts_notes	prn_usr_id
_1.procedures_results	pres_created_usr_id
_1.provider_access	pacc_usr_id
_1.radiology_orders_signed	rosig_signed_by_usr_id
_1.recalls_reasons_associations	rra_usr_id
_1.referral_program	ref_usr_id
_1.reports_queue	rq_usr_id
_1.reports_schedules	rsched_usr_id
_1.saved_filters	sfil_usr_id
_1.schedules_exceptions	sexc_usr_id
_1.tasks	task_created_usr_id
_1.tasks	task_modified_usr_id
_1.tasks	task_assign_to_usr_id
_1.tasks_assigned_map	tamap_usr_id
_1.tasks_assignments	taskass_assigner_usr_id
_1.tasks_assignments	taskass_assigned_usr_id
_1.test_codes_search_frequency	tcof_usr_id
_1.user_preferences	upref_usr_id
_1.users_roles	ur_usr_id
_1.voided_payments	vp_usr_id
_1188.audits	aud_usr_id
_1188.audits	aud_spoofing_usr_id
_1188.audits	aud_web_usr_id
_1188.audits_archive	aud_usr_id
_1188.audits_archive	aud_spoofing_usr_id
_1188.audits_archive	aud_web_usr_id
_1188.audits_new	aud_usr_id
_1188.audits_new	aud_spoofing_usr_id
_1188.audits_new_archive	aud_usr_id
_1188.audits_new_archive	aud_spoofing_usr_id
_1188.billing_reports_queue	brq_usr_id
_1188.card_connect_profiles	cconp_usr_id
_1188.chart_changes	cc_usr_id
_1188.charts_care_plan	ccp_assigned_usr_id
_1188.charts_stored_notes_access	chsna_usr_id
_1188.charts_stored_notes_frequency	chsnf_usr_id
_1188.client_configs	cc_usr_id
_1188.clinical_alerts_access	caa_usr_id
_1188.clinical_interventions	ci_creator_usr_id
_1188.clinical_interventions	ci_modifier_usr_id
_1188.clinical_interventions	ci_enabler_usr_id
_1188.clinical_interventions	ci_disabler_usr_id
_1188.clinical_interventions_review_map	cirm_disabled_usr_id
_1188.clinical_interventions_review_map	cirm_creator_usr_id
_1188.clinical_interventions_users_map	cium_usr_id
_1188.closed_periods	clp_usr_id
_1188.closed_periods_daily	clpd_usr_id
_1188.daily_close_schedules	dcs_usr_id
_1188.documents_folders	dfol_usr_id
_1188.encounters_claims_files	ecf_usr_id
_1188.encounters_soap_templates_access	esta_usr_id
_1188.encounters_soap_templates_frequency	estf_usr_id
_1188.encounters_stored_notes_access	esna_usr_id
_1188.encounters_stored_notes_frequency	esnf_usr_id
_1188.encounters_stored_notes_patients_frequency	esnpf_usr_id
_1188.erx_notification_counts	erx_not_usr_id
_1188.erx_web_users	erx_users_usr_id
_1188.feature_requests	fea_usr_id
_1188.groups_members	gms_usr_id
_1188.handouts	hand_usr_id
_1188.health_maintenance_associations	hma_usr_id
_1188.invoices_periods	invper_usr_id
_1188.lab_orders_signed	losig_signed_by_usr_id
_1188.labels	lbl_usr_id
_1188.ledger	led_usr_id
_1188.models_updates	mdu_usr_id
_1188.notes	not_usr_id
_1188.notes	not_mod_usr_id
_1188.nuance_config	ncf_usr_id
_1188.patient_access_restriction	patar_usr_id
_1188.patient_amendments	pa_creator_usr_id
_1188.patient_amendments	pa_apprv_usr_id
_1188.patient_next_of_kin	pnk_created_by_usr_id
_1188.patient_portal_requests	ppr_usr_id
_1188.patients_document_assembly	pda_usr_id
_1188.patients_handouts	phs_usr_id
_1188.patients_icd9_problems	pip_diagnosed_by_usr_id
_1188.patients_icd9_problems	pip_resolved_by_usr_id
_1188.patients_icd9_problems	pip_created_by_usr_id
_1188.patients_immunizations	pim_admin_usr_id
_1188.patients_immunizations	pim_entered_by_usr_id
_1188.patients_inventory	pinv_administered_usr_id
_1188.patients_inventory	pinv_created_by_usr_id
_1188.patients_payment_methods	patpm_usr_id
_1188.patients_popup_receivers	ppr_usr_id
_1188.patients_referrals	pref_assigned_usr_id
_1188.patients_statements	pst_usr_id
_1188.patients_stored_messages	psm_modified_usr_id
_1188.physician_order_delegation_users_map	phyodum_usr_id
_1188.physicians	phy_usr_id
_1188.pi_user_access_map	pi_access_usr_id
_1188.precerts_comments	prc_usr_id
_1188.precerts_notes	prn_usr_id
_1188.procedures_results	pres_created_usr_id
_1188.provider_access	pacc_usr_id
_1188.radiology_orders_signed	rosig_signed_by_usr_id
_1188.recalls_reasons_associations	rra_usr_id
_1188.referral_program	ref_usr_id
_1188.reports_queue	rq_usr_id
_1188.reports_schedules	rsched_usr_id
_1188.saved_filters	sfil_usr_id
_1188.schedules_exceptions	sexc_usr_id
_1188.tasks	task_created_usr_id
_1188.tasks	task_modified_usr_id
_1188.tasks	task_assign_to_usr_id
_1188.tasks_assigned_map	tamap_usr_id
_1188.tasks_assignments	taskass_assigner_usr_id
_1188.tasks_assignments	taskass_assigned_usr_id
_1188.test_codes_search_frequency	tcof_usr_id
_1188.user_preferences	upref_usr_id
_1188.users_roles	ur_usr_id
_1188.voided_payments	vp_usr_id
_1218.audits	aud_usr_id
_1218.audits	aud_spoofing_usr_id
_1218.audits	aud_web_usr_id
_1218.audits_archive	aud_usr_id
_1218.audits_archive	aud_spoofing_usr_id
_1218.audits_archive	aud_web_usr_id
_1218.audits_new	aud_usr_id
_1218.audits_new	aud_spoofing_usr_id
_1218.audits_new_archive	aud_usr_id
_1218.audits_new_archive	aud_spoofing_usr_id
_1218.billing_reports_queue	brq_usr_id
_1218.card_connect_profiles	cconp_usr_id
_1218.chart_changes	cc_usr_id
_1218.charts_care_plan	ccp_assigned_usr_id
_1218.charts_stored_notes_access	chsna_usr_id
_1218.charts_stored_notes_frequency	chsnf_usr_id
_1218.client_configs	cc_usr_id
_1218.clinical_alerts_access	caa_usr_id
_1218.clinical_interventions	ci_creator_usr_id
_1218.clinical_interventions	ci_modifier_usr_id
_1218.clinical_interventions	ci_enabler_usr_id
_1218.clinical_interventions	ci_disabler_usr_id
_1218.clinical_interventions_review_map	cirm_disabled_usr_id
_1218.clinical_interventions_review_map	cirm_creator_usr_id
_1218.clinical_interventions_users_map	cium_usr_id
_1218.closed_periods	clp_usr_id
_1218.closed_periods_daily	clpd_usr_id
_1218.daily_close_schedules	dcs_usr_id
_1218.documents_folders	dfol_usr_id
_1218.encounters_claims_files	ecf_usr_id
_1218.encounters_soap_templates_access	esta_usr_id
_1218.encounters_soap_templates_frequency	estf_usr_id
_1218.encounters_stored_notes_access	esna_usr_id
_1218.encounters_stored_notes_frequency	esnf_usr_id
_1218.encounters_stored_notes_patients_frequency	esnpf_usr_id
_1218.erx_notification_counts	erx_not_usr_id
_1218.erx_web_users	erx_users_usr_id
_1218.feature_requests	fea_usr_id
_1218.groups_members	gms_usr_id
_1218.handouts	hand_usr_id
_1218.health_maintenance_associations	hma_usr_id
_1218.invoices_periods	invper_usr_id
_1218.lab_orders_signed	losig_signed_by_usr_id
_1218.labels	lbl_usr_id
_1218.ledger	led_usr_id
_1218.models_updates	mdu_usr_id
_1218.notes	not_usr_id
_1218.notes	not_mod_usr_id
_1218.nuance_config	ncf_usr_id
_1218.patient_access_restriction	patar_usr_id
_1218.patient_amendments	pa_creator_usr_id
_1218.patient_amendments	pa_apprv_usr_id
_1218.patient_next_of_kin	pnk_created_by_usr_id
_1218.patient_portal_requests	ppr_usr_id
_1218.patients_document_assembly	pda_usr_id
_1218.patients_handouts	phs_usr_id
_1218.patients_icd9_problems	pip_diagnosed_by_usr_id
_1218.patients_icd9_problems	pip_resolved_by_usr_id
_1218.patients_icd9_problems	pip_created_by_usr_id
_1218.patients_immunizations	pim_admin_usr_id
_1218.patients_immunizations	pim_entered_by_usr_id
_1218.patients_inventory	pinv_administered_usr_id
_1218.patients_inventory	pinv_created_by_usr_id
_1218.patients_payment_methods	patpm_usr_id
_1218.patients_popup_receivers	ppr_usr_id
_1218.patients_referrals	pref_assigned_usr_id
_1218.patients_statements	pst_usr_id
_1218.patients_stored_messages	psm_modified_usr_id
_1218.physician_order_delegation_users_map	phyodum_usr_id
_1218.physicians	phy_usr_id
_1218.pi_user_access_map	pi_access_usr_id
_1218.precerts_comments	prc_usr_id
_1218.precerts_notes	prn_usr_id
_1218.procedures_results	pres_created_usr_id
_1218.provider_access	pacc_usr_id
_1218.radiology_orders_signed	rosig_signed_by_usr_id
_1218.recalls_reasons_associations	rra_usr_id
_1218.referral_program	ref_usr_id
_1218.reports_queue	rq_usr_id
_1218.reports_schedules	rsched_usr_id
_1218.saved_filters	sfil_usr_id
_1218.schedules_exceptions	sexc_usr_id
_1218.tasks	task_created_usr_id
_1218.tasks	task_modified_usr_id
_1218.tasks	task_assign_to_usr_id
_1218.tasks_assigned_map	tamap_usr_id
_1218.tasks_assignments	taskass_assigner_usr_id
_1218.tasks_assignments	taskass_assigned_usr_id
_1218.test_codes_search_frequency	tcof_usr_id
_1218.user_preferences	upref_usr_id
_1218.users_roles	ur_usr_id
_1218.voided_payments	vp_usr_id
_1548.audits	aud_usr_id
_1548.audits	aud_spoofing_usr_id
_1548.audits	aud_web_usr_id
_1548.audits_archive	aud_usr_id
_1548.audits_archive	aud_spoofing_usr_id
_1548.audits_archive	aud_web_usr_id
_1548.audits_new	aud_usr_id
_1548.audits_new	aud_spoofing_usr_id
_1548.audits_new_archive	aud_usr_id
_1548.audits_new_archive	aud_spoofing_usr_id
_1548.billing_reports_queue	brq_usr_id
_1548.card_connect_profiles	cconp_usr_id
_1548.chart_changes	cc_usr_id
_1548.charts_care_plan	ccp_assigned_usr_id
_1548.charts_stored_notes_access	chsna_usr_id
_1548.charts_stored_notes_frequency	chsnf_usr_id
_1548.client_configs	cc_usr_id
_1548.clinical_alerts_access	caa_usr_id
_1548.clinical_interventions	ci_creator_usr_id
_1548.clinical_interventions	ci_modifier_usr_id
_1548.clinical_interventions	ci_enabler_usr_id
_1548.clinical_interventions	ci_disabler_usr_id
_1548.clinical_interventions_review_map	cirm_disabled_usr_id
_1548.clinical_interventions_review_map	cirm_creator_usr_id
_1548.clinical_interventions_users_map	cium_usr_id
_1548.closed_periods	clp_usr_id
_1548.closed_periods_daily	clpd_usr_id
_1548.daily_close_schedules	dcs_usr_id
_1548.documents_folders	dfol_usr_id
_1548.encounters_claims_files	ecf_usr_id
_1548.encounters_soap_templates_access	esta_usr_id
_1548.encounters_soap_templates_frequency	estf_usr_id
_1548.encounters_stored_notes_access	esna_usr_id
_1548.encounters_stored_notes_frequency	esnf_usr_id
_1548.encounters_stored_notes_patients_frequency	esnpf_usr_id
_1548.erx_notification_counts	erx_not_usr_id
_1548.erx_web_users	erx_users_usr_id
_1548.feature_requests	fea_usr_id
_1548.groups_members	gms_usr_id
_1548.handouts	hand_usr_id
_1548.health_maintenance_associations	hma_usr_id
_1548.invoices_periods	invper_usr_id
_1548.lab_orders_signed	losig_signed_by_usr_id
_1548.labels	lbl_usr_id
_1548.ledger	led_usr_id
_1548.models_updates	mdu_usr_id
_1548.notes	not_usr_id
_1548.notes	not_mod_usr_id
_1548.nuance_config	ncf_usr_id
_1548.patient_access_restriction	patar_usr_id
_1548.patient_amendments	pa_creator_usr_id
_1548.patient_amendments	pa_apprv_usr_id
_1548.patient_next_of_kin	pnk_created_by_usr_id
_1548.patient_portal_requests	ppr_usr_id
_1548.patients_document_assembly	pda_usr_id
_1548.patients_handouts	phs_usr_id
_1548.patients_icd9_problems	pip_diagnosed_by_usr_id
_1548.patients_icd9_problems	pip_resolved_by_usr_id
_1548.patients_icd9_problems	pip_created_by_usr_id
_1548.patients_immunizations	pim_admin_usr_id
_1548.patients_immunizations	pim_entered_by_usr_id
_1548.patients_inventory	pinv_administered_usr_id
_1548.patients_inventory	pinv_created_by_usr_id
_1548.patients_payment_methods	patpm_usr_id
_1548.patients_popup_receivers	ppr_usr_id
_1548.patients_referrals	pref_assigned_usr_id
_1548.patients_statements	pst_usr_id
_1548.patients_stored_messages	psm_modified_usr_id
_1548.physician_order_delegation_users_map	phyodum_usr_id
_1548.physicians	phy_usr_id
_1548.pi_user_access_map	pi_access_usr_id
_1548.precerts_comments	prc_usr_id
_1548.precerts_notes	prn_usr_id
_1548.procedures_results	pres_created_usr_id
_1548.provider_access	pacc_usr_id
_1548.radiology_orders_signed	rosig_signed_by_usr_id
_1548.recalls_reasons_associations	rra_usr_id
_1548.referral_program	ref_usr_id
_1548.reports_queue	rq_usr_id
_1548.reports_schedules	rsched_usr_id
_1548.saved_filters	sfil_usr_id
_1548.schedules_exceptions	sexc_usr_id
_1548.tasks	task_created_usr_id
_1548.tasks	task_modified_usr_id
_1548.tasks	task_assign_to_usr_id
_1548.tasks_assigned_map	tamap_usr_id
_1548.tasks_assignments	taskass_assigner_usr_id
_1548.tasks_assignments	taskass_assigned_usr_id
_1548.test_codes_search_frequency	tcof_usr_id
_1548.user_preferences	upref_usr_id
_1548.users_roles	ur_usr_id
_1548.voided_payments	vp_usr_id
_435.audits	aud_usr_id
_435.audits	aud_spoofing_usr_id
_435.audits	aud_web_usr_id
_435.audits_archive	aud_usr_id
_435.audits_archive	aud_spoofing_usr_id
_435.audits_archive	aud_web_usr_id
_435.audits_archive_2008	aud_usr_id
_435.audits_archive_2008	aud_spoofing_usr_id
_435.audits_archive_2009	aud_usr_id
_435.audits_archive_2009	aud_spoofing_usr_id
_435.audits_archive_2010	aud_usr_id
_435.audits_archive_2010	aud_spoofing_usr_id
_435.audits_archive_2011	aud_usr_id
_435.audits_archive_2011	aud_spoofing_usr_id
_435.audits_archive_2012	aud_usr_id
_435.audits_archive_2012	aud_spoofing_usr_id
_435.audits_archive_2013	aud_usr_id
_435.audits_archive_2013	aud_spoofing_usr_id
_435.audits_archive_2014	aud_usr_id
_435.audits_archive_2014	aud_spoofing_usr_id
_435.audits_archive_2015	aud_usr_id
_435.audits_archive_2015	aud_spoofing_usr_id
_435.audits_archive_2016	aud_usr_id
_435.audits_archive_2016	aud_spoofing_usr_id
_435.audits_archive_2017	aud_usr_id
_435.audits_archive_2017	aud_spoofing_usr_id
_435.audits_archive_2018	aud_usr_id
_435.audits_archive_2018	aud_spoofing_usr_id
_435.audits_archive_2019	aud_usr_id
_435.audits_archive_2019	aud_spoofing_usr_id
_435.audits_archive_2020	aud_usr_id
_435.audits_archive_2020	aud_spoofing_usr_id
_435.audits_new	aud_usr_id
_435.audits_new	aud_spoofing_usr_id
_435.audits_new_archive	aud_usr_id
_435.audits_new_archive	aud_spoofing_usr_id
_435.audits_new_trial	aud_usr_id
_435.audits_new_trial	aud_spoofing_usr_id
_435.audits_users	audusr_usr_id
_435.billing_reports_queue	brq_usr_id
_435.card_connect_profiles	cconp_usr_id
_435.chart_changes	cc_usr_id
_435.charts_care_plan	ccp_assigned_usr_id
_435.charts_stored_notes_access	chsna_usr_id
_435.charts_stored_notes_frequency	chsnf_usr_id
_435.client_configs	cc_usr_id
_435.clinical_alerts_access	caa_usr_id
_435.clinical_interventions	ci_creator_usr_id
_435.clinical_interventions	ci_modifier_usr_id
_435.clinical_interventions	ci_enabler_usr_id
_435.clinical_interventions	ci_disabler_usr_id
_435.clinical_interventions_review_map	cirm_disabled_usr_id
_435.clinical_interventions_review_map	cirm_creator_usr_id
_435.clinical_interventions_users_map	cium_usr_id
_435.closed_periods	clp_usr_id
_435.closed_periods_daily	clpd_usr_id
_435.daily_close_schedules	dcs_usr_id
_435.documents_folders	dfol_usr_id
_435.encounters_claims_files	ecf_usr_id
_435.encounters_soap_templates_access	esta_usr_id
_435.encounters_soap_templates_frequency	estf_usr_id
_435.encounters_stored_notes_access	esna_usr_id
_435.encounters_stored_notes_frequency	esnf_usr_id
_435.encounters_stored_notes_patients_frequency	esnpf_usr_id
_435.erx_notification_counts	erx_not_usr_id
_435.erx_web_users	erx_users_usr_id
_435.feature_requests	fea_usr_id
_435.groups_members	gms_usr_id
_435.handouts	hand_usr_id
_435.health_maintenance_associations	hma_usr_id
_435.invoices_periods	invper_usr_id
_435.lab_orders_signed	losig_signed_by_usr_id
_435.labels	lbl_usr_id
_435.ledger	led_usr_id
_435.models_updates	mdu_usr_id
_435.notes	not_usr_id
_435.notes	not_mod_usr_id
_435.nuance_config	ncf_usr_id
_435.patient_access_restriction	patar_usr_id
_435.patient_amendments	pa_creator_usr_id
_435.patient_amendments	pa_apprv_usr_id
_435.patient_next_of_kin	pnk_created_by_usr_id
_435.patient_portal_requests	ppr_usr_id
_435.patients_document_assembly	pda_usr_id
_435.patients_handouts	phs_usr_id
_435.patients_icd9_problems	pip_diagnosed_by_usr_id
_435.patients_icd9_problems	pip_resolved_by_usr_id
_435.patients_icd9_problems	pip_created_by_usr_id
_435.patients_immunizations	pim_admin_usr_id
_435.patients_immunizations	pim_entered_by_usr_id
_435.patients_inventory	pinv_administered_usr_id
_435.patients_inventory	pinv_created_by_usr_id
_435.patients_payment_methods	patpm_usr_id
_435.patients_popup_receivers	ppr_usr_id
_435.patients_referrals	pref_assigned_usr_id
_435.patients_statements	pst_usr_id
_435.patients_stored_messages	psm_modified_usr_id
_435.physician_order_delegation_users_map	phyodum_usr_id
_435.physicians	phy_usr_id
_435.pi_user_access_map	pi_access_usr_id
_435.precerts_comments	prc_usr_id
_435.precerts_notes	prn_usr_id
_435.procedures_results	pres_created_usr_id
_435.provider_access	pacc_usr_id
_435.radiology_orders_signed	rosig_signed_by_usr_id
_435.recalls_reasons_associations	rra_usr_id
_435.referral_program	ref_usr_id
_435.reports_queue	rq_usr_id
_435.reports_schedules	rsched_usr_id
_435.saved_filters	sfil_usr_id
_435.schedules_exceptions	sexc_usr_id
_435.tasks	task_created_usr_id
_435.tasks	task_modified_usr_id
_435.tasks	task_assign_to_usr_id
_435.tasks_assigned_map	tamap_usr_id
_435.tasks_assignments	taskass_assigner_usr_id
_435.tasks_assignments	taskass_assigned_usr_id
_435.test_codes_search_frequency	tcof_usr_id
_435.user_preferences	upref_usr_id
_435.users_roles	ur_usr_id
_435.voided_payments	vp_usr_id
_436.audits	aud_usr_id
_436.audits	aud_spoofing_usr_id
_436.audits	aud_web_usr_id
_436.audits_archive	aud_usr_id
_436.audits_archive	aud_spoofing_usr_id
_436.audits_archive	aud_web_usr_id
_436.audits_new	aud_usr_id
_436.audits_new	aud_spoofing_usr_id
_436.audits_new_archive	aud_usr_id
_436.audits_new_archive	aud_spoofing_usr_id
_436.audits_users	audusr_usr_id
_436.billing_reports_queue	brq_usr_id
_436.card_connect_profiles	cconp_usr_id
_436.chart_changes	cc_usr_id
_436.charts_care_plan	ccp_assigned_usr_id
_436.charts_stored_notes_access	chsna_usr_id
_436.charts_stored_notes_frequency	chsnf_usr_id
_436.client_configs	cc_usr_id
_436.clinical_alerts_access	caa_usr_id
_436.clinical_interventions	ci_creator_usr_id
_436.clinical_interventions	ci_modifier_usr_id
_436.clinical_interventions	ci_enabler_usr_id
_436.clinical_interventions	ci_disabler_usr_id
_436.clinical_interventions_review_map	cirm_disabled_usr_id
_436.clinical_interventions_review_map	cirm_creator_usr_id
_436.clinical_interventions_users_map	cium_usr_id
_436.closed_periods	clp_usr_id
_436.closed_periods_daily	clpd_usr_id
_436.daily_close_schedules	dcs_usr_id
_436.documents_folders	dfol_usr_id
_436.encounters_claims_files	ecf_usr_id
_436.encounters_soap_templates_access	esta_usr_id
_436.encounters_soap_templates_frequency	estf_usr_id
_436.encounters_stored_notes_access	esna_usr_id
_436.encounters_stored_notes_frequency	esnf_usr_id
_436.encounters_stored_notes_patients_frequency	esnpf_usr_id
_436.erx_notification_counts	erx_not_usr_id
_436.erx_web_users	erx_users_usr_id
_436.feature_requests	fea_usr_id
_436.groups_members	gms_usr_id
_436.handouts	hand_usr_id
_436.health_maintenance_associations	hma_usr_id
_436.invoices_periods	invper_usr_id
_436.lab_orders_signed	losig_signed_by_usr_id
_436.labels	lbl_usr_id
_436.ledger	led_usr_id
_436.models_updates	mdu_usr_id
_436.notes	not_usr_id
_436.notes	not_mod_usr_id
_436.nuance_config	ncf_usr_id
_436.patient_access_restriction	patar_usr_id
_436.patient_amendments	pa_creator_usr_id
_436.patient_amendments	pa_apprv_usr_id
_436.patient_next_of_kin	pnk_created_by_usr_id
_436.patient_portal_requests	ppr_usr_id
_436.patients_document_assembly	pda_usr_id
_436.patients_handouts	phs_usr_id
_436.patients_icd9_problems	pip_diagnosed_by_usr_id
_436.patients_icd9_problems	pip_resolved_by_usr_id
_436.patients_icd9_problems	pip_created_by_usr_id
_436.patients_immunizations	pim_admin_usr_id
_436.patients_immunizations	pim_entered_by_usr_id
_436.patients_inventory	pinv_administered_usr_id
_436.patients_inventory	pinv_created_by_usr_id
_436.patients_payment_methods	patpm_usr_id
_436.patients_popup_receivers	ppr_usr_id
_436.patients_referrals	pref_assigned_usr_id
_436.patients_statements	pst_usr_id
_436.patients_stored_messages	psm_modified_usr_id
_436.physician_order_delegation_users_map	phyodum_usr_id
_436.physicians	phy_usr_id
_436.pi_user_access_map	pi_access_usr_id
_436.precerts_comments	prc_usr_id
_436.precerts_notes	prn_usr_id
_436.procedures_results	pres_created_usr_id
_436.provider_access	pacc_usr_id
_436.radiology_orders_signed	rosig_signed_by_usr_id
_436.recalls_reasons_associations	rra_usr_id
_436.referral_program	ref_usr_id
_436.reports_queue	rq_usr_id
_436.reports_schedules	rsched_usr_id
_436.saved_filters	sfil_usr_id
_436.schedules_exceptions	sexc_usr_id
_436.tasks	task_created_usr_id
_436.tasks	task_modified_usr_id
_436.tasks	task_assign_to_usr_id
_436.tasks_assigned_map	tamap_usr_id
_436.tasks_assignments	taskass_assigner_usr_id
_436.tasks_assignments	taskass_assigned_usr_id
_436.test_codes_search_frequency	tcof_usr_id
_436.user_preferences	upref_usr_id
_436.users_roles	ur_usr_id
_436.voided_payments	vp_usr_id
_436_archive_testing.audits	aud_usr_id
_436_archive_testing.audits	aud_spoofing_usr_id
_436_archive_testing.audits	aud_web_usr_id
_436_archive_testing.audits_archive	aud_usr_id
_436_archive_testing.audits_archive	aud_spoofing_usr_id
_436_archive_testing.audits_archive	aud_web_usr_id
_436_archive_testing.audits_archive_2008	aud_usr_id
_436_archive_testing.audits_archive_2008	aud_spoofing_usr_id
_436_archive_testing.audits_archive_2009	aud_usr_id
_436_archive_testing.audits_archive_2009	aud_spoofing_usr_id
_436_archive_testing.audits_archive_2010	aud_usr_id
_436_archive_testing.audits_archive_2010	aud_spoofing_usr_id
_436_archive_testing.audits_archive_2011	aud_usr_id
_436_archive_testing.audits_archive_2011	aud_spoofing_usr_id
_436_archive_testing.audits_archive_2012	aud_usr_id
_436_archive_testing.audits_archive_2012	aud_spoofing_usr_id
_436_archive_testing.audits_archive_2013	aud_usr_id
_436_archive_testing.audits_archive_2013	aud_spoofing_usr_id
_436_archive_testing.audits_archive_2014	aud_usr_id
_436_archive_testing.audits_archive_2014	aud_spoofing_usr_id
_436_archive_testing.audits_archive_2015	aud_usr_id
_436_archive_testing.audits_archive_2015	aud_spoofing_usr_id
_436_archive_testing.audits_archive_2016	aud_usr_id
_436_archive_testing.audits_archive_2016	aud_spoofing_usr_id
_436_archive_testing.audits_archive_2017	aud_usr_id
_436_archive_testing.audits_archive_2017	aud_spoofing_usr_id
_436_archive_testing.audits_archive_2018	aud_usr_id
_436_archive_testing.audits_archive_2018	aud_spoofing_usr_id
_436_archive_testing.audits_archive_2019	aud_usr_id
_436_archive_testing.audits_archive_2019	aud_spoofing_usr_id
_436_archive_testing.audits_archive_2020	aud_usr_id
_436_archive_testing.audits_archive_2020	aud_spoofing_usr_id
_436_archive_testing.audits_archive_2021	aud_usr_id
_436_archive_testing.audits_archive_2021	aud_spoofing_usr_id
_436_archive_testing.audits_new	aud_usr_id
_436_archive_testing.audits_new	aud_spoofing_usr_id
_436_archive_testing.audits_new_archive	aud_usr_id
_436_archive_testing.audits_new_archive	aud_spoofing_usr_id
_436_archive_testing.audits_users	audusr_usr_id
_436_archive_testing.billing_reports_queue	brq_usr_id
_436_archive_testing.card_connect_profiles	cconp_usr_id
_436_archive_testing.chart_changes	cc_usr_id
_436_archive_testing.charts_care_plan	ccp_assigned_usr_id
_436_archive_testing.charts_stored_notes_access	chsna_usr_id
_436_archive_testing.charts_stored_notes_frequency	chsnf_usr_id
_436_archive_testing.client_configs	cc_usr_id
_436_archive_testing.clinical_alerts_access	caa_usr_id
_436_archive_testing.clinical_interventions	ci_creator_usr_id
_436_archive_testing.clinical_interventions	ci_modifier_usr_id
_436_archive_testing.clinical_interventions	ci_enabler_usr_id
_436_archive_testing.clinical_interventions	ci_disabler_usr_id
_436_archive_testing.clinical_interventions_review_map	cirm_disabled_usr_id
_436_archive_testing.clinical_interventions_review_map	cirm_creator_usr_id
_436_archive_testing.clinical_interventions_users_map	cium_usr_id
_436_archive_testing.closed_periods	clp_usr_id
_436_archive_testing.closed_periods_daily	clpd_usr_id
_436_archive_testing.daily_close_schedules	dcs_usr_id
_436_archive_testing.documents_folders	dfol_usr_id
_436_archive_testing.encounters_claims_files	ecf_usr_id
_436_archive_testing.encounters_soap_templates_access	esta_usr_id
_436_archive_testing.encounters_soap_templates_frequency	estf_usr_id
_436_archive_testing.encounters_stored_notes_access	esna_usr_id
_436_archive_testing.encounters_stored_notes_frequency	esnf_usr_id
_436_archive_testing.encounters_stored_notes_patients_frequency	esnpf_usr_id
_436_archive_testing.erx_notification_counts	erx_not_usr_id
_436_archive_testing.erx_web_users	erx_users_usr_id
_436_archive_testing.feature_requests	fea_usr_id
_436_archive_testing.groups_members	gms_usr_id
_436_archive_testing.handouts	hand_usr_id
_436_archive_testing.health_maintenance_associations	hma_usr_id
_436_archive_testing.invoices_periods	invper_usr_id
_436_archive_testing.lab_orders_signed	losig_signed_by_usr_id
_436_archive_testing.labels	lbl_usr_id
_436_archive_testing.ledger	led_usr_id
_436_archive_testing.models_updates	mdu_usr_id
_436_archive_testing.notes	not_usr_id
_436_archive_testing.notes	not_mod_usr_id
_436_archive_testing.nuance_config	ncf_usr_id
_436_archive_testing.patient_access_restriction	patar_usr_id
_436_archive_testing.patient_amendments	pa_creator_usr_id
_436_archive_testing.patient_amendments	pa_apprv_usr_id
_436_archive_testing.patient_next_of_kin	pnk_created_by_usr_id
_436_archive_testing.patient_portal_requests	ppr_usr_id
_436_archive_testing.patients_document_assembly	pda_usr_id
_436_archive_testing.patients_handouts	phs_usr_id
_436_archive_testing.patients_immunizations	pim_admin_usr_id
_436_archive_testing.patients_immunizations	pim_entered_by_usr_id
_436_archive_testing.patients_inventory	pinv_administered_usr_id
_436_archive_testing.patients_inventory	pinv_created_by_usr_id
_436_archive_testing.patients_payment_methods	patpm_usr_id
_436_archive_testing.patients_popup_receivers	ppr_usr_id
_436_archive_testing.patients_referrals	pref_assigned_usr_id
_436_archive_testing.patients_statements	pst_usr_id
_436_archive_testing.patients_stored_messages	psm_modified_usr_id
_436_archive_testing.physician_order_delegation_users_map	phyodum_usr_id
_436_archive_testing.physicians	phy_usr_id
_436_archive_testing.pi_user_access_map	pi_access_usr_id
_436_archive_testing.precerts_comments	prc_usr_id
_436_archive_testing.precerts_notes	prn_usr_id
_436_archive_testing.procedures_results	pres_created_usr_id
_436_archive_testing.provider_access	pacc_usr_id
_436_archive_testing.radiology_orders_signed	rosig_signed_by_usr_id
_436_archive_testing.recalls_reasons_associations	rra_usr_id
_436_archive_testing.referral_program	ref_usr_id
_436_archive_testing.reports_queue	rq_usr_id
_436_archive_testing.reports_schedules	rsched_usr_id
_436_archive_testing.saved_filters	sfil_usr_id
_436_archive_testing.schedules_exceptions	sexc_usr_id
_436_archive_testing.tasks	task_created_usr_id
_436_archive_testing.tasks	task_modified_usr_id
_436_archive_testing.tasks	task_assign_to_usr_id
_436_archive_testing.tasks_assigned_map	tamap_usr_id
_436_archive_testing.tasks_assignments	taskass_assigner_usr_id
_436_archive_testing.tasks_assignments	taskass_assigned_usr_id
_436_archive_testing.test_codes_search_frequency	tcof_usr_id
_436_archive_testing.user_preferences	upref_usr_id
_436_archive_testing.users_roles	ur_usr_id
_436_archive_testing.voided_payments	vp_usr_id
_437.audits	aud_usr_id
_437.audits	aud_spoofing_usr_id
_437.audits	aud_web_usr_id
_437.audits_archive	aud_usr_id
_437.audits_archive	aud_spoofing_usr_id
_437.audits_archive	aud_web_usr_id
_437.audits_new	aud_usr_id
_437.audits_new	aud_spoofing_usr_id
_437.audits_new_archive	aud_usr_id
_437.audits_new_archive	aud_spoofing_usr_id
_437.audits_users	audusr_usr_id
_437.billing_reports_queue	brq_usr_id
_437.card_connect_profiles	cconp_usr_id
_437.chart_changes	cc_usr_id
_437.charts_care_plan	ccp_assigned_usr_id
_437.charts_stored_notes_access	chsna_usr_id
_437.charts_stored_notes_frequency	chsnf_usr_id
_437.client_configs	cc_usr_id
_437.clinical_alerts_access	caa_usr_id
_437.clinical_interventions	ci_creator_usr_id
_437.clinical_interventions	ci_modifier_usr_id
_437.clinical_interventions	ci_enabler_usr_id
_437.clinical_interventions	ci_disabler_usr_id
_437.clinical_interventions_review_map	cirm_disabled_usr_id
_437.clinical_interventions_review_map	cirm_creator_usr_id
_437.clinical_interventions_users_map	cium_usr_id
_437.closed_periods	clp_usr_id
_437.closed_periods_daily	clpd_usr_id
_437.daily_close_schedules	dcs_usr_id
_437.documents_folders	dfol_usr_id
_437.encounters_claims_files	ecf_usr_id
_437.encounters_soap_templates_access	esta_usr_id
_437.encounters_soap_templates_frequency	estf_usr_id
_437.encounters_stored_notes_access	esna_usr_id
_437.encounters_stored_notes_frequency	esnf_usr_id
_437.encounters_stored_notes_patients_frequency	esnpf_usr_id
_437.erx_notification_counts	erx_not_usr_id
_437.erx_web_users	erx_users_usr_id
_437.feature_requests	fea_usr_id
_437.groups_members	gms_usr_id
_437.handouts	hand_usr_id
_437.health_maintenance_associations	hma_usr_id
_437.invoices_periods	invper_usr_id
_437.lab_orders_signed	losig_signed_by_usr_id
_437.labels	lbl_usr_id
_437.ledger	led_usr_id
_437.models_updates	mdu_usr_id
_437.notes	not_usr_id
_437.notes	not_mod_usr_id
_437.nuance_config	ncf_usr_id
_437.patient_access_restriction	patar_usr_id
_437.patient_amendments	pa_creator_usr_id
_437.patient_amendments	pa_apprv_usr_id
_437.patient_next_of_kin	pnk_created_by_usr_id
_437.patient_portal_requests	ppr_usr_id
_437.patients_document_assembly	pda_usr_id
_437.patients_handouts	phs_usr_id
_437.patients_icd9_problems	pip_diagnosed_by_usr_id
_437.patients_icd9_problems	pip_resolved_by_usr_id
_437.patients_icd9_problems	pip_created_by_usr_id
_437.patients_immunizations	pim_admin_usr_id
_437.patients_immunizations	pim_entered_by_usr_id
_437.patients_inventory	pinv_administered_usr_id
_437.patients_inventory	pinv_created_by_usr_id
_437.patients_payment_methods	patpm_usr_id
_437.patients_popup_receivers	ppr_usr_id
_437.patients_referrals	pref_assigned_usr_id
_437.patients_statements	pst_usr_id
_437.patients_stored_messages	psm_modified_usr_id
_437.physician_order_delegation_users_map	phyodum_usr_id
_437.physicians	phy_usr_id
_437.pi_user_access_map	pi_access_usr_id
_437.precerts_comments	prc_usr_id
_437.precerts_notes	prn_usr_id
_437.procedures_results	pres_created_usr_id
_437.provider_access	pacc_usr_id
_437.radiology_orders_signed	rosig_signed_by_usr_id
_437.recalls_reasons_associations	rra_usr_id
_437.referral_program	ref_usr_id
_437.reports_queue	rq_usr_id
_437.reports_schedules	rsched_usr_id
_437.saved_filters	sfil_usr_id
_437.schedules_exceptions	sexc_usr_id
_437.tasks	task_created_usr_id
_437.tasks	task_modified_usr_id
_437.tasks	task_assign_to_usr_id
_437.tasks_assigned_map	tamap_usr_id
_437.tasks_assignments	taskass_assigner_usr_id
_437.tasks_assignments	taskass_assigned_usr_id
_437.test_codes_search_frequency	tcof_usr_id
_437.user_preferences	upref_usr_id
_437.users_roles	ur_usr_id
_437.voided_payments	vp_usr_id
_8.audits	aud_usr_id
_8.audits	aud_spoofing_usr_id
_8.audits	aud_web_usr_id
_8.audits_archive	aud_usr_id
_8.audits_archive	aud_spoofing_usr_id
_8.audits_archive	aud_web_usr_id
_8.audits_archive_2020	aud_usr_id
_8.audits_archive_2020	aud_spoofing_usr_id
_8.audits_new	aud_usr_id
_8.audits_new	aud_spoofing_usr_id
_8.audits_new_archive	aud_usr_id
_8.audits_new_archive	aud_spoofing_usr_id
_8.billing_reports_queue	brq_usr_id
_8.card_connect_profiles	cconp_usr_id
_8.chart_changes	cc_usr_id
_8.charts_care_plan	ccp_assigned_usr_id
_8.charts_stored_notes_access	chsna_usr_id
_8.charts_stored_notes_frequency	chsnf_usr_id
_8.client_configs	cc_usr_id
_8.clinical_alerts_access	caa_usr_id
_8.clinical_interventions	ci_creator_usr_id
_8.clinical_interventions	ci_modifier_usr_id
_8.clinical_interventions	ci_enabler_usr_id
_8.clinical_interventions	ci_disabler_usr_id
_8.clinical_interventions_review_map	cirm_disabled_usr_id
_8.clinical_interventions_review_map	cirm_creator_usr_id
_8.clinical_interventions_users_map	cium_usr_id
_8.closed_periods	clp_usr_id
_8.closed_periods_daily	clpd_usr_id
_8.daily_close_schedules	dcs_usr_id
_8.documents_folders	dfol_usr_id
_8.encounters_claims_files	ecf_usr_id
_8.encounters_soap_templates_access	esta_usr_id
_8.encounters_soap_templates_frequency	estf_usr_id
_8.encounters_stored_notes_access	esna_usr_id
_8.encounters_stored_notes_frequency	esnf_usr_id
_8.encounters_stored_notes_patients_frequency	esnpf_usr_id
_8.erx_notification_counts	erx_not_usr_id
_8.erx_web_users	erx_users_usr_id
_8.feature_requests	fea_usr_id
_8.groups_members	gms_usr_id
_8.handouts	hand_usr_id
_8.health_maintenance_associations	hma_usr_id
_8.invoices_periods	invper_usr_id
_8.lab_orders_signed	losig_signed_by_usr_id
_8.labels	lbl_usr_id
_8.ledger	led_usr_id
_8.models_updates	mdu_usr_id
_8.notes	not_usr_id
_8.notes	not_mod_usr_id
_8.nuance_config	ncf_usr_id
_8.patient_access_restriction	patar_usr_id
_8.patient_amendments	pa_creator_usr_id
_8.patient_amendments	pa_apprv_usr_id
_8.patient_next_of_kin	pnk_created_by_usr_id
_8.patient_portal_requests	ppr_usr_id
_8.patients_document_assembly	pda_usr_id
_8.patients_handouts	phs_usr_id
_8.patients_icd9_problems	pip_diagnosed_by_usr_id
_8.patients_icd9_problems	pip_resolved_by_usr_id
_8.patients_icd9_problems	pip_created_by_usr_id
_8.patients_immunizations	pim_admin_usr_id
_8.patients_immunizations	pim_entered_by_usr_id
_8.patients_inventory	pinv_administered_usr_id
_8.patients_inventory	pinv_created_by_usr_id
_8.patients_payment_methods	patpm_usr_id
_8.patients_popup_receivers	ppr_usr_id
_8.patients_referrals	pref_assigned_usr_id
_8.patients_statements	pst_usr_id
_8.patients_stored_messages	psm_modified_usr_id
_8.physician_order_delegation_users_map	phyodum_usr_id
_8.physicians	phy_usr_id
_8.pi_user_access_map	pi_access_usr_id
_8.precerts_comments	prc_usr_id
_8.precerts_notes	prn_usr_id
_8.procedures_results	pres_created_usr_id
_8.provider_access	pacc_usr_id
_8.radiology_orders_signed	rosig_signed_by_usr_id
_8.recalls_reasons_associations	rra_usr_id
_8.referral_program	ref_usr_id
_8.reports_queue	rq_usr_id
_8.reports_schedules	rsched_usr_id
_8.saved_filters	sfil_usr_id
_8.schedules_exceptions	sexc_usr_id
_8.tasks	task_created_usr_id
_8.tasks	task_modified_usr_id
_8.tasks	task_assign_to_usr_id
_8.tasks_assigned_map	tamap_usr_id
_8.tasks_assignments	taskass_assigner_usr_id
_8.tasks_assignments	taskass_assigned_usr_id
_8.test_codes_search_frequency	tcof_usr_id
_8.user_preferences	upref_usr_id
_8.users_roles	ur_usr_id
_8.voided_payments	vp_usr_id
_81.audits	aud_usr_id
_81.audits	aud_spoofing_usr_id
_81.audits	aud_web_usr_id
_81.audits_archive	aud_usr_id
_81.audits_archive	aud_spoofing_usr_id
_81.audits_archive	aud_web_usr_id
_81.audits_new	aud_usr_id
_81.audits_new	aud_spoofing_usr_id
_81.audits_new_archive	aud_usr_id
_81.audits_new_archive	aud_spoofing_usr_id
_81.billing_reports_queue	brq_usr_id
_81.card_connect_profiles	cconp_usr_id
_81.chart_changes	cc_usr_id
_81.charts_care_plan	ccp_assigned_usr_id
_81.charts_stored_notes_access	chsna_usr_id
_81.charts_stored_notes_frequency	chsnf_usr_id
_81.client_configs	cc_usr_id
_81.clinical_alerts_access	caa_usr_id
_81.clinical_interventions	ci_creator_usr_id
_81.clinical_interventions	ci_modifier_usr_id
_81.clinical_interventions	ci_enabler_usr_id
_81.clinical_interventions	ci_disabler_usr_id
_81.clinical_interventions_review_map	cirm_disabled_usr_id
_81.clinical_interventions_review_map	cirm_creator_usr_id
_81.clinical_interventions_users_map	cium_usr_id
_81.closed_periods	clp_usr_id
_81.closed_periods_daily	clpd_usr_id
_81.daily_close_schedules	dcs_usr_id
_81.documents_folders	dfol_usr_id
_81.encounters_claims_files	ecf_usr_id
_81.encounters_soap_templates_access	esta_usr_id
_81.encounters_soap_templates_frequency	estf_usr_id
_81.encounters_stored_notes_access	esna_usr_id
_81.encounters_stored_notes_frequency	esnf_usr_id
_81.encounters_stored_notes_patients_frequency	esnpf_usr_id
_81.erx_notification_counts	erx_not_usr_id
_81.erx_web_users	erx_users_usr_id
_81.feature_requests	fea_usr_id
_81.groups_members	gms_usr_id
_81.handouts	hand_usr_id
_81.health_maintenance_associations	hma_usr_id
_81.invoices_periods	invper_usr_id
_81.lab_orders_signed	losig_signed_by_usr_id
_81.labels	lbl_usr_id
_81.ledger	led_usr_id
_81.models_updates	mdu_usr_id
_81.notes	not_usr_id
_81.notes	not_mod_usr_id
_81.nuance_config	ncf_usr_id
_81.patient_access_restriction	patar_usr_id
_81.patient_amendments	pa_creator_usr_id
_81.patient_amendments	pa_apprv_usr_id
_81.patient_next_of_kin	pnk_created_by_usr_id
_81.patient_portal_requests	ppr_usr_id
_81.patients_document_assembly	pda_usr_id
_81.patients_handouts	phs_usr_id
_81.patients_icd9_problems	pip_diagnosed_by_usr_id
_81.patients_icd9_problems	pip_resolved_by_usr_id
_81.patients_icd9_problems	pip_created_by_usr_id
_81.patients_immunizations	pim_admin_usr_id
_81.patients_immunizations	pim_entered_by_usr_id
_81.patients_inventory	pinv_administered_usr_id
_81.patients_inventory	pinv_created_by_usr_id
_81.patients_payment_methods	patpm_usr_id
_81.patients_popup_receivers	ppr_usr_id
_81.patients_referrals	pref_assigned_usr_id
_81.patients_statements	pst_usr_id
_81.patients_stored_messages	psm_modified_usr_id
_81.physician_order_delegation_users_map	phyodum_usr_id
_81.physicians	phy_usr_id
_81.pi_user_access_map	pi_access_usr_id
_81.precerts_comments	prc_usr_id
_81.precerts_notes	prn_usr_id
_81.procedures_results	pres_created_usr_id
_81.provider_access	pacc_usr_id
_81.radiology_orders_signed	rosig_signed_by_usr_id
_81.recalls_reasons_associations	rra_usr_id
_81.referral_program	ref_usr_id
_81.reports_queue	rq_usr_id
_81.reports_schedules	rsched_usr_id
_81.saved_filters	sfil_usr_id
_81.schedules_exceptions	sexc_usr_id
_81.tasks	task_created_usr_id
_81.tasks	task_modified_usr_id
_81.tasks	task_assign_to_usr_id
_81.tasks_assigned_map	tamap_usr_id
_81.tasks_assignments	taskass_assigner_usr_id
_81.tasks_assignments	taskass_assigned_usr_id
_81.test_codes_search_frequency	tcof_usr_id
_81.user_preferences	upref_usr_id
_81.users_roles	ur_usr_id
_81.voided_payments	vp_usr_id
_999.audits	aud_usr_id
_999.audits	aud_spoofing_usr_id
_999.audits	aud_web_usr_id
_999.audits_archive	aud_usr_id
_999.audits_archive	aud_spoofing_usr_id
_999.audits_archive	aud_web_usr_id
_999.audits_new	aud_usr_id
_999.audits_new	aud_spoofing_usr_id
_999.audits_new_archive	aud_usr_id
_999.audits_new_archive	aud_spoofing_usr_id
_999.billing_reports_queue	brq_usr_id
_999.card_connect_profiles	cconp_usr_id
_999.chart_changes	cc_usr_id
_999.charts_care_plan	ccp_assigned_usr_id
_999.charts_stored_notes_access	chsna_usr_id
_999.charts_stored_notes_frequency	chsnf_usr_id
_999.client_configs	cc_usr_id
_999.clinical_alerts_access	caa_usr_id
_999.clinical_interventions	ci_creator_usr_id
_999.clinical_interventions	ci_modifier_usr_id
_999.clinical_interventions	ci_enabler_usr_id
_999.clinical_interventions	ci_disabler_usr_id
_999.clinical_interventions_review_map	cirm_disabled_usr_id
_999.clinical_interventions_review_map	cirm_creator_usr_id
_999.clinical_interventions_users_map	cium_usr_id
_999.closed_periods	clp_usr_id
_999.closed_periods_daily	clpd_usr_id
_999.daily_close_schedules	dcs_usr_id
_999.documents_folders	dfol_usr_id
_999.encounters_claims_files	ecf_usr_id
_999.encounters_soap_templates_access	esta_usr_id
_999.encounters_soap_templates_frequency	estf_usr_id
_999.encounters_stored_notes_access	esna_usr_id
_999.encounters_stored_notes_frequency	esnf_usr_id
_999.encounters_stored_notes_patients_frequency	esnpf_usr_id
_999.erx_notification_counts	erx_not_usr_id
_999.erx_web_users	erx_users_usr_id
_999.feature_requests	fea_usr_id
_999.groups_members	gms_usr_id
_999.handouts	hand_usr_id
_999.health_maintenance_associations	hma_usr_id
_999.invoices_periods	invper_usr_id
_999.lab_orders_signed	losig_signed_by_usr_id
_999.labels	lbl_usr_id
_999.ledger	led_usr_id
_999.models_updates	mdu_usr_id
_999.notes	not_usr_id
_999.notes	not_mod_usr_id
_999.nuance_config	ncf_usr_id
_999.patient_access_restriction	patar_usr_id
_999.patient_amendments	pa_creator_usr_id
_999.patient_amendments	pa_apprv_usr_id
_999.patient_next_of_kin	pnk_created_by_usr_id
_999.patient_portal_requests	ppr_usr_id
_999.patients_document_assembly	pda_usr_id
_999.patients_handouts	phs_usr_id
_999.patients_icd9_problems	pip_diagnosed_by_usr_id
_999.patients_icd9_problems	pip_resolved_by_usr_id
_999.patients_icd9_problems	pip_created_by_usr_id
_999.patients_immunizations	pim_admin_usr_id
_999.patients_immunizations	pim_entered_by_usr_id
_999.patients_inventory	pinv_administered_usr_id
_999.patients_inventory	pinv_created_by_usr_id
_999.patients_payment_methods	patpm_usr_id
_999.patients_popup_receivers	ppr_usr_id
_999.patients_referrals	pref_assigned_usr_id
_999.patients_statements	pst_usr_id
_999.patients_stored_messages	psm_modified_usr_id
_999.physician_order_delegation_users_map	phyodum_usr_id
_999.physicians	phy_usr_id
_999.pi_user_access_map	pi_access_usr_id
_999.precerts_comments	prc_usr_id
_999.precerts_notes	prn_usr_id
_999.procedures_results	pres_created_usr_id
_999.provider_access	pacc_usr_id
_999.radiology_orders_signed	rosig_signed_by_usr_id
_999.recalls_reasons_associations	rra_usr_id
_999.referral_program	ref_usr_id
_999.reports_queue	rq_usr_id
_999.reports_schedules	rsched_usr_id
_999.saved_filters	sfil_usr_id
_999.schedules_exceptions	sexc_usr_id
_999.tasks	task_created_usr_id
_999.tasks	task_modified_usr_id
_999.tasks	task_assign_to_usr_id
_999.tasks_assigned_map	tamap_usr_id
_999.tasks_assignments	taskass_assigner_usr_id
_999.tasks_assignments	taskass_assigned_usr_id
_999.test_codes_search_frequency	tcof_usr_id
_999.user_preferences	upref_usr_id
_999.users_roles	ur_usr_id
_999.voided_payments	vp_usr_id
common.ahi_audits	aud_usr_id
common.ahi_audits	aud_spoofing_usr_id
common.ahi_audits	aud_web_usr_id
common.ahi_notes	not_usr_id
common.application_notes	appn_usr_id
common.client_imports_meta_data	cimd_imported_usr_id
common.clients_contract_data	ccd_sales_rep_usr_id
common.clients_contract_data	ccd_follow_up_usr_id
common.clients_contract_data	ccd_implementation_specialist_usr_id
common.clients_contract_data	ccd_rcm_coordinator_usr_id
common.clients_notes	cln_usr_id
common.configurations	conf_usr_id
common.dashboardmd_users	dmdu_usr_id
common.data_import_clients_meta_data	dicmd_upload_usr_id
common.data_import_clients_meta_data	dicmd_import_usr_id
common.dev_requests	dev_submitted_usr_id
common.dev_requests	dev_assigned_usr_id
common.dev_requests_notes	dvn_usr_id
common.dev_requests_screencasts	drs_usr_id
common.dev_requests_votes	dvt_usr_id
common.fax_accounts_map	fxam_usr_id
common.faxes	fax_usr_id
common.feature_requests	fea_usr_id
common.interfaces_types	it_usr_id
common.leads_notes	len_usr_id
common.login_events	loge_usr_id
common.permissions	perm_usr_id
common.phi_mail_users	pmu_usr_id
common.push_notification_registration_tokens	pnr_usr_id
common.rcm_clients_access	rca_usr_id
common.reports_queue_orders	rqo_usr_id
common.reports_queue_orders_access	rqoa_usr_id
common.security_answers	sea_usr_id
common.service_tickets_comments	stcp_usr_id
common.service_tickets_notes	stns_usr_id
common.sfax_accounts_map	sfam_usr_id
common.sfaxes	sfax_usr_id
common.stripe_accounts	sua_stripe_usr_id
common.support_threads	spt_usr_id
common.telehealth_codes	thc_usr_id
common.telehealth_otp	ts_usr_id
common.users_access	uxs_usr_id
common.users_access	uxs_usr_id_ext
common.users_history	uhs_usr_id
common.users_login_stats	uls_usr_id
common.users_notification_settings	usrnotset_usr_id
common.users_passwords	upwd_usr_id
common.users_permissions	upr_usr_id
common.users_portal_access	upa_usr_id
common.users_settings	us_usr_id
common.users_simplifymd	usmd_usr_id

usr_modified

Table	Column
_1.appointments	apt_usr_modified
_1.encounters	enc_usr_modified
_1.patients	pat_usr_modified
_1.tasks	task_usr_modified
_1188.appointments	apt_usr_modified
_1188.encounters	enc_usr_modified
_1188.patients	pat_usr_modified
_1188.tasks	task_usr_modified
_1218.appointments	apt_usr_modified
_1218.encounters	enc_usr_modified
_1218.patients	pat_usr_modified
_1218.tasks	task_usr_modified
_1548.appointments	apt_usr_modified
_1548.encounters	enc_usr_modified
_1548.patients	pat_usr_modified
_1548.tasks	task_usr_modified
_435.appointments	apt_usr_modified
_435.encounters	enc_usr_modified
_435.patients	pat_usr_modified
_435.tasks	task_usr_modified
_436.appointments	apt_usr_modified
_436.encounters	enc_usr_modified
_436.patients	pat_usr_modified
_436.tasks	task_usr_modified
_436_archive_testing.appointments	apt_usr_modified
_436_archive_testing.encounters	enc_usr_modified
_436_archive_testing.patients	pat_usr_modified
_436_archive_testing.tasks	task_usr_modified
_437.appointments	apt_usr_modified
_437.encounters	enc_usr_modified
_437.patients	pat_usr_modified
_437.tasks	task_usr_modified
_8.appointments	apt_usr_modified
_8.encounters	enc_usr_modified
_8.patients	pat_usr_modified
_8.tasks	task_usr_modified
_81.appointments	apt_usr_modified
_81.encounters	enc_usr_modified
_81.patients	pat_usr_modified
_81.tasks	task_usr_modified
_999.appointments	apt_usr_modified
_999.encounters	enc_usr_modified
_999.patients	pat_usr_modified
_999.tasks	task_usr_modified

usr_created

Table	Column
_1.patients_urls	pu_usr_created
_1188.patients_urls	pu_usr_created
_1218.patients_urls	pu_usr_created
_1548.patients_urls	pu_usr_created
_435.patients_urls	pu_usr_created
_436.patients_urls	pu_usr_created
_436_archive_testing.patients_urls	pu_usr_created
_437.patients_urls	pu_usr_created
_8.patients_urls	pu_usr_created
_81.patients_urls	pu_usr_created
_999.patients_urls	pu_usr_created