aurora_standard.chmemrxd

Field Type Null Default Key Extra Comment
empl_code varchar(6) YES MUL
rx_date date YES
seq_no smallint(6) YES
patient_last varchar(20) YES
patient_first varchar(20) YES
patient_mid varchar(10) YES
rx_no int(11) YES
drug_strength varchar(30) YES
no_dispensed varchar(20) YES
ndc varchar(14) YES
phys_name varchar(30) YES
days_supply varchar(10) YES
price_charged decimal(10,2) YES
paid varchar(1) YES
print_flag varchar(1) YES
source varchar(6) YES
sales_tax decimal(8,2) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
source
TableColumn
Loinc.loinc_codeslc_source
Loinc.loinc_codes_sourcelcsrc_source
_1.encounters_ub04enc_ub04_15_source
_1.hl7_ordersord_specimen_source
_1.immunizationsimz_funding_source
_1.ordersord_source
_1.orders_templatesordt_source
_1.patient_portal_requestsppr_source
_1.patients_education_resultsperes_source
_1.patients_immunizationspim_funding_source
_1.pre_services_line_adjustmentsprestsla_source
_1.radiology_ordersrad_source
_1.referral_sourcesref_source
_1188.encounters_ub04enc_ub04_15_source
_1188.hl7_ordersord_specimen_source
_1188.immunizationsimz_funding_source
_1188.ordersord_source
_1188.orders_templatesordt_source
_1188.patient_portal_requestsppr_source
_1188.patients_education_resultsperes_source
_1188.patients_immunizationspim_funding_source
_1188.pre_services_line_adjustmentsprestsla_source
_1188.radiology_ordersrad_source
_1188.referral_sourcesref_source
_1218.encounters_ub04enc_ub04_15_source
_1218.hl7_ordersord_specimen_source
_1218.immunizationsimz_funding_source
_1218.ordersord_source
_1218.orders_templatesordt_source
_1218.patient_portal_requestsppr_source
_1218.patients_education_resultsperes_source
_1218.patients_immunizationspim_funding_source
_1218.pre_services_line_adjustmentsprestsla_source
_1218.radiology_ordersrad_source
_1218.referral_sourcesref_source
_1548.encounters_ub04enc_ub04_15_source
_1548.hl7_ordersord_specimen_source
_1548.immunizationsimz_funding_source
_1548.ordersord_source
_1548.orders_templatesordt_source
_1548.patient_portal_requestsppr_source
_1548.patients_education_resultsperes_source
_1548.patients_immunizationspim_funding_source
_1548.pre_services_line_adjustmentsprestsla_source
_1548.radiology_ordersrad_source
_1548.referral_sourcesref_source
_435.encounters_ub04enc_ub04_15_source
_435.hl7_ordersord_specimen_source
_435.immunizationsimz_funding_source
_435.ordersord_source
_435.orders_templatesordt_source
_435.patient_portal_requestsppr_source
_435.patients_education_resultsperes_source
_435.patients_immunizationspim_funding_source
_435.pre_services_line_adjustmentsprestsla_source
_435.radiology_ordersrad_source
_435.referral_sourcesref_source
_436.encounters_ub04enc_ub04_15_source
_436.hl7_ordersord_specimen_source
_436.immunizationsimz_funding_source
_436.ordersord_source
_436.orders_templatesordt_source
_436.patient_portal_requestsppr_source
_436.patients_education_resultsperes_source
_436.patients_immunizationspim_funding_source
_436.pre_services_line_adjustmentsprestsla_source
_436.radiology_ordersrad_source
_436.referral_sourcesref_source
_436_archive_testing.encounters_ub04enc_ub04_15_source
_436_archive_testing.hl7_ordersord_specimen_source
_436_archive_testing.immunizationsimz_funding_source
_436_archive_testing.ordersord_source
_436_archive_testing.orders_templatesordt_source
_436_archive_testing.patient_portal_requestsppr_source
_436_archive_testing.patients_education_resultsperes_source
_436_archive_testing.patients_immunizationspim_funding_source
_436_archive_testing.pre_services_line_adjustmentsprestsla_source
_436_archive_testing.radiology_ordersrad_source
_436_archive_testing.referral_sourcesref_source
_437.encounters_ub04enc_ub04_15_source
_437.hl7_ordersord_specimen_source
_437.immunizationsimz_funding_source
_437.ordersord_source
_437.orders_templatesordt_source
_437.patient_portal_requestsppr_source
_437.patients_education_resultsperes_source
_437.patients_immunizationspim_funding_source
_437.pre_services_line_adjustmentsprestsla_source
_437.radiology_ordersrad_source
_437.referral_sourcesref_source
_8.encounters_ub04enc_ub04_15_source
_8.hl7_ordersord_specimen_source
_8.immunizationsimz_funding_source
_8.ordersord_source
_8.orders_templatesordt_source
_8.patient_portal_requestsppr_source
_8.patients_education_resultsperes_source
_8.patients_immunizationspim_funding_source
_8.pre_services_line_adjustmentsprestsla_source
_8.radiology_ordersrad_source
_8.referral_sourcesref_source
_81.encounters_ub04enc_ub04_15_source
_81.hl7_ordersord_specimen_source
_81.immunizationsimz_funding_source
_81.ordersord_source
_81.orders_templatesordt_source
_81.patient_portal_requestsppr_source
_81.patients_education_resultsperes_source
_81.patients_immunizationspim_funding_source
_81.pre_services_line_adjustmentsprestsla_source
_81.radiology_ordersrad_source
_81.referral_sourcesref_source
_999.encounters_ub04enc_ub04_15_source
_999.hl7_ordersord_specimen_source
_999.immunizationsimz_funding_source
_999.ordersord_source
_999.orders_templatesordt_source
_999.patient_portal_requestsppr_source
_999.patients_education_resultsperes_source
_999.patients_immunizationspim_funding_source
_999.pre_services_line_adjustmentsprestsla_source
_999.radiology_ordersrad_source
_999.referral_sourcesref_source
ahiWiki.recentchangesrc_source
ahiWiki.sitessite_source
aurora_standard.chm1500rpayor_source
aurora_standard.chmabstrgrp_source
aurora_standard.chmdrgccgrp_source
aurora_standard.chmedilrpayor_source
aurora_standard.chmfcglcgrp_source
aurora_standard.chmgrprcgrp_source
aurora_standard.chmmdcccgrp_source
aurora_standard.chmmrhdrget_grp_source
aurora_standard.chmpysrcpay_source
aurora_standard.chmpysrcgrp_source
aurora_standard.chmvrsncgrp_source
aurora_standard.chpvacidvac_phy_source
aurora_standard.chpvacscvac_source
aurora_standard.chqletrdletter_source
aurora_standard.chtclokdtrans_source
aurora_standard.hhtclokdtrans_source
aurora_standard.hl7in2policy_source
aurora_standard.timetabltrans_source
aurora_standard.tmpmrrptclaim_source
aurora_standard.workdrggrp_source
common.loinc_codeslc_source
template_library.orders_templatesordt_source
ndc
TableColumn
_1.charts_cpt_codeschcp_ndc
_1.configured_encounters_templates_cpt_codescetcc_ndc
_1.encounters_cpt_codesecp_ndc
_1.encounters_cpt_codes_templatesecpt_ndc
_1.immunizationsimz_ndc
_1188.charts_cpt_codeschcp_ndc
_1188.configured_encounters_templates_cpt_codescetcc_ndc
_1188.encounters_cpt_codesecp_ndc
_1188.encounters_cpt_codes_templatesecpt_ndc
_1188.immunizationsimz_ndc
_1218.charts_cpt_codeschcp_ndc
_1218.configured_encounters_templates_cpt_codescetcc_ndc
_1218.encounters_cpt_codesecp_ndc
_1218.encounters_cpt_codes_templatesecpt_ndc
_1218.immunizationsimz_ndc
_1548.charts_cpt_codeschcp_ndc
_1548.configured_encounters_templates_cpt_codescetcc_ndc
_1548.encounters_cpt_codesecp_ndc
_1548.encounters_cpt_codes_templatesecpt_ndc
_1548.immunizationsimz_ndc
_435.charts_cpt_codeschcp_ndc
_435.configured_encounters_templates_cpt_codescetcc_ndc
_435.encounters_cpt_codesecp_ndc
_435.encounters_cpt_codes_templatesecpt_ndc
_435.immunizationsimz_ndc
_436.charts_cpt_codeschcp_ndc
_436.configured_encounters_templates_cpt_codescetcc_ndc
_436.encounters_cpt_codesecp_ndc
_436.encounters_cpt_codes_templatesecpt_ndc
_436.immunizationsimz_ndc
_436_archive_testing.charts_cpt_codeschcp_ndc
_436_archive_testing.configured_encounters_templates_cpt_codescetcc_ndc
_436_archive_testing.encounters_cpt_codesecp_ndc
_436_archive_testing.encounters_cpt_codes_templatesecpt_ndc
_436_archive_testing.immunizationsimz_ndc
_437.charts_cpt_codeschcp_ndc
_437.configured_encounters_templates_cpt_codescetcc_ndc
_437.encounters_cpt_codesecp_ndc
_437.encounters_cpt_codes_templatesecpt_ndc
_437.immunizationsimz_ndc
_8.charts_cpt_codeschcp_ndc
_8.configured_encounters_templates_cpt_codescetcc_ndc
_8.encounters_cpt_codesecp_ndc
_8.encounters_cpt_codes_templatesecpt_ndc
_8.immunizationsimz_ndc
_81.charts_cpt_codeschcp_ndc
_81.configured_encounters_templates_cpt_codescetcc_ndc
_81.encounters_cpt_codesecp_ndc
_81.encounters_cpt_codes_templatesecpt_ndc
_81.immunizationsimz_ndc
_999.charts_cpt_codeschcp_ndc
_999.configured_encounters_templates_cpt_codescetcc_ndc
_999.encounters_cpt_codesecp_ndc
_999.encounters_cpt_codes_templatesecpt_ndc
_999.immunizationsimz_ndc
template_library.encounters_cpt_codes_templatesecpt_ndc
paid
TableColumn
_1.encounters_payments_edi_logsepel_prov_paid
_1188.encounters_payments_edi_logsepel_prov_paid
_1218.encounters_payments_edi_logsepel_prov_paid
_1548.encounters_payments_edi_logsepel_prov_paid
_435.encounters_payments_edi_logsepel_prov_paid
_437.encounters_payments_edi_logsepel_prov_paid
_8.encounters_payments_edi_logsepel_prov_paid
_81.encounters_payments_edi_logsepel_prov_paid
_999.encounters_payments_edi_logsepel_prov_paid
aurora_standard.chm1500ramt_paid
aurora_standard.chmblogdother_payor_paid
aurora_standard.chmmbc40misc_dte_amt_paid
aurora_standard.chmplogdother_payor_paid
aurora_standard.chmquesrgovt_paid
aurora_standard.logdetldother_payor_paid
aurora_standard.stpapckvinvoice_no_paid
seq_no
TableColumn
aurora_standard.chmarstarec_seq_no
aurora_standard.chmarstacrec_seq_no
aurora_standard.chmarstairec_seq_no
aurora_standard.chmarstdrec_seq_no
aurora_standard.chmarstdirec_seq_no
aurora_standard.chmarsterec_seq_no
aurora_standard.chmarsthrec_seq_no
aurora_standard.chmarsthirec_seq_no
aurora_standard.chmarstphrec_seq_no
aurora_standard.chmarstpirec_seq_no
aurora_standard.chmarstporec_seq_no
aurora_standard.chmarstpqrec_seq_no
aurora_standard.chmarstprrec_seq_no
aurora_standard.chmarstpsrec_seq_no
aurora_standard.chmarstptrec_seq_no
aurora_standard.chmarstpyrec_seq_no
aurora_standard.chmcostarec_seq_no
aurora_standard.chmcostbrec_seq_no
aurora_standard.chmcostdrec_seq_no
aurora_standard.chmcostrcrec_seq_no
aurora_standard.chmgltcda_seq_no
aurora_standard.chmgltcdb_seq_no
aurora_standard.chmhid4arec_seq_no
aurora_standard.chmhid4brec_seq_no
aurora_standard.chmhid4crec_seq_no
aurora_standard.chmhid4drec_seq_no
aurora_standard.chmhid4grec_seq_no
aurora_standard.chrhhdcclisting_seq_no
aurora_standard.chrhhmprlisting_seq_no
aurora_standard.chrhhndclisting_seq_no
aurora_standard.chrhhndcfirm_seq_no
aurora_standard.chrhhroclisting_seq_no
aurora_standard.chrmndclisting_seq_no
aurora_standard.chrmndcfirm_seq_no
aurora_standard.chxhistdh_seq_no
aurora_standard.chyhistdh_seq_no
aurora_standard.drugclaslisting_seq_no
aurora_standard.formulatlisting_seq_no
aurora_standard.listingslisting_seq_no
aurora_standard.listingsfirm_seq_no
aurora_standard.packagelisting_seq_no
aurora_standard.routeslisting_seq_no
empl_code
TableColumn
aurora_standard.chtsupvcsupv_empl_code
aurora_standard.stypddrdadj_empl_code