aurora_standard.hl7orc

Field Type Null Default Key Extra Comment
hl7joinno smallint(6) YES
seg_orc varchar(3) YES
order_cntrl varchar(2) YES
placer_ord_num varchar(22) YES
filler_ord_num varchar(22) YES
placer_grp_num varchar(22) YES
order_status varchar(2) YES
response_flag varchar(1) YES
quantity_timing varchar(200) YES
parent varchar(200) YES
date_time_of_trans varchar(26) YES
entered_by varchar(120) YES
verified_by varchar(120) YES
ordering_prov varchar(120) YES
enterer_loc varchar(80) YES
call_bck_ph_num varchar(40) YES
ord_effect_d_t varchar(26) YES
ord_cntrl_cd_reas varchar(200) YES
entering_org varchar(60) YES
entering_dev varchar(60) YES
action_by varchar(120) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
order_status
TableColumn
HSPI_Bastrop.laboratory_orderslaboratory_order_status
HSPI_CURES2015_B1.laboratory_orderslaboratory_order_status
HSPI_Central_Hospital.laboratory_orderslaboratory_order_status
HSPI_Dewitt.laboratory_orderslaboratory_order_status
HSPI_Fulton.laboratory_orderslaboratory_order_status
HSPI_Inferno.laboratory_orderslaboratory_order_status
HSPI_MU2015_E1.laboratory_orderslaboratory_order_status
HSPI_MU2015_G2.laboratory_orderslaboratory_order_status
HSPI_MU2015_G9.laboratory_orderslaboratory_order_status
HSPI_Ness.laboratory_orderslaboratory_order_status
HSPI_Sandbox.laboratory_orderslaboratory_order_status
HSPI_Summit_General.laboratory_orderslaboratory_order_status
HSPI_United_Physicians.laboratory_orderslaboratory_order_status
MPI.laboratory_orderslaboratory_order_status
parent
TableColumn
aurora_standard.cgxrelattab_parent
aurora_standard.cgxrelatnod_parent