aurora_standard.chmoperc

Field Type Null Default Key Extra Comment
input_by bigint(20) unsigned NO PRI auto_increment
full_name varchar(20) YES
initials varchar(3) YES
log_in varchar(20) YES UNI
order_id varchar(20) YES
location varchar(20) YES
fac_group varchar(10) YES
rx_verify varchar(1) YES
oe_verify varchar(1) YES
menu_name varchar(255) YES
usr_onln_pw varchar(255) YES
usr_access_grp varchar(5) YES
usr_email_add varchar(50) YES
usr_active varchar(1) YES
usr_su varchar(1) YES
maint_insrc varchar(1) YES
maint_phync varchar(1) YES
hand_at_adm varchar(2) YES
passwd_chngd date YES
default_printer varchar(15) YES
coll_agency varchar(10) YES
maint_guar varchar(1) YES
exec_access varchar(1) YES
auto_ssn int(11) NO
allow_archive varchar(1) YES
allow_vis_del varchar(1) YES
allow_ar_inq varchar(1) YES
brand_new_user varchar(255) YES
brand_new_pass 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
location
TableColumn
_1.cpoe_responsescpoe_res_location
_1.encounters_soap_vitalsespv_location
_1.hl7_accessionsacc_location
_1.patients_immunizationspim_location
_1.precertspre_scheduled_location
_1.precerts_mapprem_location
_1.radiology_resultsrad_res_location
_1188.cpoe_responsescpoe_res_location
_1188.encounters_soap_vitalsespv_location
_1188.hl7_accessionsacc_location
_1188.patients_immunizationspim_location
_1188.precertspre_scheduled_location
_1188.precerts_mapprem_location
_1188.radiology_resultsrad_res_location
_1218.cpoe_responsescpoe_res_location
_1218.encounters_soap_vitalsespv_location
_1218.hl7_accessionsacc_location
_1218.patients_immunizationspim_location
_1218.precertspre_scheduled_location
_1218.precerts_mapprem_location
_1218.radiology_resultsrad_res_location
_1548.cpoe_responsescpoe_res_location
_1548.encounters_soap_vitalsespv_location
_1548.hl7_accessionsacc_location
_1548.patients_immunizationspim_location
_1548.precertspre_scheduled_location
_1548.precerts_mapprem_location
_1548.radiology_resultsrad_res_location
_435.cpoe_responsescpoe_res_location
_435.encounters_soap_vitalsespv_location
_435.hl7_accessionsacc_location
_435.patients_immunizationspim_location
_435.precertspre_scheduled_location
_435.precerts_mapprem_location
_435.radiology_resultsrad_res_location
_436.cpoe_responsescpoe_res_location
_436.encounters_soap_vitalsespv_location
_436.hl7_accessionsacc_location
_436.patients_immunizationspim_location
_436.precertspre_scheduled_location
_436.precerts_mapprem_location
_436.radiology_resultsrad_res_location
_436_archive_testing.cpoe_responsescpoe_res_location
_436_archive_testing.encounters_soap_vitalsespv_location
_436_archive_testing.hl7_accessionsacc_location
_436_archive_testing.patients_immunizationspim_location
_436_archive_testing.precertspre_scheduled_location
_436_archive_testing.precerts_mapprem_location
_436_archive_testing.radiology_resultsrad_res_location
_437.cpoe_responsescpoe_res_location
_437.encounters_soap_vitalsespv_location
_437.hl7_accessionsacc_location
_437.patients_immunizationspim_location
_437.precertspre_scheduled_location
_437.precerts_mapprem_location
_437.radiology_resultsrad_res_location
_8.cpoe_responsescpoe_res_location
_8.encounters_soap_vitalsespv_location
_8.hl7_accessionsacc_location
_8.patients_immunizationspim_location
_8.precertspre_scheduled_location
_8.precerts_mapprem_location
_8.radiology_resultsrad_res_location
_81.cpoe_responsescpoe_res_location
_81.encounters_soap_vitalsespv_location
_81.hl7_accessionsacc_location
_81.patients_immunizationspim_location
_81.precertspre_scheduled_location
_81.precerts_mapprem_location
_81.radiology_resultsrad_res_location
_999.cpoe_responsescpoe_res_location
_999.encounters_soap_vitalsespv_location
_999.hl7_accessionsacc_location
_999.patients_immunizationspim_location
_999.precertspre_scheduled_location
_999.precerts_mapprem_location
_999.radiology_resultsrad_res_location
aurora_standard.bhguaremp_location
aurora_standard.bhtguaremp_location
aurora_standard.chpinsrdclass_location
aurora_standard.chplocacclass_location
aurora_standard.chqcmeudcme_location
aurora_standard.chqletrdletter_location
aurora_standard.chrcntrcrx_location
aurora_standard.mergdocsfile_location
aurora_standard.mergsigsfile_location
aurora_standard.sthcadjdstock_location
aurora_standard.sticadjdstock_location
aurora_standard.stilocarstock_location
aurora_standard.stipyxlcrev_location
aurora_standard.stipyxlcexp_location
aurora_standard.stistkldstock_location
aurora_standard.stock2stock_location
aurora_standard.stoshipdstock_location
aurora_standard.tmplocarstock_location
initials
TableColumn
_1.ordersord_collectors_initials
_1188.ordersord_collectors_initials
_1218.ordersord_collectors_initials
_1548.ordersord_collectors_initials
_435.ordersord_collectors_initials
_436.ordersord_collectors_initials
_436_archive_testing.ordersord_collectors_initials
_437.ordersord_collectors_initials
_8.ordersord_collectors_initials
_81.ordersord_collectors_initials
_999.ordersord_collectors_initials