Student Records Data and Reporting

Report Field Name: What is contained in this field is represented by one of three types of values:

• Actual field name: a fixed field or value in the database

• Derived: a value that is calculated or attained through a combination of other fields – it is not a fixed value in the database. Examples include:

  • Advisor Campus Email: value is attained by performing a crosswalk lookup using the Student Advisor table and matching the EmplID of the Advisor to the EmplID in the Email Address table.

  • Academic Level: value is attained by performing a lookup using the Academic Level Beginning of Term field on the Student Career Term table.

• n/a: This is a conceptual or contextual field. A fixed field or value does not exist in the database per se; however, the presence of multiples of fixed values represent the conceptual representation of this field. Examples include:

  • Double Major: a singular Major (as denoted by the student’s Academic Plan) is a fixed field that exists in the database. However, if the student is pursuing multiple majors simultaneously, there is no fixed field in the database that denotes that the student is a double major candidate, but in reality, because there is more than one major associated with the student, they are defined as a double major.

  • Dual Degree: a singular Degree (as denoted by the Degree field on the student’s Academic Plan table) is a fixed field that exists in the database. However, if the student is pursuing multiple degrees simultaneously, there is no fixed field in the database that denotes that the student is a dual degree candidate, but in reality, because there is more than one degree associated with the student, they are considered a dual degree student.