Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 | FolderID | varchar(10) | 10 | NOT NULL | | Key to Folder_Template table |
 ![Foreign Keys FK_FOLDER_TEMPLATE_ChartGroup: [dbo].[CHART_GROUPS].ChartGroup Foreign Keys FK_FOLDER_TEMPLATE_ChartGroup: [dbo].[CHART_GROUPS].ChartGroup](../../../../Images/fk.png) | ChartGroup | int | 4 | NOT NULL | | Link to Chart_Groups.Code |
 | Parent | varchar(10) | 10 | NOT NULL | | If its a nested folder it will contain the parent folder name, otherwise it will say "Root" |
 | Description | varchar(25) | 25 | NULL allowed | | Name of Folder |
| Tag | int | 4 | NOT NULL | | Contains the nest level of the folder. Parent folder = 1. Subfolder = 2. Folder under a subfolder = 3 etc.. |
 | FolderIndex | int | 4 | NOT NULL | | stores sorting order of folders in scan |
| UnfiledFolder | bit | 1 | NOT NULL | | 0 = No, 1 = Yes - "Archives" is a delivered unfiled folder. The idea being you can use the Filer button on this folder. |
| ImportID | int | 4 | NOT NULL | | Import Identifier. Auto incremented from System.NextImportID. |
| FolderPath | varchar(250) | 250 | NULL allowed | | Named folder path (ie "Patient Infomation \ HIPPA Forms \ Third row folder") |
| SystemFolder | bit | 1 | NULL allowed | | 0 = Not a system folder, 1 = system folder, UI checkbox (Scan delivers 4 system folders: Archives, Imported Documents, Clipboard and Prescriptions). |
| EntryCode | varchar(10) | 10 | NULL allowed | | Document Type Code for chart viewer mapping. Link to Works.dbo.Document_Type_de.entrycode. |
| TWTaskTypeID | int | 4 | NOT NULL | ((0)) | ID of the task type |
| WebFolder | int | 4 | NOT NULL | ((0)) | Web Folder. 0 = No, 1 = Yes |
| URL | varchar(255) | 255 | NULL allowed | | When webfolder = 1, this is the URL to the folder |
| UserName | varchar(50) | 50 | NULL allowed | | When webfolder = 1, this is the username to login to the folder |
| Password | varchar(50) | 50 | NULL allowed | | When webfolder = 1, this is the password to login to the folder |
 | AlternateID | varchar(100) | 100 | NULL allowed | | Alternate ID of the task type |