aurora_standard.schprocedurc

Field	Type	Null	Default	Key	Extra
fac_no	varchar(3)	NO	0	MUL
group_id	bigint(20)	NO	0
procedure_id	int(11)	NO	0	MUL
procedure_desc	varchar(30)	YES
duration	smallint(6)	YES
active_flag	varchar(1)	YES
min_age	varchar(10)	YES
preps	varchar(255)	YES
diagnosis_reqd	varchar(1)	YES
prep_id	int(11)	YES
time_delay	smallint(6)	YES
nxt_procedure	int(11)	YES
chs_rowID	int(11)	NO		PRI	auto_increment
text_color	varchar(255)	YES
background_color	varchar(255)	YES
cqm_encounter_type_snomed_id	int(11)	YES
cqm_encounter_type_cpt_id	int(11)	YES
cqm_encounter_type_hcpcs_id	int(11)	YES

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

duration

Table	Column
HSPI_Bastrop.medication_requests	dosage_duration
HSPI_CURES2015_B1.medication_requests	dosage_duration
HSPI_Central_Hospital.medication_requests	dosage_duration
HSPI_Dewitt.medication_requests	dosage_duration
HSPI_Fulton.medication_requests	dosage_duration
HSPI_Inferno.medication_requests	dosage_duration
HSPI_MU2015_E1.medication_requests	dosage_duration
HSPI_MU2015_G2.medication_requests	dosage_duration
HSPI_MU2015_G9.medication_requests	dosage_duration
HSPI_Sandbox.medication_requests	dosage_duration
HSPI_Summit_General.medication_requests	dosage_duration
HSPI_United_Physicians.medication_requests	dosage_duration
MPI.medication_requests	dosage_duration
SSO.users	lock_next_duration
_1.appointment_recurrence	arec_apt_duration
_1.appointments	apt_duration
_1.appointments_reasons	are_duration
_1.orders	ord_duration
_1.orders_templates	ordt_duration
_1.patients_medications	pms_duration
_1.patients_prescriptions	prx_duration
_1.radiology_orders	rad_duration
_1.recalls_reasons	rr_duration
_1.schedules	sch_duration
_1.tasks_categories	tcat_duration
_1188.appointment_recurrence	arec_apt_duration
_1188.appointments	apt_duration
_1188.appointments_reasons	are_duration
_1188.orders	ord_duration
_1188.orders_templates	ordt_duration
_1188.patients_medications	pms_duration
_1188.patients_prescriptions	prx_duration
_1188.radiology_orders	rad_duration
_1188.recalls_reasons	rr_duration
_1188.schedules	sch_duration
_1188.tasks_categories	tcat_duration
_1218.appointment_recurrence	arec_apt_duration
_1218.appointments	apt_duration
_1218.appointments_reasons	are_duration
_1218.orders	ord_duration
_1218.orders_templates	ordt_duration
_1218.patients_medications	pms_duration
_1218.patients_prescriptions	prx_duration
_1218.radiology_orders	rad_duration
_1218.recalls_reasons	rr_duration
_1218.schedules	sch_duration
_1218.tasks_categories	tcat_duration
_1548.appointment_recurrence	arec_apt_duration
_1548.appointments	apt_duration
_1548.appointments_reasons	are_duration
_1548.orders	ord_duration
_1548.orders_templates	ordt_duration
_1548.patients_medications	pms_duration
_1548.patients_prescriptions	prx_duration
_1548.radiology_orders	rad_duration
_1548.recalls_reasons	rr_duration
_1548.schedules	sch_duration
_1548.tasks_categories	tcat_duration
_435.appointment_recurrence	arec_apt_duration
_435.appointments	apt_duration
_435.appointments_reasons	are_duration
_435.orders	ord_duration
_435.orders_templates	ordt_duration
_435.patients_medications	pms_duration
_435.patients_prescriptions	prx_duration
_435.radiology_orders	rad_duration
_435.recalls_reasons	rr_duration
_435.schedules	sch_duration
_435.tasks_categories	tcat_duration
_436.appointment_recurrence	arec_apt_duration
_436.appointments	apt_duration
_436.appointments_reasons	are_duration
_436.orders	ord_duration
_436.orders_templates	ordt_duration
_436.patients_medications	pms_duration
_436.patients_prescriptions	prx_duration
_436.radiology_orders	rad_duration
_436.recalls_reasons	rr_duration
_436.schedules	sch_duration
_436.tasks_categories	tcat_duration
_436_archive_testing.appointment_recurrence	arec_apt_duration
_436_archive_testing.appointments	apt_duration
_436_archive_testing.appointments_reasons	are_duration
_436_archive_testing.orders	ord_duration
_436_archive_testing.orders_templates	ordt_duration
_436_archive_testing.patients_medications	pms_duration
_436_archive_testing.patients_prescriptions	prx_duration
_436_archive_testing.radiology_orders	rad_duration
_436_archive_testing.recalls_reasons	rr_duration
_436_archive_testing.schedules	sch_duration
_436_archive_testing.tasks_categories	tcat_duration
_437.appointment_recurrence	arec_apt_duration
_437.appointments	apt_duration
_437.appointments_reasons	are_duration
_437.orders	ord_duration
_437.orders_templates	ordt_duration
_437.patients_medications	pms_duration
_437.patients_prescriptions	prx_duration
_437.radiology_orders	rad_duration
_437.recalls_reasons	rr_duration
_437.schedules	sch_duration
_437.tasks_categories	tcat_duration
_8.appointment_recurrence	arec_apt_duration
_8.appointments	apt_duration
_8.appointments_reasons	are_duration
_8.orders	ord_duration
_8.orders_templates	ordt_duration
_8.patients_medications	pms_duration
_8.patients_prescriptions	prx_duration
_8.radiology_orders	rad_duration
_8.recalls_reasons	rr_duration
_8.schedules	sch_duration
_8.tasks_categories	tcat_duration
_81.appointment_recurrence	arec_apt_duration
_81.appointments	apt_duration
_81.appointments_reasons	are_duration
_81.orders	ord_duration
_81.orders_templates	ordt_duration
_81.patients_medications	pms_duration
_81.patients_prescriptions	prx_duration
_81.radiology_orders	rad_duration
_81.recalls_reasons	rr_duration
_81.schedules	sch_duration
_81.tasks_categories	tcat_duration
_999.appointment_recurrence	arec_apt_duration
_999.appointments	apt_duration
_999.appointments_reasons	are_duration
_999.orders	ord_duration
_999.orders_templates	ordt_duration
_999.patients_medications	pms_duration
_999.patients_prescriptions	prx_duration
_999.radiology_orders	rad_duration
_999.recalls_reasons	rr_duration
_999.schedules	sch_duration
_999.tasks_categories	tcat_duration
aurora_standard.chpcobrc	months_duration
common.telehealth_sessions	ths_duration
common.telehealth_sessions	ths_summed_duration
template_library.orders_templates	ordt_duration
xlnt.builds	build_duration

background_color

Table	Column
_1.inventory_classes	invc_background_color
_1188.inventory_classes	invc_background_color
_1218.inventory_classes	invc_background_color
_1548.inventory_classes	invc_background_color
_435.inventory_classes	invc_background_color
_436.inventory_classes	invc_background_color
_436_archive_testing.inventory_classes	invc_background_color
_437.inventory_classes	invc_background_color
_8.inventory_classes	invc_background_color
_81.inventory_classes	invc_background_color
_999.inventory_classes	invc_background_color

fac_no

Table	Column
aurora_standard.chmprica	prev_fac_no
aurora_standard.chmprica	cur_fac_no
aurora_standard.chpcashr	cash_fac_no
aurora_standard.chpcobpd	cash_fac_no
aurora_standard.chpcobpd	bal_fac_no
aurora_standard.chscustd	dept_fac_no
aurora_standard.chshotlr	dept_fac_no
aurora_standard.chtemplr	dflt_fac_no
aurora_standard.curs_temp	cash_fac_no
aurora_standard.curs_temp	ap_fac_no
aurora_standard.stgrowpd	rod_beg_fac_no
aurora_standard.stgrowpd	rod_end_fac_no
aurora_standard.stpcashd	dist_fac_no
aurora_standard.stpcashd	disc_fac_no
aurora_standard.stpcashe	cash_fac_no
aurora_standard.stpcntrc	cash_fac_no
aurora_standard.stpcntrc	disc_fac_no
aurora_standard.stpinvce	cash_fac_no
aurora_standard.stpopend	ap_fac_no
aurora_standard.stpopend	cash_fac_no
aurora_standard.stucntrc	cash_fac_no
aurora_standard.stuinvce	cash_fac_no
aurora_standard.stxfinsd	fin_fac_no
aurora_standard.styaccrr	liab_fac_no
aurora_standard.styaccrr	expense_fac_no
aurora_standard.styemplr	cash_fac_no
aurora_standard.stypayfd	cash_fac_no
aurora_standard.stypayod	bal_fac_no
aurora_standard.stypayre	cash_fac_no
aurora_standard.styrevsd	cash_fac_no
aurora_standard.stytyper	cash_fac_no