TableName

varchar(50)

Primary key

Name of the table for the dynamic form.

ViewName

varchar(255)

FileName

varchar(255)

Name of the xml file holding the configuration for the dynamic form.

Caption

varchar(255)

Caption for the dynamic form to use in GUI.

GenerateSql

bit

Hidden

bit

Whether or not to make the dynamic form visible in the GUI

IsShared

bit

Whether or not to make the dynamic form shared

Link

varchar(255)

Description

Text

SortByField

varchar(50)

Name of field to sort records in record tree by.

SortDescending

bit

Whether or not to sort records descending in the recorrd tree

StructureType

varchar(50)

SequenceNumber

int

Responsible

int

Imagefile

varchar(255)

Url to file containing the image associated to the dynamic form in the record tree.

ImagefileClosed

varchar(255)

Url to file containing the image associated to the dynamic form in the record tree when the form is closed.

ImagefilePlanned

varchar(255)

Url to file containing the image associated to the dynamic form in the record tree when the form is planned.

ImagefileComplete

varchar(255)

Url to file containing the image associated to the dynamic form in the record tree when the form is complete.

ImagefileIncomplete

varchar(255)

Url to file containing the image associated to the dynamic form in the record tree when the form is incomplete.

Closable

bit

SingleOpenMode

bit

Flatview

bit

Whether or not to create a flat view for the dynamic form.

AugmentedView

bit

Whether or not to create an augmented view for the dynamic form.

Plannable

bit

Approve

bit

Searchable

bit

Draftmode

int

OrgunitRelation

int

Foreign key to OrgunitRelationType

How to handle inheritance according to data ownership:

• 0 - None

• 1 - Choose

• 2 - Inherite

• 3 - Overwrite

OrgUnitConfigure

bit

AccessModeRead

int

Foreign key to AccessModeRead

The type of data user can read inherit from predescessor, all patient data, all patient data from patient having data in own organizational unit, all data from own organizational unit, all data from own organizational unit and organizational unit who are descendant to own organizational unit, all patient data from patient having data in own organizational unit and organizational unit who are descendant to own organizational unit

AccessModeWrite

int

Foreign key to AccessModeWrite

The type of data user can write inherit from predescessor, all patient data that can be read, all data from own organizational unit and all data from own organizational unit and organizational unit who are descendant to own organizational unit.

AccessModeDenied

int

Foreign key to AccessmodeDenied

How to handle denied data possible choices are inherit from predescessor, totally hide non accessible data partly hide non accessible data.

PatientAccessMode

int

AutoCreate

bit

Whether or not to autocreate an instance of the dynamic form when inserting a new patient

DefaultLastPreviousSource

int

DefaultLastPreviousPrompt

bit

Whether or not to prompt

CreateOrgUnitList

bit