Cognos Data Guide

Summary

The Cognos Data Guide provides a summary of the various data groups available in Cognos and the types of data that can be found in them. This article is particularly useful for people trying to determine what data groups should be requested for their work within the Cognos reporting service.

Body

Overview

This article describes the data security groups available in Cognos and the types of data they contain, or what job functions might need to request their access. All data security groups beyond Core Data require the approval of the responsible Data Steward before access can be given.

For instructions on requesting access to security groups beyond Core Data, see How do I get access to the IDR data warehouse and Cognos?.

Core Data

The Core Data group is the default security group for all Cognos users, which contains University of Oregon data that has been deemed available to all employees without additional approvals. The data in this group spans the Finance, HR and Student domains and includes most financial transactions, non-sensitive personnel data, and class schedule and course definition data.

Core Data also includes all of the list of value tables that provides codes and descriptions to assist with building report prompt pages.

Finance and Human Resources (HR)

The results you see on Cognos reports within the Finance and HR modules will be filtered by the contact information for which you are approved. For example, if a report contains a Vendor Mailing address (MA) and you are not approved for Vendor Mailing addresses, that information will be blank on your report.

If you require any of the contact information listed below, please apply for that access.

Contact Information

  • Core Contact Information – Automatically granted with Core data
    • Employee UO and Vendor VO, VP and VR address, phone and email
    • VO is Vendor Orders, VP is Vendor Payments and VR is Vendor Remit
  • Common Employee & Vendor
    • Core plus Employee MA, PR and Vendor MA, PR address, phone and email
    • MA is Mailing and PR is Permanent
  • All Employee and Vendor
    • Core plus Employee & Vendor contact info
  • Student Detail within Finance/HR Reports
    • Student unmasked name and ID; MA, PR address, phone and UO email o
    • MA is Mailing and PR is Permanent Additional Data
  • Core Data includes all Banner data from Finance, HR and Student that isn't deemed sensitive or private. Examples are departmental budgets, grants, payroll, employee positions, course catalog, faculty assignments
  • Sensitive Finance includes bank and collection agency data
  • Private Finance includes SSN, tax ID, bank account
  • Sensitive A/R includes charges, payments, disbursements, deposits, holds, degree, ethnicity, race, veteran, athletics, visa, tax
  • Private A/R includes tax ID, sensitive HR includes ethnicity, race, citizenship, veteran status, benefits, deductions, visa, taxes, leaves, degrees, employment history, academic outcomes
  • Private HR includes tax ID, beneficiary tax ID

Additional Data

  • Core Data includes all Banner data from Finance, HR and Student that isn't deemed sensitive or private. Examples are departmental budgets, grants, payroll, employee positions, course catalog, faculty assignments
  • Sensitive Finance includes bank and collection agency data
  • Private Finance includes SSN, tax ID, bank account
  • Sensitive AR includes charges, payments, disbursements, deposits, holds, degree, ethnicity, race, veteran, athletics, visa, tax
  • Private AR includes tax ID
  • Sensitive HR includes ethnicity, race, citizenship, veteran status, benefits, deductions, visa, taxes, leaves, degrees, employment history, academic outcomes
  • Private HR includes tax ID, beneficiary tax ID

Student

  • Sensitive Student contains general student info, registration, person information, and majors
  • Academic History contains student transcripts, advisors, grades, and GPAs
  • Admissions Data contains undergraduate (UG) and graduate (GR) applicant data
  • Sensitive Person Details contains Date of birth, race, ethnicity, tax ID, and deceased status
  • Athletics contains student sports information
  • Veterans contains veterans education benefits information
  • Holds is for staff who place/remove holds only
  • International contains passport, and sponsor information
  • Withdrawals is for staff who require student withdrawal information

Details

Details

Article ID: 140749
Created
Thu 5/9/24 2:00 PM
Modified
Thu 11/7/24 5:41 PM

Related Services / Offerings

Related Services / Offerings (1)

Use this service to request support for Integrated Data & Reporting (IDR)-Cognos support