Cognos

Subject Area

Examples of Available Reports

The General Ledger (GL) Aggregate query package contains general ledger information aggregated by fiscal month and account string. It is used by people who manage responsibility center, departmental, or project income, expenses, and balances. Both actual and budget amounts are included for the month, fiscal year to date, project to date, and prior fiscal year.

The GL Transaction query package contains detailed general ledger information for each transaction. It is used by people who manage responsibility center, departmental, or project income, expenses, and balances. Actual and budget debit, credit, and net amounts are included for the transactions. Various revenue and expense calculations are included in the package. Various organizational hierarchies can be used to group the transactions.

Level II Balance Sheet
Level II Balance Sheet Department Summary
Level II Financial Report Area Summary
Level I Balance Sheet
Level I Financial Report
Level I Financial Report - Masters/Subs

The Payroll Transaction query package contains detailed labor distribution transaction information by fiscal month. It could be used by people who manage responsibility center, departmental, or payroll expenses. Adjustment and regular pay amounts are included for each month, along with a fiscal year to date and project to date amount.

Labor Distribution by Account
Labor Distribution by Account (unformatted)
Labor Distribution by Account - Masters/Subs

Subject Area

Examples of Available Reports

The Active Student package contains personal and academic data for any student who is enrolled or eligible to enroll as of today's date.

The Active Student package is a query-only area

The Admissions package contains personal, academic, and application information for each student application to the University. It also contains high school and test score (e.g., SAT and ACT) information. The package could be used to identify all students that have applied to a particular school with a math SAT test score of > 500, for instance.

The Class Enrollment package contains students' personal and academic enrollment data as well as detailed class information.

Veteran Services Reports

Consumers Report by Fiscal Year

Producers Report by Fiscal Year

The Course Catalog package contains information about courses offered at the University of Pittsburgh. It is used to generate a list of active courses by campus or by school for an academic term; course enrollment requirements summary, etc.

The Class Schedule package contains data pertinent to the class, such as schedule, location, instructor, prerequisites, class credit, textbook, and fee information. In addition to generating a class schedule report, it can be used to produce online course listings, room usage reports, lists of classes for the school by instructor, etc.

Schools Offering Classes – Attribute/Attribute Value

Class Schedule All Columns Report

Class Section Update Report

GSPIA Reports > GSPIA Course Schedule by Instructor

The Enrollment & Tuition package contains personal, academic, and tuition data for any student enrolled for the specific term within a snapshot. It could be used to trend the in-state and out of state student enrollment and tuition dollars over the years, broken down by demographics and academic information.

Enrollment, Tuition, and Credits by Academic Plan Code

FTE Headcounts and Tuition

Grades for Repeated Classes

IMPACT Reports > PA degrees awarded by county

Pitt-Greensburg > GBG Education Minors

There are two Financial Aid packages: Financial Aid Award and Financial Aid Need. The award and need packages are separate since need amounts are by aid year and award amounts are by term. These packages contain personal, academic, and financial aid need and award data for enrolled students. The packages could be used to analyze scholarship retention statistics, for example.

Net Tuition Division Reports for Selected Campus and Academic Center

The Freshman Retention package contains personal, academic, and class enrollment data for each first-time student for each term of the student’s first year plus fall term of their second year in college. Financial aid need information is also available.

Fall Freshman Retention Action Report

Fall Freshman Retention Action Report by Campus

The Graduation package contains students' first graduation and degree information, as well as demographic and graduation GPA data. The most recent data for degrees is in this package. It can be used to calculate graduation rates, average time to graduate, etc.

The Graduation Census Query contains a snapshot of the same data as of the degree census date for each year.

Graduation and Retention Reports Containing Counts and Rates > Graduation Counts and Rates Report by Term and Grouping – Regional Campuses Graduation and Retention Reports > Number of Freshmen in Cohort by Demographic Grouping – Pittsburgh Campus

First Enrollment and Graduation of Online Students

Degree Reports > Certification and Degree Awarded by Academic Year and CIP

There are six packages of Student Financial data divided into two separate sets.

One set is for student billing information; the second set pertains to third party billing information. The three packages in each set are Accounting Line, Item Line, and Item.

The Accounting Line package can be used to query debits and credits posted to PRISM. The Item Line package can be used to query the details of each transaction, such as the date it occurred and the item type of the transaction. The item package can be used to query the account information at a higher (less detailed) level of the account, such as the account term or the item term amounts.

Aging report – By Student

Aging report – By third Party

Subject Area

Examples of Available Reports

The Employee Pkg package contains personnel data for all employees.

What employees are in a particular RC

What is the current demographic makeup of all staff members of University

What is the historical turnover rate for the past 5 years for all full-time faculty members.