Home :: Content

Student Profile


Quick View
Summary: 

The goal is to create a table or tables to support reporting for student data. This structure will combine many topics, thus avoiding complex and confusing query structures that involve multiple subqueries.

The two most important reasons for creating this are:

  1. It shows a student’s enrolled hours without having to accumulate individual class enrollment hours out of PS ASU STDNT ENRL.
  2. It provides current program plan information without having to go thru the program/plan stacks.
Start Date: 
July 6, 2009
Go Live: 
December 18, 2009
End Date: 
January 8, 2010
Current Milestone: 
November 27, 2009 - Phase one testing completed.
Stage: 
On track
People
Sponsor/Champion: 
Elizabeth D. Capaldi, Executive Vice President and University Provost
Lead Customer: 
Sheila Ainlay
Lead Customer: 
Lou Ann Denny
Project Manager: 
Sharan Johnson
Contact for more information: 
sharan.johnson@asu.edu
Associate VP University Technology: 
John Rome
University Technology Director: 
Kendal Burkhart
More Info
Source: 
Executive
Department: 
Registrar
Priority: 
Medium
Scope: 

The previous Data Warehouse provided a Student Profile table. The new PeopleSoft student data has assumed a new level of complexity.

This project will produce a simplified student profile table (eliminating the need for subqueries). The table will have one record per term, per student, per career, per active plan.

Flags will be used to identify primary program/plan which will let you see one record per student per term like the previous Student Profile table.

The data is mainly Student Registration related. It may also include Financial Aid data.

All Milestones and Schedule: 

Initial Planning:  Completed

  • July 14, 2009 -- Identify roles and fill out Current Project Roles Spreadsheet -- Completed
  • July 17, 2009 -- Prepare initial project plan, email stakeholders -- Completed
  • July 24, 2009 -- Agree on team members time needs -- Completed
  • September 25, 2009  -- Data fields identified per the scope of this effort. -- Completed

Programming:  Work In Progress

  • Table 1 - Completed
  • Table 2 - Completed
  • Potential Table 3 - To be completed by - Date to be determined
  • Criteria for Snap Shots to be determined - To be completed by November 25, 2009
  • EPM, MyReports - To be completed by November 25, 2009
  • Snap Shots - To be completed by December 4, 2009

Testing:  Work In Progress

  • Initial Testing - Work in Progress -- To be completed by November 27, 2009 (JoDean Marin, Jennifer Hornsby)
  • User acceptance testing -- To be completed by December 4, 2009  (Extended user group)

Additional Modifications/Fixes - Based on Testing Results:  To be completed by December 11, 2009

Final Testing:  Not Started -- To be completed by December 15, 2009

  • Regression Testing 
  • User Acceptance Testing
  • Iterative fixes and testing as needed

Production:  Not Started

  • Approval from customer to move to production -- To be completed by December 16, 2009
  • Request migration to production -- To be completed by December 17, 2009
  • Move to production -- To be completed by December 18, 2009

Project Close Out:  Not Started

  • Collect additional feedback from stakeholders  -- To be completed by January 7, 2010
  • Completion of Data Dictionary -- To be completed by January 6, 2010
  • Completion of Project Documentation -- To be completed by January 6, 2010
  • Review and Approval of Data Dictionary and Project Documentation -- To be completed by January 8, 2010
  • Project Closed -- To be completed by January 8, 2010

 

  • To be completed by January 8, 2009 -- Not started
  • Collect additional feedback collection stakeholders,
  • Completion of Data Dictionary,
  • Completion of Project Documentation,
  • Project Closing.

 

Deliverables: 

Student Profile table in the Data Warehouse
Documentation with all source and destination data fields and data transformation information.

AttachmentSize
New Student Profile.pdf21.05 KB
Syndicate content