Tables [dbo].[FORMS_DETAIL]
This contains all the elements that appear in the form. 1 row per element.
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_FORMS_DETAIL: FormID\ObjectIDFormIDint4NOT NULLLink to Form_Header.FormID
Cluster Primary Key PK_FORMS_DETAIL: FormID\ObjectIDObjectIDint4NOT NULLObject Identifier. Auto increments from System.NextObjectID
DataTypevarchar(50)50NULL allowedWhat type ob data is the element going to hold (text, date, bit, Grid etc...)
Decimalsint4NULL allowedUsed when DataType is a CalculationField to specify how may decimal places to render
Descriptionvarchar(50)50NULL allowedDescribes the object. This populates automatically. First Radio button will be "RadioButton1". Second one will be "RadioButton2".
FieldCheckedint4NULL allowedDefault to checked?
Lengthint4NULL allowedFor text fields, how many characters
Requiredint4NULL allowed0 = No, 1 = Yes
ObjectTypeint4NULL allowedNumerical value to relates to the type of object it is. (1 = checkbox, 3 = text, 10 = database field, 23 = radio button, 212 = line etc..
Alignmentint4NULL allowedText Alignment in field (0 = left, 1 = Right, 2 = Center
Appearanceint4NULL allowedText Appearance 0 = flat, 1 = 3D
BackColorint4NULL allowedText Color
BackStyleint4NULL allowedFor Circles and Squares drawn on the form, what is the background style. 0 = Transparent, 1 = Opaque
Borderint4NULL allowed0 = no border, 1 = border
BorderColorint4NULL allowedBackground Color in decimal format
BorderStyleint4NULL allowedFor Circles and Squares drawn on form, you can set the line style. 0 = transparent, 1 = Solid, 2 = dashes, 3 = dots
BorderWidthint4NULL allowedFor Lines, Circles, and Squares you can set the border width (1-255)
CaptiontextmaxNULL allowedThe name of the field as shown to the user.
FillColorint4NULL allowedFor Circles or Squares you draw on the form, you can adjust the inside color.
FillStyleint4NULL allowedFor Circles or Squares you draw on the form you can set the style. 0 = solid, 1 = transparent
FontBoldint4NULL allowed0 = not Bold, 1 = Bold
FontItalicint4NULL allowed0 = not Italic, 1 = Italic
FontSizeint4NULL allowedFont size
FontUnderlineint4NULL allowed0 = not underlined, 1 = underlined
ForeColorint4NULL allowedFont Color
Heightint4NULL allowedHight of element
LeftPosint4NULL allowedX coordinate of where the element is from left hand edge of page
ListIDint4NULL allowedWhen adding a dropdown List, which dropdown is it. -1 = Groups, -2 Users, -3 Provider. If value is >0 then it references a user created list built in FormsMD and stored in List_header.ListID
Orientationint4NULL allowedFor a line added to a form 1 = horizontal line, 2 = verticle line
Picturevarchar(250)250NULL allowedUNC path to a picture you want to include on the form
Stretchint4NULL allowedPicture stretch to fit 0 = No, 1 = Yes
Textvarchar(50)50NULL allowedWhen using a dropdown list, what name to default it to
TopPosint4NULL allowedY coordinate of where the element is from the top edge of the page
Widthint4NULL allowedWidth of element
TableNamevarchar(50)50NULL allowedWhen using a database field, which table does the field pull from (PATIENTS view)
FieldNamevarchar(50)50NULL allowedWhen using a database field, which column from the TableName do we pull (ie Firstname).
FieldDescriptionvarchar(50)50NULL allowedFor Database Field ObjectTypes this is a placeholder value in the field. You cannot change it. (ie "Patient Full Name" or "Chart Number")
TabIndexint4NULL allowedTo control order of cursor jumping when tab is hit
FontNamevarchar(50)50NULL allowedType of Font (Ariel, MS Serif etc..)
GridColumnsint4NULL allowedFor a table spreadsheet added to the form, this is the number of columns
GridRowsint4NULL allowedFor a table added to the form, this is the number of rows
ShowColumnHeadersint4NULL allowedFor a table added to the form, 0 = show header, 1 = do not show header
GridDefvarchar(1000)1000NULL allowedFor a table added to the form, this contains the definition. (ie 4~Left|First|1500|Text|0|30|2~Left|Second|1500|Text|0|30|2~Left|Third|1500|Number|0|3|2~Left|Fourth|1500|Date|0|8|2~Center|Last Center|1500|Text|0|30|2) The first number (4) is the # of rows. Then each column definition is divided up by a tilde ~. The fields within the pipes define column settings. Text alignment |  column name | column width | (text, number, or date) | decimals (for number type) | text length | text wrapping to X rows
LockModeint4NULL allowedUsed for tables added to a form 0 = Do No Lock, 1 = Lock Immediately, 2 = Lock after X hours
LockHoursint4NULL allowedWhen Lockmode is 2, this is the number of hours to lock the table.
TaskCodeint4NULL allowed((0))Code of task
GroupCodeint4NULL allowed((0))Items like Radio Buttons will need to belong to the same group. Items not in a group will have a groupcode of 0
WorkflowIDvarchar(30)30NULL allowedID of workflow
WorkflowEventint4NOT NULL((0))Event of workflow
TimeOutHoursdecimal(6,2)5NULL allowed((0))Hours until timeout
ActionButtonTypevarchar(50)50NULL allowedType of action button
ActionButtonActionvarchar(250)250NULL allowedAction performed by action button
Visiblebit1NOT NULL((1))0 = not visible, 1 = Visible
WorkflowNumberint4NOT NULL((0))Number of workflows
TimeOutTimevarchar(20)20NULL allowedTime until timeout
ScaleToFitbit1NULL allowedPicture Scale to fit
PreserveAspectRatiobit1NULL allowedFor Pictures 0 = Do not perserve aspect ratio. 1 = perserve aspect ratio
Calculationvarchar(500)500NULL allowedFor Calculation objects this is the definition. Calculations can only apply against Numeric text fields. If two Numeric fields (field ID 214 and 215) were on a form and you wanted to add them together, this calculation columne would look like "[214]+[215]".
PageNumberint4NOT NULL((1))Page Number, forms can be multiple pages