aurora_standard.chmaptnc

Field Type Null Default Key Extra Comment
group_id varchar(15) YES MUL
resource_code varchar(10) YES
reason varchar(11) YES
comment varchar(40) YES
dow varchar(3) YES
from_date date YES
to_date date YES
from_time time YES
to_time time YES
date_created date YES
who_created varchar(3) YES
date_purged date YES
who_purged varchar(3) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
reason
TableColumn
Azalea.pto_requestspto_reason
Loinc.loinc_codeslc_status_reason
SSO.login_eventsfailed_reason
_1.appointmentsapt_ins_reject_reason
_1.cpoe_responsescpoe_res_testing_reason
_1.encounters_soapesp_referring_reason
_1.hl7_accessionsacc_testing_reason
_1.hl7_ordersord_specimen_reject_reason
_1.patients_enrollmentspert_opt_out_reason
_1.patients_implantable_devicespid_inactive_reason
_1.patients_medicationspms_stop_reason
_1.patients_referralspref_reason
_1.radiology_resultsrad_res_testing_reason
_1.schedulessch_reason
_1188.appointmentsapt_ins_reject_reason
_1188.cpoe_responsescpoe_res_testing_reason
_1188.encounters_soapesp_referring_reason
_1188.hl7_accessionsacc_testing_reason
_1188.hl7_ordersord_specimen_reject_reason
_1188.patients_enrollmentspert_opt_out_reason
_1188.patients_implantable_devicespid_inactive_reason
_1188.patients_medicationspms_stop_reason
_1188.patients_referralspref_reason
_1188.radiology_resultsrad_res_testing_reason
_1188.schedulessch_reason
_1218.appointmentsapt_ins_reject_reason
_1218.cpoe_responsescpoe_res_testing_reason
_1218.encounters_soapesp_referring_reason
_1218.hl7_accessionsacc_testing_reason
_1218.hl7_ordersord_specimen_reject_reason
_1218.patients_enrollmentspert_opt_out_reason
_1218.patients_implantable_devicespid_inactive_reason
_1218.patients_medicationspms_stop_reason
_1218.patients_referralspref_reason
_1218.radiology_resultsrad_res_testing_reason
_1218.schedulessch_reason
_1548.appointmentsapt_ins_reject_reason
_1548.cpoe_responsescpoe_res_testing_reason
_1548.encounters_soapesp_referring_reason
_1548.hl7_accessionsacc_testing_reason
_1548.hl7_ordersord_specimen_reject_reason
_1548.patients_enrollmentspert_opt_out_reason
_1548.patients_implantable_devicespid_inactive_reason
_1548.patients_medicationspms_stop_reason
_1548.patients_referralspref_reason
_1548.radiology_resultsrad_res_testing_reason
_1548.schedulessch_reason
_435.appointmentsapt_ins_reject_reason
_435.cpoe_responsescpoe_res_testing_reason
_435.encounters_soapesp_referring_reason
_435.hl7_accessionsacc_testing_reason
_435.hl7_ordersord_specimen_reject_reason
_435.patients_enrollmentspert_opt_out_reason
_435.patients_implantable_devicespid_inactive_reason
_435.patients_medicationspms_stop_reason
_435.patients_referralspref_reason
_435.radiology_resultsrad_res_testing_reason
_435.schedulessch_reason
_436.appointmentsapt_ins_reject_reason
_436.cpoe_responsescpoe_res_testing_reason
_436.encounters_soapesp_referring_reason
_436.hl7_accessionsacc_testing_reason
_436.hl7_ordersord_specimen_reject_reason
_436.patients_enrollmentspert_opt_out_reason
_436.patients_implantable_devicespid_inactive_reason
_436.patients_medicationspms_stop_reason
_436.patients_referralspref_reason
_436.radiology_resultsrad_res_testing_reason
_436.schedulessch_reason
_436_archive_testing.appointmentsapt_ins_reject_reason
_436_archive_testing.cpoe_responsescpoe_res_testing_reason
_436_archive_testing.encounters_soapesp_referring_reason
_436_archive_testing.hl7_accessionsacc_testing_reason
_436_archive_testing.hl7_ordersord_specimen_reject_reason
_436_archive_testing.patients_enrollmentspert_opt_out_reason
_436_archive_testing.patients_implantable_devicespid_inactive_reason
_436_archive_testing.patients_medicationspms_stop_reason
_436_archive_testing.patients_referralspref_reason
_436_archive_testing.radiology_resultsrad_res_testing_reason
_436_archive_testing.schedulessch_reason
_437.appointmentsapt_ins_reject_reason
_437.cpoe_responsescpoe_res_testing_reason
_437.encounters_soapesp_referring_reason
_437.hl7_accessionsacc_testing_reason
_437.hl7_ordersord_specimen_reject_reason
_437.patients_enrollmentspert_opt_out_reason
_437.patients_implantable_devicespid_inactive_reason
_437.patients_medicationspms_stop_reason
_437.patients_referralspref_reason
_437.radiology_resultsrad_res_testing_reason
_437.schedulessch_reason
_8.appointmentsapt_ins_reject_reason
_8.cpoe_responsescpoe_res_testing_reason
_8.encounters_soapesp_referring_reason
_8.hl7_accessionsacc_testing_reason
_8.hl7_ordersord_specimen_reject_reason
_8.patients_enrollmentspert_opt_out_reason
_8.patients_implantable_devicespid_inactive_reason
_8.patients_medicationspms_stop_reason
_8.patients_referralspref_reason
_8.radiology_resultsrad_res_testing_reason
_8.schedulessch_reason
_81.appointmentsapt_ins_reject_reason
_81.cpoe_responsescpoe_res_testing_reason
_81.encounters_soapesp_referring_reason
_81.hl7_accessionsacc_testing_reason
_81.hl7_ordersord_specimen_reject_reason
_81.patients_enrollmentspert_opt_out_reason
_81.patients_implantable_devicespid_inactive_reason
_81.patients_medicationspms_stop_reason
_81.patients_referralspref_reason
_81.radiology_resultsrad_res_testing_reason
_81.schedulessch_reason
_999.appointmentsapt_ins_reject_reason
_999.cpoe_responsescpoe_res_testing_reason
_999.encounters_soapesp_referring_reason
_999.hl7_accessionsacc_testing_reason
_999.hl7_ordersord_specimen_reject_reason
_999.patients_enrollmentspert_opt_out_reason
_999.patients_implantable_devicespid_inactive_reason
_999.patients_medicationspms_stop_reason
_999.patients_referralspref_reason
_999.radiology_resultsrad_res_testing_reason
_999.schedulessch_reason
ahiWiki.filearchivefa_deleted_reason
ahiWiki.ipblocksipb_reason
ahiWiki.protected_titlespt_reason
aurora_standard.bdallvisdis_reason
aurora_standard.bdvisdis_reason
aurora_standard.bsvisdis_reason
aurora_standard.bsvisbddis_reason
aurora_standard.c7visdis_reason
aurora_standard.c9visdis_reason
aurora_standard.cavisdis_reason
aurora_standard.cavishdis_reason
aurora_standard.chhl7adtdischg_reason
aurora_standard.chmadmtrdischg_reason
aurora_standard.chmchpsdchg_dischg_reason
aurora_standard.chmcostadischg_reason
aurora_standard.chmcox06dischg_reason
aurora_standard.chmertmrer_reason
aurora_standard.chmhid4adischg_reason
aurora_standard.chmhidiadischg_reason
aurora_standard.chmmbc41med_b_reason
aurora_standard.chmrtrndtran_reason
aurora_standard.chmstatcdef_dis_reason
aurora_standard.chmutahdischg_reason
aurora_standard.chmutah1dischg_reason
aurora_standard.chmutah4dischg_reason
aurora_standard.chpbatadwarning_reason
aurora_standard.chpcoberenddate_reason
aurora_standard.chpcobrdenddate_reason
aurora_standard.chptermrtermination_reason
aurora_standard.hhmadmtrdischg_reason
aurora_standard.hl7gt1cont_reason
aurora_standard.hl7in2empl_cont_reason
aurora_standard.hl7pv2admit_reason
aurora_standard.hl7pv2trans_reason
aurora_standard.kcvisdis_reason
aurora_standard.kcvisitdis_reason
aurora_standard.oeordauditaudit_reason
aurora_standard.oeorderorder_reason
aurora_standard.schovrwtblkcunblock_reason
aurora_standard.stoordrdcm_dm_reason
aurora_standard.stucntrccm_reason
aurora_standard.stucntrcdm_reason
aurora_standard.stuordrdcm_dm_reason
aurora_standard.stxvckrdvoid_reason
aurora_standard.tmpmrrptdischg_reason
common.applicantsapp_arrest_reason
common.applicantsapp_law_reason
common.applicantsapp_convicted_reason
common.applicantsapp_not_adjudicated_reason
common.applicantsapp_not_convicted_reason
common.applicantsapp_civil_reason
common.clients_contract_dataccd_churn_reason
common.clients_enrollments_mapcem_no_optout_reason
common.loinc_codeslc_status_reason
group_id
TableColumn
HSPI_Bastrop.billing_alert_rulesentity_condition_group_id
HSPI_Bastrop.claim_batch_generation_rulesentity_condition_group_id
HSPI_Bastrop.claim_field_adjustment_rulesentity_condition_group_id
HSPI_Bastrop.claim_item_generation_rulesentity_condition_group_id
HSPI_Bastrop.saved_filtersentity_condition_group_id
HSPI_CURES2015_B1.billing_alert_rulesentity_condition_group_id
HSPI_CURES2015_B1.billing_controlsentity_condition_group_id
HSPI_CURES2015_B1.claim_batch_generation_rulesentity_condition_group_id
HSPI_CURES2015_B1.claim_field_adjustment_rulesentity_condition_group_id
HSPI_CURES2015_B1.claim_item_generation_rulesentity_condition_group_id
HSPI_CURES2015_B1.claim_splitting_rule_charge_groupsentity_condition_group_id
HSPI_CURES2015_B1.claim_splitting_rulesencounter_matching_condition_group_id
HSPI_CURES2015_B1.invoice_generation_rule_setsentity_condition_group_id
HSPI_CURES2015_B1.saved_filtersentity_condition_group_id
HSPI_Central_Hospital.billing_alert_rulesentity_condition_group_id
HSPI_Central_Hospital.billing_controlsentity_condition_group_id
HSPI_Central_Hospital.claim_batch_generation_rulesentity_condition_group_id
HSPI_Central_Hospital.claim_field_adjustment_rulesentity_condition_group_id
HSPI_Central_Hospital.claim_item_generation_rulesentity_condition_group_id
HSPI_Central_Hospital.claim_splitting_rule_charge_groupsentity_condition_group_id
HSPI_Central_Hospital.claim_splitting_rulesencounter_matching_condition_group_id
HSPI_Central_Hospital.invoice_generation_rule_setsentity_condition_group_id
HSPI_Central_Hospital.saved_filtersentity_condition_group_id
HSPI_Dewitt.billing_alert_rulesentity_condition_group_id
HSPI_Dewitt.billing_controlsentity_condition_group_id
HSPI_Dewitt.claim_batch_generation_rulesentity_condition_group_id
HSPI_Dewitt.claim_field_adjustment_rulesentity_condition_group_id
HSPI_Dewitt.claim_item_generation_rulesentity_condition_group_id
HSPI_Dewitt.claim_splitting_rule_charge_groupsentity_condition_group_id
HSPI_Dewitt.claim_splitting_rulesencounter_matching_condition_group_id
HSPI_Dewitt.invoice_generation_rule_setsentity_condition_group_id
HSPI_Dewitt.saved_filtersentity_condition_group_id
HSPI_Fulton.billing_alert_rulesentity_condition_group_id
HSPI_Fulton.billing_controlsentity_condition_group_id
HSPI_Fulton.claim_batch_generation_rulesentity_condition_group_id
HSPI_Fulton.claim_field_adjustment_rulesentity_condition_group_id
HSPI_Fulton.claim_item_generation_rulesentity_condition_group_id
HSPI_Fulton.claim_splitting_rule_charge_groupsentity_condition_group_id
HSPI_Fulton.claim_splitting_rulesencounter_matching_condition_group_id
HSPI_Fulton.invoice_generation_rule_setsentity_condition_group_id
HSPI_Fulton.saved_filtersentity_condition_group_id
HSPI_Inferno.billing_alert_rulesentity_condition_group_id
HSPI_Inferno.billing_controlsentity_condition_group_id
HSPI_Inferno.claim_batch_generation_rulesentity_condition_group_id
HSPI_Inferno.claim_field_adjustment_rulesentity_condition_group_id
HSPI_Inferno.claim_item_generation_rulesentity_condition_group_id
HSPI_Inferno.claim_splitting_rule_charge_groupsentity_condition_group_id
HSPI_Inferno.claim_splitting_rulesencounter_matching_condition_group_id
HSPI_Inferno.invoice_generation_rule_setsentity_condition_group_id
HSPI_Inferno.saved_filtersentity_condition_group_id
HSPI_MU2015_E1.billing_alert_rulesentity_condition_group_id
HSPI_MU2015_E1.billing_controlsentity_condition_group_id
HSPI_MU2015_E1.claim_batch_generation_rulesentity_condition_group_id
HSPI_MU2015_E1.claim_field_adjustment_rulesentity_condition_group_id
HSPI_MU2015_E1.claim_item_generation_rulesentity_condition_group_id
HSPI_MU2015_E1.claim_splitting_rule_charge_groupsentity_condition_group_id
HSPI_MU2015_E1.claim_splitting_rulesencounter_matching_condition_group_id
HSPI_MU2015_E1.invoice_generation_rule_setsentity_condition_group_id
HSPI_MU2015_E1.saved_filtersentity_condition_group_id
HSPI_MU2015_G2.billing_alert_rulesentity_condition_group_id
HSPI_MU2015_G2.billing_controlsentity_condition_group_id
HSPI_MU2015_G2.claim_batch_generation_rulesentity_condition_group_id
HSPI_MU2015_G2.claim_field_adjustment_rulesentity_condition_group_id
HSPI_MU2015_G2.claim_item_generation_rulesentity_condition_group_id
HSPI_MU2015_G2.claim_splitting_rule_charge_groupsentity_condition_group_id
HSPI_MU2015_G2.claim_splitting_rulesencounter_matching_condition_group_id
HSPI_MU2015_G2.invoice_generation_rule_setsentity_condition_group_id
HSPI_MU2015_G2.saved_filtersentity_condition_group_id
HSPI_MU2015_G9.billing_alert_rulesentity_condition_group_id
HSPI_MU2015_G9.billing_controlsentity_condition_group_id
HSPI_MU2015_G9.claim_batch_generation_rulesentity_condition_group_id
HSPI_MU2015_G9.claim_field_adjustment_rulesentity_condition_group_id
HSPI_MU2015_G9.claim_item_generation_rulesentity_condition_group_id
HSPI_MU2015_G9.claim_splitting_rule_charge_groupsentity_condition_group_id
HSPI_MU2015_G9.claim_splitting_rulesencounter_matching_condition_group_id
HSPI_MU2015_G9.invoice_generation_rule_setsentity_condition_group_id
HSPI_MU2015_G9.saved_filtersentity_condition_group_id
HSPI_Sandbox.billing_alert_rulesentity_condition_group_id
HSPI_Sandbox.billing_controlsentity_condition_group_id
HSPI_Sandbox.claim_batch_generation_rulesentity_condition_group_id
HSPI_Sandbox.claim_field_adjustment_rulesentity_condition_group_id
HSPI_Sandbox.claim_item_generation_rulesentity_condition_group_id
HSPI_Sandbox.claim_splitting_rule_charge_groupsentity_condition_group_id
HSPI_Sandbox.claim_splitting_rulesencounter_matching_condition_group_id
HSPI_Sandbox.invoice_generation_rule_setsentity_condition_group_id
HSPI_Sandbox.saved_filtersentity_condition_group_id
HSPI_Summit_General.billing_alert_rulesentity_condition_group_id
HSPI_Summit_General.billing_controlsentity_condition_group_id
HSPI_Summit_General.claim_batch_generation_rulesentity_condition_group_id
HSPI_Summit_General.claim_field_adjustment_rulesentity_condition_group_id
HSPI_Summit_General.claim_item_generation_rulesentity_condition_group_id
HSPI_Summit_General.claim_splitting_rule_charge_groupsentity_condition_group_id
HSPI_Summit_General.claim_splitting_rulesencounter_matching_condition_group_id
HSPI_Summit_General.invoice_generation_rule_setsentity_condition_group_id
HSPI_Summit_General.saved_filtersentity_condition_group_id
HSPI_United_Physicians.billing_alert_rulesentity_condition_group_id
HSPI_United_Physicians.billing_controlsentity_condition_group_id
HSPI_United_Physicians.claim_batch_generation_rulesentity_condition_group_id
HSPI_United_Physicians.claim_field_adjustment_rulesentity_condition_group_id
HSPI_United_Physicians.claim_item_generation_rulesentity_condition_group_id
HSPI_United_Physicians.claim_splitting_rule_charge_groupsentity_condition_group_id
HSPI_United_Physicians.claim_splitting_rulesencounter_matching_condition_group_id
HSPI_United_Physicians.invoice_generation_rule_setsentity_condition_group_id
HSPI_United_Physicians.saved_filtersentity_condition_group_id
MPI.billing_alert_rulesentity_condition_group_id
MPI.billing_controlsentity_condition_group_id
MPI.claim_batch_generation_rulesentity_condition_group_id
MPI.claim_field_adjustment_rulesentity_condition_group_id
MPI.claim_item_generation_rulesentity_condition_group_id
MPI.claim_splitting_rule_charge_groupsentity_condition_group_id
MPI.claim_splitting_rulesencounter_matching_condition_group_id
MPI.invoice_generation_rule_setsentity_condition_group_id
MPI.saved_filtersentity_condition_group_id
_1.schedulessch_group_id
_1188.schedulessch_group_id
_1218.schedulessch_group_id
_1548.schedulessch_group_id
_435.schedulessch_group_id
_436.schedulessch_group_id
_436_archive_testing.schedulessch_group_id
_437.schedulessch_group_id
_8.schedulessch_group_id
_81.schedulessch_group_id
_999.schedulessch_group_id
aurora_standard.vault_icd9sicd_group_id
common.clientscli_medicare_group_id
common.clientscli_medicaid_group_id
from_date
TableColumn
_1.encounters_ub04enc_ub04_06_from_date
_1.schedulessch_from_date
_1.schedules_eventssevnt_from_date
_1.taskstask_from_date
_1188.encounters_ub04enc_ub04_06_from_date
_1188.schedulessch_from_date
_1188.schedules_eventssevnt_from_date
_1188.taskstask_from_date
_1218.encounters_ub04enc_ub04_06_from_date
_1218.schedulessch_from_date
_1218.schedules_eventssevnt_from_date
_1218.taskstask_from_date
_1548.encounters_ub04enc_ub04_06_from_date
_1548.schedulessch_from_date
_1548.schedules_eventssevnt_from_date
_1548.taskstask_from_date
_435.encounters_ub04enc_ub04_06_from_date
_435.schedulessch_from_date
_435.schedules_eventssevnt_from_date
_435.taskstask_from_date
_436.encounters_ub04enc_ub04_06_from_date
_436.schedulessch_from_date
_436.schedules_eventssevnt_from_date
_436.taskstask_from_date
_436_archive_testing.encounters_ub04enc_ub04_06_from_date
_436_archive_testing.schedulessch_from_date
_436_archive_testing.schedules_eventssevnt_from_date
_436_archive_testing.taskstask_from_date
_437.encounters_ub04enc_ub04_06_from_date
_437.schedulessch_from_date
_437.schedules_eventssevnt_from_date
_437.taskstask_from_date
_8.encounters_ub04enc_ub04_06_from_date
_8.schedulessch_from_date
_8.schedules_eventssevnt_from_date
_8.taskstask_from_date
_81.encounters_ub04enc_ub04_06_from_date
_81.schedulessch_from_date
_81.schedules_eventssevnt_from_date
_81.taskstask_from_date
_999.encounters_ub04enc_ub04_06_from_date
_999.schedulessch_from_date
_999.schedules_eventssevnt_from_date
_999.taskstask_from_date
aurora_standard.chmardydrev_from_date
aurora_standard.chmcptvceff_from_date
aurora_standard.chmvrsnceff_from_date
common.rcm_stats_generalrcmsg_from_date
common.rcm_stats_practice_analysisrcmspa_from_date
comment
TableColumn
_1.orders_commentsorc_comment
_1.orders_comments_templatesorct_comment
_1.precerts_commentsprc_comment
_1.radiology_order_notesradnot_comment
_1188.orders_commentsorc_comment
_1188.orders_comments_templatesorct_comment
_1188.precerts_commentsprc_comment
_1188.radiology_order_notesradnot_comment
_1218.orders_commentsorc_comment
_1218.orders_comments_templatesorct_comment
_1218.precerts_commentsprc_comment
_1218.radiology_order_notesradnot_comment
_1548.orders_commentsorc_comment
_1548.orders_comments_templatesorct_comment
_1548.precerts_commentsprc_comment
_1548.radiology_order_notesradnot_comment
_435.orders_commentsorc_comment
_435.orders_comments_templatesorct_comment
_435.precerts_commentsprc_comment
_435.radiology_order_notesradnot_comment
_436.orders_commentsorc_comment
_436.orders_comments_templatesorct_comment
_436.precerts_commentsprc_comment
_436.radiology_order_notesradnot_comment
_436_archive_testing.orders_commentsorc_comment
_436_archive_testing.orders_comments_templatesorct_comment
_436_archive_testing.precerts_commentsprc_comment
_436_archive_testing.radiology_order_notesradnot_comment
_437.orders_commentsorc_comment
_437.orders_comments_templatesorct_comment
_437.precerts_commentsprc_comment
_437.radiology_order_notesradnot_comment
_8.orders_commentsorc_comment
_8.orders_comments_templatesorct_comment
_8.precerts_commentsprc_comment
_8.radiology_order_notesradnot_comment
_81.orders_commentsorc_comment
_81.orders_comments_templatesorct_comment
_81.precerts_commentsprc_comment
_81.radiology_order_notesradnot_comment
_999.orders_commentsorc_comment
_999.orders_comments_templatesorct_comment
_999.precerts_commentsprc_comment
_999.radiology_order_notesradnot_comment
ahiWiki.archivear_comment
ahiWiki.logginglog_comment
ahiWiki.recentchangesrc_comment
ahiWiki.revisionrev_comment
aurora_standard.audppayddenial_comment
aurora_standard.chmabstrstatus_comment
aurora_standard.chmblogddenial_comment
aurora_standard.chmbremddenial_comment
aurora_standard.chmmcqudemp_comment
aurora_standard.chmmcqudsp_emp_comment
aurora_standard.chmozpcdacct_comment
aurora_standard.chmppayddenial_comment
aurora_standard.chpevaldreviewer_comment
aurora_standard.hl7ntesrc_comment
aurora_standard.hl7nteadsrc_comment
common.service_tickets_commentsstcp_comment
template_library.orders_comments_templatesorct_comment
to_date
TableColumn
_1.schedulessch_to_date
_1.schedules_eventssevnt_to_date
_1.taskstask_to_date
_1188.schedulessch_to_date
_1188.schedules_eventssevnt_to_date
_1188.taskstask_to_date
_1218.schedulessch_to_date
_1218.schedules_eventssevnt_to_date
_1218.taskstask_to_date
_1548.schedulessch_to_date
_1548.schedules_eventssevnt_to_date
_1548.taskstask_to_date
_435.schedulessch_to_date
_435.schedules_eventssevnt_to_date
_435.taskstask_to_date
_436.schedulessch_to_date
_436.schedules_eventssevnt_to_date
_436.taskstask_to_date
_436_archive_testing.schedulessch_to_date
_436_archive_testing.schedules_eventssevnt_to_date
_436_archive_testing.taskstask_to_date
_437.schedulessch_to_date
_437.schedules_eventssevnt_to_date
_437.taskstask_to_date
_8.schedulessch_to_date
_8.schedules_eventssevnt_to_date
_8.taskstask_to_date
_81.schedulessch_to_date
_81.schedules_eventssevnt_to_date
_81.taskstask_to_date
_999.schedulessch_to_date
_999.schedules_eventssevnt_to_date
_999.taskstask_to_date
common.rcm_stats_agingrcmsa_to_date
common.rcm_stats_generalrcmsg_to_date
common.rcm_stats_practice_analysisrcmspa_to_date
date_created
TableColumn
common.service_tickets_commentsstcp_date_created