aurora_standard.tmparinq

Field Type Null Default Key Extra Comment
visit_no int(11) NO MUL
which_log char(2) YES
bill_id char(3) YES
seq_no smallint(6) unsigned YES
payer char(20) YES
claim_type char(2) YES
emc_date date YES
bill_type char(3) YES
bill_amt decimal(10,2) YES
bill_bal decimal(10,2) YES
from_date date YES
thru_date date YES

References

Local Column References
bill_type
TableColumn
_1.chartschrt_bill_type
_1.encountersenc_bill_type
_1.encounters_paymentsepay_bill_type
_1.insurancesins_ub04_bill_type
_1.locationsloc_ub04_bill_type
_1.ordersord_bill_type
_1.patientspat_bill_type
_1.patients_demographics_snapshotspds_bill_type
_1.physiciansphy_ub04_bill_type
_1.precertspre_bill_type
_1.radiology_ordersrad_bill_type
_1188.chartschrt_bill_type
_1188.encountersenc_bill_type
_1188.encounters_paymentsepay_bill_type
_1188.insurancesins_ub04_bill_type
_1188.locationsloc_ub04_bill_type
_1188.ordersord_bill_type
_1188.patientspat_bill_type
_1188.patients_demographics_snapshotspds_bill_type
_1188.physiciansphy_ub04_bill_type
_1188.precertspre_bill_type
_1188.radiology_ordersrad_bill_type
_1218.chartschrt_bill_type
_1218.encountersenc_bill_type
_1218.encounters_paymentsepay_bill_type
_1218.insurancesins_ub04_bill_type
_1218.locationsloc_ub04_bill_type
_1218.ordersord_bill_type
_1218.patientspat_bill_type
_1218.patients_demographics_snapshotspds_bill_type
_1218.physiciansphy_ub04_bill_type
_1218.precertspre_bill_type
_1218.radiology_ordersrad_bill_type
_1548.chartschrt_bill_type
_1548.encountersenc_bill_type
_1548.encounters_paymentsepay_bill_type
_1548.insurancesins_ub04_bill_type
_1548.locationsloc_ub04_bill_type
_1548.ordersord_bill_type
_1548.patientspat_bill_type
_1548.patients_demographics_snapshotspds_bill_type
_1548.physiciansphy_ub04_bill_type
_1548.precertspre_bill_type
_1548.radiology_ordersrad_bill_type
_435.chartschrt_bill_type
_435.encountersenc_bill_type
_435.encounters_paymentsepay_bill_type
_435.insurancesins_ub04_bill_type
_435.locationsloc_ub04_bill_type
_435.ordersord_bill_type
_435.patientspat_bill_type
_435.patients_demographics_snapshotspds_bill_type
_435.physiciansphy_ub04_bill_type
_435.precertspre_bill_type
_435.radiology_ordersrad_bill_type
_436.chartschrt_bill_type
_436.encountersenc_bill_type
_436.encounters_paymentsepay_bill_type
_436.insurancesins_ub04_bill_type
_436.locationsloc_ub04_bill_type
_436.ordersord_bill_type
_436.patientspat_bill_type
_436.patients_demographics_snapshotspds_bill_type
_436.physiciansphy_ub04_bill_type
_436.precertspre_bill_type
_436.radiology_ordersrad_bill_type
_436_archive_testing.chartschrt_bill_type
_436_archive_testing.encountersenc_bill_type
_436_archive_testing.encounters_paymentsepay_bill_type
_436_archive_testing.insurancesins_ub04_bill_type
_436_archive_testing.locationsloc_ub04_bill_type
_436_archive_testing.ordersord_bill_type
_436_archive_testing.patientspat_bill_type
_436_archive_testing.patients_demographics_snapshotspds_bill_type
_436_archive_testing.physiciansphy_ub04_bill_type
_436_archive_testing.precertspre_bill_type
_436_archive_testing.radiology_ordersrad_bill_type
_437.chartschrt_bill_type
_437.encountersenc_bill_type
_437.encounters_paymentsepay_bill_type
_437.insurancesins_ub04_bill_type
_437.locationsloc_ub04_bill_type
_437.ordersord_bill_type
_437.patientspat_bill_type
_437.patients_demographics_snapshotspds_bill_type
_437.physiciansphy_ub04_bill_type
_437.precertspre_bill_type
_437.radiology_ordersrad_bill_type
_8.chartschrt_bill_type
_8.daily_close_calculationsdcc_enc_bill_type
_8.encountersenc_bill_type
_8.encounters_paymentsepay_bill_type
_8.insurancesins_ub04_bill_type
_8.locationsloc_ub04_bill_type
_8.ordersord_bill_type
_8.patientspat_bill_type
_8.patients_demographics_snapshotspds_bill_type
_8.physiciansphy_ub04_bill_type
_8.precertspre_bill_type
_8.radiology_ordersrad_bill_type
_81.chartschrt_bill_type
_81.encountersenc_bill_type
_81.encounters_paymentsepay_bill_type
_81.insurancesins_ub04_bill_type
_81.locationsloc_ub04_bill_type
_81.ordersord_bill_type
_81.patientspat_bill_type
_81.patients_demographics_snapshotspds_bill_type
_81.physiciansphy_ub04_bill_type
_81.precertspre_bill_type
_81.radiology_ordersrad_bill_type
_999.chartschrt_bill_type
_999.encountersenc_bill_type
_999.encounters_paymentsepay_bill_type
_999.insurancesins_ub04_bill_type
_999.locationsloc_ub04_bill_type
_999.ordersord_bill_type
_999.patientspat_bill_type
_999.patients_demographics_snapshotspds_bill_type
_999.physiciansphy_ub04_bill_type
_999.precertspre_bill_type
_999.radiology_ordersrad_bill_type
common.clientscli_ub04_bill_type
payer
TableColumn
_1.encountersenc_next_payer
_1.encounters_cpt_codesecp_next_payer_bill_type
_1.encounters_paymentsepay_edi_payer
_1.insurancesins_edi_payer
_1.insurances_newins_edi_payer
_1188.encountersenc_next_payer
_1188.encounters_cpt_codesecp_next_payer_bill_type
_1188.encounters_paymentsepay_edi_payer
_1188.insurancesins_edi_payer
_1188.insurances_newins_edi_payer
_1218.encountersenc_next_payer
_1218.encounters_cpt_codesecp_next_payer_bill_type
_1218.encounters_paymentsepay_edi_payer
_1218.insurancesins_edi_payer
_1218.insurances_newins_edi_payer
_1548.encountersenc_next_payer
_1548.encounters_cpt_codesecp_next_payer_bill_type
_1548.encounters_paymentsepay_edi_payer
_1548.insurancesins_edi_payer
_1548.insurances_newins_edi_payer
_435.encountersenc_next_payer
_435.encounters_cpt_codesecp_next_payer_bill_type
_435.encounters_paymentsepay_edi_payer
_435.insurancesins_edi_payer
_435.insurances_newins_edi_payer
_435.ledger_running_balancelrb_next_payer_bill_type
_436.encountersenc_next_payer
_436.encounters_cpt_codesecp_next_payer_bill_type
_436.encounters_paymentsepay_edi_payer
_436.insurancesins_edi_payer
_436.insurances_newins_edi_payer
_436.ledger_running_balancelrb_next_payer_bill_type
_436_archive_testing.encountersenc_next_payer
_436_archive_testing.encounters_cpt_codesecp_next_payer_bill_type
_436_archive_testing.encounters_paymentsepay_edi_payer
_436_archive_testing.insurancesins_edi_payer
_436_archive_testing.insurances_newins_edi_payer
_436_archive_testing.ledger_running_balancelrb_next_payer_bill_type
_437.encountersenc_next_payer
_437.encounters_cpt_codesecp_next_payer_bill_type
_437.encounters_paymentsepay_edi_payer
_437.insurancesins_edi_payer
_437.insurances_newins_edi_payer
_437.ledger_running_balancelrb_next_payer_bill_type
_8.daily_close_calculationsdcc_next_payer
_8.daily_close_calculationsdcc_next_payer_bill_type
_8.encountersenc_next_payer
_8.encounters_cpt_codesecp_next_payer_bill_type
_8.encounters_paymentsepay_edi_payer
_8.insurancesins_edi_payer
_8.insurances_newins_edi_payer
_81.encountersenc_next_payer
_81.encounters_cpt_codesecp_next_payer_bill_type
_81.encounters_paymentsepay_edi_payer
_81.insurancesins_edi_payer
_81.insurances_newins_edi_payer
_999.encountersenc_next_payer
_999.encounters_cpt_codesecp_next_payer_bill_type
_999.encounters_paymentsepay_edi_payer
_999.insurancesins_edi_payer
_999.insurances_newins_edi_payer
aurora_standard.abmviscur_payer
aurora_standard.adshmdpri_payer
aurora_standard.adshmdsec_payer
aurora_standard.adshpmtpri_payer
aurora_standard.adshpmtsec_payer
aurora_standard.adshrevsec_payer
aurora_standard.chm835pdins_co_payer
aurora_standard.chmazstdpri_payer
aurora_standard.chmazstipri_payer
aurora_standard.chmazstopri_payer
aurora_standard.chmerapcera_payer
aurora_standard.chmlastrpri_payer
aurora_standard.chmlastrsec_payer
aurora_standard.chmlastrter_payer
aurora_standard.chmmhastpri_payer
aurora_standard.chmmhastsec_payer
aurora_standard.chmtxstrpri_payer
aurora_standard.chmtxstrsec_payer
aurora_standard.chmtxstrter_payer
aurora_standard.chmutah7pri_payer
aurora_standard.chmutah7sec_payer
aurora_standard.chmutah7ter_payer
aurora_standard.chmutahapri_payer
aurora_standard.chmutahasec_payer
aurora_standard.chmutahater_payer
claim_type
TableColumn
_1.encounters_claims_filesecf_claim_type
_1188.encounters_claims_filesecf_claim_type
_1218.encounters_claims_filesecf_claim_type
_1548.encounters_claims_filesecf_claim_type
_435.encounters_claims_filesecf_claim_type
_436.encounters_claims_filesecf_claim_type
_436_archive_testing.encounters_claims_filesecf_claim_type
_437.encounters_claims_filesecf_claim_type
_8.encounters_claims_filesecf_claim_type
_81.encounters_claims_filesecf_claim_type
_999.encounters_claims_filesecf_claim_type
from_date
TableColumn
_1.encounters_ub04enc_ub04_06_from_date
_1.schedulessch_from_date
_1.schedules_eventssevnt_from_date
_1.taskstask_from_date
_1188.encounters_ub04enc_ub04_06_from_date
_1188.schedulessch_from_date
_1188.schedules_eventssevnt_from_date
_1188.taskstask_from_date
_1218.encounters_ub04enc_ub04_06_from_date
_1218.schedulessch_from_date
_1218.schedules_eventssevnt_from_date
_1218.taskstask_from_date
_1548.encounters_ub04enc_ub04_06_from_date
_1548.schedulessch_from_date
_1548.schedules_eventssevnt_from_date
_1548.taskstask_from_date
_435.encounters_ub04enc_ub04_06_from_date
_435.schedulessch_from_date
_435.schedules_eventssevnt_from_date
_435.taskstask_from_date
_436.encounters_ub04enc_ub04_06_from_date
_436.schedulessch_from_date
_436.schedules_eventssevnt_from_date
_436.taskstask_from_date
_436_archive_testing.encounters_ub04enc_ub04_06_from_date
_436_archive_testing.schedulessch_from_date
_436_archive_testing.schedules_eventssevnt_from_date
_436_archive_testing.taskstask_from_date
_437.encounters_ub04enc_ub04_06_from_date
_437.schedulessch_from_date
_437.schedules_eventssevnt_from_date
_437.taskstask_from_date
_8.encounters_ub04enc_ub04_06_from_date
_8.schedulessch_from_date
_8.schedules_eventssevnt_from_date
_8.taskstask_from_date
_81.encounters_ub04enc_ub04_06_from_date
_81.schedulessch_from_date
_81.schedules_eventssevnt_from_date
_81.taskstask_from_date
_999.encounters_ub04enc_ub04_06_from_date
_999.schedulessch_from_date
_999.schedules_eventssevnt_from_date
_999.taskstask_from_date
aurora_standard.chmardydrev_from_date
aurora_standard.chmcptvceff_from_date
aurora_standard.chmvrsnceff_from_date
common.rcm_stats_generalrcmsg_from_date
common.rcm_stats_practice_analysisrcmspa_from_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
thru_date
TableColumn
aurora_standard.chmcptvceff_thru_date
aurora_standard.chmvrsnceff_thru_date