GPA of student up to and including the academic term

Academic term in which the student was first enrolled/registered at current student level

Full time/Part time status of the student for the term

'Full-time' - Student meets the minimum requirements set by the institution to be considered a full-time student.

'Part-time' - Student meets the minimum requirements set by the institution to be considered a part-time student.

Home campus associated with the student

If institution does not associate a home campus for students, set value of field to null. If value is null, the degree program campus will be the default campus associated with the student.

If record is applicable for IPEDS reporting, value = 1, else 0

If student is enrolled, but not seeking an academic degree or award, value = 1, else 0

Default value if null: 0/false

Unique person identifier for student

Date source record inserted or modified

Residency of student for tuition and reporting purposes

If institution does not use residency to determine tuition rates or if different tuition rates are not offered, use default value of In State.

'In District' - Student resides in the same district as the institution as of the designated 'TermCode'.

'In State' - As of the designated 'TermCode', the student resides in a different district than the institution within the same state.

'Out of State' - As of the designated 'TermCode', the student resides in a different state than the institution within the same country.

'Out of US' - Student resides outside of the US as of the designated 'TermCode'.

Level of student

'Undergraduate' - Student is pursuing a bachelor's/associate degree program or a vocational/technical program below the baccalaureate.

'Masters' - Student is pursuing a post-bachelor's level program requiring between 1 and 2 full time equivalent academic years of work.

'Doctorate' - Student is pursuing a post-master's level program requiring the preparation of an original dissertation/project which demonstrates substantial artistic or scholarly achievement.

'Professional Practice Doctorate' - Student is pursuing a post-master's level program to demonstrate the knowledge and skills required to be recognized for professional practice.

'Continuing Education' - Student is pursuing an additional learning that is not aligned with a degree outcome.

'Other' - Student level is not described by one of the above.

Type of student

'High School' - Student is earning college credits before completing high school. If the student returns to the college after completing high school, they should be considered 'First Time'.

'First Time' - A student who has no prior postsecondary experience attending any institution at the undergraduate level. This includes students who entered with advanced standing (college credits or recognized postsecondary credential earned before graduation from high school). For systems/coordinated institutions, a student is only considered 'First Time' if they did not attend another institution within the same coordinated system prior to applying at your institution.

'Transfer' - Transfer-in student at the institution for the first time that attended another postsecondary institution at the same level. These students are transfers regardless of whether they are entering with or without credits. For systems/coordinated institutions, a student is a transfer if they applied to your institution after attending another institution within the same coordinated system.

'Continuing' - A 'Continuing' or returning value describes a student that: 1) Was previously a 'First Time' student at the institution. 2) Is returning to the institution after having left for a period. 3) Did not transfer to another institution during their time away.

'Re-admit' - A student that: 1) Was previously a 'First Time' student at the institution. 2) Is returning to the institution after having left for a period. 3) Transferred to another institution during their time away.

'Visiting' - A student that is enrolled at another institution that plans to take courses at your institution but it not seeking a degree/certificate from your institution.

'Unknown' - Student can’t be described by one of the above.

Indicates study abroad status of student

'Not Study Abroad' - Student is not studying abroad as of the designated 'TermCode'.

'Study Abroad - Home Institution' - Student is studying abroad as of the designated 'TermCode' and the 'home' institution serves as an administrative record for enrollment.

'Study Abroad - Host Institution' - Student is studying abroad as of the designated 'TermCode' and the 'host' institution serves as an administrative record for enrollment.

Academic term code

GPA of student for the academic term

Campus associated with the student

Renamed to homeCampus. Remap the campus field to the homeCampus field, if applicable.
If homeCampus value is null, the campus associated with the student is based on the student's degree program.

College code associated with student

Removed. College is associated with the student based on the student's degree program.

Status of student

Removed. New logic required in the SQL query to relocate Study Abroad values to the new field studyAbroadStatus. If a record exists in the Student entity, the student status, by default, is considered Active.