aurora_standard.hhl7chgd

Field	Type	Null
record_type	char(3)	YES
batch_id	char(20)	YES
fac_no	char(3)	YES
location	char(10)	YES
visit_no	int(11)	YES
price_code	char(20)	YES
price_desc	char(20)	YES
units	smallint(6)	YES
chg_date	date	YES
chg_time	char(10)	YES
charge_amt	decimal(9,2)	YES
visit_err	smallint(6)	YES
price_cd_err	smallint(6)	YES
last_name	char(20)	YES
first_name	char(20)	YES
comment_field	char(20)	YES
patienttype	char(15)	YES
readingNPI	varchar(10)	YES
inventory_wareh	varchar(10)	YES
orderdbycode	varchar(10)	YES
row_no	int(11)	YES

References

Local Column

References

batch_id

Table	Column
HSPI_Bastrop.charges	charge_batch_id
HSPI_Bastrop.claim_items	claim_batch_id
HSPI_Bastrop.claims	claim_batch_id
HSPI_Bastrop.invoice_batches_facilities_map	invoice_batch_id
HSPI_Bastrop.invoices	invoice_batch_id
HSPI_Bastrop.transactions	transaction_batch_id
HSPI_CURES2015_B1.charges	charge_batch_id
HSPI_CURES2015_B1.claim_items	claim_batch_id
HSPI_CURES2015_B1.claims	claim_batch_id
HSPI_CURES2015_B1.claims_claim_batches_map	claim_batch_id
HSPI_CURES2015_B1.fa_transaction_wrappers	transaction_batch_id
HSPI_CURES2015_B1.invoice_batches_facilities_map	invoice_batch_id
HSPI_CURES2015_B1.invoices	invoice_batch_id
HSPI_CURES2015_B1.transaction_batch_financial_accounts	transaction_batch_id
HSPI_CURES2015_B1.transactions	transaction_batch_id
HSPI_Central_Hospital.charges	charge_batch_id
HSPI_Central_Hospital.claim_files	claim_batch_id
HSPI_Central_Hospital.claim_items	claim_batch_id
HSPI_Central_Hospital.claims	claim_batch_id
HSPI_Central_Hospital.claims_claim_batches_map	claim_batch_id
HSPI_Central_Hospital.fa_transaction_wrappers	transaction_batch_id
HSPI_Central_Hospital.invoice_batches_facilities_map	invoice_batch_id
HSPI_Central_Hospital.invoices	invoice_batch_id
HSPI_Central_Hospital.transaction_batch_financial_accounts	transaction_batch_id
HSPI_Central_Hospital.transactions	transaction_batch_id
HSPI_Dewitt.charges	charge_batch_id
HSPI_Dewitt.claim_files	claim_batch_id
HSPI_Dewitt.claim_items	claim_batch_id
HSPI_Dewitt.claims	claim_batch_id
HSPI_Dewitt.claims_claim_batches_map	claim_batch_id
HSPI_Dewitt.fa_transaction_wrappers	transaction_batch_id
HSPI_Dewitt.invoice_batches_facilities_map	invoice_batch_id
HSPI_Dewitt.invoices	invoice_batch_id
HSPI_Dewitt.transaction_batch_financial_accounts	transaction_batch_id
HSPI_Dewitt.transactions	transaction_batch_id
HSPI_Fulton.charges	charge_batch_id
HSPI_Fulton.claim_files	claim_batch_id
HSPI_Fulton.claim_items	claim_batch_id
HSPI_Fulton.claims	claim_batch_id
HSPI_Fulton.claims_claim_batches_map	claim_batch_id
HSPI_Fulton.fa_transaction_wrappers	transaction_batch_id
HSPI_Fulton.invoice_batches_facilities_map	invoice_batch_id
HSPI_Fulton.invoices	invoice_batch_id
HSPI_Fulton.transaction_batch_financial_accounts	transaction_batch_id
HSPI_Fulton.transactions	transaction_batch_id
HSPI_Inferno.charges	charge_batch_id
HSPI_Inferno.claim_files	claim_batch_id
HSPI_Inferno.claim_items	claim_batch_id
HSPI_Inferno.claims	claim_batch_id
HSPI_Inferno.claims_claim_batches_map	claim_batch_id
HSPI_Inferno.fa_transaction_wrappers	transaction_batch_id
HSPI_Inferno.invoice_batches_facilities_map	invoice_batch_id
HSPI_Inferno.invoices	invoice_batch_id
HSPI_Inferno.transaction_batch_financial_accounts	transaction_batch_id
HSPI_Inferno.transactions	transaction_batch_id
HSPI_MU2015_E1.charges	charge_batch_id
HSPI_MU2015_E1.claim_files	claim_batch_id
HSPI_MU2015_E1.claim_items	claim_batch_id
HSPI_MU2015_E1.claims	claim_batch_id
HSPI_MU2015_E1.claims_claim_batches_map	claim_batch_id
HSPI_MU2015_E1.fa_transaction_wrappers	transaction_batch_id
HSPI_MU2015_E1.invoice_batches_facilities_map	invoice_batch_id
HSPI_MU2015_E1.invoices	invoice_batch_id
HSPI_MU2015_E1.transaction_batch_financial_accounts	transaction_batch_id
HSPI_MU2015_E1.transactions	transaction_batch_id
HSPI_MU2015_G2.charges	charge_batch_id
HSPI_MU2015_G2.claim_files	claim_batch_id
HSPI_MU2015_G2.claim_items	claim_batch_id
HSPI_MU2015_G2.claims	claim_batch_id
HSPI_MU2015_G2.claims_claim_batches_map	claim_batch_id
HSPI_MU2015_G2.fa_transaction_wrappers	transaction_batch_id
HSPI_MU2015_G2.invoice_batches_facilities_map	invoice_batch_id
HSPI_MU2015_G2.invoices	invoice_batch_id
HSPI_MU2015_G2.transaction_batch_financial_accounts	transaction_batch_id
HSPI_MU2015_G2.transactions	transaction_batch_id
HSPI_MU2015_G9.charges	charge_batch_id
HSPI_MU2015_G9.claim_files	claim_batch_id
HSPI_MU2015_G9.claim_items	claim_batch_id
HSPI_MU2015_G9.claims	claim_batch_id
HSPI_MU2015_G9.claims_claim_batches_map	claim_batch_id
HSPI_MU2015_G9.fa_transaction_wrappers	transaction_batch_id
HSPI_MU2015_G9.invoice_batches_facilities_map	invoice_batch_id
HSPI_MU2015_G9.invoices	invoice_batch_id
HSPI_MU2015_G9.transaction_batch_financial_accounts	transaction_batch_id
HSPI_MU2015_G9.transactions	transaction_batch_id
HSPI_Sandbox.charges	charge_batch_id
HSPI_Sandbox.claim_files	claim_batch_id
HSPI_Sandbox.claim_items	claim_batch_id
HSPI_Sandbox.claims	claim_batch_id
HSPI_Sandbox.claims_claim_batches_map	claim_batch_id
HSPI_Sandbox.fa_transaction_wrappers	transaction_batch_id
HSPI_Sandbox.invoice_batches_facilities_map	invoice_batch_id
HSPI_Sandbox.invoices	invoice_batch_id
HSPI_Sandbox.transaction_batch_financial_accounts	transaction_batch_id
HSPI_Sandbox.transactions	transaction_batch_id
HSPI_Summit_General.charges	charge_batch_id
HSPI_Summit_General.claim_files	claim_batch_id
HSPI_Summit_General.claim_items	claim_batch_id
HSPI_Summit_General.claims	claim_batch_id
HSPI_Summit_General.claims_claim_batches_map	claim_batch_id
HSPI_Summit_General.fa_transaction_wrappers	transaction_batch_id
HSPI_Summit_General.invoice_batches_facilities_map	invoice_batch_id
HSPI_Summit_General.invoices	invoice_batch_id
HSPI_Summit_General.transaction_batch_financial_accounts	transaction_batch_id
HSPI_Summit_General.transactions	transaction_batch_id
HSPI_United_Physicians.charges	charge_batch_id
HSPI_United_Physicians.claim_files	claim_batch_id
HSPI_United_Physicians.claim_items	claim_batch_id
HSPI_United_Physicians.claims	claim_batch_id
HSPI_United_Physicians.claims_claim_batches_map	claim_batch_id
HSPI_United_Physicians.fa_transaction_wrappers	transaction_batch_id
HSPI_United_Physicians.invoice_batches_facilities_map	invoice_batch_id
HSPI_United_Physicians.invoices	invoice_batch_id
HSPI_United_Physicians.transaction_batch_financial_accounts	transaction_batch_id
HSPI_United_Physicians.transactions	transaction_batch_id
MPI.charges	charge_batch_id
MPI.claim_files	claim_batch_id
MPI.claim_items	claim_batch_id
MPI.claims	claim_batch_id
MPI.claims_claim_batches_map	claim_batch_id
MPI.fa_transaction_wrappers	transaction_batch_id
MPI.invoice_batches_facilities_map	invoice_batch_id
MPI.invoices	invoice_batch_id
MPI.transaction_batch_financial_accounts	transaction_batch_id
MPI.transactions	transaction_batch_id
aurora_standard.hl7ft1	trans_batch_id
xlnt.selenium_test_queue	selenium_test_batch_id

units

Table	Column
Loinc.loinc_codes	lc_ipcc_units
Loinc.loinc_codes	lc_submitted_units
Loinc.loinc_codes	lc_example_units
Loinc.loinc_codes	lc_curated_range_and_units
Loinc.loinc_codes	lc_example_ucum_units
Loinc.loinc_codes	lc_example_si_ucum_units
Loinc.loinc_codes_example_units	lceu_example_units
_1.charts_cpt_codes	chcp_num_units
_1.charts_medications	cm_quantity_units
_1.charts_procedures	cp_num_units
_1.clients_fee_schedules_map	cfsm_num_units
_1.clinical_interventions_coded_attributes	cica_units
_1.clinical_interventions_lab_results_map	cilrm_units
_1.configured_encounters_templates_cpt_codes	cetcc_num_units
_1.encounters_cpt_codes	ecp_num_units
_1.encounters_cpt_codes_templates	ecpt_num_units
_1.hl7_results	res_observ_units
_1.labs_results	lr_observ_units
_1.patients_immunizations	pim_administered_units
_1.patients_immunizations_templates	pimt_administered_units
_1.patients_inventory	pinv_administered_units
_1.patients_medications	pms_quantity_units
_1.patients_prescriptions	prx_quantity_units
_1.patients_responsibility_estimates_services	prests_ndc_num_units
_1.patients_responsibility_estimates_services	prests_num_units
_1.patients_responsibility_estimates_services	prests_allowed_units
_1.precerts_cpt_codes	pcp_num_units
_1188.charts_cpt_codes	chcp_num_units
_1188.charts_medications	cm_quantity_units
_1188.charts_procedures	cp_num_units
_1188.clients_fee_schedules_map	cfsm_num_units
_1188.clinical_interventions_lab_results_map	cilrm_units
_1188.configured_encounters_templates_cpt_codes	cetcc_num_units
_1188.encounters_cpt_codes	ecp_num_units
_1188.encounters_cpt_codes_templates	ecpt_num_units
_1188.hl7_results	res_observ_units
_1188.labs_results	lr_observ_units
_1188.patients_immunizations	pim_administered_units
_1188.patients_immunizations_templates	pimt_administered_units
_1188.patients_inventory	pinv_administered_units
_1188.patients_medications	pms_quantity_units
_1188.patients_prescriptions	prx_quantity_units
_1188.patients_responsibility_estimates_services	prests_ndc_num_units
_1188.patients_responsibility_estimates_services	prests_num_units
_1188.patients_responsibility_estimates_services	prests_allowed_units
_1188.precerts_cpt_codes	pcp_num_units
_1218.charts_cpt_codes	chcp_num_units
_1218.charts_medications	cm_quantity_units
_1218.charts_procedures	cp_num_units
_1218.clients_fee_schedules_map	cfsm_num_units
_1218.clinical_interventions_lab_results_map	cilrm_units
_1218.configured_encounters_templates_cpt_codes	cetcc_num_units
_1218.encounters_cpt_codes	ecp_num_units
_1218.encounters_cpt_codes_templates	ecpt_num_units
_1218.hl7_results	res_observ_units
_1218.labs_results	lr_observ_units
_1218.patients_immunizations	pim_administered_units
_1218.patients_immunizations_templates	pimt_administered_units
_1218.patients_inventory	pinv_administered_units
_1218.patients_medications	pms_quantity_units
_1218.patients_prescriptions	prx_quantity_units
_1218.patients_responsibility_estimates_services	prests_ndc_num_units
_1218.patients_responsibility_estimates_services	prests_num_units
_1218.patients_responsibility_estimates_services	prests_allowed_units
_1218.precerts_cpt_codes	pcp_num_units
_1548.charts_cpt_codes	chcp_num_units
_1548.charts_medications	cm_quantity_units
_1548.charts_procedures	cp_num_units
_1548.clients_fee_schedules_map	cfsm_num_units
_1548.clinical_interventions_coded_attributes	cica_units
_1548.clinical_interventions_lab_results_map	cilrm_units
_1548.configured_encounters_templates_cpt_codes	cetcc_num_units
_1548.encounters_cpt_codes	ecp_num_units
_1548.encounters_cpt_codes_templates	ecpt_num_units
_1548.hl7_results	res_observ_units
_1548.labs_results	lr_observ_units
_1548.patients_immunizations	pim_administered_units
_1548.patients_immunizations_templates	pimt_administered_units
_1548.patients_inventory	pinv_administered_units
_1548.patients_medications	pms_quantity_units
_1548.patients_prescriptions	prx_quantity_units
_1548.patients_responsibility_estimates_services	prests_ndc_num_units
_1548.patients_responsibility_estimates_services	prests_num_units
_1548.patients_responsibility_estimates_services	prests_allowed_units
_1548.precerts_cpt_codes	pcp_num_units
_435.charts_cpt_codes	chcp_num_units
_435.charts_medications	cm_quantity_units
_435.charts_procedures	cp_num_units
_435.clients_fee_schedules_map	cfsm_num_units
_435.clinical_interventions_coded_attributes	cica_units
_435.clinical_interventions_lab_results_map	cilrm_units
_435.configured_encounters_templates_cpt_codes	cetcc_num_units
_435.encounters_cpt_codes	ecp_num_units
_435.encounters_cpt_codes_templates	ecpt_num_units
_435.hl7_results	res_observ_units
_435.labs_results	lr_observ_units
_435.patients_immunizations	pim_administered_units
_435.patients_immunizations_templates	pimt_administered_units
_435.patients_inventory	pinv_administered_units
_435.patients_medications	pms_quantity_units
_435.patients_prescriptions	prx_quantity_units
_435.patients_responsibility_estimates_services	prests_ndc_num_units
_435.patients_responsibility_estimates_services	prests_num_units
_435.precerts_cpt_codes	pcp_num_units
_436.charts_cpt_codes	chcp_num_units
_436.charts_medications	cm_quantity_units
_436.charts_procedures	cp_num_units
_436.clients_fee_schedules_map	cfsm_num_units
_436.clinical_interventions_coded_attributes	cica_units
_436.clinical_interventions_lab_results_map	cilrm_units
_436.configured_encounters_templates_cpt_codes	cetcc_num_units
_436.encounters_cpt_codes	ecp_num_units
_436.encounters_cpt_codes_templates	ecpt_num_units
_436.hl7_results	res_observ_units
_436.labs_results	lr_observ_units
_436.patients_immunizations	pim_administered_units
_436.patients_immunizations_templates	pimt_administered_units
_436.patients_inventory	pinv_administered_units
_436.patients_medications	pms_quantity_units
_436.patients_prescriptions	prx_quantity_units
_436.patients_responsibility_estimates_services	prests_ndc_num_units
_436.patients_responsibility_estimates_services	prests_num_units
_436.precerts_cpt_codes	pcp_num_units
_436_archive_testing.charts_cpt_codes	chcp_num_units
_436_archive_testing.charts_medications	cm_quantity_units
_436_archive_testing.charts_procedures	cp_num_units
_436_archive_testing.clients_fee_schedules_map	cfsm_num_units
_436_archive_testing.clinical_interventions_coded_attributes	cica_units
_436_archive_testing.clinical_interventions_lab_results_map	cilrm_units
_436_archive_testing.configured_encounters_templates_cpt_codes	cetcc_num_units
_436_archive_testing.encounters_cpt_codes	ecp_num_units
_436_archive_testing.encounters_cpt_codes_templates	ecpt_num_units
_436_archive_testing.hl7_results	res_observ_units
_436_archive_testing.labs_results	lr_observ_units
_436_archive_testing.patients_immunizations	pim_administered_units
_436_archive_testing.patients_immunizations_templates	pimt_administered_units
_436_archive_testing.patients_inventory	pinv_administered_units
_436_archive_testing.patients_medications	pms_quantity_units
_436_archive_testing.patients_prescriptions	prx_quantity_units
_436_archive_testing.patients_responsibility_estimates_services	prests_ndc_num_units
_436_archive_testing.patients_responsibility_estimates_services	prests_num_units
_436_archive_testing.precerts_cpt_codes	pcp_num_units
_437.charts_cpt_codes	chcp_num_units
_437.charts_medications	cm_quantity_units
_437.charts_procedures	cp_num_units
_437.clients_fee_schedules_map	cfsm_num_units
_437.clinical_interventions_coded_attributes	cica_units
_437.clinical_interventions_lab_results_map	cilrm_units
_437.configured_encounters_templates_cpt_codes	cetcc_num_units
_437.encounters_cpt_codes	ecp_num_units
_437.encounters_cpt_codes_templates	ecpt_num_units
_437.hl7_results	res_observ_units
_437.labs_results	lr_observ_units
_437.patients_immunizations	pim_administered_units
_437.patients_immunizations_templates	pimt_administered_units
_437.patients_inventory	pinv_administered_units
_437.patients_medications	pms_quantity_units
_437.patients_prescriptions	prx_quantity_units
_437.patients_responsibility_estimates_services	prests_ndc_num_units
_437.patients_responsibility_estimates_services	prests_num_units
_437.precerts_cpt_codes	pcp_num_units
_8.charts_cpt_codes	chcp_num_units
_8.charts_medications	cm_quantity_units
_8.charts_procedures	cp_num_units
_8.clients_fee_schedules_map	cfsm_num_units
_8.clinical_interventions_coded_attributes	cica_units
_8.clinical_interventions_lab_results_map	cilrm_units
_8.configured_encounters_templates_cpt_codes	cetcc_num_units
_8.daily_close_calculations	dcc_ecp_num_units
_8.encounters_cpt_codes	ecp_num_units
_8.encounters_cpt_codes_templates	ecpt_num_units
_8.hl7_results	res_observ_units
_8.labs_results	lr_observ_units
_8.patients_immunizations	pim_administered_units
_8.patients_immunizations_templates	pimt_administered_units
_8.patients_inventory	pinv_administered_units
_8.patients_medications	pms_quantity_units
_8.patients_prescriptions	prx_quantity_units
_8.patients_responsibility_estimates_services	prests_ndc_num_units
_8.patients_responsibility_estimates_services	prests_num_units
_8.patients_responsibility_estimates_services	prests_allowed_units
_8.precerts_cpt_codes	pcp_num_units
_81.charts_cpt_codes	chcp_num_units
_81.charts_medications	cm_quantity_units
_81.charts_procedures	cp_num_units
_81.clients_fee_schedules_map	cfsm_num_units
_81.clinical_interventions_lab_results_map	cilrm_units
_81.configured_encounters_templates_cpt_codes	cetcc_num_units
_81.encounters_cpt_codes	ecp_num_units
_81.encounters_cpt_codes_templates	ecpt_num_units
_81.hl7_results	res_observ_units
_81.labs_results	lr_observ_units
_81.patients_immunizations	pim_administered_units
_81.patients_immunizations_templates	pimt_administered_units
_81.patients_inventory	pinv_administered_units
_81.patients_medications	pms_quantity_units
_81.patients_prescriptions	prx_quantity_units
_81.patients_responsibility_estimates_services	prests_ndc_num_units
_81.patients_responsibility_estimates_services	prests_num_units
_81.patients_responsibility_estimates_services	prests_allowed_units
_81.precerts_cpt_codes	pcp_num_units
_999.charts_cpt_codes	chcp_num_units
_999.charts_medications	cm_quantity_units
_999.charts_procedures	cp_num_units
_999.clients_fee_schedules_map	cfsm_num_units
_999.clinical_interventions_coded_attributes	cica_units
_999.clinical_interventions_lab_results_map	cilrm_units
_999.configured_encounters_templates_cpt_codes	cetcc_num_units
_999.encounters_cpt_codes	ecp_num_units
_999.encounters_cpt_codes_templates	ecpt_num_units
_999.hl7_results	res_observ_units
_999.labs_results	lr_observ_units
_999.patients_immunizations	pim_administered_units
_999.patients_immunizations_templates	pimt_administered_units
_999.patients_inventory	pinv_administered_units
_999.patients_medications	pms_quantity_units
_999.patients_prescriptions	prx_quantity_units
_999.patients_responsibility_estimates_services	prests_ndc_num_units
_999.patients_responsibility_estimates_services	prests_num_units
_999.patients_responsibility_estimates_services	prests_allowed_units
_999.precerts_cpt_codes	pcp_num_units
aurora_standard.c7cdmrx	bill_units
aurora_standard.cachrg	chg_units
aurora_standard.cachrg2	chg_units
aurora_standard.cachrgca	chg_units
aurora_standard.cachrgevo	chg_units
aurora_standard.canullchrg	chg_units
aurora_standard.caroom	chg_units
aurora_standard.chmabstr	blood_units
aurora_standard.chmapcbr	cpt_units
aurora_standard.chmapcir	cpt_units
aurora_standard.choordmd	order_units
aurora_standard.choordrc	default_units
aurora_standard.chrordrr	dispense_units
aurora_standard.oeorder	order_units
common.loinc_codes	lc_ipcc_units
common.loinc_codes	lc_submitted_units
common.loinc_codes	lc_example_units
common.loinc_codes	lc_curated_range_and_units
common.loinc_codes	lc_example_ucum_units
common.loinc_codes	lc_example_si_ucum_units
common.test_codes_cpt	tcc_units
template_library.encounters_cpt_codes_templates	ecpt_num_units
template_library.patients_immunizations_templates	pimt_administered_units

location

Table	Column
_1.cpoe_responses	cpoe_res_location
_1.encounters_soap_vitals	espv_location
_1.hl7_accessions	acc_location
_1.patients_immunizations	pim_location
_1.precerts	pre_scheduled_location
_1.precerts_map	prem_location
_1.radiology_results	rad_res_location
_1188.cpoe_responses	cpoe_res_location
_1188.encounters_soap_vitals	espv_location
_1188.hl7_accessions	acc_location
_1188.patients_immunizations	pim_location
_1188.precerts	pre_scheduled_location
_1188.precerts_map	prem_location
_1188.radiology_results	rad_res_location
_1218.cpoe_responses	cpoe_res_location
_1218.encounters_soap_vitals	espv_location
_1218.hl7_accessions	acc_location
_1218.patients_immunizations	pim_location
_1218.precerts	pre_scheduled_location
_1218.precerts_map	prem_location
_1218.radiology_results	rad_res_location
_1548.cpoe_responses	cpoe_res_location
_1548.encounters_soap_vitals	espv_location
_1548.hl7_accessions	acc_location
_1548.patients_immunizations	pim_location
_1548.precerts	pre_scheduled_location
_1548.precerts_map	prem_location
_1548.radiology_results	rad_res_location
_435.cpoe_responses	cpoe_res_location
_435.encounters_soap_vitals	espv_location
_435.hl7_accessions	acc_location
_435.patients_immunizations	pim_location
_435.precerts	pre_scheduled_location
_435.precerts_map	prem_location
_435.radiology_results	rad_res_location
_436.cpoe_responses	cpoe_res_location
_436.encounters_soap_vitals	espv_location
_436.hl7_accessions	acc_location
_436.patients_immunizations	pim_location
_436.precerts	pre_scheduled_location
_436.precerts_map	prem_location
_436.radiology_results	rad_res_location
_436_archive_testing.cpoe_responses	cpoe_res_location
_436_archive_testing.encounters_soap_vitals	espv_location
_436_archive_testing.hl7_accessions	acc_location
_436_archive_testing.patients_immunizations	pim_location
_436_archive_testing.precerts	pre_scheduled_location
_436_archive_testing.precerts_map	prem_location
_436_archive_testing.radiology_results	rad_res_location
_437.cpoe_responses	cpoe_res_location
_437.encounters_soap_vitals	espv_location
_437.hl7_accessions	acc_location
_437.patients_immunizations	pim_location
_437.precerts	pre_scheduled_location
_437.precerts_map	prem_location
_437.radiology_results	rad_res_location
_8.cpoe_responses	cpoe_res_location
_8.encounters_soap_vitals	espv_location
_8.hl7_accessions	acc_location
_8.patients_immunizations	pim_location
_8.precerts	pre_scheduled_location
_8.precerts_map	prem_location
_8.radiology_results	rad_res_location
_81.cpoe_responses	cpoe_res_location
_81.encounters_soap_vitals	espv_location
_81.hl7_accessions	acc_location
_81.patients_immunizations	pim_location
_81.precerts	pre_scheduled_location
_81.precerts_map	prem_location
_81.radiology_results	rad_res_location
_999.cpoe_responses	cpoe_res_location
_999.encounters_soap_vitals	espv_location
_999.hl7_accessions	acc_location
_999.patients_immunizations	pim_location
_999.precerts	pre_scheduled_location
_999.precerts_map	prem_location
_999.radiology_results	rad_res_location
aurora_standard.bhguar	emp_location
aurora_standard.bhtguar	emp_location
aurora_standard.chpinsrd	class_location
aurora_standard.chplocac	class_location
aurora_standard.chqcmeud	cme_location
aurora_standard.chqletrd	letter_location
aurora_standard.chrcntrc	rx_location
aurora_standard.mergdocs	file_location
aurora_standard.mergsigs	file_location
aurora_standard.sthcadjd	stock_location
aurora_standard.sticadjd	stock_location
aurora_standard.stilocar	stock_location
aurora_standard.stipyxlc	rev_location
aurora_standard.stipyxlc	exp_location
aurora_standard.stistkld	stock_location
aurora_standard.stock2	stock_location
aurora_standard.stoshipd	stock_location
aurora_standard.tmplocar	stock_location

visit_no

Table	Column
aurora_standard.anotesd	an_visit_no
aurora_standard.bdfiled	bd_visit_no
aurora_standard.chmarsi	pat_visit_no
aurora_standard.chmcampi	pat_visit_no
aurora_standard.chmcombr	to_visit_no
aurora_standard.chmexmpi	pat_visit_no
aurora_standard.chmokipd	pat_visit_no
aurora_standard.chmokopd	pat_visit_no
aurora_standard.chmraded	pat_visit_no
aurora_standard.chmradex	pat_visit_no
aurora_standard.chrcombr	to_visit_no
aurora_standard.ncexmpi	pat_visit_no

row_no

Table	Column
aurora_standard.apsaging	apsar_row_no

last_name

Table	Column
aurora_standard.c7insur2	p_last_name
aurora_standard.c7insur3	p_last_name
aurora_standard.chm1500r	pat_last_name
aurora_standard.chmcmhed	pat_last_name
aurora_standard.chmstmtd	g_last_name

first_name

Table	Column
aurora_standard.c7insur2	p_first_name
aurora_standard.c7insur3	p_first_name
aurora_standard.chm1500r	pat_first_name
aurora_standard.chmcmhed	pat_first_name
aurora_standard.chmstmtd	g_first_name

chg_date

Table	Column
aurora_standard.chmbchgr	def_chg_date
aurora_standard.chmbitmr	def_chg_date

fac_no

Table	Column
aurora_standard.chmprica	prev_fac_no
aurora_standard.chmprica	cur_fac_no
aurora_standard.chpcashr	cash_fac_no
aurora_standard.chpcobpd	cash_fac_no
aurora_standard.chpcobpd	bal_fac_no
aurora_standard.chscustd	dept_fac_no
aurora_standard.chshotlr	dept_fac_no
aurora_standard.chtemplr	dflt_fac_no
aurora_standard.curs_temp	cash_fac_no
aurora_standard.curs_temp	ap_fac_no
aurora_standard.stgrowpd	rod_beg_fac_no
aurora_standard.stgrowpd	rod_end_fac_no
aurora_standard.stpcashd	dist_fac_no
aurora_standard.stpcashd	disc_fac_no
aurora_standard.stpcashe	cash_fac_no
aurora_standard.stpcntrc	cash_fac_no
aurora_standard.stpcntrc	disc_fac_no
aurora_standard.stpinvce	cash_fac_no
aurora_standard.stpopend	ap_fac_no
aurora_standard.stpopend	cash_fac_no
aurora_standard.stucntrc	cash_fac_no
aurora_standard.stuinvce	cash_fac_no
aurora_standard.stxfinsd	fin_fac_no
aurora_standard.styaccrr	liab_fac_no
aurora_standard.styaccrr	expense_fac_no
aurora_standard.styemplr	cash_fac_no
aurora_standard.stypayfd	cash_fac_no
aurora_standard.stypayod	bal_fac_no
aurora_standard.stypayre	cash_fac_no
aurora_standard.styrevsd	cash_fac_no
aurora_standard.stytyper	cash_fac_no