Dictionary Tables

Facilities and Healthcare Areas dictionaries

(Tables: Facilities, HealthcareAreas)

The most important dictionaries of the LDR are the facilities and healthcare-area dictionaries. These dictionaries list all the laboratories and facilities that submit test requests to laboratories and classifies these facilities by type and by health-care region. A five level healthcare region is maintained in the Healthcare Area dictionaries to facilitate health management

• • Country

  • Province

  • Region

  • District

  • Sub-District

This facilitates the most commonly requested management reports. In addition, the Latitude and Longitude (GPS coordinates) of each facility and healthcare area are recorded to allow the data to be presented graphically as a map using a GIS.

There is more detailed information about the use of the Facilities and HealthcareAreas table on another page: Facilities and HealthcareAreas

HL7 Codes dictionaries

These dictionaries provide descriptions for all the coded fields derived from the HL7 standard. They include descriptions for abnormal flags, patient classes, results type and status and specimen sites and sources.

HL7 Tables:

• HL7AbnormalFlagCodes

• HL7EthnicGroupCodes

• HL7PatientClassCodes

• HL7ResultStatusCodes

• HL7ResultTypeCodes

• HL7SectionCodes

• HL7SexCodes

• HL7SpecimenSiteCodes

• HL7SpecimenSourceCodes

LOINC dictionary

(Table: LOINC)

The complete LOINC data set is maintained as an OpenLDR dictionary. This can be used for standardized naming, and to look up other aspects of laboratory tests provided by LOINC.

OpenLDR code dictionaries

(Tables: MDRCodes)

These dictionaries provide descriptions for all the coded fields used by OpenLDR that are not derived from the HL7, LOINC or SI standards. They include descriptions for multi-drug-resistant flags (MDRs).

Surveillance dictionary

(Table: Surveillance)

This dictionary defines the items that are used to provide surveillance reports using data from the monitoring data.

Analyzer dictionary

(Table: Analyzers)

This dictionary contains a list of all analyzers, including the manufacturer, serial number and date of installation - used for reports related to laboratory equipment.