aurora_standard.logchrgd

Field Type Null Default Key Extra Comment
visit_no int(11) YES MUL
which_log varchar(2) YES
bill_id varchar(3) YES
total_chgs decimal(10,2) YES
remit_id varchar(10) YES
anes_crna decimal(10,2) YES
blood_adm decimal(10,2) YES
rm_pvt decimal(10,2) YES
emerg_rm decimal(10,2) YES
ultra decimal(10,2) YES
lab_fee_sc decimal(10,2) YES
other_diag decimal(10,2) YES
ct_scan decimal(10,2) YES
lab decimal(10,2) YES
ambulance decimal(10,2) YES
eeg decimal(10,2) YES
med_sup decimal(10,2) YES
ech decimal(10,2) YES
hltr_mon decimal(10,2) YES
obs decimal(10,2) YES
card_mon decimal(10,2) YES
selfadm_dg decimal(10,2) YES
or decimal(10,2) YES
ekg decimal(10,2) YES
deliv_room decimal(10,2) YES
pharmacy decimal(10,2) YES
pt decimal(10,2) YES
xray decimal(10,2) YES
rec_room decimal(10,2) YES
resp_svc decimal(10,2) YES
iv_sol decimal(10,2) YES
rm_semipvt decimal(10,2) YES
wound_clin decimal(10,2) YES
speech decimal(10,2) YES
treatment decimal(10,2) YES
amb_sur decimal(10,2) YES
nursery_rm decimal(10,2) YES
ot decimal(10,2) YES
vaccine decimal(10,2) YES
pro_fees decimal(10,2) YES
nuclear_md decimal(10,2) YES
occ_thy decimal(10,2) YES
mri decimal(10,2) YES
other decimal(10,2) YES
mammogram decimal(10,2) YES
card_rehab decimal(10,2) YES
intra_lens decimal(10,2) YES
stress_tst decimal(10,2) YES
pediatrics decimal(10,2) YES
ob_room decimal(10,2) YES
blood decimal(10,2) YES
rural_cl decimal(10,2) YES
extra48 decimal(10,2) YES
extra49 decimal(10,2) YES
extra50 decimal(10,2) YES
extra51 decimal(10,2) YES
extra52 decimal(10,2) YES
extra53 decimal(10,2) YES
extra54 decimal(10,2) YES
extra55 decimal(10,2) YES
extra56 decimal(10,2) YES
extra57 decimal(10,2) YES
extra58 decimal(10,2) YES
extra59 decimal(10,2) YES
extra60 decimal(10,2) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
ot
TableColumn
Azalea.employeesemp_ot
_1.chartschrt_phone_other
_1.charts_medicationscm_dose_other
_1.encountersenc_phone_other
_1.inventoryinv_administered_location_other
_1.inventoryinv_administered_route_other
_1.orders_papsopap_hyst_other
_1.orders_papsopap_collected_by_other
_1.orders_paps_historyopaph_hyst_other
_1.patientspat_phone_other
_1.patients_demographics_snapshotspds_phone_other
_1.patients_inventorypinv_administered_route_other
_1.patients_inventorypinv_administered_location_other
_1.patients_medicationspms_dose_other
_1.patients_prescriptionsprx_dose_other
_1.poapoa_relation_other
_1.precertspre_phone_other
_1188.chartschrt_phone_other
_1188.charts_medicationscm_dose_other
_1188.encountersenc_phone_other
_1188.inventoryinv_administered_location_other
_1188.inventoryinv_administered_route_other
_1188.orders_papsopap_hyst_other
_1188.orders_papsopap_collected_by_other
_1188.orders_paps_historyopaph_hyst_other
_1188.patientspat_phone_other
_1188.patients_demographics_snapshotspds_phone_other
_1188.patients_inventorypinv_administered_route_other
_1188.patients_inventorypinv_administered_location_other
_1188.patients_medicationspms_dose_other
_1188.patients_prescriptionsprx_dose_other
_1188.poapoa_relation_other
_1188.precertspre_phone_other
_1218.chartschrt_phone_other
_1218.charts_medicationscm_dose_other
_1218.encountersenc_phone_other
_1218.inventoryinv_administered_location_other
_1218.inventoryinv_administered_route_other
_1218.orders_papsopap_hyst_other
_1218.orders_papsopap_collected_by_other
_1218.orders_paps_historyopaph_hyst_other
_1218.patientspat_phone_other
_1218.patients_demographics_snapshotspds_phone_other
_1218.patients_inventorypinv_administered_route_other
_1218.patients_inventorypinv_administered_location_other
_1218.patients_medicationspms_dose_other
_1218.patients_prescriptionsprx_dose_other
_1218.poapoa_relation_other
_1218.precertspre_phone_other
_1548.chartschrt_phone_other
_1548.charts_medicationscm_dose_other
_1548.encountersenc_phone_other
_1548.inventoryinv_administered_location_other
_1548.inventoryinv_administered_route_other
_1548.orders_papsopap_hyst_other
_1548.orders_papsopap_collected_by_other
_1548.orders_paps_historyopaph_hyst_other
_1548.patientspat_phone_other
_1548.patients_demographics_snapshotspds_phone_other
_1548.patients_inventorypinv_administered_route_other
_1548.patients_inventorypinv_administered_location_other
_1548.patients_medicationspms_dose_other
_1548.patients_prescriptionsprx_dose_other
_1548.poapoa_relation_other
_1548.precertspre_phone_other
_435.chartschrt_phone_other
_435.charts_medicationscm_dose_other
_435.encountersenc_phone_other
_435.inventoryinv_administered_location_other
_435.inventoryinv_administered_route_other
_435.orders_papsopap_hyst_other
_435.orders_papsopap_collected_by_other
_435.orders_paps_historyopaph_hyst_other
_435.patientspat_phone_other
_435.patients_demographics_snapshotspds_phone_other
_435.patients_inventorypinv_administered_route_other
_435.patients_inventorypinv_administered_location_other
_435.patients_medicationspms_dose_other
_435.patients_prescriptionsprx_dose_other
_435.poapoa_relation_other
_435.precertspre_phone_other
_436.chartschrt_phone_other
_436.charts_medicationscm_dose_other
_436.encountersenc_phone_other
_436.inventoryinv_administered_location_other
_436.inventoryinv_administered_route_other
_436.orders_papsopap_hyst_other
_436.orders_papsopap_collected_by_other
_436.orders_paps_historyopaph_hyst_other
_436.patientspat_phone_other
_436.patients_demographics_snapshotspds_phone_other
_436.patients_inventorypinv_administered_route_other
_436.patients_inventorypinv_administered_location_other
_436.patients_medicationspms_dose_other
_436.patients_prescriptionsprx_dose_other
_436.poapoa_relation_other
_436.precertspre_phone_other
_436_archive_testing.chartschrt_phone_other
_436_archive_testing.charts_medicationscm_dose_other
_436_archive_testing.encountersenc_phone_other
_436_archive_testing.inventoryinv_administered_location_other
_436_archive_testing.inventoryinv_administered_route_other
_436_archive_testing.orders_papsopap_hyst_other
_436_archive_testing.orders_papsopap_collected_by_other
_436_archive_testing.orders_paps_historyopaph_hyst_other
_436_archive_testing.patientspat_phone_other
_436_archive_testing.patients_demographics_snapshotspds_phone_other
_436_archive_testing.patients_inventorypinv_administered_route_other
_436_archive_testing.patients_inventorypinv_administered_location_other
_436_archive_testing.patients_medicationspms_dose_other
_436_archive_testing.patients_prescriptionsprx_dose_other
_436_archive_testing.poapoa_relation_other
_436_archive_testing.precertspre_phone_other
_437.chartschrt_phone_other
_437.charts_medicationscm_dose_other
_437.encountersenc_phone_other
_437.inventoryinv_administered_location_other
_437.inventoryinv_administered_route_other
_437.orders_papsopap_hyst_other
_437.orders_papsopap_collected_by_other
_437.orders_paps_historyopaph_hyst_other
_437.patientspat_phone_other
_437.patients_demographics_snapshotspds_phone_other
_437.patients_inventorypinv_administered_route_other
_437.patients_inventorypinv_administered_location_other
_437.patients_medicationspms_dose_other
_437.patients_prescriptionsprx_dose_other
_437.poapoa_relation_other
_437.precertspre_phone_other
_8.chartschrt_phone_other
_8.charts_medicationscm_dose_other
_8.encountersenc_phone_other
_8.inventoryinv_administered_location_other
_8.inventoryinv_administered_route_other
_8.orders_papsopap_hyst_other
_8.orders_papsopap_collected_by_other
_8.orders_paps_historyopaph_hyst_other
_8.patientspat_phone_other
_8.patients_demographics_snapshotspds_phone_other
_8.patients_inventorypinv_administered_route_other
_8.patients_inventorypinv_administered_location_other
_8.patients_medicationspms_dose_other
_8.patients_prescriptionsprx_dose_other
_8.poapoa_relation_other
_8.precertspre_phone_other
_81.chartschrt_phone_other
_81.charts_medicationscm_dose_other
_81.encountersenc_phone_other
_81.inventoryinv_administered_location_other
_81.inventoryinv_administered_route_other
_81.orders_papsopap_hyst_other
_81.orders_papsopap_collected_by_other
_81.orders_paps_historyopaph_hyst_other
_81.patientspat_phone_other
_81.patients_demographics_snapshotspds_phone_other
_81.patients_inventorypinv_administered_route_other
_81.patients_inventorypinv_administered_location_other
_81.patients_medicationspms_dose_other
_81.patients_prescriptionsprx_dose_other
_81.poapoa_relation_other
_81.precertspre_phone_other
_999.chartschrt_phone_other
_999.charts_medicationscm_dose_other
_999.encountersenc_phone_other
_999.inventoryinv_administered_location_other
_999.inventoryinv_administered_route_other
_999.orders_papsopap_hyst_other
_999.orders_papsopap_collected_by_other
_999.orders_paps_historyopaph_hyst_other
_999.patientspat_phone_other
_999.patients_demographics_snapshotspds_phone_other
_999.patients_inventorypinv_administered_route_other
_999.patients_inventorypinv_administered_location_other
_999.patients_medicationspms_dose_other
_999.patients_prescriptionsprx_dose_other
_999.poapoa_relation_other
_999.precertspre_phone_other
aurora_standard.chhcntrclag_days_other
aurora_standard.chltrnsdhcfa_other
aurora_standard.chmazstdamt_other
aurora_standard.chmazstiamt_other
aurora_standard.chmazstoamt_other
aurora_standard.chmbillcform_other
aurora_standard.chmcntrclag_days_other
aurora_standard.chmmbc50condition_other
aurora_standard.oddpayreded_other
aurora_standard.oddpayreobl_other
aurora_standard.odhpayreded_other
aurora_standard.odhpayreobl_other
aurora_standard.stypayreded_other
aurora_standard.stypayreobl_other
aurora_standard.stystwhrinc_lim_other
aurora_standard.stystwhrstd_other
aurora_standard.stystwhrstd_l_other
aurora_standard.stystwhrprs_other
aurora_standard.stystwhrprs_l_other
aurora_standard.stystwhrdep_other
aurora_standard.stystwhrdep_l_other
aurora_standard.stystwhrtc_other
aurora_standard.stystwhrtc_l_other
aurora_standard.stystwhrnsq_other
aurora_standard.stystwhrnsq_l_other
common.contactscon_phone_other
or
TableColumn
Loinc.loinc_codeslc_order_obs
aurora_standard.chmabstrdeath_or
common.loinc_codeslc_order_obs
common.test_codestco_x_reject_due_to_thawing_or_other
lab
TableColumn
_1.encountersenc_outside_lab
_1.precertspre_outside_lab
_1188.encountersenc_outside_lab
_1188.precertspre_outside_lab
_1218.encountersenc_outside_lab
_1218.precertspre_outside_lab
_1548.encountersenc_outside_lab
_1548.precertspre_outside_lab
_435.encountersenc_outside_lab
_435.precertspre_outside_lab
_436.encountersenc_outside_lab
_436.precertspre_outside_lab
_436_archive_testing.encountersenc_outside_lab
_436_archive_testing.precertspre_outside_lab
_437.encountersenc_outside_lab
_437.precertspre_outside_lab
_8.encountersenc_outside_lab
_8.precertspre_outside_lab
_81.encountersenc_outside_lab
_81.precertspre_outside_lab
_999.encountersenc_outside_lab
_999.precertspre_outside_lab
aurora_standard.chltrandabnorm_lab
common.interfaces_typesit_lab
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
ekg
TableColumn
aurora_standard.aswphyncm_ekg
aurora_standard.aswphyncx_ekg
obs
TableColumn
aurora_standard.chmbenedi_precert_obs
aurora_standard.chmbenedo_precert_obs
aurora_standard.chmibendprecert_obs
pt
TableColumn
aurora_standard.chmub04bf_78_pt
aurora_standard.chmub04bf_79_pt
aurora_standard.chrdrugcmin_reorder_pt
aurora_standard.empldeptft_pt
vaccine
TableColumn
common.vaccinesvac_non_vaccine