Tables [dbo].[FOLDER_TEMPLATE]
Folders can be created to organize scanned images in a patients chart.
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_FOLDER_TEMPLATE: FolderIDFolderIDvarchar(10)10NOT NULLKey to Folder_Template table
Indexes IX_FOLDER_TEMPLATE_CHARTGROUPForeign Keys FK_FOLDER_TEMPLATE_ChartGroup: [dbo].[CHART_GROUPS].ChartGroupChartGroupint4NOT NULLLink to Chart_Groups.Code
Indexes IX_FOLDER_TEMPLATE_PARENTParentvarchar(10)10NOT NULLIf its a nested folder it will contain the parent folder name, otherwise it will say "Root"
Indexes IX_FOLDER_TEMPLATE_DESCRIPTIONDescriptionvarchar(25)25NULL allowedName of Folder
Tagint4NOT NULLContains the nest level of the folder. Parent folder = 1. Subfolder = 2. Folder under a subfolder = 3 etc..
Indexes IX_FOLDER_TEMPLATE_FOLDERINDEXFolderIndexint4NOT NULLstores sorting order of folders in scan
UnfiledFolderbit1NOT NULL0 = No, 1 = Yes - "Archives" is a delivered unfiled folder. The idea being you can use the Filer button on this folder.
ImportIDint4NOT NULLImport Identifier. Auto incremented from System.NextImportID.
FolderPathvarchar(250)250NULL allowedNamed folder path (ie "Patient Infomation \ HIPPA Forms \ Third row folder")
SystemFolderbit1NULL allowed0 = Not a system folder, 1 = system folder, UI checkbox (Scan delivers 4 system folders: Archives, Imported Documents, Clipboard and Prescriptions).
EntryCodevarchar(10)10NULL allowedDocument Type Code for chart viewer mapping. Link to Works.dbo.Document_Type_de.entrycode.
TWTaskTypeIDint4NOT NULL((0))ID of the task type
WebFolderint4NOT NULL((0))Web Folder. 0 = No, 1 = Yes
URLvarchar(255)255NULL allowedWhen webfolder = 1, this is the URL to the folder
UserNamevarchar(50)50NULL allowedWhen webfolder = 1, this is the username to login to the folder
Passwordvarchar(50)50NULL allowedWhen webfolder = 1, this is the password to login to the folder
Indexes IX_FOLDER_TEMPLATE_ALTERNATEIDAlternateIDvarchar(100)100NULL allowedAlternate ID of the task type