emily freeman, college of medicine gail douglas, information … · gail douglas, information...

Emily Freeman, College of Medicine Gail Douglas, Information Technology

History & Background

• Started in 2005

• Created to be a centralized data repository for faculty for all colleges

FacFacts Technical Components

Grants Systems

Demographics

Historical Data

JFR

ARIA

FITS

SAP

Web Portal

New Faculty

History & Background

• SQL Server

• Web-based, intranet site

• User Authenticated – UAMS ID/password off domain

• Updated nightly with a download from SAP/ARIA

Role-Based System

Role-Based System

Current Projects/Uses

COM Faculty Data Repository

Current Projects/Uses

CON Faculty Data Repository

Current Projects/Uses

CV Generator

Current Projects/Uses COM Salary Letters

Current Projects/Uses COM FTE Reporting

Current Projects/Uses

COM Promotion & Tenure System

Other Projects/Uses

COM Annual Report

http://intranet.uams.edu/com-2008-2009.pdf

Frequently Used Reports COM Faculty Roster

Frequently Used Reports

LCME Reports

Frequently Used Reports

COM Department Rosters

Frequently Used Reports Customizable Reports

• Name

• Credentials

• Department

• Division

• Home Address

• Work Location

• Work Address

• Slot

• Start Date

• Email

• Rank

• Gender

• Ethnic Origin

• SAP ID

• Employment Classification

• VA 8ths

• Tenure Status

• Tenure Pathway

• Institution

• DOB

Upcoming Projects Faculty Development Report

Expected Projects

• Build Your Own Report (in progress)

• NIH Biosketch

• User Keyword Search

• Website Information

QUESTIONS?