Skip to main content

Field Reference

The columns included in each Static Report, listed by report. Use it to see what data a report contains before you run it, or to find which report has the field you're after.

External Request Status

  • StudentLastName

  • StudentFirstName

  • StudentID

  • StudentEmail

  • RecommenderFirstName

  • RecommenderLastName

  • RecommenderEmail

  • RequestTemplateName

  • DateSent

  • Received

General Application Questions

  • Section

  • Question Text

  • Required/Optional

  • Question Type

  • Options/Columns

Qualified Students

  • Scholarship Title

  • Last Name

  • First Name

  • Email

  • Phone

  • Student Id

  • Application Status

  • Notes

  • Score 1

  • Score 2

Reviewer Assignment and Progress Report

  • Reviewer Last Name

  • Reviewer First Name

  • Reviewer Email

  • Group Name

  • Panel #

  • Number Of Applicants Assigned

  • Number Of Reviews Complete

  • Percent Complete

  • Score 1

  • Score 2

Reviewer Score Detail by Group

  • Applicant Last Name

  • Applicant First Name

  • Applicant Email

  • Applicant Student ID

  • Reviewer Last Name

  • Reviewer First Name

  • Reviewer Email

  • Reviewer Notes

  • Review Status

  • Personal Statements

  • EFC

  • College GPA

  • Total Points

  • Total Possible Score

  • Percent Score

Reviewer Scores by Applicant

  • ReviewerLastName

  • ReviewerFirstName

  • ReviewerEmail

  • StudentLastName

  • StudentFirstName

  • StudentId

  • GroupName

  • PossibleScore

  • GivenScore

  • PercentageScore

  • ReviewStatus

  • ReviewGroupId

  • ApplicantUserId

  • Score1

  • Score2

Scholarship Details and Status

  • ScholarshipName

  • Description

  • InternalNotes

  • FundID

  • Department

  • ReviewGroup

  • ApplicationStartDate

  • ApplicationEndDate

  • PublishStatus

  • NumberOfAwards

  • TotalAppliedStudents

  • AwardedStudents

  • DeniedStudents

  • AwardsRemaining

  • PaymentsPerAward

  • AmountAvailableToAward

  • AmountAwarded

  • RemainingToAward

  • Donors

  • IsHidden

  • IsActive

Scholarships Awarded

  • ScholarshipTitle

  • FundId

  • ApplicantLastName

  • ApplicantFirstName

  • ApplicantEmail

  • StudentId

  • AmountAwarded

  • AwardDate

  • Notes

  • CalculatedScore

Scholarships with Qualifications and Additional Requirements

  • ScholarshipTitle

  • Type

  • QualificationGroup

  • QualificationTitle

  • QuestionText

  • Operator

  • AcceptedAnswers

  • ScholarshipDescription

  • InternalNotes

  • FundId

Score Card Assignment

  • Department

  • Scholarship

  • ScoreCard

  • MaxScore

Special Funds Application Tracking

  • Scholarship

  • FirstName

  • LastName

  • Email

  • Student ID

  • SFA Submission Status

Student Answers

  • LastName [Profile]

  • FirstName [Profile]

  • Email [Profile]

  • StudentId [Profile]

  • Phone Number [Profile]

  • RegisterDate [Profile]

  • LastLogin [Profile]

  • [Site-Specific Sections] Complete

  • General Application Submitted

Submitted Not Awarded

  • Email

  • FirstName

  • LastName

  • StudentId

Texting History

This report appears only for clients with the texting add-on.

  • PhoneNumber

  • Text

  • Date

  • RecipientFirstName

  • RecipientLastName

  • Email

Did this answer your question?