Forms automation system implementation

Abstract

A system and method for the electronic design, storage, and distribution of business forms maximizes all of these functions, utilizing a forms automation platform and a central library facility. The forms automation platform includes customer profile, form profile, form field description, and distribution information files each having a unique customer identifier, and typically also having a unique form identifier, and including detailed information about each form. The central library facility includes customer profile, geographic profile, printer profile, distribution data, form profile, and form output format files; again unique customer identifiers, as well as specific form identifiers, are provided. Forms are automatically distributed by the central library facility to end user sites, at which remote computers are located, by polling for forms to be released, establishing a session with the end users to which release is to be made, and then electronically transferring the forms. Form profile information that is typically stored--in order to effectively process requests--include the software package used to design the form, a description of the form, the date of form creation and/or last revision, the number of parts, whether the form has landscape or portrait mode, the length, and the width of the form.

Claims

What is claimed is:

1. A method of electronically developing, producing, managing, and distributing a plurality of different business forms for an entity having a plurality of geographically remote use locations with different needs for different business forms, comprising the steps of:

(a) at a centralized location, storing the plurality of business forms in electronic format, each form having the following data associated therewith: identification code for the form; word description of the form; software package used to design the form; date of form creation or last revision; number of parts to the form; whether the form has landscape or portrait mode; length of the form; and width of the form;

(b) based upon geographic location, volume requirements, form construction, and equipment profile, determining which of the geographically remote use locations will be provided with business forms in electronic and/or preprinted form, and storing that information at said centralized location; and

(c) through electronic scheduling or in response to commands inputted at said centralized location, automatically distributing forms in electronic form, or distributing preprinted forms, from the centralized location to the geographically remote use locations for that particular form, according to the determinations provided in step (b).

2. A method as recited in claim 1 wherein a first of the use locations has a first printer with a first printer format, and wherein a second of the use locations has a second printer utilizing a second printer format different than the first printer format; and wherein step (a) is practiced to store the business forms to be distributed to both the first and second use locations in both the first and second printer formats; and wherein step (c) is practiced to distribute formats in electronic format to the first and second printers, for printing into paper forms at the first and second use locations.

3. A method as recited in claim 2 wherein a plurality of printers are provided at the use locations, and comprising the further step of assigning a unique printer code to each of the printers, and wherein steps (b) and (c) are practiced by transmitting an appropriate printer format electronic form to each selected printer utilizing the unique printer code.

4. A method of electronically creating and managing a plurality of different business forms, utilizing a first computer at a first location, and a second computer at a second location, comprising the steps of:

(a) at the first computer, creating a plurality of business forms in electronic format, including printer formats;

(b) allocating a session with the second computer;

(c) designating business forms for transfer;

(d) electronically transferring the designated forms from the first computer to the second computer;

(e) confirming that the transfer has taken place; and

(f) initiating a table population function at the second computer, and confirming when that function has been completed.

5. A system for production of business forms, comprising:

first computer means comprising a forms automation platform means: for establishing each of a plurality of business forms in electronic format; for determining print format information for said forms; and for converting said electronic format to appropriate print formats based upon distribution profile information and print format information, to design a business form in electronic format;

second computer means at each of a plurality of end user sites, and including means for inputting variable information, if any, to be contained in the business forms to be produced;

third computer means comprising a central library means: for processing requests for distribution to effect electronic distribution of forms; and for providing information about print formats and distribution profiles to said second computer means; said third computer means including a display and an inputting means for inputting commands regarding a specific business form or forms requested;

electronic communications means for providing communication between said forms automation platform means and said central library means, and between said central library means and said end user sites; and

said third computer means comprising a file comprising customer profile information including an identification uniquely identifying each customer, and address information for the customer; a geographic profile including the customer identification and a unique code for each different geographic location of the customer's facilities; a printer profile file including the customer identification, and a code identifying each printer, and the type of printer, at each geographic location of the customer; a distribution data file including the customer identification, a code to uniquely identify each form for a customer, and the code to uniquely identify each printer; a form profile data file including the customer identification, and the code to identify each form for a customer; and a form output file including the customer identification, and a code to uniquely identify the format of each form of the customer.

6. A system as recited in claim 5 wherein the form output file also includes a code that describes the form type, a code that describes the printer type, a file identification of where the format is stored, and a code to tell if the form is compressed; and wherein the code to identify the format of each form identifies "print ready", "source", or "compiled".

7. A system as recited in claim 5 wherein the form profile data file includes therein a code to uniquely identify each revision of each form, a description of the form, the software package used to design the form, the date the form was created, the number of parts to the form, a code to identify landscape or portrait mode, the length of the form, and the width of the form.

8. A system as recited in claim 5 wherein the printer profile file also includes a description of the printer and printer type, a code of the printer type, and the name of the printer manufacturer.

9. A system as recited in claim 5 wherein the form profile data file is a parent of the form output format file and the distribution data file, and is a dependent of the file containing customer profile information.

10. A system as recited in claim 5 further comprising a user profile file having the customer identification, an indicator which either allows or prevents a user from signing on to the system and a flag to indicate new forms have arrived in the third computer means.

11. A system as recited in claim 5 further comprising a site profile file interrelated with the geographic profile file, and including the customer identification, an identifier to uniquely identify each site for the customer, a description of each site, and a unique code for each different geographic profile used.

12. A system as recited in claim 11 further comprising a corporate profile file having the customer identification, a code for each different corporate profile within a customer, and a plurality of levels in the corporate organization; said corporate profile file being a dependent of the customer profile file, and a parent of the site profile file.

13. A system as recited in claim 5 further comprising a corporate profile file having the customer identification, a code for each different corporate profile within a customer, and a plurality of levels in the corporate organization; said corporate profile file being a dependent of the customer profile file.

14. A system as recited in claim 5 further comprising a form field information file which is a dependent of the form profile data file, and includes the customer identification, the code to uniquely identify a form for a customer, a code to uniquely identify each revision of the form, a sequential number of fields within a form, a description of the length of the field, a description of the field format, and a description of whether the field is numeric, character, or the like.

15. A system for production of business forms, comprising:

first computer means comprising a forms automation platform means: for establishing each of a plurality of business forms in electronic format; for determining print format information for said forms; and for converting said electronic format to appropriate print formats based upon said distribution profile information and print format information, to design a business form in electronic format;

second computer means at each of a plurality of end user sites, including means for inputting variable information, if any, to be contained in the business forms to be produced;

third computer means comprising a central library means: for processing requests for distribution to effect electronic distribution of forms; and for providing information about print formats and distribution profiles to said second computer means, said means including a display and an inputting means for inputting commands regarding the specific business form or forms requested;

communications means for providing communication between said forms automation platform means and said central library means, and between said central library means and said end user sites; and

said first computer means having: a customer profile file including an identifier uniquely identifying a customer and a customer's address; a form profile file including the unique customer identifier, a unique identifier of a form for a customer, and physical information about the form; a form file name file including the unique customer identifier and unique identifier for the form, and the type of printer the form is designed for; and a distribution information file including the unique customer identifier, an indicator of whether or not a form has been selected for distribution to said third computer means, the unique form identifier, and the date of distribution of the form.

16. A system as recited in claim 15 wherein said form profile file includes as the form physical information therein; the software on which the form was designed, the width of the form, the length of the form, the number of pages in the form, the number of parts of the form, and the page orientation of the form.

17. A system as recited in claim 16 wherein said form profile file also includes the release status of the form, the system date on which the form was created or revised, and the system date on which the form was last released.

18. A system as recited in claim 16 wherein said form profile file is a dependent of said customer profile file, and a parent to a field description file having the customer identifier, the unique form identifier, the form field length, the form field data type, and the form field data format.

19. A system as recited in claim 15 wherein said distribution information file is not a parent or dependent of other files.

20. A method of distributing business forms to each of a plurality of geographically remote end users, comprising the steps of:

(a) storing in electronic format in a computer a plurality of different business forms;

(b) also storing in the computer predefined commands, including date and extent of distribution commands, relating to the distribution of the electronic business forms;

(c) periodically polling the computer to locate applicable date commands;

(d) identifying forms for distribution in the computer;

(e) establishing a session between the computer and an end user;

(f) transferring the forms electronically from the computer to the end user; and

(g) acknowledging receipt of the forms by the end user from the computer.

Description

BACKGROUND AND SUMMARY OF THE INVENTION

Conventionally, large organizations that use large volumes of many different types of business forms have the forms printed in paper form internally or by a manufacturer of business forms, and then store the forms in one or more warehouses for distribution to each of the geographically remote user locations of that organization. Distribution costs can be significant, especially if the locations are widely disseminated, and there can be significant costs associated with the warehousing, inventory and obsolescence of preprinted paper forms. If attempts are made to do away with inventorying of preprinted forms, electronic forms may be stored for printing of paper forms on demand, however typically systems capable of electronic storage and retrieval are marketed by vendors supplying only one type of equipment, so that the systems are not versatile enough to be utilized even within a single location of the organization unless all printers and related equipment at that location are compatible. Further, such systems do not have conventional preprinted forms manufacture integrated therewith, and are therefore limited.

Also, when new forms are required, they are typically designed at a location where the need for the form is first recognized. The newly designed form may, or may not, become part of the forms package available to other interested parts of the organization, and even if it ultimately becomes available, may go through a redundant design sequence before being adopted by the organization headquarters. Usually, no centralized forms facility is provided, requiring redundant entry and processing of information in electronic or hard copy format.

According to the present invention, a detailed implementation is provided for a system and method which overcome the major elements of the problems identified above. According to the present invention, it is possible for a large consumer of forms, having numerous geographically remote user locations with varying needs for many different types of forms, to eliminate or minimize the warehousing, inventory, and obsolescence costs associated with preprinted forms, to minimize the number of preprinted forms utilized, to minimize redundant entry and processing of information, and to provide centralized design, control and management of electronic forms. According to the invention, the same form may be printed at a number of geographically remote locations on different types of printers, the forms can be distributed and updated automatically and efficiently, and if a form is needed but not readily reproducible on in house equipment, an order for the form may be transmitted to a vendor's manufacturing facility or facilities (e.g. located geographically proximate the remote user locations to be served) for production and distribution.

The system according to the invention comprises as basic components first and second computer means, which comprise a central library facility (CLF), and a forms automation platform (FAP). Two way communication is provided between the CLF and FAP by appropriate communications software and protocol modules. The CLF is typically located at a centralized facility of the forms consumer (customer), while the FAP is typically located at a centralized facility of the vendor (forms manufacturer), although it may be located wherever convenient for performing the desired tasks to a particular customer's satisfaction. A third computer means; typically a PC, is located at end user sites to communicate with the CLF and receive distributed forms therefrom.

The primary functions that take place at the FAP are: electronic forms design (at a centralized location), using one or more conventional design packages such as PERFORM, F3, JETFORM or MECA III; creating, maintaining, updating, and ensuring the integrity of a display image library; logically associating print formats and distribution profile information received for each form within the display image library; converting display images to print formats based on the distribution profile specified for each form; downloading the print images to the CLF; executing electronic forms update processing; communication with the CLF; and communication with other print facilities (e.g. a manufacturer of business forms, and internal print shop, or the like). A release date is entered at the FAP, and managed at the CLF.

A FAP may service multiple CLFs and must then associate specific forms with specific CLFs. The FAP will generate print formats based on those printers supported by the customer to which the forms will be distributed.

The major functions of the CLF are file management and distribution, including the collection, assimilation and output of management information. The CLF also logically associates formats (print formats) and distribution profile information received for each form. The CLF electronically stores all of the forms previously supplied by the FAP, and effects transmission thereof to remote locations having use for them, and effects display or printing of forms--regardless of exact printer configuration--at the remote user locations. The CLF collects and downloads the form images to the end users (i.e. the third computer means) on a release date, after polling of the computer in which they are located. This may be done completely automatically, or after manual verification.

According to one aspect of the invention, a method is provided comprising the steps of: (a) at a centralized location, storing the plurality of business forms in electronic format including by providing each with the following data associated therewith: identification code for the form; verbal description of the form; software package used to design the form; date of form creation and/or last revision; number of parts to the form; whether the form has landscape or portrait mode; length of the form; and width of the form; (b) based upon geographic location, volume requirements, form construction, and equipment profile, determining which of the geographically remote use locations will be provided with business forms in electronic and/or preprinted form, and storing that information at said centralized location; and (c) through electronic scheduling or in response to commands inputted at the centralized location, automatically distributing forms in electronic and/or preprinted form from the centralized location to the geographically remote use locations for that particular form, according to the determinations provided in step (b).

According to another aspect of the invention, a method is provided utilizing first and second computers at different locations and comprising the steps of: (a) at the first computer, creating a plurality of business forms in electronic format, including printer formats; (b) allocating a session with the second computer; (c) designating appropriate business forms for transfer; (d) electronically transferring the designated forms from the first computer to the second computer; (e) confirming that the transfer has taken place; and (f) initiating a table population function at the second computer, and confirming when that function has been completed.

A system for producing business forms according to the invention comprises: first computer means comprising a forms automation platform means: for establishing each of a plurality of business forms in electronic format; for determining print format information for the forms; and for converting the electronic format to appropriate print formats based upon the distribution profile information and print format information, to design a business form in electronic format; second computer means at each of a plurality of end user sites; third computer means comprising a central library means: for processing requests for distribution to effect electronic distribution of forms; and for providing information about print formats and distribution profiles to the second computer means, the means including a display and an inputting means for inputting commands regarding the specific business form or forms requested, and for inputting variable information, if any, to be contained in the business forms to be produced; communications means for providing communication between the forms automation platform means and the central library means, and between the central library means and the end user sites; and the third computer means comprising a file comprising customer profile information including an identification uniquely identifying each customer, and address information for the customer; a geographic profile including the customer identification and a unique code for each different geographic location of the customer's facilities; a printer profile file including the customer identification, and a code identifying each printer, and the type of printer, at each geographic location of the customer; a distribution data file including the customer identification, a code to uniquely identify each form for a customer, and the code to uniquely identify each printer; a form profile data file including the customer identification, and the code to identify each form for a customer; and a form output file including the customer identification, and the code to uniquely identify each form of the customer.

The first computer means of the above system may have a customer profile file including an identifier uniquely identifying a customer and a customer's address; a form profile file including the unique customer identifier, a unique identifier of a form for a customer, and physical information about the form; a form file name file including the unique customer identifier and unique identifier for the form, and the type of printer the form is designed for; and a distribution information form including the unique customer identifier, an indicator of whether or not a form has been selected for distribution to the third computer means, the unique form identifier, and the date of distribution of the form.

Another method according to the invention comprises the steps of: (a) storing in electronic format in a computer a plurality of different business forms; (b) also storing in the computer predefined commands, including date and extent of distribution commands, relating to the distribution of the electronic business forms; (c) periodically polling the computer to locate applicable data commands; (d) identifying forms for distribution in the computer; (e) establishing a session between the computer and an end user; (f) transferring the forms electronically from the computer to the end user; and (g) acknowledging receipt of the forms by the end user from the computer.

It is the primary object of the present invention to provide for the detailed implementation necessary to effective and efficient creation and production of electronic and preprinted business forms for large consumers of forms having multiple locations. This and other objects of the invention will become clear from an inspection of the detailed description of the invention, and from the appended claims.

BRIEF DESCRIPTION OF THE DRAWINGS

FIG. 1 is a schematic block diagram comprising a high level functional overview of an exemplary system which is implemented according to the invention;

FIG. 2 is a block diagram showing one embodiment of a more detailed interrelationship between the components of the FIG. 1 system;

FIG. 3 is a block diagram showing an overview of the interconnections between the central library facility (CLF), forms automation platform (FAP), and end users;

FIG. 4 is a schematic view of the FAP;

FIG. 5 is a schematic like that of FIG. 4 for a host computer utilizable with the CLF and the FAP;

FIG. 6 is a data model diagram for data structures provided by the FAP, for detailed implementation according to the invention;

FIG. 7 is a data flow diagram of exemplary program control processes performed by the FAP, for detailed implementation according to the invention;

FIGS. 8a-8e are schematics giving lower level breakdowns of the major elements of FIG. 7;

FIG. 9 is a flow diagram illustrating access to the CLF from the FAP;

FIG. 10 is a schematic diagram illustrating exemplary components of the CLF of the system of FIGS. 1 and 2;

FIG. 11 is a CLF data model diagram, for detailed implementation according to the invention;

FIG. 12 is a schematic showing the CLF data base relationships, for detailed implementation according to the invention;

FIGS. 13a-13i provide a schematic structure chart for the CLF, for detailed implementation according to the invention;

FIG. 14 is an exemplary flow diagram for releasing forms from the CLF to end user sites based upon a distribution profile;

FIG. 15 is an exemplary flow diagram for transmitting an electronic form, initiated at the CLF; and

FIG. 16 is an exemplary flow diagram for transmitting a print request, initiated at the CLF.

DETAILED DESCRIPTION OF THE DRAWINGS

The forms automation system according to the present invention is illustrated generally by reference numeral 10 in FIGS. 1 and 2. The forms automation system 10 will be utilized by those consumers of business forms who have large numbers of business forms (both type and amount) that will be utilized at a number of geographically remote use locations. The system 10 is designed to be marketed by a business forms manufacturing company that has conventional forms production facilities, although it could be marketed by a wide variety of different types of companies. The system 10 is particularly useful when it it implemented in such a way that forms may be produced directly at the use locations, or in a conventional manufacturing facility, depending upon the construction of that particular form, the extent of its distribution, the quantity of forms utilized, and the like.

In this description, the term "vendor" or "manufacturer" when utilized refers to the entity providing the forms automation system according to the invention, typically a conventional business forms manufacturer. The term "customer" or "user" refers to the vendor's customer, namely the organization that has a plurality of geographically remote use locations, and consumes the business forms (also encompassing multiple departments that are remote within the same building, for example).

The major objectives of the system 10 are to provide for the centralized design of business forms, the centralized management and distribution of electronic and pre-printed (paper) forms, the co-existence of the same form in both paper and electronic formats, and the flexibility to meet the user's requirements. The major components of the system 10 comprise computer means providing the central library facility (hereinafter denoted by the acronym "CLF") 12, and computer means providing the forms automation platform (hereinafter denoted by the acronym "FAP") 14. The CLF 12 is preferably located in one of the customer's facilities (e.g. the same facility that has the main frame computer 34). This also typically is one of the use locations. The FAP 14 may, under some circumstances, be located at a customer's facility, but more typically is located at one of the vendor's facilities. In any case, the CLF 12 and FAP 14 provide for centralized design, management, and distribution of business forms. Appropriate conventional communications components are provided to inter-relate the CLF 12 and FAP 14, and to communicate with a variety of other stations.

In the schematic illustration in FIG. 1, the end user station 15 comprises a plurality of geographically remote use locations, each of which may have a printer--such as a laser printer 16--associated therewith. A computer, such as a PC, is provided at each of the use stations 15, as schematically illustrated in FIGS. 1 and 2, interfaced (two way communication) with the CLF 12. The PC and CLF may utilize IBM's OS/2 (version 1.2), or an equivalent multi-tasking operating system.

The CLF 12 may also control an internal electronic forms composition system 17 maintained by the organization having the geographically remote use locations 15, which may in turn control a high speed printing device, such as a high speed laser printer 18, or other non-impact printer. Both the CLF 12 and FAP 14 may also provide information to a standard business forms manufacturing facility, shown generally by reference numeral 19, for producing business forms. For example, the CLF 12 could access facility 19 through an external applications data base 28. Different types of manufacturing facilities encompassed by facility 19 may--for a large conventional business forms manufacturer such as Moore Business Forms, Inc.--include a traditional plant 20, a short run facility 21, an intelligent imaging facility 22, or other types of facilities 23. Also, the FAP 14 may control an internal print shop 24 at the FAP 14 location, for providing camera ready copy. The printing facilities 21, 23, and 24 deliver printed forms--as indicated by line 25--to the use locations 15 via a motor vehicle or the like (e.g. a common carrier), while the traditional plant 20 supplies paper forms to the use locations 15 through a warehouse 26 run by the forms manufacturer, a contractor, or another. The imaging facilities 22 typically provide paper forms to the use locations 15 via mail or a courier service 27 or the like.

As illustrated schematically in FIG. 2, the CLF 12 includes an internal applications data base 29 (and associated database access mechanisms), and includes as part of the preferred embodiment communication facilitating components thereof, such as a vendor supplied token ring (or other network adapter) 30 communicating with an (e.g. token ring) electronic data network 31. The applications data base 29 may have as its data model "SQL", a commercially available package, such as that sold by IBM with its OS/2 (version 1.2) system. A conventional communications interface component 32, such as an IBM 3270 standard protocol interface, is also preferably provided, as is the communications protocol module 33. The CLF 12 may be provided on main frame computer 34 directly at a customer (user's) location, with a front end processor 35--such as an IBM 3745/3720--interconnected between the module 33 and the computer 34, and a front end processor 36--e.g. an IBM 3745/3720--connected between the main frame computer 34 and the token ring network 31.

The forms automation platform 14 includes a commercially available applications database 37 (such as that sold by Oracle Systems Corp. under the trademark "Oracle"), with a component thereof 38 providing custom design of the forms. The forms design function is preferably accomplished utilizing a compatible commercially available primary design software package, such as Perform, sold by Delrina Technology, JETFORM, sold by Indigo, or MECCA III ("DOCS"), sold by Amgraph. A communications protocol module 39 is also utilized (such as an IBM SDLC), while the token ring adapter 40 is provided for optional communications over token ring network 31.

One of the primary functions of the FAP 14 is to provide for the centralized design of business forms. It is the entry point into the system 10, and contains software that controls the execution of the other processes within the system 10. As earlier indicated, forms design packages are associated therewith, such as the DOCS, or PERFORM, packages. The forms may be designed elsewhere and downloaded to the FAP 14 prior to transmission to the CLF 12. The FAP 14 communicates with the CLF (preferably two way) by modems 41, or a token ring, or networked protocols defined by the IEEE 802.5 or 802.2 standards. A terminal 43 (see FIG. 4), including a display screen 44, and inputting means such as a keyboard 45 and/or mouse 46, are provided as a human interface to the FAP 14. Other technologies could also be utilized, such as scanners and digitalization apparatus.

In addition to the forms design packages, the FAP 14 contains application software for a number of other functions. A file management function manages display (source) images for all released forms and forms that are scheduled for up-date/release. This software creates, maintains, up-dates and ensures the integrity of the display image library.

A user friendly interface function is provided by software that allows the operator to be queried for information regarding print formats and distribution profiles for each form. This information is logically associated with the display image within the file management system function so that whenever an electronic form is created or up-dated, it will have the necessary components. The forms administrator at the FAP 14 will obtain the following information for each electronic form created or up-dated: form identification; form description; form processing (e.g. new/update); the design software used to design the form; the release date; the security level; the distribution profile (user sites, output devices/sites, generic customer environment information); the paper base production requirements (e.g. manufacturing facilities, or internal print shops for camera ready copy); and variable data field encoding.

The FAP 14 also converts the display images to appropriate print formats based upon the distribution profile specified for each form. This is typically done right in the forms design package 38 itself (e.g. in PERFORM). The operator inputs what printer formats the form is to be provided in, and the package 38 does the necessary formatting (either single or multiple). That is, if a form is to be distributed at a first location having a first printer with a first printer format, and to a second geographically remote user location, having a second printer with a second printer format (e.g. a different manufacturer for the second printer than the first printer), the display images must be converted to print formats for both the first and second printers. That is, the same electronic business form will exist in different formats. The print image files will be validated for existence, having been previously formatted based upon the customer profile, and downloaded to the CLF 12. The CLF 12 may effect distribution on a scheduled release date. Of course this is practiced with any number of printers.

The system 10 may have any one of the following output formats: display image; encoded display image; print format; and production output. The display image format may require no conversion, and--for example--can be used to merely display the form on a screen (e.g. the screen 44 of the CLF 12). For the encoded display image format, the operator at the FAP 14 has encoded the variable data fields, and this format is used for merging variable data with the electronic form in a conventional manner via a batch process at the user site. This format, too, can be sent to a display terminal (e.g. 44). Print formats should be able to support output to postscript printers, as well as for printers for all other major manufacturers such as IBM, Hewlett Packard, Xerox, etc. The production output formats will support an output for a manufacturing production facility 19, via a PC to PC (e.g. DOCS to DOCS ) transmission. This output may be used to produce camera ready copy. This will insure the most updated form at all times. It also will provide an output to control an internal print shop 24 for producing camera ready copy.

As earlier indicated, the FAP 14 communicates with the CLF 12 via modems 41, token ring 31, or the like. Print images and form profiles are transferred to the CLF 12, and update processing within the CLF 12 is scheduled. Display and print images for updated forms will be downloaded to the CLF 12, and appropriate file management functions, such as archiving, will be scheduled and performed.

Major components of the data flow diagram of FIG. 7 include the FAP administrator software 86, form maintenance process 87, profile maintenance process 88, CLF administrative software 89, CLF update process 90, a report generation process 91, and the FAP utility process 92. FIG. 8a illustrates a detail data flow diagram for the form maintenance process 87. FIG. 8b illustrates a detail data flow diagram for the profile maintenance process 88. FIG. 8c illustrates detail data flow diagram for the CLF update process 90. FIG. 8d illustrates a detail data flow diagram for the report generation process 91; and FIG. 8e illustrates a detail data flow diagram for the FAP utility process 92.

FIG. 5 provides a schematic of a conventional host computer 34 and its interrelationship to other components in a typical configuration. The computer 34 may include applications software 49, a printer control 50, and a communications module 51. A printer 52, such as an IBM 3800, is controlled by the printer controller 50 software, e.g. JES AND AFP, both by IBM. Other printers 52, such as the Xerox 9700, of course may also be utilized. The communications module 51, such as an IBM SNA, is interconnected with a communications controller 53, such an an IBM 37XX FEP. A personal computer 54 may be interconnected to the controller 53 via a token ring or other link, and control a locally attached printer 16, or access other printers in the network. The controller 53 is connected through modems 55 to other PCs 54 (at sites 15). Controller 53 can communicate through the token ring 31 with the CLF 12 and FAP 14, or through modems 42 with the CLF 12. Communications may also be provided optionally through modems 56 with a cluster controller 57--such as an IBM 3174/3274--which in turn is interconnected with a communications interface (such as an IBM 3270) and a PC (such as a 3270 emulation PC). PC 58 may function as a print/file server to support multiple devices.

The controller 53 (typically located on host 34) will run a version of a network control program (e.g. OS/2 version 1.2from IBM) that supports peer to peer networking. The PC 54 has a Moore Forms Print Server. Therefore, CLF 12 communicates directly with PC 54 through controller 53 automatically, without "bothering" host 34.

The major menu items provided to the user of the FAP 14 are provided on menu screens. The main menu will allow selection of the forms design program, updating the central library with selected forms, defining a form profile for a current form, defining form fields for a current form, customer profile information, CLF profile information, and a customer profile query. Many others may also be provided. Typical screens for each of these above specific menu items are as follows:

For forms design, a list of the design software defined for a particular customer will be displayed, e.g.:

    ______________________________________
    Form   Profile   Library   Reports   Utility   Exit
    Run Form Design Program
    Enter Customer ID: 3-1234567-00000
    Form SW
    JFDESIGN
    PERFORM
    F3
    Char Mode:  Replace  Page 3    Count: 3
    ______________________________________

    ______________________________________
    Update   Exit
    Update Central Library with Selected Forms.
    CLF ID:
           SAVANNAH    CENTRAL LIBRARY UPDATE
                                             Dist
    Select
          Customer ID Form ID     Rev  Status
                                             Date
    ______________________________________
          3-1234567-00000
                      TINFORM     0    Com-
                                       pleted
          3-1234567-00000
                      SIGDEMO     0    Com-
                                       pleted
          3-1234567-00000
                      UMIVFILL    0    Com-
                                       pleted
    Press [F5] to return to menu
    To select Form for Library Update, enter `*`.
    To save selections, press [F10].
    Char Mode:  Replace  Page 1    Count: 3
    ______________________________________

    ______________________________________
    Profile   Query   Ext
    Define Form Profile for current form.
                   FORM FIELDS
    Field Name
            TIMFLD1      Sequence 1  Location 2.times.4in
    Field Type
            CHAR      Length 8    Format*******X
    Validation
            NONE
    Calculation
            NONE
    Field Name
            TIMFLD2      Sequence 2  Location 2.times.3in
    Field Type
            CHAR      Length 10   Format********X
    Validation
            NONE
    Calculation
            NONE
    Field Name
            TIMFLD3      Sequence 3  Location 4.times.4in
    Field Type
            DATE      Length 8    FormatMM-DD-YY
    Validation
            NONE
    Calculation
            NONE
    Press [F5] to return to menu
    Char Mode:  Replace  Page 2    Count: 3
    ______________________________________

    __________________________________________________________________________
    Fields   Query   Exit
    Define Form Fields for current form.
                            FORM PROFILE INFORMATION
    Cust ID
          3-1234567-00000
                      Cust Name
                            XYZ BANK
    Form ID
          TINFORM
                 Descr CUSTOMER ADD & TIN CHANGES-HP W/S2 CART.
    Revision
          0  Form Status
                     NEW    Release Status COMPLETED
    Form Path
          C:.backslash.XYZBANK
    Form Width
           8.5    No. of Pages 1
                          FORM FILES:
    Form Length
           11     No. of Parts 1
                          File Name
                                   PD Type
                                         CLF ID
    Orientation
           PORTRAIT
                  Duplex N
                          TINFORM.IFD
                                   HP S  SAVANNAH
    Form SW
           JFDESIGN       TINFORM.MDF
                                   HP C  SAVANNAH
                          TINFORM.PRT
                                   HP P  SAVANNAH
         By         Date
    Created
         FAP        19-NOV-90
    Modified
         FAP        19-NOV-90
    Released
    Press [F5] to return to menu
    Char Mode:  Replace  Page 1    Count: 1
    __________________________________________________________________________

    __________________________________________________________________________
    Query   Exit
    Move to query screen
                CUSTOMER PROFILE INFORMATION
    Cust ID 3-1234567-00000
                  Directory C:.backslash.CSBANK
    Cust Name XYZ BANK
                    Phone Number (800) 800-8000
    Contact S. Jones  Fax Number (800) 800-8001
    CUSTOMER ADDRESS:   SHIPPING ADDRESS:
    Addr  222 MAIN STREET
                     Addr 222 MAIN STREET
    City  SPRINGFIELD   City  SPRINGFIELD
    State ME
          Zip 00001
                 Cntry USA
                        State ME
                              Zip 00001
                                     Cntry USA
                   Attn S. JONES
    HW/SW HW/SW Name:
                   Description
    S     JFDESIGN JETFORM DESIGN V. 2.1
    H     HPLJIID  HEWLETT-PACKARD LASERJET IID
    S     PERFORM  PERFORM V.2.1
    Press [F5] to return to menu
    Char Mode:  Replace  Page 1    Count 1
    __________________________________________________________________________

    ______________________________________
    Query   Exit
    Move to query screen
            CENTRAL LIBRARY FACILITY PROFILE
            INFORMATION
                                 Customer ID
    CLF ID   SPRINGFIELD         3-1234567-00000
    Location XYZ BANK, SPRINGFIELD,
             ME
    Description
             IBM PS/2 MODEL 80,
             )S/2 V. 1.2
    Administrator
             S. JONES
    Phone    (800) 800-8000
    Number
    Modem    (800) 800-8002
    Number
    Fax Number
             (800) 800-8001
    Press [F5] to move to menu
    Char Mode:  Replace  Page 1    Count 1
    Exit
    Return to master record
    An exemplary customer profile query screen is:
            CUSTOMER PROFILE
            QUERY
            Cust ID
            3-1234567-00000
                           Hardware/Software
    CLF ID                 Type   Name
    ______________________________________
    SAVANNAH               H      HPLJIID
                           S      JFDESIGN
                           S      PERFORM
    ______________________________________

    ______________________________________
    FORMS AUTOMATION PLATFORM TABLES
    DATA                             Ref.
    ENTITY NAME  ALIAS               #
    ______________________________________
    ASSOCIATION  CUSTOMER/CLF        76
    INFO         ASSOCIATION TABLE
    CLF PROFILE  CLF MASTER TABLE    77
    CUSTOMER     CUSTOMER MASTER     78
    PROFILE      TABLE
    DISTRIBUTION FORM DISTRIBUTION   79
    INFO         TABLE
    FIELD        FORM FIELD DEFINITION
                                     80
    DESCRIPTIONS TABLE
    FORM         FORM DISTRIBUTION   81
    FILENAMES    FILENAMES TABLE
    FORM         FORM MASTER TABLE   82
    PROFILES
    FORM SW &    FORMS SW/PRINTERS   83
    PRINTER INFO TABLE
    PRINTER      FORM FILE PRINTER   84
    IDENTIFIERS  TYPES TABLE
    SYSTEM       FAP SYSTEM PARAMETER
                                     85
    PARAMETER INFO
                 TABLE
    ______________________________________

    ______________________________________
    CENTRAL LIBRARY FACILITY
    MAIN MENU
    ______________________________________
    Enter the Capital Letter of the Item Below and
    Press Enter ->
             Forms management
             Profile management
             Distribution management
             Release function
             Queries and reports
             Utilities
    F3=EXIT
    ______________________________________

    ______________________________________
    CENTRAL LIBRARY FACILITY
    FORMS MANAGEMENT MENU
    ______________________________________
    Enter the Capital Letter of the Item Below and
    Press Enter ->
             List/delete/update forms
             Field information list
             Output format list
             Print form
    F2=REFRESH  F3=EXIT
    ______________________________________

    __________________________________________________________________________
    CENTRAL LIBRARY FACILITY
    FORMS LIST
    Type a P in the action column to print and press PF4.
                Revision
                      Release
                           Creation
    Action Form Id
            Status
                Date  Date Date Forms Description
    __________________________________________________________________________
    .sub.-- CSADRTIN
            CUR --    --   --   CUSTOMER ADDRESS & TI
    .sub.-- CSDEMOGR
            CUR --    --   --   DEMOGRAPHIC INFORMATI
    .sub.-- CSSGNCRD
            CUR --    --   --   SIGNATURE CARD
    .sub.-- CSUNIVER
            CUR --    --   --   UNIVERSAL FORM
    .sub.--
    .sub.--
    .sub.--
    F3-EXIT  F4=QUEUE PRINT
    __________________________________________________________________________

    __________________________________________________________________________
    CENTRAL LIBRARY FACILITY
    PRINT FORMS
    __________________________________________________________________________
    Enter number of copies and destination for each form  More:  +
                            NUMBER
                                  PRINTER
                                        SITE
                                            CANCEL
    FORM ID
           FORM DESCRIPTION COPIES
                                  ID    ID  PRINT
    CSSGNCRD
           SIGNATURE CARD                   N
    PF3=EXIT  PF4=PROCESS REQUEST  PF8=NEXT FORM
    __________________________________________________________________________

    ______________________________________
    CENTRAL LIBRARY FACILITY
    PROFILE MANAGEMENT MENU
    ______________________________________
    Enter the Capital Letter of the Item Below and
    Press Enter ->
              User profile
              Category profile
              Site profile
              corporate proFile
              Geographic profile
              cusTomer profile
              grOup profile
              Printer profile
    F2=REFRESH  F3=EXIT
    ______________________________________

    __________________________________________________________________________
    USER PROFILE
    __________________________________________________________________________
    Update/Delete: Type "U" and/or "D" in ACTION column and press "ENTER"
    Add: Press F4; Associations: Type an "S" i ACTION column and press F6
    USER            CORP  GEO.
                              ****** LOCK OUT ******
    ACT
       ID   USER NAME
                    ID    ID  FLAG
                                  DATE   TIME
    __________________________________________________________________________
    -- TOM  Tom
    -- CLA  Cristie 111       Y   12-10-1990
                                         10:10:10
    -- DLY  Donna
    -- FEA  Fran
    -- JOE  Joe     111   232
    -- JZA  Julie
    -- SAN  SAM
    D002   ****   END OF OUTPUT   ****
    F2=REFRESH F3=EXIT F4=ADD
    __________________________________________________________________________

    __________________________________________________________________________
    USER PROFILE ADD
    __________________________________________________________________________
    Enter Data in all fields - THEN press "ENTER"
    User ID . . . :        User Name . . . :
    Corporate ID . . . :
    Geographic ID . . . :
    Telephone No . . . :
                      Distribution Tickler Flag . . ..sub.-- Amin.
                      flag..sub.--
    *******************************Lock Out Data******************************
    Lock Out Date:
                  Lock Out Time: Lock Out Flag.:.sub.--
    version 0.1
    ekF2=REFRESH F3=EXIT
    __________________________________________________________________________

    ______________________________________
    CENTRAL LIBRARY FACILITY
    SITE PROFILE
    ______________________________________
    Customer ID:   2-4561686-00000
    Customer Name:
                 State Bank
    Site ID
           Site Description
                          Geographic ID
                                      Network ID
    ______________________________________
    FLA001 Tampa Banking Dept
                          TPA001      FLATPA01
    GE0001 Atlanta Branch ATL001      GE0ATL01
    NYC002 New York Branch
                          NYC001      NYNYC02
    CHI003 Chicago Branch CHI001      ILCHI01
    SCA001 South Carolina Office
                          CAE001      SCACAE01
    PF3=EXIT
    ______________________________________

    ______________________________________
    CENTRAL LIBRARY FACILITY
    CUSTOMER PROFILE
    ______________________________________
    Customer ID:       2-4561686-00000
    Customer Name:     State Bank
    Address:           The American Road
                       Atlanta
                       GA 30123 USA
    Contact Name:      Don Jones
    Phone Number:      800-321-1234
    PF3=EXIT
    ______________________________________

    __________________________________________________________________________
    GROUPS LIST
    __________________________________________________________________________
    UPDATE/DELETE: Type U and/or D in action column and press Enter. ADD:
    Press F4;
    ASSOCIATION: Type an S in action column and press F6.
    Action
          Group ID
                Seq. #    Group Description
    __________________________________________________________________________
    --    G1    1         Test 1
    --    G2    1         Test 2
    --    G2    2         Test 3
    --    G3    1         Test 4
    --    G3    2         Test 5
    --    G3    3         Test 6
    --    GRP101
                1         New Group Added
    --    NRC001
                1         First MRC Group
    D002
        *****   END OF OUTPUT
                          ****
    F3=EXIT  F4=ADD  F6=ASSOCIATIONS    F12=CANCEL
    __________________________________________________________________________

    ______________________________________
    ADD DISTRIBUTION GROUP
    ______________________________________
    Type in entries for the distribution group and press
    <Enter> to add.
    Group Id . . .
    Sequence Number . . .
    Group Description . . .
    F3=EXIT                   E12=Cancel
    ______________________________________

    ______________________________________
    ASSOCIATION MENU
    ______________________________________
    Type the Id of a base item and press <Enter>, OR type an "S"
    and press <Enter> for a selection listing of the base item.
                            Association
    Base Item     Id        Items
    ______________________________________
    .sub.-- FORM . . .      .sub.-- GROUPS
    .sub.-- GROUP ID . . .  .sub.-- FORMS
                                      .sub.-- SITES
      SEQ. NUMBER . . .
    .sub.-- USER . . .      .sub.-- SITES
    .sub.-- SITE . . .      .sub.-- USERS
                                      .sub.-- PRINTERS
                            .sub.-- GROUPS
    .sub.-- PRINTER . . .   .sub.-- SITES
    F3=Exit                   F12=Cancel
    ______________________________________

    __________________________________________________________________________
    SITES ASSOCIATED WITH A GROUP
    __________________________________________________________________________
    Group ID: GI   SEQ:  1   DESC: TEST 1
    ADD: Press F4; DELETE: Type a "D" in action column and press <Enter>.
       SITE             CORP
                            GEO.             NET
    ACT
       ID    DESCRIPTION
                        ID  ID  MODEM TELEPHONE
                                             ID
    __________________________________________________________________________
    -- KANSAS
             KANSAS
    -- S1
    -- SIT101
             NEW SITE ADDED
    -- WISC  WISCONSIN
    D002 ****   END OF OUTPUT   ****
    F3=EXIT    F4=ADD    F12=CANCEL
    __________________________________________________________________________

    __________________________________________________________________________
    ADD SITES ASSOCIATED WITH A GROUP
    __________________________________________________________________________
    To add items to the association list, type one or more "S" in MORE:  +
    the action column and press <Enter>
       SITE             CORP
                            GEO.             NET
    ACT
       ID    DESCRIPTION
                        ID  ID  MODEM TELEPHONE
                                             ID
    __________________________________________________________________________
    -- ALA   ALABAMA
    -- CALIF CALIFORNIA
    -- COLO  COLORADO                        COLNET
    -- FLA   FLORIDA                         FLANET
    -- KANSAS
             KANSAS
    -- MASS  MASSACHUSETTS
    -- MICH  MICHIGAN
    -- MINN  MINNESOTA          55543210000000000
    -- S1
    -- S2
    -- S3
    -- SIT101
             NEW SITE ADDED 12-1-90
    F3=EXIT             F8=FWD       F12=CANCEL
    __________________________________________________________________________

    ______________________________________
    CENTRAL LIBRARY FACILITY
    PRINTER PROFILE
    ______________________________________
    Customer ID:
               2-4561686-00000
    Customer Name:
               State Bank
    Printer ID
              Printer Type
                          Printer Manufacturer Name
    ______________________________________
    01        PS          Adobe PostScript
    02        HP          Hewlett Packard LaserJet
    03        AF          IBM 3800 Printers
    04        AF          IBM 4019 Printer
    05        MF          XEROX 9700 Printer
    PF3=EXIT
    ______________________________________

    ______________________________________
    CENTRAL LIBRARY FACILITY
    DISTRIBUTION MENU
    ______________________________________
    Enter the Capital Letter of the Item Below and
    Press Enter->
           New form distribution cycle
           Add form distribution
           Delete form distribution
    FS=REFRESH  F3=EXIT
    ______________________________________

    ______________________________________
    CENTRAL LIBRARY FACILITY
    RELEASE FORMS MENU
    ______________________________________
    Enter the Capital Letter of the Item Below and
    Press Enter ->
             Release forms to site
             Automatic release
             release From remote site
    F2=REFRESH  F3=EXIT
    ______________________________________

    ______________________________________
    CENTRAL LIBRARY FACILITY
    RELEASE TO SITES
    ______________________________________
           Do you wish to release New/revised forms (N) or
    All forms (A)?
                   Enter Selection here (N, A) > .sub.--
           Also select one of the choices below:
           .sub.-- Release All Forms to All Sites
           .sub.-- Release All Forms for Specific Site(s)
           .sub.-- Release Specific Forms(s) to All Sites
           .sub.-- Release Specific Form(s) to Specific Sites
    F2=Refresh  F3=Exit
    ______________________________________

    __________________________________________________________________________
    TABLE NAME: CUSTOMER PROFILE ALIAS: CP
    __________________________________________________________________________
    ELEMENT/RECORD
                 DB TABLE ELE.
                              KEY LEN DEFINITION
    __________________________________________________________________________
    CLF Customer ID
                 CP.sub.-- CUS.sub.-- ID
                              1   006 Uniquely identifies each customer.
    Country Indicator
                 CP.sub.-- MBF.sub.-- CTRY.sub.-- ID
                              E   001 Country indicator for the customer ID.
    Customer ID  CP.sub.-- MBF.sub.-- ID
                              E   015 Corporate identifier for a customer.
    Customer Name
                 CP-NME       E   030 Name of customer.
    ADDR1        CP.sub.-- ADR.sub.-- 1
                              E   030 Street address one.
    ADDR2        CP.sub.-- ADR.sub.-- 2
                              E   030 Street address two.
    City         CP.sub.-- CTY
                              E   030 Name of city.
    State Prov   CP.sub.-- STE
                              E   004 State or province abbreviation.
    Zip          CP.sub.-- ZIP
                              E   010 The customer's zip code (U.S.) or
                                      postal code.
    Country      CP.sub.-- CTRY
                              E   004 Name of country in which the customer
                                      is located.
    Num Versions CP.sub.-- NBR.sub.-- ARC
                              E   001 Number of archived form versions to
                                      keep.
    Contact Name CP.sub.-- CTC
                              E   030 Name of the contact person at the
                                      customer location.
    Contact Phone
                 CP.sub.-- CTC.sub.-- TEL
                              E   015 Phone number of the customer contact
                                      person.
    Customer Status
                 CP.sub.-- STA.sub.-- CDE
                              E   001 Current CLF customer status `D` =
                                      deleted `A` = Activated
    Customer Status Date
                 CP.sub.-- STA.sub.-- DTE
                              E   008 Date of status change for customer
    CLF ID       CP.sub.-- CLF.sub.-- ID
                              E   010 A unique identifier for each customer's
                                      CLF
    Num Levels   CP.sub.-- NBR.sub.-- LVL
                              E   001 The number of corporate organization
                                      levels to be used
    Level Name 1 CP.sub.-- CORP.sub.-- LVL.sub.-- 1
                              E   015 First name for corporate level
                                      definition
    Level Name 2 CP.sub.-- CORP.sub.-- LVL.sub.-- 2
                              E   015 Second name for corporate level
                                      definition
    Level Name 3 CP.sub.-- CORP.sub.-- LVL.sub.-- 3
                              E   015 Third name for corporate level
                                      definition
    __________________________________________________________________________
    Key Data:
    Primary Key
           (CLF Customer ID)
    __________________________________________________________________________
    Indexes:
    Name On Columns
                   Type of Work
    __________________________________________________________________________
    Cusidx
         CLF Customer ID
                   Primary, Ascending, Unique
    __________________________________________________________________________
    Relationship to Other Tables:
    Parent of:
          Form Profile
          Category Profile
          Printer Profile
          Corporate Profile
          Geographic Profile
          User Profile
          Site Profile
          Group Profile
                    All Tables are Access Thru CLF Customer
    __________________________________________________________________________
                    ID

    ______________________________________
    TABLE NAME: CORPORATE PROFILE ALIAS: CO
    ______________________________________
             DB
    ELEMENT/ TABLE
    RECORD   ELE.     KEY    LEN  DEFINITION
    ______________________________________
    CLF               1      006  Uniquely identifies.
    Customer ID                   each customer.
    Corporate ID      2      006  Code for each different
                                  corporate profile for
                                  a customer
    Level 1           E      020  Highest level in corporate
                                  organization.
    Level 2           E      020  Second highest level in
                                  corporate organization.
    Level 3           E      020  Third highest level in
                                  corporate organization.
    ______________________________________
    Key Data:
    Primary Key  (CLF Customer ID, Corporate ID)
    Foreign Key  FK.sub.-- CORPA (CLF Customer ID)
                 References Customer Profile
                 on Delete Cascade;
    ______________________________________
    Indexes:
    Name    On Columns    Type of Index
    ______________________________________
    CORPIDX CLF Customer ID
                          Primary, Ascending, Unique
            Corporate ID
    ______________________________________
    Relationship to Other Tables:
    Parent of:  User Profile Thru CLF Customer ID,
                Corporate ID
                Site Profile Thru CLF Customer ID,
                Corporate ID
    Dependent of:
                Customer Profile Thru CLF Customer ID
    ______________________________________

    ______________________________________
    TABLE NAME: GEOGRAPHIC PROFILE ALIAS: GP
    ______________________________________
               DB
    ELEMENT/   TABLE
    RECORD     ELE.     KEY    LEN  DEFINITION
    ______________________________________
    CLF                 1      006  Uniquely identifies
    Customer ID                     each customer.
    Geographic ID       2      006  Unique Code for each
                                    different geographic
                                    profile used
    SMSA-Code           E      003
    Country Name        E      004  Name of Country
                                    (International Code).
    Region Name         E      020  Name of Region.
    State/Province      E      004  Name of State or
    Name                            Province.
    State Region        E      020  Name of Region with-
    Name                            in a State or Province.
    City Name           E      030  Name of City.
    City Region         E      030  Name of Region with-
    Name                            in City.
    Building/Branch     E      015  Code to Identify a
    ID                              Building or Branch.
    Floor Number        E      003  Number of the Floor
                                    in the Building.
    ______________________________________
    Key Data:
    Primary Key  (CLF Customer ID, Geographic ID)
    Foreign Key  FK.sub.-- GEOA (CLF Customer ID)
                 References Customer Profile
                 on Delete Cascade;
    ______________________________________
    INDEXES:
    Name    On Columns    Type of Index
    ______________________________________
    DEOIDX  CLF CUSTOMER  PRIMARY, ASCENDING,
            ID            UNIQUE
            GEOGRAPHIC ID
    ______________________________________
    Relationship to other Tables:
    Parent of:  User Profile Thru CLF Customer ID,
                Geographic ID
                Site Profile Thru CLF Customer ID,
                Geographic ID
    Dependent of:
                Customer Profile Thru CLF Customer ID
    ______________________________________

    __________________________________________________________________________
    TABLE NAME: SECURITY ALIAS: SE
    __________________________________________________________________________
    ELEMENT/RECORD
                 DB TABLE ELE.
                           KEY
                              LEN
                                 DEFINITION
    __________________________________________________________________________
    CLF Customer ID        1  006
                                 Uniquely identifies each customer.
    User ID                2  006
                                 The Logon ID associated with each CLF user.
    Password               3  006
                                 The Password associated with each user ID.
    Security Funct         E  001
                                 The Authority to maintain the security
                                 table.
    Prof Mgmt Funct        E  001
                                 The Authority to maintain profile tables.
    Form Mgmt Funct        E  001
                                 The Authority to maintain the central forms
                                 library.
    Dist Funct             E  001
                                 The Authority to control form distribution
                                 to end site.
    Release Funct          E  001
                                 The Authority to release forms to the end
                                 user site.
    Report Funct           E  001
                                 The Ability to produce reports.
    Security Level         E  001
                                 Defines the level of authority for each
                                 user.
    Distribution Tickler Flag
                           E  001
                                 Flag to indicate if new forms have arrived
                                 in the
                                 system.
    __________________________________________________________________________
    Key Data:
    Primary Key
           (CLF Customer ID, User ID, Password)
    Foreign Key
           FK.sub.-- Sea (CLF Customer ID, User ID)
           References User Profile
           On Delete Cascade;
    __________________________________________________________________________
    Indexes:
    Name On Columns
                   Type of Work
    __________________________________________________________________________
    SEIDX
         CLF Customer ID
                   Primary, Ascending, Unique
         User ID
         Password
    __________________________________________________________________________
    Relationship to Other Tables:
    Dependent of:
            User Profile Thru CLF Customer ID, User ID
    __________________________________________________________________________

    __________________________________________________________________________
    TABLE NAME: USER PROFILE ALIAS: UP
    __________________________________________________________________________
    ELEMENT/RECORD
                 DB TABLE ELE.
                           KEY
                              LEN
                                 DEFINITION
    __________________________________________________________________________
    CLF Customer ID        1  006
                                 Uniquely identifies each customer.
    User ID                2  006
                                 The Logon ID associated with each CLF user.
    User Name              E  030
                                 Name of User.
    User Phone             E  015
                                 Telephone number of user.
    Lock Out Flag          E  001
                                 Indicator which allows or prevents a user
                                 from signing
                                 on.
    Lock Out Date          E  002
                                 Date a user's ID is locked due to invalid
                                 access
                                 attempts.
    Lock Out Time          E  008
                                 Time a user's ID is locked due to invalid
                                 access
                                 attempts.
    Corporate ID           E  006
                                 Code for each different corporate profile
                                 for a
                                 customer.
    Geographic ID          E  006
                                 Unique code for each different geographic
                                 profile
                                 used.
    Distribution Tickler Flag
                           E  001
                                 Flag to indicate new forms have arrived in
                                 the
                                 database.
    __________________________________________________________________________
    Key Data:
    Primary Key
           (CLF Customer ID, User ID)
    Foreign Key
           FK.sub.-- USERA (CLF Customer ID, Corporate ID)
           References Corporate Profile
           On Delete Restrict;
    Foreign Key
           FK.sub.-- USERB (CLF Customer ID, Geographic ID)
           References Geographic Profile
           On Delete Restrict;
    Foreign Key
           FK.sub.-- USERC (CLF Customer ID)
           References Customer Profile
           On Delete Restrict;
    __________________________________________________________________________
    Indexes:
    Name   On Columns
                     Type of Index
    __________________________________________________________________________
    USERIDX
           CLF Customer ID
                     Primary, Ascending, Unique
           User ID
    USERIDXA
           CLF Customer ID
                     Ascending
           Corporate ID
    USERIDXB
           CLF Customer ID
                     Ascending
           Geographic ID
    Relationship to Other Tables:
    Parent of:
            User/Site Thru CLF Customer ID, Site
            Security Thru CLF Customer ID, User ID
    Dependent of:
            Customer Profile thru CLF Customer ID
            Corporate Profile thru CLF Customer ID, Corporate ID
            Geographic Profile thru CLF Customer ID, Geographic
    __________________________________________________________________________
            ID

    __________________________________________________________________________
    TABLE NAME: SITE PROFILE ALIAS: ST
    __________________________________________________________________________
    ELEMENT/RECORD
                DB TABLE ELE.
                           KEY
                              LEN
                                 DEFINITION
    __________________________________________________________________________
    CLF Customer ID
                ST.sub.-- CLF .sub.-- CUS.sub.-- ID
                           1  006
                                 Uniquely identifies each customer.
    Site ID     ST.sub.-- SITE.sub.-- ID
                           2  006
                                 Identifier to uniquely identify a site for a
                                 customer.
    Site Description
                ST.sub.-- DESCRIPTION
                           E  030
                                 Description of site
    Corporate ID
                ST.sub.-- CORP.sub.-- ID
                           E  006
                                 Code for each different corporate profile
                                 for a
                                 customer
    Geographic ID
                ST.sub.-- GEO.sub.-- ID
                           E  006
                                 Unique code for each different geographic
                                 profile used
    Modem Phone ST.sub.-- MODEM.sub.-- TEL
                           E  015
                                 The phone number to be dialed for
                                 communications.
    Network ID  ST.sub.-- NETWORK.sub.-- ID
                           E  004
                                 The physical communication identifier
    Data Type   ST.sub.-- CHR.sub.-- TYP
                           E  001
                                 Code to indicate if the site is ASCII or
                                 EBCIDIC
                                 data type
    __________________________________________________________________________
    Key Data:
    Primary Key
           (CLF Customer ID, Site ID)
    Foreign Key
           FK.sub.-- SITEA (CLF Customer ID)
           References Customer Profile
           On Delete Restrict;
    Foreign Key
           FK.sub.-- SITEB (CLF Customer ID, Corporate ID)
           References Corporate Profile
           On Delete Restrict;
    Foreign Key
           FK.sub.-- SITEC (CLF Customer ID, Geographic ID)
           References Geographic Profile
           On Delete Restrict;
    __________________________________________________________________________
    Indexes:
    Name   On Columns
                     Type of Work
    __________________________________________________________________________
    SITEIDX
           CLF Customer ID
                     Primary, Ascending, Unique
           Site ID
    SITEIDXA
           CLF Customer ID
                     Ascending
           Corporate ID
    SITEIDXB
           CLF Customer ID
                     Ascending
           Geographic ID
    __________________________________________________________________________
    Relationship to Other Tables:
    Parent of:
            User/Site Profile thru CLF Customer ID, Site ID
            Site/Printer Profile thru CLF Customer ID, Site ID
            Site/Group Profile thru CLF Customer ID, Site ID
    Dependent of:
            Customer Profile thru CLF Customer ID
            Corporate Profile thru CLF Customer ID, Corporate ID
            Geographic Profile thru CLF Customer ID, Geographic
    __________________________________________________________________________
            ID

    ______________________________________
    TABLE NAME: SITE/USER DATA ALIAS: SU
    ______________________________________
             DB
    ELEMENT/ TABLE
    RECORD   ELE.     KEY    LEN  DEFINITION
    ______________________________________
    CLF               1      006  Uniquely identifies
    Customer ID                   each customer.
    Site ID           2      006  Identifier to uniquely
                                  identify a site for a
                                  customer
    User ID           3      006  The Logon ID associated
                                  with each CLE user.
    ______________________________________
    Key Data
    Primary Key (CLF Customer ID, Site ID, User ID)
    Foreign Key FK.sub.-- SUA (CLF Customer ID, User ID)
                References User Profile
                On Delete Cascade;
    Foreign Key FK.sub.-- SUB (Clf Customer ID, Site ID)
                References Site Profile
                On Delete Cascade;
    ______________________________________
    Indexes:
    Name    On Columns    Type of Index
    ______________________________________
    SUIDX   CLF Customer ID
                          Primary, Ascending, Unique
            Site ID
            User ID
    SUIDXA  CLF Customer ID
                          Ascending
            User ID
    SUIDXB  CLF Customer ID
                          Ascending
            Site ID
    ______________________________________
    Relationship to Other Tables:
    Dependent of:
              User Profile thru CLF Customer ID, User ID
              Site Profile thru CLF Customer ID, Site ID
    ______________________________________

    __________________________________________________________________________
    TABLE NAME: GROUP PROFILE ALIAS: GR
    __________________________________________________________________________
    ELEMENT/RECORD
                 DB TABLE ELE.
                             KEY
                                LEN
                                   DEFINITION
    __________________________________________________________________________
    CLF Customer ID
                 GR.sub.-- CLF.sub.-- CUS.sub.-- ID
                             1  006
                                   Uniquely identifies each customer.
    Group ID     GR.sub.-- GRP.sub.-- ID
                             2  006
                                   Code to uniquely identify the distribution
                                   group.
    Group Sequence Number
                 GR.sub.-- GRP.sub.-- SEQ.sub.-- NBR
                             3  003
                                   Sequence number to control level within a
                                   group.
    Group Description
                 GR-GRP.sub.-- DSC
                             E  030
                                   Description of the distribution
    __________________________________________________________________________
                                   group.
    Key Data:
    Primary Key
           (CLF Customer ID, Group ID, Group Sequence Number)
    Foreign Key
           FK.sub.-- GRPA (CLF Customer ID)
           References Customer Profile
           On Delete Cascade;
    __________________________________________________________________________
    Indexes:
    Name  On Columns   Type of Index
    __________________________________________________________________________
    GRPIDX
          CLF Customer ID
                       Primary, Ascending, Unique
          Group ID
          Group Sequence Number
    __________________________________________________________________________
    Relationship to Other Tables:
    Parent of:
            Site/Group thru CLF Customer ID, Group ID, Group Sequence Number
            Group/Form thru CLF Customer ID, Group ID, Group Sequence Number
    Dependent of:
            Customer Profile thru CLF Customer ID
    __________________________________________________________________________

    __________________________________________________________________________
    TABLE NAME: SITE/GROUP DATA ALIAS: SG
    __________________________________________________________________________
    ELEMENT/RECORD
                 DB TABLE ELE.
                             KEY
                                LEN
                                   DEFINITION
    __________________________________________________________________________
    CLF Customer ID
                 SG.sub.-- CLF.sub.-- CUS-ID
                             1  006
                                   Uniquely identifies each customer.
    Site ID      SG.sub.-- SITE.sub.-- ID
                             2  006
                                   Identifier to uniquely identify a site for
                                   a customer
    Group ID     SG.sub.-- GRP.sub.-- ID
                             3  006
                                   Code to uniquely identify the distribution
                                   group
    Group Sequence Number
                 SG.sub.-- GRP.sub.-- SEQ.sub.-- NBR
                             4  003
                                   Sequence number to control level within a
                                   group
    __________________________________________________________________________
    Key Data:
    Primary Key
           (CLF Customer ID, Site ID, Group ID, Group Sequence Number)
    Foreign Key
           FK.sub.-- SGA (CLF Customer ID, Site ID)
           References Site Profile
           On Delete Cascade;
    Foreign Key
           FK.sub.-- SGB (CLF Customer ID, Site ID)
           References Group Profile
           On Delete Cascade;
    __________________________________________________________________________
    Indexes:
    Name  On Columns   Type of Index
    __________________________________________________________________________
    SGIDX CLF Customer ID
                       Primary, Ascending, Unique
          Site ID
          Group ID
          Group Sequence Number
    SGIDXA
          CLF Customer ID
                       Ascending
          Site ID
    SGIDXB
          CLF Customer ID
                       Ascending
          Group ID
          Group Sequence Number
    __________________________________________________________________________
    Relationship to Other Tables:
    Dependent of:
            Site Profile thru CLF Customer ID, Site ID
            Group Profile thru CLF Customer ID, Group ID, Group Sequence
            Number
    __________________________________________________________________________

    __________________________________________________________________________
    TABLE NAME: PRINTER PROFILE ALIAS: PP
    __________________________________________________________________________
    ELEMENT/RECORD
                 DB TABLE ELE.
                             KEY
                                LEN
                                   DEFINITION
    __________________________________________________________________________
    CLF Customer ID
                 PP.sub.-- CLF.sub.-- CUS.sub.-- ID
                             1  006
                                   Uniquely identifies each customer.
    Printer ID   PP.sub.-- PTR.sub.-- ID
                             2  006
                                   Code to uniquely identify each printer.
    Printer Type PP.sub.-- PTR.sub.-- TYP
                             E  002
                                   Code of printer type (see list below).
    Printer Type Description
                 PP.sub.-- PTR.sub.-- DSC
                             E  015
                                   Description of the printer and printer
                                   type
    Printer MFR Name
                 PP.sub.-- PTR.sub.-- MFR.sub.-- NME
                             E  020
                                   Name of printer manufacturer
    __________________________________________________________________________
    Key Data:
    Primary Key
           (CLF Customer ID, Printer ID)
    Foreign Key
           FK.sub.-- PTRA (CLF Customer ID)
           References Customer Profile
           On Delete Cascade;
    __________________________________________________________________________
    Indexes:
    Name On Columns
                   Type of Index
    __________________________________________________________________________
    PTRIDX
         CLF Customer ID
                   Primary, Ascending, Unique
         Printer ID
    __________________________________________________________________________
    Relationship to Other Tables:
    Parent of:
            Site/Printer Thru CLF Customer ID, Printer ID
    Dependent of:
            Customer Profile thru CLF Customer ID
    __________________________________________________________________________
    Printer Type Codes:
               Code
                  Description
    __________________________________________________________________________
               HP HP PCL
               H5 HP PCL 5
               AF AFP
               MF META FILE
               DT DOT MATRIX
               XC XICS
               PS POSTSCRIPT
               DC DOT MATRIX COLOR
    __________________________________________________________________________

    __________________________________________________________________________
    TABLE NAME: SITE/PRINTER DATA ALIAS: SP
    __________________________________________________________________________
    ELEMENT/RECORD
                DB TABLE ELE.
                          KEY
                             LEN
                                DEFINITION
    __________________________________________________________________________
    CLF Customer ID
                SP.sub.-- CLF.sub.-- CUS.sub.-- ID
                          1  006
                                Uniquely identifies each customer
    Site ID     SP.sub.-- SITE.sub.-- ID
                          2  006
                                Identifier to uniquely identify a site for a
                                customer
    Printer ID  SP.sub.-- PTR.sub.-- ID
                          3  006
                                Identifier to uniquely identify a printer
    Printer Type
                SP.sub.-- PTR-TYP
                          4  002
                                Code of printer type (see list below under
                                printer
                                profile)
    __________________________________________________________________________
    Key Data:
    Primary Key
           (CLF Customer ID, Site ID, Printer Type)
    Foreign Key
           FK.sub.-- SPA (CLF Customer ID, Site ID)
           References Site Profile
           On Delete Cascade;
    Foreign Key
           FK.sub.-- SPB (CLF Customer ID, Printer ID)
           References Printer Profile
           On Delete Cascade;
    __________________________________________________________________________
    Indexes:
    Name On Columns
                   Type of Index
    __________________________________________________________________________
    SPIDX
         CLF Customer ID
                   Primary, Ascending, Unique
         Site ID
         Printer ID
    SPIDXA
         CLF Customer ID
                   Ascending
         Site ID
    SPIDXB
         CLE Customer ID
                   Ascending
         Printer ID
    __________________________________________________________________________
    Relationship to Other Tables:
    Parent of:
            Distribution Profile thru CLF Customer ID, Site ID, Printer ID
    Dependent of:
            Printer Profile thru CLF Customer ID, Printer ID
            Site Profile Thru CLF Customer ID, Site ID
    __________________________________________________________________________

    __________________________________________________________________________
    TABLE NAME: DISTRIBUTION PROFILE ALIAS: DP
    __________________________________________________________________________
    ELEMENT/RECORD
                DB TABLE ELE.
                           KEY
                              LEN
                                 DEFINITION
    __________________________________________________________________________
    CLF Customer ID
                DP.sub.-- CLF.sub.-- CUS.sub.-- ID
                           1  006
                                 Uniquely identifies each customer
    FORM ID     DP.sub.-- FRM.sub.-- ID
                           2  008
                                 Code to uniquely identify a form for a
                                 customer
    SITE ID     DP.sub.-- SIT.sub.-- ID
                           3  006
                                 Identifier to uniquely identify a site for a
                                 customer
    Printer Type
                DP.sub.-- PTR.sub.-- TYPE
                           4  002
                                 Code of printer type (see list on printer
                                 profile)
    Printer ID  DP.sub.-- PTR.sub.-- ID
                           5  006
                                 Code to uniquely identify a printer
    Release Code
                SP.sub.-- RLS.sub.-- CDE
                           E  001
                                 Code to indicate release action (see list
                                 below)
    Xmit Date   DP.sub.-- XMIT.sub.-- DTE
                           E  008
                                 Date the form was transmitted (released) to
                                 the site
    __________________________________________________________________________
    Key Data:
    Primary Key
           (CLF Customer ID, Form ID, Site ID, Printer ID)
    Foreign Key
           FK.sub.-- DPA (CLF Customer ID, Form ID)
           References Form Profile
           on Delete Cascade;
    Foreign Key
           FK.sub.-- DPB (CLF Customer ID, Site ID, Printer ID, Printer
           Type)
           References Site/Printer Data
           On Delete Cascade;
    __________________________________________________________________________
    Indexes:
    Name  On Columns
                    Type of Index
    __________________________________________________________________________
    DPIDX CLF Customer ID
                    Primary, Ascending, Unique
          Form ID
          Site ID
          Printer ID
    DPIDXA
          CLF Customer ID
                    Ascending
          Form ID
    DPIDXB
          CLF Customer ID
                    Ascending
          Site ID
          Printer ID
          Printer Type
    DPIDXC
          CLF Customer ID
                    Ascending
          Printer Type
    __________________________________________________________________________
    Relationship to Other Tables:
    Dependent of:
            Site/Printer Data thru CLF Customer ID, Site ID, Printer ID
            Form Profile thru CLF Customer ID, Form ID
    __________________________________________________________________________
    Release Codes:
            Code
               Description
    __________________________________________________________________________
            0  Form is current
            1  Form is new to distribution
            2  Forms has been revised
            9  Form is inactive (logically deleted)
    __________________________________________________________________________

    __________________________________________________________________________
    TABLE NAME: FORM PROFILE ALIAS: FP
    __________________________________________________________________________
    ELEMENT/RECORD DB TABLE ELE.  KEY LEN DEFINITION
    __________________________________________________________________________
    CLF Customer ID
                   FP.sub.-- CLF.sub.-- CUS.sub.-- ID
                                  1   006 Uniquely identifies each customer.
    Form ID        FP.sub.-- FORM.sub.-- ID
                                  2   008 Code to uniquely identify a form
                                          for a customer.
    Form Sub ID    FP.sub.-- FRM.sub.-- SUB.sub.-- ID
                                  3   003 Code to uniquely identify each
                                          revision of the form.
    Customer Catalog Number
                   FP.sub.-- CUS.sub.-- CAT.sub.-- NBR
                                  E   015 Customers number to identify the
                                          form.
    Form Description
                   FP-Description E   030 Description of form.
    Form Design Software
                   FP.sub.-- Design.sub.-- SFW
                                  E   010 Software package used to design the
                                          form.
    Form Status Code
                   FP.sub.-- STA.sub.-- CDE
                                  E   001 Code to indicate that the form is
                                          new or revised.
    Form Creation Date
                   FP.sub.-- CRE-DATE
                                  E   010 Date form was created (from FAP).
    Form Revision Date
                   FP.sub.-- REV.sub.-- DATE
                                  E   010 Date form was last revised (from
                                          FAP).
    Form Release Date
                   FP.sub.-- RLS.sub.-- DATE
                                  E   010 Date the form is to be released to
                                          users.
    Prior Release Date
                   FP.sub.-- OLD.sub.-- RLS.sub.-- DTE
                                  E   010 Date of the previous release date
    Category ID    FP.sub.-- CTG.sub.-- ID
                                  E   010 Code of form category to which a
                                          form is assigned
    FAP ID         FP.sub.-- FAP.sub.-- ID
                                  E   010 Unique identifier of the FAP that
                                          created the form.
    FAP Phone Modem Number
                   FP.sub.-- FAP.sub.-- TEL.sub.-- MODEM
                                  E   015 Telephone number of the FAP modem.
    Number of Parts
                   FP.sub.-- NBR.sub.-- PRT
                                  E   003 Number of parts to the form.
    Forms Orientation
                   FP.sub.-- ORT  E   001 Code to identify landscape (L) or
                                          portrait (P) mode.
    Length of Form FP.sub.-- LEN  E   008 Length of the form.
    Width of the Form
                   FP.sub.-- WID  E   008 Width of the form.
    __________________________________________________________________________
    Key Data:
    Primary Key
           (CLF Customer ID, Form ID, Form Sub ID)
    Foreign Key
           FK.sub.-- FPA (CLF Customer ID)
           References Customer Profile
           On Delete Cascade;
    Foreign Key
           FK.sub.-- FPB (CLF Customer ID, Category ID)
           References Category Profile
           On Delete Set Null;
    __________________________________________________________________________
    Indexes:
    Name On Columns
                   Type of Index
    __________________________________________________________________________
    FPIDX
         CLF Customer ID
                   Primary, Ascending, Unique
         Form ID
         Form Sub ID
    FPIDXA
         CLF Customer ID
                   Ascending
         Category ID
    __________________________________________________________________________
    Relationship to Other Tables:
    Parent of:
            Distribution Profile thru CLF Customer ID, Form ID
            Form Output Format thru CLF Customer ID, Form ID, Form Sub ID
            Form Field Information thru CLF Customer ID, Form ID, Sub ID
    Dependent of:
            Customer Profile thru CLF Customer ID
            Category Profile thru CLF Customer ID, Category
    __________________________________________________________________________
            ID

    __________________________________________________________________________
    TABLE NAME: CATEGORY TABLE ALIAS: CT
    __________________________________________________________________________
    ELEMENT/RECORD
                DB TABLE ELE.
                           KEY
                              LEN
                                 DEFINITION
    __________________________________________________________________________
    CLF Customer ID
                CT.sub.-- CLF.sub.-- CUS.sub.-- ID
                           1  006
                                 Uniquely identifies each customer.
    Category ID CT.sub.-- CTG.sub.-- ID
                           2  010
                                 Code of form category to which a form is
                                 assigned.
    Category Description
                CT.sub.-- CTG.sub.-- DSC
                           E  030
                                 Description of form category.
    Key Data:
    Primary Key (CLF Customer ID, Category ID)
    Foreign Key (FK.sub.-- CTA (CLF Customer ID)
    References Customer Profile
    on Delete Restrict;
    __________________________________________________________________________
    Name            On Columns            Type of Index
    __________________________________________________________________________
    Indexes:
    CTIDX           CLF Customer ID       Primary, Ascending, Unique
                    Category ID
    Relationship to Other Tables:
    Parent of:      Form Profile thru Category ID
    Dependent of:   Customer Profile thru CLF Customer ID
    __________________________________________________________________________

    __________________________________________________________________________
    TABLE NAME: USAGE STATISTICS ALIAS: STAT
    ELEMENT/RECORD
                DB TABLE ELE.
                           KEY
                              LEN
                                 DEFINITION
    __________________________________________________________________________
    CLF Customer ID        E  006
                                 Uniquely identifies each customer.
    Form ID                E  008
                                 Code to uniquely identify a form for a
                                 customer.
    Form Sub ID            E  002
                                 Code to uniquely identify each revision of
                                 the form.
    User ID                E  006
                                 The logon ID associated with each CLF user.
    Printer Type           E  002
                                 Code of printer type (HP-PCL, Postscript,
                                 etc.).
    Site ID                E  006
                                 Identifier to uniquely identify a site for a
                                 customer.
    Date Used              E  002
                                 Date the form was used
    Time Used              E  002
                                 Time the form was used
    Number of Copies       E  002
                                 The number of copies printed at user
    __________________________________________________________________________
                                 site.

    __________________________________________________________________________
    NAME: FORM FIELD INFORMATION ALIAS: FF
    __________________________________________________________________________
    ELEMENT/RECORD
                DB TABLE ELE.
                           KEY
                              LEN
                                 DEFINITION
    __________________________________________________________________________
    CLF Customer ID        1  006
                                 Uniquely identifies each customer.
    Form ID                2  008
                                 Code to uniquely identify a form for a
                                 customer.
    Form SUB ID            3  003
                                 Code to uniquely identify each revision of
                                 the form.
    Field Number           4  003
                                 Sequential number of fields within a form.
    Field Name             E  020
                                 Name of the field
    Data Description       E  040
                                 Concise description of data used in this
                                 field
    Field Length           E  002
                                 Describes the length of the field
    Field Format           E  005
                                 Describes the field format.
    Field Type             E  001
                                 Defines the field type. I.E. Numeric
    Field Location         E  040
                                 The location of the data in the users file
    Key Data:
    Primary Key (CLF Customer ID, Form ID, Form Sub ID, Field Number)
    Foreign Key FK.sub.-- FF (CLF Customer ID, Form ID, Form Sub ID)
    References Form Profile
    on Delete Cascade;
    __________________________________________________________________________
    Name           On Columns               Type of Index
    __________________________________________________________________________
    Indexes:
    FFIDX          CLF Customer ID          Primary, Ascending, Unique
                   Form ID
                   Form Sub ID
                   Field Number
    Relationship to Other Tables:
    Dependent of:  Form Profile thru CLF Customer ID, Form ID,
                   Form Sub ID
    __________________________________________________________________________

    __________________________________________________________________________
    NAME: FORM OUTPUT FORMAT ALIAS: FO
    __________________________________________________________________________
    ELEMENT/RECORD
                DB TABLE ELE.
                            KEY
                               LEN
                                  DEFINITION
    __________________________________________________________________________
    CLF Customer ID
                FO.sub.-- CLF.sub.-- CUS.sub.-- ID
                            1  006
                                  Uniquely identifies each customer.
    Form ID     FO.sub.-- FORM.sub.-- ID
                            2  008
                                  Code to uniquely identify a form for a
                                  customer.
    Form Sub ID FO.sub.-- FRM.sub.-- SUB.sub.-- ID
                            3  002
                                  Code to uniquely identify each revision of
                                  the form.
    Output Format Type
                FO.sub.-- FRMT.sub.-- TYP
                            4  001
                                  Code that describes from type S = Source C
                                  = Compile
                                  P = Print Ready
    Printer Type
                FO.sub.-- PTR.sub.-- TYP
                            5  002
                                  Code of printer type (HP-PCL, Postscript,
                                  etc.).
    Form Format File ID
                FO.sub.-- FILE.sub.-- NAME
                            E  012
                                  File ID where form format data is stored.
                                  DOS 8.3
                                  Format.
    Compression Indicator
                FO.sub.-- COMPRESS.sub.-- IND
                            E  001
                                  Code to tell if the form is compressed. Y =
                                  Yes N = No
    Key Data:
    Primary Key (CLF Customer ID, Form ID, Form Sub IS, Output Format Type,
    Printer Type)
    Foreign Key FK.sub.-- FOA (CLF Customer ID, Form ID, Form Sub ID)
    References Form Profile
    On Delete Cascade;
    __________________________________________________________________________
    Name           On Columns                  Type of Index
    __________________________________________________________________________
    Indexes:
    FOIDX          CLF Customer ID             Primary, Ascending, Unique
                   Form ID
                   Form Sub ID
                   Output Format Type
                   Printer Type
    Relationship to Other Tables:
    Dependent of:  Form Profile thru CLF Customer ID, Form ID, Form
                   Sub ID
    __________________________________________________________________________

    __________________________________________________________________________
    NAME: MENU ALIAS: MENU
    __________________________________________________________________________
    ELEMENT/RECORD
                DB TABLE ELE.
                           KEY
                              LEN
                                 DEFINITION
    __________________________________________________________________________
    Security Level         1  000
                                 Defines the level of authority for each
                                 user.
    Program ID
    Program Name
    Program Desc
    Screen Loc
    Trans ID
    Key Data:
    Primary Key (CLF Customer ID, ????)
    Foreign Key CATA (CLF Customer ID)
    References Customer Profile
    On Delete Cascade;
    __________________________________________________________________________

    __________________________________________________________________________
    NAME: GROUP/FORM ALIAS: GF
    __________________________________________________________________________
    ELEMENT/RECORD
                 DB TABLE ELE.
                            KEY
                               LEN
                                  DEFINITION
    __________________________________________________________________________
    CLF Customer ID         1  006
                                  Uniquely identifies each customer.
    Group ID                2  006
                                  Code to uniquely identify the distribution
                                  group.
    Group Sequence Number   3  003
                                  Sequence number to control level within a
                                  group
    Form ID                 4  008
                                  Code to uniquely identify a form for a
                                  customer.
    Key Data:
    Primary Key (CLF Customer ID, Group ID, Group Sequence Number, Form ID)
    Foreign Key FK.sub.-- GFA (CLF Customer ID, Group ID, Group Sequence
    Number)
    References Group Profile
    On Delete Cascade;
    __________________________________________________________________________
    Name           On Columns              Type of Index
    __________________________________________________________________________
    Indexes:
    GFIDX          CLF Customer ID         Primary, Ascending, Unique
                   Group ID
                   Group Sequence Number
                   Form ID
    GFIDXA         CLF Customer ID         Ascending
                   Group ID
                   Group Sequence Number
    GFIDXB         CLF Customer ID         Ascending
                   Form ID
    Relationship to Other Tables:
    Dependent of:  Group Profile thru CLF Customer ID, Group ID,
                   Group Sequence Number
    __________________________________________________________________________