aurora_standard.schresourcec

Field	Type	Null	Default	Key	Extra
fac_no	varchar(3)	NO		MUL
group_id	smallint(6)	NO		MUL
resource_id	bigint(20)	NO	0
resource_desc	varchar(30)	YES
active_flag	varchar(1)	YES
sun	varchar(1)	YES
mon	varchar(1)	YES
tue	varchar(1)	YES
wed	varchar(1)	YES
thu	varchar(1)	YES
fri	varchar(1)	YES
sat	varchar(1)	YES
recurrence_week	smallint(6)	YES
emr_no_reqd	varchar(1)	YES
chs_rowID	int(11)	NO		PRI	auto_increment
bgcolor	varchar(255)	YES
textcolor	varchar(255)	YES
short_code	varchar(255)	YES
default_physician	int(11)	YES
resource_rules	text	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

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

mon

Table	Column
aurora_standard.chtshftc	valid_mon
aurora_standard.logchrgd	hltr_mon
aurora_standard.logchrgd	card_mon

tue

Table	Column
aurora_standard.chtshftc	valid_tue

wed

Table	Column
aurora_standard.chtshftc	valid_wed

thu

Table	Column
aurora_standard.chtshftc	valid_thu

fri

Table	Column
aurora_standard.chtshftc	valid_fri

sat

Table	Column
aurora_standard.chtshftc	valid_sat

sun

Table	Column
aurora_standard.chtshftc	valid_sun