RBB Reports - FINANCIAL

Externally Sponsored Activities

File location in Cognos: 1-UD RBB > Financial

Source:

  • The data from this report comes from FIRPT via the Data Warehouse - RBB Data Mart package.

Description:

  • This report provides a list of externally sponsored activities for a selected fiscal year.
  • The report has a drill-through capability to see Purpose/Chartfield1 and Project ID details.
  • The fund type is the 5th and 6th characters of the Purpose/Chartfield1. Fund types between ‘31’ and ’47, or equal to ‘3A’ or ‘22’ will be included.
  • Fund Code = ‘OPBAL’
  • Account is between ‘100000’ and ‘195999’
  • Program code is ‘'INST1', 'INST2', 'INST3', 'INST7', 'RSCH1', 'RSCH2', 'RSCH3', 'RSCH4', 'RSCH5', 'RSEXP', 'AGEXT', 'PUBSV', 'SPINS', 'INSTM','RSCHM','PBSVM'
  • UOD End Fiscal balance not equal ‘0’
  • The user will be prompted to select an accounting period and fiscal year.

Graduate Tuition Expense by College

File location in Cognos: 1-UD RBB > Financial

Source:

  • The data from this report comes from UDSIS via the Data Warehouse - Grad Tuition package.

Description:

  • A graduate tuition expense report has been created for every fiscal year from 2007 to 2009.
  • Graduate tuition expense is taken from the Billing tables in UDSIS where purpose code = ‘UNIV112211’ and then broken down by college based on the student’s primary program for the term. Graduate tuition expense is detailed by month, purpose code, and term.

Graduate Tuition Revenue by College

File location in Cognos: 1-UD RBB > Financial

Source:

  • The data from this report comes from UDSIS via the Data Warehouse - Grad Tuition package.

Description:

  • A graduate tuition revenue report has been created for every fiscal year from 2007 to 2009.
  • Graduate tuition revenue is taken from the Billing tables in UDSIS from several purpose codes and deferred accounts (IPSS112146, IPSS112152, IPSS112158, IPSS112163, UNIV112268, UNIV112269, UNIV112271, UNIV112272, UNIV112273, UNIV112274, UNIV112275, UNIV112276, UNIV112277, UNIV112278, UNIV112279, UNIV112281, UNIV112282, UNIV112283, UNIV112284, UNIV112285, UNIV112286, UNIV112287, UNIV112295, UNIV112296, L3T152, L3T227, L3T228, L3T153, L3T141, L3T132, L3T146, L3T137, L3T133, L3T136, L3T138, L3T139, L3T142, L3T143, L3T144, L3T145, L3T148, L3T149, L3T151)
  • The revenue is broken down by college using the student’s primary program for the term. It is detailed by month, purpose code, and term.

Restricted Endowment

File location in Cognos: 1-UD RBB > Financial

Source:

  • The data from this report comes from FIRPT via the Data Warehouse - RBB Data Mart package.

Description:

  • This report provides a list of restricted gifts given for a select fiscal year based on the fund type of 46 and 47. The fund type is the 5th and 6th characters of the Purpose/Chartfield1.
  • Column groupings are based on account.
  • '1 Begin Bal' includes account = ‘F12300’

'2 Endow Inc' includes account = 'R07000'

‘3TII' includes account = 'R07600'

'4 Oth Rev' includes accounts starting with ‘R’

'5 Expense' includes accounts starting with ‘1’ excluding those accounts starting with ‘199’

'6 Transfer' includes accounts starting with ‘199’

  • The user will be prompted to select an accounting period and fiscal year.

Restricted Gifts

File location in Cognos: 1-UD RBB > Financial

Source:

  • The data from this report comes from FIRPT via the Data Warehouse - RBB Data Mart package.

Description:

  • This report provides a list of restricted gifts given for a select fiscal year based on the fund type of 41 and 45. The fund type is the 5th and 6th characters of the Purpose/Chartfield1.
  • The user will be prompted to select an accounting period and fiscal year.

Space Allocation

File location in Cognos: 1-UD RBB > Financial

Source:

  • The data from this report comes from FIRPT via the Data Warehouse - RBB Data Mart package.

Description:

  • This report provides a list of buildings and rooms assigned to a department. It gives the total square footage and percent usage by room function. It also provides a link to the building’s floor plan c/o the GIS office.
  • The user will be prompted to select a department.

RBB Reports - HR

Employees by Department

File location in Cognos: 1-UD RBB > HR

Source:

  • The data from this report comes from HRRPT via the Data Warehouse - RBB Data Mart package.

Description:

  • This report provides a detailed list of employees.
  • The users are prompted to select the Employee Status, Salary Admin Plan, As of Date (Effective Date) and Department.
  • The users can drill through to detailed information of BioDemo, Position Data, and Earning and LAM Distribution.
  • Drill through to position data to see position funding in HR and UOD Balance detail
  • Drill through to HR Earnings and LAM Distribution detail
  • Drill through to BioDemo detail
  • Security for this report is the same as security in HRRPT.

Employees by Department Total Counts

File location in Cognos: 1-UD-RBBHR

Source:

  • The data from this report comes from HRRPT via the Data Warehouse - RBB Data Mart package.

Description:

  • This report provides employee counts by Department, Contract Type, Contract Terms and Salary Admin Plan.
  • The users are prompted to select the Employee Status, Salary Admin Plan, As of Date and Department.
  • The users can drill through to a detailed list of employees.
  • Security for this report is the same as security in HRRPT.

S Contracts

File location in Cognos: 1-UD RBB > HR

Source:

  • The data from this report comes from HRRPT via the Data Warehouse - RBB Data Mart package.

Description:

  • This report provides a detailed list of S Contracts including Empl ID, Name, Academic Year, Academic Term, Reason, Earnings Code, Course Description, Goal Amount, Contract Dates and Account information.
  • The users are prompted for As of Date (Effective Date), Academic Year, and Academic Term with optional choices of Reason and Earnings Code.

RBB Reports - STUDENT

Cross College Enrollment

File location in Cognos: 1-UD RBB > Student > RBB Reporting

Source:

  • The data from this report comes from UDSIS via the Data Warehouse - Student Enrollment Data Mart package.

Description:

  • This report provides a total of all units taken by students from colleges that are not their home college.
  • The students are grouped according to their primary program and academic plan. The units are totaled and broken down according to the college where it was taken.
  • Users are prompted for the program status and academic term.
  • Users can drill through the units taken to see the students enrolled in the courses, with the Student ID, Name, Academic Career Course Academic Group, Subject, Catalog Number, Class Section and Units Taken.

Graduate Admissions - Applications, Offers and Admits

File location in Cognos: 1-UD RBB > Student > RBB Reporting

Source:

  • The data from this report comes from UDSIS via the Data Warehouse - Admissions Data Mart package.

Description:

  • This report provides a count of graduate applications offers and admits by term, college and by academic plan. It also counts the number of US Citizens/Permanent Residents, international students, and minorities.
  • The applications are broken down by term and grouped by calendar year (Jan-Dec).
  • Users will be prompted for the admission year/s, the college, and academic plan/s.
  • Users can drill-through by academic plan to see the applicant’s gender, ethnicity, residency, and application status.

Graduate Degrees by Academic Plan - by Term

File location in Cognos: 1-UD RBB > Student > RBB Reporting

Source:

  • The data from this report comes from UDSIS via the Data Warehouse - Degree Data Mart package.

Description:

  • This report counts the number of graduate degrees awarded by academic term. It is not a count of students; rather of degrees completed. If a student completed both a Masters and PHD degree on the same term, the student will be counted twice.
  • The report will prompt the user for the academic term/s, college and academic plans. The academic terms selected are grouped by calendar year and totaled by year.
  • Users can drill-through and see the degrees awarded at the student level either by calendar year or by academic term.

Student Counts by Department Crosstab

File location in Cognos: 1-UD RBB > Student > RBB Reporting

Source:

  • The data from this report comes from the UDSIS via the Data Warehouse - UDSIS Official Extract package.

Description:

  • This report provides unduplicated headcounts and full-time equivalency calculation (FTE) by College and Department. FTE is calculated by dividing the total number of part time majors by 3 and adding the quotient to the number of full time majors.
  • The counts are broken down by Academic Term, Academic Load and Academic Career.
  • Users are prompted for Academic Term, Run Data ID and Academic Career.
  • Users can drill through to the detailed list of students.

Student Credit Hours by College & Department

File location in Cognos: 1-UD RBB > Student > RBB Reporting

Source:

  • The data from this report comes from UDSIS via the Data Warehouse - Student Enrollment Data Martpackage.

Description:

  • Each course in UDSIS is owned by a college. This report sums the credit hours from all the courses that the college owns (enrollment at the beginning of the semester * course credits). Credit hours are broken down by college, department, and level of instruction (Lower Division = 100- and 200-level courses, Upper Division= 300- and 400-level courses, Graduate = 500- to 800-level courses) per semester.
  • The report has a drill-through capability to see enrollment and course credits at the student level.
  • The user will be prompted to select the academic term/s and the college/s.

RBB Reports

Page 1 of 7