aurora_standard.stock

Field	Type	Null	Key	Extra
stock_num	smallint(6)	YES
manu_code	varchar(3)	YES
description	varchar(15)	YES
unit_price	decimal(16,2)	YES
unit	varchar(4)	YES
unit_descr	varchar(15)	YES
chs_rowID	bigint(20) unsigned	NO	PRI	auto_increment

References

Local Column

References

unit

Table	Column
HSPI_Bastrop.charge_master_codes	ndcQuantity_unit
HSPI_Bastrop.claim_items	quantity_unit
HSPI_Bastrop.claim_supporting_info	valueQuantity_unit
HSPI_Bastrop.conditions	onsetAge_unit
HSPI_Bastrop.examples	exampleQuantity_unit
HSPI_Bastrop.immunizations	quantity_unit
HSPI_Bastrop.medication_requests	dosage_quantity_unit
HSPI_Bastrop.medication_requests	dispense_quantity_unit
HSPI_Bastrop.medication_requests	dispense_duration_unit
HSPI_Bastrop.medications	quantity_unit
HSPI_Bastrop.observations	quantity_unit
HSPI_Bastrop.observations	range_low_unit
HSPI_Bastrop.observations	range_high_unit
HSPI_Bastrop.observations_components	quantity_unit
HSPI_Bastrop.observations_components	range_low_unit
HSPI_Bastrop.observations_components	range_high_unit
HSPI_Bastrop.specimens	quantity_unit
HSPI_CURES2015_B1.charge_master_codes	ndcQuantity_unit
HSPI_CURES2015_B1.claim_items	quantity_unit
HSPI_CURES2015_B1.claim_supporting_info	valueQuantity_unit
HSPI_CURES2015_B1.conditions	onsetAge_unit
HSPI_CURES2015_B1.examples	exampleQuantity_unit
HSPI_CURES2015_B1.immunizations	quantity_unit
HSPI_CURES2015_B1.medication_requests	dosage_quantity_unit
HSPI_CURES2015_B1.medication_requests	dispense_quantity_unit
HSPI_CURES2015_B1.medication_requests	dispense_duration_unit
HSPI_CURES2015_B1.medications	quantity_unit
HSPI_CURES2015_B1.observations	quantity_unit
HSPI_CURES2015_B1.observations	range_low_unit
HSPI_CURES2015_B1.observations	range_high_unit
HSPI_CURES2015_B1.observations_components	quantity_unit
HSPI_CURES2015_B1.observations_components	range_low_unit
HSPI_CURES2015_B1.observations_components	range_high_unit
HSPI_CURES2015_B1.specimens	quantity_unit
HSPI_Central_Hospital.charge_master_codes	ndcQuantity_unit
HSPI_Central_Hospital.claim_items	quantity_unit
HSPI_Central_Hospital.claim_supporting_info	valueQuantity_unit
HSPI_Central_Hospital.conditions	onsetAge_unit
HSPI_Central_Hospital.examples	exampleQuantity_unit
HSPI_Central_Hospital.immunizations	quantity_unit
HSPI_Central_Hospital.medication_requests	dosage_quantity_unit
HSPI_Central_Hospital.medication_requests	dispense_quantity_unit
HSPI_Central_Hospital.medication_requests	dispense_duration_unit
HSPI_Central_Hospital.medications	quantity_unit
HSPI_Central_Hospital.observations	quantity_unit
HSPI_Central_Hospital.observations	range_low_unit
HSPI_Central_Hospital.observations	range_high_unit
HSPI_Central_Hospital.observations_components	quantity_unit
HSPI_Central_Hospital.observations_components	range_low_unit
HSPI_Central_Hospital.observations_components	range_high_unit
HSPI_Central_Hospital.specimens	quantity_unit
HSPI_Dewitt.charge_master_codes	ndcQuantity_unit
HSPI_Dewitt.claim_items	quantity_unit
HSPI_Dewitt.claim_supporting_info	valueQuantity_unit
HSPI_Dewitt.conditions	onsetAge_unit
HSPI_Dewitt.examples	exampleQuantity_unit
HSPI_Dewitt.immunizations	quantity_unit
HSPI_Dewitt.medication_requests	dosage_quantity_unit
HSPI_Dewitt.medication_requests	dispense_quantity_unit
HSPI_Dewitt.medication_requests	dispense_duration_unit
HSPI_Dewitt.medications	quantity_unit
HSPI_Dewitt.observations	quantity_unit
HSPI_Dewitt.observations	range_low_unit
HSPI_Dewitt.observations	range_high_unit
HSPI_Dewitt.observations_components	quantity_unit
HSPI_Dewitt.observations_components	range_low_unit
HSPI_Dewitt.observations_components	range_high_unit
HSPI_Dewitt.specimens	quantity_unit
HSPI_Fulton.charge_master_codes	ndcQuantity_unit
HSPI_Fulton.claim_items	quantity_unit
HSPI_Fulton.claim_supporting_info	valueQuantity_unit
HSPI_Fulton.conditions	onsetAge_unit
HSPI_Fulton.examples	exampleQuantity_unit
HSPI_Fulton.immunizations	quantity_unit
HSPI_Fulton.medication_requests	dosage_quantity_unit
HSPI_Fulton.medication_requests	dispense_quantity_unit
HSPI_Fulton.medication_requests	dispense_duration_unit
HSPI_Fulton.medications	quantity_unit
HSPI_Fulton.observations	quantity_unit
HSPI_Fulton.observations	range_low_unit
HSPI_Fulton.observations	range_high_unit
HSPI_Fulton.observations_components	quantity_unit
HSPI_Fulton.observations_components	range_low_unit
HSPI_Fulton.observations_components	range_high_unit
HSPI_Fulton.specimens	quantity_unit
HSPI_Inferno.charge_master_codes	ndcQuantity_unit
HSPI_Inferno.claim_items	quantity_unit
HSPI_Inferno.claim_supporting_info	valueQuantity_unit
HSPI_Inferno.conditions	onsetAge_unit
HSPI_Inferno.examples	exampleQuantity_unit
HSPI_Inferno.immunizations	quantity_unit
HSPI_Inferno.medication_requests	dosage_quantity_unit
HSPI_Inferno.medication_requests	dispense_quantity_unit
HSPI_Inferno.medication_requests	dispense_duration_unit
HSPI_Inferno.medications	quantity_unit
HSPI_Inferno.observations	quantity_unit
HSPI_Inferno.observations	range_low_unit
HSPI_Inferno.observations	range_high_unit
HSPI_Inferno.observations_components	quantity_unit
HSPI_Inferno.observations_components	range_low_unit
HSPI_Inferno.observations_components	range_high_unit
HSPI_Inferno.specimens	quantity_unit
HSPI_MU2015_E1.charge_master_codes	ndcQuantity_unit
HSPI_MU2015_E1.claim_items	quantity_unit
HSPI_MU2015_E1.claim_supporting_info	valueQuantity_unit
HSPI_MU2015_E1.conditions	onsetAge_unit
HSPI_MU2015_E1.examples	exampleQuantity_unit
HSPI_MU2015_E1.immunizations	quantity_unit
HSPI_MU2015_E1.medication_requests	dosage_quantity_unit
HSPI_MU2015_E1.medication_requests	dispense_quantity_unit
HSPI_MU2015_E1.medication_requests	dispense_duration_unit
HSPI_MU2015_E1.medications	quantity_unit
HSPI_MU2015_E1.observations	quantity_unit
HSPI_MU2015_E1.observations	range_low_unit
HSPI_MU2015_E1.observations	range_high_unit
HSPI_MU2015_E1.observations_components	quantity_unit
HSPI_MU2015_E1.observations_components	range_low_unit
HSPI_MU2015_E1.observations_components	range_high_unit
HSPI_MU2015_E1.specimens	quantity_unit
HSPI_MU2015_G2.charge_master_codes	ndcQuantity_unit
HSPI_MU2015_G2.claim_items	quantity_unit
HSPI_MU2015_G2.claim_supporting_info	valueQuantity_unit
HSPI_MU2015_G2.conditions	onsetAge_unit
HSPI_MU2015_G2.examples	exampleQuantity_unit
HSPI_MU2015_G2.immunizations	quantity_unit
HSPI_MU2015_G2.medication_requests	dosage_quantity_unit
HSPI_MU2015_G2.medication_requests	dispense_quantity_unit
HSPI_MU2015_G2.medication_requests	dispense_duration_unit
HSPI_MU2015_G2.medications	quantity_unit
HSPI_MU2015_G2.observations	quantity_unit
HSPI_MU2015_G2.observations	range_low_unit
HSPI_MU2015_G2.observations	range_high_unit
HSPI_MU2015_G2.observations_components	quantity_unit
HSPI_MU2015_G2.observations_components	range_low_unit
HSPI_MU2015_G2.observations_components	range_high_unit
HSPI_MU2015_G2.specimens	quantity_unit
HSPI_MU2015_G9.charge_master_codes	ndcQuantity_unit
HSPI_MU2015_G9.claim_items	quantity_unit
HSPI_MU2015_G9.claim_supporting_info	valueQuantity_unit
HSPI_MU2015_G9.conditions	onsetAge_unit
HSPI_MU2015_G9.examples	exampleQuantity_unit
HSPI_MU2015_G9.immunizations	quantity_unit
HSPI_MU2015_G9.medication_requests	dosage_quantity_unit
HSPI_MU2015_G9.medication_requests	dispense_quantity_unit
HSPI_MU2015_G9.medication_requests	dispense_duration_unit
HSPI_MU2015_G9.medications	quantity_unit
HSPI_MU2015_G9.observations	quantity_unit
HSPI_MU2015_G9.observations	range_low_unit
HSPI_MU2015_G9.observations	range_high_unit
HSPI_MU2015_G9.observations_components	quantity_unit
HSPI_MU2015_G9.observations_components	range_low_unit
HSPI_MU2015_G9.observations_components	range_high_unit
HSPI_MU2015_G9.specimens	quantity_unit
HSPI_Ness.conditions	onsetAge_unit
HSPI_Ness.immunizations	quantity_unit
HSPI_Ness.medications	quantity_unit
HSPI_Ness.observations	quantity_unit
HSPI_Ness.observations	range_low_unit
HSPI_Ness.observations	range_high_unit
HSPI_Ness.observations_components	quantity_unit
HSPI_Ness.observations_components	range_low_unit
HSPI_Ness.observations_components	range_high_unit
HSPI_Ness.specimens	quantity_unit
HSPI_Sandbox.charge_master_codes	ndcQuantity_unit
HSPI_Sandbox.claim_items	quantity_unit
HSPI_Sandbox.claim_supporting_info	valueQuantity_unit
HSPI_Sandbox.conditions	onsetAge_unit
HSPI_Sandbox.examples	exampleQuantity_unit
HSPI_Sandbox.immunizations	quantity_unit
HSPI_Sandbox.medication_requests	dosage_quantity_unit
HSPI_Sandbox.medication_requests	dispense_quantity_unit
HSPI_Sandbox.medication_requests	dispense_duration_unit
HSPI_Sandbox.medications	quantity_unit
HSPI_Sandbox.observations	quantity_unit
HSPI_Sandbox.observations	range_low_unit
HSPI_Sandbox.observations	range_high_unit
HSPI_Sandbox.observations_components	quantity_unit
HSPI_Sandbox.observations_components	range_low_unit
HSPI_Sandbox.observations_components	range_high_unit
HSPI_Sandbox.specimens	quantity_unit
HSPI_Summit_General.charge_master_codes	ndcQuantity_unit
HSPI_Summit_General.claim_items	quantity_unit
HSPI_Summit_General.claim_supporting_info	valueQuantity_unit
HSPI_Summit_General.conditions	onsetAge_unit
HSPI_Summit_General.examples	exampleQuantity_unit
HSPI_Summit_General.immunizations	quantity_unit
HSPI_Summit_General.medication_requests	dosage_quantity_unit
HSPI_Summit_General.medication_requests	dispense_quantity_unit
HSPI_Summit_General.medication_requests	dispense_duration_unit
HSPI_Summit_General.medications	quantity_unit
HSPI_Summit_General.observations	quantity_unit
HSPI_Summit_General.observations	range_low_unit
HSPI_Summit_General.observations	range_high_unit
HSPI_Summit_General.observations_components	quantity_unit
HSPI_Summit_General.observations_components	range_low_unit
HSPI_Summit_General.observations_components	range_high_unit
HSPI_Summit_General.specimens	quantity_unit
HSPI_United_Physicians.charge_master_codes	ndcQuantity_unit
HSPI_United_Physicians.claim_items	quantity_unit
HSPI_United_Physicians.claim_supporting_info	valueQuantity_unit
HSPI_United_Physicians.conditions	onsetAge_unit
HSPI_United_Physicians.examples	exampleQuantity_unit
HSPI_United_Physicians.immunizations	quantity_unit
HSPI_United_Physicians.medication_requests	dosage_quantity_unit
HSPI_United_Physicians.medication_requests	dispense_quantity_unit
HSPI_United_Physicians.medication_requests	dispense_duration_unit
HSPI_United_Physicians.medications	quantity_unit
HSPI_United_Physicians.observations	quantity_unit
HSPI_United_Physicians.observations	range_low_unit
HSPI_United_Physicians.observations	range_high_unit
HSPI_United_Physicians.observations_components	quantity_unit
HSPI_United_Physicians.observations_components	range_low_unit
HSPI_United_Physicians.observations_components	range_high_unit
HSPI_United_Physicians.specimens	quantity_unit
MPI.charge_master_codes	ndcQuantity_unit
MPI.claim_items	quantity_unit
MPI.claim_supporting_info	valueQuantity_unit
MPI.conditions	onsetAge_unit
MPI.examples	exampleQuantity_unit
MPI.immunizations	quantity_unit
MPI.medication_requests	dosage_quantity_unit
MPI.medication_requests	dispense_quantity_unit
MPI.medication_requests	dispense_duration_unit
MPI.medications	quantity_unit
MPI.observations	quantity_unit
MPI.observations	range_low_unit
MPI.observations	range_high_unit
MPI.observations_components	quantity_unit
MPI.observations_components	range_low_unit
MPI.observations_components	range_high_unit
MPI.specimens	quantity_unit
_1.charts_medications	cm_dose_unit
_1.clinical_interventions	ci_pat_age_unit
_1.encounters_soap_labels_components	eslc_unit
_1.hl7_results_obx_map	obxm_unit
_1.patients_medications	pms_dose_unit
_1.patients_prescriptions	prx_dose_unit
_1.radiology_results_test_codes_results	rrtcres_observ_unit
_1.systems_components	scmp_default_unit
_1188.charts_medications	cm_dose_unit
_1188.clinical_interventions	ci_pat_age_unit
_1188.encounters_soap_labels_components	eslc_unit
_1188.hl7_results_obx_map	obxm_unit
_1188.patients_medications	pms_dose_unit
_1188.patients_prescriptions	prx_dose_unit
_1188.radiology_results_test_codes_results	rrtcres_observ_unit
_1188.systems_components	scmp_default_unit
_1218.charts_medications	cm_dose_unit
_1218.clinical_interventions	ci_pat_age_unit
_1218.encounters_soap_labels_components	eslc_unit
_1218.hl7_results_obx_map	obxm_unit
_1218.patients_medications	pms_dose_unit
_1218.patients_prescriptions	prx_dose_unit
_1218.radiology_results_test_codes_results	rrtcres_observ_unit
_1218.systems_components	scmp_default_unit
_1548.charts_medications	cm_dose_unit
_1548.clinical_interventions	ci_pat_age_unit
_1548.encounters_soap_labels_components	eslc_unit
_1548.hl7_results_obx_map	obxm_unit
_1548.patients_medications	pms_dose_unit
_1548.patients_prescriptions	prx_dose_unit
_1548.radiology_results_test_codes_results	rrtcres_observ_unit
_1548.systems_components	scmp_default_unit
_435.charts_medications	cm_dose_unit
_435.clinical_interventions	ci_pat_age_unit
_435.encounters_soap_labels_components	eslc_unit
_435.hl7_results_obx_map	obxm_unit
_435.patients_medications	pms_dose_unit
_435.patients_prescriptions	prx_dose_unit
_435.radiology_results_test_codes_results	rrtcres_observ_unit
_435.systems_components	scmp_default_unit
_436.charts_medications	cm_dose_unit
_436.clinical_interventions	ci_pat_age_unit
_436.encounters_soap_labels_components	eslc_unit
_436.hl7_results_obx_map	obxm_unit
_436.patients_medications	pms_dose_unit
_436.patients_prescriptions	prx_dose_unit
_436.radiology_results_test_codes_results	rrtcres_observ_unit
_436.systems_components	scmp_default_unit
_436_archive_testing.charts_medications	cm_dose_unit
_436_archive_testing.clinical_interventions	ci_pat_age_unit
_436_archive_testing.encounters_soap_labels_components	eslc_unit
_436_archive_testing.hl7_results_obx_map	obxm_unit
_436_archive_testing.patients_medications	pms_dose_unit
_436_archive_testing.patients_prescriptions	prx_dose_unit
_436_archive_testing.radiology_results_test_codes_results	rrtcres_observ_unit
_436_archive_testing.systems_components	scmp_default_unit
_437.charts_medications	cm_dose_unit
_437.clinical_interventions	ci_pat_age_unit
_437.encounters_soap_labels_components	eslc_unit
_437.hl7_results_obx_map	obxm_unit
_437.patients_medications	pms_dose_unit
_437.patients_prescriptions	prx_dose_unit
_437.radiology_results_test_codes_results	rrtcres_observ_unit
_437.systems_components	scmp_default_unit
_8.charts_medications	cm_dose_unit
_8.clinical_interventions	ci_pat_age_unit
_8.encounters_soap_labels_components	eslc_unit
_8.hl7_results_obx_map	obxm_unit
_8.patients_medications	pms_dose_unit
_8.patients_prescriptions	prx_dose_unit
_8.radiology_results_test_codes_results	rrtcres_observ_unit
_8.systems_components	scmp_default_unit
_81.charts_medications	cm_dose_unit
_81.clinical_interventions	ci_pat_age_unit
_81.encounters_soap_labels_components	eslc_unit
_81.hl7_results_obx_map	obxm_unit
_81.patients_medications	pms_dose_unit
_81.patients_prescriptions	prx_dose_unit
_81.radiology_results_test_codes_results	rrtcres_observ_unit
_81.systems_components	scmp_default_unit
_999.charts_medications	cm_dose_unit
_999.clinical_interventions	ci_pat_age_unit
_999.encounters_soap_labels_components	eslc_unit
_999.hl7_results_obx_map	obxm_unit
_999.patients_medications	pms_dose_unit
_999.patients_prescriptions	prx_dose_unit
_999.radiology_results_test_codes_results	rrtcres_observ_unit
_999.systems_components	scmp_default_unit
aurora_standard.bdcdm	issue_unit
aurora_standard.c7cdm	issue_unit
aurora_standard.c8cdm	issue_unit
aurora_standard.chmhcahp	dis_unit
aurora_standard.chmhstmr	sub_unit
aurora_standard.chmhstrm	sub_unit
aurora_standard.chmpricc	issue_unit
aurora_standard.glsprice	issue_unit
aurora_standard.hl7ft1	trans_amt_unit
aurora_standard.oeitmcatc	itm_unit
aurora_standard.ohorx	sale_unit
aurora_standard.pharm1	per_unit
aurora_standard.stiinvtr	weight_unit
aurora_standard.stiinvtr	sell_unit
aurora_standard.stiinvtr	bill_unit
aurora_standard.stiinvtr	stock_unit
aurora_standard.stiinvtr	purch_unit
aurora_standard.stoordrd	sell_unit
aurora_standard.stoordre	recur_unit
aurora_standard.stoshipd	sell_unit
aurora_standard.stuabcd	issue_unit
aurora_standard.stuctlgd	purch_unit
aurora_standard.stuordrd	sell_unit
aurora_standard.stuordrd	purch_unit
aurora_standard.stuordrd	stock_unit
aurora_standard.stuprice	purch_unit
aurora_standard.tmpctlgd	purch_unit
aurora_standard.ttiinvtr	weight_unit
aurora_standard.ttiinvtr	sell_unit
aurora_standard.ttiinvtr	bill_unit
aurora_standard.ttiinvtr	stock_unit
aurora_standard.ttiinvtr	purch_unit
common.cqm_conditions	cqc_duration_unit
common.cqm_conditions	cqc_target_att_modifier_unit
common.cqm_conditions	cqc_target2_att_modifier_unit

description

Table	Column
HSPI_Bastrop.devices	device_description
HSPI_CURES2015_B1.devices	device_description
HSPI_Central_Hospital.devices	device_description
HSPI_Dewitt.devices	device_description
HSPI_Fulton.devices	device_description
HSPI_Inferno.devices	device_description
HSPI_MU2015_E1.devices	device_description
HSPI_MU2015_G2.devices	device_description
HSPI_MU2015_G9.devices	device_description
HSPI_Sandbox.devices	device_description
HSPI_Summit_General.devices	device_description
HSPI_United_Physicians.devices	device_description
MPI.devices	device_description
_1.adjustment_rules	ar_description
_1.cqm_errors	cqmer_description
_1.encounters_alert_rules	ear_description
_1.patients_implantable_devices	pid_device_description
_1188.cqm_errors	cqmer_description
_1188.encounters_alert_rules	ear_description
_1188.patients_implantable_devices	pid_device_description
_1218.adjustment_rules	ar_description
_1218.cqm_errors	cqmer_description
_1218.encounters_alert_rules	ear_description
_1218.patients_implantable_devices	pid_device_description
_1548.adjustment_rules	ar_description
_1548.cqm_errors	cqmer_description
_1548.encounters_alert_rules	ear_description
_1548.patients_implantable_devices	pid_device_description
_435.adjustment_rules	ar_description
_435.cqm_errors	cqmer_description
_435.encounters_alert_rules	ear_description
_435.patients_implantable_devices	pid_device_description
_436.adjustment_rules	ar_description
_436.cqm_errors	cqmer_description
_436.encounters_alert_rules	ear_description
_436.patients_implantable_devices	pid_device_description
_436_archive_testing.adjustment_rules	ar_description
_436_archive_testing.cqm_errors	cqmer_description
_436_archive_testing.encounters_alert_rules	ear_description
_436_archive_testing.patients_implantable_devices	pid_device_description
_437.adjustment_rules	ar_description
_437.cqm_errors	cqmer_description
_437.encounters_alert_rules	ear_description
_437.patients_implantable_devices	pid_device_description
_8.adjustment_rules	ar_description
_8.cqm_errors	cqmer_description
_8.encounters_alert_rules	ear_description
_8.patients_implantable_devices	pid_device_description
_81.cqm_errors	cqmer_description
_81.encounters_alert_rules	ear_description
_81.patients_implantable_devices	pid_device_description
_999.adjustment_rules	ar_description
_999.cqm_errors	cqmer_description
_999.encounters_alert_rules	ear_description
_999.patients_implantable_devices	pid_device_description
ahiWiki.filearchive	fa_description
ahiWiki.image	img_description
ahiWiki.oldimage	oi_description
aurora_standard.medgenix_modules	module_description
aurora_standard.stfclond	asst_description
aurora_standard.stpapckv	acct_description
aurora_standard.stultypr	update_description
aurora_standard.stxparmd	val_description
aurora_standard.stydeddv	home_description
aurora_standard.styincdv	home_description
aurora_standard.styintfc	source_description
aurora_standard.styjobtc	job_description
aurora_standard.styobldv	home_description
aurora_standard.styptodv	home_description
common.data_import_options	dio_description
common.data_import_value_types	divt_description
common.dev_requests	dev_description
common.dev_requests_screencasts	drs_description
common.insurances_claim_indicators	insci_description
common.smoking_statuses	ss_description
common.test_codes	tco_x_specimen_description
common.test_codes_profiles	tcp_description

unit_price

Table	Column
aurora_standard.chrdrugc	awp_unit_price
aurora_standard.chrdrugc	dp_unit_price
aurora_standard.lngdrg	wac_cur_unit_price
aurora_standard.lngdrg	awp_cur_unit_price
aurora_standard.lngdrg	dp_cur_unit_price
aurora_standard.lngdrg	ful_cur_unit_price
aurora_standard.lngdrg	srp_cur_unit_price