aurora_standard.oeordtxtd

Field Type Null Default Key Extra Comment
chs_rowID int(11) NO PRI auto_increment
order_id int(11) YES
order_type char(1) YES
order_seq smallint(6) YES
order_txt varchar(255) YES

References

Local Column References
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
order_type
TableColumn
_1.physician_order_delegationsphyod_order_type
_1188.physician_order_delegationsphyod_order_type
_1218.physician_order_delegationsphyod_order_type
_1548.physician_order_delegationsphyod_order_type
_435.physician_order_delegationsphyod_order_type
_436.physician_order_delegationsphyod_order_type
_436_archive_testing.physician_order_delegationsphyod_order_type
_437.physician_order_delegationsphyod_order_type
_8.physician_order_delegationsphyod_order_type
_81.physician_order_delegationsphyod_order_type
_999.physician_order_delegationsphyod_order_type