aurora_standard.listings

Field Type Null Default Key Extra Comment
listing_seq_no int(11) YES UNI
lblcode varchar(6) YES
prodcode varchar(4) YES
strength varchar(10) YES
unit varchar(10) YES
rx_otc varchar(1) YES
dosage_form varchar(25) YES
firm_seq_no int(11) YES
tradename varchar(100) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

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
strength
TableColumn
aurora_standard.chmemrxddrug_strength
aurora_standard.chrdrugcprod_strength
common.drugsdrg_strength