WebDocs iSeries Edition Table List
From Support
Main
Most Important Document Info Tables
DOCS00
Document Catalog/Main Index table. This is the main document index table that holds all document records along with their main index information. There is one record for each document stored in DOCS00. There are several logical files that start with DOCS* that belong to this table.
DOCVER00
This table holds the version information for each document. When a new document is checked-in to DOCS00 a corresponding record always gets created in DOCVER00. When a document is checked-out and checked-in, the version info is stored here along with a file pointer to the new version.
Note:If you are writing a processing program to look at or process all images associated with a document in DOCS00, you should start with DOCVER00 as the primary table so as not to miss any versions.
DOCTXT00
Document Full Text Index. If documents are full text indexed, the word/document ID combinations are stored here.
DOCNOT00
Document Text Notes. This table holds any text or workflow notes related to a document.
DOCLINK00
Document Linked Indexes - This table holds info on document linked indexes. Any document in DOCS00 can have several linked indexes in DOCLINK00. This allows the physical document to be stored once in DOCS00 and logically linked to other processes via the document links. An unlimited number of document link records can exist in DOCLINK00 for a single document in DOCS00.
Settings Tables
DOCUSR00
WebDocs user table. Contains all user info for WebDocs users.
DOCFLR00
Document folders table. This table holds the document virtual folder definitions as well as a description for each folder. It also holds the IFS/Network location where new documents will be checked in to if added to this folder.
DOCKEY00
Document Keyword Settings - This table holds the metadata descriptions for the document keyword for each document type. This information shows up on screen when a search is run or document details are viewed in the browser.
DOCLOG00
Document Log Table. This table holds document access logging info if logging is enabled. This table can be queried to produce document access reports.
DOCSEC00
Document Security Table - This table holds all user security access info for all virtual folders in DOCFLR00. This table determines the rights for access to folders by individual users or user groups. This table is the key security mechanism for WebDocs along with additional user level or pre-defined SQL filters which can be set up in DOCUSR00 (user level SQL document filters), DOCFLT00 (Pre-defined SQL Filters), DOCUSFLT00 (Pre-Defined SQL Filtes Assigned to a User)
DOCFLT00
Document User Filter Criteria table. This table can hold pre-defined SQL filter criteria that can be assigned to a user via the DOCUSRFLT00 table. This prevents administrators from needing to become SQL experts. Once an SQL criteria is defined it can be applied to one or more users via DOCUSRFLT00.
DOCUSFLT00
Document User predefined Filter Criteria. This table allows one or more pre-defined SQL filter criterias to be assigned to a user to limit their access to selected documents. This criteria is applied in addition to folder access set via DOCSEC00 and filter access set at the user level. This allows for security granularity by user.
DOCTYPE00
Document Types - This table holds each document type and its description. The keyword metadata for each document type is stored in DOCKEY00.
DOCTYPU00
Document type user access. This table determines which document types will show up in the WebDocs browser search or checkin pulldowns for a user. This helps limit the number of doc types user groups will see. Ex: Payroll really only needs to see HR/Payroll related document types for searching. There's no reason they need to see doc types for A/R, A/P, etc.
DOCLS00
Document Custom Lookup Pulldown SQL - This table holds information to allow users to create predefined lookups for index values based on their iSeries application data. Ex: For an A/P document. a vendor table can be hooked up to the WebDocs search screen so the user can search for a vendor number if they do not know it.
Workflow Lite/Document Routing Table
DOCFLORH00
Document Workflow/Workpiece Item Header - This table contains a header record entry for each document ID that is currently in a workflow process.
Note: A single document can exist in multiple workflow processes at the same time and each workflow process is independent.
DOCFLOW00
Document Workflow/Workpiece Item Detail/Step Information - When a new workflow is initiated via the DOCFLOWCRT command, a copy of all the steps the document must go through gets copied to DOCFLOW00 and a header gets created in DOCFLORH00, The current workflow status for each document in workflow is then tracked via DOCFLOW00 as the workpiece progresses via accept or reject operations.
Predefined Workflow Routing Processes
DOCFLOWH00
Document Workflow Definition header - This table can be used to create a simple named, pre-defined process. Ex: PURCHASING - This process could be used to auto-route a document to each purchasing user for approval. The sequence steps for a pre-defined process are defined in DOCFLOWD00. Once a pre-defined process has been created, the process name can be specified when adding an item to workflow via the DOCFLOWCRT command instead of specifying individual users.
DOCFLOWD00
Document Workflow Definition Detail Steps - For a process defined in DOCFLOWH00, one or more steps can be added for the document to flow through. Each step represents a stop at a user level or group level workflow inbox. The steps are linear, however a workflow item can be accepted or rejected (forward or backwards) if needed.
Providing Access to Other Users Workflow
DOCFLOWS00
Document Workflow User Access - This table can be used to allow access to another users workflow inbox. Ex: If Joe is on vacation, Sally may need access to Joe's workflow items for review. Any workflow inboxes a user has access to will display in the WebDocs browser interface on the left side tree.
Additional Tables
DOCEVENT
This table is used by the workflow event notifcation processes. Users should normally not modify this table. The DOCEVMON command processes this table to send notifications. This table was designed to be a generic event notifier.
DOCTYPG00
Document Type List for User Group. Not implemented yet.
DOCROUT00
Not currently used. DOCEVENT will most likely replace this table.
DOCVOL00
Not implemented yet.
