QUESTIONNAIRERESPONSE
Description: Provides a complete or partial list of answers to a set of questions filled when responding to a questionnaire

Primary Key
Column Name Ordinal Position

Foreign Key
Column Name Ordinal Position Referenced Table
QUESTIONNAIREID 4 QUESTIONNAIRE
LKQUESTIONNAIRERESPONSESTATUSID 5 LKQUESTIONNAIRERESPONSESTATUS
ENCOUNTERID 8 ENCOUNTER
AUTHORDEVICEID 11 DEVICE
AUTHORORGANIZATIONID 15 ORGANIZATION
NOTEID 19 NOTE

Column Information
Name Type
1 QUESTIONNAIRERESPONSEID INT
Description: The unique Id for the QuestionnaireResponse table
Name Type
2 UUID UNIQUEIDENTIFIER
Description: The universally unique Id for the record
Name Type
3 FHIRLASTUPDATEDDATETIME DATETIME2
Description: Date and time when a FHIR property of the Questionnaire Response has been modified
Name Type
4 QUESTIONNAIREID INT
Description: QuestionnaireId is a foreign key to the Questionnaire table
Name Type
5 LKQUESTIONNAIRERESPONSESTATUSID INT
Description: LkQuestionnaireResponseStatusId is a foreign key to the LkQuestionnaireResponseStatus table
Name Type
6 EXPERIMENTAL BIT
Description: Questionnaire Response Experimental
Name Type
7 SUBJECTURL NVARCHAR
Description: Questionnaire Response Subject URL
Name Type
8 ENCOUNTERID INT
Description: EncounterId is a foreign key to the Encounter table
Name Type
9 AUTHOREDDATETIME DATETIME2
Description: Date and time the answers were gathered
Name Type
10 AUTHOREDDATETIMEOFFSET INT
Description: Authored time zone offset
Name Type
11 AUTHORDEVICEID INT
Description: AuthorDeviceId is a foreign key to the Device table
Name Type
15 AUTHORORGANIZATIONID INT
Description: AuthorOrganizationId is a foreign key to the Organization table
Name Type
19 NOTEID INT
Description: NoteId is a foreign key to the Note table
Name Type
20 LASTPDFRENDERVERSION INT
Description: Version of the PDF Render used to create the Questionnaire Response PDF file
Name Type
21 LASTTXTRENDERVERSION INT
Description: Version of the TXT render used to create the Questionnaire Response text file
Name Type
23 CREATED DATETIME2
Description: Record created time
Name Type
24 CREATEDTIMEZONEOFFSET INT
Description: Time zone Offset for Created time
Name Type
26 LASTMODIFIED DATETIME2
Description: Record Last Modified time
Name Type
27 LASTMODIFIEDTIMEZONEOFFSET INT
Description: Time zone Offset for Modified time