Column Name	Ordinal Position

Column Name	Ordinal Position	Referenced Table
LKDIAGNOSTICREPORTSTATUSID	4	LKDIAGNOSTICREPORTSTATUS
ENCOUNTERID	5	ENCOUNTER
CONCLUSIONNOTEID	13	NOTE
PROVENANCEID	14	PROVENANCE
LKENTEREDINERRORREASONID	15	LKENTEREDINERRORREASON

	Name	Type
1	DIAGNOSTICREPORTID	INT
	Description: The unique Id for the DiagnosticReport table

	Name	Type
2	UUID	UNIQUEIDENTIFIER
	Description: The universally unique Id for the record

	Name	Type
3	FHIRLASTUPDATEDDATETIME	DATETIME2
	Description: The last updated datetime for the FHIR resource

	Name	Type
4	LKDIAGNOSTICREPORTSTATUSID	INT
	Description: LkDiagnosticReportStatusId is a foreign key to the LkDiagnosticReportStatus table

	Name	Type
5	ENCOUNTERID	INT
	Description: EncounterId is a foreign key to the Encounter table

	Name	Type
6	CODINGTEXT	NVARCHAR
	Description: Text copy of the coding

	Name	Type
7	EFFECTIVEDATETIME	DATETIME2
	Description: The time the record was documented

	Name	Type
8	EFFECTIVEDATETIMEOFFSET	INT
	Description: The user time zone offset at the time the record was documented

	Name	Type
9	EFFECTIVEENDDATETIME	DATETIME2
	Description: The time the record was documented as complete

	Name	Type
10	EFFECTIVEENDDATETIMEOFFSET	INT
	Description: The user time zone offset at the time the record was documented as complete

	Name	Type
11	ISSUEDDATETIME	DATETIME2
	Description: The time the record was issued

	Name	Type
12	ISSUEDDATETIMEOFFSET	INT
	Description: The user time zone offset at the time the record was issued

	Name	Type
13	CONCLUSIONNOTEID	INT
	Description: ConclusionNoteId is a foreign key to the Note table

	Name	Type
14	PROVENANCEID	INT
	Description: ProvenanceId is a foreign key to the Provenance table

	Name	Type
15	LKENTEREDINERRORREASONID	INT
	Description: LkEnteredInErrorReasonId is a foreign key to the LkEnteredInErrorReason table

	Name	Type
16	LASTMODIFIEDDATETIME	DATETIME2
	Description: Record Last Modified time

	Name	Type
17	LASTMODIFIEDDATETIMEOFFSET	INT
	Description: Time zone Offset for Modified time