| Column Name | Ordinal Position |
|---|
| Column Name | Ordinal Position | Referenced Table |
|---|
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | LKQUESTIONNAIRETYPEID | INT | ||||||||
|
Description: The unique Id for the LkQuestionnaireType table
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 2 | QUESTIONNAIRETYPE | NVARCHAR | ||||||||
|
Description: Text value of the questionnaire type (Clinical Note, Assessment, etc)
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 3 | WORKFLOWCAPTION | NVARCHAR | ||||||||
|
Description: Text of the caption to be displayed in the workflow
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 4 | CANBESIGNED | BIT | ||||||||
|
Description: Flag to indicate this questionnaire type can be signed
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 6 | CREATED | DATETIME2 | ||||||||
|
Description: Record created time
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 7 | CREATEDTIMEZONEOFFSET | INT | ||||||||
|
Description: Time zone Offset for Created time
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 9 | LASTMODIFIED | DATETIME2 | ||||||||
|
Description: Record Last Modified time
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 10 | LASTMODIFIEDTIMEZONEOFFSET | INT | ||||||||
|
Description: Time zone Offset for Modified time
|
||||||||||