A Comprehensive PET-CT Database for Tracking Patient Variables

A Comprehensive PET-CT Database for Tracking Patient Variables Free Online Research Papers Abstract: A relational database was developed tracking demographic and examination information for patients undergoing PET/CT studies. Methods: A worksheet was first developed to capture patient and study information which was then entered into a relational database. Reports were designed to provide administrative and clinical information. Results: Approximately 2000 patients and three years of data have been recorded in the database. Reports have been used for administrative and research purposes. Conclusion: The database provided reports used to justify staffing, expenditures, and growth. It has also provided research data as well as clinical feedback used to improve the care and management of our patients. Introduction: In July 2003, the Medical College of Georgia installed a PET/CT scanner in its Radiation Therapy Outpatient Center. The scanner is used to perform a variety of diagnostic and oncology-related procedures. In order to be able to retroactively derive research data, a means of tracking patients as well as their individual studies was needed. Although a previously existing diagnostic PET scanner was in use, only radiopharmaceutical records were kept. In the radiation therapy PET/CT environment we felt it important to record additional information obtained from the in-depth patient history and physical. Materials and Methods: A worksheet was developed which allows the technologist to record a current medical history. It was designed by the nuclear medicine physician, the on-site radio pharmacist, and the lead PET technologist. Worksheet entries directly correspond to the database fields to simplify data input for the technologist. If funding becomes available for a computer in the incubation area, the technologist will be able to enter the history directly into the database. Worksheets are filled out by the nuclear medicine technical staff but in order to reduce errors, only the certified PET technologists perform data entry. Data has been collected since the inception of the PET/CT unit in August, 2003. The database currently holds approximately 2000 patients each of whom has had from 1 to 6 PET/CT examinations. Because of the complexity of the information to be recorded, it was determined that a relational database rather than a spreadsheet would be the most effective tool. A relational database promotes accuracy and flexibility and also simplifies data input. Rather than the free text fields used in spreadsheets, extensive use was made of drop boxes and radio buttons as shown in figure 1 which provide selection from fixed, pre-established choices. Because a patient can and often does have multiple examinations, one table was established for the patient and a related table for procedures. There is also a table of examination types. Using the relational capability of the database, every procedure is linked to a specific patient and exam type, both of which are selected from drop boxes. Tables were also developed for referring physicians and exam indications. Because information is linked rather than entered as free text, accuracy is improved and consistency is ensured. Current departmental research interests focus on several patient populations including pediatric lymphoma, cervical and gynecological cancer, and patients requiring treatment planning. Specific database fields were selected to allow future correlations of disease and risk factors. In addition, fields were provided related to patient demographics in order to provide regional coverage documentation for the Certificate of Need. As shown in figure 2, pre administrative reports include monthly procedure counts (figure 3), Veteran’s Administration patient volume, patient demographics for the Certificate of Need, and patient referral volume by physician (figure 4). For research purposes, study data in reports can be filtered by examination indications, type of exam, or patient sex, race, age, or risk factors. Results: The database is useful in providing financial reports. These reports are used to correlate contract billing and to monitor coding accuracy. Reports are also useful in looking at volumes in order to monitor productivity and develop future budgets. Database reports organize research data on patients and their studies including demographics, history, and risk factors. The tools associated with a relational database provide statistics useful in the publication of case studies, preparation of lectures, and tracking of research data. Discussion: The database was designed and structured to provide flexibility in the use and presentation of information. One of the advantages of a properly designed database is that the presentation of information can be readily customized. Those entering information into the database as well as the individuals who will be using the results and reports should be involved in the design process. After obtaining all potentially useful information in the proper format, reports can be customized to fit the needs of administrators and researchers. The approach used in the development and use of this database is adaptable to other types of institutions. The focus should be predicting the information required by the specific users as well as simplifying data entry. Well-designed database structure and screens can save time and reduce or eliminate many input errors, thus enhancing productivity and accuracy. Once accurate information is collected in a well-designed format, it is relatively simple for someone proficient with databases to produce customized reports. This is especially important because users often have changing needs and interests over time. Below are examples of reports which administrators and clinicians at our institution have found useful: Veteran Patient Volume The reimbursement department uses this data to track billing cycles. Physician Referral Base This information is useful in focusing marketing efforts by identifying areas for development. Pediatric Lymphomas Following pediatric patients over a period of years will help determine improved clinical pathways for disease management. Gynecological Cancers The gynecological clinic is one of our largest referral bases. This information will be used to differentiate needs for customized scanning such as â€Å"dual point† scanning post surgery. Patient Logs and Volumes Reports provide monthly and yearly patient volume data in both textual and graphical format. Accurate volume information allows us to project staffing needs and schedule system maintenance. The printout also provides a hardcopy back-up of invaluable data. Radiation Treatment Planning By tracking the protocol used for each patient, outcomes are improved by retrospectively analyzing clinical patient management. Conclusion: This database has provided hospital administration with accurate and timely reports to justify staffing, expenditures, and growth. It has provided our physicians with a plethora of research data and has provided our technologists with a method of correlative thinking in the care and management of our patients. As volume increases, the need for accurate, easily accessible information becomes more important. The database is being continually modified and new reports are being developed to enhance management and research functions. Use of a PET/CT tracking database should prove helpful to other facilities to exploit the potential of this technology. References: 1. Gardner WD. Breast Cancer Database Provides Faster Access To Patient Records. InformationWeek Web site. 2005. Available at: informationweek.com/story/showArticle.jhtml;jsessionid=NBXENMVY3EP5AQSNDBGCKHSCJUMEKJVN?articleID=174400322. Accessed April 28, 2007. 2. Johnson S, Paul T, Khenia A. Generic Database Design for Patient Management Information. American Medical Informatics Association Web site. Available at: amia.org/pubs/symposia/D004062.PDF. Accessed April 28, 2007. 3. Friedman C, Hripcsak G, Johnson SB, Cimino JJ, Clayton PD. A Generalized Relational Scheme for an Integrated Clinical Patient Database. Proceedings of the Fourteenth Annual Symposium on Computer Applications in Medical Care. Washington, D.C. 1990. 4. Essin DJ, Lincoln TL. Implementing a Low-cost Computer-based Patient Record: A controlled vocabulary reduces database design complexity. In: Gardner R, ed. Nineteenth Symposium on Computer Applications in Medical Care. Philadelphia: Hanley and Belfus, 1995:431-5. Research Papers on A Comprehensive PET-CT Database for Tracking Patient VariablesArguments for Physician-Assisted Suicide (PAS)The Project Managment Office SystemRiordan Manufacturing Production PlanResearch Process Part OneThe Fifth HorsemanInfluences of Socio-Economic Status of Married MalesIncorporating Risk and Uncertainty Factor in CapitalBionic Assembly System: A New Concept of SelfThree Concepts of PsychodynamicOpen Architechture a white paper

How Eliezer's relations with his father changes throughout the novel Essay

How Eliezer's relations with his father changes throughout the novel - Essay Example This lack of connection is evident when Wiesel dismissed his son’s idea to take his religion studies to greater or further exploration, claiming that he was too young. However, all these changes when the family forcefully taken to a concentration camp, Auschwitz, during the Nazi period. The hard and unpleasant they experience changes Eliezer’s attitude against his father. They begin to take care of each other and he begins to view his father as a role model, someone he truly admires and fears to lose. When the order is issued to separate women and children (to the left) from fathers (to the right), Elizer joins his father who would have stayed alone had Elizer not joined him, despite his young age (Smith 117). The father and son develop a strong bond following the horrors of war and conditions they are subjected to a t the concentration camps. The value their relationship and the once strained connections becomes that of understanding, love and care. As the situation gets worse, Elie feels strongly about not losing his father and upon the New Year, their relationship is completely transformed to that of closeness and protection (Bloom 106). They even figure ting out together and contemplate the future or no future together, as never before. He would not leave his father to die in the snow and kept on encouraging him that he will soon lie on the

Chinese banking system Essay Example | Topics and Well Written Essays - 500 words

Chinese banking system - Essay Example In the banking sector, Chinese financial system is by and large dominated by the large but underdeveloped banking system, which is mainly controlled by the four largest state-owned banks with a lot of non-performing loans. These state-owned banks will a lot of power by using the money injected into their business from the large foreign currency reserves to give out loans to selective borrowers, in particular, state-owned banks and to selective investment projects. But with the on going privatization in the banking sector, this will permit the entry into the sector of more domestic and foreign banks that will be of great importance since it will stimulate the banking sector and bring in more competitiveness and root out all the NPL.Chinese Financial markets have been characterized by speculation and insider information and have not been very successful in the effective allocation of resources as the banking sector. China has two main financial markets, the Shanghai Stock Exchange and Shenzhen Stock Exchange all established in 1990 and have been growing at a tremendous rate. But these markets have not been working at the rate which can bring in some improvements in the Chinese financial market sector. This is all due to encumbrances and poor regulation at the level of the regulatory environment particularly in the corporate and trading laws, legal protection of investors, and as well as institutions governing the enforcement of contracts that have all been poorly developed.