Tables [dbo].[FORMS_HEADER]
Form information. The individual elements on the form are in Form_Detail.
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_FORMS_HEADER: FormIDFormIDint4NOT NULLKey to the Forms_Header table
Indexes IX_FORMS_HEADER_FORMNAMEFormNamevarchar(50)50NULL allowedName of Form
FolderIDvarchar(10)10NULL allowedFolder. When the form is created on a patients chart, what folder should it appear under in. Link to Folder_Template.FolderID.
DocumentNamevarchar(50)50NULL allowedDocument name. It can be different than the Form Name.
Statusint4NOT NULL((1))0 = inactive, 1 = active
AutoLockint4NOT NULL((0))0 = No, 1 = Yes
BarcodeDocumentNamevarchar(50)50NULL allowedName of the document associated with the specific barcode
BarcodeDatedatetime8NULL allowedDate in barcode for the form header
BarcodeFolderIDvarchar(10)10NULL allowedID of the folder where document will be sorted to based on the setup barcode for that document