aurora_standard.chrhomed

Field Type Null Default Key Extra Comment
visit_no int(11) YES
item_no int(11) YES
medication varchar(30) YES
dose varchar(15) YES
sig_code varchar(10) YES
last_dose varchar(10) YES
input_by int(11) YES
process_flag varchar(1) YES
process_by int(11) YES
input_date date YES
input_time time YES
comment varchar(60) YES
status varchar(1) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
status
TableColumn
API.request_logs_v2http_status
HSPI_Bastrop.appointmentsappointment_status
HSPI_Bastrop.communicationscommunication_status
HSPI_Bastrop.encountersencounter_status
HSPI_Bastrop.encountersencounter_billing_status
HSPI_Bastrop.laboratory_orderslaboratory_order_status
HSPI_Bastrop.medication_requestsmedication_request_status
HSPI_Bastrop.observationsobservation_status
HSPI_Bastrop.problemsclinical_status
HSPI_Bastrop.problemsverification_status
HSPI_Bastrop.proceduresprocedure_status
HSPI_CURES2015_B1.allergiesverification_status
HSPI_CURES2015_B1.appointmentsappointment_status
HSPI_CURES2015_B1.communicationscommunication_status
HSPI_CURES2015_B1.encountersencounter_status
HSPI_CURES2015_B1.encountersencounter_billing_status
HSPI_CURES2015_B1.laboratory_orderslaboratory_order_status
HSPI_CURES2015_B1.medication_requestsmedication_request_status
HSPI_CURES2015_B1.observationsobservation_status
HSPI_CURES2015_B1.problemsclinical_status
HSPI_CURES2015_B1.problemsverification_status
HSPI_CURES2015_B1.proceduresprocedure_status
HSPI_Central_Hospital.allergiesverification_status
HSPI_Central_Hospital.appointmentsappointment_status
HSPI_Central_Hospital.communicationscommunication_status
HSPI_Central_Hospital.encountersencounter_status
HSPI_Central_Hospital.encountersencounter_billing_status
HSPI_Central_Hospital.laboratory_orderslaboratory_order_status
HSPI_Central_Hospital.medication_requestsmedication_request_status
HSPI_Central_Hospital.observationsobservation_status
HSPI_Central_Hospital.problemsclinical_status
HSPI_Central_Hospital.problemsverification_status
HSPI_Central_Hospital.proceduresprocedure_status
HSPI_Dewitt.allergiesverification_status
HSPI_Dewitt.appointmentsappointment_status
HSPI_Dewitt.communicationscommunication_status
HSPI_Dewitt.encountersencounter_status
HSPI_Dewitt.encountersencounter_billing_status
HSPI_Dewitt.laboratory_orderslaboratory_order_status
HSPI_Dewitt.medication_requestsmedication_request_status
HSPI_Dewitt.observationsobservation_status
HSPI_Dewitt.problemsclinical_status
HSPI_Dewitt.problemsverification_status
HSPI_Dewitt.proceduresprocedure_status
HSPI_Fulton.allergiesverification_status
HSPI_Fulton.appointmentsappointment_status
HSPI_Fulton.communicationscommunication_status
HSPI_Fulton.encountersencounter_status
HSPI_Fulton.encountersencounter_billing_status
HSPI_Fulton.laboratory_orderslaboratory_order_status
HSPI_Fulton.medication_requestsmedication_request_status
HSPI_Fulton.observationsobservation_status
HSPI_Fulton.problemsclinical_status
HSPI_Fulton.problemsverification_status
HSPI_Fulton.proceduresprocedure_status
HSPI_Inferno.allergiesverification_status
HSPI_Inferno.appointmentsappointment_status
HSPI_Inferno.communicationscommunication_status
HSPI_Inferno.encountersencounter_status
HSPI_Inferno.encountersencounter_billing_status
HSPI_Inferno.laboratory_orderslaboratory_order_status
HSPI_Inferno.medication_requestsmedication_request_status
HSPI_Inferno.observationsobservation_status
HSPI_Inferno.problemsclinical_status
HSPI_Inferno.problemsverification_status
HSPI_Inferno.proceduresprocedure_status
HSPI_MU2015_E1.allergiesverification_status
HSPI_MU2015_E1.appointmentsappointment_status
HSPI_MU2015_E1.communicationscommunication_status
HSPI_MU2015_E1.encountersencounter_status
HSPI_MU2015_E1.encountersencounter_billing_status
HSPI_MU2015_E1.laboratory_orderslaboratory_order_status
HSPI_MU2015_E1.medication_requestsmedication_request_status
HSPI_MU2015_E1.observationsobservation_status
HSPI_MU2015_E1.problemsclinical_status
HSPI_MU2015_E1.problemsverification_status
HSPI_MU2015_E1.proceduresprocedure_status
HSPI_MU2015_G2.allergiesverification_status
HSPI_MU2015_G2.appointmentsappointment_status
HSPI_MU2015_G2.communicationscommunication_status
HSPI_MU2015_G2.encountersencounter_status
HSPI_MU2015_G2.encountersencounter_billing_status
HSPI_MU2015_G2.laboratory_orderslaboratory_order_status
HSPI_MU2015_G2.medication_requestsmedication_request_status
HSPI_MU2015_G2.observationsobservation_status
HSPI_MU2015_G2.problemsclinical_status
HSPI_MU2015_G2.problemsverification_status
HSPI_MU2015_G2.proceduresprocedure_status
HSPI_MU2015_G9.allergiesverification_status
HSPI_MU2015_G9.appointmentsappointment_status
HSPI_MU2015_G9.communicationscommunication_status
HSPI_MU2015_G9.encountersencounter_status
HSPI_MU2015_G9.encountersencounter_billing_status
HSPI_MU2015_G9.laboratory_orderslaboratory_order_status
HSPI_MU2015_G9.medication_requestsmedication_request_status
HSPI_MU2015_G9.observationsobservation_status
HSPI_MU2015_G9.problemsclinical_status
HSPI_MU2015_G9.problemsverification_status
HSPI_MU2015_G9.proceduresprocedure_status
HSPI_Ness.appointmentsappointment_status
HSPI_Ness.encountersencounter_status
HSPI_Ness.laboratory_orderslaboratory_order_status
HSPI_Ness.observationsobservation_status
HSPI_Sandbox.allergiesverification_status
HSPI_Sandbox.appointmentsappointment_status
HSPI_Sandbox.communicationscommunication_status
HSPI_Sandbox.encountersencounter_status
HSPI_Sandbox.encountersencounter_billing_status
HSPI_Sandbox.laboratory_orderslaboratory_order_status
HSPI_Sandbox.medication_requestsmedication_request_status
HSPI_Sandbox.observationsobservation_status
HSPI_Sandbox.problemsclinical_status
HSPI_Sandbox.problemsverification_status
HSPI_Sandbox.proceduresprocedure_status
HSPI_Summit_General.allergiesverification_status
HSPI_Summit_General.appointmentsappointment_status
HSPI_Summit_General.communicationscommunication_status
HSPI_Summit_General.encountersencounter_status
HSPI_Summit_General.encountersencounter_billing_status
HSPI_Summit_General.laboratory_orderslaboratory_order_status
HSPI_Summit_General.medication_requestsmedication_request_status
HSPI_Summit_General.observationsobservation_status
HSPI_Summit_General.problemsclinical_status
HSPI_Summit_General.problemsverification_status
HSPI_Summit_General.proceduresprocedure_status
HSPI_System.web_hook_request_logshttp_status
HSPI_System.web_hook_triggershttp_status
HSPI_United_Physicians.allergiesverification_status
HSPI_United_Physicians.appointmentsappointment_status
HSPI_United_Physicians.communicationscommunication_status
HSPI_United_Physicians.encountersencounter_status
HSPI_United_Physicians.encountersencounter_billing_status
HSPI_United_Physicians.laboratory_orderslaboratory_order_status
HSPI_United_Physicians.medication_requestsmedication_request_status
HSPI_United_Physicians.observationsobservation_status
HSPI_United_Physicians.problemsclinical_status
HSPI_United_Physicians.problemsverification_status
HSPI_United_Physicians.proceduresprocedure_status
Loinc.loinc_codeslc_status
MPI.allergiesverification_status
MPI.appointmentsappointment_status
MPI.communicationscommunication_status
MPI.encountersencounter_status
MPI.encountersencounter_billing_status
MPI.laboratory_orderslaboratory_order_status
MPI.medication_requestsmedication_request_status
MPI.observationsobservation_status
MPI.problemsclinical_status
MPI.problemsverification_status
MPI.proceduresprocedure_status
_1.appointment_reminders_configurationsarcon_status
_1.appointments_requestsaptreq_status
_1.billing_reports_queuebrq_status
_1.chartschrt_status
_1.chartschrt_marital_status
_1.charts_care_planccp_referral_status
_1.charts_icd9_codescic_status
_1.clinical_interventionsci_marital_status
_1.cpoe_responsescpoe_res_status
_1.encountersenc_maritial_status
_1.encountersenc_employer_status
_1.encountersenc_ins1_tpl_status
_1.encountersenc_ins2_tpl_status
_1.encounters_claims_filesecf_status
_1.encounters_paymentsepay_status
_1.encounters_payments_edi_logsepel_status
_1.encounters_soapesp_pss_status
_1.encounters_ub04enc_ub04_17_status
_1.erx_notificationserx_nots_status
_1.hl7_accessionsacc_status
_1.hl7_ordersord_status
_1.hl7_resultsres_status
_1.immunization_reportedimrp_status
_1.insurancesins_status
_1.ordersord_status
_1.orders_templatesordt_status
_1.patientspat_maritial_status
_1.patientspat_employer_status
_1.patients_allergiespalg_status
_1.patients_demographics_snapshotspds_maritial_status
_1.patients_demographics_snapshotspds_employer_status
_1.patients_document_assemblypda_status
_1.patients_handoutsphs_status
_1.patients_handoutsphs_review_status
_1.patients_icd9_problemspip_status
_1.patients_icd9_problemspip_cog_status
_1.patients_icd9_problemspip_func_status
_1.patients_referralspref_referral_status
_1.patients_reminderspr_status
_1.patients_responsibility_estimatesprest_status
_1.patients_smoking_statuspss_status
_1.patients_statementspst_status
_1.precertspre_maritial_status
_1.precertspre_employer_status
_1.problems_listspl_status
_1.radiology_ordersrad_status
_1.radiology_resultsrad_res_status
_1.radiology_results_test_codes_resultsrrtcres_status
_1.taskstask_status
_1188.appointment_reminders_configurationsarcon_status
_1188.appointments_requestsaptreq_status
_1188.billing_reports_queuebrq_status
_1188.chartschrt_status
_1188.chartschrt_marital_status
_1188.charts_care_planccp_referral_status
_1188.charts_icd9_codescic_status
_1188.clinical_interventionsci_marital_status
_1188.cpoe_responsescpoe_res_status
_1188.encountersenc_maritial_status
_1188.encountersenc_employer_status
_1188.encountersenc_ins1_tpl_status
_1188.encountersenc_ins2_tpl_status
_1188.encounters_claims_filesecf_status
_1188.encounters_paymentsepay_status
_1188.encounters_payments_edi_logsepel_status
_1188.encounters_soapesp_pss_status
_1188.encounters_ub04enc_ub04_17_status
_1188.erx_notificationserx_nots_status
_1188.hl7_accessionsacc_status
_1188.hl7_ordersord_status
_1188.hl7_resultsres_status
_1188.immunization_reportedimrp_status
_1188.insurancesins_status
_1188.ordersord_status
_1188.orders_templatesordt_status
_1188.patientspat_maritial_status
_1188.patientspat_employer_status
_1188.patients_allergiespalg_status
_1188.patients_demographics_snapshotspds_maritial_status
_1188.patients_demographics_snapshotspds_employer_status
_1188.patients_document_assemblypda_status
_1188.patients_handoutsphs_status
_1188.patients_handoutsphs_review_status
_1188.patients_icd9_problemspip_status
_1188.patients_icd9_problemspip_cog_status
_1188.patients_icd9_problemspip_func_status
_1188.patients_referralspref_referral_status
_1188.patients_reminderspr_status
_1188.patients_responsibility_estimatesprest_status
_1188.patients_smoking_statuspss_status
_1188.patients_statementspst_status
_1188.precertspre_maritial_status
_1188.precertspre_employer_status
_1188.problems_listspl_status
_1188.radiology_ordersrad_status
_1188.radiology_resultsrad_res_status
_1188.radiology_results_test_codes_resultsrrtcres_status
_1188.taskstask_status
_1218.appointment_reminders_configurationsarcon_status
_1218.appointments_requestsaptreq_status
_1218.billing_reports_queuebrq_status
_1218.chartschrt_status
_1218.chartschrt_marital_status
_1218.charts_care_planccp_referral_status
_1218.charts_icd9_codescic_status
_1218.clinical_interventionsci_marital_status
_1218.cpoe_responsescpoe_res_status
_1218.encountersenc_maritial_status
_1218.encountersenc_employer_status
_1218.encountersenc_ins1_tpl_status
_1218.encountersenc_ins2_tpl_status
_1218.encounters_claims_filesecf_status
_1218.encounters_paymentsepay_status
_1218.encounters_payments_edi_logsepel_status
_1218.encounters_soapesp_pss_status
_1218.encounters_ub04enc_ub04_17_status
_1218.erx_notificationserx_nots_status
_1218.hl7_accessionsacc_status
_1218.hl7_ordersord_status
_1218.hl7_resultsres_status
_1218.immunization_reportedimrp_status
_1218.insurancesins_status
_1218.ordersord_status
_1218.orders_templatesordt_status
_1218.patientspat_maritial_status
_1218.patientspat_employer_status
_1218.patients_allergiespalg_status
_1218.patients_demographics_snapshotspds_maritial_status
_1218.patients_demographics_snapshotspds_employer_status
_1218.patients_document_assemblypda_status
_1218.patients_handoutsphs_status
_1218.patients_handoutsphs_review_status
_1218.patients_icd9_problemspip_status
_1218.patients_icd9_problemspip_cog_status
_1218.patients_icd9_problemspip_func_status
_1218.patients_referralspref_referral_status
_1218.patients_reminderspr_status
_1218.patients_responsibility_estimatesprest_status
_1218.patients_smoking_statuspss_status
_1218.patients_statementspst_status
_1218.precertspre_maritial_status
_1218.precertspre_employer_status
_1218.problems_listspl_status
_1218.radiology_ordersrad_status
_1218.radiology_resultsrad_res_status
_1218.radiology_results_test_codes_resultsrrtcres_status
_1218.taskstask_status
_1548.appointment_reminders_configurationsarcon_status
_1548.appointments_requestsaptreq_status
_1548.billing_reports_queuebrq_status
_1548.chartschrt_status
_1548.chartschrt_marital_status
_1548.charts_care_planccp_referral_status
_1548.charts_icd9_codescic_status
_1548.clinical_interventionsci_marital_status
_1548.cpoe_responsescpoe_res_status
_1548.encountersenc_maritial_status
_1548.encountersenc_employer_status
_1548.encountersenc_ins1_tpl_status
_1548.encountersenc_ins2_tpl_status
_1548.encounters_claims_filesecf_status
_1548.encounters_paymentsepay_status
_1548.encounters_payments_edi_logsepel_status
_1548.encounters_soapesp_pss_status
_1548.encounters_ub04enc_ub04_17_status
_1548.erx_notificationserx_nots_status
_1548.hl7_accessionsacc_status
_1548.hl7_ordersord_status
_1548.hl7_resultsres_status
_1548.immunization_reportedimrp_status
_1548.insurancesins_status
_1548.ordersord_status
_1548.orders_templatesordt_status
_1548.patientspat_maritial_status
_1548.patientspat_employer_status
_1548.patients_allergiespalg_status
_1548.patients_demographics_snapshotspds_maritial_status
_1548.patients_demographics_snapshotspds_employer_status
_1548.patients_document_assemblypda_status
_1548.patients_handoutsphs_status
_1548.patients_handoutsphs_review_status
_1548.patients_icd9_problemspip_status
_1548.patients_icd9_problemspip_cog_status
_1548.patients_icd9_problemspip_func_status
_1548.patients_referralspref_referral_status
_1548.patients_reminderspr_status
_1548.patients_responsibility_estimatesprest_status
_1548.patients_smoking_statuspss_status
_1548.patients_statementspst_status
_1548.precertspre_maritial_status
_1548.precertspre_employer_status
_1548.problems_listspl_status
_1548.radiology_ordersrad_status
_1548.radiology_resultsrad_res_status
_1548.radiology_results_test_codes_resultsrrtcres_status
_1548.taskstask_status
_435.appointment_reminders_configurationsarcon_status
_435.appointments_requestsaptreq_status
_435.billing_reports_queuebrq_status
_435.chartschrt_status
_435.chartschrt_marital_status
_435.charts_care_planccp_referral_status
_435.charts_icd9_codescic_status
_435.clinical_interventionsci_marital_status
_435.cpoe_responsescpoe_res_status
_435.encountersenc_maritial_status
_435.encountersenc_employer_status
_435.encountersenc_ins1_tpl_status
_435.encountersenc_ins2_tpl_status
_435.encounters_claims_filesecf_status
_435.encounters_paymentsepay_status
_435.encounters_payments_edi_logsepel_status
_435.encounters_soapesp_pss_status
_435.encounters_ub04enc_ub04_17_status
_435.erx_notificationserx_nots_status
_435.hl7_accessionsacc_status
_435.hl7_ordersord_status
_435.hl7_resultsres_status
_435.immunization_reportedimrp_status
_435.insurancesins_status
_435.ordersord_status
_435.orders_templatesordt_status
_435.patientspat_maritial_status
_435.patientspat_employer_status
_435.patients_allergiespalg_status
_435.patients_demographics_snapshotspds_maritial_status
_435.patients_demographics_snapshotspds_employer_status
_435.patients_document_assemblypda_status
_435.patients_handoutsphs_status
_435.patients_handoutsphs_review_status
_435.patients_icd9_problemspip_status
_435.patients_icd9_problemspip_cog_status
_435.patients_icd9_problemspip_func_status
_435.patients_referralspref_referral_status
_435.patients_reminderspr_status
_435.patients_responsibility_estimatesprest_status
_435.patients_smoking_statuspss_status
_435.patients_statementspst_status
_435.precertspre_maritial_status
_435.precertspre_employer_status
_435.problems_listspl_status
_435.radiology_ordersrad_status
_435.radiology_resultsrad_res_status
_435.radiology_results_test_codes_resultsrrtcres_status
_435.taskstask_status
_436.appointment_reminders_configurationsarcon_status
_436.appointments_requestsaptreq_status
_436.billing_reports_queuebrq_status
_436.chartschrt_status
_436.chartschrt_marital_status
_436.charts_care_planccp_referral_status
_436.charts_icd9_codescic_status
_436.clinical_interventionsci_marital_status
_436.cpoe_responsescpoe_res_status
_436.encountersenc_maritial_status
_436.encountersenc_employer_status
_436.encountersenc_ins1_tpl_status
_436.encountersenc_ins2_tpl_status
_436.encounters_claims_filesecf_status
_436.encounters_paymentsepay_status
_436.encounters_payments_edi_logsepel_status
_436.encounters_soapesp_pss_status
_436.encounters_ub04enc_ub04_17_status
_436.erx_notificationserx_nots_status
_436.hl7_accessionsacc_status
_436.hl7_ordersord_status
_436.hl7_resultsres_status
_436.immunization_reportedimrp_status
_436.insurancesins_status
_436.ordersord_status
_436.orders_templatesordt_status
_436.patientspat_maritial_status
_436.patientspat_employer_status
_436.patients_allergiespalg_status
_436.patients_demographics_snapshotspds_maritial_status
_436.patients_demographics_snapshotspds_employer_status
_436.patients_document_assemblypda_status
_436.patients_handoutsphs_status
_436.patients_handoutsphs_review_status
_436.patients_icd9_problemspip_status
_436.patients_icd9_problemspip_cog_status
_436.patients_icd9_problemspip_func_status
_436.patients_referralspref_referral_status
_436.patients_reminderspr_status
_436.patients_responsibility_estimatesprest_status
_436.patients_smoking_statuspss_status
_436.patients_statementspst_status
_436.precertspre_maritial_status
_436.precertspre_employer_status
_436.problems_listspl_status
_436.radiology_ordersrad_status
_436.radiology_resultsrad_res_status
_436.radiology_results_test_codes_resultsrrtcres_status
_436.taskstask_status
_436_archive_testing.appointment_reminders_configurationsarcon_status
_436_archive_testing.appointments_requestsaptreq_status
_436_archive_testing.billing_reports_queuebrq_status
_436_archive_testing.chartschrt_status
_436_archive_testing.chartschrt_marital_status
_436_archive_testing.charts_care_planccp_referral_status
_436_archive_testing.charts_icd9_codescic_status
_436_archive_testing.clinical_interventionsci_marital_status
_436_archive_testing.cpoe_responsescpoe_res_status
_436_archive_testing.encountersenc_maritial_status
_436_archive_testing.encountersenc_employer_status
_436_archive_testing.encountersenc_ins1_tpl_status
_436_archive_testing.encountersenc_ins2_tpl_status
_436_archive_testing.encounters_claims_filesecf_status
_436_archive_testing.encounters_paymentsepay_status
_436_archive_testing.encounters_payments_edi_logsepel_status
_436_archive_testing.encounters_soapesp_pss_status
_436_archive_testing.encounters_ub04enc_ub04_17_status
_436_archive_testing.erx_notificationserx_nots_status
_436_archive_testing.hl7_accessionsacc_status
_436_archive_testing.hl7_ordersord_status
_436_archive_testing.hl7_resultsres_status
_436_archive_testing.immunization_reportedimrp_status
_436_archive_testing.insurancesins_status
_436_archive_testing.ordersord_status
_436_archive_testing.orders_templatesordt_status
_436_archive_testing.patientspat_maritial_status
_436_archive_testing.patientspat_employer_status
_436_archive_testing.patients_allergiespalg_status
_436_archive_testing.patients_demographics_snapshotspds_maritial_status
_436_archive_testing.patients_demographics_snapshotspds_employer_status
_436_archive_testing.patients_document_assemblypda_status
_436_archive_testing.patients_handoutsphs_status
_436_archive_testing.patients_handoutsphs_review_status
_436_archive_testing.patients_icd9_problemspip_status
_436_archive_testing.patients_icd9_problemspip_cog_status
_436_archive_testing.patients_icd9_problemspip_func_status
_436_archive_testing.patients_referralspref_referral_status
_436_archive_testing.patients_reminderspr_status
_436_archive_testing.patients_responsibility_estimatesprest_status
_436_archive_testing.patients_smoking_statuspss_status
_436_archive_testing.patients_statementspst_status
_436_archive_testing.precertspre_maritial_status
_436_archive_testing.precertspre_employer_status
_436_archive_testing.problems_listspl_status
_436_archive_testing.radiology_ordersrad_status
_436_archive_testing.radiology_resultsrad_res_status
_436_archive_testing.radiology_results_test_codes_resultsrrtcres_status
_436_archive_testing.taskstask_status
_437.appointment_reminders_configurationsarcon_status
_437.appointments_requestsaptreq_status
_437.billing_reports_queuebrq_status
_437.chartschrt_status
_437.chartschrt_marital_status
_437.charts_care_planccp_referral_status
_437.charts_icd9_codescic_status
_437.clinical_interventionsci_marital_status
_437.cpoe_responsescpoe_res_status
_437.encountersenc_maritial_status
_437.encountersenc_employer_status
_437.encountersenc_ins1_tpl_status
_437.encountersenc_ins2_tpl_status
_437.encounters_claims_filesecf_status
_437.encounters_paymentsepay_status
_437.encounters_payments_edi_logsepel_status
_437.encounters_soapesp_pss_status
_437.encounters_ub04enc_ub04_17_status
_437.erx_notificationserx_nots_status
_437.hl7_accessionsacc_status
_437.hl7_ordersord_status
_437.hl7_resultsres_status
_437.immunization_reportedimrp_status
_437.insurancesins_status
_437.ordersord_status
_437.orders_templatesordt_status
_437.patientspat_maritial_status
_437.patientspat_employer_status
_437.patients_allergiespalg_status
_437.patients_demographics_snapshotspds_maritial_status
_437.patients_demographics_snapshotspds_employer_status
_437.patients_document_assemblypda_status
_437.patients_handoutsphs_status
_437.patients_handoutsphs_review_status
_437.patients_icd9_problemspip_status
_437.patients_icd9_problemspip_cog_status
_437.patients_icd9_problemspip_func_status
_437.patients_referralspref_referral_status
_437.patients_reminderspr_status
_437.patients_responsibility_estimatesprest_status
_437.patients_smoking_statuspss_status
_437.patients_statementspst_status
_437.precertspre_maritial_status
_437.precertspre_employer_status
_437.problems_listspl_status
_437.radiology_ordersrad_status
_437.radiology_resultsrad_res_status
_437.radiology_results_test_codes_resultsrrtcres_status
_437.taskstask_status
_8.appointment_reminders_configurationsarcon_status
_8.appointments_requestsaptreq_status
_8.billing_reports_queuebrq_status
_8.chartschrt_status
_8.chartschrt_marital_status
_8.charts_care_planccp_referral_status
_8.charts_icd9_codescic_status
_8.clinical_interventionsci_marital_status
_8.cpoe_responsescpoe_res_status
_8.encountersenc_maritial_status
_8.encountersenc_employer_status
_8.encountersenc_ins1_tpl_status
_8.encountersenc_ins2_tpl_status
_8.encounters_claims_filesecf_status
_8.encounters_paymentsepay_status
_8.encounters_payments_edi_logsepel_status
_8.encounters_soapesp_pss_status
_8.encounters_ub04enc_ub04_17_status
_8.erx_notificationserx_nots_status
_8.hl7_accessionsacc_status
_8.hl7_ordersord_status
_8.hl7_resultsres_status
_8.immunization_reportedimrp_status
_8.insurancesins_status
_8.ordersord_status
_8.orders_templatesordt_status
_8.patientspat_maritial_status
_8.patientspat_employer_status
_8.patients_allergiespalg_status
_8.patients_demographics_snapshotspds_maritial_status
_8.patients_demographics_snapshotspds_employer_status
_8.patients_document_assemblypda_status
_8.patients_handoutsphs_status
_8.patients_handoutsphs_review_status
_8.patients_icd9_problemspip_status
_8.patients_icd9_problemspip_cog_status
_8.patients_icd9_problemspip_func_status
_8.patients_referralspref_referral_status
_8.patients_reminderspr_status
_8.patients_responsibility_estimatesprest_status
_8.patients_smoking_statuspss_status
_8.patients_statementspst_status
_8.precertspre_maritial_status
_8.precertspre_employer_status
_8.problems_listspl_status
_8.radiology_ordersrad_status
_8.radiology_resultsrad_res_status
_8.radiology_results_test_codes_resultsrrtcres_status
_8.taskstask_status
_81.appointment_reminders_configurationsarcon_status
_81.appointments_requestsaptreq_status
_81.billing_reports_queuebrq_status
_81.chartschrt_status
_81.chartschrt_marital_status
_81.charts_care_planccp_referral_status
_81.charts_icd9_codescic_status
_81.clinical_interventionsci_marital_status
_81.cpoe_responsescpoe_res_status
_81.encountersenc_maritial_status
_81.encountersenc_employer_status
_81.encountersenc_ins1_tpl_status
_81.encountersenc_ins2_tpl_status
_81.encounters_claims_filesecf_status
_81.encounters_paymentsepay_status
_81.encounters_payments_edi_logsepel_status
_81.encounters_soapesp_pss_status
_81.encounters_ub04enc_ub04_17_status
_81.erx_notificationserx_nots_status
_81.hl7_accessionsacc_status
_81.hl7_ordersord_status
_81.hl7_resultsres_status
_81.immunization_reportedimrp_status
_81.insurancesins_status
_81.ordersord_status
_81.orders_templatesordt_status
_81.patientspat_maritial_status
_81.patientspat_employer_status
_81.patients_allergiespalg_status
_81.patients_demographics_snapshotspds_maritial_status
_81.patients_demographics_snapshotspds_employer_status
_81.patients_document_assemblypda_status
_81.patients_handoutsphs_status
_81.patients_handoutsphs_review_status
_81.patients_icd9_problemspip_status
_81.patients_icd9_problemspip_cog_status
_81.patients_icd9_problemspip_func_status
_81.patients_referralspref_referral_status
_81.patients_reminderspr_status
_81.patients_responsibility_estimatesprest_status
_81.patients_smoking_statuspss_status
_81.patients_statementspst_status
_81.precertspre_maritial_status
_81.precertspre_employer_status
_81.problems_listspl_status
_81.radiology_ordersrad_status
_81.radiology_resultsrad_res_status
_81.radiology_results_test_codes_resultsrrtcres_status
_81.taskstask_status
_999.appointment_reminders_configurationsarcon_status
_999.appointments_requestsaptreq_status
_999.billing_reports_queuebrq_status
_999.chartschrt_status
_999.chartschrt_marital_status
_999.charts_care_planccp_referral_status
_999.charts_icd9_codescic_status
_999.clinical_interventionsci_marital_status
_999.cpoe_responsescpoe_res_status
_999.encountersenc_maritial_status
_999.encountersenc_employer_status
_999.encountersenc_ins1_tpl_status
_999.encountersenc_ins2_tpl_status
_999.encounters_claims_filesecf_status
_999.encounters_paymentsepay_status
_999.encounters_payments_edi_logsepel_status
_999.encounters_soapesp_pss_status
_999.encounters_ub04enc_ub04_17_status
_999.erx_notificationserx_nots_status
_999.hl7_accessionsacc_status
_999.hl7_ordersord_status
_999.hl7_resultsres_status
_999.immunization_reportedimrp_status
_999.insurancesins_status
_999.ordersord_status
_999.orders_templatesordt_status
_999.patientspat_maritial_status
_999.patientspat_employer_status
_999.patients_allergiespalg_status
_999.patients_demographics_snapshotspds_maritial_status
_999.patients_demographics_snapshotspds_employer_status
_999.patients_document_assemblypda_status
_999.patients_handoutsphs_status
_999.patients_handoutsphs_review_status
_999.patients_icd9_problemspip_status
_999.patients_icd9_problemspip_cog_status
_999.patients_icd9_problemspip_func_status
_999.patients_referralspref_referral_status
_999.patients_reminderspr_status
_999.patients_responsibility_estimatesprest_status
_999.patients_smoking_statuspss_status
_999.patients_statementspst_status
_999.precertspre_maritial_status
_999.precertspre_employer_status
_999.problems_listspl_status
_999.radiology_ordersrad_status
_999.radiology_resultsrad_res_status
_999.radiology_results_test_codes_resultsrrtcres_status
_999.taskstask_status
ahiWiki.uploadstashus_status
aurora_standard.abmmpiemp_status
aurora_standard.abmvisbilling_status
aurora_standard.acampiwork_status
aurora_standard.activity_logsexit_status
aurora_standard.adjpaypat_status
aurora_standard.adshmdpat_status
aurora_standard.adshpmtpat_status
aurora_standard.adshpmtclaim_status
aurora_standard.adshrevpat_status
aurora_standard.ainsrvwpat_status
aurora_standard.amcbdpat_status
aurora_standard.apsaradm_status
aurora_standard.apsar0adm_status
aurora_standard.apsarbdadm_status
aurora_standard.apsarhistadm_status
aurora_standard.audpadjdpat_status
aurora_standard.audpadjdbill_status
aurora_standard.audpchgdpat_status
aurora_standard.audpchgdbill_status
aurora_standard.audppaydpat_status
aurora_standard.audppaydbill_status
aurora_standard.audroomdpat_status
aurora_standard.avtotspat_status
aurora_standard.b2mrdrp_status
aurora_standard.bhguaremp_status
aurora_standard.bhmrdrp_status
aurora_standard.bhtguaremp_status
aurora_standard.bhtmrdrp_status
aurora_standard.bsinsurmarital_status
aurora_standard.c7absabs_status
aurora_standard.cadrgabs_status
aurora_standard.campimarital_status
aurora_standard.catotspat_status
aurora_standard.cgrreptrrpt_status
aurora_standard.cgscliprclip_status
aurora_standard.cgxsselrsel_status
aurora_standard.chhl7adtpat_status
aurora_standard.chm1500dbill_status
aurora_standard.chm1500rbill_status
aurora_standard.chm15chdbill_status
aurora_standard.chm835pdclaim_status
aurora_standard.chmabstrabs_status
aurora_standard.chmabstrrelease_status
aurora_standard.chmabstrmarital_status
aurora_standard.chmachgdpat_status
aurora_standard.chmachgdbill_status
aurora_standard.chmadmddpat_status
aurora_standard.chmadmtrpat_status
aurora_standard.chmadmtrbill_status
aurora_standard.chmadmwclegal_status
aurora_standard.chmagesdpat_status
aurora_standard.chmapcbrapc_status
aurora_standard.chmapcgrbill_status
aurora_standard.chmapcirapc_status
aurora_standard.chmarbexpat_status
aurora_standard.chmarbexdis_status
aurora_standard.chmarchrpat_status
aurora_standard.chmarsipat_status
aurora_standard.chmarsidis_status
aurora_standard.chmarstippat_status
aurora_standard.chmarstppat_status
aurora_standard.chmazstddis_status
aurora_standard.chmazstidis_status
aurora_standard.chmazstodis_status
aurora_standard.chmbadjdpat_status
aurora_standard.chmbadjdbill_status
aurora_standard.chmbadjrbatch_status
aurora_standard.chmbatexdis_status
aurora_standard.chmbchgdpat_status
aurora_standard.chmbchgdbill_status
aurora_standard.chmbchgrbatch_status
aurora_standard.chmbillcpat_status
aurora_standard.chmbilleaction_status
aurora_standard.chmbitmdpat_status
aurora_standard.chmbitmdbill_status
aurora_standard.chmbitmrbatch_status
aurora_standard.chmblogdbill_status
aurora_standard.chmblogrbatch_status
aurora_standard.chmbpaydpat_status
aurora_standard.chmbpaydbill_status
aurora_standard.chmbpayrbatch_status
aurora_standard.chmbremdbill_status
aurora_standard.chmbremrbatch_status
aurora_standard.chmcampipat_status
aurora_standard.chmcampidis_status
aurora_standard.chmclaimdis_status
aurora_standard.chmcompdpat_status
aurora_standard.chmcox06pat_status
aurora_standard.chmcptcdbill_status
aurora_standard.chmdietdcur_status
aurora_standard.chmedilrfa_status
aurora_standard.chmexmpipat_status
aurora_standard.chmexmpidis_status
aurora_standard.chmexvispat_status
aurora_standard.chmexvisdis_status
aurora_standard.chmgltcda_pat_status
aurora_standard.chmgltcdb_pat_status
aurora_standard.chmhcahpdis_status
aurora_standard.chmhcaphpat_status
aurora_standard.chmhcaphdis_status
aurora_standard.chmhcapspat_status
aurora_standard.chmhcapsdis_status
aurora_standard.chmhidicmarital_status
aurora_standard.chmhipadhipaa_status
aurora_standard.chmhistdpat_status
aurora_standard.chmhstmrdis_status
aurora_standard.chmhstrmdis_status
aurora_standard.chmlastrdis_status
aurora_standard.chmmashrpt_status
aurora_standard.chmmbc55medicare_status
aurora_standard.chmmhastdis_status
aurora_standard.chmmhasthomeless_status
aurora_standard.chmmhbcrmedicare_status
aurora_standard.chmmichrmedicare_status
aurora_standard.chmmichrdischarge_status
aurora_standard.chmnbcgrbatch_status
aurora_standard.chmnbpyrbatch_status
aurora_standard.chmnrcexdis_status
aurora_standard.chmnvstbdis_status
aurora_standard.chmnvstrdis_status
aurora_standard.chmokipddischg_status
aurora_standard.chmokopddischg_status
aurora_standard.chmpadjdpat_status
aurora_standard.chmpadjdbill_status
aurora_standard.chmpadmradm_status
aurora_standard.chmpatircurr_status
aurora_standard.chmpatmrmarital_status
aurora_standard.chmpchgdpat_status
aurora_standard.chmpchgdbill_status
aurora_standard.chmpdemopat_status
aurora_standard.chmpdemodis_status
aurora_standard.chmphynepat_status
aurora_standard.chmplogdbill_status
aurora_standard.chmpnotralert_status
aurora_standard.chmppaydpat_status
aurora_standard.chmppaydbill_status
aurora_standard.chmpreadbill_status
aurora_standard.chmpreadpa_status
aurora_standard.chmprebcpat_status
aurora_standard.chmpresspat_status
aurora_standard.chmpricaprev_pat_status
aurora_standard.chmpricacur_pat_status
aurora_standard.chmpricxpat_status
aurora_standard.chmradexpat_status
aurora_standard.chmradexdis_status
aurora_standard.chmrchgdpat_status
aurora_standard.chmrchgdbill_status
aurora_standard.chmrefndpat_status
aurora_standard.chmreqdfpat_status
aurora_standard.chmroomdpat_status
aurora_standard.chmtbtrrbatch_status
aurora_standard.chmtkl1dpat_status
aurora_standard.chmtkl2dpat_status
aurora_standard.chmtkl3dpat_status
aurora_standard.chmtkl4dpat_status
aurora_standard.chmtkl5dpat_status
aurora_standard.chmtkl6dpat_status
aurora_standard.chmtkl7dpat_status
aurora_standard.chmtkl8dpat_status
aurora_standard.chmtkl9dpat_status
aurora_standard.chmtxstrdis_status
aurora_standard.chmutah7dischg_status
aurora_standard.chmutahadischg_status
aurora_standard.chmvisivpat_status
aurora_standard.chmvtotdpat_status
aurora_standard.choordmdorder_status
aurora_standard.chpcemprempl_status
aurora_standard.chpempirpolicy_status
aurora_standard.chppersrempl_status
aurora_standard.chpposcdpos_status
aurora_standard.chpposddpos_status
aurora_standard.chrhhmprpt_status
aurora_standard.chrordrrpt_status
aurora_standard.chtemplrcurrent_status
aurora_standard.chtstatdempl_status
aurora_standard.chxexamdpat_status
aurora_standard.chxexamrpat_status
aurora_standard.chxleasdpat_status
aurora_standard.chyresprpat_status
aurora_standard.cofybalpat_status
aurora_standard.hhmadmtrpat_status
aurora_standard.hhmadmtrbill_status
aurora_standard.hl7in2job_status
aurora_standard.hl7orcorder_status
aurora_standard.logdetldpat_status
aurora_standard.ncexmpipat_status
aurora_standard.oebatchaudpat_status
aurora_standard.oebatchaudbill_status
aurora_standard.oeorderorder_status
aurora_standard.schapptmastrappt_status
aurora_standard.schappttemprappt_status
aurora_standard.stfactvdact_status
aurora_standard.stfactvvact_status
aurora_standard.stoordreorder_status
aurora_standard.stppytortax_status
aurora_standard.stuordrepo_status
aurora_standard.sturqsterequest_status
aurora_standard.styemplrempl_status
aurora_standard.stypacadpy_empl_status
aurora_standard.stypacadper_empl_status
aurora_standard.stytyperempl_status
aurora_standard.tmp04dpat_status
common.clients_zuora_physicians_configczp_employ_status
common.data_import_clients_meta_datadicmd_status
common.dev_requestsdev_status
common.leadslea_status
common.loinc_codeslc_status
common.service_ticketsstc_status
common.sfaxessfax_status
common.support_threadsspt_status
common.vaccinesvac_status
common.vaccines_manufacturersmvx_status
rcmroi.dev__ip_geocodesmaster_status
rcmroi.dev__rcm_roi_resultsmaster_status
rcmroi.dev__sf_tokensmaster_status
rcmroi.dev__sf_usersmaster_status
rcmroi.dev__sobj_Accountmaster_status
rcmroi.dev__sobj_Contactmaster_status
rcmroi.dev__sobj_Leadmaster_status
rcmroi.dev__sobj_RCM_Analysis__cmaster_status
rcmroi.dev__specialtiesmaster_status
rcmroi.dev__zip_codesmaster_status
rcmroi.prod__ip_geocodesmaster_status
rcmroi.prod__rcm_roi_resultsmaster_status
rcmroi.prod__sf_tokensmaster_status
rcmroi.prod__sf_usersmaster_status
rcmroi.prod__sobj_Accountmaster_status
rcmroi.prod__sobj_Contactmaster_status
rcmroi.prod__sobj_Leadmaster_status
rcmroi.prod__sobj_RCM_Analysis__cmaster_status
rcmroi.prod__specialtiesmaster_status
rcmroi.prod__zip_codesmaster_status
rcmroi.test__ip_geocodesmaster_status
rcmroi.test__rcm_roi_resultsmaster_status
rcmroi.test__sf_tokensmaster_status
rcmroi.test__sf_usersmaster_status
rcmroi.test__sobj_Accountmaster_status
rcmroi.test__sobj_Contactmaster_status
rcmroi.test__sobj_Leadmaster_status
rcmroi.test__sobj_RCM_Analysis__cmaster_status
rcmroi.test__specialtiesmaster_status
rcmroi.test__zip_codesmaster_status
template_library.encounters_soap_templatesest_status
template_library.orders_templatesordt_status
xlnt.jira_issuesjira_status
xlnt.loghttp_status
dose
TableColumn
_1.charts_medicationscm_dose
_1.patients_medicationspms_dose
_1.patients_prescriptionsprx_dose
_1188.charts_medicationscm_dose
_1188.patients_medicationspms_dose
_1188.patients_prescriptionsprx_dose
_1218.charts_medicationscm_dose
_1218.patients_medicationspms_dose
_1218.patients_prescriptionsprx_dose
_1548.charts_medicationscm_dose
_1548.patients_medicationspms_dose
_1548.patients_prescriptionsprx_dose
_435.charts_medicationscm_dose
_435.patients_medicationspms_dose
_435.patients_prescriptionsprx_dose
_436.charts_medicationscm_dose
_436.patients_medicationspms_dose
_436.patients_prescriptionsprx_dose
_436_archive_testing.charts_medicationscm_dose
_436_archive_testing.patients_medicationspms_dose
_436_archive_testing.patients_prescriptionsprx_dose
_437.charts_medicationscm_dose
_437.patients_medicationspms_dose
_437.patients_prescriptionsprx_dose
_8.charts_medicationscm_dose
_8.patients_medicationspms_dose
_8.patients_prescriptionsprx_dose
_81.charts_medicationscm_dose
_81.patients_medicationspms_dose
_81.patients_prescriptionsprx_dose
_999.charts_medicationscm_dose
_999.patients_medicationspms_dose
_999.patients_prescriptionsprx_dose
aurora_standard.chrdrugcunit_dose
aurora_standard.chrdrugcdefault_dose
aurora_standard.chrordrrhrs_per_dose
comment
TableColumn
_1.orders_commentsorc_comment
_1.orders_comments_templatesorct_comment
_1.precerts_commentsprc_comment
_1.radiology_order_notesradnot_comment
_1188.orders_commentsorc_comment
_1188.orders_comments_templatesorct_comment
_1188.precerts_commentsprc_comment
_1188.radiology_order_notesradnot_comment
_1218.orders_commentsorc_comment
_1218.orders_comments_templatesorct_comment
_1218.precerts_commentsprc_comment
_1218.radiology_order_notesradnot_comment
_1548.orders_commentsorc_comment
_1548.orders_comments_templatesorct_comment
_1548.precerts_commentsprc_comment
_1548.radiology_order_notesradnot_comment
_435.orders_commentsorc_comment
_435.orders_comments_templatesorct_comment
_435.precerts_commentsprc_comment
_435.radiology_order_notesradnot_comment
_436.orders_commentsorc_comment
_436.orders_comments_templatesorct_comment
_436.precerts_commentsprc_comment
_436.radiology_order_notesradnot_comment
_436_archive_testing.orders_commentsorc_comment
_436_archive_testing.orders_comments_templatesorct_comment
_436_archive_testing.precerts_commentsprc_comment
_436_archive_testing.radiology_order_notesradnot_comment
_437.orders_commentsorc_comment
_437.orders_comments_templatesorct_comment
_437.precerts_commentsprc_comment
_437.radiology_order_notesradnot_comment
_8.orders_commentsorc_comment
_8.orders_comments_templatesorct_comment
_8.precerts_commentsprc_comment
_8.radiology_order_notesradnot_comment
_81.orders_commentsorc_comment
_81.orders_comments_templatesorct_comment
_81.precerts_commentsprc_comment
_81.radiology_order_notesradnot_comment
_999.orders_commentsorc_comment
_999.orders_comments_templatesorct_comment
_999.precerts_commentsprc_comment
_999.radiology_order_notesradnot_comment
ahiWiki.archivear_comment
ahiWiki.logginglog_comment
ahiWiki.recentchangesrc_comment
ahiWiki.revisionrev_comment
aurora_standard.audppayddenial_comment
aurora_standard.chmabstrstatus_comment
aurora_standard.chmblogddenial_comment
aurora_standard.chmbremddenial_comment
aurora_standard.chmmcqudemp_comment
aurora_standard.chmmcqudsp_emp_comment
aurora_standard.chmozpcdacct_comment
aurora_standard.chmppayddenial_comment
aurora_standard.chpevaldreviewer_comment
aurora_standard.hl7ntesrc_comment
aurora_standard.hl7nteadsrc_comment
common.service_tickets_commentsstcp_comment
template_library.orders_comments_templatesorct_comment
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
item_no
TableColumn
aurora_standard.chmpintrrx_item_no