Integration: Deciding on a Database Structure for
Image-Master
Overview
Deciding on a Database Structure
Image-Master is a completely customizable and
user-defined filing system. As such, you have complete control over
the types of index fields, their lengths, data types, and rules. In
addition to the user-defined fields, there are a number of
mandatory internal control fields which may be of interest to you
if you elect to parse our database directly.
This section of the documentation uses a
collection-attorney focused database for Image-Master (CLS000) as
an example. You can make changes to the database structure with the
Image-Master configuration
module yourself to suit your needs, and CLS can distribute an
application-specific database (appropriately named) for use with
your software.
User-defined Fields in CLS000:
|
Field Name
|
Length
|
Data Type
|
Description
|
|
fileno
|
8
|
Character
|
Collection-Master (attorney) file number
|
|
ddate
|
8
|
Date
|
Document Date
|
|
cmt
|
48
|
Character
|
Document Description
|
|
llcode
|
8
|
Character
|
Queue/Routing Person ID
|
|
docketno
|
15
|
Character
|
Docket Number
|
|
fwfileno
|
20
|
Character
|
Forwarder's File Number
|
|
client
|
40
|
Character
|
Client (Forwarder's) Name
|
|
debtor
|
30
|
Character
|
Debtor Name
|
|
creditor
|
25
|
Character
|
Creditor Name
|
|
lmdatec
|
6
|
Character
|
Computed Filing Folder ID (See NOTE.)
|
| NOTE: The
lmdatec field usually resolves to yyyymm or yyyyww where
yyyy is the four-digit year, mm is the two digit month, and ww is
the two digit week of the system date on the computer. The field is
used to segregate documents into roughly equal periodic bundles on
the hard drive, in order to make backup and archiving
administrative tasks easier to perform. |
Internal Control Fields Present in ALL Image-Master Databases:
|
Field Name
|
Length
|
Data Type
|
Description
|
|
volume
|
8
|
Character
|
Volume ID if doc is on removable media
|
|
npath
|
60
|
Character
|
Path to Images in this document (See NOTE.)
|
| NOTE: Using Collection-Master as the
third-party application example, a "C" means exported to
Collection-Master. This can be an absolute path (ie.
C:\IMASTER\IMAGES\) [used with fixed media] or a relative path
(i.e. \DIR1\OCTOBER\IMAGES\) [used with removable media] or a UNC
path (i.e. \\SERVER\SHARE\FOLDER\) [doc on a NAS or similar] or a
URL path.) Most likely, Collection-Master users will use absolute
or UNC paths. |
|
nfile
|
5
|
Character
|
File Name Prefix (See naming
of images.)
|
|
nfext
|
3
|
Character
|
Image Name Extension (i.e. TIF, JPG, PCX)
|
|
npages
|
3
|
Numeric
|
Number of pages in the document (1-999)
|
|
status
|
1
|
Character
|
Multiple Uses Flag.
|
|
status
|
1 1
|
Character
|
Document Creation Status N=New, C=Changed
|
|
status2
|
1
|
Character
|
Special third-party use (undefined)
|
|
lmdate
|
8
|
Date
|
Date of scan (from workstation clock)
|
|
nfullname
|
8
|
Character
|
Normalized multi-page filename. (undefined)
|
Related Topics
Introduction
Image-Master Third-Party Integration
|