aurora_standard.chm835ps

Field Type Null Default Key Extra Comment
batch_id char(10) NO MUL
svc_err_msg varchar(20) YES
visit_no int(11) NO MUL
bill_id char(3) YES
seq_no int(11) YES
svc_number smallint(6) YES
proced_code char(20) YES
mod_1 char(2) YES
mod_2 char(2) YES
mod_3 char(2) YES
mod_4 char(2) YES
mod_5 char(2) YES
charge_amt decimal(16,2) YES
adj_amt decimal(16,2) YES
pmt_amt decimal(16,2) YES
allow_amt decimal(16,2) YES
ub_rev_code char(10) YES
units decimal(6,0) YES
proced_date date NO
svc_reason_1 char(10) YES
svc_amt_1 decimal(16,2) YES
svc_reason_2 char(10) YES
svc_amt_2 decimal(16,2) YES
svc_reason_3 char(10) YES
svc_amt_3 decimal(16,2) YES
svc_reason_4 char(10) YES
svc_amt_4 decimal(16,2) YES
deduct decimal(16,2) YES
coinsur decimal(16,2) YES
copay decimal(16,2) YES
apg varchar(5) YES
apc varchar(5) YES
item_remark_code varchar(10) YES
chs_rowID bigint(255) 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
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
deduct
TableColumn
_1.encounters_payments_edi_logsepel_deduct
_1188.encounters_payments_edi_logsepel_deduct
_1218.encounters_payments_edi_logsepel_deduct
_1548.encounters_payments_edi_logsepel_deduct
_435.encounters_payments_edi_logsepel_deduct
_437.encounters_payments_edi_logsepel_deduct
_8.encounters_payments_edi_logsepel_deduct
_81.encounters_payments_edi_logsepel_deduct
_999.encounters_payments_edi_logsepel_deduct
aurora_standard.chhl7in1policy_deduct
aurora_standard.chhl7in2blood_deduct
aurora_standard.hl7in1policy_deduct
aurora_standard.hl7in1adpolicy_deduct
aurora_standard.hl7in2blood_deduct
aurora_standard.hl7in2adblood_deduct
copay
TableColumn
_1.insurances_repositoryirep_ins_copay
_1.patientspat_ins1_copay
_1.patientspat_ins2_copay
_1.patientspat_ins3_copay
_1.patients_demographics_snapshotspds_ins1_copay
_1.patients_demographics_snapshotspds_ins2_copay
_1.patients_demographics_snapshotspds_ins3_copay
_1188.insurances_repositoryirep_ins_copay
_1188.patientspat_ins1_copay
_1188.patientspat_ins2_copay
_1188.patientspat_ins3_copay
_1188.patients_demographics_snapshotspds_ins1_copay
_1188.patients_demographics_snapshotspds_ins2_copay
_1188.patients_demographics_snapshotspds_ins3_copay
_1218.insurances_repositoryirep_ins_copay
_1218.patientspat_ins1_copay
_1218.patientspat_ins2_copay
_1218.patientspat_ins3_copay
_1218.patients_demographics_snapshotspds_ins1_copay
_1218.patients_demographics_snapshotspds_ins2_copay
_1218.patients_demographics_snapshotspds_ins3_copay
_1548.insurances_repositoryirep_ins_copay
_1548.patientspat_ins1_copay
_1548.patientspat_ins2_copay
_1548.patientspat_ins3_copay
_1548.patients_demographics_snapshotspds_ins1_copay
_1548.patients_demographics_snapshotspds_ins2_copay
_1548.patients_demographics_snapshotspds_ins3_copay
_435.insurances_repositoryirep_ins_copay
_435.patientspat_ins1_copay
_435.patientspat_ins2_copay
_435.patientspat_ins3_copay
_435.patients_demographics_snapshotspds_ins1_copay
_435.patients_demographics_snapshotspds_ins2_copay
_435.patients_demographics_snapshotspds_ins3_copay
_436.insurances_repositoryirep_ins_copay
_436.patientspat_ins1_copay
_436.patientspat_ins2_copay
_436.patientspat_ins3_copay
_436.patients_demographics_snapshotspds_ins1_copay
_436.patients_demographics_snapshotspds_ins2_copay
_436.patients_demographics_snapshotspds_ins3_copay
_436_archive_testing.insurances_repositoryirep_ins_copay
_436_archive_testing.patientspat_ins1_copay
_436_archive_testing.patientspat_ins2_copay
_436_archive_testing.patientspat_ins3_copay
_436_archive_testing.patients_demographics_snapshotspds_ins1_copay
_436_archive_testing.patients_demographics_snapshotspds_ins2_copay
_436_archive_testing.patients_demographics_snapshotspds_ins3_copay
_437.insurances_repositoryirep_ins_copay
_437.patientspat_ins1_copay
_437.patientspat_ins2_copay
_437.patientspat_ins3_copay
_437.patients_demographics_snapshotspds_ins1_copay
_437.patients_demographics_snapshotspds_ins2_copay
_437.patients_demographics_snapshotspds_ins3_copay
_8.insurances_repositoryirep_ins_copay
_8.patientspat_ins1_copay
_8.patientspat_ins2_copay
_8.patientspat_ins3_copay
_8.patients_demographics_snapshotspds_ins1_copay
_8.patients_demographics_snapshotspds_ins2_copay
_8.patients_demographics_snapshotspds_ins3_copay
_81.insurances_repositoryirep_ins_copay
_81.patientspat_ins1_copay
_81.patientspat_ins2_copay
_81.patientspat_ins3_copay
_81.patients_demographics_snapshotspds_ins1_copay
_81.patients_demographics_snapshotspds_ins2_copay
_81.patients_demographics_snapshotspds_ins3_copay
_999.insurances_repositoryirep_ins_copay
_999.patientspat_ins1_copay
_999.patientspat_ins2_copay
_999.patientspat_ins3_copay
_999.patients_demographics_snapshotspds_ins1_copay
_999.patients_demographics_snapshotspds_ins2_copay
_999.patients_demographics_snapshotspds_ins3_copay
aurora_standard.chmapcgrtot_copay
aurora_standard.chmcptcdest_copay
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
mod_1
TableColumn
aurora_standard.axlscdmmd_mod_1
aurora_standard.axlscdmci_mod_1
aurora_standard.chmpricaprev_mod_1
aurora_standard.chmpricacur_mod_1
mod_2
TableColumn
aurora_standard.axlscdmmd_mod_2
aurora_standard.axlscdmci_mod_2
aurora_standard.chmpricaprev_mod_2
aurora_standard.chmpricacur_mod_2
pmt_amt
TableColumn
aurora_standard.bfhoslast_pmt_amt
aurora_standard.bfpasrlast_pmt_amt
aurora_standard.chmadmqrlast_pmt_amt
aurora_standard.ohovisqrlast_pmt_amt
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
apc
TableColumn
aurora_standard.chmcptcdest_apc
aurora_standard.chmcptcdactual_apc
aurora_standard.chmhaadrdr_apc
aurora_standard.chmhaapypy_apc
aurora_standard.workcptwk_apc
ub_rev_code
TableColumn
aurora_standard.chmstatcdef_ub_rev_code