aurora_standard.schsecurityd

Field	Type	Null	Key
input_by	int(11)	YES	MUL
fac_no	varchar(3)	YES	MUL
group_id	varchar(15)	YES
resource_id	varchar(15)	YES
user_add	varchar(1)	YES
user_update	varchar(1)	YES
user_view_only	varchar(1)	YES
user_cloaked_view	varchar(1)	YES
user_no_access	varchar(1)	YES
chs_rowID	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

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