Clinical Database Design
| 036. Designs clinical database structures for data acquisition and data entry. |
| 037. Implements, per design, clinical database structures for data acquisition and data entry. |
| 038. Designs clinical database structures for data validation. |
| 039. Defines content, structure and procedures for using a library of database modules. |
| 040. Implements, per design, clinical database structures for data validation. |
| 041. Designs clinical database structures for data analysis and reporting. |
| 042. Implements, per design, clinical database structures for data analysis and reporting. |
| CRF Tracking and Inventory |
| 043. Applies protocol/CRF schedules to populate CRF tracking tools, if they exist. |
| 044. Creates tools to track and inventory CRFs. |
| 045. Defines user requirements for integrated electronic tools to perform CRF tracking tasks. |
| 046. Notifies data entry group of priorities. |
| 047. Determines and reports anticipated vs. actual CRF receipts. |
| 048. Routinely maintains tracking/inventory and identifies missing CRFs. |
| 049. Tracks down and retrieves missing CRFs. |
| 050. Identifies CRF flow issues and initiates steps to resolve. |
| 051. Resolves issues with data flow in collaboration with the project team. |
| 052. Develops and maintains process, SOPs and standards for CRF Tracking and Inventory control. |
| CRF Data Entry Process Discrepancy Resolution |
| 053. Develops guidelines for data entry. |
| 054. Resolves discrepancies and issues that arise during data entry that are not readily resolved by data entry staff, e.g. medical abbreviations and terminology, marginalia. |
| 055. Understands the discrepancy resolution process (includes AE-subject data). |
| 056. Compares the entered data to the original to arrive at proper verification. |
| 057. Reviews and oversees routine verification activities to assure consistency and judgement. |
| 058. Creates reports to track data entry process. |
| CRF Data Validation (e.g. data review, cleaning, query generation, applying data handling conventions) |
| 059. Understands the data validation process and its importance. |
| 060. Understands the interaction of data types across CRFs and visits to perform review where automated checking is inefficient. |
| 061. Identifies areas of manual review where electronic checks are not effective. |
| 062. Is able to apply thorough detailed review of CRF data routinely. |
| 063. Initiates automated methods to minimize manual review. |
| 064. Identifies tools and methods to improve or facilitate manual review process. |
| 065. Evaluates and improves efficiency of the data validation, query, query resolution process. |
| 066. Relates elements of protocol to defining data validation checks. |
| 067. Defines content, structure and procedures for using a library of standard data validation procedures and queries. |
| 068. Applies standard data validation techniques, software and guidelines to routine data cleaning activities. |
| 069. Defines new requirements for data validation techniques, procedures, etc. |
| 070. Defines data handling conventions. |
| 071. Uses appropriate problem solving techniques to ensure that the precise data problem is identified and queried. |
| 072. Defines standards for written queries and query process. |
| 073. Develops standard query language. |
| 074. Writes clear, concise queries. |
| 075. Generates queries based on standard data cleaning practices. |
| 076. Documents and maintains data validation process, SOPs and standards. |
| Safety Review |
| 104. Identifies safety issues/trends for the study based on clearly defined guidelines and a review of all clinical trial data. |
| 105. Understands safety profile of the drug under study and disease state of patients. |
| 106. Defines guidelines for identifying safety issues/trends in collaboration with clinical. |
| 107. Communicates safety trends to project team. |
| 108. Develops and maintains process, SOPs and standards to compliance with regulations for reviewing and reporting SAE data. |
| 109. Understands severity levels in AE data. |
| SAE Reconciliation |
| 138. Understands the definition of serious adverse events. |
| 139. Is able to identify SAEs in clinical data. |
| 140. Develops and maintains SOPs process and standards for reconciling SAE data with other clinical trials data. |
| 141. Understands the SAE reconciliation process. |
| 142. Reconciles clinical databases' adverse events with serious adverse event reporting databases according to guidelines. |
| 143. Documents the outcome of the reconciliation process clearly and consistently. |
| 144. Creates automated tools/or ad-hoc reports to present information appropriate to reconciliation. |
| 145. Relates different or similar medical terms/conditions in order to reconcile information presented in different text/coding terms from different systems. |
| 146. Understands the data that SAEs are reconciled against and make decisions on what to query. |
| 147. Performs and makes tactical decisions about the SAE reconciliation process. |
| Review of Final Data Tables or Graphs |
| 209. Identifies inconsistent data points. |
| 210. Understands algorithms for derivations, collapsing, imputation, and summarization of data. |
| 213. Identifies outliers. |
| 214. Handles and documents outliers. |
| Archiving Database and Associated Information |
| 222. Understands procedures related to archiving. |
| 223. Develops and maintains archiving process and standards SOPs. |
| 226. Performs data archiving steps. |
| CRF Design |
| 012. Relates protocol to CRF design and ensures that design supports data analysis and reporting requirements. |
| 013. Creates effective/efficient new CRF designs from new data types that are defined by protocol. |
| 014. Understands and applies widely accepted good CRF design techniques. |
| 015. Collaborates with team members to assure all needs are met by the CRF design. |
| 016. Identifies data collection that will require non-standard programming. |
| 017. Is able to explain why a particular collection method is not appropriate if it isn't. |
| 018. Defines content, structure and procedures for using a library of CRF design modules. |
| 019. Ensures CRF design consistency across number of studies in a program. |
| 020. Identifies and requests additions to standard metadata. |
| 021. Creates annotated CRF. |
| 022. Documents CRF completion guidelines and instructions. |
| 023. Presents CRF completion instructions at investigator meetings. |
| 024. Develops and documents the process, SOPS, and standards for CRF design, approval, and change control. |
| Query Resolution |
| 077. Clearly understands the data problem identified. |
| 078. Writes clear and concise query responses. |
| 079. Applies corrections to database using appropriate QC. |
| 080. Develops and maintains process, standards and SOPs for query resolution. |
| 081. Applies sound judgement and decision making to evaluating responses and applying to database updates, documentation, etc. |
| Query Tracking |
| 082. Develops and maintains process SOPs and standards for query tracking. |
| 083. Creates tools to track and inventory queries. |
| 084. Maintains tracking/inventory and identify outstanding queries. |
| 085. Categorizes queries by age/site and regenerates if necessary. |
| 086. Tracks down and retrieves outstanding queries. |
| 087. Creates standard reports to efficiently identify outstanding queries, query types per site, etc. |
| 088. Generates and interprets standard reports of query status, in support of standardized metrics. |
| 089. Defines user requirements for integrated electronic tools for query linking and management. |
| 090. Relates queries per site to additional training requirements at site to attempt to reduce query needs. |
| 091. Relates queries to processes and activities (e.g. CRF design) requiring process improvements. |
| Database Updates |
| 099. Follows up on query responses, errors identified in data cleaning by performing accurate database updates. |
| 100. Reviews the updates of peers in terms of assuring accuracy/quality. |
| 101. Documents database changes in the automated system audit trails and paper/electronic documentation. |
| 102. Develops and maintains process, standards and SOPs for performing database updates. |
| 103. Reviews audit trails, database change rates to assure staff expertise, extraordinary problems with CRF design, investigator site training, database screen design, etc. |
| Coding (AEs; Signs and Symptoms) |
| 110. Understands medical terminology. |
| 111. Utilizes available tools, systems and processes in support of the coding of medical terms. |
| 112. Understands the structure of an electronic medical dictionary. |
| 113. Understands what medical autoencoding is and how it works. |
| 114. Possesses knowledge of algorithms that are applied to coding. |
| 115. Can manually code adverse events, when/if required. |
| 116. Familiar with all standard adverse event dictionaries, e.g. COSTART, MedDRA. |
| 117. Familiar with company-specific dictionaries and code lists. |
| 118. Defines company-specific dictionaries and code lists. |
| 119. Develops and maintains process SOPs and standards for coding adverse events and symptoms. |
| 120. Creates an ad hoc listing of coded adverse events for clinical review of pointings/mappings. |
| 121. Reviews and approve a list of coded terms. |
| 122. Determines if the correct preferred term has been applied. |
| 123. Defines autoencoding algorithms. |
| 124. Comprehends coding algorithms and assures that the correct algorithm has been applied. |
| 125. Understands the structure of a dictionary and manipulates it, if necessary. |
| 126. Identifies all standard AE dictionaries and understand the differences between them. |
| Coding Medications |
| 127. Understands what medication coding is and why it is important. |
| 128. Understands drugs dictionary drug classes and what they mean. |
| 129. Determines if the correct code has been applied. |
| 130. Creates an ad hoc listing of medications. |
| 131. Can manually encode medication data, when/if required. |
| 132. Understands algorithms and how they are applied to coding. |
| 133. Identifies all standard drug dictionaries, e.g. WHOMED, BNF. |
| 134. Develops and maintains SOPs process and standards for coding medications. |
| 135. Creates ad hoc listings of medications for clinical review of pointings/mappings. |
| 136. Defines drug autoencoding algorithms. |
| 137. Understands the structure of the medication dictionary. |
| Database Quality Control Audits |
| 188. Understands the data handling process, tools and data management plan. |
| 189. Understands and applies quality acceptance criteria. |
| 190. Distinguishes critical from non-critical errors. |
| 191. Performs database audit and generates report per guidelines. |
| 192. Documents database QC performed. |
| 193. Develops and maintains process and standard SOPs relevant to database audits. |
| 194. Established quality criteria and quality error rates acceptance limits. |
| 195. Evaluates data points that should be audited. |
| 196. Establishes timelines to perform an audit and oversees activities of audit team. |
| 197. Identifies root cause of errors in order to recommend change in process/technology to assure the error doesn't occur again (continuous improvement). |
| 198. Ensures adequate preparation for internal and external database and data management audits, can respond knowledgeably and confidently to issues or questions that arise during audits. |
| 199. Ensures scope of audits include all potential sources of data errors. |
| 200. Ensures that sampling audit techniques are statistically valid and support decisions made about data. |
| 201. Applies sound judgement on handling audit findings. |
| 202. Identifies inconsistent data points. |
| 203. Understands algorithms for derivations, collapsing, and imputation. |
| 204. Defines requirements for data listings. |
| 205. Identifies trends in data. |
| 206. Identifies outliers. |
| 207. Deleted from capabilities. |
| 208. Handles and documents outliers. |
| Review of Final Reports |
| 217. Understands Clinical Study Report Guidelines. |
| 218. Understands the Clinical Study Report Outline. |
| 221. Understands the following: ISE- Integrated Summary of Effectiveness, ISS- Integrated Summary of Safety Information. |
| Information Technology |
| 252. Conducts user testing of systems and applications per written specifications. |
| 253. Develops and approves user acceptance test specifications and test results. |