{"id":386,"date":"2019-01-17T08:43:37","date_gmt":"2019-01-17T08:43:37","guid":{"rendered":"http:\/\/206.71.52.87\/~newwebproject\/?page_id=386"},"modified":"2019-08-12T05:08:36","modified_gmt":"2019-08-12T05:08:36","slug":"database-design-development-and-user-acceptance-testing","status":"publish","type":"page","link":"https:\/\/cdsatoolkit.thsti.in\/?page_id=386","title":{"rendered":"Database Design, Development and User Acceptance Testing"},"content":{"rendered":"<div class=\"flex_column av_one_half  flex_column_div first  \" style='padding:0px 15px 0px 2px ; border-radius:0px; '><section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock  '   itemprop=\"text\" ><div class=\"dfr1\"><strong>Clinical Trials Toolkit &#8211; India<\/strong><\/div>\n<\/div><\/section><\/div>\n<div class=\"flex_column av_one_half  flex_column_div   \" style='padding:0px -20px 10px 0px ; border-radius:0px; '><section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock  '   itemprop=\"text\" ><div class=\"dfr\" style=\"text-align: right;\"><strong><strong>You are in: Home \/ Routemap \/ <\/strong>Database Design, Development and User Acceptance Testing<\/strong><\/div>\n<\/div><\/section><\/div>\n<\/div><\/div><\/div><!-- close content main div --><\/div><\/div><div id='sdew' class='avia-section main_color avia-section-default avia-no-shadow avia-bg-style-scroll   container_wrap sidebar_right'   ><div class='container' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-386'><div class='entry-content-wrapper clearfix'>\n<div class=\"flex_column av_one_fifth  flex_column_div first  \" style='padding:0px 0px 0px 12px ; border-radius:0px; '><div class='avia-button-wrap avia-button-left '><a href='https:\/\/cdsatoolkit.thsti.in\/?page_id=384' class='avia-button   avia-icon_select-yes-left-icon avia-color-custom avia-size-small avia-position-left '  style='background-color:#1d66a3; border-color:#1d66a3; color:#ffffff; ' ><span class='avia_button_icon avia_button_icon_left ' aria-hidden='true' data-av_icon='\ue888' data-av_iconfont='entypo-fontello'><\/span><span class='avia_iconbox_title' >Previous<\/span><\/a><\/div><\/div><div class=\"flex_column av_three_fifth  flex_column_div   \" style='padding:0px 0px 0px 0px ; border-radius:0px; '><div style='padding-bottom:10px;' class='av-special-heading av-special-heading-h2  blockquote modern-quote modern-centered   '><h2 class='av-special-heading-tag '  itemprop=\"headline\"  >Database Design, Development and User Acceptance Testing<\/h2><div class='special-heading-border'><div class='special-heading-inner-border' ><\/div><\/div><\/div><\/div><div class=\"flex_column av_one_fifth  flex_column_div   \" style='padding:15px 0px 0px -15px ; border-radius:0px; '><div class='avia-button-wrap avia-button-right '><a href='https:\/\/cdsatoolkit.thsti.in\/?page_id=355' class='avia-button   avia-icon_select-yes-right-icon avia-color-custom avia-size-small avia-position-right '  style='background-color:#1d66a3; border-color:#1d66a3; color:#ffffff; ' ><span class='avia_iconbox_title' >Next<\/span><span class='avia_button_icon avia_button_icon_right' aria-hidden='true' data-av_icon='\ue889' data-av_iconfont='entypo-fontello'><\/span><\/a><\/div><\/div>\n<\/div><\/div><\/div><!-- close content main div --><\/div><\/div><div id='after_section_1' class='main_color av_default_container_wrap container_wrap sidebar_right'   ><div class='container' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-386'><div class='entry-content-wrapper clearfix'>\n<\/div><\/div><\/div><!-- close content main div --><\/div><\/div><div id='lop1' class='avia-section main_color avia-section-default avia-no-shadow avia-bg-style-scroll   container_wrap sidebar_right'   ><div class='container' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-386'><div class='entry-content-wrapper clearfix'>\n<section class=\"avia_codeblock_section  avia_code_block_0\"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_codeblock '  itemprop=\"text\" > [avia_codeblock_placeholder uid=\"0\"] <\/div><\/section>\n<\/div><\/div><\/div><!-- close content main div --><\/div><\/div><div id='after_section_2' class='main_color av_default_container_wrap container_wrap sidebar_right'   ><div class='container' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-386'><div class='entry-content-wrapper clearfix'>\n<\/div><\/div><\/div><!-- close content main div --><\/div><\/div><div id='nbvc' class='avia-section main_color avia-section-large avia-no-shadow avia-bg-style-scroll   container_wrap sidebar_right'   ><div class='container' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-386'><div class='entry-content-wrapper clearfix'>\n<div class=\"flex_column av_two_third  flex_column_div first  \" style='padding:8px 0px 0px 14px ; border-radius:0px; '><section class=\"av_textblock_section \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock  '   itemprop=\"text\" ><p style=\"text-align: justify;\">Clinical Data Management plays a vital role in clinical research. It is involved in all aspects of processing clinical data and ensures that data gathered is accurate, complete, logical and consistent. In doing to the data is fit for statistical analysis, presentation and interpretation.<\/p>\n<p style=\"text-align: justify;\">Clinical trial data gathered at the investigator site in the case report forms are stored in the Clinical Data Management System (CDMS). CDMS is a tool(s) intended to ensure that data gathered in the course of study is accurate, complete, logical and consistent. CDMS must be comply with the regulatory requirements (21CFR Part11). Commonly used CDMS are: Oracle clinical, Rave, Clinitrail, Promasys, Macro and eClinical Suite etc.<\/p>\n<p style=\"text-align: justify;\">A database is simply a structured set of data and in its simplest form can be defined as a collection of rows and columns. Database design should allow for capture of all data on the CRF. eCRF should be an exact copy of the CRF design which allows entry of all data captured on the CRF. Once the funding for a trial has been secured, it is essential that the design of the database is initiated. If the research team is independent from the database design team, then, a user specification or requirements document is prepared by the research team that clearly explains the requirements of the database for a trial.<\/p>\n<h4><strong>Roles and Responsibilities <\/strong><\/h4>\n<ul style=\"margin-top: 0.5em !important;\">\n<li style=\"text-align: justify;\">Trial Management Team: generation of user requirements\/specifications document; user testing.<\/li>\n<li style=\"text-align: justify;\">Database Programmer: Development of the database, creation and implementation of edit checks, validation rules and logic checks.<\/li>\n<li>Data Manager: Creation of annotated CRF, DVP and DMP.<\/li>\n<li>Database Administrator: Creation of user access control.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">The database should be designed in order to prevent errors in data management, archival, retrieval or transmission. Thorough documentation must exist at all levels of a clinical trial\u2019s data collection and management process.<\/p>\n<p style=\"text-align: justify;\">Computer systems used in the processing and management of clinical trial data must be sufficiently validated and tested prior to the development of the database. Validation of the database is essential, as it plays a key role in providing a high quality database that complies with all applicable regulations. It also helps demonstrate the quality of the data generated during the trial. Validation refers to both, validation of the Clinical Data Management System (CDMS) and\/or validation of the programming related to the development of the database. CDMS validation involves Installation Qualification (IQ), Operational Qualification (OQ) and Performance Qualification (PQ). IQ and OQ are generally performed by the vendor which involves installation of the database and configuration of the server, and ensuring that the all system requirements are installed in the CDMS. Post-installation, the vendor conducts performance testing (OQ). The Data Management team then populates the database with dummy or test data on the system, to test the features on CDMS (PQ). In addition to any documentation provided by the vendor, trial-specific database manuals are developed with the help of screenshots (capturing all the steps) taken during the process of IQ, OQ and PQ.<\/p>\n<p style=\"text-align: justify;\">Validation is required to confirm that the software has been developed in line with the requirements stated by the user, and is fit for purpose. User Acceptance testing (UAT), is an element of validation and is performed once the database has been developed. This is performed before the CDMS is used to capture\/process any live data. It is performed by a user of the database or CDMS (data entry operators, data managers, medical department, statistician and principal investigator), and should follow a predefined protocol detailing each step and expected result with clearly defined pass and fail values. The UAT report provides objective evidence for the validation process. Once UAT has been successfully completed and documented and any remedial actions implemented and retested, the test database is moved into production mode to capture live trial data.<\/p>\n<h4><strong>References and Further Reading<\/strong><\/h4>\n<ul style=\"margin-top: 0.5em !important;\">\n<li style=\"text-align: justify;\">Good Clinical Data Management Practices, Society for Clinical Data Management, October 2013 edition, available <a href=\"https:\/\/www.scdm.org\/publications\/gcdmp\/\" target=\"_blank\" rel=\"noopener noreferrer\">online<\/a> (last accessed on 26.02.2019).<\/li>\n<li style=\"text-align: justify;\">Good Clinical Practices for Clinical Research in India, Central Drugs Standard Control Organization, Ministry of Health and Family Welfare, 2001, available <a href=\"http:\/\/www.cdsco.nic.in\/html\/GCP1.html\" target=\"_blank\" rel=\"noopener noreferrer\">online<\/a> (last accessed on 26.02.2019).<\/li>\n<li style=\"text-align: justify;\">ICH Harmonised Guideline, Integrated Addendum to ICH E6(R1): Guideline for Good Clinical Practice E6(R2), current step 4 version, dated 9<sup>th <\/sup>November 2016, available <a href=\"https:\/\/www.ich.org\/fileadmin\/Public_Web_Site\/ICH_Products\/Guidelines\/Efficacy\/E6\/E6_R2__Step_4_2016_1109.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">online<\/a> (last accessed on 26.02.2019).<\/li>\n<li style=\"text-align: justify;\">MRC Clinical Trials Unit at University College London SOP on Database Development, version 4.0, 2017.<\/li>\n<\/ul>\n<\/div><\/section><\/div><div class=\"flex_column av_one_third  flex_column_div   \" style='padding:2px 2px 0px 0px ; border-radius:0px; '><div class='avia-builder-widget-area clearfix '><div id=\"custom_html-3\" class=\"widget_text widget clearfix widget_custom_html\"><h3 class=\"widgettitle\">Key Components<\/h3><div class=\"textwidget custom-html-widget\"><div class=\"hjubv\">\r\n\t\r\n\r\n<ol style=\"margin-left: 15px !important;\">\r\n\t<li><a href=\"\/?page_id=1075\" style=\"color: #000;\">Trial Planning<\/a><\/li>\r\n\t<li><a href=\"\/?page_id=319\" style=\"color: #000;\">Trial Design<\/a><\/li>\r\n\t<li style=\"color:red !important\"><a href=\"\/?page_id=309\" style=\"color: red;\">Sponsorship<\/a><\/li>\r\n\t<li style=\"color:red !important\"><a href=\"\/?page_id=333\" style=\"color: red;\">Funding<\/a><\/li>\r\n\t<li><a href=\"\/?page_id=339\" style=\"color: #000;\">Internationally Funded Trials<\/a><\/li>\r\n\t<li><a href=\"\/?page_id=862\" style=\"color: #000;\">Trial Set-Up<\/a><\/li>\r\n\t<li style=\"color:red !important\"><a href=\"\/?page_id=343\" style=\"color: red;\">Protocol Development<\/a><\/li>\r\n\t<li style=\"color:red !important\"><a href=\"\/?page_id=345\" style=\"color: red;\">Essential Documents<\/a><\/li>\r\n<\/ol>\t\r\n<p class=\"kaw\">\r\n<ul style=\"margin-top: -23px;\">\r\n\t<li style=\"color:red !important\"><a href=\"\/?page_id=873\" style=\"color: red;\">Case Record Form<\/a><\/li>\r\n\t<li style=\"color:red !important\"><a href=\"\/?page_id=877\" style=\"color: red;\">Informed Consent Documents<\/a><\/li>\r\n\t<li style=\"color:red !important\"><a href=\"\/?page_id=880\" style=\"color: red;\">Investigator\u2019s Brochure<\/a><\/li>\r\n\t<li style=\"color:#7a7a7a !important\"><a href=\"\/?page_id=885\" style=\"color: #000;\">Trial Master File<\/a><\/li>\r\n\t<li style=\"color:#7a7a7a !important\"><a href=\"\/?page_id=363\" style=\"color: #000;\">Laboratory Related Documents<\/a><\/li>\r\n<\/ul>\r\n<\/p>\r\n<ol start=\"9\" style=\"margin-left: 15px !important;\">\r\n\t<li><a href=\"\/?page_id=419\" style=\"color: #000;\">Risk Management<\/a><\/li>\r\n\t<li><a href=\"\/?page_id=372\" style=\"color: #000;\">Quality and Process Management<\/a><\/li>\r\n<\/ol>\t\r\n<p class=\"kaw\">\r\n<ul style=\"margin-top: -23px;\">\r\n\t<li style=\"color:#7a7a7a !important\"><a href=\"\/?page_id=374\" style=\"color: #000;\">Sponsor Specific Processes and Documents<\/a><\/li>\r\n\t<li style=\"color:#7a7a7a !important\"><a href=\"\/?page_id=376\" style=\"color: #000;\">Pharmacovigilance Plan<\/a><\/li>\r\n\t<li style=\"color:#7a7a7a !important\"><a href=\"\/?page_id=378\" style=\"color: #000;\">Monitoring Plan<\/a><\/li>\r\n\t<li style=\"color:#7a7a7a !important\"><a href=\"\/?page_id=962\" style=\"color: #000;\">Safety Management Plan<\/a><\/li>\r\n\t<li style=\"color:#7a7a7a !important\"><a href=\"\/?page_id=384\" style=\"color: #000;\">Randomisation System Development and User Acceptance Testing<\/a><\/li>\r\n\t<li style=\"color:#7a7a7a !important\"><a href=\"\/?page_id=386\" style=\"color: #000;\">Database Design, Development and User Acceptance Testing<\/a> <\/li>\r\n\t<li style=\"color:#7a7a7a !important\"><a href=\"\/?page_id=355\" style=\"color: #000;\">Statistical Analysis Plan<\/a><\/li>\r\n\t<li style=\"color:#7a7a7a !important\"><a href=\"\/?page_id=380\" style=\"color: #000;\">Data Management Plan<\/a> <\/li>\r\n<\/ul>\r\n<\/p>\r\n<ol start=\"11\" style=\"margin-left: 15px !important;\">\r\n\t<li><a href=\"\/?page_id=399\" style=\"color: #000;\">Site Feasibility and Selection<\/a><\/li>\r\n<\/ol>\t\r\n<p class=\"kaw\">\r\n<ul style=\"margin-top: -23px;\">\r\n\t<li style=\"color:#7a7a7a !important\"><a href=\"\/?page_id=401\" style=\"color: #000;\">Site Identification and Evaluation<\/a><\/li>\r\n\t<li style=\"color:#7a7a7a !important\"><a href=\"\/?page_id=382\" style=\"color: #000;\">Site-specific Processes and Documents<\/a><\/li>\r\n\t<li style=\"color:red !important\"><a href=\"\/?page_id=906\" style=\"color: red;\">Clinical Trial Agreement and Investigator\u2019s Undertaking<\/a><\/li>\r\n\t<li style=\"color:#7a7a7a !important\"><a href=\"\/?page_id=409\" style=\"color: #000;\">Site Staff Training<\/a><\/li>\r\n<\/ul>\r\n<\/p>\r\n<ol start=\"12\" style=\"margin-left: 15px !important;\">\r\n\t<li><a href=\"\/?page_id=812\" style=\"color: #000;\">Trial Drug Supplies<\/a><\/li>\r\n\t<li><a href=\"\/?page_id=815\" style=\"color: #000;\">Approvals and Registration<\/a><\/li>\r\n\t<li style=\"color:red !important\"><a href=\"\/?page_id=421\" style=\"color: red;\">Regulatory Approval<\/a><\/li>\r\n    <li style=\"color:red !important\"><a href=\"\/?page_id=425\" style=\"color: red;\">Ethics Approval<\/a><\/li>\r\n\t<li style=\"color:red !important\"><a href=\"\/?page_id=852\" style=\"color: red;\">Clinical Trial Registration<\/a><\/li>\r\n\t<li><a href=\"\/?page_id=423\" style=\"color: #000;\">Other Approvals<\/a><\/li>\r\n\t<li style=\"color:red !important\"><a href=\"\/?page_id=433\" style=\"color: red;\">Final Protocol<\/a><\/li>\r\n\t<li><a href=\"\/?page_id=836\" style=\"color: #000;\">Management and Oversight Groups<\/a><\/li>\r\n\t<li><a href=\"\/?page_id=439\" style=\"color: #000;\">Trial Begins<\/a><\/li>\r\n\t<li><a href=\"\/?page_id=453\" style=\"color: #000;\">Trial Conduct<\/a><\/li>\r\n\t<li><a href=\"\/?page_id=498\" style=\"color: #000;\">Trial Close-Out<\/a><\/li>\r\n\t<li><a href=\"\/?page_id=518\" style=\"color: #000;\">Statistical Analysis and Reports<\/a><\/li>\r\n\t<li><a href=\"\/?page_id=510\" style=\"color: #000;\">Communication and Dissemination of Results<\/a><\/li>\r\n\t<li style=\"color:red !important\"><a href=\"\/?page_id=522\" style=\"color: red;\">Archiving<\/a><\/li>\r\n<\/ol>\r\n\t<\/div><\/div><\/div><div id=\"search-4\" class=\"widget clearfix widget_search\"><h3 class=\"widgettitle\">Search<\/h3>\n\n<form action=\"https:\/\/cdsatoolkit.thsti.in\/\" id=\"searchform\" method=\"get\" class=\"\">\n\t<div>\n\t\t<input type=\"submit\" value=\"\ue803\" id=\"searchsubmit\" class=\"button avia-font-entypo-fontello\" \/>\n\t\t<input type=\"text\" id=\"s\" name=\"s\" value=\"\" placeholder='Search' \/>\n\t\t\t<\/div>\n<\/form><\/div><\/div><\/div><\/div><\/div><\/div><!-- close content main div --><\/div><\/div><div id='after_section_3' class='main_color av_default_container_wrap container_wrap sidebar_right'   ><div class='container' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-386'><div class='entry-content-wrapper clearfix'>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/cdsatoolkit.thsti.in\/index.php?rest_route=\/wp\/v2\/pages\/386"}],"collection":[{"href":"https:\/\/cdsatoolkit.thsti.in\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/cdsatoolkit.thsti.in\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/cdsatoolkit.thsti.in\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cdsatoolkit.thsti.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=386"}],"version-history":[{"count":21,"href":"https:\/\/cdsatoolkit.thsti.in\/index.php?rest_route=\/wp\/v2\/pages\/386\/revisions"}],"predecessor-version":[{"id":2995,"href":"https:\/\/cdsatoolkit.thsti.in\/index.php?rest_route=\/wp\/v2\/pages\/386\/revisions\/2995"}],"wp:attachment":[{"href":"https:\/\/cdsatoolkit.thsti.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}