aurora_standard.stxgropr

Field	Type	Null	Key	Extra
group_id	varchar(8)	YES	MUL
description	varchar(30)	YES
chs_rowID	bigint(20) unsigned	NO	PRI	auto_increment

References

Local Column

References

group_id

Table	Column
HSPI_Bastrop.billing_alert_rules	entity_condition_group_id
HSPI_Bastrop.claim_batch_generation_rules	entity_condition_group_id
HSPI_Bastrop.claim_field_adjustment_rules	entity_condition_group_id
HSPI_Bastrop.claim_item_generation_rules	entity_condition_group_id
HSPI_Bastrop.saved_filters	entity_condition_group_id
HSPI_CURES2015_B1.billing_alert_rules	entity_condition_group_id
HSPI_CURES2015_B1.billing_controls	entity_condition_group_id
HSPI_CURES2015_B1.claim_batch_generation_rules	entity_condition_group_id
HSPI_CURES2015_B1.claim_field_adjustment_rules	entity_condition_group_id
HSPI_CURES2015_B1.claim_item_generation_rules	entity_condition_group_id
HSPI_CURES2015_B1.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_CURES2015_B1.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_CURES2015_B1.invoice_generation_rule_sets	entity_condition_group_id
HSPI_CURES2015_B1.saved_filters	entity_condition_group_id
HSPI_Central_Hospital.billing_alert_rules	entity_condition_group_id
HSPI_Central_Hospital.billing_controls	entity_condition_group_id
HSPI_Central_Hospital.claim_batch_generation_rules	entity_condition_group_id
HSPI_Central_Hospital.claim_field_adjustment_rules	entity_condition_group_id
HSPI_Central_Hospital.claim_item_generation_rules	entity_condition_group_id
HSPI_Central_Hospital.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_Central_Hospital.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_Central_Hospital.invoice_generation_rule_sets	entity_condition_group_id
HSPI_Central_Hospital.saved_filters	entity_condition_group_id
HSPI_Dewitt.billing_alert_rules	entity_condition_group_id
HSPI_Dewitt.billing_controls	entity_condition_group_id
HSPI_Dewitt.claim_batch_generation_rules	entity_condition_group_id
HSPI_Dewitt.claim_field_adjustment_rules	entity_condition_group_id
HSPI_Dewitt.claim_item_generation_rules	entity_condition_group_id
HSPI_Dewitt.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_Dewitt.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_Dewitt.invoice_generation_rule_sets	entity_condition_group_id
HSPI_Dewitt.saved_filters	entity_condition_group_id
HSPI_Fulton.billing_alert_rules	entity_condition_group_id
HSPI_Fulton.billing_controls	entity_condition_group_id
HSPI_Fulton.claim_batch_generation_rules	entity_condition_group_id
HSPI_Fulton.claim_field_adjustment_rules	entity_condition_group_id
HSPI_Fulton.claim_item_generation_rules	entity_condition_group_id
HSPI_Fulton.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_Fulton.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_Fulton.invoice_generation_rule_sets	entity_condition_group_id
HSPI_Fulton.saved_filters	entity_condition_group_id
HSPI_Inferno.billing_alert_rules	entity_condition_group_id
HSPI_Inferno.billing_controls	entity_condition_group_id
HSPI_Inferno.claim_batch_generation_rules	entity_condition_group_id
HSPI_Inferno.claim_field_adjustment_rules	entity_condition_group_id
HSPI_Inferno.claim_item_generation_rules	entity_condition_group_id
HSPI_Inferno.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_Inferno.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_Inferno.invoice_generation_rule_sets	entity_condition_group_id
HSPI_Inferno.saved_filters	entity_condition_group_id
HSPI_MU2015_E1.billing_alert_rules	entity_condition_group_id
HSPI_MU2015_E1.billing_controls	entity_condition_group_id
HSPI_MU2015_E1.claim_batch_generation_rules	entity_condition_group_id
HSPI_MU2015_E1.claim_field_adjustment_rules	entity_condition_group_id
HSPI_MU2015_E1.claim_item_generation_rules	entity_condition_group_id
HSPI_MU2015_E1.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_MU2015_E1.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_MU2015_E1.invoice_generation_rule_sets	entity_condition_group_id
HSPI_MU2015_E1.saved_filters	entity_condition_group_id
HSPI_MU2015_G2.billing_alert_rules	entity_condition_group_id
HSPI_MU2015_G2.billing_controls	entity_condition_group_id
HSPI_MU2015_G2.claim_batch_generation_rules	entity_condition_group_id
HSPI_MU2015_G2.claim_field_adjustment_rules	entity_condition_group_id
HSPI_MU2015_G2.claim_item_generation_rules	entity_condition_group_id
HSPI_MU2015_G2.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_MU2015_G2.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_MU2015_G2.invoice_generation_rule_sets	entity_condition_group_id
HSPI_MU2015_G2.saved_filters	entity_condition_group_id
HSPI_MU2015_G9.billing_alert_rules	entity_condition_group_id
HSPI_MU2015_G9.billing_controls	entity_condition_group_id
HSPI_MU2015_G9.claim_batch_generation_rules	entity_condition_group_id
HSPI_MU2015_G9.claim_field_adjustment_rules	entity_condition_group_id
HSPI_MU2015_G9.claim_item_generation_rules	entity_condition_group_id
HSPI_MU2015_G9.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_MU2015_G9.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_MU2015_G9.invoice_generation_rule_sets	entity_condition_group_id
HSPI_MU2015_G9.saved_filters	entity_condition_group_id
HSPI_Sandbox.billing_alert_rules	entity_condition_group_id
HSPI_Sandbox.billing_controls	entity_condition_group_id
HSPI_Sandbox.claim_batch_generation_rules	entity_condition_group_id
HSPI_Sandbox.claim_field_adjustment_rules	entity_condition_group_id
HSPI_Sandbox.claim_item_generation_rules	entity_condition_group_id
HSPI_Sandbox.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_Sandbox.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_Sandbox.invoice_generation_rule_sets	entity_condition_group_id
HSPI_Sandbox.saved_filters	entity_condition_group_id
HSPI_Summit_General.billing_alert_rules	entity_condition_group_id
HSPI_Summit_General.billing_controls	entity_condition_group_id
HSPI_Summit_General.claim_batch_generation_rules	entity_condition_group_id
HSPI_Summit_General.claim_field_adjustment_rules	entity_condition_group_id
HSPI_Summit_General.claim_item_generation_rules	entity_condition_group_id
HSPI_Summit_General.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_Summit_General.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_Summit_General.invoice_generation_rule_sets	entity_condition_group_id
HSPI_Summit_General.saved_filters	entity_condition_group_id
HSPI_United_Physicians.billing_alert_rules	entity_condition_group_id
HSPI_United_Physicians.billing_controls	entity_condition_group_id
HSPI_United_Physicians.claim_batch_generation_rules	entity_condition_group_id
HSPI_United_Physicians.claim_field_adjustment_rules	entity_condition_group_id
HSPI_United_Physicians.claim_item_generation_rules	entity_condition_group_id
HSPI_United_Physicians.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_United_Physicians.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_United_Physicians.invoice_generation_rule_sets	entity_condition_group_id
HSPI_United_Physicians.saved_filters	entity_condition_group_id
MPI.billing_alert_rules	entity_condition_group_id
MPI.billing_controls	entity_condition_group_id
MPI.claim_batch_generation_rules	entity_condition_group_id
MPI.claim_field_adjustment_rules	entity_condition_group_id
MPI.claim_item_generation_rules	entity_condition_group_id
MPI.claim_splitting_rule_charge_groups	entity_condition_group_id
MPI.claim_splitting_rules	encounter_matching_condition_group_id
MPI.invoice_generation_rule_sets	entity_condition_group_id
MPI.saved_filters	entity_condition_group_id
_1.schedules	sch_group_id
_1188.schedules	sch_group_id
_1218.schedules	sch_group_id
_1548.schedules	sch_group_id
_435.schedules	sch_group_id
_436.schedules	sch_group_id
_436_archive_testing.schedules	sch_group_id
_437.schedules	sch_group_id
_8.schedules	sch_group_id
_81.schedules	sch_group_id
_999.schedules	sch_group_id
aurora_standard.vault_icd9s	icd_group_id
common.clients	cli_medicare_group_id
common.clients	cli_medicaid_group_id

description

Table	Column
HSPI_Bastrop.devices	device_description
HSPI_CURES2015_B1.devices	device_description
HSPI_Central_Hospital.devices	device_description
HSPI_Dewitt.devices	device_description
HSPI_Fulton.devices	device_description
HSPI_Inferno.devices	device_description
HSPI_MU2015_E1.devices	device_description
HSPI_MU2015_G2.devices	device_description
HSPI_MU2015_G9.devices	device_description
HSPI_Sandbox.devices	device_description
HSPI_Summit_General.devices	device_description
HSPI_United_Physicians.devices	device_description
MPI.devices	device_description
_1.adjustment_rules	ar_description
_1.cqm_errors	cqmer_description
_1.encounters_alert_rules	ear_description
_1.patients_implantable_devices	pid_device_description
_1188.cqm_errors	cqmer_description
_1188.encounters_alert_rules	ear_description
_1188.patients_implantable_devices	pid_device_description
_1218.adjustment_rules	ar_description
_1218.cqm_errors	cqmer_description
_1218.encounters_alert_rules	ear_description
_1218.patients_implantable_devices	pid_device_description
_1548.adjustment_rules	ar_description
_1548.cqm_errors	cqmer_description
_1548.encounters_alert_rules	ear_description
_1548.patients_implantable_devices	pid_device_description
_435.adjustment_rules	ar_description
_435.cqm_errors	cqmer_description
_435.encounters_alert_rules	ear_description
_435.patients_implantable_devices	pid_device_description
_436.adjustment_rules	ar_description
_436.cqm_errors	cqmer_description
_436.encounters_alert_rules	ear_description
_436.patients_implantable_devices	pid_device_description
_436_archive_testing.adjustment_rules	ar_description
_436_archive_testing.cqm_errors	cqmer_description
_436_archive_testing.encounters_alert_rules	ear_description
_436_archive_testing.patients_implantable_devices	pid_device_description
_437.adjustment_rules	ar_description
_437.cqm_errors	cqmer_description
_437.encounters_alert_rules	ear_description
_437.patients_implantable_devices	pid_device_description
_8.adjustment_rules	ar_description
_8.cqm_errors	cqmer_description
_8.encounters_alert_rules	ear_description
_8.patients_implantable_devices	pid_device_description
_81.cqm_errors	cqmer_description
_81.encounters_alert_rules	ear_description
_81.patients_implantable_devices	pid_device_description
_999.adjustment_rules	ar_description
_999.cqm_errors	cqmer_description
_999.encounters_alert_rules	ear_description
_999.patients_implantable_devices	pid_device_description
ahiWiki.filearchive	fa_description
ahiWiki.image	img_description
ahiWiki.oldimage	oi_description
aurora_standard.medgenix_modules	module_description
aurora_standard.stfclond	asst_description
aurora_standard.stpapckv	acct_description
aurora_standard.stultypr	update_description
aurora_standard.stxparmd	val_description
aurora_standard.stydeddv	home_description
aurora_standard.styincdv	home_description
aurora_standard.styintfc	source_description
aurora_standard.styjobtc	job_description
aurora_standard.styobldv	home_description
aurora_standard.styptodv	home_description
common.data_import_options	dio_description
common.data_import_value_types	divt_description
common.dev_requests	dev_description
common.dev_requests_screencasts	drs_description
common.insurances_claim_indicators	insci_description
common.smoking_statuses	ss_description
common.test_codes	tco_x_specimen_description
common.test_codes_profiles	tcp_description