aurora_standard.chrpxord

Field Type Null Default Key Extra Comment
charge_credit varchar(7) YES
visit_no varchar(20) YES
pat_name varchar(20) YES
pyxis_code varchar(10) YES
med_name varchar(30) YES
units decimal(5,2) YES
nurse_station varchar(10) YES
user_name varchar(20) YES
user_id varchar(10) YES
order_datetime datetime YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
user_id
TableColumn
HSPI_CURES2015_B1.patient_abstractscompleted_by_user_id
HSPI_Central_Hospital.patient_abstractscompleted_by_user_id
HSPI_Dewitt.patient_abstractscompleted_by_user_id
HSPI_Fulton.patient_abstractscompleted_by_user_id
HSPI_Inferno.patient_abstractscompleted_by_user_id
HSPI_MU2015_E1.patient_abstractscompleted_by_user_id
HSPI_MU2015_G2.patient_abstractscompleted_by_user_id
HSPI_MU2015_G9.patient_abstractscompleted_by_user_id
HSPI_Sandbox.patient_abstractscompleted_by_user_id
HSPI_Summit_General.patient_abstractscompleted_by_user_id
HSPI_United_Physicians.patient_abstractscompleted_by_user_id
MPI.patient_abstractscompleted_by_user_id
SSO.login_eventsspoofed_user_id
SSO.user_registrationinvited_by_user_id
units
TableColumn
Loinc.loinc_codeslc_ipcc_units
Loinc.loinc_codeslc_submitted_units
Loinc.loinc_codeslc_example_units
Loinc.loinc_codeslc_curated_range_and_units
Loinc.loinc_codeslc_example_ucum_units
Loinc.loinc_codeslc_example_si_ucum_units
Loinc.loinc_codes_example_unitslceu_example_units
_1.charts_cpt_codeschcp_num_units
_1.charts_medicationscm_quantity_units
_1.charts_procedurescp_num_units
_1.clients_fee_schedules_mapcfsm_num_units
_1.clinical_interventions_coded_attributescica_units
_1.clinical_interventions_lab_results_mapcilrm_units
_1.configured_encounters_templates_cpt_codescetcc_num_units
_1.encounters_cpt_codesecp_num_units
_1.encounters_cpt_codes_templatesecpt_num_units
_1.hl7_resultsres_observ_units
_1.labs_resultslr_observ_units
_1.patients_immunizationspim_administered_units
_1.patients_immunizations_templatespimt_administered_units
_1.patients_inventorypinv_administered_units
_1.patients_medicationspms_quantity_units
_1.patients_prescriptionsprx_quantity_units
_1.patients_responsibility_estimates_servicesprests_ndc_num_units
_1.patients_responsibility_estimates_servicesprests_num_units
_1.patients_responsibility_estimates_servicesprests_allowed_units
_1.precerts_cpt_codespcp_num_units
_1188.charts_cpt_codeschcp_num_units
_1188.charts_medicationscm_quantity_units
_1188.charts_procedurescp_num_units
_1188.clients_fee_schedules_mapcfsm_num_units
_1188.clinical_interventions_lab_results_mapcilrm_units
_1188.configured_encounters_templates_cpt_codescetcc_num_units
_1188.encounters_cpt_codesecp_num_units
_1188.encounters_cpt_codes_templatesecpt_num_units
_1188.hl7_resultsres_observ_units
_1188.labs_resultslr_observ_units
_1188.patients_immunizationspim_administered_units
_1188.patients_immunizations_templatespimt_administered_units
_1188.patients_inventorypinv_administered_units
_1188.patients_medicationspms_quantity_units
_1188.patients_prescriptionsprx_quantity_units
_1188.patients_responsibility_estimates_servicesprests_ndc_num_units
_1188.patients_responsibility_estimates_servicesprests_num_units
_1188.patients_responsibility_estimates_servicesprests_allowed_units
_1188.precerts_cpt_codespcp_num_units
_1218.charts_cpt_codeschcp_num_units
_1218.charts_medicationscm_quantity_units
_1218.charts_procedurescp_num_units
_1218.clients_fee_schedules_mapcfsm_num_units
_1218.clinical_interventions_lab_results_mapcilrm_units
_1218.configured_encounters_templates_cpt_codescetcc_num_units
_1218.encounters_cpt_codesecp_num_units
_1218.encounters_cpt_codes_templatesecpt_num_units
_1218.hl7_resultsres_observ_units
_1218.labs_resultslr_observ_units
_1218.patients_immunizationspim_administered_units
_1218.patients_immunizations_templatespimt_administered_units
_1218.patients_inventorypinv_administered_units
_1218.patients_medicationspms_quantity_units
_1218.patients_prescriptionsprx_quantity_units
_1218.patients_responsibility_estimates_servicesprests_ndc_num_units
_1218.patients_responsibility_estimates_servicesprests_num_units
_1218.patients_responsibility_estimates_servicesprests_allowed_units
_1218.precerts_cpt_codespcp_num_units
_1548.charts_cpt_codeschcp_num_units
_1548.charts_medicationscm_quantity_units
_1548.charts_procedurescp_num_units
_1548.clients_fee_schedules_mapcfsm_num_units
_1548.clinical_interventions_coded_attributescica_units
_1548.clinical_interventions_lab_results_mapcilrm_units
_1548.configured_encounters_templates_cpt_codescetcc_num_units
_1548.encounters_cpt_codesecp_num_units
_1548.encounters_cpt_codes_templatesecpt_num_units
_1548.hl7_resultsres_observ_units
_1548.labs_resultslr_observ_units
_1548.patients_immunizationspim_administered_units
_1548.patients_immunizations_templatespimt_administered_units
_1548.patients_inventorypinv_administered_units
_1548.patients_medicationspms_quantity_units
_1548.patients_prescriptionsprx_quantity_units
_1548.patients_responsibility_estimates_servicesprests_ndc_num_units
_1548.patients_responsibility_estimates_servicesprests_num_units
_1548.patients_responsibility_estimates_servicesprests_allowed_units
_1548.precerts_cpt_codespcp_num_units
_435.charts_cpt_codeschcp_num_units
_435.charts_medicationscm_quantity_units
_435.charts_procedurescp_num_units
_435.clients_fee_schedules_mapcfsm_num_units
_435.clinical_interventions_coded_attributescica_units
_435.clinical_interventions_lab_results_mapcilrm_units
_435.configured_encounters_templates_cpt_codescetcc_num_units
_435.encounters_cpt_codesecp_num_units
_435.encounters_cpt_codes_templatesecpt_num_units
_435.hl7_resultsres_observ_units
_435.labs_resultslr_observ_units
_435.patients_immunizationspim_administered_units
_435.patients_immunizations_templatespimt_administered_units
_435.patients_inventorypinv_administered_units
_435.patients_medicationspms_quantity_units
_435.patients_prescriptionsprx_quantity_units
_435.patients_responsibility_estimates_servicesprests_ndc_num_units
_435.patients_responsibility_estimates_servicesprests_num_units
_435.precerts_cpt_codespcp_num_units
_436.charts_cpt_codeschcp_num_units
_436.charts_medicationscm_quantity_units
_436.charts_procedurescp_num_units
_436.clients_fee_schedules_mapcfsm_num_units
_436.clinical_interventions_coded_attributescica_units
_436.clinical_interventions_lab_results_mapcilrm_units
_436.configured_encounters_templates_cpt_codescetcc_num_units
_436.encounters_cpt_codesecp_num_units
_436.encounters_cpt_codes_templatesecpt_num_units
_436.hl7_resultsres_observ_units
_436.labs_resultslr_observ_units
_436.patients_immunizationspim_administered_units
_436.patients_immunizations_templatespimt_administered_units
_436.patients_inventorypinv_administered_units
_436.patients_medicationspms_quantity_units
_436.patients_prescriptionsprx_quantity_units
_436.patients_responsibility_estimates_servicesprests_ndc_num_units
_436.patients_responsibility_estimates_servicesprests_num_units
_436.precerts_cpt_codespcp_num_units
_436_archive_testing.charts_cpt_codeschcp_num_units
_436_archive_testing.charts_medicationscm_quantity_units
_436_archive_testing.charts_procedurescp_num_units
_436_archive_testing.clients_fee_schedules_mapcfsm_num_units
_436_archive_testing.clinical_interventions_coded_attributescica_units
_436_archive_testing.clinical_interventions_lab_results_mapcilrm_units
_436_archive_testing.configured_encounters_templates_cpt_codescetcc_num_units
_436_archive_testing.encounters_cpt_codesecp_num_units
_436_archive_testing.encounters_cpt_codes_templatesecpt_num_units
_436_archive_testing.hl7_resultsres_observ_units
_436_archive_testing.labs_resultslr_observ_units
_436_archive_testing.patients_immunizationspim_administered_units
_436_archive_testing.patients_immunizations_templatespimt_administered_units
_436_archive_testing.patients_inventorypinv_administered_units
_436_archive_testing.patients_medicationspms_quantity_units
_436_archive_testing.patients_prescriptionsprx_quantity_units
_436_archive_testing.patients_responsibility_estimates_servicesprests_ndc_num_units
_436_archive_testing.patients_responsibility_estimates_servicesprests_num_units
_436_archive_testing.precerts_cpt_codespcp_num_units
_437.charts_cpt_codeschcp_num_units
_437.charts_medicationscm_quantity_units
_437.charts_procedurescp_num_units
_437.clients_fee_schedules_mapcfsm_num_units
_437.clinical_interventions_coded_attributescica_units
_437.clinical_interventions_lab_results_mapcilrm_units
_437.configured_encounters_templates_cpt_codescetcc_num_units
_437.encounters_cpt_codesecp_num_units
_437.encounters_cpt_codes_templatesecpt_num_units
_437.hl7_resultsres_observ_units
_437.labs_resultslr_observ_units
_437.patients_immunizationspim_administered_units
_437.patients_immunizations_templatespimt_administered_units
_437.patients_inventorypinv_administered_units
_437.patients_medicationspms_quantity_units
_437.patients_prescriptionsprx_quantity_units
_437.patients_responsibility_estimates_servicesprests_ndc_num_units
_437.patients_responsibility_estimates_servicesprests_num_units
_437.precerts_cpt_codespcp_num_units
_8.charts_cpt_codeschcp_num_units
_8.charts_medicationscm_quantity_units
_8.charts_procedurescp_num_units
_8.clients_fee_schedules_mapcfsm_num_units
_8.clinical_interventions_coded_attributescica_units
_8.clinical_interventions_lab_results_mapcilrm_units
_8.configured_encounters_templates_cpt_codescetcc_num_units
_8.daily_close_calculationsdcc_ecp_num_units
_8.encounters_cpt_codesecp_num_units
_8.encounters_cpt_codes_templatesecpt_num_units
_8.hl7_resultsres_observ_units
_8.labs_resultslr_observ_units
_8.patients_immunizationspim_administered_units
_8.patients_immunizations_templatespimt_administered_units
_8.patients_inventorypinv_administered_units
_8.patients_medicationspms_quantity_units
_8.patients_prescriptionsprx_quantity_units
_8.patients_responsibility_estimates_servicesprests_ndc_num_units
_8.patients_responsibility_estimates_servicesprests_num_units
_8.patients_responsibility_estimates_servicesprests_allowed_units
_8.precerts_cpt_codespcp_num_units
_81.charts_cpt_codeschcp_num_units
_81.charts_medicationscm_quantity_units
_81.charts_procedurescp_num_units
_81.clients_fee_schedules_mapcfsm_num_units
_81.clinical_interventions_lab_results_mapcilrm_units
_81.configured_encounters_templates_cpt_codescetcc_num_units
_81.encounters_cpt_codesecp_num_units
_81.encounters_cpt_codes_templatesecpt_num_units
_81.hl7_resultsres_observ_units
_81.labs_resultslr_observ_units
_81.patients_immunizationspim_administered_units
_81.patients_immunizations_templatespimt_administered_units
_81.patients_inventorypinv_administered_units
_81.patients_medicationspms_quantity_units
_81.patients_prescriptionsprx_quantity_units
_81.patients_responsibility_estimates_servicesprests_ndc_num_units
_81.patients_responsibility_estimates_servicesprests_num_units
_81.patients_responsibility_estimates_servicesprests_allowed_units
_81.precerts_cpt_codespcp_num_units
_999.charts_cpt_codeschcp_num_units
_999.charts_medicationscm_quantity_units
_999.charts_procedurescp_num_units
_999.clients_fee_schedules_mapcfsm_num_units
_999.clinical_interventions_coded_attributescica_units
_999.clinical_interventions_lab_results_mapcilrm_units
_999.configured_encounters_templates_cpt_codescetcc_num_units
_999.encounters_cpt_codesecp_num_units
_999.encounters_cpt_codes_templatesecpt_num_units
_999.hl7_resultsres_observ_units
_999.labs_resultslr_observ_units
_999.patients_immunizationspim_administered_units
_999.patients_immunizations_templatespimt_administered_units
_999.patients_inventorypinv_administered_units
_999.patients_medicationspms_quantity_units
_999.patients_prescriptionsprx_quantity_units
_999.patients_responsibility_estimates_servicesprests_ndc_num_units
_999.patients_responsibility_estimates_servicesprests_num_units
_999.patients_responsibility_estimates_servicesprests_allowed_units
_999.precerts_cpt_codespcp_num_units
aurora_standard.c7cdmrxbill_units
aurora_standard.cachrgchg_units
aurora_standard.cachrg2chg_units
aurora_standard.cachrgcachg_units
aurora_standard.cachrgevochg_units
aurora_standard.canullchrgchg_units
aurora_standard.caroomchg_units
aurora_standard.chmabstrblood_units
aurora_standard.chmapcbrcpt_units
aurora_standard.chmapcircpt_units
aurora_standard.choordmdorder_units
aurora_standard.choordrcdefault_units
aurora_standard.chrordrrdispense_units
aurora_standard.oeorderorder_units
common.loinc_codeslc_ipcc_units
common.loinc_codeslc_submitted_units
common.loinc_codeslc_example_units
common.loinc_codeslc_curated_range_and_units
common.loinc_codeslc_example_ucum_units
common.loinc_codeslc_example_si_ucum_units
common.test_codes_cpttcc_units
template_library.encounters_cpt_codes_templatesecpt_num_units
template_library.patients_immunizations_templatespimt_administered_units
user_name
TableColumn
_1.erx_practiceserx_prac_user_name
_1.erx_web_userserx_users_user_name
_1188.erx_practiceserx_prac_user_name
_1188.erx_web_userserx_users_user_name
_1218.erx_practiceserx_prac_user_name
_1218.erx_web_userserx_users_user_name
_1548.erx_practiceserx_prac_user_name
_1548.erx_web_userserx_users_user_name
_435.erx_practiceserx_prac_user_name
_435.erx_web_userserx_users_user_name
_436.erx_practiceserx_prac_user_name
_436.erx_web_userserx_users_user_name
_436_archive_testing.erx_practiceserx_prac_user_name
_436_archive_testing.erx_web_userserx_users_user_name
_437.erx_practiceserx_prac_user_name
_437.erx_web_userserx_users_user_name
_8.erx_practiceserx_prac_user_name
_8.erx_web_userserx_users_user_name
_81.erx_practiceserx_prac_user_name
_81.erx_web_userserx_users_user_name
_999.erx_practiceserx_prac_user_name
_999.erx_web_userserx_users_user_name
visit_no
TableColumn
aurora_standard.anotesdan_visit_no
aurora_standard.bdfiledbd_visit_no
aurora_standard.chmarsipat_visit_no
aurora_standard.chmcampipat_visit_no
aurora_standard.chmcombrto_visit_no
aurora_standard.chmexmpipat_visit_no
aurora_standard.chmokipdpat_visit_no
aurora_standard.chmokopdpat_visit_no
aurora_standard.chmradedpat_visit_no
aurora_standard.chmradexpat_visit_no
aurora_standard.chrcombrto_visit_no
aurora_standard.ncexmpipat_visit_no