_999.groups

Field	Type	Null	Default	Key	Extra
grp_id	int(11)	NO		PRI	auto_increment
grp_cus_id	int(11)	NO		MUL
grp_cli_id	int(11)	NO		MUL
grp_name	varchar(60)	NO
grp_no_reply	char(1)	NO
grp_phr_access	char(1)	NO
grp_msg_access	char(1)	NO
grp_disabled	char(1)	NO
grp_modified	datetime	YES	CURRENT_TIMESTAMP
grp_created	datetime	YES	CURRENT_TIMESTAMP

References

Local Column

References

grp_id

Table	Column
Messaging.messages_access	mxs_grp_id
Messaging.messages_access_new	mxs_grp_id
Messaging.messages_groups	mg_grp_id
Messaging.messages_groups_members	mgm_grp_id
_1.appointments	apt_grp_id
_1.appointments_reasons	are_grp_id
_1.charts_care_plan	ccp_assigned_grp_id
_1.clinical_alerts_access	caa_grp_id
_1.clinical_interventions_groups_map	cigm_grp_id
_1.cpt_quickpick	cptqp_grp_id
_1.encounters_soap_templates_access	esta_grp_id
_1.encounters_stored_notes_access	esna_grp_id
_1.groups_members	gms_grp_id
_1.health_maintenance_associations	hma_grp_id
_1.patient_access_restriction	patar_grp_id
_1.patients_histories	ph_grp_id
_1.patients_popup_receivers	ppr_grp_id
_1.patients_referrals	pref_assigned_grp_id
_1.pi_user_access_map	pi_access_grp_id
_1.recalls_reasons	rr_grp_id
_1.recalls_reasons_associations	rra_grp_id
_1.rooms	rms_grp_id
_1.tasks	task_assign_to_grp_id
_1.tasks_assigned_map	tamap_grp_id
_1.tasks_assignments	taskass_assigned_grp_id
_1.tasks_categories	tcat_grp_id
_1188.appointments	apt_grp_id
_1188.appointments_reasons	are_grp_id
_1188.charts_care_plan	ccp_assigned_grp_id
_1188.clinical_alerts_access	caa_grp_id
_1188.clinical_interventions_groups_map	cigm_grp_id
_1188.cpt_quickpick	cptqp_grp_id
_1188.encounters_soap_templates_access	esta_grp_id
_1188.encounters_stored_notes_access	esna_grp_id
_1188.groups_members	gms_grp_id
_1188.health_maintenance_associations	hma_grp_id
_1188.patient_access_restriction	patar_grp_id
_1188.patients_histories	ph_grp_id
_1188.patients_popup_receivers	ppr_grp_id
_1188.patients_referrals	pref_assigned_grp_id
_1188.pi_user_access_map	pi_access_grp_id
_1188.recalls_reasons	rr_grp_id
_1188.recalls_reasons_associations	rra_grp_id
_1188.rooms	rms_grp_id
_1188.tasks	task_assign_to_grp_id
_1188.tasks_assigned_map	tamap_grp_id
_1188.tasks_assignments	taskass_assigned_grp_id
_1188.tasks_categories	tcat_grp_id
_1218.appointments	apt_grp_id
_1218.appointments_reasons	are_grp_id
_1218.charts_care_plan	ccp_assigned_grp_id
_1218.clinical_alerts_access	caa_grp_id
_1218.clinical_interventions_groups_map	cigm_grp_id
_1218.cpt_quickpick	cptqp_grp_id
_1218.encounters_soap_templates_access	esta_grp_id
_1218.encounters_stored_notes_access	esna_grp_id
_1218.groups_members	gms_grp_id
_1218.health_maintenance_associations	hma_grp_id
_1218.patient_access_restriction	patar_grp_id
_1218.patients_histories	ph_grp_id
_1218.patients_popup_receivers	ppr_grp_id
_1218.patients_referrals	pref_assigned_grp_id
_1218.pi_user_access_map	pi_access_grp_id
_1218.recalls_reasons	rr_grp_id
_1218.recalls_reasons_associations	rra_grp_id
_1218.rooms	rms_grp_id
_1218.tasks	task_assign_to_grp_id
_1218.tasks_assigned_map	tamap_grp_id
_1218.tasks_assignments	taskass_assigned_grp_id
_1218.tasks_categories	tcat_grp_id
_1548.appointments	apt_grp_id
_1548.appointments_reasons	are_grp_id
_1548.charts_care_plan	ccp_assigned_grp_id
_1548.clinical_alerts_access	caa_grp_id
_1548.clinical_interventions_groups_map	cigm_grp_id
_1548.cpt_quickpick	cptqp_grp_id
_1548.encounters_soap_templates_access	esta_grp_id
_1548.encounters_stored_notes_access	esna_grp_id
_1548.groups_members	gms_grp_id
_1548.health_maintenance_associations	hma_grp_id
_1548.patient_access_restriction	patar_grp_id
_1548.patients_histories	ph_grp_id
_1548.patients_popup_receivers	ppr_grp_id
_1548.patients_referrals	pref_assigned_grp_id
_1548.pi_user_access_map	pi_access_grp_id
_1548.recalls_reasons	rr_grp_id
_1548.recalls_reasons_associations	rra_grp_id
_1548.rooms	rms_grp_id
_1548.tasks	task_assign_to_grp_id
_1548.tasks_assigned_map	tamap_grp_id
_1548.tasks_assignments	taskass_assigned_grp_id
_1548.tasks_categories	tcat_grp_id
_435.appointments	apt_grp_id
_435.appointments_reasons	are_grp_id
_435.charts_care_plan	ccp_assigned_grp_id
_435.clinical_alerts_access	caa_grp_id
_435.clinical_interventions_groups_map	cigm_grp_id
_435.cpt_quickpick	cptqp_grp_id
_435.encounters_soap_templates_access	esta_grp_id
_435.encounters_stored_notes_access	esna_grp_id
_435.groups_members	gms_grp_id
_435.health_maintenance_associations	hma_grp_id
_435.patient_access_restriction	patar_grp_id
_435.patients_histories	ph_grp_id
_435.patients_popup_receivers	ppr_grp_id
_435.patients_referrals	pref_assigned_grp_id
_435.pi_user_access_map	pi_access_grp_id
_435.recalls_reasons	rr_grp_id
_435.recalls_reasons_associations	rra_grp_id
_435.rooms	rms_grp_id
_435.tasks	task_assign_to_grp_id
_435.tasks_assigned_map	tamap_grp_id
_435.tasks_assignments	taskass_assigned_grp_id
_435.tasks_categories	tcat_grp_id
_436.appointments	apt_grp_id
_436.appointments_reasons	are_grp_id
_436.charts_care_plan	ccp_assigned_grp_id
_436.clinical_alerts_access	caa_grp_id
_436.clinical_interventions_groups_map	cigm_grp_id
_436.cpt_quickpick	cptqp_grp_id
_436.encounters_soap_templates_access	esta_grp_id
_436.encounters_stored_notes_access	esna_grp_id
_436.groups_members	gms_grp_id
_436.health_maintenance_associations	hma_grp_id
_436.patient_access_restriction	patar_grp_id
_436.patients_histories	ph_grp_id
_436.patients_popup_receivers	ppr_grp_id
_436.patients_referrals	pref_assigned_grp_id
_436.pi_user_access_map	pi_access_grp_id
_436.recalls_reasons	rr_grp_id
_436.recalls_reasons_associations	rra_grp_id
_436.rooms	rms_grp_id
_436.tasks	task_assign_to_grp_id
_436.tasks_assigned_map	tamap_grp_id
_436.tasks_assignments	taskass_assigned_grp_id
_436.tasks_categories	tcat_grp_id
_436_archive_testing.appointments	apt_grp_id
_436_archive_testing.appointments_reasons	are_grp_id
_436_archive_testing.charts_care_plan	ccp_assigned_grp_id
_436_archive_testing.clinical_alerts_access	caa_grp_id
_436_archive_testing.clinical_interventions_groups_map	cigm_grp_id
_436_archive_testing.cpt_quickpick	cptqp_grp_id
_436_archive_testing.encounters_soap_templates_access	esta_grp_id
_436_archive_testing.encounters_stored_notes_access	esna_grp_id
_436_archive_testing.groups_members	gms_grp_id
_436_archive_testing.health_maintenance_associations	hma_grp_id
_436_archive_testing.patient_access_restriction	patar_grp_id
_436_archive_testing.patients_histories	ph_grp_id
_436_archive_testing.patients_popup_receivers	ppr_grp_id
_436_archive_testing.patients_referrals	pref_assigned_grp_id
_436_archive_testing.pi_user_access_map	pi_access_grp_id
_436_archive_testing.recalls_reasons	rr_grp_id
_436_archive_testing.recalls_reasons_associations	rra_grp_id
_436_archive_testing.rooms	rms_grp_id
_436_archive_testing.tasks	task_assign_to_grp_id
_436_archive_testing.tasks_assigned_map	tamap_grp_id
_436_archive_testing.tasks_assignments	taskass_assigned_grp_id
_436_archive_testing.tasks_categories	tcat_grp_id
_437.appointments	apt_grp_id
_437.appointments_reasons	are_grp_id
_437.charts_care_plan	ccp_assigned_grp_id
_437.clinical_alerts_access	caa_grp_id
_437.clinical_interventions_groups_map	cigm_grp_id
_437.cpt_quickpick	cptqp_grp_id
_437.encounters_soap_templates_access	esta_grp_id
_437.encounters_stored_notes_access	esna_grp_id
_437.groups_members	gms_grp_id
_437.health_maintenance_associations	hma_grp_id
_437.patient_access_restriction	patar_grp_id
_437.patients_histories	ph_grp_id
_437.patients_popup_receivers	ppr_grp_id
_437.patients_referrals	pref_assigned_grp_id
_437.pi_user_access_map	pi_access_grp_id
_437.recalls_reasons	rr_grp_id
_437.recalls_reasons_associations	rra_grp_id
_437.rooms	rms_grp_id
_437.tasks	task_assign_to_grp_id
_437.tasks_assigned_map	tamap_grp_id
_437.tasks_assignments	taskass_assigned_grp_id
_437.tasks_categories	tcat_grp_id
_8.appointments	apt_grp_id
_8.appointments_reasons	are_grp_id
_8.charts_care_plan	ccp_assigned_grp_id
_8.clinical_alerts_access	caa_grp_id
_8.clinical_interventions_groups_map	cigm_grp_id
_8.cpt_quickpick	cptqp_grp_id
_8.encounters_soap_templates_access	esta_grp_id
_8.encounters_stored_notes_access	esna_grp_id
_8.groups_members	gms_grp_id
_8.health_maintenance_associations	hma_grp_id
_8.patient_access_restriction	patar_grp_id
_8.patients_histories	ph_grp_id
_8.patients_popup_receivers	ppr_grp_id
_8.patients_referrals	pref_assigned_grp_id
_8.pi_user_access_map	pi_access_grp_id
_8.recalls_reasons	rr_grp_id
_8.recalls_reasons_associations	rra_grp_id
_8.rooms	rms_grp_id
_8.tasks	task_assign_to_grp_id
_8.tasks_assigned_map	tamap_grp_id
_8.tasks_assignments	taskass_assigned_grp_id
_8.tasks_categories	tcat_grp_id
_81.appointments	apt_grp_id
_81.appointments_reasons	are_grp_id
_81.charts_care_plan	ccp_assigned_grp_id
_81.clinical_alerts_access	caa_grp_id
_81.clinical_interventions_groups_map	cigm_grp_id
_81.cpt_quickpick	cptqp_grp_id
_81.encounters_soap_templates_access	esta_grp_id
_81.encounters_stored_notes_access	esna_grp_id
_81.groups_members	gms_grp_id
_81.health_maintenance_associations	hma_grp_id
_81.patient_access_restriction	patar_grp_id
_81.patients_histories	ph_grp_id
_81.patients_popup_receivers	ppr_grp_id
_81.patients_referrals	pref_assigned_grp_id
_81.pi_user_access_map	pi_access_grp_id
_81.recalls_reasons	rr_grp_id
_81.recalls_reasons_associations	rra_grp_id
_81.rooms	rms_grp_id
_81.tasks	task_assign_to_grp_id
_81.tasks_assigned_map	tamap_grp_id
_81.tasks_assignments	taskass_assigned_grp_id
_81.tasks_categories	tcat_grp_id
_999.appointments	apt_grp_id
_999.appointments_reasons	are_grp_id
_999.charts_care_plan	ccp_assigned_grp_id
_999.clinical_alerts_access	caa_grp_id
_999.clinical_interventions_groups_map	cigm_grp_id
_999.cpt_quickpick	cptqp_grp_id
_999.encounters_soap_templates_access	esta_grp_id
_999.encounters_stored_notes_access	esna_grp_id
_999.groups_members	gms_grp_id
_999.health_maintenance_associations	hma_grp_id
_999.patient_access_restriction	patar_grp_id
_999.patients_histories	ph_grp_id
_999.patients_popup_receivers	ppr_grp_id
_999.patients_referrals	pref_assigned_grp_id
_999.pi_user_access_map	pi_access_grp_id
_999.recalls_reasons	rr_grp_id
_999.recalls_reasons_associations	rra_grp_id
_999.rooms	rms_grp_id
_999.tasks	task_assign_to_grp_id
_999.tasks_assigned_map	tamap_grp_id
_999.tasks_assignments	taskass_assigned_grp_id
_999.tasks_categories	tcat_grp_id
common.configurations_options	confopt_grp_id