Student Data Model

Our student data model fields are listed below. This data is encapsulated by the Student class. This data is populated through the Web Service Data Provider system. We have future plans for providing ways to populate this data through local database tables and a file import system.

Identifiers

• studentId - Unique student ID. Digits only, must be unique.
• username - Unique username. String.

Basic Demographics

• firstName - String
• middleName - String
• lastName - String
• preferredName - Preferred first name, populated if different from first name. String
• confidential - 'Y' if confidentiality flag has been set with the Registrar, 'N' otherwise. The flag being set indicates that the student's data should be treated their data with extra care. Do not discuss nor confirm the student's existence over the phone.

Academic Info

• campus - String. 'main_campus' or 'distance_ed'
• level - String Values: 'ugrad', 'grad', 'grad2', 'doctoral', 'postdoc'
• majors - Array of students majors. Each element contains a 'major_code' and 'major_desc' field.
• gpa - floating point. Student's latest cummulative GPA
• gradDate - Scheduled date of graduation, if any (can be empty). Format: 5/15/2017
• holds - Array of hold reasons. Each element contains a hold_desc field.
• creditHours - Integer. Student's latest number of completed course credit hours.

Type Flags

• isStaff - Integer. 1 if the student has any employment records (i.e. is a faculty/staff member). (NB: Also includes student employees). 0 otherwise.
• isStudent - Integer. 1 if the student is currently an enrolled student (NB: Also includes faculty/staff who are taking classes). 0 otherwise

These flags are not mutually exclusive. We usually expect at least one of them to be true, but both can also be true concurrently.