Data Entry Guide
Caisis 3.0 User Manual
Purpose and Conventions
This user manual is intended to be a resource for all Caisis web application users . It describes Caisis components and provides detailed appendices with guidance on data entry and use of the application for specific specialties. Further information can be found at www.caisis.org. The manual uses hyperlinks to guide you to more detailed information on the subjects covered. All buttons, menu selections, and field names appear in bold. Processes that require multiple steps will have these steps separated by an -> pointing to the next step needed in the sequence (e.g. Start -> Programs -> Microsoft Word).
Caisis is an integrated information system for clinical research and patient care. It is an open source web-based database designed to efficiently manage large reusable datasets to support predictive modeling and translational research. The goal is to improve data quality and accuracy while reducing time and effort for clinicians and support staff. Caisis was primarily developed at Memorial Sloan-Kettering Cancer Center and is currently operating at over 25 institutions in North America, Europe, and Asia. The effort has fostered a vibrant user community who continue to collaborate to develop the system, to further their research, and to implement clinical and operational improvements. The project team responsible for the design and development of the current application is made up of people of various professional backgrounds including Clinical Research, Clinical Practice, Database Design, and Web Development. Many members of the Caisis Development Team have first hand experience dealing with the obstacles that hinder effective clinic flow and data collection. Caisis has always been a system designed for users by users.
Caisis is a web application built on a three-tier architecture utilizing proven enterprise level technologies. The first tier of the application is a DHTML web interface built and designed to be compatible with the latest browsers: Internet Explorer, Firefox, Safari, and other standards compliant browsers. (The Caisis team recommends the use of Microsoft’s Internet Explorer for ideal performance.) The second tier incorporates the power of the object oriented language C# through Microsoft’s .Net. All data is stored in the third tier using Microsoft’s SQL Server.
The application does not require any software licenses for the technologies in the system, including SQL Server, which has a free download, microsoft.com/express/sql/download This allows the user to run a SQL server database, but does not provide any administrative tools. The server running the application must have a Windows OS, preferably 2000 or 2003, and requires the latest .Net Framework, which is also a free download: msdn.microsoft.com/netframework/ For better performance, the recommended minimum requirements for servers hosting Caisis are a server with at least a Pentium II or III running at 500 MHz and 256 MB of RAM. Further Caisis installation documents can be found here.
Caisis can be accessed from any computer connected to the Internet. To get started, type the address for Caisis into the address bar of the browser. The web address for Caisis will depend on the local settings at your institution, but every address will load the login screen first.
|The login screen allows you to change your password or request a new password at any time. The login screen also allows you to select the Purpose of your session in the application. The Purpose selections are: Clinical, Research, and Operations. To log in to Caisis enter your username and password and click enter. NOTE: Your Caisis System Administrator will provide you with your username and password.|
Change Your Password
|To ensure the privacy of your password, please change it on your first login to Caisis. To change your password click the change your password button on the lower left of the login screen. The login screen will display fields for you to enter your username, current password, and your new password. After you have re-typed your new password, click the button labeled: update password and enter site to log in to Caisis with your new password.|
Forgot Your Password?
|If you forget your password click the button labeled: forgot your password? and Caisis will email you a new password. Note: your old password will be disabled.|
|Caisis is a robust database that can support the storage of patient data from multiple sources. Each source or Dataset can be segregated by an array of dimensions or variables including institution, disease, physician, and protocol. Datasets can also be created based on any combination of dimensions. User can be granted access to one or many Datasets and have diiferent privileges depending on which dataset they select.|
Using Caisis – the day-to-day guide to data entry
How to Find a Patient
Caisis offers a number of ways to find a patient or group of patients. To find a patient whose name you know, simply enter the first few letters of the last name or the MRN in the Find a Patient: box and press Enter. If a direct match is found, Caisis will directly display that patient’s summary. If more than one patient is found, as pictured below, Caisis will display a list for you to choose a patient.
The Caisis Components
Caisis is organized with a tab for each part: Home, Patient Lists, Patient Data, Forms, Reports, Query Tool and the Admin tool. The normal user will not have access to Admin tool for the System. The Caisis Home tab is shown below.
The Home Tab
|The Home tab is the first tab you will see after logging in to Caisis. It offers links to View a List of Patients, View or Enter Data for a Patient, Enter an Electronic Form, and to Administer the System. Note that the Admin Tool is only visible to people with the necessary privileges.|
|Beneath the house icon is a link to Common Tasks.|
Add a New Patient
|The Add a New Patient form allows for the addition of patients not in Caisis.|
Add / Edit a Physician
Add a New Physician
|A new physician’s Specialty, Level, Institutional Affiliation, and contact information is entered on this form.|
View or Edit data for an Existing Physician
|To edit a Physician, first select their name from a list of all the physicians in Caisis. After you select the Physician’s name, the physician’s information will be editable. Note that the Physician’s name is not editable.|
Add / Edit a Protocol
Add a New Protocol
|Protocol Information, such as Title, IRB #, PI, and Description are entered on this form.|
View or Edit an Existing Protocol
|To edit a Protocol, first select the Protocol from a list of all the protocols in Caisis. After you select the Protocol, the Protocol’s information will be editable. Note that the Protocol’s Title and IRB # are not editable.|
The Patient List Tab
Only one list can be active at any one time. When you log on to Caisis, the Patient List screen will not have a list displayed. It will have some basic instructions available and arrows to all of the available list menus. To access a list, place your mouse over the type of list you would like to display. The menu will “drop-down” with links to all of the possible lists in that menu. Simply click on the menu name and it will load in the screen.
Creating a Category List
The only type of list that can be created by a user is the Category List. The Category List is created based on data entered for each patient in the Categories Form of the Patient Summary section.
Caisis users cannot delete Clinic and Protocol lists. Any user can delete individual patients from Public Category lists. Only users who created a Private list can delete individual patients from that Private Category list.
Deleting a Category List
To delete a category list, you need to remove each patient from the list. This is done by first selecting a patient on the list and then deleting them from the Category form Patient Data -> Patients -> Categories.
The Patient Data Tab – Data Entry Overview
The Patient Data tab serves as an interface for data entry and display. Once a patient is selected, the Patient Data section will display. There are two main parts of this section: the Date, Variable, Value (DVV) list and the entry forms. The DVV list can be seen on the left side of the screen; it is a running list of all items in the database sorted in chronological order. On the right side are the data entry forms for all of the data that can be stored in Caisis including medications, surgeries, medical therapies, and more. As you click through the DVV list, the forms screen on the right will refresh to show you the details associated with that specific record.
Entering Data – the Data Entry Controls
All of the entry screens in the Patient Data section have a consistent set of data entry controls. These buttons are used to modify, delete, and add new records. A summary of each button can be found below.
A new record may be created by selecting the entry form from the menu bar (which opens the form with a blank record) or by clicking the new button if you are already in a form. The new button is located with all of the buttons at the bottom of every entry screen.
All records are disabled for editing until the edit button has been clicked. Locked records can be edited only after clicking the unlock button. The user who locked the record is the only one who can unlock it.
To save a record, click the save button.
Unsaved changes to a record may be canceled while the record is in edit mode by clicking the cancel button. The record will be refreshed to its prior state, which may be a blank entry screen.
To delete a record, click the delete button. A pop-up window will appear asking you to verify that you want to delete the record. If you want to delete the record, click the OK button, otherwise click cancel and the record will return to its original state.
The lock button allows users to save high-quality, complete data. Other users cannot edit a locked record and its details. This feature should only be used when the current user has entered complete, superior quality data. If you are the user who locked a record, only you will be able to unlock the record to make additions or corrections. Other users will not have that option, but they will have the option of contacting you via email or contacting an administrator. Administrators and data managers have permission to unlock records for people who no longer are available to unlock the record themselves, so a record will never be permanently locked.
Entering Data – the Audit Log
The Audit Log Fields
|Every time a record is entered or edited, information about the user making these changes is displayed at the bottom of the entry forms panel. The following items are shown: Entered By, Updated By, and Locked By, each with the time the action was completed. When a record is first entered into the database, the user’s name and the time that the record was entered is stored for tracking purposes within the database. If another user or the same user makes changes to the record, then that user’s name and entry time is added. The Entered By: information is always based on the original record, while the Updated By: information can change several times. Although the information is not displayed on the screen, these changes and the original records are all stored in audit logs. When a record is changed in a table, a copy of the prior record or table row is added to the corresponding audit log for that table. The audit logs are in place, so that no record or change is ever lost and to ensure that Caisis meets the requirements of Title 21 Code of Federal Regulations Part 11. For more information, visit the FDA’s Part 11 website: http://www.fda.gov/ora/compliance_ref/part11/|
Navigating the Patient Data Screen
The Patient Summary Screen
The first screen visible in the Forms section is the Summary screen. The Summary screen pulls select information from the database to provide a quick summary of the patient’s history and treatment course.
Across the top of this section are a series of drop down menus: Patients, Encounters, Procedures, Therapies, Diagnostics, and Outcomes. Each one of these menus has a series of links to data entry forms including the medication, surgery, and allergy forms. Clicking any of these links will refresh the right side of the Patient Data section to display a specific form for data entry. The DVV list will be filtered to display records of the same type previously entered for this patient. When a record is entered and saved, it will be visible in chronological order on the DVV list.
The Date Variable Value (DVV) lists described
The DVV list displays on the left side of the screen. It provides a chronological overview of the patient's history. There is an alphabetical pull down menu within the DVV list in the from which you may see a filtered selection of information on this patient. Selecting an item from this list will display its detail in a form on the right side of the screen. These forms are explained below.
This is a select view of the most relevant information for this patient in Caisis.
This is a list of all the information for this patient in Caisis.
This is a view of all the documented actions taken for managing the data of this patient. It shows the date of the action, a brief description of the action taken, and the status of the action (pending or complete).
This view lists each of the patient’s allergies and their corresponding response.
This view lists information on all the biopsies for this patient.
This view lists information on all brachytherapy procedures for this patient.
This view lists what categories a patient has been assigned to within the database.
This view lists the stage of a patient’s disease at different points in time.
This view lists the details about each of the patient’s comorbidities.
This view lists the details about the consents a patient has received, signed, or rescinded.
This view lists all cytologies on a patient, including bladder washings, voided urines, cerebro-spinal fluids, fine needle aspirates, etc.
This view lists a complete list of diagnostic studies done for the patient including the procedure date, type, and result.
This view lists the dietary intake for a patient at different points in time.
This view lists each clinical encounter for this patient. It includes physical exams, reviews of symptoms, and digital rectal exams.
This view lists each endoscopic procedure recorded for this patient. NOTE: TURPs are usually found under Prostate Biopsy rather than Endoscopy.
This view lists the patient’s family history of cancer; particularly what family member had what type of cancer.
This view lists the various identifiers used to track a patient within the database: the type of identifier used and the specific value. This list may include hospital numbers, study identifiers, or other identifiers and is not limited.
This view lists each of the patient’s lab tests including the date it was done, the units of measurement, and the result. Using the filter tool at the bottom of the screen you may select one or more types of lab tests and display only those tests, or remove the filter again and see all lab tests.
This view lists the dates, schedule, dosage, and other details about each medication the patient has taken.
This view lists each of the medical therapy treatments received by the patient including the start date, type of agent, and dosage.
This view lists all doctors involved in a patient’s case and the role of each physician.
This view lists each of the general surgical treatments done on the patient (other than major cancer surgeries).
This view lists basic information about the radical prostatectomy, such as the procedure date, surgeon, Gleason score, lymph node and margin status.
This view lists a complete list of Protocols that a patient has been registered to including a short title, the enrollment date and the most recent activity.
This view lists the quality of life interventions of the patient such as treatments for potency or continence.
This view lists each of the radiation therapy treatments performed on the patient including the Start Date, Radiation Type, and Dosage information.
This view lists a link to the social history page where you will find information on the patient's drinking, smoking and social history.
This view lists date and clinical status including progression of disease and disease states.
This view lists date and type of surgery for all the surgical procedures performed on the patient. This includes prostatectomies, cystectomies, orchiectomies, etc. and any procedures related to the surgeries (such as PLND with RP).
This view lists date, survey name, and overall score (if appropriate) of all surveys recorded for a patient, including surveys about continence and potency such as the IIEF and IPSS.
This view lists the date and type of adverse event or toxicities from a medication, surgery, or other therapy.
This view lists the date and type of all treatments including medical therapies (i.e. chemotherapy, androgen suppression), surgeries, radiation therapy, and brachytherapy.
This view lists any items that had been marked as pending and with dates in the past.
This view lists any items marked as pending.