Column Name	Ordinal Position

Column Name	Ordinal Position	Referenced Table
LKQUESTIONNAIREQUESTIONALIGNMENTID	11	LKQUESTIONNAIREQUESTIONALIGNMENT
LKQUESTIONNAIREVIEWTYPEID	12	LKQUESTIONNAIREVIEWTYPE
LKQUESTIONNAIRETAGID	13	LKQUESTIONNAIRETAG
QUESTIONNAIRESUBTAGID	14	QUESTIONNAIRESUBTAG
COPIEDFROMID	15	QUESTIONNAIRE
PARENTQUESTIONNAIREID	16	QUESTIONNAIRE
LKVOICERECOGNITIONTOPICID	17	LKVOICERECOGNITIONTOPIC
QUESTIONNAIREFAMILYID	18	QUESTIONNAIREFAMILY
LKQUESTIONNAIRETYPEID	19	LKQUESTIONNAIRETYPE

	Name	Type
1	QUESTIONNAIREID	INT
	Description: The unique Id for the Questionnaire table

	Name	Type
2	UUID	UNIQUEIDENTIFIER
	Description: Unique Identifier

	Name	Type
3	NAME	NVARCHAR
	Description: Name of the Questionnaire

	Name	Type
4	VERSION	INT
	Description: The incremental version of the Questionnaire

	Name	Type
5	DESCRIPTION	NVARCHAR
	Description: Detailed Description

	Name	Type
6	ISACTIVE	BIT
	Description: True when a questionnaire is Active

	Name	Type
7	ISLOCKED	BIT
	Description: True when a questionnaire is locked and cannot be modified

	Name	Type
8	ISDRAFT	BIT
	Description: True when a questionnaire is draft When set the false the questionnaire is published

	Name	Type
9	CARRYFORWARDHOURS	INT
	Description: Max number of hours that a Note created with the questionnaire can be carried forward

	Name	Type
10	CARRYFORWARDDISPLAYFORMAT	NCHAR
	Description: Format used to display the Carry Forward Hours in the Questionnaire Library UI

	Name	Type
11	LKQUESTIONNAIREQUESTIONALIGNMENTID	INT
	Description: LkQuestionnaireQuestionAlignmentId is a foreign key to the LkQuestionnaireQuestionAlignment table

	Name	Type
12	LKQUESTIONNAIREVIEWTYPEID	INT
	Description: LkQuestionnaireViewTypeId is a foreign key to the LkQuestionnaireViewType table

	Name	Type
13	LKQUESTIONNAIRETAGID	INT
	Description: LkQuestionnaireTagId is a foreign key to the LkQuestionnaireTag table

	Name	Type
14	QUESTIONNAIRESUBTAGID	INT
	Description: QuestionnaireSubTagId is a foreign key to the QuestionnaireSubTag table

	Name	Type
15	COPIEDFROMID	INT
	Description: CopiedFromId is a foreign key to the Questionnaire table

	Name	Type
16	PARENTQUESTIONNAIREID	INT
	Description: ParentQuestionnaireId is a foreign key to the Questionnaire table

	Name	Type
17	LKVOICERECOGNITIONTOPICID	INT
	Description: LkVoiceRecognitionTopicId is a foreign key to the LkVoiceRecognitionTopic table

	Name	Type
18	QUESTIONNAIREFAMILYID	INT
	Description: QuestionnaireFamilyId is a foreign key to the QuestionnaireFamily table

	Name	Type
19	LKQUESTIONNAIRETYPEID	INT
	Description: LkQuestionnaireTypeId is a foreign key to the LkQuestionnaireType table

	Name	Type
20	ALLOWMULTIAUTHORS	BIT
	Description: True when the Note created with the questionnaire can have multiple authors

	Name	Type
22	CREATED	DATETIME2
	Description: Record created time

	Name	Type
23	CREATEDTIMEZONEOFFSET	INT
	Description: Time zone Offset for Created time

	Name	Type
25	LASTMODIFIED	DATETIME2
	Description: Record Last Modified time

	Name	Type
26	LASTMODIFIEDTIMEZONEOFFSET	INT
	Description: Time zone Offset for Modified time