aurora_standard.schopendatec

Field	Type	Null	Key	Extra
fac_no	varchar(3)	YES
group_id	bigint(20)	YES
resource_id	bigint(20)	YES	MUL
seq	bigint(20)	YES
open_type	varchar(1)	YES
open_date	date	YES
open_days	smallint(6)	YES
chs_rowID	int(11)	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

seq

Table	Column
aurora_standard.anotesd	an_seq
aurora_standard.cgxjoind	join_seq
aurora_standard.chlrescd	res_seq
aurora_standard.chmarerd	rec_seq
aurora_standard.chmblogd	pay_seq
aurora_standard.chmbnote	note_seq
aurora_standard.chmbremd	pay_seq
aurora_standard.chmdfypd	dfy_seq
aurora_standard.chmescmr	dx_seq
aurora_standard.chmhdpcd	h_seq
aurora_standard.chmhierd	rec_seq
aurora_standard.chmtkl1d	disp_seq
aurora_standard.chmtkl2d	disp_seq
aurora_standard.chmtkl3d	disp_seq
aurora_standard.chmtkl4d	disp_seq
aurora_standard.chmtkl5d	disp_seq
aurora_standard.chmtkl6d	disp_seq
aurora_standard.chmtkl7d	disp_seq
aurora_standard.chmtkl8d	disp_seq
aurora_standard.chmtkl9d	disp_seq
aurora_standard.chmtxerd	rec_seq
aurora_standard.choordrc	cat_seq
aurora_standard.chxexamd	req_seq
aurora_standard.chxexamr	req_seq
aurora_standard.chxfarcd	req_seq
aurora_standard.chxlarcd	req_seq
aurora_standard.chxleasd	req_seq
aurora_standard.chxleasr	req_seq
aurora_standard.chyrespd	req_seq
aurora_standard.chyrespr	req_seq
aurora_standard.oeitmcatc	itm_seq
aurora_standard.oeitmtextc	itm_seq
aurora_standard.oeordtxtd	order_seq
aurora_standard.oeurgc	urg_seq
aurora_standard.schactivec	display_seq
aurora_standard.schanesiac	ane_seq
aurora_standard.schapptmastr	appt_seq
aurora_standard.schapptnoted	note_seq
aurora_standard.schapptprepd	prep_seq
aurora_standard.schappttempr	appt_seq
aurora_standard.schmultic	display_seq
aurora_standard.schprocedurd	prep_seq
aurora_standard.stgwhsed	processing_seq
aurora_standard.stxchrtr	processing_seq
aurora_standard.stxchrtv	processing_seq
aurora_standard.stystwhr	ann_seq
aurora_standard.stystwhr	inc_lim_seq
aurora_standard.stystwhr	std_seq
aurora_standard.stystwhr	prs_seq
aurora_standard.stystwhr	fed_calc_seq
aurora_standard.stystwhr	fed_red_seq
aurora_standard.stystwhr	dep_seq
aurora_standard.stystwhr	tc_seq
aurora_standard.stystwhr	st_tax_seq
aurora_standard.stystwhr	fed_tax_seq
aurora_standard.stystwhr	adjust_seq
aurora_standard.surpcgrpc	grp_seq
aurora_standard.surpcnotesd	note_seq

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