The Analysis Database

1
The Analysis Database
CommonManagement Systems

• December 7, 2005

2
Todays Agenda

• Transcript functionality
• Degree audit Analysis Database functionality
• Analysis Database potential in Facilitating
  Graduation
• Sample report

3
PeopleSoft Academic Advising in Summary

• Academic advising components
• Tiered rules structure
• Course lists
• Requirement groups, requirements, requirement
  lines
• Milestones other non-course-based requirements
• Requirement rules tied to academic structure
• Exceptions handling capability

4
PeopleSoft Academic Advising in Summary

• Delivered via special-purpose transcript
• Available in Self Service online PeopleSoft
• Students
• Faculty / Advisors
• Specific authorized staff
• Advisement engine
• Analysis Database
• Delivered set of choices
• Transcript data
• Appearance

5
Steps to Produce Degree Audit Report

• Configure transcript type
• Official and unofficial reports
• Self service availability

6
Steps to Produce Degree Audit Report

• Configure transcript type
• Official and unofficial reports
• Self-service availability

7
Steps to Produce Degree Audit Report

• Configure transcript type
• Official and unofficial reports
• Self service availability
• Set-up transcript type security access

8
Steps to Produce Degree Audit Report

• Set-up transcript type security access

9
Steps to Produce Degree Audit Report

• Configure transcript type
• Official and unofficial reports
• Self service availability
• Set-up transcript type security access
• Submit transcript request
• Request transcript type
• Specify Analysis Database results

10
Steps to Produce Degree Audit Report

• Submit transcript request
• Request transcript type
• Specify Analysis Database results

• Completed Only
• Incomplete Only
• Analysis Database
• Standard Report Format

11
Steps to Produce Degree Audit Report

• Configure transcript type
• Official and unofficial reports
• Self service availability
• Set-up transcript type security access
• Submit transcript request
• Request transcript type
• Specify Analysis Database results
• Process request

12
Steps to Produce Degree Audit Report

• Process request

13
Creating Transcripts in Batch
14
Steps to Produce Degree Audit Report

• Configure transcript type
• Official and unofficial reports
• Self service availability
• Set-up transcript type security access
• Submit transcript request
• Request transcript type
• Specify Analysis Database results
• Process request
• View results

15
Steps to Produce Degree Audit Report

• View results

16
Transcript Requests the Analysis Database
17
Categories of Tables Comprising Analysis Database

• Summary tables
• R_CAREER
• R_ACAD_PROG
• R_ACAD_PLAN
• R_ACAD_SUBPLAN

E.g., from R_ACAD_PLAN
Computer Science BS
18
Categories of Tables Comprising Analysis Database

• Requirement completion tables
• R_RG_LINK
• R_RQRMNT_GROUP
• R_REQUIREMENT
• R_RQRMNT_LINE

E.g., from R_RQRMNT_GROUP
COMPUTER SCIENCE PRIMARY MAJOR B. S.
2003-Current Catalog - 89 Units Required
(RG-0666)
GENERAL EDUCATION REQUIREMENTS 1999-Current
Catalog - 51 Units Required (RG-0007)
19
Categories of Tables Comprising Analysis Database

• Requirement satisfaction tables
• R_UNIT_CRSE_GPA
• R_COURSE_USEAGE
• R_TRANSCRIPT

E.g., from R_TRANSCRIPT
20
Categories of Tables Comprising Analysis Database

• Overrides/substitutions tables
• R_OVERRIDE_RG
• R_OVERRIDE_RQ
• R_OVERRIDE_LN
• R_COURSE_DIREC
• R_SUBSTITUTION

E.g., from R_OVERRIDE_RQ
GENERAL EDUCATION (1999)
GE CATEGORY C
21
Categories of Tables Comprising Analysis Database

• Simulations conditions tables
• R_WHAT_IF
• R_RQDPLN_HEADER
• R_RQDPLN_DETAIL
• R_COND_USEAGE

E.g., from R_WHAT_IF
Spring 2002
English Literature BA
22
Categories of Tables Comprising Analysis Database

• Control tables
• R_REPORT
• R_ORDER
• R_DESCRIPTION

E.g., from R_REPORT
23
Transcript Results Become Analysis Database Tables
R_CAREER R_DESCRIPTION
R_ACAD_PROG R_DESCRIPTION
24
Transcript Results Become Analysis Database Tables
R_RQRMNT_GROUP R_DESCRIPTION
R_UNIT_CRSE_GPA R_DESCRIPTION
R_REQUIREMENT R_DESCRIPTION
R_UNIT_CRSE_GPA R_DESCRIPTION
R_REQUIREMENT R_DESCRIPTION
R_UNIT_CRSE_GPA R_DESCRIPTION R_COURSE_USAGE
R_ RQRMNT_LINE R_DESCRIPTION
R_COURSE_USEAGE R_DESCRIPTION
25
Potential Benefits

• Potential benefits Analysis Database
• Combine degree audit data with other tables
• Useful to achieve 22 Facilitating Graduation
  recommendations in reports
• Ability to develop custom advisement transcripts
• Purge capability to exist in CS Bundle 3
  (January, 2006)

26
Sample Report
27
Initiative 18

• Initiative 18 from AA-2005-21 requires the
  following
• Mandatory and If Needed Intrusive Advisement as
  Student Approaches / Exceeds Minimum Units
  Required for the Degree
• Suggested elements include full degree audit at
  least for selected students as they approach the
  degree and the use of registration holds or
  other strong requirements for students whose
  accumulated unit totals exceed the minimum
  requirements for the degree, operationalizing in
  that way a strong advising requirement.
• How do you identify these students?

28
Initiative 18 Report
This report uses information from the analysis
database combined with data from the students
academic record (STDNT_CAR_TERM) to identify
students who have the potential to accumulate
excess units because the sum of their units taken
to date and the units needed to complete missing
requirements exceed the total units required for
the degree.
29
Tracking Completion of General Education
This report uses information from the analysis
database combined with data from the students
academic record (STDNT_CAR_TERM) to identify
students who have completed more than 60 units
but who still have General Education requirements
to be completed.
30
Tracking Completion of General Education
The information can be grouped in various ways
and presented graphically.
31
Analyzing How Requirements are Met
32
Analyzing How Requirements are Met
33
Questions
?
Hmmmmm?
How did?
How does?
What about?
What if?
How can?
Why does?