Identifier

tblHF.HfId / tblHF.HFCode / tblLocations.LocationId / tblLocations.LocationCode

FHIR location.mode field is used to switch between mapping from tblHF and tblLocations fields
HfId / LocationId is used as DB Primary Key, while mapping is being done to HFCode / LocationCode by

name

tblHF.HFName / tblLocatons.LocationName

FHIR location.mode field is used to switch between mapping from tblHF and tblLocations fields

type

tblHF.HFLevel / tblLocations.LocationType

FHIR location.mode field is used to switch between mapping from tblHF and tblLocations fields

Address

tblHF.HFAddress

partOfReference

tblHF.LocationId / tblLocations.ParentLocationId

FHIR location.mode field is used to switch between mapping from tblHF and tblLocations fields

telecom

tblHF.Phone / tblHF.Fax / tblHF.eMail

telecom field contains values that are being mapped for Phone, Fax and Email fields