Column Name	Ordinal Position

Column Name	Ordinal Position	Referenced Table
LKVALUETYPEID	2	LKVALUETYPE
LOWVALUEID	3	VALUE
HIGHVALUEID	4	VALUE
QUANTITYID	7	QUANTITY
MEDIAID	13	MEDIA
DOCUMENTREFERENCEID	14	DOCUMENTREFERENCE

	Name	Type
1	VALUEID	INT
	Description: The unique Id for the Value table

	Name	Type
2	LKVALUETYPEID	INT
	Description: LkValueTypeId is a foreign key to the LkValueType table

	Name	Type
3	LOWVALUEID	INT
	Description: LowValueId is a foreign key to the Value table

	Name	Type
4	HIGHVALUEID	INT
	Description: HighValueId is a foreign key to the Value table

	Name	Type
5	VALUE	NVARCHAR
	Description: Observed value (result)

	Name	Type
6	BOOLEAN	BIT
	Description: Flag to indicate if the value is a boolean

	Name	Type
7	QUANTITYID	INT
	Description: QuantityId is a foreign key to the Quantity table

	Name	Type
8	YEAR	INT
	Description: Year used if value is a date type

	Name	Type
9	MONTH	INT
	Description: Month used if value is a date type

	Name	Type
10	DAY	INT
	Description: Day used if value is a date type

	Name	Type
11	TIME	TIME
	Description: Time used if value is a datetime type

	Name	Type
12	TIMEZONEOFFSET	INT
	Description: Time zone offset used if value is a datetime type

	Name	Type
13	MEDIAID	INT
	Description: MediaId is a foreign key to the Media table

	Name	Type
14	DOCUMENTREFERENCEID	INT
	Description: DocumentReferenceId is a foreign key to the DocumentReference table

	Name	Type
15	CODEABLECONCEPTTEXT	NVARCHAR
	Description: Text used if value is a codable concept

	Name	Type
16	INTERNALUSEFORMERGEFK	INT
	Description: Used to store a temporary Id to prevent the use of a sql merge