HSPI_Central_Hospital.location_identifiers_map

Field	Type	Null	Default	Key	Extra	Comment
location_id	char(36)	NO		PRI		(DC2Type:uuid)
identifier_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