100 likes | 267 Views
IRDB “Redesign”. Trainee Activities PowerView May 9, 2002. Agenda. Review redesign goals PowerView goals and objectives Present PV_TRAINEE_ADMIN Suggested enhancements to the TA module. IRDB Redesign Goal. Make the IRDB the eRA Decision Support System (DSS)
E N D
IRDB “Redesign” Trainee Activities PowerView May 9, 2002
Agenda • Review redesign goals • PowerView goals and objectives • Present PV_TRAINEE_ADMIN • Suggested enhancements to the TA module
IRDB Redesign Goal • Make the IRDB the eRA Decision Support System (DSS) • Give people the information they need • Make the information useful • Improve performance • Minimize the impact of change on the IC
PowerView Goals and Objectives • Provide business area centric reporting structures, that • Facilitate ad-hoc querying and reporting using common tools (e.g., Access, Excel, and Discoverer) • Provide timely, accurate, and consistent data to current, history, and pubfile records
IRDB Redesign Proposed TA PowerView
PV_TRAINEE_ADMIN • Includes all type “T” and “F” records • National Research Service Award (NRSA) applications and appointments • Fellowship awards • Designed primarily for GM and PA staff
Key indicators Appt. status code and descrip. (6) Appt. type code (6) DSF code (7) FOT code and descrip. (7) Payback status code (8) Termination status code (10) WIP status code (10) Key dates Activation date, type 1 and 2 “Fs” (6) Project start and end dates (8) Support limit waiver approval date (9) Trainee appointment start and end dates (9) Termination date (10) Key Indicators and Dates
Funding data Stipend level (9) Stipend amount (9) Total stipend amount (10) Travel amount (10) Tuition amount (10) Person Data Full name Person ID (8) Person profile ID (8) Person invol. ID (8) Person type code (8) Role type code (8) Stipend level degree code (9) Budget and People Data
Admin data *Appl ID (6) *Source_code_dc (6) *Appointment num (6) Activity code (6) Admin. IC (6) Appl. Type code (6) External org ID (7) FY (7) Full grant number (7) Admin data cont’d. Major activity code (7) Org Name (8) Project title (8) Serial Number (9) Suffix code (9) Support waiver limit code (9) Admin Data * = Primary Key
Track more than one degree Track trainee after leaving NIH Training discipline Support once training stops Project description Department, program, and major component names Prior NRSA support Prior non-NRSA support Trainee institution name TA module enhancements!?