aurora_standard.chm15bcd

Field Type Null Default Key Extra Comment
batch_id varchar(10) YES
visit_no int(11) YES MUL
price_code varchar(10) YES
chg_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 smallint(6) YES
diag_seq_2 smallint(6) YES
diag_seq_3 smallint(6) YES
diag_seq_4 smallint(6) YES
pos_1532 varchar(2) YES
to_date date YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
batch_id
TableColumn
HSPI_Bastrop.chargescharge_batch_id
HSPI_Bastrop.claim_itemsclaim_batch_id
HSPI_Bastrop.claimsclaim_batch_id
HSPI_Bastrop.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Bastrop.invoicesinvoice_batch_id
HSPI_Bastrop.transactionstransaction_batch_id
HSPI_CURES2015_B1.chargescharge_batch_id
HSPI_CURES2015_B1.claim_itemsclaim_batch_id
HSPI_CURES2015_B1.claimsclaim_batch_id
HSPI_CURES2015_B1.claims_claim_batches_mapclaim_batch_id
HSPI_CURES2015_B1.fa_transaction_wrapperstransaction_batch_id
HSPI_CURES2015_B1.invoice_batches_facilities_mapinvoice_batch_id
HSPI_CURES2015_B1.invoicesinvoice_batch_id
HSPI_CURES2015_B1.transaction_batch_financial_accountstransaction_batch_id
HSPI_CURES2015_B1.transactionstransaction_batch_id
HSPI_Central_Hospital.chargescharge_batch_id
HSPI_Central_Hospital.claim_filesclaim_batch_id
HSPI_Central_Hospital.claim_itemsclaim_batch_id
HSPI_Central_Hospital.claimsclaim_batch_id
HSPI_Central_Hospital.claims_claim_batches_mapclaim_batch_id
HSPI_Central_Hospital.fa_transaction_wrapperstransaction_batch_id
HSPI_Central_Hospital.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Central_Hospital.invoicesinvoice_batch_id
HSPI_Central_Hospital.transaction_batch_financial_accountstransaction_batch_id
HSPI_Central_Hospital.transactionstransaction_batch_id
HSPI_Dewitt.chargescharge_batch_id
HSPI_Dewitt.claim_filesclaim_batch_id
HSPI_Dewitt.claim_itemsclaim_batch_id
HSPI_Dewitt.claimsclaim_batch_id
HSPI_Dewitt.claims_claim_batches_mapclaim_batch_id
HSPI_Dewitt.fa_transaction_wrapperstransaction_batch_id
HSPI_Dewitt.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Dewitt.invoicesinvoice_batch_id
HSPI_Dewitt.transaction_batch_financial_accountstransaction_batch_id
HSPI_Dewitt.transactionstransaction_batch_id
HSPI_Fulton.chargescharge_batch_id
HSPI_Fulton.claim_filesclaim_batch_id
HSPI_Fulton.claim_itemsclaim_batch_id
HSPI_Fulton.claimsclaim_batch_id
HSPI_Fulton.claims_claim_batches_mapclaim_batch_id
HSPI_Fulton.fa_transaction_wrapperstransaction_batch_id
HSPI_Fulton.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Fulton.invoicesinvoice_batch_id
HSPI_Fulton.transaction_batch_financial_accountstransaction_batch_id
HSPI_Fulton.transactionstransaction_batch_id
HSPI_Inferno.chargescharge_batch_id
HSPI_Inferno.claim_filesclaim_batch_id
HSPI_Inferno.claim_itemsclaim_batch_id
HSPI_Inferno.claimsclaim_batch_id
HSPI_Inferno.claims_claim_batches_mapclaim_batch_id
HSPI_Inferno.fa_transaction_wrapperstransaction_batch_id
HSPI_Inferno.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Inferno.invoicesinvoice_batch_id
HSPI_Inferno.transaction_batch_financial_accountstransaction_batch_id
HSPI_Inferno.transactionstransaction_batch_id
HSPI_MU2015_E1.chargescharge_batch_id
HSPI_MU2015_E1.claim_filesclaim_batch_id
HSPI_MU2015_E1.claim_itemsclaim_batch_id
HSPI_MU2015_E1.claimsclaim_batch_id
HSPI_MU2015_E1.claims_claim_batches_mapclaim_batch_id
HSPI_MU2015_E1.fa_transaction_wrapperstransaction_batch_id
HSPI_MU2015_E1.invoice_batches_facilities_mapinvoice_batch_id
HSPI_MU2015_E1.invoicesinvoice_batch_id
HSPI_MU2015_E1.transaction_batch_financial_accountstransaction_batch_id
HSPI_MU2015_E1.transactionstransaction_batch_id
HSPI_MU2015_G2.chargescharge_batch_id
HSPI_MU2015_G2.claim_filesclaim_batch_id
HSPI_MU2015_G2.claim_itemsclaim_batch_id
HSPI_MU2015_G2.claimsclaim_batch_id
HSPI_MU2015_G2.claims_claim_batches_mapclaim_batch_id
HSPI_MU2015_G2.fa_transaction_wrapperstransaction_batch_id
HSPI_MU2015_G2.invoice_batches_facilities_mapinvoice_batch_id
HSPI_MU2015_G2.invoicesinvoice_batch_id
HSPI_MU2015_G2.transaction_batch_financial_accountstransaction_batch_id
HSPI_MU2015_G2.transactionstransaction_batch_id
HSPI_MU2015_G9.chargescharge_batch_id
HSPI_MU2015_G9.claim_filesclaim_batch_id
HSPI_MU2015_G9.claim_itemsclaim_batch_id
HSPI_MU2015_G9.claimsclaim_batch_id
HSPI_MU2015_G9.claims_claim_batches_mapclaim_batch_id
HSPI_MU2015_G9.fa_transaction_wrapperstransaction_batch_id
HSPI_MU2015_G9.invoice_batches_facilities_mapinvoice_batch_id
HSPI_MU2015_G9.invoicesinvoice_batch_id
HSPI_MU2015_G9.transaction_batch_financial_accountstransaction_batch_id
HSPI_MU2015_G9.transactionstransaction_batch_id
HSPI_Sandbox.chargescharge_batch_id
HSPI_Sandbox.claim_filesclaim_batch_id
HSPI_Sandbox.claim_itemsclaim_batch_id
HSPI_Sandbox.claimsclaim_batch_id
HSPI_Sandbox.claims_claim_batches_mapclaim_batch_id
HSPI_Sandbox.fa_transaction_wrapperstransaction_batch_id
HSPI_Sandbox.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Sandbox.invoicesinvoice_batch_id
HSPI_Sandbox.transaction_batch_financial_accountstransaction_batch_id
HSPI_Sandbox.transactionstransaction_batch_id
HSPI_Summit_General.chargescharge_batch_id
HSPI_Summit_General.claim_filesclaim_batch_id
HSPI_Summit_General.claim_itemsclaim_batch_id
HSPI_Summit_General.claimsclaim_batch_id
HSPI_Summit_General.claims_claim_batches_mapclaim_batch_id
HSPI_Summit_General.fa_transaction_wrapperstransaction_batch_id
HSPI_Summit_General.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Summit_General.invoicesinvoice_batch_id
HSPI_Summit_General.transaction_batch_financial_accountstransaction_batch_id
HSPI_Summit_General.transactionstransaction_batch_id
HSPI_United_Physicians.chargescharge_batch_id
HSPI_United_Physicians.claim_filesclaim_batch_id
HSPI_United_Physicians.claim_itemsclaim_batch_id
HSPI_United_Physicians.claimsclaim_batch_id
HSPI_United_Physicians.claims_claim_batches_mapclaim_batch_id
HSPI_United_Physicians.fa_transaction_wrapperstransaction_batch_id
HSPI_United_Physicians.invoice_batches_facilities_mapinvoice_batch_id
HSPI_United_Physicians.invoicesinvoice_batch_id
HSPI_United_Physicians.transaction_batch_financial_accountstransaction_batch_id
HSPI_United_Physicians.transactionstransaction_batch_id
MPI.chargescharge_batch_id
MPI.claim_filesclaim_batch_id
MPI.claim_itemsclaim_batch_id
MPI.claimsclaim_batch_id
MPI.claims_claim_batches_mapclaim_batch_id
MPI.fa_transaction_wrapperstransaction_batch_id
MPI.invoice_batches_facilities_mapinvoice_batch_id
MPI.invoicesinvoice_batch_id
MPI.transaction_batch_financial_accountstransaction_batch_id
MPI.transactionstransaction_batch_id
aurora_standard.hl7ft1trans_batch_id
xlnt.selenium_test_queueselenium_test_batch_id
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
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
pos
TableColumn
aurora_standard.cgmmposrx_pos
aurora_standard.cgmmposry_pos
aurora_standard.chmabstrhidi_pos
aurora_standard.chmstatchidi_pos
aurora_standard.chmstatcdef_pos
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