aurora_standard.oelocsetupc

Field Type Null Default Key Extra Comment
chs_rowID int(11) NO PRI auto_increment
grp_id smallint(6) YES
subgrp_id smallint(6) YES
location varchar(20) YES

References

Local Column References
grp_id
TableColumn
Messaging.messages_accessmxs_grp_id
Messaging.messages_access_newmxs_grp_id
Messaging.messages_groupsmg_grp_id
Messaging.messages_groups_membersmgm_grp_id
_1.appointmentsapt_grp_id
_1.appointments_reasonsare_grp_id
_1.charts_care_planccp_assigned_grp_id
_1.clinical_alerts_accesscaa_grp_id
_1.clinical_interventions_groups_mapcigm_grp_id
_1.cpt_quickpickcptqp_grp_id
_1.encounters_soap_templates_accessesta_grp_id
_1.encounters_stored_notes_accessesna_grp_id
_1.groups_membersgms_grp_id
_1.health_maintenance_associationshma_grp_id
_1.patient_access_restrictionpatar_grp_id
_1.patients_historiesph_grp_id
_1.patients_popup_receiversppr_grp_id
_1.patients_referralspref_assigned_grp_id
_1.pi_user_access_mappi_access_grp_id
_1.recalls_reasonsrr_grp_id
_1.recalls_reasons_associationsrra_grp_id
_1.roomsrms_grp_id
_1.taskstask_assign_to_grp_id
_1.tasks_assigned_maptamap_grp_id
_1.tasks_assignmentstaskass_assigned_grp_id
_1.tasks_categoriestcat_grp_id
_1188.appointmentsapt_grp_id
_1188.appointments_reasonsare_grp_id
_1188.charts_care_planccp_assigned_grp_id
_1188.clinical_alerts_accesscaa_grp_id
_1188.clinical_interventions_groups_mapcigm_grp_id
_1188.cpt_quickpickcptqp_grp_id
_1188.encounters_soap_templates_accessesta_grp_id
_1188.encounters_stored_notes_accessesna_grp_id
_1188.groups_membersgms_grp_id
_1188.health_maintenance_associationshma_grp_id
_1188.patient_access_restrictionpatar_grp_id
_1188.patients_historiesph_grp_id
_1188.patients_popup_receiversppr_grp_id
_1188.patients_referralspref_assigned_grp_id
_1188.pi_user_access_mappi_access_grp_id
_1188.recalls_reasonsrr_grp_id
_1188.recalls_reasons_associationsrra_grp_id
_1188.roomsrms_grp_id
_1188.taskstask_assign_to_grp_id
_1188.tasks_assigned_maptamap_grp_id
_1188.tasks_assignmentstaskass_assigned_grp_id
_1188.tasks_categoriestcat_grp_id
_1218.appointmentsapt_grp_id
_1218.appointments_reasonsare_grp_id
_1218.charts_care_planccp_assigned_grp_id
_1218.clinical_alerts_accesscaa_grp_id
_1218.clinical_interventions_groups_mapcigm_grp_id
_1218.cpt_quickpickcptqp_grp_id
_1218.encounters_soap_templates_accessesta_grp_id
_1218.encounters_stored_notes_accessesna_grp_id
_1218.groups_membersgms_grp_id
_1218.health_maintenance_associationshma_grp_id
_1218.patient_access_restrictionpatar_grp_id
_1218.patients_historiesph_grp_id
_1218.patients_popup_receiversppr_grp_id
_1218.patients_referralspref_assigned_grp_id
_1218.pi_user_access_mappi_access_grp_id
_1218.recalls_reasonsrr_grp_id
_1218.recalls_reasons_associationsrra_grp_id
_1218.roomsrms_grp_id
_1218.taskstask_assign_to_grp_id
_1218.tasks_assigned_maptamap_grp_id
_1218.tasks_assignmentstaskass_assigned_grp_id
_1218.tasks_categoriestcat_grp_id
_1548.appointmentsapt_grp_id
_1548.appointments_reasonsare_grp_id
_1548.charts_care_planccp_assigned_grp_id
_1548.clinical_alerts_accesscaa_grp_id
_1548.clinical_interventions_groups_mapcigm_grp_id
_1548.cpt_quickpickcptqp_grp_id
_1548.encounters_soap_templates_accessesta_grp_id
_1548.encounters_stored_notes_accessesna_grp_id
_1548.groups_membersgms_grp_id
_1548.health_maintenance_associationshma_grp_id
_1548.patient_access_restrictionpatar_grp_id
_1548.patients_historiesph_grp_id
_1548.patients_popup_receiversppr_grp_id
_1548.patients_referralspref_assigned_grp_id
_1548.pi_user_access_mappi_access_grp_id
_1548.recalls_reasonsrr_grp_id
_1548.recalls_reasons_associationsrra_grp_id
_1548.roomsrms_grp_id
_1548.taskstask_assign_to_grp_id
_1548.tasks_assigned_maptamap_grp_id
_1548.tasks_assignmentstaskass_assigned_grp_id
_1548.tasks_categoriestcat_grp_id
_435.appointmentsapt_grp_id
_435.appointments_reasonsare_grp_id
_435.charts_care_planccp_assigned_grp_id
_435.clinical_alerts_accesscaa_grp_id
_435.clinical_interventions_groups_mapcigm_grp_id
_435.cpt_quickpickcptqp_grp_id
_435.encounters_soap_templates_accessesta_grp_id
_435.encounters_stored_notes_accessesna_grp_id
_435.groups_membersgms_grp_id
_435.health_maintenance_associationshma_grp_id
_435.patient_access_restrictionpatar_grp_id
_435.patients_historiesph_grp_id
_435.patients_popup_receiversppr_grp_id
_435.patients_referralspref_assigned_grp_id
_435.pi_user_access_mappi_access_grp_id
_435.recalls_reasonsrr_grp_id
_435.recalls_reasons_associationsrra_grp_id
_435.roomsrms_grp_id
_435.taskstask_assign_to_grp_id
_435.tasks_assigned_maptamap_grp_id
_435.tasks_assignmentstaskass_assigned_grp_id
_435.tasks_categoriestcat_grp_id
_436.appointmentsapt_grp_id
_436.appointments_reasonsare_grp_id
_436.charts_care_planccp_assigned_grp_id
_436.clinical_alerts_accesscaa_grp_id
_436.clinical_interventions_groups_mapcigm_grp_id
_436.cpt_quickpickcptqp_grp_id
_436.encounters_soap_templates_accessesta_grp_id
_436.encounters_stored_notes_accessesna_grp_id
_436.groups_membersgms_grp_id
_436.health_maintenance_associationshma_grp_id
_436.patient_access_restrictionpatar_grp_id
_436.patients_historiesph_grp_id
_436.patients_popup_receiversppr_grp_id
_436.patients_referralspref_assigned_grp_id
_436.pi_user_access_mappi_access_grp_id
_436.recalls_reasonsrr_grp_id
_436.recalls_reasons_associationsrra_grp_id
_436.roomsrms_grp_id
_436.taskstask_assign_to_grp_id
_436.tasks_assigned_maptamap_grp_id
_436.tasks_assignmentstaskass_assigned_grp_id
_436.tasks_categoriestcat_grp_id
_436_archive_testing.appointmentsapt_grp_id
_436_archive_testing.appointments_reasonsare_grp_id
_436_archive_testing.charts_care_planccp_assigned_grp_id
_436_archive_testing.clinical_alerts_accesscaa_grp_id
_436_archive_testing.clinical_interventions_groups_mapcigm_grp_id
_436_archive_testing.cpt_quickpickcptqp_grp_id
_436_archive_testing.encounters_soap_templates_accessesta_grp_id
_436_archive_testing.encounters_stored_notes_accessesna_grp_id
_436_archive_testing.groups_membersgms_grp_id
_436_archive_testing.health_maintenance_associationshma_grp_id
_436_archive_testing.patient_access_restrictionpatar_grp_id
_436_archive_testing.patients_historiesph_grp_id
_436_archive_testing.patients_popup_receiversppr_grp_id
_436_archive_testing.patients_referralspref_assigned_grp_id
_436_archive_testing.pi_user_access_mappi_access_grp_id
_436_archive_testing.recalls_reasonsrr_grp_id
_436_archive_testing.recalls_reasons_associationsrra_grp_id
_436_archive_testing.roomsrms_grp_id
_436_archive_testing.taskstask_assign_to_grp_id
_436_archive_testing.tasks_assigned_maptamap_grp_id
_436_archive_testing.tasks_assignmentstaskass_assigned_grp_id
_436_archive_testing.tasks_categoriestcat_grp_id
_437.appointmentsapt_grp_id
_437.appointments_reasonsare_grp_id
_437.charts_care_planccp_assigned_grp_id
_437.clinical_alerts_accesscaa_grp_id
_437.clinical_interventions_groups_mapcigm_grp_id
_437.cpt_quickpickcptqp_grp_id
_437.encounters_soap_templates_accessesta_grp_id
_437.encounters_stored_notes_accessesna_grp_id
_437.groups_membersgms_grp_id
_437.health_maintenance_associationshma_grp_id
_437.patient_access_restrictionpatar_grp_id
_437.patients_historiesph_grp_id
_437.patients_popup_receiversppr_grp_id
_437.patients_referralspref_assigned_grp_id
_437.pi_user_access_mappi_access_grp_id
_437.recalls_reasonsrr_grp_id
_437.recalls_reasons_associationsrra_grp_id
_437.roomsrms_grp_id
_437.taskstask_assign_to_grp_id
_437.tasks_assigned_maptamap_grp_id
_437.tasks_assignmentstaskass_assigned_grp_id
_437.tasks_categoriestcat_grp_id
_8.appointmentsapt_grp_id
_8.appointments_reasonsare_grp_id
_8.charts_care_planccp_assigned_grp_id
_8.clinical_alerts_accesscaa_grp_id
_8.clinical_interventions_groups_mapcigm_grp_id
_8.cpt_quickpickcptqp_grp_id
_8.encounters_soap_templates_accessesta_grp_id
_8.encounters_stored_notes_accessesna_grp_id
_8.groups_membersgms_grp_id
_8.health_maintenance_associationshma_grp_id
_8.patient_access_restrictionpatar_grp_id
_8.patients_historiesph_grp_id
_8.patients_popup_receiversppr_grp_id
_8.patients_referralspref_assigned_grp_id
_8.pi_user_access_mappi_access_grp_id
_8.recalls_reasonsrr_grp_id
_8.recalls_reasons_associationsrra_grp_id
_8.roomsrms_grp_id
_8.taskstask_assign_to_grp_id
_8.tasks_assigned_maptamap_grp_id
_8.tasks_assignmentstaskass_assigned_grp_id
_8.tasks_categoriestcat_grp_id
_81.appointmentsapt_grp_id
_81.appointments_reasonsare_grp_id
_81.charts_care_planccp_assigned_grp_id
_81.clinical_alerts_accesscaa_grp_id
_81.clinical_interventions_groups_mapcigm_grp_id
_81.cpt_quickpickcptqp_grp_id
_81.encounters_soap_templates_accessesta_grp_id
_81.encounters_stored_notes_accessesna_grp_id
_81.groups_membersgms_grp_id
_81.health_maintenance_associationshma_grp_id
_81.patient_access_restrictionpatar_grp_id
_81.patients_historiesph_grp_id
_81.patients_popup_receiversppr_grp_id
_81.patients_referralspref_assigned_grp_id
_81.pi_user_access_mappi_access_grp_id
_81.recalls_reasonsrr_grp_id
_81.recalls_reasons_associationsrra_grp_id
_81.roomsrms_grp_id
_81.taskstask_assign_to_grp_id
_81.tasks_assigned_maptamap_grp_id
_81.tasks_assignmentstaskass_assigned_grp_id
_81.tasks_categoriestcat_grp_id
_999.appointmentsapt_grp_id
_999.appointments_reasonsare_grp_id
_999.charts_care_planccp_assigned_grp_id
_999.clinical_alerts_accesscaa_grp_id
_999.clinical_interventions_groups_mapcigm_grp_id
_999.cpt_quickpickcptqp_grp_id
_999.encounters_soap_templates_accessesta_grp_id
_999.encounters_stored_notes_accessesna_grp_id
_999.groups_membersgms_grp_id
_999.health_maintenance_associationshma_grp_id
_999.patient_access_restrictionpatar_grp_id
_999.patients_historiesph_grp_id
_999.patients_popup_receiversppr_grp_id
_999.patients_referralspref_assigned_grp_id
_999.pi_user_access_mappi_access_grp_id
_999.recalls_reasonsrr_grp_id
_999.recalls_reasons_associationsrra_grp_id
_999.roomsrms_grp_id
_999.taskstask_assign_to_grp_id
_999.tasks_assigned_maptamap_grp_id
_999.tasks_assignmentstaskass_assigned_grp_id
_999.tasks_categoriestcat_grp_id
common.configurations_optionsconfopt_grp_id
location
TableColumn
_1.cpoe_responsescpoe_res_location
_1.encounters_soap_vitalsespv_location
_1.hl7_accessionsacc_location
_1.patients_immunizationspim_location
_1.precertspre_scheduled_location
_1.precerts_mapprem_location
_1.radiology_resultsrad_res_location
_1188.cpoe_responsescpoe_res_location
_1188.encounters_soap_vitalsespv_location
_1188.hl7_accessionsacc_location
_1188.patients_immunizationspim_location
_1188.precertspre_scheduled_location
_1188.precerts_mapprem_location
_1188.radiology_resultsrad_res_location
_1218.cpoe_responsescpoe_res_location
_1218.encounters_soap_vitalsespv_location
_1218.hl7_accessionsacc_location
_1218.patients_immunizationspim_location
_1218.precertspre_scheduled_location
_1218.precerts_mapprem_location
_1218.radiology_resultsrad_res_location
_1548.cpoe_responsescpoe_res_location
_1548.encounters_soap_vitalsespv_location
_1548.hl7_accessionsacc_location
_1548.patients_immunizationspim_location
_1548.precertspre_scheduled_location
_1548.precerts_mapprem_location
_1548.radiology_resultsrad_res_location
_435.cpoe_responsescpoe_res_location
_435.encounters_soap_vitalsespv_location
_435.hl7_accessionsacc_location
_435.patients_immunizationspim_location
_435.precertspre_scheduled_location
_435.precerts_mapprem_location
_435.radiology_resultsrad_res_location
_436.cpoe_responsescpoe_res_location
_436.encounters_soap_vitalsespv_location
_436.hl7_accessionsacc_location
_436.patients_immunizationspim_location
_436.precertspre_scheduled_location
_436.precerts_mapprem_location
_436.radiology_resultsrad_res_location
_436_archive_testing.cpoe_responsescpoe_res_location
_436_archive_testing.encounters_soap_vitalsespv_location
_436_archive_testing.hl7_accessionsacc_location
_436_archive_testing.patients_immunizationspim_location
_436_archive_testing.precertspre_scheduled_location
_436_archive_testing.precerts_mapprem_location
_436_archive_testing.radiology_resultsrad_res_location
_437.cpoe_responsescpoe_res_location
_437.encounters_soap_vitalsespv_location
_437.hl7_accessionsacc_location
_437.patients_immunizationspim_location
_437.precertspre_scheduled_location
_437.precerts_mapprem_location
_437.radiology_resultsrad_res_location
_8.cpoe_responsescpoe_res_location
_8.encounters_soap_vitalsespv_location
_8.hl7_accessionsacc_location
_8.patients_immunizationspim_location
_8.precertspre_scheduled_location
_8.precerts_mapprem_location
_8.radiology_resultsrad_res_location
_81.cpoe_responsescpoe_res_location
_81.encounters_soap_vitalsespv_location
_81.hl7_accessionsacc_location
_81.patients_immunizationspim_location
_81.precertspre_scheduled_location
_81.precerts_mapprem_location
_81.radiology_resultsrad_res_location
_999.cpoe_responsescpoe_res_location
_999.encounters_soap_vitalsespv_location
_999.hl7_accessionsacc_location
_999.patients_immunizationspim_location
_999.precertspre_scheduled_location
_999.precerts_mapprem_location
_999.radiology_resultsrad_res_location
aurora_standard.bhguaremp_location
aurora_standard.bhtguaremp_location
aurora_standard.chpinsrdclass_location
aurora_standard.chplocacclass_location
aurora_standard.chqcmeudcme_location
aurora_standard.chqletrdletter_location
aurora_standard.chrcntrcrx_location
aurora_standard.mergdocsfile_location
aurora_standard.mergsigsfile_location
aurora_standard.sthcadjdstock_location
aurora_standard.sticadjdstock_location
aurora_standard.stilocarstock_location
aurora_standard.stipyxlcrev_location
aurora_standard.stipyxlcexp_location
aurora_standard.stistkldstock_location
aurora_standard.stock2stock_location
aurora_standard.stoshipdstock_location
aurora_standard.tmplocarstock_location