Understanding the Campus Solutions Warehouse

This chapter provides an overview of the Campus Solutions Warehouse, the Campus Solutions Warehouse structure, and the Campus Solutions Warehouse components.

Understanding Campus Solutions Warehouse

PeopleSoft Campus Solutions Warehouse is a comprehensive reporting and analysis platform. It includes a multidimensional warehouse (MDW) infrastructure for operational and near real-time reporting. It also contains packaged marts that provide a key multidimensional analysis and reporting environment. These marts help you understand recruiting trends and their success in generating new students. They also help make clear the class and term enrollments trends, as well as provide information regarding the curricula offered and its effectiveness. Lastly, the marts will help you understand the financial transactions of students attending the institution as well as knowing who has received and benefited from financial aid as part of their Academic career.

With PeopleSoft Campus Solutions Warehouse, you can review data against organizational metrics and perform strategic analyses to identify and track the multiple dimensions that affect profitability, and identify key performance drivers, trends and opportunities, and so on. You are able to organize information into several easy-to-manipulate dimensions, including: Business Unit, Academic Career, Academic Program, Academic Plan, Academic Subplan, Institution, Term, Admit Type, Recruiting Category, Referral Source, Application Method. You can take action on those issues that will most directly optimize business performance and influence profitability with measures and derived metrics such as Admissions Rate, Prospect Count, Application Count, Enrollment Rate and Graduation Rate.

PeopleSoft delivers the PeopleSoft Campus Solutions Warehouse complete with extract, transform, and load (ETL) maps, data models, data marts, and a library of key performance metrics. PeopleSoft Campus Solutions Warehouse combines the various dimensions, measures, and limited derived metrics into prepackaged Campus Solutions -specific analysis and sample reports. PeopleSoft Campus Solutions Warehouse also includes the tools that enable modifying or adding to the predefined reporting content

Note. For details of dimensions, see the PDF file that is published on CD-ROM with your documentation.

Understanding the Campus Solutions Warehouse Structure

PeopleSoft marts are subsets of PeopleSoft Campus Solutions Warehouse and are the foundation for the reporting applications. Marts are subject-specific relational schemas created for a particular group of users for multidimensional analysis and reporting. Each core functional area of the warehouse has predefined marts. PeopleSoft Campus Solutions Warehouse includes the Admissions Mart, Student Records Mart, and Student Financial Services Mart.

Campus Solutions Warehouse marts and business processes

Each mart is associated with a business process or processes that helps you to answer the questions you need to keep your organization robust and ahead of its competition. With each mart, we present the fact tables that will help you answer your critical business questions.

Note. For additional details of facts, see the PDF file that is published on CD-ROM with your documentation.

This section discusses:

Admissions Mart
Student Records Mart
Student Financial Services Mart

Admissions Mart

The analytic reports based on student admissions provides information about applicants to the institution and eventually to student records for successful applicants to the institution. There is a focus on the students’ academic career, academic program, admit term, and program status. This mart answers business questions such as:

How many prospects are there for a particular academic program? How many applicants are admitted and enrolled in classes for a particular academic program in a particular admit term?

Student Recruiting and Admission Business Processes

Admissions Mart is related to PeopleSoft’s Student Recruiting and Student Admissions Application business processes. The Student Recruiting business process fulfills institutions requirements to capture and track prospective student and their associated academic institutions, academic careers, academic programs, plans and sub-plans. This business process helps you manage prospective students through to the application process.

The Student Admissions business process tracks information about applicants to the institution tracking that applicant and their subsequent admission into the institution for the associated recruiter.

Admissions Mart Delivered Fact Tables

With Admissions Mart PeopleSoft provides the following fact tables:

Student Recruiting
Student Admission Application
Student Admission Application Status
External Test Scores
External Academic Summary

Student Recruiting Fact Table

The Student Recruiting fact table contains information on prospective students and the associated academic institutions, academic careers, academic programs, plans, and sub-plans. It also contains data on the recruiting categories, regions, and the recruiters to which the prospective students are assigned. With this fact group, you can answer questions such as “How many prospects are there for a particular academic program?“

The granularity for this fact table is every prospective student for an academic career in an academic institution and the related academic program, plan, and sub plan, assigned to a particular recruiting category and recruiter.

This table describes the facts in the Student Recruiting fact table:

Fact Name	Fact Name Fact Description
Prospect Count (Derived)	Contains Number of prospective students who are interested in and/or being recruited for an institution. The number of prospective students. This fact helps you to answer questions such as: How many prospective students are there?
Yield (Prospects to Applicants) (Derived)	Contains the percentage of prospective students (persons who have expressed interest) who have been converted to applicants (persons who have submitted admission applications). This fact helps you to answer questions such as: What percent of the prospects submitted applications?

Fact Name

Fact Name Fact Description

Prospect Count (Derived)

Contains Number of prospective students who are interested in and/or being recruited for an institution. The number of prospective students. This fact helps you to answer questions such as: How many prospective students are there?

Yield (Prospects to Applicants) (Derived)

Contains the percentage of prospective students (persons who have expressed interest) who have been converted to applicants (persons who have submitted admission applications). This fact helps you to answer questions such as:

What percent of the prospects submitted applications?

Student Admission Application Fact Table

The Student Admission Application fact table contains data on applicants and the associated academic institutions, academic careers, academic programs, plans, and sub-plans. It also contains data on the recruiting categories, regions, and the recruiters to which applicants are assigned. With this fact group, you can answer questions such as “How many applicants are there for a particular academic program?”

The granularity for this fact table is every application entry of an applicant for an academic career in an academic institution and the related academic program, plan, and sub-plan assigned to a particular recruiting category and a particular recruiter.

This table describes the facts in the Student Admission Application fact table:

Fact Name	Fact Description
Applicant Count (Derived)	Total number of applicants for a program. This fact helps you to answer questions such as: How many applicants are there?
Application Count (Derived)	Total number of applications received for a program. This fact helps you to answer questions such as: How many applications are there?
Transfer Count (Derived)	Total number of applications received for a program as transfer students from another institution or an external organization. This fact helps you to answer questions such as: How many people applied as transfer students?

Student Admission Applications Status Fact Table

The Student Admission Applications Status fact table contains information on the application status changes and their effective dates. Each status change is represented as a row in the fact table. With this fact group, you can answer questions such as “How many applicants were admitted for a particular academic program?”

The granularity for this fact table is every application status change entry, effective on a particular date, for a particular application

This table describes the facts in the Student Admission Application Status fact table:

Fact Name	Fact Description
Admission Rate (Derived)	Ratio between the total number of applicants and those who have been admitted. This fact helps you to answer questions such as: How much percent of applicants were admitted?
Enrollment Rate (Derived)	Ratio between the total number of applicants and those who have been matriculated and have enrolled in classes. This fact helps you to answer questions such as: How much percent of applicants were matriculated and enrolled in classes?
Offers of Admission Count (Derived)	Total number of applicants that have been offered admission. This fact helps you to answer questions such as: How many applicants were admitted?
Yield (Applicants to Admits) (Derived)	Percentage of applicants that have been admitted. This fact helps you to answer questions such as: How much percent of applicants were admitted?
Yield (Admits to Enrollees) (Derived)	Percentage of admitted applicants that have enrolled in classes. This fact helps you to answer questions such as: How much percent of admitted students enrolled in classes?

External Test Scores Fact Table

The External Test Scores fact table contains information on the external test scores of prospects and applicants. With this fact group, you can answer questions such as “What is the average SAT score of the prospects or applicants?”

The granularity for this fact table is every external test score entry of a prospect or applicant for a particular test and the related components taken on a particular date, obtained from a particular data source.

This table describes the facts in the External Test Scores fact table:

Fact Name	Fact Description
Test Score	Test score attained in the external test. This fact helps you to answer questions such as: What are the numerical scores of the prospects or applicants on a particular test?
Letter Score	Letter grade attained in the test, for example, A, B, or C. This fact helps you to answer questions such as: What are the letter scores of the prospects or applicants on a particular test?
Percentile	Percentile of the score attained in the test. This fact helps you to answer questions such as: What is the percentile of the prospects or applicants on a particular test?
Average Scores (Derived)	Average score on standardized tests, such as SAT, ACT, and so on. This fact helps you to answer questions such as: What is the average score of the prospects or applicants on a particular test?

External Academic Summary Fact Table

The External Academic Summary fact table contains data on the external academic information of the prospects and applicants. With this fact group, you can answer questions such as “What is the average GPA of the prospects or applicants in a particular external organization?”

The granularity for this fact table is every external academic summary entry of a prospect or applicant for a particular external academic career at a particular external organization, derived with a particular summary type.

This table describes the facts in the External Academic Summary fact table:

Fact Name	Fact Description
Total Units Attempted	Total number of course units that the prospect or applicant has attempted. This fact helps you to answer questions such as: How many course units did the prospects or applicants in a particular external organization attempt?
Total Units Completed	Total number of course units that the prospect or applicant has completed. This fact helps you to answer questions such as: How many course units did the prospects or applicants in a particular external organization complete?
Class Rank	Class rank of the prospect or applicant where that person has taken the external courses or academics. This fact helps you to answer questions such as: What is the class rank of the prospects or applicants in a particular external organization?
Class Size	Class size of the prospect or applicant where that person has taken the external courses or academics. What is the class size of the prospects or applicants in a particular external organization?
External GPA (Grade Point Average)	GPA attained by the prospect or applicant in the external courses or academics. This fact helps you to answer questions such as: What is the GPA of the prospects or applicants in a particular external organization?
Converted GPA	Existing GPA converted to the standards of the enrolled or admitted school or organization’s GPA grading system. This fact helps you to answer questions such as: What is the converted GPA of the prospects or applicants?
Percentile	Percentile attained in the external courses or academics. This fact helps you to answer questions such as: What is the percentile of the prospects or applicants in a particular external organization?
Average High School Rank (Derived)	Average high school rank attained during external academics. This fact helps you to answer questions such as: What is the average rank of the prospects or applicants in a particular external organization?

Student Records Mart

With Student Records mart analytics you can review and manage items such as enrollment and registration metrics, count of student and faculty by registered courses, available courses for catalog building and schedule building, graduation rates and student career fulfillment of requirements, student academic standing, and faculty and student profiles.

Enrollment reports include areas such as monitoring average class sizes, pre-requisites not being met, grade distributions, and graduation eligibility. Reports in this category include aggregated statistical reports with year-to-year comparisons in several subject areas.

With Student Records Mart you can answer questions such as:

What are the enrollment metrics for this term?
Can I get the Student Retention and Graduation rates year over year by Cohort, Gender and Ethnicity?
What is average GPA by Institution, Career and Program?
What is average time to graduate by Institution, Career and Program?
What classes are scheduled for this term?
Can I track and analyze the workload of the faculty?
What are the Class enrollment details?
What are the honors/awards details for the enrolled students?

Academic Program Activation and Management Business Process

Student Records Mart is related to the Academic Program Activation and Management business process. This business process includes Course Catalog, Class Scheduling, Student Career Term records and Enrollment business processes. These processes fulfill the institutions need to track course delivery, student participation through enrollments to those classes. The Academic Program activation and Management processes help manage class size, a student’s enrollment in a class and track the resulting grades from the class.

Student Records Mart Delivered Fact Tables

With Student Records mart, PeopleSoft provides the following fact tables:

Term Enrollment
Class Enrollment
Academic Program Detail
Academic Plan Summary
Class Instructor
Institution Summary

Term Enrollment Fact Table

The Term Enrollment fact table contains an individual student’s enrollment entry for a given term. With this fact group, you can answer questions such as:

What is average GPA by Institution, Career and Program?
What are the units enrolled, progressed, or earned by each student Institution, Career and Program?

The granularity for this fact table is an individual student’s enrollment entry for a given term.

This table describes the facts in the Term Enrollment fact table:

Fact Name	Fact Description
Current Grade Point Average	The current term’s student GPA for an academic career.
Cumulative GPA	Student’s cumulative GPA for an academic career.
Returning Flag	Set to 1 if the student had enrolled for the previous term, otherwise, defaults to 0.
Course Count	Number of courses for which the student was enrolled during that term.
Number of Credit Units	Number of credit units for which the student was enrolled during that term.
Number of Credit Hours	Number of credit hours for which the student was enrolled during that term.
Number of transfer units	Number of transfer units for which the student was enrolled during that term.
Class Rank	The class rank of the student for that term.
Grade Points	Number of grade points earned by the student during that term.
Units In Progress Toward GPA	Number of units in progress that count toward grade point average for the term. This includes classes that are not yet graded in the term.
Units in Progress Not Toward GPA	Number of credit hours in progress that do not count toward grade point average for the term. This includes classes that are not yet graded in the term
Units Passed Toward GPA	Number of credit hours passed that count toward grade point average for the term.
Units Passed Not Toward GPA	Number of credit hours passed that does not count toward grade point average for the term.
Unit Taken	Number of specific credit hours elected by a student for each unique section within a course.
Unit Taken Grade Point Average	Number of credit hours taken that count toward grade point average for the term.
Unit Taken No Grade Point Average	Number of credit hours taken that does not count toward grade point average for the term.
Units Taken For Progress	The sum of a student’s credit hours taken in a particular term that can be applied toward academic progress.
Unit Test Credit	Number of test transfers credit hours that have been accepted in the term.
Units From Other Credit	Number of other transfers credit hours that have been accepted in the term.
Current GPA	The current term’s student GPA for an academic career.
Units Audit	The total number of credit hours taken on an audit-grading basis for the term.
Total Cumulative Units	The cumulative total of credit hours passed and all transfer credit hours for a specific academic career.
Total Grade Points	A number representing the cumulative grade points earned.
Persistence Rate (Derived)	A measure of the percentage of students who re-enroll from term to term.
Student Full-time Equivalent (FTE) (Derived)	Measurement of enrollment derived by dividing total student credit hours for a term by some configurable amount, both for graduate and undergraduate students.

Class Enrollment Fact Table

The Class Enrollment fact table contains an individual student’s enrollment entry for a given term for a given class. With this fact group, you can answer questions such:

What are the enrollment metrics for this term?
What classes are scheduled for this term?
Which classes are taught by which instructor for this term?

The granularity for this fact table is an individual student’s enrollment entry for a given term for a given class.

This table describes the facts in the Class Enrollment fact table:

Fact Name	Fact Description
Number of Units Taken	Number of class units taken by the student.
Number of Units Earned	Number of class units earned by the student.
Number of Grade Points Earned	Number of grade points earned by the student for that class.
Grade Points Per Unit	A numeric value assigned to a particular grade. This value is multiplied by the number of units and is used to calculate the grade point average.
Number of Units Progressed	Number of class units progressed by the student. Progressed means the number of units that a student has progressed or earned in a term.
Number of Units Attempted	Number of class units attempted by the student.
Repeat Flag	Indicates if this is a repeat class for that student. (Yes or No)
Student Count (Derived)	Class grade earned by the student.
Enrollment Total (Derived)	Total number of students enrolled for a class.
Instructor Count (Derived)	Total number of Instructors for a term.
Course Count (Derived)	Total count of course by student. This is the count of courses taken by a student grouped by various dimensions like term, etc.
Class Size (Derived)	Total number of students enrolled in a class.
Instructor to Student Ratio (Derived)	Ratio of instructors to students for a program, career, and so on. This measurement is only for the primary instructor to student ratio. However, you can derive this measurement for all other faculties (including non-primary instructor) by combining Class Instructor fact and Class Enrollment fact. A class may have a primary instructor and a teaching assistant (TA). We are referring to the former for this fact.

Academic Program Detail Fact Table

The Academic Program Detail fact table contains an individual program action entry for a particular student for a given academic program. With this fact group, you can answer questions such as what are the different actions performed for a student for a Program?

The granularity for this fact table is an individual program action entry for a particular student for a given academic program.

This table describes the fact in the Academic Program Detail fact table:

Fact Name	Fact Description
Action Count	Row count. This will always be set to 1.

Academic Plan Summary Fact Table

The Academic Plan Summary fact table contains an individual student's summary entry for a given academic plan and related academic program. Each row has the most current information about an individual student and the particular academic plan with which he is associated. With this fact group, you can answer questions such as:

What is average time to graduate by Institution, Career and Program?
What are the degrees awarded for student, Institution, Career and Program?

The granularity for this fact table is an individual student’s summary entry for a given academic plan and related academic program.

This table describes the facts in the Academic Plan Summary fact table:

Fact Name	Fact Description
Degree GPA	Student’s GPA for the program or plan.
Student Rank	Student’s rank for the program or plan.
Degree Status	Status of the degree. (Awarded, Revoked)
Completion Count (Derived)	Total number of students that completed a program.
Graduation Rate (Derived)	Rate of the students of a particular cohort who graduated or completed the program within a certain number of years. Graduation rate is at a program level; so distinct student count should be taken. This means when this metric is derived in the reporting tool it should be defined with a count of distinct students and not total students.
Time Taken to Graduate (Derived)	Total time taken from initial enrollment to degree conferral, usually measured in 4, 5, or 6 year increments, depending on the student cohort.

Class Instructor Fact Table

The Class Instructor fact table contains information about an individual class scheduled for a particular term. With this fact group, you can answer questions such as:

What classes are scheduled for this term?
Can I track and analyze the workload of the faculty?

The granularity for this fact table is an individual class scheduled for a particular term.

This table describes the facts in the Class Instructor fact table:

Fact Name	Fact Description
Assignment Percentage	This is the assignment percentage of the instructor.
Instructor Load Percentage	This is the percentage of the weekly instructor load
Row Count	This is a dummy rowcount number which is always set to 1 and can be used for deriving various metrics.
Week Workload Hour Count	This is the weekly workload hours of the instructor.

Institution Summary Fact Table

The Institution Summary fact table is an aggregated fact that contains calculated metrics for every academic plan, admit term, admit type, student gender, ethnicity, and student cohort that has a snapshot date. With this fact group, you can answer questions such as:

Can I get the Student Retention and Graduation rates year over year by Cohort, Gender and Ethnicity?
What is average time to graduate by Institution, Career and Program?

The granularity for this fact table is each row, which has calculated metrics for every academic program, admit term, admit type, student gender, ethnicity, and student cohort.

This table describes the facts in the Institution Summary fact table:

Fact Name	Fact Description
Total Head Count	Total count of students for a given admit term.
Full Time Head Count	Number of full-time students for a given admit term.
Part Time Head Count	Number of part-time students for a given admit term.
1 Year Retention Count	Number of students enrolling from term to term in first year. The First year of enrollment for a student in the Institution, typically in the Fall. Second year would be the 2nd fall and so on.
2 Year Retention Count	Number of students enrolling from term to term in second year.
3 Year Retention Count	Number of students enrolling from term to term in third year.
4 Year Retention Count	Number of students enrolling from term to term in fourth year.
5 Year Retention Count	Number of students enrolling from term to term in fifth year.
6 Year Retention Count	Number of students enrolling from term to term in sixth year.
7 Year Retention Count	Number of students enrolling from term to term in seventh year.
3 Year Graduation Count	Number of students graduating after three years of a program.
4 Year Graduation Count	Number of students graduating after four years of program.
5 Year Graduation Count	Number of students graduating after five years of program.
6 Year Graduation Count	Number of students graduating after six years of program.
7 Year Graduation Count	Number of students graduating after seven years of program.

Student Financial Services Mart

The Student Financial Services mart is comprised of two subject areas: Student Financial Services and Financial Aid.

Student Financial Services is used by institutions to manage student receivables, billing, and collections, as well as the transactions that are supported by reports, such as Receipts Per Day and Refund Customers Trial Balance by Students. This subject area of the Campus Solutions Warehouse links student financial information to dimensions such as Person, Account, and Product, enabling the analysis of student financial aid information from various viewpoints.

The Financial Aid subject area automates federal and institutional aid processing and helps you to manage student financial aid activity for students and applicants. Reports for financial aid application provide details such as Year to Date Disbursement, Overawards, and Pell Originations. This subject area links financial aid information to dimensions such as Person, Account and Product, enabling you to perform analysis of aid information from various viewpoints.

With Student Financial Services mart you can answer questions such as:

What is the total amount of bills for a student or an external organization?
What is the total amount of tuition charged for a particular course?

Award Business Process

Student Financial Services mart is related to the Award business process. The Award Business Process fulfills an institutions need to track and report student’s payments for classes taken as well as financial aid awards given to students for an academic year.

Student Financial Services Mart Delivered Fact Tables

With Student Financial Services mart, PeopleSoft provides the following fact tables:

Bill Summary Snapshot fact
Pending Payments fact
Student Financials Transactions fact
Award Disbursement fact
Award Summary fact

Bill Summary Snapshot Fact Table

The Bill Summary Snapshot fact table contains the total billing information for a student or external organization for a snapshot period. This fact table is an accumulative snapshot. With this fact group, you can answer questions such as “What is the total amount billed and paid at this snapshot period?”

The granularity for this fact table is the total bill for a student or external organization for a snapshot period.

This table describes the facts in the Bill Summary Snapshot fact table:

Fact Name	Fact Description
Total Billed Amount	Total amount billed to a student or external organization. Use this fact to answer questions such as: What is the total amount already billed for a student up to this snapshot period?
Total Paid Amount	Total amount of payments made by a student or external organization. Use this fact to answer questions such as: What is the total amount already paid by a student up to this snapshot period?
Overdue Bill Count (derived)	Number of bills unpaid. Use this fact to answer questions such as: How many bills a student has not paid in full?
Late Payment Count (derived)	Number of bills paid late. Use this fact to answer questions such as: How many bills were paid past the due date?

Pending Payments Fact Table

The Pending Payments fact table contains information about payments, charges, and the balance for payments. With this fact group, you can answer questions such as “What is the amount of receivable for a student or external organization?”

The granularity for this fact table is payments, charges, and balance incurred by a student or external organization.

This table describes the facts in the Pending Payments fact table:

Fact Name	Fact Description
Total Payments	Total amount of payments made by a student or external organization. Use this fact to answer questions such as: What is the total amount of payments made by a student or external organization?
Total Charges	Total amount of charges to a student or external organization. Use this fact to answer questions such as: What is the total amount of charges made by a student or external organization?
Payment Balance (derived)	Difference between the total amount of payments and charges. Use this fact to answer questions such as: What is the total amount of receivables for a student or external organization?

Student Financial Transactions Fact Table

The Student Financial Transactions fact table contains information about student financial transactions. With this fact group, you can answer questions such as “What is the total amount of tuition charged for a particular course?”

The granularity for this fact table is an individual financial transaction made by a student or external organization.

This table describes the facts in the Student Financial Transactions fact table:

Fact Name	Fact Description
Transaction Amount	Amount associated with a student financial transaction. Use this fact to answer questions such as: What is the amount of tuition charged for English subjects?
Paid Amount	Amount of payment applied to a charge transaction amount. Use this fact to answer questions such as: What is the amount paid for English subjects?
Encumbered Amount	Encumbered amount associated with a student financial payment transaction. Use this fact to answer questions such as: What is the encumbered amount for all payments for English subjects?

Award Disbursement Fact Table

The Award Disbursement fact table contains term-based detail information associated with a student’s awards, such as amount, status, disbursement, aid type, and so on. With this fact group, you can answer questions such as “How many awards were disbursed for a particular term?”

The granularity for this fact table is an individual award disbursement by institution to student for an aid year.

This table describes the facts in the Award Disbursement fact table:

Fact Name	Fact Description
Award Amount	A number representing the amount of a financial aid award to a student. This can represent the offered, disbursed, accepted or authorized amount, depending on the award status. Use this fact to answer questions such as: What is the total amount of aid awarded to a student for a particular term?
Offer Amount (Derived)	A number representing the dollar amount of a financial aid award offered to a student. Use this fact to answer questions such as: What is the total amount of aid offered to a student for a particular term?
Accept Amount (Derived)	A number representing the dollar amount of a financial aid award accepted by a student. Use this fact to answer questions such as: What is the total amount of aid accepted by a student for a particular term?
Disbursed Amount (Derived)	A number representing the total dollar amount of a financial aid award that was disbursed to a student. Use this fact to answer questions such as: What is the total amount of aid disbursed to a particular student?
Authorized Amount (Derived)	A number representing the dollar amount of a financial aid award authorized to be disbursed to a student. Use this fact to answer questions such as: What is the total amount of aid authorized for a student?

Award Summary Fact Table

The Award Summary fact table contains detail information associated with a student’s awards, such as amount, status, disbursement, aid type, and so on. With this fact group, you can answer questions such as ” What is the total amount of aid disbursed by an institution?”

The granularity for this fact table is total awards made to a student by an institution for an aid year.

This table describes the facts in the Award Summary fact table:

Fact Name	Fact Description
Award Amount	A number representing the amount of a financial aid award to a student. This can represent the offered, disbursed, accepted or authorized amount, depending on the award status. Use this fact to answer questions such as: What is the total amount of aid awarded for an aid year?
Award Count	A number representing the number of awards offered, disbursed, accepted or authorized to a student. This can represent the offered, disbursed, accepted or authorized counts depending on the award status. Use this fact to answer questions such as: How many awards were offered to a student?

Fact Name

Fact Description

Award Amount

A number representing the amount of a financial aid award to a student. This can represent the offered, disbursed, accepted or authorized amount, depending on the award status. Use this fact to answer questions such as:

What is the total amount of aid awarded for an aid year?

Award Count

A number representing the number of awards offered, disbursed, accepted or authorized to a student. This can represent the offered, disbursed, accepted or authorized counts depending on the award status. Use this fact to answer questions such as:

How many awards were offered to a student?