DOCUMENTREFERENCE
Description: A reference to a document of any kind for any purpose which includes meta data about the document so it can be discovered and managed

Primary Key
Column Name Ordinal Position

Foreign Key
Column Name Ordinal Position Referenced Table
LKDOCUMENTREFERENCESTATUSID 4 LKDOCUMENTREFERENCESTATUS
PATIENTID 5 PATIENT
PRACTITIONERID 6 PRACTITIONER
DEVICEID 7 DEVICE
ORGANIZATIONID 8 ORGANIZATION
ENCOUNTERID 9 ENCOUNTER
PROVENANCEID 17 PROVENANCE

Column Information
Name Type
1 DOCUMENTREFERENCEID INT
Description: The unique Id for the DocumentReference table
Name Type
2 UUID UNIQUEIDENTIFIER
Description: The universally unique Id for the record
Name Type
3 DESCRIPTION NVARCHAR
Description: Detailed Description
Name Type
4 LKDOCUMENTREFERENCESTATUSID INT
Description: LkDocumentReferenceStatusId is a foreign key to the LkDocumentReferenceStatus table
Name Type
5 PATIENTID INT
Description: PatientId is a foreign key to the Patient table
Name Type
6 PRACTITIONERID INT
Description: PractitionerId is a foreign key to the Practitioner table
Name Type
7 DEVICEID INT
Description: DeviceId is a foreign key to the Device table
Name Type
8 ORGANIZATIONID INT
Description: OrganizationId is a foreign key to the Organization table
Name Type
9 ENCOUNTERID INT
Description: EncounterId is a foreign key to the Encounter table
Name Type
11 CREATED DATETIME2
Description: Record created time
Name Type
12 CREATEDTIMEZONEOFFSET INT
Description: Time zone Offset for Created time
Name Type
14 LASTMODIFIED DATETIME2
Description: Record Last Modified time
Name Type
15 LASTMODIFIEDTIMEZONEOFFSET INT
Description: Time zone Offset for Modified time
Name Type
16 LKREGDOCUMENTTYPEID INT
Description: LkRegDocumentTypeId is a foreign key to the LkRegDocumentType table
Name Type
17 PROVENANCEID INT
Description: ProvenanceId is a foreign key to the Provenance table