Abstract:
A method for generating and using a portable patient file may include entering data relating to a patient into a computer and storing the patient data in a medical record for the patient in a database using metadata in an adaptive data environment. The computer is configured to instantiate a file configured for import or export of the patient data, and the file is capable of transferring the patient data from the database to another database with preservation of semantic meanings associated with the patient data.

Description:
[0001]    This application is a continuation of U.S. patent application Ser. No. 11/858,241, filed on Sep. 20, 2007. 
     
    
     BACKGROUND OF THE INVENTION 
       [0002]    1. Field of the Invention 
         [0003]    The present invention is directed to a system and method for electronic record-keeping, organizing, and managing. 
         [0004]    2. Description of the Related Art 
         [0005]    Standards for healthcare patient record structures are failing to deliver on the promise for which they were first introduced and delivered. Record structure standards were created to allow exchange of information, but did not address the real need of the actual care of patients or the proper storage of patient information over time. Messaging standards have allowed the transfer of non-machine readable information, and terminology and information model standards have allowed for semantic interoperability. 
         [0006]    Standards considered include: 
         [0007]    CCR: The Continuity of Care Record is a patient health summary standard. It is a way to create flexible documents that contain the most relevant and timely core health information about a patient, and to send these electronically from one caregiver to another. It contains various sections such as patient demographics, insurance information, diagnosis and problem list, medications, allergies and care plan. It is a “snapshot” of a patient&#39;s health data at a point in time, and as such, does not address important issues related to the longitudinal patient medical record. 
         [0008]    HL7 RIM: The Health Level 7 Reference Information Model. At the core of the HL7 version 3 standards development methodology is the Reference Information Model (RIM), which is a static object-oriented model in UML notation. The RIM serves as the source from which all specialized HL7 version 3 information models are derived and from which all HL7 data ultimately receives its meaning. This is to establish semantic interoperability across a vast and growing number of subject domains (e.g., laboratory, clinical health record data, problem- and goal-oriented care, public health, clinical research, etc.), which are loosely but critically related. The RIM was first conceived as a data model, where all data elements known from HL7 version 2 and some large electronic health record data models were put on a single information roadmap. This model has been under development since 1996, and has not yet received consensus from participating members—most HL7 data interchange uses version 2.3.1. The model is primarily geared toward support for administrative and financial patient data exchange and observation data exchange, but does not address longitudinal electronic patient medical record structures. 
         [0009]    HL7 CDA: The HL7 Clinical Document Architecture (CDA) is a document markup standard that specifies the structure and semantics of “clinical documents” for the purpose of exchange. Similarly to CCR, this represents a “snapshot” of a patient&#39;s health data at a certain point in time, and does not address an overall design of longitudinal electronic patient medical record structure. 
         [0010]    Care Record Summary (CRS): A special use case of the HL7 CDA used as a care record summary. 
         [0011]    What is needed is a record format that addresses the issues presented above. 
       BRIEF SUMMARY OF THE INVENTION 
       [0012]    A system and method for capturing the complete depth of information contained within data, in particular, how data elements exist and interact with each other over time. The system and method may be scalable, have congruency with published standards for medical data interoperability, answer day-to-day patient management workflow and be compliant with the Health Insurance Portability and Accountability Act (HIPAA). 
         [0013]    In one embodiment, the present invention may be a method for keeping, organizing and managing electronic records, comprising: generating a first instance of data objects having data elements during a first encounter, the data elements further comprising a first instance identifier and temporal identifiers; linking a data object in the first instance to a summarization reference with a pointer; creating an additional instance of data objects having data elements during a later encounter, the additional data elements further comprising an additional instance identifier and temporal identifiers; and providing continuity for the first instance data objects over time. Continuity may be accomplished by tracking a relationship between the first instance data object a data object of the additional instance, as well as repointing the pointer to point between the summarization reference and the additional instance data object. Moreover, the additional instance data object may be a revision of the first instance data object. In addition, tracking may be achieved by back-linking the revision to the first instance data object. The method may also include diagnosing a problem and formulating a plan based on information contained in the first instance of data objects; and treating or managing the problem and reviewing the plan based on information contained in the additional instance of data objects. Moreover, the method may comprise relating at least one first instance data object with at least one additional data object in said instance of data objects. 
         [0014]    In another embodiment, the method may comprise collecting visit level information for administrative use, the visit level information comprising at least one of the following: demographic information, subjective information, objective information, assessment information and plan information; collecting and maintaining a list of items relating to an individual; assuming management of follow up items; creating a revision history of the list of items over time; implementing a privacy protocol; providing a task-based workflow; supporting secure data exchange; and supporting resource-based tasking. In this embodiment, the implementation of the privacy protocol may be accomplished by: providing an audit of database activity; providing robust security; providing role-based record access; and encrypting sensitive data. 
         [0015]    In still another embodiment, the method present invention may be a method for longitudinal electronic record-keeping having the steps of: storing discrete data elements relating to an individual; creating a new record for a visit, wherein the new record is a wrapper for the discrete data elements captured during the visit; collecting a group of records for the individual, having additional discrete data elements and at least one identifier reference; determining a problem based on the additional discrete data elements in the group of records and the visit; ordering a plan motivated by the problem; repeating the creating, determining and ordering steps for a subsequent visit to document additional problems and plans; following up on the problems and plans during the subsequent visit; generating historical linkages of the problems and plans; and maintaining a current list of problems and plans that are relevant to the individual. During or following the subsequent visit, the discrete data elements captured during an earlier visit may be elevated to a problem or plan. The method may also include closing each record at the end of each visit and preventing entry of further discrete data elements to each record after the record is closed. In addition, a task may be created at the completion of each visit and the method may be based on a task-driven workflow that may require producing a task calendar of events, functional data review and task production. Moreover, a new or existing task list may be used to trigger a new task or a reminder. The method may also allow a user to transport data elements from one system to another generally without incurring data loss. 
         [0016]    In addition to the method, the present invention also comprises a system for carrying out the method. In one embodiment, the system may have a user interface module or layer; a business logic module or layer; at least one data access layer; a data storage system layer; data storage functions; and a communication layer to external systems. The system may also have a visualization layer supported by one or more of the other layers. These layers may be used to minimize the dependencies between data elements. Using the inventive system, data may be translated into tables, indexes, primary key constraints, foreign key constraints or triggers for storage. 
         [0017]    In another embodiment, the system may further have controlled vocabulary modules, such as codified, controlled medical vocabularies. These controlled vocabulary modules, along with other system elements may reduce or alleviate a need for data cleansing. 
     
    
     
       BRIEF DESCRIPTION OF THE SEVERAL VIEWS OF THE DRAWINGS 
         [0018]      FIG. 1  is a schematic of one embodiment of a longitudinal electronic medical record. 
           [0019]      FIG. 2  is a diagram of a problem management workflow taken over several visits. 
           [0020]      FIG. 3  is an example of a document view of the software layers of the inventive system and method. 
           [0021]      FIG. 4  is a functional face sheet exhibiting patient lists as described in  FIG. 1 . 
           [0022]      FIG. 5  is an example of an electronic medical record component view of the inventive system and method. 
           [0023]      FIG. 6  is a software engineering view of one embodiment of the architecture of the inventive electronic medical record system and method. 
           [0024]      FIG. 7  is a representation of a visual output of a longitudinal patient medical record, overlaid with components of an advanced data manager. 
           [0025]      FIG. 8  is a schematic of an example of the inventive system and method in action through a first visit. 
           [0026]      FIG. 9  is a schematic of an example of the inventive system and method in action through a second visit. 
           [0027]      FIG. 10  is a schematic of an example of the inventive system and method in action through a third visit. 
           [0028]      FIG. 11  is a functional entity relationship diagram of the longitudinal electronic medical record of  FIG. 1 . 
           [0029]      FIGS. 12-12A  are a side-by-side view of a relational database representation of the longitudinal electronic medical record of  FIG. 1 , from a database administrator standpoint. 
           [0030]      FIG. 13  is a schematic of the metadata behind the entities of  FIG. 11 , arranged using an advanced data manager. 
           [0031]      FIG. 14  is an example of the deployment of the metadata of  FIG. 13 . 
           [0032]    FIGS.  14 A- 14 EE are the deployment of  FIG. 14  shown in an enlarged form. 
       
    
    
     DETAILED DESCRIPTION OF THE INVENTION 
       [0033]    A system and method for longitudinal electronic record-keeping, organizing, and managing. Although the system and method have applicability to a broad range of disciplines in which data or conditions are recorded and evaluated over time, they will be described herein with specific suitability to the medical field. In this context, method and system are shown in the preferred embodiment of a longitudinal electronic medical record (LEMR). 
         [0034]    I. Requirements for a Longitudinal Electronic Medical Record 
         [0035]    The written medical history of a patient is a longitudinal record of what has happened to the patient since birth. It may chronicle diseases, major and minor illnesses, as well as growth milestones. By documenting everything that has happened to the patient prior to the current visit, it often give clues to current disease states and helps guide the clinician in either the diagnosis of new problems or the treatment and/or management of older ones. A LEMR aims to achieve that goal. It is a record of patient health information generated by one or more encounters in any care delivery setting, by one or more care providers. Included in this information may be patient demographics, chief complaints, physical exams, review of systems, progress notes, problems, medications, plans, vital signs, history information (including past medical, surgical, medication, test, social, travel, immunization, obstetric, growth chart and developmental history), laboratory data, SOAP notes, radiology reports, genetic information, scanned documents, referral documents, as well as other information commonly known in the art. 
         [0036]    The LEMR should automate and streamline the clinician&#39;s workflow. It may have the ability to generate a complete record of a clinical patient encounter, as well as to support other care-related activities directly or indirectly including evidence-based decision support, quality management, and outcomes reporting. 
         [0037]    An important concept behind the LEMR is to show data element continuity and the relationships between elements generated in multiple instances, in other words, show a patient data point over time, and also show this data point in relation to other data points. Furthermore, an element should be considered polymorphic. For example, while element X may first be identified as a chief complaint, element X may be later elevated to a patient problem and then later be considered past medical history. An element first identified as a plan may be updated or modified. An element initially declared as a medication may be retired, thus becoming medication history. Moreover, it may also eventually be identified as allergy. In this manner, the LEMR element is important in itself, but the lifecycle of the element is equally important. 
         [0038]    As a result, a LEMR becomes a web of relationships, with a prevalent axis of time. The LEMR may capture information patient visit by patient visit, note during which visit the information is captured, and relate all such information to previous and future patient visits. In one variation, a “visit” may be equivalent to a patient encounter, or a patient episode of care, etc. In addition to this relative capacity, the LEMR may also be able to summarize the patient&#39;s current health status in a single view such as a patient face sheet. 
         [0039]    Elements within a LEMR may be discrete and codified. For example, a SOAP note as a text memo may not be a principal constituent of an LEMR, but many elements participating in capturing patient SOAP note information may be LEMR primary elements. The SOAP or progress note built from these elements is simply a data collection byproduct. 
         [0040]    In one embodiment, a LEMR is supported by some form of office workflow. For example, without additional “cues,” a LEMR may not specify the next patient encounter. However, the LEMR design may include the ability to setup and collect information pointers directed at other activities within the LEMR. Such information pointers, also referred to as “tasks,” may either be created before completing the patient encounter or by examining the state of a LEMR using Arden-syntax rules. This information pointer list may become the basis for care providers to effectively and accurately provide care to a patient. 
         [0041]    Moreover, the LEMR is a data collection device that may provide the following functions: 
         [0042]    Collect visit level information for administrative use such as demographic information, as well as clinical data such as subjective, objective, assessment and plan information. 
         [0043]    Assume the management of follow up items. Any patient visit after the first patient visit should be geared toward following up on formulated or ordered plans from the previous visit. 
         [0044]    Collect and maintain a list of patient items such as: problem list, medication list, plan list, etc. 
         [0045]    Maintain item versioning: create over time a revision history of clinical items. 
         [0046]    Implement a privacy protocol, such as HIPAA, which may include: 
         [0047]    Providing an audit of all database activity, for insertions, updates and deletions. In other words, maintain “who did what and when.” 
         [0048]    Providing robust security. One layer (ADM, the bottom layer) may be central and may provide data and enforce security. All subsequent layers may be access layers, such as intelligent data access, business rule layer, presentation layer, interface layer(s), etc. In this configuration, the idea may be to divide and conquer, i.e. each layer may have specific responsibilities, not interfering with other layers, but combining to enhance security. 
         [0049]    Providing role-based record access. The lowest layer (ADM) may define storage, security and data access roles. Roles may be defined to group together privileges: for example, being an administrator, or being a form application user, or being a report writer for all associated rights. Users may then be created and associated with roles. Applications may react on user login to enable a feature subject to authorization in accordance with a user&#39;s role, or possibly deny access to resources. 
         [0050]    Forcing encryption on patient-sensitive data, both within the backend database and via any interface-type transmissions. 
         [0051]    Moreover, the LEMR may provide a task-based workflow. Tasks are patient care workflow checkpoints. Completing a task may trigger the creation of further tasks and tasks may also be created by evaluating the current state of the patient using Arden Syntax-like rules, for example. 
         [0052]    Support secure data exchange. 
         [0053]    Provide support for resource-based scheduling for appointments, tests, and other resource-based tasking. 
         [0054]    2. Blueprint for a Standard Model 
         [0055]    Turning to  FIG. 1 , a schematic of one embodiment of a LEMR is shown. LEMR of  FIG. 1  may be organized around the principles of patient, medical record, visit and follow-up, as described below: 
         [0056]    Patient 
         [0057]    The most basic unit of the LEMR may be the patient. A patient has discrete data elements such as: last name, first name, date of birth, social security number, language, maiden name, ethnicity, middle name, patient status, and suffix. These are elements that are unlikely to change over time, or which changes are not tracked, and which may be used for identification. In this embodiment, patient-specific elements that do change are tracked under the Visit section, as explained below. 
         [0058]    Medical Record 
         [0059]    A patient is likely to have one or more medical records, scattered throughout different inpatient and outpatient settings. The medical record element is the collection of records for the patient. Each medical record may have discrete elements such as a Medical Record Number (MRN) and a facility identifier reference. 
         [0060]    Visit 
         [0061]    The visit is the level that captures data from a patient clinical encounter. Each new clinical encounter warrants a new visit record. A visit captures information that is either new or changed at the time of the encounter. Each visit record has discrete data elements and may include: account number, admission/encounter date and type, gender, marital status, patient type, religion, visit type, and other elements that likely change over time. As such, they may be given a time stamp or other form of temporal identifier to describe when they are entered. In addition, the visit may also be a wrapper for many visit-oriented data elements, such as: administrative, subjective, objective, and assessment and plan data. 
         [0062]    Administrative data may be data elements associated with visit-related patient demographic information and visit-administration information. Among the information that may comprise administrative data are: 
         [0063]    Patient address list: a list of patient addresses at the time of the visit. An address may comprise street, city, state, zip code, telephone, email, and address type. 
         [0064]    Patient insurance information: the patient primary and secondary insurance details. This information plays an important role for data interchange when placing orders with laboratory systems. 
         [0065]    Print outs: these are the documents as text streams that have been created and printed during a patient encounter or other interactions with the patient. Printout storage may comprise the document itself and a document type. 
         [0066]    Subjective data may be data collected in generally non-codified form from the patient, as expressed by the patient. Among the information that may comprise subjective data are: 
         [0067]    Chief Complaint: a short textual description of the reason for the encounter. 
         [0068]    History of present illness: story-like record of the patient&#39;s history of this current complaint. 
         [0069]    Review of systems: a structured laundry list of pertinent positives and negatives (signs, symptoms and history items). 
         [0070]    Objective data may be data collected in codified form by examining the patient, or through other forms of data collection or chart review. Among the information that may comprise objective data are: 
         [0071]    Physical Exam: the description of the patient&#39;s physical appearance and response to various stimuli, which is part of the clinician&#39;s examination. 
         [0072]    Vital Signs: may include data elements such as Blood Pressure, Pulse, Respirations, Weight, Height, and Oxygen Saturation. 
         [0073]    Allergy History: may include both medication and non-medications that have caused adverse reactions to the patient and the form of the reaction. 
         [0074]    Family History: may include pertinent medical and genetic history of family members as well as the current state of their health. This can include lists by family member, by disease, or as graphs. 
         [0075]    OB/GYN History: may include obstetrical and gynecological history for women. 
         [0076]    Travel History: may include descriptions of places traveled to and other potential exposures that can predispose the patient to disease or other conditions. 
         [0077]    Social History: may include data about social exposures such as tobacco, alcohol and drug use, as well as other elements such as education, occupation and living arrangements. 
         [0078]    Immunization History: may include data about preventative immunizations. 
         [0079]    Assessment &amp; Plan data may be additional data captured within the visit level and may comprise problems &amp; assessment and plans related to those problems: 
         [0080]    Problems, problem determination, and problem assessment or management are additional aspects of the LEMR. In one embodiment, the system may manage problem lifecycle, which captures a timeline of problem management, including all problem revisions, and plan relationships, which capture the reasoning or rationale for ordering a plan. One or many problems may have motivated ordering a particular plan, while a single problem may motivate ordering several plans, thus establishing a many-to-many relationship between problems and plans. 
         [0081]    Problem elements may comprise: source and code (of the controlled medical vocabulary), title, description, comment, onset and end date, activity, status, and severity. 
         [0082]    There may be many different types of plans, including: orders (laboratory or procedure orders), referrals, medications, discharge instructions (for example patient education materials), and other courses of action known in the art. In addition, plans may have one or multiple relationships to problems. The link between the plan and the patient&#39;s problem or reason for the plan may be significant in performing decision support computations (e.g. medical necessity checking), and to point out health, workflow, and resource allocation issues that may occur at a later point in time. Plan elements comprise: source and code (of the controlled medical vocabulary), title, description, comment, onset and end date, and status. 
         [0083]    Medications plan elements may be substantially more complex and include: medication name, dosage, unit, route, form, intake and intake unit, frequency, quantity, refill information, whether a patient education pamphlet was given out, prescription details to the patient, and comments. 
         [0084]    In the case where plans are laboratory or procedure orders, the plan result child element may be the location for capturing the results of the lab or procedure, in detail. 
         [0085]    A plan or order may be documented either as a performable order (for example, ‘Venipuncture’, ‘Dye Injection’), or an order result (actual value for a laboratory result, a radiology finding, or a finding interpretation), or a document order (for example surgical history items), or a charge order (for example a billing code associated with a visit event). 
         [0086]    A plan may be supported by a task, or a set of tasks. More specifically, tasks may be dependent or independent of each other. Dependent tasks may be considered hierarchical: a task is satisfied (completed, or closed) when all child tasks are satisfied. 
         [0087]    Follow Up List 
         [0088]    The concept of follow up is important to a longitudinal electronic record. Elements of follow up may be found in Dr. Kim Charles Meyers&#39; concept of problem resolution workflow, which is embodied in copending U.S. patent application Ser. No. 11/436,010 “Problem Solving Process Based Computing,” filed on May 17, 2006, claiming the benefit of U.S. Provisional Application 60/681,937, filed May 17, 2005 and which contents are incorporated herein by reference. 
         [0089]    The intent of the patient medical record is to provide a framework for patient problem resolution, and a patient encounter should start with discussing items from the previous visits (problem status, plan orders &amp; results, medication prescriptions). As a corollary, the follow up list is the list of items that should be followed up on sometime in the future, and, like the visit, may include items such as problems and plans. 
         [0090]    Supporting Longitudinal care 
         [0091]    The LEMR model focuses on assessment and plan as central elements within the longitudinal care delivery process and provides tracking of these actions by problems. Assessment and plan may be attached to single or multiple problems. The model allows any item from the patient&#39;s data to be elevated to the problem list. This LEMR model also allows for software applications to harmonize the presentation layers around the problem and results that need to be monitored in longitudinal care delivery. 
         [0092]    3. Problem Management Workflow 
         [0093]    Turning to  FIG. 2 , a problem management workflow is shown. As can be seen in  FIG. 2 , the initial visit may comprise Subjective (History), Objective (Physical Exam) and Assessment and Plans sections. In a preferred embodiment, the next visit is started with a patient orientation which may includes items from all four categories, and an assessment of the success or failure of the plans from the prior visit. Further visits may repeat this process with the intended basic goal of addressing patient problems by managing, and eventually resolving the problems. 
         [0094]    Electronic Medical/Health Record vendors frequently either neglect to recognize or are incapable of handling the follow-up visit. The delivery of a comprehensive orientation model requires a commitment to retrieve and debrief prior visit plans. As a technical point, most standard relational database models are not well suited to deliver this simple problem solving theme. 
         [0095]    4. Patient Current Lists 
         [0096]    To this point, the LEMR has been presented as a patient-specific collection of medical record visits over time. However, it may also be quickly able to display the current state of the patient. For example, patient problems within visits may be collected and historical linkages of problem revisions over time may be maintained, but the list of patient problems that are current and relevant to the patient care status must also be maintained. This reasoning is applied to the following lists: 
         [0097]    Address List. 
         [0098]    Patient current addresses may be updated if necessary at the start of each patient encounter in order to keep a list of active patient addresses such as home, office, etc. 
         [0099]    Insurance Information List. 
         [0100]    Similarly to the patient address list, an LEMR should keep an up-to-date list of patient insurance(s). This list is important to the billing aspect of a patient medical record, and is also key to submitting laboratory orders using HL-7. 
         [0101]    Allergy List. 
         [0102]    The list of current patient allergies. 
         [0103]    History Lists: Family History List, OB/GYN List, Travel History List, Social History List, Immunization History List, Test History List. 
         [0104]    The list of patient historical items, by history sections. 
         [0105]    Problem List. 
         [0106]    The list of relevant patient problems. This list may be rather involved. For example some of the previously captured patient visit problems may be listed, and within the listed problems, problems may be listed by status (active, inactive, retired, and superseded, etc.). Moreover, one problem may have led to the creation of a later problem, or treatment for one problem may impact the status of another problem. 
         [0107]    Test History List. 
         [0108]    The list of plans ordered for the patient. This list may grow to be quite large over time, as it is the reference of plans—and results—over the entire history of the patient&#39;s care. Some tests may be deemed less important and archived or their display suppressed; others may be prioritized and displayed prominently. 
         [0109]    Medication List. 
         [0110]    Medications may be either acute or chronic. Some are recorded only once, while others are refilled many times. It is important to store the medication with a state as a function of status (active, stopped, continued, etc) and medication start/end date. 
         [0111]    5. Portable Patient File Concept 
         [0112]    In one embodiment, an important additional requirement of an LEMR model is the ability to transport patient data from one system to another, generally without incurring data loss. This concept may be supported by Portable Patient Files, as a mechanism to define the XML format as the pattern depicted in  FIG. 1 , which may then be used for file instantiation during patient database export or import. Format of the Portable Patient File may be expressed as an XML file, and the format of the XML file may be driven by the definition of the Meta Data in an adaptive data environment, as discussed in the Storage Mechanisms section below. The content of a Portable Patient File may comprise all information attached to a patient. 
         [0113]    6. Patient Oriented Tasking 
         [0114]      FIG. 1  may allude to patient workflow as it mainly represents a methodology for organizing patient information. A patient care treatment protocol may be represented as a patient data life cycle over time; triggering events for patient care independent of the inpatient or outpatient setting, which may be supported with a task-driven work flow. This task-driven workflow may be based first on producing a task calendar of patient care events, and second, on regularly proceeding to patient data functional review, supported by Arden syntax-like capability to produce care protocol driven tasks. From a care provider standpoint, good patient care often requires reminders, from an existing task list on all patients, or via computational means that may trigger a task or reminder given a particular set of circumstances. 
         [0115]    Patient Task 
         [0116]    One or more patient tasks may be created at the end of a patient encounter, for example: 
         [0117]    Next care encounter with patient; 
         [0118]    Plan order result review and phone call to patient; 
         [0119]    Next physical exam; 
         [0120]    Next laboratory test; etc. 
         [0121]    Computational Means for Task Creations 
         [0122]    A downside to creating tasks at the end of a patient encounter may be that conditions change. For example, a laboratory result may: trigger calling the patient sooner, ordering follow up laboratory orders, or simply reassessing the patient state given the new evidence. 
         [0123]    The logic for such computation may be rather straightforward: if [condition] then [task action[given no overlap]]. This is well achieved using an Arden Syntax—powered task engine. For example, one could conceive the following computations: 
         [0124]    Has the patient had a cholesterol check within the past year? 
         [0125]    If the patient has diabetes mellitus and either hypertension (or two blood pressures higher than 140/90), is the patient on an Angiotensin Converting Enzyme Inhibitor (ACE-I)? 
         [0126]    Patient Scheduling 
         [0127]    Patient scheduling comprises finding a time slot where the patient care encounter will occur with the care provider. In simplistic situations, for an outpatient family practice with matched sets of physicians, nurses and examinations rooms, a large sheet of paper may work. For more complex cases, with shared resources, ranging from shared examinations rooms to multi-facility, multi-model, multi-procedure office settings supporting complex scheduling, a professional patient scheduling system may be necessary. In other words, patient scheduling may be resource-based scheduling for appointments, tests, and other resource-based tasking. 
         [0128]    There are multiple ways in which patient scheduling may occur. Wave scheduling may be highly favorable to the care provider, but is rather disrespectful to patients. In wave scheduling, many patients are all told to come at a given time. Once there, they are seen on a “first-come, first-served” basis. Loading the patients at the front end of the day may optimize the efficiency of a staff by guaranteeing there is never a lull in patient flow. However, while this may be good for productivity, it is unpopular with patients, some of whom may have to wait several hours to be seen, despite having arrived on time for their appointments. 
         [0129]    Time-slot scheduling, as opposed to wave scheduling is actually a resource based scheduling algorithm. All resources—physicians, nurses, staff type, patient, examination room, equipment unit and type, modality, facility, etc—have constraints, availability, and dependencies, which ultimately drive patient scheduling. For example, nuclear imaging may require an injection, followed by a first image taken at a precise time, followed by a second image at a precise interval of time. Such multi-modal procedure may involve different equipment (maybe mobile), different staff or staff type, and room reservations. 
         [0130]    After computations, an agreed-upon scheduled time may morph into one or more patient tasks, assigned to one or several care providers. 
         [0131]    7. Document View Model: Example of Face Sheet View 
         [0132]    Patient medical record software is complex software. Creating and maintaining such software may be achieved using software layers in order to minimize dependencies. Following a Document View model, the patient face sheet is a visualization layer that taps into and is supported by services provided by one or more lower level layers. In other words, a common set of layers may support one or more view layers, for example for different care provider roles across the enterprise. 
         [0133]      FIG. 3  shows an example of document view software layering. User Interface and Business Logic layers may work in concert to consume services provided by the Patient Data Storage layer, Task layer and Coded Medical Vocabulary service layer. 
         [0134]    Turning to  FIG. 4 , a function face sheet exhibiting patient lists as described in  FIG. 1  is shown. This face sheet focuses on patient care issues and may present the following advantages: 
         [0135]    Patient problems, Allergies, and Medications are clearly displayed for a quick review. 
         [0136]    All patient history lists are one click away, by selecting the corresponding tab sheet within the history quadrant. 
         [0137]    Editing and reviewing demographics information is one step away. 
         [0138]    All quadrant items can be created and edited using ‘local’ New and Edit buttons. 
         [0139]    Any alert-triggering items will be highlighted (including at a minimum decision-support rules, and possibly including any other business rules). 
         [0140]    The face sheet may show a user what is current for a given patient. However, it may also be capable of showing a patient&#39;s historical information. Moreover, the face sheet may be used with a standard vocabulary, which may allow for easier interoperability among various providers, e.g. The software behind the face sheet may also recognize several common phrases (“chest pains”, e.g.) and know what code to give them or how to code them. 
         [0141]    8. Role of Controlled Medical Vocabularies 
         [0142]    Successful implementation of a comprehensive LEMR may lay in the implementation of a controlled medical vocabulary. It may be important to capture the meaning of the problem and its classification within medical concepts. It also may be important that this meaning is preserved and used to repeat a successful care plan. In other words, controlled medical vocabularies may be at the core of an appropriately designed and implemented patient medical record: all parts—problem, medication, plan, history item, even subjective findings—may be tagged with a source vocabulary, and a code internal to that source vocabulary. If this controlled medical vocabulary is an interface terminology mapped to reference and administrative terminologies, the benefits available afterward may include: 
         [0143]    Providing billing code(s) for the financial systems downstream. 
         [0144]    Populating decision support systems with patient information, such as medication indications, medication contraindications, allergy checking and drug-to-drug, drug-to-disease interactions. 
         [0145]    Performing real-time queries against trusted clinical reference materials, directly from patient health records. 
         [0146]    Manipulating and reviewing information for quality analysis, outcomes, research, and strategic planning, and 
         [0147]    Translating provider-entered problems into administrative codes, coder-specific language, and patient-friendly terms automatically. 
         [0148]    II. Longitudinal Electronic Medical Record Architecture 
         [0149]      FIG. 5  depicts a common electronic medical record architecture of the inventive method and system, supporting the basic precepts for a fully functional physician electronic medical record. From a high level standpoint, the architecture may comprise a ‘User Interface’, patient data storage services, business logic, possibly Controlled Medical Vocabulary services, and interfaces. 
         [0150]    The foundation of a sound electronic medical record application may reside around back end services; the type of subsystems that may not be easily visible to end users. End users are mostly exposed to the user interface—a thin or thick client, and back-end services, while generally omnipresent, may be presented only sporadically to the user.  FIG. 5  shows EMR Generic System components and their relationships in context of each others. 
         [0151]    As can be seen in  FIG. 5 , these components may comprise: 
         [0152]    User Interface Module/Layer. 
         [0153]    This module may represent how a role-based system allows users to interact with data, work flow and tasks, following defined business logic. In other words, this is the set of screens that is available to users to see and interact with. 
         [0154]    Business Logic Module/Layer. 
         [0155]    The business logic modules are the layers of software that isolate the user interface presentation logic from data access &amp; storage implementation instructions. This layer defines “how the application works.” This layer is where the true logic of the application is encapsulated. 
         [0156]    Data Access Layer. 
         [0157]    The data access layer is a mechanical layer. It may be best implemented when automatically derived from the patient data storage system. It usually reflects a “CRUD”—create, read, update, delete—approach at the very basic level, and may incorporate caching algorithms. 
         [0158]    Patient Data Storage System Module/Layer. 
         [0159]    This may be considered the central element of the EMR. The module may assume the functions of creation and maintenance of data access, security enforcement and audit of data interactions. 
         [0160]    The patient data storage system module/layer may be the lowest layer. It may be the layer that controls storage, security—for data access control—and data access roles. It may be a one-point of access, such that generally all subsequent layers may be required to authenticate against this layer to gain privilege(s) to resources. In this way, security may be maintained generally independently of system architecture. In addition, this module/layer may also be the layer where access audit is performed. These features and functions may be consistent with HIPAA, where the main goal may not be to prevent access, but rather to guarantee data access by role, after authentication, and keep an access audit log. 
         [0161]    Controlled Medical Vocabulary (CMV) Modules. 
         [0162]    Refer to the “Role of Controlled Medical Vocabularies” section, discussed above, for more information. 
         [0163]    Data Storage Functions. 
         [0164]    Refer to the “Storage Mechanisms” section, discussed below, for more information. 
         [0165]    Communication Layer to External Systems. 
         [0166]    LEMRs may be ineffective without interfaces to external systems. Such systems may include order messaging/results (laboratories, pharmacies, radiology, etc), patient admission/discharge/transfer (ADT), and patient financial applications as the most frequently interfaced applications. 
         [0167]    The inventive system and method may use these modules or layers and functions to translate data into tables, indexes, primary and foreign key constraints or triggers for storage of the data. 
         [0168]      FIG. 6  shows one embodiment of EMR System components, from a software engineering standpoint. This figure emphasizes the following additional system functions, although additional functions may be available: 
         [0169]    Interface modules, supported by iHL7 for HL7-driven transactions and by Interface Agent (IA), for web services—driven transactions. 
         [0170]    Business layer and data access layers. Such layers may be achieved using web services, COM+ objects, Java beans. The emphasis is on what will be most effective in the target environment. 
         [0171]    User interface. Presentation technologies may comprise thin or thick client architectures, even though AJAX toolset recent advances tend to blur the line between thick and thin presentation technologies. 
         [0172]    Dictation Module. The Dictation service is a service which transforms a sound wave file into text. Additionally, the text may be first tagged with Controlled Medical Vocabulary (CMV) terms, and secondly, CMV terms may be assigned to the appropriate section of the medical record encounter. 
         [0173]    1. Storage Mechanisms 
         [0174]    It is commonly estimated that over 80% of the software engineering time spent building an EMR is spent building a storage device, data access layer, and security layer. One example of a data management solution to this issue is Intelligent Medical Objects&#39; (IMO) Adaptive Data Manager™ (ADM) as represented in the commonly-owned, co-pending U.S. patent application Ser. No. 11/065,600, filed Feb. 24, 2005 and issued as a U.S. Pat. No. 7,693,917 on Apr. 6, 2010, which is a continuation-in-part of U.S. patent application Ser. No. 09/997,723, filed Nov. 30, 2001 and issued as U.S. Pat. No. 6,904,432 on Jun. 7, 2005, the contents of both which are incorporated herein by reference. It is both a back-end information storage infrastructure, and a flexible development environment aimed at managing complex data storage. ADM is aimed at managing complexity: the data model is expressed in terms that any data analyst can understand, while database complexities are handled reliably and consistently by ADM. ADM is: 
         [0175]    Based on a Meta data manager concept: the organization of the data itself (the Meta data) is described to ADM (prior to any collection of data). The Meta data Manager encloses definitions of Meta data elements as well as the relationships among these meta data elements. 
         [0176]    An open-architecture system: it is implemented using Oracle standard features, and security is handled using proxy users, roles and profiles. 
         [0177]    An implementation of HIPAA, without additional overhead. Security and role-driven functions are prevalent throughout ADM. User action Audit is pervasive and omnipresent. 
         [0178]    A notable point of this design is information storage location. Information may be semantically expressed as: 
         [0179]    Discrete elements, or values, such as the value for the patient last name. 
         [0180]    Containers as groups of values, which functionally belong to the same information concept, such as a patient having many values for patient last name, first name, date of birth, social security number, etc. 
         [0181]    Containers may be specialized as Container arrays: a patient may have one or several visits, whereas visit containers are array indexed. 
         [0182]    The relationships between containers and arrays. 
         [0183]    Containers and arrays revision information. 
         [0184]    Task information, exclusively supporting workflow, whereas containers and arrays do not store workflow state. 
         [0185]    Summarization of the record, which may be referred to as patients lists. These lists, such as patient problem list and patient medication list, gather items from disparate patient care events and are referred to as virtual arrays. In effect, by adding virtual lists, the information science model is elevated from a tree structure to a graph structure. 
         [0186]    Creating, modifying or deleting a container, container array item or discrete element will generate an audit trail with author, date and previous value. 
         [0187]    Practically, ADM was designed to handle complexity and ease of development from a developer standpoint. ADM resolved, and other data management solutions may resolve, the following issues: 
         [0188]    Directed Graph Database Storage. 
         [0189]    ADM is based on directed graphs, instantiated in a relational database. Accessing and modifying data in a directed graph is a NP-Complete problem. Therefore, when loading data from a directed graph, it may be necessary to ask how much data should be loaded, and when should the loading of data stop? This simple assertion has tremendous impact on performance. 
         [0190]    Concurrency Management. 
         [0191]    Compounding the issues presented with directed graph database storage, letting two or more users edit the same area of information may raise issues of data accuracy, data reload, and impact on performance. NP-Complete algorithmic issues related to database storage of data modeled as a directed graph may have the greatest impact on concurrency management, the most important question being “where should we stop reloading data that might have been changed?” 
         [0192]    2. Additional Design Considerations 
         [0193]    Containers and Container arrays encapsulate groups or discrete elements, child containers and container arrays. In effect, a tree of relationships with nodes as Containers and Container arrays, leaves as discrete elements, and edges as parent-child relationships between Containers, Container arrays and discrete elements is defined. Modifying any Containers, Container arrays and discrete elements may generate audit trails; therefore, it may be part of the design effort to intelligently organize Containers, Container arrays and discrete elements according to the functions of such elements. For example, we may assume that last name, first name, and SSN may be discrete elements belonging to the person container, while experience has shown that a person&#39;s gender is optimally designed as a child of the visit array container. 
         [0194]    3. Reporting and Data Extraction 
         [0195]    ADM assists with data harvesting: ADM allows creation of Meta views, as superset constructs that rely on the Meta data. For example, a simple electronic medical record for collecting immunization information for pediatric patients may be defined. This electronic medical record is in itself non-trivial, as notions of patient demographics, longitudinal data captured as patient visits, simple face sheet information such as current medications, current allergies, and past immunizations are represented there and defined in the database as different database objects. Following this example, a Meta view allows grouping in one database object—for reporting purposes—different elements, such as patient demographics, date of last admission, immunizations, staff, etc. 
         [0196]    In other words, the back end repository for a well-designed longitudinal patient medical record is a gold mine for outcome reporting, via data mart or data warehouse projects. To this end, an LEMR may reduce or alleviate the need for data cleansing, as most of the effort of normalization may be made when creating the record itself, and most data elements may be codified elements—as opposed to text elements. It is worth noting that an LEMR may also carry many text-based elements, but it is a good practice to limit the number of such elements, for greater data harvesting quality at a later date. 
         [0197]    4. Face Sheet Practical Implementation 
         [0198]    IMO implemented a longitudinal patient medical record, named iEMR, for Dr. Kim Charles Meyers, supporting precepts advocated by Dr. Meyers, and supported by ADM and VisualADM. All aspects of electronic medical record system and method may be supported by ADM. In particular, most behaviors are dictated by the structure of the Meta data. In addition, ADM is also the storage for the application itself. 
         [0199]      FIG. 7  shows all facets of the iEMR implementation, from a VisualADM standpoint. According to the display of  FIG. 7 : 
         [0200]    The face sheet is presented at the center of the figure. 
         [0201]    Meta Data, Instance Data, Form internal hierarchy is detailed on right and bottom side. 
         [0202]    The left hand side shows script execution, and script source code. 
         [0203]    VisualADM&#39;s FormRunner, because of its integration with ADM, may provide the following features related to healthcare: 
         [0204]    Mix of rich client and thin client technologies. 
         [0205]    A purely thin client interface may be slower, and more cumbersome, for real time patient interactions. VisualADM, as a rich client sharing thin client concepts, achieves speed of interactions. 
         [0206]    Orientation toward Healthcare. 
         [0207]    The system and method may be capable of providing: 
         [0208]    Support for role-driven workflow 
         [0209]    Support for knowledge object orientation. Support for knowledge expansion. 
         [0210]    Support for dictionary lists 
         [0211]    A reduced amount of source code necessary for building electronic medical record-type applications. 
         [0212]    Support for lexicon knowledge queries using IMO&#39;s LexiconHub. 
         [0213]    Support for task-based workflow. 
         [0214]    Rule scripting language geared toward health care. 
         [0215]    Support for macro operations. 
         [0216]    Support for document management functions 
         [0217]    Support for PDF forms, PDF merge, PDF display. 
         [0218]    Support for RTF reports. 
         [0219]    Support for email workflow. 
         [0220]    Support for HL7 communication services. 
       Example 1 
       [0221]    A Document View Model of a Longitudinal Electronic Medical System in action: 
         [0222]    This section presents an example of all parts of one embodiment of an LEMR working in concert. It will be appreciated that other alternative information may be captured, other process may be undertaken, and additional uses may all be possible. The premise is a new patient presenting with symptoms of asthma, receiving care through three successive care provider encounters. 
         [0223]    Visit  1   
         [0224]      FIG. 8  describes Patient John Doe, with demographic information date of birth [Jan. 1, 1960], SSN [xxx-xx-xxxx] created as a new record. A new medical record is created by default. As for any new patient encounter, a new visit record is created as well. 
         [0225]    The care provider—patient visit occurs. As part of the visit, the following information is captured: 
         [0226]    Address and insurance information, 
         [0227]    Chief Complaint, History of Present Illness and Review of Systems (subjective sections information content), 
         [0228]    Physical exam and vitals (objective sections information content), 
         [0229]    Problem is recorded as Asthma, with status “Under consideration”; Medication Plan includes “Combivent” (Assessment and Plan section information content). 
         [0230]    In addition, at the highest level, current list relationships may be captured and recorded data may be linked to summarization icons or summarization references. As with other data objects generated during the visit, pointers may be used to link the recorded data to the summarization references. These relationships may include: 
         [0231]    Current patient address list, 
         [0232]    Current patient insurance list, 
         [0233]    Current problem list: Asthma (version 1). Problem Asthma in this visit is also related to Medication Plan “Combivent” in this vist. 
         [0234]    Current Medication List: Combivent (version 1). 
         [0235]    Follow up items: Asthma (version 1), Combivent (version 1). These two items should be prominently displayed during the next visit to highlight patient follow-up. 
         [0236]    After completion of the patient care provider encounter, the visit is closed to seal the interaction in time. In one embodiment, that part of the tree may never be touched or edited again so as to prevent entry of additional discrete data elements. However, actually entering data may also be considered a technical, not logical, question, so the system or method may allow a user to go back and edit text, eg. 
         [0237]    As shown in  FIG. 8 , the connections generally have a single arrowhead at one end and a double arrowhead at the other. This represents a one-to-many combination. The solid lines indicate that this data may be represented in a tree structure. Moreover, the summarization icons of “Address List,” “Insurance Info,” “Problem List,” “Test History List,” “Medication List,” and “Follow up Items” may be linked to information captured during each visit, so that the information may have multiple parents. In this case, the LEMR takes on a graph structure and increases in complexity. 
         [0238]    A next encounter time may be established for the patient&#39;s next encounter, supported by a care provider-based task. Optionally, additional tasks may be created plan by plan, for laboratory tests for example. 
         [0239]    Visit  2   
         [0240]      FIG. 9  shows patient, John Doe, after his second visit. As a new patient encounter, a new visit record is created, having a new temporal identifier to signify when the visit occurred, as well as a new instance identifier, detailing that the visit is a new visit in the patient&#39;s history. The care provider addresses the follow up item list, including the plan or plans created in the previous visit, and creates data entry for the following: 
         [0241]    Problem Asthma. 
         [0242]    Information for this problem is modified, thus creating a new revision. A problem status change was performed: status was changed from “Under Consideration” to “Doing Better.” The process of creating a problem revision and providing continuity for a problem is a three-part process: 
         [0243]    1) Problem Asthma revision 2 is created. The problem may have a new temporal identifier to describe when the creation occurred. However, it may have the same instance identifier as Visit  2 . 
         [0244]    2) Problem Asthma revision 2 is back linked to Problem Asthma revision 1. 
         [0245]    3) The problem list link to Problem Asthma revision 1 is updated to be pointing to Problem Asthma revision 2. 
         [0246]    Medication Combivent. 
         [0247]    Information for this medication is modified, thus creating a new revision. A medication status change is performed: status is changed from no status to “Continue”. Similarly to the problem Asthma, the process of creating a medication revision and providing continuity for the medication is a three-part process: 
         [0248]    Medication Combivent revision 2 is created. 
         [0249]    1) Medication Combivent revision 2 is back linked to Medication Combivent revision 1. 
         [0250]    2) The Medication list link to Medication Combivent revision 1 is updated to be pointing to Medication Combivent revision 2. 
         [0251]    3) In addition, Problem Asthma version 2 is related to Medication Combivent version 2. 
         [0252]    Follow up items for visit # 1  are cleared, and new follow up items for visit # 2  are created. In this example, such items should be prominently displayed during the next visit to highlight patient follow-up. Again, the visit is closed to seal the interaction in time after completion of encounter. 
         [0253]    Again, a next encounter time may be established for the patient&#39;s next encounter, supported by a care provider-based task, and additional tasks may be created plan by plan. 
         [0254]    Visit  3   
         [0255]      FIG. 10  represents a third visit. As a new patient encounter, a new visit record is created, again having new temporal and instance identifiers. The care provider only addresses changes for the medication Combivent, for a refill for example, using the follow up link. The following actions occur: 
         [0256]    Medication Combivent. 
         [0257]    Information for this medication is modified, again creating a new revision. A medication status change is performed: status is changed from “Continued” to “Refill”. Similarly to visit  2 , revision actions occur by creating revision 3, linking revision 3 to revision 2, and re-linking medication list link from revision 2 to revision 3. 
         [0258]    Problem Asthma. 
         [0259]    Element Information for Problem Asthma is not modified, but linking information to Medication Combivent is changed thus motivating a new revision. Similar steps apply as described during visit  2  for Problem Asthma. 
         [0260]    In addition, Problem Asthma version 2 is related to Medication Combivent version 2. 
         [0261]    Follow up items for visit # 2  are updated to point toward items for visit # 3 . 
       Example 2 
       [0262]    Implementation of a Complex Problem 
         [0263]      FIG. 11  shows in detail the example of LEMR as provided in  FIG. 1 , this time expressed as an Entity Relationship Diagram. Note that  FIG. 11  does not show any discrete elements. 
         [0264]    In this example, most ADM administrative interactions may be handled using XML, mainly for safe keeping, transfer, and migration operations; Meta data is a prime example, and the code at the end of the specification shows a portion of the example depicted in  FIG. 11  as an XML document. 
         [0265]    Example of Longitudinal Medical Record Architecture 
         [0266]    An XML document may be used as a source for ADM behaviors, primarily for translation to RDBMS structures; the example described above may create and maintain without external help  110  tables, 58 triggers, 249 indexes and 757 primary, foreign, unique and check constraints. 
         [0267]      FIG. 12  shows the code at the end of the specification expressed as a relational database, from a database administrator standpoint. This visualization may be rather intimidating, and may only present a portion of the database schema. It may not be advisable to maintain an ADM-generated database using traditional database management tools, but rather to use ADM-supplied management tools. 
         [0268]      FIG. 13  shows the Meta data exposed in the above-mentioned code, as managed by ADM database management tools. 
         [0269]    Meta Data to Relational Database Deployment 
         [0270]    The Meta data layer may be translated into tables, indexes, primary key and foreign key constraints, and/or triggers, for storage of instance data. Deployment may follow these simple rules: 
         [0271]    A Meta data element either triggers creation of a table or addition to the payload of a table. 
         [0272]    Meta data datatypes may be divided into 3 types: 
         [0273]    1. Container and Array. 
         [0274]    These data types trigger a table creation. The name of the table may be the meta data short name with ‘$’ as a suffix. The resulting table may have: 
         [0275]    A primary key (the table name with a ‘_code’ suffix), 
         [0276]    Possibly a foreign key parent relationship to the parent meta data deployed table if the meta data has a parent meta data element, 
         [0277]    A default row text (the table name with a ‘_text’ suffix), 
         [0278]    A set of column defined as ‘payload’, defined from child meta data discrete elements, 
         [0279]    Tagging references, such as the row creation date (TAG_CREATEDATE), the row last update date (TAG_SYSTEMDATE), and the row user author reference (TAG_SYSTEMUSER). 
         [0280]    Furthermore, an array meta data element may add an order index reference as a tag reference (TAG_ORDER). 
         [0281]    2. Discrete data types, including string, number, boolean, real, text and date. Meta data elements of discrete data type participate in the parent meta data element table payload. String, number, real, boolean, date and text may respectively translate into varchar2(4000), number(10), number(10.5), number(1), date and CLOB (character large object) Oracle data types. The string data type may slightly differ: the user has the ability to set the data type length, from 1 to 4000. It is by default  4000 . 
         [0282]    3. Virtual Array. 
         [0283]    A virtual array may indicates arrays of relationships from one table to another table, as translated into relational database design terms. In other words, the result may be a straightforward relational table: a reference column to the parent meta data table (FROM_CODE), a reference column to the child meta data table (TO_CODE), and tagging references such as the row last update date (TAG_SYSTEMDATE), and the row user author reference (TAG_SYSTEMUSER). 
         [0284]      FIG. 14  illustrates these rules, using  FIG. 10  Meta data as a base example.  FIG. 14  shows a condensed view of FIGS.  14 A- 14 EE, illustrating the relationship among elements on each side and between elements on each side. Matching reference numerals in the various sheets of FIGS.  14 A- 14 EE designate identical arrows as they extend from sheet to sheet.  FIGS. 14A-EE  show: 
         [0285]    The Meta data graph, modeled on the left hand side. 
         [0000]    The arrows to the left of the data elements in the Meta data model indicate parent child relationships, thereby building a tree. The solid arrows extending to the right of the grayscale data elements like “Patient_Address (Virtual Array)” and “Patient_Allergy (Virtual Array),” indicate virtual array relationships, relationships that constitute the Meta data graph attribute. In  FIG. 14A , these are arrows numbered 16-28, for example. 
         [0286]    The relational database created from the Meta data on the right hand side. Each shaded box is a table. Solid arrows, like those numbered 74, 79-84, 86, 88 and 90 in  FIG. 14T , indicate a child-parent relationship (i.e., a foreign key to primary key relationship), and curved, dashed arrows, like those numbered 77-78, 85, 87, 89 and 91-93 in  FIG. 14T , indicate a double foreign key relationship in the case of virtual array tables instantiated as true relational tables. 
         [0287]    Straight-line, dashed arrows, from the left hand side to the right hand side, represent a Meta data element instantiated as a table. 
         [0288]    Note that FIG.  14 &#39;s instance data database objects, as shown with more clarity in FIGS.  141 - 14 EE, do not include text for the primary key and foreign key database constraints; all instantiated elements do actually translate into primary key and foreign key constraint relationships. 
         [0289]    Deployment similar to that of  FIG. 14  deployment also includes several events that are not shown in the figure and happen concurrently with creating the main instance data objects: 
         [0290]    Creations of the archive matching tables: all dynamically created tables may also have a matching ‘_arc’ table, similar in structure, with the purpose to archive past column values during update and delete operations. 
         [0291]    Creations of triggers allowing data movements from table to archive table. 
         [0292]    Expansion of Meta data flags into particular aspects of trigger generation, notably in the case of Meta data payload indexing. 
         [0293]    Role assignments. ADM security layer is driven by roles, and roles are automatically granted set of rights on all dynamically created objects. 
         [0294]    As discussed above, the following code shows a portion of the example depicted in  FIG. 11  as an XML document. 
         [0295]    While the foregoing written description of the invention enables one of ordinary skill to make and use what is considered presently to be the best mode thereof, those of ordinary skill will understand and appreciate the existence of variations, combinations, and equivalents of the specific exemplary embodiment and method herein. The invention should therefore not be limited by the above described embodiment and method, but by all embodiments and methods within the scope and spirit of the invention as claimed.