Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The FHIR Location will be used to represent the tblHF and tblLocations. The FHIR location.mode field can be used to distinguish between those object.

FHIR resource:

Location

Fields mapping:

OpenIMIS field

DB type

FHIR field

Description

Note

LocationId

PK

identifier

Unique code or number identifying the location to its users


LocationCode

nvarchar

identifier

Unique code or number identifying the location to its users


LocationName

nvarchar

name

Name of the location as used by humans


ParentLocationId

int

partOf - Reference(Location)

Another Location this one is physically part of


LocationType

nchar

type

R - Region
D - District
W - Municipality
V - Village


ValidityFrom

datetime


Audit information. More information can be found here (on page 113):
https://github.com/openimis/openimis_docs/blob/master/specs/Web%20application%20-%20Functional%20Design%20Specification.pdf

This information are valuable for OpenIMIS but probably not required by external systems.

ValidityTo

datetime


LegacyId

int


AuditUserId

int


RowId

timestamp



I'm not sure but this is probably some unique value used to distinguish database rows. Probably not useful for external systems.

MalePopulation

int



I'm not sure if those values are valuable for external systems.

FemalePopulation

int



OtherPopulation

int



Families

int