aurora_standard.chmnursc

Field Type Null Default Key Extra Comment
station_code varchar(10) YES UNI
hosp_service varchar(20) YES
description varchar(20) YES MUL
in_census varchar(1) YES
order_id varchar(20) YES MUL
census_beds smallint(6) YES
fac_no varchar(3) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
description
TableColumn
HSPI_Bastrop.devicesdevice_description
HSPI_CURES2015_B1.devicesdevice_description
HSPI_Central_Hospital.devicesdevice_description
HSPI_Dewitt.devicesdevice_description
HSPI_Fulton.devicesdevice_description
HSPI_Inferno.devicesdevice_description
HSPI_MU2015_E1.devicesdevice_description
HSPI_MU2015_G2.devicesdevice_description
HSPI_MU2015_G9.devicesdevice_description
HSPI_Sandbox.devicesdevice_description
HSPI_Summit_General.devicesdevice_description
HSPI_United_Physicians.devicesdevice_description
MPI.devicesdevice_description
_1.adjustment_rulesar_description
_1.cqm_errorscqmer_description
_1.encounters_alert_rulesear_description
_1.patients_implantable_devicespid_device_description
_1188.cqm_errorscqmer_description
_1188.encounters_alert_rulesear_description
_1188.patients_implantable_devicespid_device_description
_1218.adjustment_rulesar_description
_1218.cqm_errorscqmer_description
_1218.encounters_alert_rulesear_description
_1218.patients_implantable_devicespid_device_description
_1548.adjustment_rulesar_description
_1548.cqm_errorscqmer_description
_1548.encounters_alert_rulesear_description
_1548.patients_implantable_devicespid_device_description
_435.adjustment_rulesar_description
_435.cqm_errorscqmer_description
_435.encounters_alert_rulesear_description
_435.patients_implantable_devicespid_device_description
_436.adjustment_rulesar_description
_436.cqm_errorscqmer_description
_436.encounters_alert_rulesear_description
_436.patients_implantable_devicespid_device_description
_436_archive_testing.adjustment_rulesar_description
_436_archive_testing.cqm_errorscqmer_description
_436_archive_testing.encounters_alert_rulesear_description
_436_archive_testing.patients_implantable_devicespid_device_description
_437.adjustment_rulesar_description
_437.cqm_errorscqmer_description
_437.encounters_alert_rulesear_description
_437.patients_implantable_devicespid_device_description
_8.adjustment_rulesar_description
_8.cqm_errorscqmer_description
_8.encounters_alert_rulesear_description
_8.patients_implantable_devicespid_device_description
_81.cqm_errorscqmer_description
_81.encounters_alert_rulesear_description
_81.patients_implantable_devicespid_device_description
_999.adjustment_rulesar_description
_999.cqm_errorscqmer_description
_999.encounters_alert_rulesear_description
_999.patients_implantable_devicespid_device_description
ahiWiki.filearchivefa_description
ahiWiki.imageimg_description
ahiWiki.oldimageoi_description
aurora_standard.medgenix_modulesmodule_description
aurora_standard.stfclondasst_description
aurora_standard.stpapckvacct_description
aurora_standard.stultyprupdate_description
aurora_standard.stxparmdval_description
aurora_standard.stydeddvhome_description
aurora_standard.styincdvhome_description
aurora_standard.styintfcsource_description
aurora_standard.styjobtcjob_description
aurora_standard.styobldvhome_description
aurora_standard.styptodvhome_description
common.data_import_optionsdio_description
common.data_import_value_typesdivt_description
common.dev_requestsdev_description
common.dev_requests_screencastsdrs_description
common.insurances_claim_indicatorsinsci_description
common.smoking_statusesss_description
common.test_codestco_x_specimen_description
common.test_codes_profilestcp_description
order_id
TableColumn
HSPI_Bastrop.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_Bastrop.laboratory_order_specimens_maplaboratory_order_id
HSPI_Bastrop.laboratory_resultslaboratory_order_id
HSPI_CURES2015_B1.care_plan_activitieslaboratory_order_id
HSPI_CURES2015_B1.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_CURES2015_B1.laboratory_order_specimens_maplaboratory_order_id
HSPI_CURES2015_B1.laboratory_resultslaboratory_order_id
HSPI_Central_Hospital.care_plan_activitieslaboratory_order_id
HSPI_Central_Hospital.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_Central_Hospital.laboratory_order_specimens_maplaboratory_order_id
HSPI_Central_Hospital.laboratory_resultslaboratory_order_id
HSPI_Dewitt.care_plan_activitieslaboratory_order_id
HSPI_Dewitt.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_Dewitt.laboratory_order_specimens_maplaboratory_order_id
HSPI_Dewitt.laboratory_resultslaboratory_order_id
HSPI_Fulton.care_plan_activitieslaboratory_order_id
HSPI_Fulton.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_Fulton.laboratory_order_specimens_maplaboratory_order_id
HSPI_Fulton.laboratory_resultslaboratory_order_id
HSPI_Inferno.care_plan_activitieslaboratory_order_id
HSPI_Inferno.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_Inferno.laboratory_order_specimens_maplaboratory_order_id
HSPI_Inferno.laboratory_resultslaboratory_order_id
HSPI_MU2015_E1.care_plan_activitieslaboratory_order_id
HSPI_MU2015_E1.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_MU2015_E1.laboratory_order_specimens_maplaboratory_order_id
HSPI_MU2015_E1.laboratory_resultslaboratory_order_id
HSPI_MU2015_G2.care_plan_activitieslaboratory_order_id
HSPI_MU2015_G2.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_MU2015_G2.laboratory_order_specimens_maplaboratory_order_id
HSPI_MU2015_G2.laboratory_resultslaboratory_order_id
HSPI_MU2015_G9.care_plan_activitieslaboratory_order_id
HSPI_MU2015_G9.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_MU2015_G9.laboratory_order_specimens_maplaboratory_order_id
HSPI_MU2015_G9.laboratory_resultslaboratory_order_id
HSPI_Ness.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_Ness.laboratory_order_specimens_maplaboratory_order_id
HSPI_Ness.laboratory_resultslaboratory_order_id
HSPI_Sandbox.care_plan_activitieslaboratory_order_id
HSPI_Sandbox.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_Sandbox.laboratory_order_specimens_maplaboratory_order_id
HSPI_Sandbox.laboratory_resultslaboratory_order_id
HSPI_Summit_General.care_plan_activitieslaboratory_order_id
HSPI_Summit_General.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_Summit_General.laboratory_order_specimens_maplaboratory_order_id
HSPI_Summit_General.laboratory_resultslaboratory_order_id
HSPI_United_Physicians.care_plan_activitieslaboratory_order_id
HSPI_United_Physicians.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_United_Physicians.laboratory_order_specimens_maplaboratory_order_id
HSPI_United_Physicians.laboratory_resultslaboratory_order_id
MPI.care_plan_activitieslaboratory_order_id
MPI.laboratory_order_diagnoses_maplaboratory_order_id
MPI.laboratory_order_specimens_maplaboratory_order_id
MPI.laboratory_resultslaboratory_order_id
_1.hl7_ordersord_order_id
_1.labs_orderslo_order_id
_1188.hl7_ordersord_order_id
_1188.labs_orderslo_order_id
_1218.hl7_ordersord_order_id
_1218.labs_orderslo_order_id
_1548.hl7_ordersord_order_id
_1548.labs_orderslo_order_id
_435.hl7_ordersord_order_id
_435.labs_orderslo_order_id
_436.hl7_ordersord_order_id
_436.labs_orderslo_order_id
_436_archive_testing.hl7_ordersord_order_id
_436_archive_testing.labs_orderslo_order_id
_437.hl7_ordersord_order_id
_437.labs_orderslo_order_id
_8.hl7_ordersord_order_id
_8.labs_orderslo_order_id
_81.hl7_ordersord_order_id
_81.labs_orderslo_order_id
_999.hl7_ordersord_order_id
_999.labs_orderslo_order_id
fac_no
TableColumn
aurora_standard.chmpricaprev_fac_no
aurora_standard.chmpricacur_fac_no
aurora_standard.chpcashrcash_fac_no
aurora_standard.chpcobpdcash_fac_no
aurora_standard.chpcobpdbal_fac_no
aurora_standard.chscustddept_fac_no
aurora_standard.chshotlrdept_fac_no
aurora_standard.chtemplrdflt_fac_no
aurora_standard.curs_tempcash_fac_no
aurora_standard.curs_tempap_fac_no
aurora_standard.stgrowpdrod_beg_fac_no
aurora_standard.stgrowpdrod_end_fac_no
aurora_standard.stpcashddist_fac_no
aurora_standard.stpcashddisc_fac_no
aurora_standard.stpcashecash_fac_no
aurora_standard.stpcntrccash_fac_no
aurora_standard.stpcntrcdisc_fac_no
aurora_standard.stpinvcecash_fac_no
aurora_standard.stpopendap_fac_no
aurora_standard.stpopendcash_fac_no
aurora_standard.stucntrccash_fac_no
aurora_standard.stuinvcecash_fac_no
aurora_standard.stxfinsdfin_fac_no
aurora_standard.styaccrrliab_fac_no
aurora_standard.styaccrrexpense_fac_no
aurora_standard.styemplrcash_fac_no
aurora_standard.stypayfdcash_fac_no
aurora_standard.stypayodbal_fac_no
aurora_standard.stypayrecash_fac_no
aurora_standard.styrevsdcash_fac_no
aurora_standard.stytypercash_fac_no