Integration: Deciding on a Database Structure for vMedia
Overview
NOTE: Depending on how you
originally set up vMedia, it might be located in the root of vMedia
rather than in the root of IMASTER. If this is the case, any
references to the IMASTER folder should be referred to as
vMedia.
Deciding on a Database Structure
vMedia 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 vMedia (CLS000) as an
example. You can make changes to the database structure with the
vMedia configuration module
yourself to suit your needs, and 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, to make backup and archiving administrative tasks
easier to perform. |
Internal Control Fields Present in ALL vMedia 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 vMedia
Third-party Integration
|