Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 | FormID | int | 4 | NOT NULL | | Link to Form_Header.FormID |
 | ObjectID | int | 4 | NOT NULL | | Object Identifier. Auto increments from System.NextObjectID |
| DataType | varchar(50) | 50 | NULL allowed | | What type ob data is the element going to hold (text, date, bit, Grid etc...) |
| Decimals | int | 4 | NULL allowed | | Used when DataType is a CalculationField to specify how may decimal places to render |
| Description | varchar(50) | 50 | NULL allowed | | Describes the object. This populates automatically. First Radio button will be "RadioButton1". Second one will be "RadioButton2". |
| FieldChecked | int | 4 | NULL allowed | | Default to checked? |
| Length | int | 4 | NULL allowed | | For text fields, how many characters |
| Required | int | 4 | NULL allowed | | 0 = No, 1 = Yes |
| ObjectType | int | 4 | NULL allowed | | Numerical value to relates to the type of object it is. (1 = checkbox, 3 = text, 10 = database field, 23 = radio button, 212 = line etc.. |
| Alignment | int | 4 | NULL allowed | | Text Alignment in field (0 = left, 1 = Right, 2 = Center |
| Appearance | int | 4 | NULL allowed | | Text Appearance 0 = flat, 1 = 3D |
| BackColor | int | 4 | NULL allowed | | Text Color |
| BackStyle | int | 4 | NULL allowed | | For Circles and Squares drawn on the form, what is the background style. 0 = Transparent, 1 = Opaque |
| Border | int | 4 | NULL allowed | | 0 = no border, 1 = border |
| BorderColor | int | 4 | NULL allowed | | Background Color in decimal format |
| BorderStyle | int | 4 | NULL allowed | | For Circles and Squares drawn on form, you can set the line style. 0 = transparent, 1 = Solid, 2 = dashes, 3 = dots |
| BorderWidth | int | 4 | NULL allowed | | For Lines, Circles, and Squares you can set the border width (1-255) |
| Caption | text | max | NULL allowed | | The name of the field as shown to the user. |
| FillColor | int | 4 | NULL allowed | | For Circles or Squares you draw on the form, you can adjust the inside color. |
| FillStyle | int | 4 | NULL allowed | | For Circles or Squares you draw on the form you can set the style. 0 = solid, 1 = transparent |
| FontBold | int | 4 | NULL allowed | | 0 = not Bold, 1 = Bold |
| FontItalic | int | 4 | NULL allowed | | 0 = not Italic, 1 = Italic |
| FontSize | int | 4 | NULL allowed | | Font size |
| FontUnderline | int | 4 | NULL allowed | | 0 = not underlined, 1 = underlined |
| ForeColor | int | 4 | NULL allowed | | Font Color |
| Height | int | 4 | NULL allowed | | Hight of element |
| LeftPos | int | 4 | NULL allowed | | X coordinate of where the element is from left hand edge of page |
| ListID | int | 4 | NULL allowed | | When 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 |
| Orientation | int | 4 | NULL allowed | | For a line added to a form 1 = horizontal line, 2 = verticle line |
| Picture | varchar(250) | 250 | NULL allowed | | UNC path to a picture you want to include on the form |
| Stretch | int | 4 | NULL allowed | | Picture stretch to fit 0 = No, 1 = Yes |
| Text | varchar(50) | 50 | NULL allowed | | When using a dropdown list, what name to default it to |
| TopPos | int | 4 | NULL allowed | | Y coordinate of where the element is from the top edge of the page |
| Width | int | 4 | NULL allowed | | Width of element |
| TableName | varchar(50) | 50 | NULL allowed | | When using a database field, which table does the field pull from (PATIENTS view) |
| FieldName | varchar(50) | 50 | NULL allowed | | When using a database field, which column from the TableName do we pull (ie Firstname). |
| FieldDescription | varchar(50) | 50 | NULL allowed | | For Database Field ObjectTypes this is a placeholder value in the field. You cannot change it. (ie "Patient Full Name" or "Chart Number") |
| TabIndex | int | 4 | NULL allowed | | To control order of cursor jumping when tab is hit |
| FontName | varchar(50) | 50 | NULL allowed | | Type of Font (Ariel, MS Serif etc..) |
| GridColumns | int | 4 | NULL allowed | | For a table spreadsheet added to the form, this is the number of columns |
| GridRows | int | 4 | NULL allowed | | For a table added to the form, this is the number of rows |
| ShowColumnHeaders | int | 4 | NULL allowed | | For a table added to the form, 0 = show header, 1 = do not show header |
| GridDef | varchar(1000) | 1000 | NULL allowed | | For 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 |
| LockMode | int | 4 | NULL allowed | | Used for tables added to a form 0 = Do No Lock, 1 = Lock Immediately, 2 = Lock after X hours |
| LockHours | int | 4 | NULL allowed | | When Lockmode is 2, this is the number of hours to lock the table. |
| TaskCode | int | 4 | NULL allowed | ((0)) | Code of task |
| GroupCode | int | 4 | NULL 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 |
| WorkflowID | varchar(30) | 30 | NULL allowed | | ID of workflow |
| WorkflowEvent | int | 4 | NOT NULL | ((0)) | Event of workflow |
| TimeOutHours | decimal(6,2) | 5 | NULL allowed | ((0)) | Hours until timeout |
| ActionButtonType | varchar(50) | 50 | NULL allowed | | Type of action button |
| ActionButtonAction | varchar(250) | 250 | NULL allowed | | Action performed by action button |
| Visible | bit | 1 | NOT NULL | ((1)) | 0 = not visible, 1 = Visible |
| WorkflowNumber | int | 4 | NOT NULL | ((0)) | Number of workflows |
| TimeOutTime | varchar(20) | 20 | NULL allowed | | Time until timeout |
| ScaleToFit | bit | 1 | NULL allowed | | Picture Scale to fit |
| PreserveAspectRatio | bit | 1 | NULL allowed | | For Pictures 0 = Do not perserve aspect ratio. 1 = perserve aspect ratio |
| Calculation | varchar(500) | 500 | NULL allowed | | For 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]". |
| PageNumber | int | 4 | NOT NULL | ((1)) | Page Number, forms can be multiple pages |