aurora_standard.chm15chd

Field Type Null Default Key Extra Comment
visit_no int(11) YES MUL
price_code varchar(10) YES
chg_date date YES
to_date date YES
seq_no smallint(6) YES
pos varchar(2) YES
tos varchar(2) YES
cpt_code varchar(6) YES
modifier_1 varchar(2) YES
modifier_2 varchar(2) YES
modifier_3 varchar(2) YES
modifier_4 varchar(2) YES
modifier_5 varchar(2) YES
diag_seq_1 char(1) YES
diag_seq_2 char(1) YES
diag_seq_3 char(1) YES
diag_seq_4 char(1) YES
pos_1532 varchar(2) YES
amount decimal(10,2) YES
units decimal(4,1) YES
bill_status varchar(3) YES
id_1500 varchar(3) YES
phys_number int(11) YES
clia_ind varchar(1) YES
comment varchar(60) YES
n24c_emg varchar(2) YES
n24h_epsdt varchar(2) YES
n24i_qual varchar(2) YES
n24j_id varchar(17) YES
n24j_npi int(10) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
amount
TableColumn
HSPI_CURES2015_B1.invoice_generation_rule_setsminimum_amount
HSPI_Central_Hospital.invoice_generation_rule_setsminimum_amount
HSPI_Dewitt.invoice_generation_rule_setsminimum_amount
HSPI_Fulton.invoice_generation_rule_setsminimum_amount
HSPI_Inferno.invoice_generation_rule_setsminimum_amount
HSPI_MU2015_E1.invoice_generation_rule_setsminimum_amount
HSPI_MU2015_G2.invoice_generation_rule_setsminimum_amount
HSPI_MU2015_G9.invoice_generation_rule_setsminimum_amount
HSPI_Sandbox.invoice_generation_rule_setsminimum_amount
HSPI_Summit_General.invoice_generation_rule_setsminimum_amount
HSPI_United_Physicians.invoice_generation_rule_setsminimum_amount
MPI.invoice_generation_rule_setsminimum_amount
_1.billing_codesbil_negative_amount
_1.encounters_paymentsepay_amount
_1.encounters_ub04enc_ub04_39_a_amount
_1.encounters_ub04enc_ub04_39_b_amount
_1.encounters_ub04enc_ub04_39_c_amount
_1.encounters_ub04enc_ub04_39_d_amount
_1.encounters_ub04enc_ub04_40_a_amount
_1.encounters_ub04enc_ub04_40_b_amount
_1.encounters_ub04enc_ub04_40_c_amount
_1.encounters_ub04enc_ub04_40_d_amount
_1.encounters_ub04enc_ub04_41_a_amount
_1.encounters_ub04enc_ub04_41_b_amount
_1.encounters_ub04enc_ub04_41_c_amount
_1.encounters_ub04enc_ub04_41_d_amount
_1.insurances_allowables_cpt_mapiacm_amount
_1.insurances_contracted_pricingicp_amount
_1.ledgerled_amount
_1.ledgerled_orig_amount
_1.ledgerled_unit_amount
_1.patient_finance_recordspfr_min_due_amount
_1.patientspat_min_due_amount
_1.patients_immunizationspim_administered_amount
_1.patients_immunizations_templatespimt_administered_amount
_1.patients_inventorypinv_administered_amount
_1.patients_payments_schedulespps_amount
_1.patients_responsibility_estimatesprest_allowed_amount
_1.patients_responsibility_estimates_servicesprests_allowed_amount
_1.pre_services_line_adjustmentsprestsla_amount
_1.voided_paymentsvp_amount
_1.voided_paymentsvp_orig_amount
_1188.billing_codesbil_negative_amount
_1188.encounters_paymentsepay_amount
_1188.encounters_ub04enc_ub04_39_a_amount
_1188.encounters_ub04enc_ub04_39_b_amount
_1188.encounters_ub04enc_ub04_39_c_amount
_1188.encounters_ub04enc_ub04_39_d_amount
_1188.encounters_ub04enc_ub04_40_a_amount
_1188.encounters_ub04enc_ub04_40_b_amount
_1188.encounters_ub04enc_ub04_40_c_amount
_1188.encounters_ub04enc_ub04_40_d_amount
_1188.encounters_ub04enc_ub04_41_a_amount
_1188.encounters_ub04enc_ub04_41_b_amount
_1188.encounters_ub04enc_ub04_41_c_amount
_1188.encounters_ub04enc_ub04_41_d_amount
_1188.insurances_allowables_cpt_mapiacm_amount
_1188.insurances_contracted_pricingicp_amount
_1188.ledgerled_amount
_1188.ledgerled_orig_amount
_1188.ledgerled_unit_amount
_1188.patient_finance_recordspfr_min_due_amount
_1188.patientspat_min_due_amount
_1188.patients_immunizationspim_administered_amount
_1188.patients_immunizations_templatespimt_administered_amount
_1188.patients_inventorypinv_administered_amount
_1188.patients_payments_schedulespps_amount
_1188.patients_responsibility_estimatesprest_allowed_amount
_1188.patients_responsibility_estimates_servicesprests_allowed_amount
_1188.pre_services_line_adjustmentsprestsla_amount
_1188.voided_paymentsvp_amount
_1188.voided_paymentsvp_orig_amount
_1218.billing_codesbil_negative_amount
_1218.encounters_paymentsepay_amount
_1218.encounters_ub04enc_ub04_39_a_amount
_1218.encounters_ub04enc_ub04_39_b_amount
_1218.encounters_ub04enc_ub04_39_c_amount
_1218.encounters_ub04enc_ub04_39_d_amount
_1218.encounters_ub04enc_ub04_40_a_amount
_1218.encounters_ub04enc_ub04_40_b_amount
_1218.encounters_ub04enc_ub04_40_c_amount
_1218.encounters_ub04enc_ub04_40_d_amount
_1218.encounters_ub04enc_ub04_41_a_amount
_1218.encounters_ub04enc_ub04_41_b_amount
_1218.encounters_ub04enc_ub04_41_c_amount
_1218.encounters_ub04enc_ub04_41_d_amount
_1218.insurances_allowables_cpt_mapiacm_amount
_1218.insurances_contracted_pricingicp_amount
_1218.led_temporary_ledger_table_ANMled_amount
_1218.led_temporary_ledger_table_ANMled_orig_amount
_1218.ledgerled_amount
_1218.ledgerled_orig_amount
_1218.ledgerled_unit_amount
_1218.patient_finance_recordspfr_min_due_amount
_1218.patientspat_min_due_amount
_1218.patients_immunizationspim_administered_amount
_1218.patients_immunizations_templatespimt_administered_amount
_1218.patients_inventorypinv_administered_amount
_1218.patients_payments_schedulespps_amount
_1218.patients_responsibility_estimatesprest_allowed_amount
_1218.patients_responsibility_estimates_servicesprests_allowed_amount
_1218.pre_services_line_adjustmentsprestsla_amount
_1218.voided_paymentsvp_amount
_1218.voided_paymentsvp_orig_amount
_1548.billing_codesbil_negative_amount
_1548.encounters_paymentsepay_amount
_1548.encounters_ub04enc_ub04_39_a_amount
_1548.encounters_ub04enc_ub04_39_b_amount
_1548.encounters_ub04enc_ub04_39_c_amount
_1548.encounters_ub04enc_ub04_39_d_amount
_1548.encounters_ub04enc_ub04_40_a_amount
_1548.encounters_ub04enc_ub04_40_b_amount
_1548.encounters_ub04enc_ub04_40_c_amount
_1548.encounters_ub04enc_ub04_40_d_amount
_1548.encounters_ub04enc_ub04_41_a_amount
_1548.encounters_ub04enc_ub04_41_b_amount
_1548.encounters_ub04enc_ub04_41_c_amount
_1548.encounters_ub04enc_ub04_41_d_amount
_1548.insurances_allowables_cpt_mapiacm_amount
_1548.insurances_contracted_pricingicp_amount
_1548.ledgerled_amount
_1548.ledgerled_orig_amount
_1548.ledgerled_unit_amount
_1548.patient_finance_recordspfr_min_due_amount
_1548.patientspat_min_due_amount
_1548.patients_immunizationspim_administered_amount
_1548.patients_immunizations_templatespimt_administered_amount
_1548.patients_inventorypinv_administered_amount
_1548.patients_payments_schedulespps_amount
_1548.patients_responsibility_estimatesprest_allowed_amount
_1548.patients_responsibility_estimates_servicesprests_allowed_amount
_1548.pre_services_line_adjustmentsprestsla_amount
_1548.voided_paymentsvp_amount
_1548.voided_paymentsvp_orig_amount
_435.billing_codesbil_negative_amount
_435.encounters_paymentsepay_amount
_435.encounters_ub04enc_ub04_39_a_amount
_435.encounters_ub04enc_ub04_39_b_amount
_435.encounters_ub04enc_ub04_39_c_amount
_435.encounters_ub04enc_ub04_39_d_amount
_435.encounters_ub04enc_ub04_40_a_amount
_435.encounters_ub04enc_ub04_40_b_amount
_435.encounters_ub04enc_ub04_40_c_amount
_435.encounters_ub04enc_ub04_40_d_amount
_435.encounters_ub04enc_ub04_41_a_amount
_435.encounters_ub04enc_ub04_41_b_amount
_435.encounters_ub04enc_ub04_41_c_amount
_435.encounters_ub04enc_ub04_41_d_amount
_435.insurances_allowables_cpt_mapiacm_amount
_435.insurances_contracted_pricingicp_amount
_435.ledgerled_amount
_435.ledgerled_orig_amount
_435.ledgerled_unit_amount
_435.patient_finance_recordspfr_min_due_amount
_435.patientspat_min_due_amount
_435.patients_immunizationspim_administered_amount
_435.patients_immunizations_templatespimt_administered_amount
_435.patients_inventorypinv_administered_amount
_435.patients_payments_schedulespps_amount
_435.patients_responsibility_estimatesprest_allowed_amount
_435.patients_responsibility_estimates_servicesprests_allowed_amount
_435.pre_services_line_adjustmentsprestsla_amount
_435.voided_paymentsvp_amount
_435.voided_paymentsvp_orig_amount
_436.billing_codesbil_negative_amount
_436.encounters_paymentsepay_amount
_436.encounters_ub04enc_ub04_39_a_amount
_436.encounters_ub04enc_ub04_39_b_amount
_436.encounters_ub04enc_ub04_39_c_amount
_436.encounters_ub04enc_ub04_39_d_amount
_436.encounters_ub04enc_ub04_40_a_amount
_436.encounters_ub04enc_ub04_40_b_amount
_436.encounters_ub04enc_ub04_40_c_amount
_436.encounters_ub04enc_ub04_40_d_amount
_436.encounters_ub04enc_ub04_41_a_amount
_436.encounters_ub04enc_ub04_41_b_amount
_436.encounters_ub04enc_ub04_41_c_amount
_436.encounters_ub04enc_ub04_41_d_amount
_436.insurances_allowables_cpt_mapiacm_amount
_436.insurances_contracted_pricingicp_amount
_436.ledgerled_amount
_436.ledgerled_orig_amount
_436.ledgerled_unit_amount
_436.patient_finance_recordspfr_min_due_amount
_436.patientspat_min_due_amount
_436.patients_immunizationspim_administered_amount
_436.patients_immunizations_templatespimt_administered_amount
_436.patients_inventorypinv_administered_amount
_436.patients_payments_schedulespps_amount
_436.patients_responsibility_estimatesprest_allowed_amount
_436.patients_responsibility_estimates_servicesprests_allowed_amount
_436.pre_services_line_adjustmentsprestsla_amount
_436.voided_paymentsvp_amount
_436.voided_paymentsvp_orig_amount
_436_archive_testing.billing_codesbil_negative_amount
_436_archive_testing.encounters_paymentsepay_amount
_436_archive_testing.encounters_ub04enc_ub04_39_a_amount
_436_archive_testing.encounters_ub04enc_ub04_39_b_amount
_436_archive_testing.encounters_ub04enc_ub04_39_c_amount
_436_archive_testing.encounters_ub04enc_ub04_39_d_amount
_436_archive_testing.encounters_ub04enc_ub04_40_a_amount
_436_archive_testing.encounters_ub04enc_ub04_40_b_amount
_436_archive_testing.encounters_ub04enc_ub04_40_c_amount
_436_archive_testing.encounters_ub04enc_ub04_40_d_amount
_436_archive_testing.encounters_ub04enc_ub04_41_a_amount
_436_archive_testing.encounters_ub04enc_ub04_41_b_amount
_436_archive_testing.encounters_ub04enc_ub04_41_c_amount
_436_archive_testing.encounters_ub04enc_ub04_41_d_amount
_436_archive_testing.insurances_allowables_cpt_mapiacm_amount
_436_archive_testing.insurances_contracted_pricingicp_amount
_436_archive_testing.ledgerled_amount
_436_archive_testing.ledgerled_orig_amount
_436_archive_testing.ledgerled_unit_amount
_436_archive_testing.patient_finance_recordspfr_min_due_amount
_436_archive_testing.patientspat_min_due_amount
_436_archive_testing.patients_immunizationspim_administered_amount
_436_archive_testing.patients_immunizations_templatespimt_administered_amount
_436_archive_testing.patients_inventorypinv_administered_amount
_436_archive_testing.patients_payments_schedulespps_amount
_436_archive_testing.patients_responsibility_estimatesprest_allowed_amount
_436_archive_testing.patients_responsibility_estimates_servicesprests_allowed_amount
_436_archive_testing.pre_services_line_adjustmentsprestsla_amount
_436_archive_testing.voided_paymentsvp_amount
_436_archive_testing.voided_paymentsvp_orig_amount
_437.billing_codesbil_negative_amount
_437.encounters_paymentsepay_amount
_437.encounters_ub04enc_ub04_39_a_amount
_437.encounters_ub04enc_ub04_39_b_amount
_437.encounters_ub04enc_ub04_39_c_amount
_437.encounters_ub04enc_ub04_39_d_amount
_437.encounters_ub04enc_ub04_40_a_amount
_437.encounters_ub04enc_ub04_40_b_amount
_437.encounters_ub04enc_ub04_40_c_amount
_437.encounters_ub04enc_ub04_40_d_amount
_437.encounters_ub04enc_ub04_41_a_amount
_437.encounters_ub04enc_ub04_41_b_amount
_437.encounters_ub04enc_ub04_41_c_amount
_437.encounters_ub04enc_ub04_41_d_amount
_437.insurances_allowables_cpt_mapiacm_amount
_437.insurances_contracted_pricingicp_amount
_437.ledgerled_amount
_437.ledgerled_orig_amount
_437.ledgerled_unit_amount
_437.patient_finance_recordspfr_min_due_amount
_437.patientspat_min_due_amount
_437.patients_immunizationspim_administered_amount
_437.patients_immunizations_templatespimt_administered_amount
_437.patients_inventorypinv_administered_amount
_437.patients_payments_schedulespps_amount
_437.patients_responsibility_estimatesprest_allowed_amount
_437.patients_responsibility_estimates_servicesprests_allowed_amount
_437.pre_services_line_adjustmentsprestsla_amount
_437.voided_paymentsvp_amount
_437.voided_paymentsvp_orig_amount
_8.billing_codesbil_negative_amount
_8.daily_close_calculationsdcc_last_payment_amount
_8.daily_close_calculationsdcc_bil_negative_amount
_8.daily_close_calculationsdcc_led_amount
_8.daily_close_calculationsdcc_led_orig_amount
_8.encounters_paymentsepay_amount
_8.encounters_ub04enc_ub04_39_a_amount
_8.encounters_ub04enc_ub04_39_b_amount
_8.encounters_ub04enc_ub04_39_c_amount
_8.encounters_ub04enc_ub04_39_d_amount
_8.encounters_ub04enc_ub04_40_a_amount
_8.encounters_ub04enc_ub04_40_b_amount
_8.encounters_ub04enc_ub04_40_c_amount
_8.encounters_ub04enc_ub04_40_d_amount
_8.encounters_ub04enc_ub04_41_a_amount
_8.encounters_ub04enc_ub04_41_b_amount
_8.encounters_ub04enc_ub04_41_c_amount
_8.encounters_ub04enc_ub04_41_d_amount
_8.insurances_allowables_cpt_mapiacm_amount
_8.insurances_contracted_pricingicp_amount
_8.ledgerled_amount
_8.ledgerled_orig_amount
_8.ledgerled_unit_amount
_8.patient_finance_recordspfr_min_due_amount
_8.patientspat_min_due_amount
_8.patients_immunizationspim_administered_amount
_8.patients_immunizations_templatespimt_administered_amount
_8.patients_inventorypinv_administered_amount
_8.patients_payments_schedulespps_amount
_8.patients_responsibility_estimatesprest_allowed_amount
_8.patients_responsibility_estimates_servicesprests_allowed_amount
_8.pre_services_line_adjustmentsprestsla_amount
_8.voided_paymentsvp_amount
_8.voided_paymentsvp_orig_amount
_81.billing_codesbil_negative_amount
_81.encounters_paymentsepay_amount
_81.encounters_ub04enc_ub04_39_a_amount
_81.encounters_ub04enc_ub04_39_b_amount
_81.encounters_ub04enc_ub04_39_c_amount
_81.encounters_ub04enc_ub04_39_d_amount
_81.encounters_ub04enc_ub04_40_a_amount
_81.encounters_ub04enc_ub04_40_b_amount
_81.encounters_ub04enc_ub04_40_c_amount
_81.encounters_ub04enc_ub04_40_d_amount
_81.encounters_ub04enc_ub04_41_a_amount
_81.encounters_ub04enc_ub04_41_b_amount
_81.encounters_ub04enc_ub04_41_c_amount
_81.encounters_ub04enc_ub04_41_d_amount
_81.insurances_allowables_cpt_mapiacm_amount
_81.insurances_contracted_pricingicp_amount
_81.ledgerled_amount
_81.ledgerled_orig_amount
_81.ledgerled_unit_amount
_81.patient_finance_recordspfr_min_due_amount
_81.patientspat_min_due_amount
_81.patients_immunizationspim_administered_amount
_81.patients_immunizations_templatespimt_administered_amount
_81.patients_inventorypinv_administered_amount
_81.patients_payments_schedulespps_amount
_81.patients_responsibility_estimatesprest_allowed_amount
_81.patients_responsibility_estimates_servicesprests_allowed_amount
_81.pre_services_line_adjustmentsprestsla_amount
_81.voided_paymentsvp_amount
_81.voided_paymentsvp_orig_amount
_999.billing_codesbil_negative_amount
_999.encounters_paymentsepay_amount
_999.encounters_ub04enc_ub04_39_a_amount
_999.encounters_ub04enc_ub04_39_b_amount
_999.encounters_ub04enc_ub04_39_c_amount
_999.encounters_ub04enc_ub04_39_d_amount
_999.encounters_ub04enc_ub04_40_a_amount
_999.encounters_ub04enc_ub04_40_b_amount
_999.encounters_ub04enc_ub04_40_c_amount
_999.encounters_ub04enc_ub04_40_d_amount
_999.encounters_ub04enc_ub04_41_a_amount
_999.encounters_ub04enc_ub04_41_b_amount
_999.encounters_ub04enc_ub04_41_c_amount
_999.encounters_ub04enc_ub04_41_d_amount
_999.insurances_allowables_cpt_mapiacm_amount
_999.insurances_contracted_pricingicp_amount
_999.ledgerled_amount
_999.ledgerled_orig_amount
_999.ledgerled_unit_amount
_999.patient_finance_recordspfr_min_due_amount
_999.patientspat_min_due_amount
_999.patients_immunizationspim_administered_amount
_999.patients_immunizations_templatespimt_administered_amount
_999.patients_inventorypinv_administered_amount
_999.patients_payments_schedulespps_amount
_999.patients_responsibility_estimatesprest_allowed_amount
_999.patients_responsibility_estimates_servicesprests_allowed_amount
_999.pre_services_line_adjustmentsprestsla_amount
_999.voided_paymentsvp_amount
_999.voided_paymentsvp_orig_amount
aurora_standard.amcbdwo_amount
aurora_standard.chmnbcgrtot_amount
aurora_standard.chmnbpyrtot_amount
aurora_standard.chmtbtrrtot_amount
aurora_standard.chpempirlife_amount
aurora_standard.chrdrugcpurch_amount
aurora_standard.chtwkhrdcarry_amount
aurora_standard.mktcusproposal_amount
aurora_standard.oddpayrecash_amount
aurora_standard.odhpayrecash_amount
aurora_standard.stfactvddepr_amount
aurora_standard.stfactvvdepr_amount
aurora_standard.stoinvceitem_amount
aurora_standard.stoinvcetrd_ds_amount
aurora_standard.stoinvcest_tx_amount
aurora_standard.stoinvceco_tx_amount
aurora_standard.stoinvceci_tx_amount
aurora_standard.stoinvcefrght_amount
aurora_standard.stoinvcetotal_amount
aurora_standard.stoinvcetax_amount
aurora_standard.stoordrdtax_amount
aurora_standard.stoordrdnet_amount
aurora_standard.stoordreitem_amount
aurora_standard.stoordretrd_ds_amount
aurora_standard.stoordretax_amount
aurora_standard.stoordrefrght_amount
aurora_standard.stoordretotal_amount
aurora_standard.stoshipdtax_amount
aurora_standard.stoshipdnet_amount
aurora_standard.stpactvdhome_curr_amount
aurora_standard.stpinvcedisc_amount
aurora_standard.stpinvceap_amount
aurora_standard.stpinvcehome_curr_amount
aurora_standard.stpopendorig_amount
aurora_standard.stpopendhome_curr_amount
aurora_standard.stractvdhome_curr_amount
aurora_standard.strcustrstmt_amount
aurora_standard.strinvcedisc_amount
aurora_standard.strinvcetax_amount
aurora_standard.strinvcefrght_amount
aurora_standard.strinvcemisc_amount
aurora_standard.strinvcear_amount
aurora_standard.strinvcehome_curr_amount
aurora_standard.strnotedorig_amount
aurora_standard.stropendorig_amount
aurora_standard.stropendhome_curr_amount
aurora_standard.stuinvcemisc_amount
aurora_standard.stuinvcefrght_amount
aurora_standard.stuordreitem_amount
aurora_standard.stuordretrd_ds_amount
aurora_standard.stuordretax_amount
aurora_standard.stuordrefrght_amount
aurora_standard.stuordremisc_amount
aurora_standard.stuordregoods_amount
aurora_standard.stuordretotal_amount
aurora_standard.stuordreprepay_amount
aurora_standard.styinccrot_shift_amount
aurora_standard.stypayrecash_amount
aurora_standard.styrevsdcash_amount
aurora_standard.tmp04dchg_amount
aurora_standard.tmp15chdchg_amount
common.billing_codesbil_negative_amount
common.rcm_stats_agingrcmsa_0_30_amount
common.rcm_stats_agingrcmsa_31_60_amount
common.rcm_stats_agingrcmsa_61_90_amount
common.rcm_stats_agingrcmsa_91_120_amount
common.rcm_stats_agingrcmsa_121_amount
common.rcm_stats_agingrcmsa_total_amount
template_library.patients_immunizations_templatespimt_administered_amount
cpt_code
TableColumn
Loinc.loinc_codeslc_cpt_code
_1.clients_fee_schedules_mapcfsm_cpt_code
_1.clinical_interventions_test_codes_mapcitcm_cpt_code
_1.immunizations_cpt_mapicm_cpt_code
_1.insurances_allowables_cpt_mapiacm_cpt_code
_1.insurances_contracted_pricingicp_cpt_code
_1.insurances_contracted_pricing_logicpl_cpt_code
_1.patients_responsibility_estimates_servicesprests_cpt_code
_1188.clients_fee_schedules_mapcfsm_cpt_code
_1188.clinical_interventions_test_codes_mapcitcm_cpt_code
_1188.immunizations_cpt_mapicm_cpt_code
_1188.insurances_allowables_cpt_mapiacm_cpt_code
_1188.insurances_contracted_pricingicp_cpt_code
_1188.insurances_contracted_pricing_logicpl_cpt_code
_1188.patients_responsibility_estimates_servicesprests_cpt_code
_1218.clients_fee_schedules_mapcfsm_cpt_code
_1218.clinical_interventions_test_codes_mapcitcm_cpt_code
_1218.immunizations_cpt_mapicm_cpt_code
_1218.insurances_allowables_cpt_mapiacm_cpt_code
_1218.insurances_contracted_pricingicp_cpt_code
_1218.insurances_contracted_pricing_logicpl_cpt_code
_1218.patients_responsibility_estimates_servicesprests_cpt_code
_1548.clients_fee_schedules_mapcfsm_cpt_code
_1548.clinical_interventions_test_codes_mapcitcm_cpt_code
_1548.immunizations_cpt_mapicm_cpt_code
_1548.insurances_allowables_cpt_mapiacm_cpt_code
_1548.insurances_contracted_pricingicp_cpt_code
_1548.insurances_contracted_pricing_logicpl_cpt_code
_1548.patients_responsibility_estimates_servicesprests_cpt_code
_435.clients_fee_schedules_mapcfsm_cpt_code
_435.clinical_interventions_test_codes_mapcitcm_cpt_code
_435.immunizations_cpt_mapicm_cpt_code
_435.insurances_allowables_cpt_mapiacm_cpt_code
_435.insurances_contracted_pricingicp_cpt_code
_435.insurances_contracted_pricing_logicpl_cpt_code
_435.patients_responsibility_estimates_servicesprests_cpt_code
_436.clients_fee_schedules_mapcfsm_cpt_code
_436.clinical_interventions_test_codes_mapcitcm_cpt_code
_436.immunizations_cpt_mapicm_cpt_code
_436.insurances_allowables_cpt_mapiacm_cpt_code
_436.insurances_contracted_pricingicp_cpt_code
_436.insurances_contracted_pricing_logicpl_cpt_code
_436.patients_responsibility_estimates_servicesprests_cpt_code
_436_archive_testing.clients_fee_schedules_mapcfsm_cpt_code
_436_archive_testing.clinical_interventions_test_codes_mapcitcm_cpt_code
_436_archive_testing.immunizations_cpt_mapicm_cpt_code
_436_archive_testing.insurances_allowables_cpt_mapiacm_cpt_code
_436_archive_testing.insurances_contracted_pricingicp_cpt_code
_436_archive_testing.insurances_contracted_pricing_logicpl_cpt_code
_436_archive_testing.patients_responsibility_estimates_servicesprests_cpt_code
_437.clients_fee_schedules_mapcfsm_cpt_code
_437.clinical_interventions_test_codes_mapcitcm_cpt_code
_437.immunizations_cpt_mapicm_cpt_code
_437.insurances_allowables_cpt_mapiacm_cpt_code
_437.insurances_contracted_pricingicp_cpt_code
_437.insurances_contracted_pricing_logicpl_cpt_code
_437.patients_responsibility_estimates_servicesprests_cpt_code
_8.clients_fee_schedules_mapcfsm_cpt_code
_8.clinical_interventions_test_codes_mapcitcm_cpt_code
_8.immunizations_cpt_mapicm_cpt_code
_8.insurances_allowables_cpt_mapiacm_cpt_code
_8.insurances_contracted_pricingicp_cpt_code
_8.insurances_contracted_pricing_logicpl_cpt_code
_8.patients_responsibility_estimates_servicesprests_cpt_code
_81.clients_fee_schedules_mapcfsm_cpt_code
_81.clinical_interventions_test_codes_mapcitcm_cpt_code
_81.immunizations_cpt_mapicm_cpt_code
_81.insurances_allowables_cpt_mapiacm_cpt_code
_81.insurances_contracted_pricingicp_cpt_code
_81.insurances_contracted_pricing_logicpl_cpt_code
_81.patients_responsibility_estimates_servicesprests_cpt_code
_999.clients_fee_schedules_mapcfsm_cpt_code
_999.clinical_interventions_test_codes_mapcitcm_cpt_code
_999.immunizations_cpt_mapicm_cpt_code
_999.insurances_allowables_cpt_mapiacm_cpt_code
_999.insurances_contracted_pricingicp_cpt_code
_999.insurances_contracted_pricing_logicpl_cpt_code
_999.patients_responsibility_estimates_servicesprests_cpt_code
aurora_standard.axlscdmmd_cpt_code
aurora_standard.axlscdmci_cpt_code
aurora_standard.c5cdmoth_cpt_code
aurora_standard.c5cdmwc_cpt_code
aurora_standard.c5cdmcomm_cpt_code
aurora_standard.c5cdmdroth_cpt_code
aurora_standard.c5cdmdrwc_cpt_code
aurora_standard.c5cdmdrcomm_cpt_code
aurora_standard.c7cdmcomm_cpt_code
aurora_standard.c8cdmcomm_cpt_code
aurora_standard.chmpricaprev_cpt_code
aurora_standard.chmpricacur_cpt_code
aurora_standard.chmpricccomm_cpt_code
aurora_standard.glspricecomm_cpt_code
common.loinc_codeslc_cpt_code
common.mednecmed_cpt_code
common.test_codes_cpttcc_cpt_code
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
pos
TableColumn
_1.billing_codesbil_positive_amount
_1188.billing_codesbil_positive_amount
_1218.billing_codesbil_positive_amount
_1548.billing_codesbil_positive_amount
_435.billing_codesbil_positive_amount
_436.billing_codesbil_positive_amount
_436_archive_testing.billing_codesbil_positive_amount
_437.billing_codesbil_positive_amount
_8.billing_codesbil_positive_amount
_8.daily_close_calculationsdcc_bil_positive_amount
_81.billing_codesbil_positive_amount
_999.billing_codesbil_positive_amount
aurora_standard.cgmmposrx_pos
aurora_standard.cgmmposry_pos
aurora_standard.chmabstrhidi_pos
aurora_standard.chmstatchidi_pos
aurora_standard.chmstatcdef_pos
common.billing_codesbil_positive_amount
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
to_date
TableColumn
_1.schedulessch_to_date
_1.schedules_eventssevnt_to_date
_1.taskstask_to_date
_1188.schedulessch_to_date
_1188.schedules_eventssevnt_to_date
_1188.taskstask_to_date
_1218.schedulessch_to_date
_1218.schedules_eventssevnt_to_date
_1218.taskstask_to_date
_1548.schedulessch_to_date
_1548.schedules_eventssevnt_to_date
_1548.taskstask_to_date
_435.schedulessch_to_date
_435.schedules_eventssevnt_to_date
_435.taskstask_to_date
_436.schedulessch_to_date
_436.schedules_eventssevnt_to_date
_436.taskstask_to_date
_436_archive_testing.schedulessch_to_date
_436_archive_testing.schedules_eventssevnt_to_date
_436_archive_testing.taskstask_to_date
_437.schedulessch_to_date
_437.schedules_eventssevnt_to_date
_437.taskstask_to_date
_8.schedulessch_to_date
_8.schedules_eventssevnt_to_date
_8.taskstask_to_date
_81.schedulessch_to_date
_81.schedules_eventssevnt_to_date
_81.taskstask_to_date
_999.schedulessch_to_date
_999.schedules_eventssevnt_to_date
_999.taskstask_to_date
common.rcm_stats_agingrcmsa_to_date
common.rcm_stats_generalrcmsg_to_date
common.rcm_stats_practice_analysisrcmspa_to_date
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
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
chg_date
TableColumn
aurora_standard.chmbchgrdef_chg_date
aurora_standard.chmbitmrdef_chg_date