DOCUMENT MANAGEMENT SYSTEM
Document management systems are disclosed herein. One disclosed example computer implemented method includes obtaining, via one or more processors, a data set representing attributes of one or more documents, obtaining a passport file, where the passport file includes an identifier, a schema designation and a workflow designation, generating a metadata file based on the data set and the schema, validating the metadata file against requirements defined by the schema, and generating a document production package including the passport file, the metadata file, and a data file.
This patent application arises as a continuation of U.S. patent application Ser. No. 12/614,092, filed on Nov. 6, 2009, entitled Document Management System, which claims the benefit of U.S. Provisional Application No. 61/198,644, filed on Nov. 7, 2008, both of which are incorporated herein by reference in their entirety.
INTRODUCTIONThe present invention is directed to computer systems and program controlled computer operations. More particularly, the present invention is directed to sophisticated networked document management systems.
BACKGROUNDBusiness and corporate documents come in many shapes and sizes. Without any restriction on the scope discussed herein, computers are often used to assist in the creation and management of documents, spanning from simple documents such as newsletters and emails, to very complicated documents such as SEC compatible corporate finance filings (10 ks, etc.). Depending on the document at issue, a very sophisticated computer system may be selectively programmed to assist in the creation of a document, to manage the corrective confirmation of the document contents, update the document as needed at designated intervals, and finally submit and/or distribute the document in accordance with its intended purpose.
Computer systems play a critical role in the management of documents under the regulation of the Securities and Exchange Commission (“SEC”). Specifically, on Wednesday, Dec. 17, 2008, the U.S. Securities and Exchange Commission (SEC) approved a final rule implementing the mandated use of XBRL (Extensible Business Reporting Language) for EDGAR (Electronic Data Gathering Analysis and Retrieving) submissions. The final rule phases in use of XBRL-based submissions for collecting financial reporting information over a period of four years, eventually impacting all domestic and foreign SEC reporting companies. The need to quickly and accurately provide XBRL compliant documents has placed a significant burden on corporations in managing this process. In addition to this, many non-financial document types are created by clients from a wide spectrum of backgrounds, businesses and resources. To meet the needs of these diverse clients, a flexible document management system, accessible through one or more discrete channels is needed. The following technology has been developed to address this (and other) needs.
OBJECTS AND TECHNOLOGICAL ENHANCEMENTSIt is therefore an object of the present invention to provide a method and apparatus for enhancing the creation of selectively styled documents in accord with predetermined requirements.
It is a further object of the present invention to provide a computer system programmed to assist in the document creation and management process for highly specialized business documents.
It is yet another object of the present invention to provide a computer interconnect bridge so that the document creation and distribution process is both secure and precise.
It is still a further object of the present invention to provide computer system architecture for supporting the secure and client customized preparation of select documents.
The above and other objects of the present invention are realized in a specific illustrative embodiment thereof, described below in connection with the following drawings.
For a more complete understanding of the specific embodiments,
The present invention can be accomplished in one or more techniques that include program controlled computers, selective data storage and computer processing steps on a data set representing attributes of a document. In a general sense, document management involves at least two aspects. The first aspect is document creation and this involves the selective arrangement of the content within a document framework. The creation process is, of course, dominated by the dictates of the document and its ultimate commercial purpose.
The second aspect of the document management process involves document formatting, publication and distribution. This aspect of the management process is directed to insuring that the content is conformed to particular standards and requirements, proofed for accuracy and otherwise formatted for its final purpose.
In the foregoing discussion, the DMS is presented as a unitary operation practiced by a single entity. In many instances, however, document processing is sufficiently complex that individual elements within the DMS process flow are separately managed. In fact, because of the specialized nature of document production management, many companies offer this as a specialized service. In this way, companies, such as publicly traded corporations, create and collect core business data, organize this data to conform the industry standards and then retain a second firm to package and produce the business data in conformed documents.
To illustrate this, consider the process for creating a corporate annual report for company XYZ listed on the New York Stock Exchange (NYSE). The report is created by collecting corporate financial records regarding profitability, sales and related data and organizing the data in accord with accepted accounting principles that permit shareholders to ascertain corporate financial health. Because of the highly regulated environment governing such financial reporting the document creation process is highly specialized. More recently, the process involves software supported creation tools including protocols such as XBRL, now mandated for all publicly trading corporations. In this regard, systems have been designed to facilitate the corporate document generation process. In the case of the XYZ corporation, data is transmitted to a second, separately managed facility that provides services to coordinate the proper formatting, tagging and dissemination of the resulting documents, including timely filing with the SEC. This division, along specialization and skill set, enhances productivity.
The XBRL protocol for tagging financial records is a powerful tool that, when properly implemented, can save time and resources. Assignees to the present invention have developed a XBRL platform that works in conjunction with the technology presented herein. This platform is disclosed in U.S. patent application Ser. No. 12/410,017 titled “Methods, Systems and Software for Processing Financial Documents.” filed on Mar. 24, 2009, the contents thereof are incorporated herein by reference.
In
The interface management module (“IMM”) can be embedded into an application or act as a stand-alone plug-in on an individual's desktop. The IMM enables an individual at the client side to upload a document(s), insert instructions, and directly submit to the central server for typesetting, filing, production, and distribution. Documents are not limited to Financial, Compliance, nor Investment Management documents and can be any type of document that the client possesses and submits for processing and disseminating. The IMM supports all type of file extensions including, without limitation, .doc, .docx, .tif, .ai, .pdf, .qxd, .ind, etc. The client chooses from one or more drop down menus to populate and create processing instructions. Free form fields provide client flexibility to communicate further details. Examples of these input screens are presented in
In one embodiment, there are multiple connection paths available from the client side to the production facility. The first to be discussed here is a Web Portal, comprising an Internet accessible web site connected to a server for facilitating data transfer. The Web Portal includes one or more separate screens (typically individual web pages) with a mix of data entry fields and instructions to facilitate data collection on the form.
In the Web Portal, the web form screens are used to collect the information necessary for the production facility to process the document(s) (“the corporate data file”) being submitted by the user. That information includes, but is not limited to what the user types in the web form. For example, the user doesn't have to enter address, or contact phone every time he/she submits the documents. This information can be retrieved from the user's profile, stored in database on the production facility side. Specifically, in a case of the Web Portal, the. Passport files for different clients are kept in the file storage of the server, and references to them are included into clients' profiles. When the Web Portal compiles the package for a particular client, it finds the Passport file based on information in the client's profile and includes the file in the package. Also, the web form screens perform basic business rules validation of the entered information. For example, a user can't submit document and specify the filing date/time to be in the past. After all data is collected (typed in, or retrieved from the production facility database), the Web Portal application generates the XML metadata file loading it with the collected information, and picks the appropriate Passport file based on the user's company (facility client). The two files are added to the package along with the files submitted by user—the payload files. The whole package generation happens on the Web Portal (i.e., on facility-controlled servers). The package is dropped into a uniquely named folder on a hard drive accessible by the Workflow Engine system. The Workflow Engine is then automatically notified about the received package by a small helper program.
Operation of the Web Portal can be understood more completely by reference to a series of screen images associated with the Web Portal access pages. Beginning with
In this illustration, the requesting company is interested in creating an Edgar compliant filing using the DMS external resources for tagging and distribution. Accordingly, after a successful login, operation moves to the screen image of
Continuing in
The next screen image,
For validation for each entry in the metadata, if the element is optional and displays a value of “0” for minOccurs no data is needed to be populate. This will pass validation through the passport acceptance level. If the element is mandatory and displays a value of “1” then if the individual does not enter information, the file will fail validation. Failed validation will not halt the process, workflow changes from automation to manual intervention. This algorithm checks the financial rules, but not formatting, which is done later. Once collected and checked, the upload process may be approved.
With the foregoing information collected, the next screen confirms some of the key demographics and permits correction/edits as needed. This is shown in
The technical architecture as shown above provides flexibility to integrate with any of the internal production systems and processes and does not negate nor limit accessible transmission methods from the external environment. The 360° transmission process adheres to strict security standards for all incoming and outgoing transmissions. The data and its integrity are typically processed without compromise. In a preferred arrangement, the data is not altered, encrypted, or changed in any way before processing.
The Passport file is the key identifier that provides mandatory information such as designated workflow based upon product/service identification. The Passport file is processed on the production side server. Once transmission is made, the Passport file triggers the operational workflow process. Table I below provides a typical Passport file.
The Passport file is provided by the production facility during the installation process of the Compliance Driver software at the client location, and attaches itself to the bundle that also includes the document data (the “data set”) for transmission. The Passport file includes the following pieces of information: the client ID, the application process to be applied to the transmitted data set, and finally, the schema; that is, a set of rules for the data set. This information is preferably transmitted using a GUID or global unique identifier to properly link the data to a specified flow path in production.
The underlying data associated with the Passport file is also presented preferably with select metadata to be associated with the project through production. A sample metadata file is presented below in Table II.
Table II-A uses the schema data referenced within Table II-B to populate mandatory and/or optional element fields for application integration, processing and validation. Table II-A correctly repurposes the naming conventions between one application and other applications to ensure data integration. Table II-A identifies the system/application where the supplied data will populate (i.e., <application> . . . </application>). The system/application and its associated workflow are rooted within the Passport file to determine transmission means and process flow. Although the metadata within the two tables are systematically ordered, the sequence of metadata is not essential because the element naming convention is the core the data relationship. Table II-B provides the data choices contained within specific drop down menus as well as contains the underlying validation criteria for these elements.
In order for the workflow to be successful, these Tables (II-A and II-B) perform two distinct tasks: 1) define what application and transmission means and 2) validate the data based upon field requirements.
XML schema variations are based upon individual production facility products or services; however, the xml schema will contain parallel metadata fields as displayed above that instructs workflow departments, captures and monitors workflow activities, and invoices and price work accordingly without manual intervention or administrative task.
In the foregoing metadata file, select metadata fields have been referenced. The declaration of fields provides a top level element (parent name) where as it identified the component. The element defines the name, the associated type of information that it will accept and its constraints. The element field names correspond and synch with our workflow application. Table III, below, provides an illustrative declaration for these fields:
As noted above, production facility Workflow Engine is notified about the incoming packages by a small helper program. The helper program sends a message to the Workflow Engine, containing a reference to the uniquely named folder on a hard drive, where the package was dropped by the receiving channel. Being invoked by the message from the helper program, the Workflow Engine accesses the folder referenced in the message. Based on the Passport file found in the folder, the Workflow Engine determines what internal workflow has to be initiated; then, it initiates the workflow passing the XML metadata file and all payload files to the first step of the workflow. A workflow may contain one or more steps, each performing a finite business task in the payload files processing. During its execution, a step can use data from the Passport file, from the XML metadata file, communicate with other production systems, send notification emails to human participants of the process, produce intermediate files, and even start other workflows, if needed.
In lieu of Web Portal access, information can be transmitted using a second path. Beginning with
In the Compliance Driver application, the collection and basic validation of user data and files happens in the standalone software that sits on the client side. During the first installation, the software requests a Passport file that it will use for the submission package preparation. The Passport files are distributed by the facility manager on per client workstation basis. When used, the Compliance Driver application is responsible for generating the XML metadata file, and loading it with the collected data. When the submission package is prepared, the application adds the XML metadata file, and the pre-installed Passport file to the package. The Compliance Driver application then sends the package to the production facility by email, bypassing the Web Portal completely. When the email with embedded package is received on the production facility side, the package is automatically extracted, and is dropped into a uniquely named folder on a hard drive accessible by the local Workflow Engine system. The Workflow Engine is then automatically notified about the received package by a small helper program.
Similar to the Web Portal approach, the Compliance Driver includes a series of screens for collecting key data and preparing for submission to the remote server supporting the production server. In
Specifically, the information collected at the client site under the guidance of the resident document link application is packaged into an email for secured delivery to the production facility.
Actual transmission via email is illustrated, for example, by an Outlook-based email as depicted in
In the above, the Submission.xml file must be validated against schema. The XML schema for the file is not attached to the email. The XML schema in Table IV for the metadata file is not typically included in a submission package but the schema is centrally located on the production facility Internet web site, and reference to it is specified in the Passport file, (Table I); the last element of the three is called <schema>. The metadata validator program (one of the steps in the workflow) actually looks into the Passport file and uses the reference found there to pull out the XML schema, and to validate the metadata against it. In Table V below, the particular values for elements in this implementation are presented for illustration.
While two transmission paths have been discussed, one using a Web Portal, the second using an email facility, these are not exhaustive. A third approach provides a direct “server” to “server” link over the Internet, avoiding both Web Portal and email attributes. This is referenced below.
Turning now to the operation flow depicted in
Logically continuing beyond block 110, the three files include the “document,” block 120, holding the company specific data, the Passport xsd file for confirming client and job processing details, block 130, and the XML instance, comprising the metadata “calls” to the work order system to populate the work order fields, block 140. Upon transmission through a secure link, these three files go into “production” at the remote facility, block 150. The interpretation of the incoming files triggers one or more of:
1. Job created
2. Work order created
Once the job created block 160 is complete, alternative/parallel paths to composition (block 170), filing service (block 180), production (block 190) and fulfillment (block 200) are provided with corresponding functional operations at block 210-240, respectively. Logic sequences look to Test 250 for any “changes,” and ultimately to completion, block 260.
The system architecture comprises the production facility, the client side and the bridge between the two as depicted in
Moving from left to right in
As discussed above, an email channel into production is supported “using an external secure email provider server, block 320 with email messages relayed directly to the corporate email server 610 in the ‘green’ zone.”
Not shown, but logically connected to the green zone, is the SEC server configured to receive properly formatted, conformed and “tagged” financial documents in compliance with current SEC protocols.
As the virtual business environment further evolves, facilitated communication is essential for processing and guiding information over secure and reliable channels to remote document management systems. The Compliance Driver and IMM may be utilized for most document-based products and services, including non-financial document management.
While the invention has been particularly shown and described with reference to a preferred embodiment, it will be understood by those skilled in the art that various changes in form and detail may be made therein without departing from the spirit and scope of the invention.
The following claims use terms that should be given their ordinary and accustomed meaning and other terms that have a meaning that is readily understood to persons skilled in the art of the invention in view of the specification. Nothing in this patent specification should be construed as a disclaimer of subject matter including elements in any claim that also reside in the prior art. In construing the following claims, care should be taken to construe the claim as a whole and nothing in the patent specification should be construed as a surrender of the fair inclusion of equivalents for specific elements in the claims under appropriate circumstances as controlled by the judicial doctrine of equivalents.
Claims
1. A computer implemented method comprising:
- obtaining, via one or more processors, a data set representing attributes of one or more documents;
- obtaining a passport file, wherein the passport file includes an identifier, a schema designation, and a workflow designation;
- generating a metadata file based on the data set and the schema;
- validating the metadata file against requirements defined by the schema; and
- generating a document production package including the passport file, the metadata file, and a data file.
2. A computer implemented method as defined in claim 1, wherein the requirements include field requirements.
3. A computer implemented method as defined in claim 1, wherein the schema includes an XML schema.
4. A computer implemented method as defined in claim 1, wherein the data file includes a client data file.
5. A computer implemented method as defined in claim 1, wherein the identifier includes a client identifier.
6. A computer implemented method as defined in claim 1, further including transmitting the document production package to a document production facility.
7. A computer implemented method as defined in claim 6, wherein transmitting the document production package includes at least one of:
- emailing the document production package;
- transmitting the document production package via a secure communication channel; or
- transmitting the document production package via a Web Portal.
8. The computer implemented method of claim 1, wherein the metadata file includes at least one of:
- a schema designation;
- client information;
- application information, wherein the application information identifies a source application of the metadata file;
- salesperson information;
- work-order information, wherein the work-order information includes territory information and file format information;
- task list information; or
- delivery information, wherein the delivery information includes one or more of a request date, a filing date, a delivery date or a delivery time.
9. A method comprising:
- receiving a document production package including a passport file, a metadata file and a data file, wherein the passport file includes an identifier, a designation of a schema and a workflow designation, and wherein the metadata file is generated based on a document data file and the schema; and
- producing a document based on the document production package.
10. A method as defined in claim 9, wherein the data set represents attributes of a document.
11. A method as defined in claim 9, wherein the schema includes an XML schema.
12. A method as defined in claim 9, wherein the identifier includes a client identifier.
13. A method as defined in claim 9, wherein the data file includes a client data file.
14. A method as defined in claim 9, further including generating an invoice based on the metadata file and the document production package.
15. The method as defined in claim 9, wherein the metadata file includes at least one of:
- a schema designation;
- client information;
- application information, wherein the application information identifies a source application of the metadata file;
- salesperson information;
- work-order information, wherein the work-order information includes territory information and file format information;
- task list information; or
- delivery information, wherein the delivery information includes one or more of a request date, a filing date, a delivery date or a delivery time.
16. A computer system for implementing a production process of tagged compliance documents, comprising:
- a server to receive document control instructions, wherein the document control instructions include a passport file, a metadata file and a document data file, and wherein the passport file includes an identifier, a schema designation and a workflow designation; and
- a processor to process the document control instructions by identifying a client and a document production process from the passport file, and by implementing the production process based on the document control instructions.
17. A computer system as defined in claim 16, wherein the processor is to implement the production process by transmitting the processed document control instructions to a document production facility.
18. A computer system as defined in claim 16, wherein the processor is to implement the production process by instructing production systems to produce a document based on the processed document control instructions.
19. A computer system as defined in claim 16, wherein the document control instructions include an email with embedded instructions and attachments.
20. The computer system as defined in claim 16, wherein the metadata file includes at least one of:
- a schema designation;
- client information;
- application information, wherein the application information identifies a source application of the metadata file;
- salesperson information;
- work-order information, wherein the work-order information includes territory information and file format information;
- task list information; or
- delivery information, wherein the delivery information includes one or more of a request date, a filing date, a delivery date or a delivery time.
21. A computer system as defined in claim 16, wherein the document control instructions include tagging instructions and at least one of:
- typesetting instructions;
- printing instructions;
- shipping instructions; or
- billing instructions.
Type: Application
Filed: Jun 16, 2015
Publication Date: Oct 1, 2015
Inventors: Constantino L. Riviello (New Rochelle, NY), Yuriy Bildeyenko (Bellmore, NY)
Application Number: 14/741,117