aurora_standard.chmhcap2

Field Type Null Default Key Extra Comment
patno char(30) YES
visitrecno char(10) YES
facid char(10) YES
pattype char(1) YES
patdischgdt char(10) YES
patlname char(50) YES
patfname char(50) YES
pataddr1 char(50) YES
pataddr2 char(50) YES
patcity char(25) YES
patstate char(2) YES
patzip5 char(10) YES
patphone char(10) YES
patage char(3) YES
patgender char(1) YES
language char(1) YES
unit char(30) YES
subunit char(30) YES
admittingphyid char(50) YES
attendingphyid char(50) YES
surgeonid char(50) YES
finclass char(1) YES
edadmittime char(5) YES
customfld1 char(50) YES
customfld2 char(50) YES
customfld3 char(50) YES
patadmitdt char(10) YES
admitsource char(1) YES
dischgstatus char(2) YES
dischgdrg char(3) YES
serviceline char(1) YES
determinationserviceline char(2) YES
ineligiblecode char(3) YES
patemail char(50) YES

References

Local Column References
unit
TableColumn
HSPI_Bastrop.charge_master_codesndcQuantity_unit
HSPI_Bastrop.claim_itemsquantity_unit
HSPI_Bastrop.claim_supporting_infovalueQuantity_unit
HSPI_Bastrop.conditionsonsetAge_unit
HSPI_Bastrop.examplesexampleQuantity_unit
HSPI_Bastrop.immunizationsquantity_unit
HSPI_Bastrop.medication_requestsdosage_quantity_unit
HSPI_Bastrop.medication_requestsdispense_quantity_unit
HSPI_Bastrop.medication_requestsdispense_duration_unit
HSPI_Bastrop.medicationsquantity_unit
HSPI_Bastrop.observationsquantity_unit
HSPI_Bastrop.observationsrange_low_unit
HSPI_Bastrop.observationsrange_high_unit
HSPI_Bastrop.observations_componentsquantity_unit
HSPI_Bastrop.observations_componentsrange_low_unit
HSPI_Bastrop.observations_componentsrange_high_unit
HSPI_Bastrop.specimensquantity_unit
HSPI_CURES2015_B1.charge_master_codesndcQuantity_unit
HSPI_CURES2015_B1.claim_itemsquantity_unit
HSPI_CURES2015_B1.claim_supporting_infovalueQuantity_unit
HSPI_CURES2015_B1.conditionsonsetAge_unit
HSPI_CURES2015_B1.examplesexampleQuantity_unit
HSPI_CURES2015_B1.immunizationsquantity_unit
HSPI_CURES2015_B1.medication_requestsdosage_quantity_unit
HSPI_CURES2015_B1.medication_requestsdispense_quantity_unit
HSPI_CURES2015_B1.medication_requestsdispense_duration_unit
HSPI_CURES2015_B1.medicationsquantity_unit
HSPI_CURES2015_B1.observationsquantity_unit
HSPI_CURES2015_B1.observationsrange_low_unit
HSPI_CURES2015_B1.observationsrange_high_unit
HSPI_CURES2015_B1.observations_componentsquantity_unit
HSPI_CURES2015_B1.observations_componentsrange_low_unit
HSPI_CURES2015_B1.observations_componentsrange_high_unit
HSPI_CURES2015_B1.specimensquantity_unit
HSPI_Central_Hospital.charge_master_codesndcQuantity_unit
HSPI_Central_Hospital.claim_itemsquantity_unit
HSPI_Central_Hospital.claim_supporting_infovalueQuantity_unit
HSPI_Central_Hospital.conditionsonsetAge_unit
HSPI_Central_Hospital.examplesexampleQuantity_unit
HSPI_Central_Hospital.immunizationsquantity_unit
HSPI_Central_Hospital.medication_requestsdosage_quantity_unit
HSPI_Central_Hospital.medication_requestsdispense_quantity_unit
HSPI_Central_Hospital.medication_requestsdispense_duration_unit
HSPI_Central_Hospital.medicationsquantity_unit
HSPI_Central_Hospital.observationsquantity_unit
HSPI_Central_Hospital.observationsrange_low_unit
HSPI_Central_Hospital.observationsrange_high_unit
HSPI_Central_Hospital.observations_componentsquantity_unit
HSPI_Central_Hospital.observations_componentsrange_low_unit
HSPI_Central_Hospital.observations_componentsrange_high_unit
HSPI_Central_Hospital.specimensquantity_unit
HSPI_Dewitt.charge_master_codesndcQuantity_unit
HSPI_Dewitt.claim_itemsquantity_unit
HSPI_Dewitt.claim_supporting_infovalueQuantity_unit
HSPI_Dewitt.conditionsonsetAge_unit
HSPI_Dewitt.examplesexampleQuantity_unit
HSPI_Dewitt.immunizationsquantity_unit
HSPI_Dewitt.medication_requestsdosage_quantity_unit
HSPI_Dewitt.medication_requestsdispense_quantity_unit
HSPI_Dewitt.medication_requestsdispense_duration_unit
HSPI_Dewitt.medicationsquantity_unit
HSPI_Dewitt.observationsquantity_unit
HSPI_Dewitt.observationsrange_low_unit
HSPI_Dewitt.observationsrange_high_unit
HSPI_Dewitt.observations_componentsquantity_unit
HSPI_Dewitt.observations_componentsrange_low_unit
HSPI_Dewitt.observations_componentsrange_high_unit
HSPI_Dewitt.specimensquantity_unit
HSPI_Fulton.charge_master_codesndcQuantity_unit
HSPI_Fulton.claim_itemsquantity_unit
HSPI_Fulton.claim_supporting_infovalueQuantity_unit
HSPI_Fulton.conditionsonsetAge_unit
HSPI_Fulton.examplesexampleQuantity_unit
HSPI_Fulton.immunizationsquantity_unit
HSPI_Fulton.medication_requestsdosage_quantity_unit
HSPI_Fulton.medication_requestsdispense_quantity_unit
HSPI_Fulton.medication_requestsdispense_duration_unit
HSPI_Fulton.medicationsquantity_unit
HSPI_Fulton.observationsquantity_unit
HSPI_Fulton.observationsrange_low_unit
HSPI_Fulton.observationsrange_high_unit
HSPI_Fulton.observations_componentsquantity_unit
HSPI_Fulton.observations_componentsrange_low_unit
HSPI_Fulton.observations_componentsrange_high_unit
HSPI_Fulton.specimensquantity_unit
HSPI_Inferno.charge_master_codesndcQuantity_unit
HSPI_Inferno.claim_itemsquantity_unit
HSPI_Inferno.claim_supporting_infovalueQuantity_unit
HSPI_Inferno.conditionsonsetAge_unit
HSPI_Inferno.examplesexampleQuantity_unit
HSPI_Inferno.immunizationsquantity_unit
HSPI_Inferno.medication_requestsdosage_quantity_unit
HSPI_Inferno.medication_requestsdispense_quantity_unit
HSPI_Inferno.medication_requestsdispense_duration_unit
HSPI_Inferno.medicationsquantity_unit
HSPI_Inferno.observationsquantity_unit
HSPI_Inferno.observationsrange_low_unit
HSPI_Inferno.observationsrange_high_unit
HSPI_Inferno.observations_componentsquantity_unit
HSPI_Inferno.observations_componentsrange_low_unit
HSPI_Inferno.observations_componentsrange_high_unit
HSPI_Inferno.specimensquantity_unit
HSPI_MU2015_E1.charge_master_codesndcQuantity_unit
HSPI_MU2015_E1.claim_itemsquantity_unit
HSPI_MU2015_E1.claim_supporting_infovalueQuantity_unit
HSPI_MU2015_E1.conditionsonsetAge_unit
HSPI_MU2015_E1.examplesexampleQuantity_unit
HSPI_MU2015_E1.immunizationsquantity_unit
HSPI_MU2015_E1.medication_requestsdosage_quantity_unit
HSPI_MU2015_E1.medication_requestsdispense_quantity_unit
HSPI_MU2015_E1.medication_requestsdispense_duration_unit
HSPI_MU2015_E1.medicationsquantity_unit
HSPI_MU2015_E1.observationsquantity_unit
HSPI_MU2015_E1.observationsrange_low_unit
HSPI_MU2015_E1.observationsrange_high_unit
HSPI_MU2015_E1.observations_componentsquantity_unit
HSPI_MU2015_E1.observations_componentsrange_low_unit
HSPI_MU2015_E1.observations_componentsrange_high_unit
HSPI_MU2015_E1.specimensquantity_unit
HSPI_MU2015_G2.charge_master_codesndcQuantity_unit
HSPI_MU2015_G2.claim_itemsquantity_unit
HSPI_MU2015_G2.claim_supporting_infovalueQuantity_unit
HSPI_MU2015_G2.conditionsonsetAge_unit
HSPI_MU2015_G2.examplesexampleQuantity_unit
HSPI_MU2015_G2.immunizationsquantity_unit
HSPI_MU2015_G2.medication_requestsdosage_quantity_unit
HSPI_MU2015_G2.medication_requestsdispense_quantity_unit
HSPI_MU2015_G2.medication_requestsdispense_duration_unit
HSPI_MU2015_G2.medicationsquantity_unit
HSPI_MU2015_G2.observationsquantity_unit
HSPI_MU2015_G2.observationsrange_low_unit
HSPI_MU2015_G2.observationsrange_high_unit
HSPI_MU2015_G2.observations_componentsquantity_unit
HSPI_MU2015_G2.observations_componentsrange_low_unit
HSPI_MU2015_G2.observations_componentsrange_high_unit
HSPI_MU2015_G2.specimensquantity_unit
HSPI_MU2015_G9.charge_master_codesndcQuantity_unit
HSPI_MU2015_G9.claim_itemsquantity_unit
HSPI_MU2015_G9.claim_supporting_infovalueQuantity_unit
HSPI_MU2015_G9.conditionsonsetAge_unit
HSPI_MU2015_G9.examplesexampleQuantity_unit
HSPI_MU2015_G9.immunizationsquantity_unit
HSPI_MU2015_G9.medication_requestsdosage_quantity_unit
HSPI_MU2015_G9.medication_requestsdispense_quantity_unit
HSPI_MU2015_G9.medication_requestsdispense_duration_unit
HSPI_MU2015_G9.medicationsquantity_unit
HSPI_MU2015_G9.observationsquantity_unit
HSPI_MU2015_G9.observationsrange_low_unit
HSPI_MU2015_G9.observationsrange_high_unit
HSPI_MU2015_G9.observations_componentsquantity_unit
HSPI_MU2015_G9.observations_componentsrange_low_unit
HSPI_MU2015_G9.observations_componentsrange_high_unit
HSPI_MU2015_G9.specimensquantity_unit
HSPI_Ness.conditionsonsetAge_unit
HSPI_Ness.immunizationsquantity_unit
HSPI_Ness.medicationsquantity_unit
HSPI_Ness.observationsquantity_unit
HSPI_Ness.observationsrange_low_unit
HSPI_Ness.observationsrange_high_unit
HSPI_Ness.observations_componentsquantity_unit
HSPI_Ness.observations_componentsrange_low_unit
HSPI_Ness.observations_componentsrange_high_unit
HSPI_Ness.specimensquantity_unit
HSPI_Sandbox.charge_master_codesndcQuantity_unit
HSPI_Sandbox.claim_itemsquantity_unit
HSPI_Sandbox.claim_supporting_infovalueQuantity_unit
HSPI_Sandbox.conditionsonsetAge_unit
HSPI_Sandbox.examplesexampleQuantity_unit
HSPI_Sandbox.immunizationsquantity_unit
HSPI_Sandbox.medication_requestsdosage_quantity_unit
HSPI_Sandbox.medication_requestsdispense_quantity_unit
HSPI_Sandbox.medication_requestsdispense_duration_unit
HSPI_Sandbox.medicationsquantity_unit
HSPI_Sandbox.observationsquantity_unit
HSPI_Sandbox.observationsrange_low_unit
HSPI_Sandbox.observationsrange_high_unit
HSPI_Sandbox.observations_componentsquantity_unit
HSPI_Sandbox.observations_componentsrange_low_unit
HSPI_Sandbox.observations_componentsrange_high_unit
HSPI_Sandbox.specimensquantity_unit
HSPI_Summit_General.charge_master_codesndcQuantity_unit
HSPI_Summit_General.claim_itemsquantity_unit
HSPI_Summit_General.claim_supporting_infovalueQuantity_unit
HSPI_Summit_General.conditionsonsetAge_unit
HSPI_Summit_General.examplesexampleQuantity_unit
HSPI_Summit_General.immunizationsquantity_unit
HSPI_Summit_General.medication_requestsdosage_quantity_unit
HSPI_Summit_General.medication_requestsdispense_quantity_unit
HSPI_Summit_General.medication_requestsdispense_duration_unit
HSPI_Summit_General.medicationsquantity_unit
HSPI_Summit_General.observationsquantity_unit
HSPI_Summit_General.observationsrange_low_unit
HSPI_Summit_General.observationsrange_high_unit
HSPI_Summit_General.observations_componentsquantity_unit
HSPI_Summit_General.observations_componentsrange_low_unit
HSPI_Summit_General.observations_componentsrange_high_unit
HSPI_Summit_General.specimensquantity_unit
HSPI_United_Physicians.charge_master_codesndcQuantity_unit
HSPI_United_Physicians.claim_itemsquantity_unit
HSPI_United_Physicians.claim_supporting_infovalueQuantity_unit
HSPI_United_Physicians.conditionsonsetAge_unit
HSPI_United_Physicians.examplesexampleQuantity_unit
HSPI_United_Physicians.immunizationsquantity_unit
HSPI_United_Physicians.medication_requestsdosage_quantity_unit
HSPI_United_Physicians.medication_requestsdispense_quantity_unit
HSPI_United_Physicians.medication_requestsdispense_duration_unit
HSPI_United_Physicians.medicationsquantity_unit
HSPI_United_Physicians.observationsquantity_unit
HSPI_United_Physicians.observationsrange_low_unit
HSPI_United_Physicians.observationsrange_high_unit
HSPI_United_Physicians.observations_componentsquantity_unit
HSPI_United_Physicians.observations_componentsrange_low_unit
HSPI_United_Physicians.observations_componentsrange_high_unit
HSPI_United_Physicians.specimensquantity_unit
MPI.charge_master_codesndcQuantity_unit
MPI.claim_itemsquantity_unit
MPI.claim_supporting_infovalueQuantity_unit
MPI.conditionsonsetAge_unit
MPI.examplesexampleQuantity_unit
MPI.immunizationsquantity_unit
MPI.medication_requestsdosage_quantity_unit
MPI.medication_requestsdispense_quantity_unit
MPI.medication_requestsdispense_duration_unit
MPI.medicationsquantity_unit
MPI.observationsquantity_unit
MPI.observationsrange_low_unit
MPI.observationsrange_high_unit
MPI.observations_componentsquantity_unit
MPI.observations_componentsrange_low_unit
MPI.observations_componentsrange_high_unit
MPI.specimensquantity_unit
_1.charts_medicationscm_dose_unit
_1.clinical_interventionsci_pat_age_unit
_1.encounters_soap_labels_componentseslc_unit
_1.hl7_results_obx_mapobxm_unit
_1.patients_medicationspms_dose_unit
_1.patients_prescriptionsprx_dose_unit
_1.radiology_results_test_codes_resultsrrtcres_observ_unit
_1.systems_componentsscmp_default_unit
_1188.charts_medicationscm_dose_unit
_1188.clinical_interventionsci_pat_age_unit
_1188.encounters_soap_labels_componentseslc_unit
_1188.hl7_results_obx_mapobxm_unit
_1188.patients_medicationspms_dose_unit
_1188.patients_prescriptionsprx_dose_unit
_1188.radiology_results_test_codes_resultsrrtcres_observ_unit
_1188.systems_componentsscmp_default_unit
_1218.charts_medicationscm_dose_unit
_1218.clinical_interventionsci_pat_age_unit
_1218.encounters_soap_labels_componentseslc_unit
_1218.hl7_results_obx_mapobxm_unit
_1218.patients_medicationspms_dose_unit
_1218.patients_prescriptionsprx_dose_unit
_1218.radiology_results_test_codes_resultsrrtcres_observ_unit
_1218.systems_componentsscmp_default_unit
_1548.charts_medicationscm_dose_unit
_1548.clinical_interventionsci_pat_age_unit
_1548.encounters_soap_labels_componentseslc_unit
_1548.hl7_results_obx_mapobxm_unit
_1548.patients_medicationspms_dose_unit
_1548.patients_prescriptionsprx_dose_unit
_1548.radiology_results_test_codes_resultsrrtcres_observ_unit
_1548.systems_componentsscmp_default_unit
_435.charts_medicationscm_dose_unit
_435.clinical_interventionsci_pat_age_unit
_435.encounters_soap_labels_componentseslc_unit
_435.hl7_results_obx_mapobxm_unit
_435.patients_medicationspms_dose_unit
_435.patients_prescriptionsprx_dose_unit
_435.radiology_results_test_codes_resultsrrtcres_observ_unit
_435.systems_componentsscmp_default_unit
_436.charts_medicationscm_dose_unit
_436.clinical_interventionsci_pat_age_unit
_436.encounters_soap_labels_componentseslc_unit
_436.hl7_results_obx_mapobxm_unit
_436.patients_medicationspms_dose_unit
_436.patients_prescriptionsprx_dose_unit
_436.radiology_results_test_codes_resultsrrtcres_observ_unit
_436.systems_componentsscmp_default_unit
_436_archive_testing.charts_medicationscm_dose_unit
_436_archive_testing.clinical_interventionsci_pat_age_unit
_436_archive_testing.encounters_soap_labels_componentseslc_unit
_436_archive_testing.hl7_results_obx_mapobxm_unit
_436_archive_testing.patients_medicationspms_dose_unit
_436_archive_testing.patients_prescriptionsprx_dose_unit
_436_archive_testing.radiology_results_test_codes_resultsrrtcres_observ_unit
_436_archive_testing.systems_componentsscmp_default_unit
_437.charts_medicationscm_dose_unit
_437.clinical_interventionsci_pat_age_unit
_437.encounters_soap_labels_componentseslc_unit
_437.hl7_results_obx_mapobxm_unit
_437.patients_medicationspms_dose_unit
_437.patients_prescriptionsprx_dose_unit
_437.radiology_results_test_codes_resultsrrtcres_observ_unit
_437.systems_componentsscmp_default_unit
_8.charts_medicationscm_dose_unit
_8.clinical_interventionsci_pat_age_unit
_8.encounters_soap_labels_componentseslc_unit
_8.hl7_results_obx_mapobxm_unit
_8.patients_medicationspms_dose_unit
_8.patients_prescriptionsprx_dose_unit
_8.radiology_results_test_codes_resultsrrtcres_observ_unit
_8.systems_componentsscmp_default_unit
_81.charts_medicationscm_dose_unit
_81.clinical_interventionsci_pat_age_unit
_81.encounters_soap_labels_componentseslc_unit
_81.hl7_results_obx_mapobxm_unit
_81.patients_medicationspms_dose_unit
_81.patients_prescriptionsprx_dose_unit
_81.radiology_results_test_codes_resultsrrtcres_observ_unit
_81.systems_componentsscmp_default_unit
_999.charts_medicationscm_dose_unit
_999.clinical_interventionsci_pat_age_unit
_999.encounters_soap_labels_componentseslc_unit
_999.hl7_results_obx_mapobxm_unit
_999.patients_medicationspms_dose_unit
_999.patients_prescriptionsprx_dose_unit
_999.radiology_results_test_codes_resultsrrtcres_observ_unit
_999.systems_componentsscmp_default_unit
aurora_standard.bdcdmissue_unit
aurora_standard.c7cdmissue_unit
aurora_standard.c8cdmissue_unit
aurora_standard.chmhcahpdis_unit
aurora_standard.chmhstmrsub_unit
aurora_standard.chmhstrmsub_unit
aurora_standard.chmpriccissue_unit
aurora_standard.glspriceissue_unit
aurora_standard.hl7ft1trans_amt_unit
aurora_standard.oeitmcatcitm_unit
aurora_standard.ohorxsale_unit
aurora_standard.pharm1per_unit
aurora_standard.stiinvtrweight_unit
aurora_standard.stiinvtrsell_unit
aurora_standard.stiinvtrbill_unit
aurora_standard.stiinvtrstock_unit
aurora_standard.stiinvtrpurch_unit
aurora_standard.stoordrdsell_unit
aurora_standard.stoordrerecur_unit
aurora_standard.stoshipdsell_unit
aurora_standard.stuabcdissue_unit
aurora_standard.stuctlgdpurch_unit
aurora_standard.stuordrdsell_unit
aurora_standard.stuordrdpurch_unit
aurora_standard.stuordrdstock_unit
aurora_standard.stupricepurch_unit
aurora_standard.tmpctlgdpurch_unit
aurora_standard.ttiinvtrweight_unit
aurora_standard.ttiinvtrsell_unit
aurora_standard.ttiinvtrbill_unit
aurora_standard.ttiinvtrstock_unit
aurora_standard.ttiinvtrpurch_unit
common.cqm_conditionscqc_duration_unit
common.cqm_conditionscqc_target_att_modifier_unit
common.cqm_conditionscqc_target2_att_modifier_unit
language
TableColumn
_1.clinical_interventionsci_language
_1188.clinical_interventionsci_language
_1218.clinical_interventionsci_language
_1548.clinical_interventionsci_language
_435.clinical_interventionsci_language
_436.clinical_interventionsci_language
_436_archive_testing.clinical_interventionsci_language
_437.clinical_interventionsci_language
_8.clinical_interventionsci_language
_81.clinical_interventionsci_language
_999.clinical_interventionsci_language
ahiWiki.sitessite_language
aurora_standard.bdmpiprim_language
aurora_standard.bsinsurprim_language
aurora_standard.campiprim_language
aurora_standard.chmpatmrprim_language
aurora_standard.hl7pidprim_language
aurora_standard.hl7pidadprim_language