System at Barbara Ann Karmanos Cancer Institute

Cancer Center Administrators Forum April 4, 2011 Hollings Cancer Center

Donna J. Mott,

Director Clinical & Administrative Systems

Organizational Chart Scientific Director of Cores Center Director Deputy Center Director Associate Center Director for Research Administration Executive Assistant Director Laboratory Operations & Shared Resources Director Grants and Contracts Director Clinical and Administrative IT Systems Director Basic and Population Sciences IT Systems Administrative Manager Manager, Post-Award Services

Department of Research Administration

Research Administration Systems at KCI  SQL Server database  ASP.Net Framework  DotNetNuke Content Management System (Research Portal)  Three environments:  Development (Microsoft Visual Source Save)  Certification  Production

Research Administration Applications      Research Administration Application Core Utilization Biosketch/ Other Support Research Portal Tracker

Research Administration Application ● ● ● ● ● Membership ● Contact Information, Rank, Title, Membership Classification, and Program Affiliation.

Publications ● Scientific Publications by Member, by Research Program and by Shared Resource Core Facility.

Grant/Funding ● For all submissions, pending, active and completed.

Output: Summary Reporting (1a, 1b, 1c & 1d; 2a, 2b), Internal Reports, Membership Reports, Inter- and Intra- Programmatic Publication Reporting.

Security: Active Directory and, Authorization Manager.

Research Administration Application © (RAA) Database

Research Administration Application © (RAA) Database

Automated Publication Service  PubMed is a free resource that is developed and maintained by the National Center for Biotechnology Information ( NCBI ), located at NIH  The web service calls eFetch and eUtils to search publication from PubMed automatically every Friday  The process returns XML format, if the pub do not exist in the RAA table the process imports into RAA.

RAA Publication Flow Diagram PubMed Automated Data Extract publication from NIH PubMed database EndNote Reference Manager Import Import publication from internal data source RAA user interface screen Manually enter Manually enter data Review/Filter KCI Internal

RAA Publication

NIH Select Publication Generate Reports External Foundations Other

Bio- sketch Publication

NCI

Core Utilization Application

 To manage Utilization of Shared Resource Services Provided.

 To process Shared Resource Financial Billing  Output: Reports by Core for Projects, Utilization, Invoices, NCI Required Reporting (CCSG).

 Security: Three levels, Active Directory, Authorization Manager, and Application.

Core Utilization Module

Biosketch and Other Support

    Collects and stores a member’s biographical information according to NIH guidelines.

     Education & Training Personal Statement Positions and Honors Peer Reviewed Publications Research Support Other support collects and stores active and pending grant information.

Output: Biosketch Report by Member, Other Support Reports by Grant.

Security: Three levels, Active Directory, Authorization Manager, and Application.

Biosketch/ Other Support

Research Portal

 Dedicated website to Research at Karmanos.

      Real Time Membership Report Research Programs Shared Resources Committee and Research Team Support Flexible Management of Content Multiple levels of security • Public Access • • Active Directory Application Level Groups  https:/www2.karmanos.org/research/home2

Research Portal

Tracker

 Effort Tracking System  Management Decision Making Regarding Workload  Utilization Efforts Spent on Grants and Projects  Billing for Staff Services  Output: Reports by Project, Staff, Application  Security: Active Directory, Authorization Manager

Tracker

Next Steps

 Integrate the RAA Grants Module with the Wayne State University faculty effort information.

 Integrate the Clinical Trials Management System protocol information with RAA Grants Module.

Discussion