HSPI_Sandbox.transaction_codes_locations_map

Field	Type	Null	Default	Key	Extra	Comment
transaction_code_id	int(11)	NO		PRI
location_id	char(36)	NO		PRI		(DC2Type:uuid)

References

Local Column

References

location_id

Table	Column
HSPI_Bastrop.PatientTracking	bed_location_id
HSPI_Bastrop.patient_tracking	bed_location_id
HSPI_CURES2015_B1.patient_tracking	bed_location_id
HSPI_Central_Hospital.patient_tracking	bed_location_id
HSPI_Dewitt.patient_tracking	bed_location_id
HSPI_Fulton.patient_tracking	bed_location_id
HSPI_Inferno.patient_tracking	bed_location_id
HSPI_MU2015_E1.patient_tracking	bed_location_id
HSPI_MU2015_G2.patient_tracking	bed_location_id
HSPI_MU2015_G9.patient_tracking	bed_location_id
HSPI_Sandbox.patient_tracking	bed_location_id
HSPI_Summit_General.patient_tracking	bed_location_id
HSPI_United_Physicians.patient_tracking	bed_location_id
MPI.patient_tracking	bed_location_id
_1.inventory	inv_administered_location_id
_1.patients_immunizations	pim_location_id
_1.patients_inventory	pinv_administered_location_id
_1188.inventory	inv_administered_location_id
_1188.patients_immunizations	pim_location_id
_1188.patients_inventory	pinv_administered_location_id
_1218.inventory	inv_administered_location_id
_1218.patients_immunizations	pim_location_id
_1218.patients_inventory	pinv_administered_location_id
_1548.inventory	inv_administered_location_id
_1548.patients_immunizations	pim_location_id
_1548.patients_inventory	pinv_administered_location_id
_435.inventory	inv_administered_location_id
_435.patients_immunizations	pim_location_id
_435.patients_inventory	pinv_administered_location_id
_436.inventory	inv_administered_location_id
_436.patients_immunizations	pim_location_id
_436.patients_inventory	pinv_administered_location_id
_436_archive_testing.inventory	inv_administered_location_id
_436_archive_testing.patients_immunizations	pim_location_id
_436_archive_testing.patients_inventory	pinv_administered_location_id
_437.inventory	inv_administered_location_id
_437.patients_immunizations	pim_location_id
_437.patients_inventory	pinv_administered_location_id
_8.inventory	inv_administered_location_id
_8.patients_immunizations	pim_location_id
_8.patients_inventory	pinv_administered_location_id
_81.inventory	inv_administered_location_id
_81.patients_immunizations	pim_location_id
_81.patients_inventory	pinv_administered_location_id
_999.inventory	inv_administered_location_id
_999.patients_immunizations	pim_location_id
_999.patients_inventory	pinv_administered_location_id

transaction_code_id

Table	Column
HSPI_Bastrop.charge_master_codes	outpatient_transaction_code_id
HSPI_Bastrop.charge_master_codes	inpatient_transaction_code_id
HSPI_Bastrop.charge_master_codes	snf_transaction_code_id
HSPI_Bastrop.charge_master_codes	ltc_transaction_code_id
HSPI_Bastrop.eob_claim_services	amount_paid_transaction_code_id
HSPI_Bastrop.eob_claims	amount_paid_transaction_code_id
HSPI_Bastrop.transaction_batches	default_charge_transaction_code_id
HSPI_Bastrop.transaction_batches	default_payment_transaction_code_id
HSPI_Bastrop.transaction_batches	default_adjustment_transaction_code_id
HSPI_CURES2015_B1.charge_master_codes	outpatient_transaction_code_id
HSPI_CURES2015_B1.charge_master_codes	inpatient_transaction_code_id
HSPI_CURES2015_B1.charge_master_codes	snf_transaction_code_id
HSPI_CURES2015_B1.charge_master_codes	ltc_transaction_code_id
HSPI_CURES2015_B1.charge_master_codes	npc_transaction_code_id
HSPI_CURES2015_B1.eob_claim_services	amount_paid_transaction_code_id
HSPI_CURES2015_B1.eob_claims	amount_paid_transaction_code_id
HSPI_CURES2015_B1.transaction_batches	default_charge_transaction_code_id
HSPI_CURES2015_B1.transaction_batches	default_payment_transaction_code_id
HSPI_CURES2015_B1.transaction_batches	default_adjustment_transaction_code_id
HSPI_Central_Hospital.charge_master_codes	outpatient_transaction_code_id
HSPI_Central_Hospital.charge_master_codes	inpatient_transaction_code_id
HSPI_Central_Hospital.charge_master_codes	snf_transaction_code_id
HSPI_Central_Hospital.charge_master_codes	ltc_transaction_code_id
HSPI_Central_Hospital.charge_master_codes	npc_transaction_code_id
HSPI_Central_Hospital.eob_claim_services	amount_paid_transaction_code_id
HSPI_Central_Hospital.eob_claims	amount_paid_transaction_code_id
HSPI_Central_Hospital.transaction_batches	default_charge_transaction_code_id
HSPI_Central_Hospital.transaction_batches	default_payment_transaction_code_id
HSPI_Central_Hospital.transaction_batches	default_adjustment_transaction_code_id
HSPI_Dewitt.charge_master_codes	outpatient_transaction_code_id
HSPI_Dewitt.charge_master_codes	inpatient_transaction_code_id
HSPI_Dewitt.charge_master_codes	snf_transaction_code_id
HSPI_Dewitt.charge_master_codes	ltc_transaction_code_id
HSPI_Dewitt.charge_master_codes	npc_transaction_code_id
HSPI_Dewitt.eob_claim_services	amount_paid_transaction_code_id
HSPI_Dewitt.eob_claims	amount_paid_transaction_code_id
HSPI_Dewitt.transaction_batches	default_charge_transaction_code_id
HSPI_Dewitt.transaction_batches	default_payment_transaction_code_id
HSPI_Dewitt.transaction_batches	default_adjustment_transaction_code_id
HSPI_Fulton.charge_master_codes	outpatient_transaction_code_id
HSPI_Fulton.charge_master_codes	inpatient_transaction_code_id
HSPI_Fulton.charge_master_codes	snf_transaction_code_id
HSPI_Fulton.charge_master_codes	ltc_transaction_code_id
HSPI_Fulton.charge_master_codes	npc_transaction_code_id
HSPI_Fulton.eob_claim_services	amount_paid_transaction_code_id
HSPI_Fulton.eob_claims	amount_paid_transaction_code_id
HSPI_Fulton.transaction_batches	default_charge_transaction_code_id
HSPI_Fulton.transaction_batches	default_payment_transaction_code_id
HSPI_Fulton.transaction_batches	default_adjustment_transaction_code_id
HSPI_Inferno.charge_master_codes	outpatient_transaction_code_id
HSPI_Inferno.charge_master_codes	inpatient_transaction_code_id
HSPI_Inferno.charge_master_codes	snf_transaction_code_id
HSPI_Inferno.charge_master_codes	ltc_transaction_code_id
HSPI_Inferno.charge_master_codes	npc_transaction_code_id
HSPI_Inferno.eob_claim_services	amount_paid_transaction_code_id
HSPI_Inferno.eob_claims	amount_paid_transaction_code_id
HSPI_Inferno.transaction_batches	default_charge_transaction_code_id
HSPI_Inferno.transaction_batches	default_payment_transaction_code_id
HSPI_Inferno.transaction_batches	default_adjustment_transaction_code_id
HSPI_MU2015_E1.charge_master_codes	outpatient_transaction_code_id
HSPI_MU2015_E1.charge_master_codes	inpatient_transaction_code_id
HSPI_MU2015_E1.charge_master_codes	snf_transaction_code_id
HSPI_MU2015_E1.charge_master_codes	ltc_transaction_code_id
HSPI_MU2015_E1.charge_master_codes	npc_transaction_code_id
HSPI_MU2015_E1.eob_claim_services	amount_paid_transaction_code_id
HSPI_MU2015_E1.eob_claims	amount_paid_transaction_code_id
HSPI_MU2015_E1.transaction_batches	default_charge_transaction_code_id
HSPI_MU2015_E1.transaction_batches	default_payment_transaction_code_id
HSPI_MU2015_E1.transaction_batches	default_adjustment_transaction_code_id
HSPI_MU2015_G2.charge_master_codes	outpatient_transaction_code_id
HSPI_MU2015_G2.charge_master_codes	inpatient_transaction_code_id
HSPI_MU2015_G2.charge_master_codes	snf_transaction_code_id
HSPI_MU2015_G2.charge_master_codes	ltc_transaction_code_id
HSPI_MU2015_G2.charge_master_codes	npc_transaction_code_id
HSPI_MU2015_G2.eob_claim_services	amount_paid_transaction_code_id
HSPI_MU2015_G2.eob_claims	amount_paid_transaction_code_id
HSPI_MU2015_G2.transaction_batches	default_charge_transaction_code_id
HSPI_MU2015_G2.transaction_batches	default_payment_transaction_code_id
HSPI_MU2015_G2.transaction_batches	default_adjustment_transaction_code_id
HSPI_MU2015_G9.charge_master_codes	outpatient_transaction_code_id
HSPI_MU2015_G9.charge_master_codes	inpatient_transaction_code_id
HSPI_MU2015_G9.charge_master_codes	snf_transaction_code_id
HSPI_MU2015_G9.charge_master_codes	ltc_transaction_code_id
HSPI_MU2015_G9.charge_master_codes	npc_transaction_code_id
HSPI_MU2015_G9.eob_claim_services	amount_paid_transaction_code_id
HSPI_MU2015_G9.eob_claims	amount_paid_transaction_code_id
HSPI_MU2015_G9.transaction_batches	default_charge_transaction_code_id
HSPI_MU2015_G9.transaction_batches	default_payment_transaction_code_id
HSPI_MU2015_G9.transaction_batches	default_adjustment_transaction_code_id
HSPI_Sandbox.charge_master_codes	outpatient_transaction_code_id
HSPI_Sandbox.charge_master_codes	inpatient_transaction_code_id
HSPI_Sandbox.charge_master_codes	snf_transaction_code_id
HSPI_Sandbox.charge_master_codes	ltc_transaction_code_id
HSPI_Sandbox.charge_master_codes	npc_transaction_code_id
HSPI_Sandbox.eob_claim_services	amount_paid_transaction_code_id
HSPI_Sandbox.eob_claims	amount_paid_transaction_code_id
HSPI_Sandbox.transaction_batches	default_charge_transaction_code_id
HSPI_Sandbox.transaction_batches	default_payment_transaction_code_id
HSPI_Sandbox.transaction_batches	default_adjustment_transaction_code_id
HSPI_Summit_General.charge_master_codes	outpatient_transaction_code_id
HSPI_Summit_General.charge_master_codes	inpatient_transaction_code_id
HSPI_Summit_General.charge_master_codes	snf_transaction_code_id
HSPI_Summit_General.charge_master_codes	ltc_transaction_code_id
HSPI_Summit_General.charge_master_codes	npc_transaction_code_id
HSPI_Summit_General.eob_claim_services	amount_paid_transaction_code_id
HSPI_Summit_General.eob_claims	amount_paid_transaction_code_id
HSPI_Summit_General.transaction_batches	default_charge_transaction_code_id
HSPI_Summit_General.transaction_batches	default_payment_transaction_code_id
HSPI_Summit_General.transaction_batches	default_adjustment_transaction_code_id
HSPI_United_Physicians.charge_master_codes	outpatient_transaction_code_id
HSPI_United_Physicians.charge_master_codes	inpatient_transaction_code_id
HSPI_United_Physicians.charge_master_codes	snf_transaction_code_id
HSPI_United_Physicians.charge_master_codes	ltc_transaction_code_id
HSPI_United_Physicians.charge_master_codes	npc_transaction_code_id
HSPI_United_Physicians.eob_claim_services	amount_paid_transaction_code_id
HSPI_United_Physicians.eob_claims	amount_paid_transaction_code_id
HSPI_United_Physicians.transaction_batches	default_charge_transaction_code_id
HSPI_United_Physicians.transaction_batches	default_payment_transaction_code_id
HSPI_United_Physicians.transaction_batches	default_adjustment_transaction_code_id
MPI.charge_master_codes	outpatient_transaction_code_id
MPI.charge_master_codes	inpatient_transaction_code_id
MPI.charge_master_codes	snf_transaction_code_id
MPI.charge_master_codes	ltc_transaction_code_id
MPI.charge_master_codes	npc_transaction_code_id
MPI.eob_claim_services	amount_paid_transaction_code_id
MPI.eob_claims	amount_paid_transaction_code_id
MPI.transaction_batches	default_charge_transaction_code_id
MPI.transaction_batches	default_payment_transaction_code_id
MPI.transaction_batches	default_adjustment_transaction_code_id