Skip to main content

Lab Result Dataset Specification

Updated over a month ago

Lab Result Dataset Specification

Lab Result Dataset Specification

Overview

The "Lab Result Dataset Specification" is a critical tool for capturing and organizing laboratory test results within a healthcare system. This dataset is essential for tracking patient diagnostics, monitoring health conditions, and supporting clinical decisions by providing accurate and timely laboratory data.

Key Features

  • Lab Result Records: This table contains detailed information about each laboratory test conducted. It records the test type, date, results, and interpretations. This comprehensive documentation is vital for ensuring that healthcare professionals have access to all necessary data to assess patient health accurately.

  • Clinical Decision Support: This dataset plays a pivotal role in enhancing the management of laboratory data, ensuring that healthcare providers can make informed clinical decisions and effectively monitor patient health outcomes.

Lab Result Table Specification

Columns

Column Name

Is Nullable

Data Type

Description

Service_Date

YES

DATE

The date when the lab service was performed.

Member_ID

YES

STRING

ID of the member or patient associated with the lab result.

Membership_ID

YES

STRING

ID of the membership or insurance plan related to the lab result.

Ordering_Provider_ID

YES

STRING

ID of the provider who ordered the lab test.

Provider_ID

YES

STRING

ID of the provider who performed the lab test.

Ordering_Provider_NPI

YES

STRING

NPI (National Provider Identifier) of the provider who ordered the lab test.

Provider_NPI

YES

STRING

NPI of the provider who performed the lab test.

Custodian_Lab_Code

YES

STRING

Code identifying the lab or facility that holds the result data.

Custodian_Lab_Name

YES

STRING

Name of the lab or facility that holds the result data.

Lab_Order_ID

YES

STRING

Unique identifier for the lab order associated with the result.

Ordered_LOINC_Code

YES

STRING

Logical Observation Identifiers Names and Codes (LOINC) code for the ordered test.

Ordered_LOINC_Name

YES

STRING

Name or description of the ordered LOINC test.

Ordered_LOINC_Class_Code

YES

STRING

LOINC class code for the ordered test.

Ordered_LOINC_Class_Description

YES

STRING

Description of the LOINC class for the ordered test.

Ordered_LOINC_Component

YES

STRING

Component part of the LOINC code for the ordered test.

Ordered_LOINC_Long_Common_Description

YES

STRING

Long common name of the ordered LOINC test.

Ordered_LOINC_Short_Common_Description

YES

STRING

Short common name of the ordered LOINC test.

Ordered_LOINC_Source

YES

STRING

Source or system that provided the ordered LOINC code.

Result_Comments

YES

STRING

Any comments or additional information related to the lab result.

Performed_LOINC_Code

YES

STRING

LOINC code for the performed or resulted test.

Performed_LOINC_Name

YES

STRING

Name or description of the performed LOINC test.

Performed_LOINC_Class_Code

YES

STRING

LOINC class code for the performed test.

Performed_LOINC_Class_Description

YES

STRING

Description of the LOINC class for the performed test.

Performed_LOINC_Component

YES

STRING

Component part of the LOINC code for the performed test.

Performed_LOINC_Long_Common_Description

YES

STRING

Long common name of the performed LOINC test.

Performed_LOINC_Short_Common_Description

YES

STRING

Short common name of the performed LOINC test.

Performed_LOINC_Source

YES

STRING

Source or system that provided the performed LOINC code.

Observation_Date

YES

TIMESTAMP

The date when the lab result was observed or recorded.

Result_Units

YES

STRING

Units of measurement for the lab test result.

Result_Value_Numeric

YES

NUMERIC

Numeric value of the lab test result if applicable.

Result_Value_String

YES

STRING

String value of the lab test result if applicable.

Result_Value_Type

YES

STRING

Type of value recorded for the lab test result (numeric or string).

Interpretation_Code

YES

STRING

Code indicating the interpretation of the lab test result.

Interpretation_Description

YES

STRING

Description of the interpretation of the lab test result.

Reference_Range_Low

YES

NUMERIC

Lower limit of the reference range for the lab test result.

Reference_Range_High

YES

NUMERIC

Upper limit of the reference range for the lab test result.

Lab Result Raw Table Specification

Columns

Column Name

Is Nullable

Data Type

Description

Service_Date

YES

DATE

The date when the lab service was performed.

Member_ID

YES

STRING

ID of the member or patient associated with the lab result.

Membership_ID

YES

STRING

ID of the membership or insurance plan related to the lab result.

Ordering_Provider_ID

YES

STRING

ID of the provider who ordered the lab test.

Provider_ID

YES

STRING

ID of the provider who performed the lab test.

Ordering_Provider_NPI

YES

STRING

NPI (National Provider Identifier) of the provider who ordered the lab test.

Provider_NPI

YES

STRING

NPI of the provider who performed the lab test.

Custodian_Lab_Code

YES

STRING

Code identifying the lab or facility that holds the result data.

Custodian_Lab_Name

YES

STRING

Name of the lab or facility that holds the result data.

Lab_Order_ID

YES

STRING

Unique identifier for the lab order associated with the result.

Ordered_LOINC_Code

YES

STRING

Logical Observation Identifiers Names and Codes (LOINC) code for the ordered test.

Ordered_LOINC_Name

YES

STRING

Name or description of the ordered LOINC test.

Ordered_LOINC_Class_Code

YES

STRING

LOINC class code for the ordered test.

Ordered_LOINC_Class_Description

YES

STRING

Description of the LOINC class for the ordered test.

Lab Result Dataset Specification

Overview

The Lab Result Dataset contains detailed information about each laboratory test conducted. It records the test type, date, results, and interpretations. This comprehensive documentation is vital for ensuring that healthcare professionals have access to all necessary data to assess patient health accurately.

Table: Lab_Result

Columns

Column Name

Is Nullable

Data Type

Description

Service_Date

YES

DATE

The date when the lab service was performed.

Member_ID

YES

STRING

ID of the member or patient associated with the lab result.

Membership_ID

YES

STRING

ID of the membership or insurance plan related to the lab result.

Ordering_Provider_ID

YES

STRING

ID of the provider who ordered the lab test.

Provider_ID

YES

STRING

ID of the provider who performed the lab test.

Ordering_Provider_NPI

YES

STRING

NPI (National Provider Identifier) of the provider who ordered the lab test.

Provider_NPI

YES

STRING

NPI of the provider who performed the lab test.

Custodian_Lab_Code

YES

STRING

Code identifying the lab or facility that holds the result data.

Custodian_Lab_Name

YES

STRING

Name of the lab or facility that holds the result data.

Lab_Order_ID

YES

STRING

Unique identifier for the lab order associated with the result.

Ordered_LOINC_Code

YES

STRING

Logical Observation Identifiers Names and Codes (LOINC) code for the ordered test.

Ordered_LOINC_Name

YES

STRING

Name or description of the ordered LOINC test.

Ordered_LOINC_Class_Code

YES

STRING

LOINC class code for the ordered test.

Ordered_LOINC_Class_Description

YES

STRING

Description of the LOINC class for the ordered test.

Ordered_LOINC_Component

YES

STRING

Component part of the LOINC code for the ordered test.

Ordered_LOINC_Long_Common_Description

YES

STRING

Long common name of the ordered LOINC test.

Ordered_LOINC_Short_Common_Description

YES

STRING

Short common name of the ordered LOINC test.

Ordered_LOINC_Source

YES

STRING

Source or system that provided the ordered LOINC code.

Result_Comments

YES

STRING

Any comments or additional information related to the lab result.

Performed_LOINC_Code

YES

STRING

LOINC code for the performed or resulted test.

Performed_LOINC_Name

YES

STRING

Name or description of the performed LOINC test.

Performed_LOINC_Class_Code

YES

STRING

LOINC class code for the performed test.

Performed_LOINC_Class_Description

YES

STRING

Description of the LOINC class for the performed test.

Performed_LOINC_Component

YES

STRING

Component part of the LOINC code for the performed test.

Performed_LOINC_Long_Common_Description

YES

STRING

Long common name of the performed LOINC test.

Performed_LOINC_Short_Common_Description

YES

STRING

Short common name of the performed LOINC test.

Performed_LOINC_Source

YES

STRING

Source or system that provided the performed LOINC code.

Observation_Date

YES

TIMESTAMP

The date when the lab result was observed or recorded.

Result_Units

YES

STRING

Units of measurement for the lab test result.

Result_Value_Numeric

YES

NUMERIC

Numeric value of the lab test result if applicable.

Result_Value_String

YES

STRING

String value of the lab test result if applicable.

Result_Value_Type

YES

STRING

Type of value recorded for the lab test result (numeric or string).

Interpretation_Code

YES

STRING

Code indicating the interpretation of the lab test result.

Interpretation_Description

YES

STRING

Description of the interpretation of the lab test result.

Reference_Range_Low

YES

NUMERIC

Lower limit of the reference range for the lab test result.

Reference_Range_High

YES

NUMERIC

Upper limit of the reference range for the lab test result.

Type

YES

STRING

Type of lab test (e.g., blood, urine, etc.).

Tenant

YES

STRING

Identifier for the specific tenant or organization.

Active_Version

YES

BOOL

Version of the lab result data that is currently active.

Date

YES

DATE

Date associated with the lab result data.

Sequence

YES

INT64

Sequence number for the lab result data.

Source_System_Name

YES

STRING

Name of the system or application that generated the lab result data.

Source_Timestamp

YES

TIMESTAMP

Timestamp when the lab result data was generated.

Source_File_Name

YES

STRING

Name of the file containing the lab result data.

Schema_Version

YES

FLOAT64

Version of the schema or data model used for the lab result data.

Visibility_Level

YES

INT64

Level of visibility or access control for the lab result data.

Member_Partition

YES

INT64

Partition or segment of the member data (if applicable).

_updated

YES

STRING

Timestamp indicating when the record was last updated.

Notes

  • LOINC Codes: Logical Observation Identifiers Names and Codes (LOINC) are universal identifiers for laboratory and clinical observations.

  • Reference Range: The reference range provides the expected range of values for a lab test result, helping to interpret whether the result is normal or abnormal.

  • Interpretation Codes: These codes and descriptions provide context for the lab test results, indicating whether they are within normal limits, abnormal, or critical.

Lab Result Dataset Specification

Lab_Result Table

Columns

  • Performed_LOINC_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or description of the performed LOINC test.

  • Performed_LOINC_Class_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: LOINC class code for the performed test.

  • Performed_LOINC_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the LOINC class for the performed test.

  • Performed_LOINC_Component

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Component part of the LOINC code for the performed test.

  • Performed_LOINC_Long_Common_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Long common name of the performed LOINC test.

  • Performed_LOINC_Short_Common_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Short common name of the performed LOINC test.

  • Performed_LOINC_Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Source or system that provided the performed LOINC code.

  • Observation_Date

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date when the lab result was observed or recorded.

  • Result_Units

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Units of measurement for the lab test result.

  • Result_Value_Numeric

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Numeric value of the lab test result if applicable.

  • Result_Value_String

  • Is Nullable: YES

  • Data Type: STRING

  • Description: String value of the lab test result if applicable.

  • Result_Value_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of value recorded for the lab test result (numeric or string).

  • Interpretation_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code indicating the interpretation of the lab test result.

  • Interpretation_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the interpretation of the lab test result.

  • Reference_Range_Low

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Lower limit of the reference range for the lab test result.

  • Reference_Range_High

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Upper limit of the reference range for the lab test result.

Lab_Result_raw Table

Columns

  • Service_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when the lab service was performed.

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the member or patient associated with the lab result.

  • Membership_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the membership or insurance plan related to the lab result.

  • Ordering_Provider_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the provider who ordered the lab test.

  • Provider_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the provider who performed the lab test.

  • Ordering_Provider_NPI

  • Is Nullable: YES

  • Data Type: STRING

  • Description: NPI (National Provider Identifier) of the provider who ordered the lab test.

  • Provider_NPI

  • Is Nullable: YES

  • Data Type: STRING

  • Description: NPI of the provider who performed the lab test.

  • Custodian_Lab_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code identifying the lab or facility that holds the result data.

  • Custodian_Lab_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the lab or facility that holds the result data.

  • Lab_Order_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the lab order associated with the result.

  • Ordered_LOINC_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Logical Observation Identifiers Names and Codes (LOINC) code for the ordered test.

  • Ordered_LOINC_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or description of the ordered LOINC test.

  • Ordered_LOINC_Class_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: LOINC class code for the ordered test.

  • Ordered_LOINC_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the LOINC class for the ordered test.

  • Ordered_LOINC_Component

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Component part of the LOINC code for the ordered test.

  • Ordered_LOINC_Long_Common_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Long common name of the ordered LOINC test.

  • Ordered_LOINC_Short_Common_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Short common name of the ordered LOINC test.

  • Ordered_LOINC_Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Source or system that provided the ordered LOINC code.

  • Result_Comments

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Any comments or additional information related to the lab result.

  • Performed_LOINC_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: LOINC code for the performed or resulted test.

  • Performed_LOINC_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or description of the performed LOINC test.

  • Performed_LOINC_Class_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: LOINC class code for the performed test.

  • Performed_LOINC_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the LOINC class for the performed test.

  • Performed_LOINC_Component

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Component part of the LOINC code for the performed test.

  • Performed_LOINC_Long_Common_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Long common name of the performed LOINC test.

  • Performed_LOINC_Short_Common_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Short common name of the performed LOINC test.

  • Performed_LOINC_Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Source or system that provided the performed LOINC code.

  • Observation_Date

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date when the lab result was observed or recorded.

  • Result_Units

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Units of measurement for the lab test result.

  • Result_Value_Numeric

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Numeric value of the lab test result if applicable.

  • Result_Value_String

  • Is Nullable: YES

  • Data Type: STRING

  • Description: String value of the lab test result if applicable.

  • Result_Value_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of value recorded for the lab test result (numeric or string).

  • Interpretation_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code indicating the interpretation of the lab test result.

  • Interpretation_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the interpretation of the lab test result.

  • Reference_Range_Low

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Lower limit of the reference range for the lab test result.

  • Reference_Range_High

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Upper limit of the reference range for the lab test result.

Lab Result Dataset Specification

Lab_Result_raw Fields

Type

  • Required: YES

  • Data Type: STRING

  • Description: Type of lab test (e.g., blood, urine, etc.).

Tenant

  • Required: YES

  • Data Type: STRING

  • Description: Identifier for the specific tenant or organization.

Active_Version

  • Required: YES

  • Data Type: BOOL

  • Description: Version of the lab result data that is currently active.

Date

  • Required: YES

  • Data Type: DATE

  • Description: Date associated with the lab result data.

Sequence

  • Required: YES

  • Data Type: INT64

  • Description: Sequence number for the lab result data.

Source_System_Name

  • Required: YES

  • Data Type: STRING

  • Description: Name of the system or application that generated the lab result data.

Source_Timestamp

  • Required: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the lab result data was generated.

Source_File_Name

  • Required: YES

  • Data Type: STRING

  • Description: Name of the file containing the lab result data.

Schema_Version

  • Required: YES

  • Data Type: FLOAT64

  • Description: Version of the schema or data model used for the lab result data.

Visibility_Level

  • Required: YES

  • Data Type: INT64

  • Description: Level of visibility or access control for the lab result data.

Member_Partition

  • Required: YES

  • Data Type: INT64

  • Description: Partition or segment of the member data (if applicable).

_updated

  • Required: YES

  • Data Type: STRING

  • Description: Timestamp indicating when the record was last updated.

Related Articles
Dictionary Dataset Specification
Dictionary Dataset Specification D L
Assessment Dataset Specification
Notification Dataset Specification
Dictionary Dataset Specification M Q
Did this answer your question?