TableName

varchar(50)

Primary key

Name of the table holding data for the dynamic form.

ViewName

varchar(255)

Filename

varchar(255)

Name of the XML file holding the specification of the form

Caption

varchar(255)

Dynamic forms caption in GUI

GenerateSQL

bit

whether or not to generate SQL

Hidden

bit

Whether or not to make the form visible in the GUI

ViewName

varchar(255)

IsShared

bit

Whether or not dynamic form is shared

Link

varchar(255)

Description

Text

SortByField

varchar(50)

Name of field to sort by.

SortDescending

bit

If true data are sorted descending else data are sorted ascending

StructureType

varchar(50)

Type to be used in structure file

SequenceNumber

int

Responsible

int

ImageFile

varchar(255)

ImageClosed

varchar(255)

ImagePlanned

varchar(255)

ImageComplete

varchar(255)

ImageIncomplete

varchar(255)

Closable

bit

SingleOpenMode

bit

FlatView

bit

Plannable

bit

Approve

bit

Searchable

bit

DraftMode

int

OrgUnitRelation

int

The relation the form has the organizational unit of its predescessor can be none, inherit, override and select

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

DefaultForm

bit

DefaultLastPreviousSource

int

DefaultLastPreviousPrompt

bit

CreateOrgUnitList

bit