Column Name	Ordinal Position

Column Name	Ordinal Position	Referenced Table
LKOBSERVATIONCATEGORYID	6	LKOBSERVATIONCATEGORY
LKOBSERVATIONDEFINITIONDATATYPEID	8	LKOBSERVATIONDEFINITIONDATATYPE
PANELOBSERVATIONDEFINITIONID	16	OBSERVATIONDEFINITION

	Name	Type
1	OBSERVATIONDEFINITIONID	INT
	Description: The unique Id for the ObservationDefinition table

	Name	Type
2	UUID	UNIQUEIDENTIFIER
	Description: The Unique Identifier of the Observation Definition

	Name	Type
3	FHIRLASTUPDATEDDATETIME	DATETIMEOFFSET
	Description: The Last time the Observation Definition was Updated

	Name	Type
4	NAME	NVARCHAR
	Description: The Name of the Observation Definition

	Name	Type
5	ABBREVIATION	NVARCHAR
	Description: The Abbreviation of the Observation Definition

	Name	Type
6	LKOBSERVATIONCATEGORYID	INT
	Description: LkObservationCategoryId is a foreign key to the LkObservationCategory table

	Name	Type
7	LKLOINCID	INT
	Description: The Loinc Id of the Observation Definition

	Name	Type
8	LKOBSERVATIONDEFINITIONDATATYPEID	INT
	Description: LkObservationDefinitionDataTypeId is a foreign key to the LkObservationDefinitionDataType table

	Name	Type
9	MULTIPLERESULTSALLOWED	BIT
	Description: If Multiple Results are Allowed for the Observation Definition

	Name	Type
10	METHODLKSNOMEDID	INT
	Description: The Snomed Id for the Method

	Name	Type
11	PREFERREDREPORTNAME	NVARCHAR
	Description: The Preferred Report Name

	Name	Type
12	QUANTITATIVERESULTLKUNITID	INT
	Description: The Unit for the Quantitative Result

	Name	Type
13	QUANTITATIVERESULTSYSTEM	NVARCHAR
	Description: The System for the Quantitative Result

	Name	Type
14	QUANTITATIVERESULTCODE	NVARCHAR
	Description: The Code for the Quantitative Result

	Name	Type
15	QUANTITATIVERESULTSDECIMALPRECISION	INT
	Description: The Decimal Precision for the Quantitative Result

	Name	Type
16	PANELOBSERVATIONDEFINITIONID	INT
	Description: PanelObservationDefinitionId is a foreign key to the ObservationDefinition table