Decision Support

Get or Change Access > For Users

Which Data Should I Request?

Access to the Data Warehouse is provided by data collection.  Your Unit Security Contact must request your access to each of the data collections that you desire to use to create custom reports or data downloads.

The table below will assist you in determining which data you should request access to in order to create reports you need.  Click on the links to get detailed technical information about the data included in each data collection.

If you would like to... Ask your USC to request your access to... Notes
Report on Academic History data for current and former students, and create reports like:
  • Awarded or Pending Degree Lists
  • Level GPA by Term
  • Course Taken History
  • Informal Class Rosters w/ Grades
Records  
Perform Census Reporting like:
  • Listing of Students Enrolled at 10th Day
  • Listing of Students by Attribute at Census Date
Registration Census  
Report on Course Catalog & Schedule data like:
  • Cross-Listed Sections
  • Canceled Courses
  • Renumbered Courses
  • List of Courses by Instructor
Catalog & Schedule  
Perform Enrollment & Curriculum Analysis and create reports like:
  • Informal Class Rosters
  • Student Attribute Lists
Registration Census (data 'frozen' at specific points in time - 10th Day, Last Day to Register, etc.)  
Perform Financial Aid Analysis     Financial Aid FinAid data is generally restricted to Financial Aid offices on each campus.  Check with your Financial Aid Office for more details.
Perform Instructional Assignment Analysis
Pre-Registration & Registration Contains both HR data and Pre-Registration & Registration data.  Request the Instructional Assignment security role.
Create Recruiting reports like:
  • List of Recruits for College or by High School
  • Activity at Sponsored Events
Recruiting & Admissions  
Create Admissions reports like:
  • List of Applicants
  • Analysis of Placement Scores
  • Analysis of Applicant Decision Status
Recruiting & Admissions  
Perform Purchasing Analysis and create reports like:
  • Purchase Order Listings
  • Purchase Order Balance
  • Unreconciled P-Card Transactions
Finance  
Report on Accounts Receivable Finance Requires separate AR security role
Create Cash and General Ledger reports like:
  • Summary of Claim on Cash by Fund and Fiscal Year
  • General Ledger Transactions by Fund and Account
Finance  
Create reports of CFOAPAL Listings like:
  • Financial Persons by Organization
  • College & Department Listing by Chart
Finance  
Report on Encumbrances & Reservations Finance  
Report on Expenses & Revenue Finance  
Report on Fixed Assets Finance  
Perform Payroll Analysis HR/Payroll  
Report on Salary Planner and Budget Information HR/Payroll and Finance  
Perform Deduction Analysis HR/Payroll Deduction data is only available to Payroll and Benefits Office staff
Perform Employee Attribute reporting such as:
  • Review Employment-Class Info
  • Create Employee Mailing Labels
HR/Payroll  
Perform Position & Job Analysis and create reports like:
  • Job End Dates or FTE Listings
  • Job or Position Detail Listings
HR/Payroll  
Report on Time & Attendance Recorded HR/Payroll  


To learn about the different data collections that are available for use, please see the Data Collections Summary, or, for more technical details, visit the DS Metadata

If you have questions about what data collection is appropriate for you, contact Decision Support via the on-line Help Desk.