Introduction

Below are the entites and elements the SIS can contribute to the UCDM as CSV. Please see Unizin's resource site for details on the CSV format and Frequently Asked Questions regarding SIS.

Entities

1. Academic Career
2. Academic Degree
3. Academic Major
4. Academic Major Specialization
5. Academic Minor
6. Academic Organization
7. Academic Program
8. Academic Session
9. Academic Term
10. Admission Test Score
11. Campus
12. Course Grade
13. Course Offering
14. Course Section
15. Course Section Enrollment
16. Facility
17. Institutional Affiliation
18. Person
19. Person - Academic Degree
20. Person - Academic Major - Academic Term
21. Person - Academic Major Specialization - Academic Term
22. Person - Academic Minor - Academic Term
23. Person - Academic Term
24. Person Email
25. Person Phone Number
26. Room

Academic Career

This entity is strongly recommended.

Entity filename: academic_career.csv.

A grouping of academic programs for statistical purposes. An Academic career exists for each school/college by level of program offered. An Academic career is the parent to an Academic program.

Code (Header)	Description	Is required	Is foreign key	Datatype
sis_int_id	The key used within the SIS to identify this Academic Career.	Yes	No	text
sis_ext_id	The global key generated by this SIS to identify this Academic Career, for use by external tools that are provisioned or launched from the SIS.	No	No	text
code	The code that uniquely identifies an Academic career at the institution.	No	No	text
description	The description of the Academic career at the Institution.	No	No	text

top

Academic Degree

This entity is recommended.

Entity filename: academic_degree.csv.

An Academic degree that can be earned by a student at an institution.

Code (Header)	Description	Is required	Is foreign key	Datatype
sis_int_id	The key used within the SIS to identify this Academic Degree.	Yes	No	text
sis_ext_id	The global key generated by this SIS to identify this Academic Degree, for use by external tools that are provisioned or launched from the SIS.	No	No	text
name	The name of the Academic degree that is earned by the student.	No	No	text
educational_level	The educational level of the Academic degree earned at the Institution. (option set)	No	No	text

top

Academic Major

This entity is recommended.

Entity filename: academic_major.csv.

A major area of study.

Code (Header)	Description	Is required	Is foreign key	Datatype
sis_int_id	The key used within the SIS to identify this Academic Major.	Yes	No	text
sis_ext_id	The global key generated by this SIS to identify this Academic Major, for use by external tools that are provisioned or launched from the SIS.	No	No	text
academic_program_id	The foreign key to the Academic program to which this Academic major belongs. See Academic Program.	Yes	Yes	integer
cip_code2k	The Classification of Instructional Program (CIP) code for the Academic major.	No	No	text
code	The institutional code that uniquely identifies an Academic major.	No	No	text
description	The institutional description of the Academic major.	No	No	text

top

Academic Major Specialization

This entity is recommended.

Entity filename: academic_major_specialization.csv.

A program specialization in a major area of study.

Code (Header)	Description	Is required	Is foreign key	Datatype
sis_int_id	The key used within the SIS to identify this Academic Major Specialization.	Yes	No	text
sis_ext_id	The global key generated by this SIS to identify this Academic Major Specialization, for use by external tools that are provisioned or launched from the SIS.	No	No	text
academic_major_id	The foreign key to the Academic major to which this Academic major specialization belongs. See Academic Major.	Yes	Yes	integer
cip_code2k	The Classification of Instructional Program (CIP) code for the Academic major specialization.	No	No	text
code	The institutional code that uniquely identifies an Academic major specialization.	No	No	text
description	The institutional description of the Academic major specialization.	No	No	text

top

Academic Minor

This entity is recommended.

Entity filename: academic_minor.csv.

A minor area of study.

Code (Header)	Description	Is required	Is foreign key	Datatype
sis_int_id	The key used within the SIS to identify this Academic Minor.	Yes	No	text
sis_ext_id	The global key generated by this SIS to identify this Academic Minor, for use by external tools that are provisioned or launched from the SIS.	No	No	text
academic_program_id	The foreign key to the Academic program to which this Academic minor belongs. See Academic Program.	Yes	Yes	integer
cip_code2k	The Classification of Instructional Program (CIP) code for the Academic minor.	No	No	text
code	The institutional code that uniquely identifies an Academic minor.	No	No	text
description	The institutional description of the Academic minor.	No	No	text

top

Academic Organization

This entity is strongly recommended.

Entity filename: academic_organization.csv.

An Academic organization is a School, Program, College, or Department responsible for delivering instruction. A particular Academic organization is always unique to a campus. However, Academic organizations across different campuses may share the same Organization Code. For example, there may exist a Department of Sociology at multiple campuses of a University system — each instance can be uniquely identified, but all may share the same academic organization code.

Code (Header)	Description	Is required	Is foreign key	Datatype
sis_int_id	The key used within the SIS to identify this Academic Organization.	Yes	No	text
sis_ext_id	The global key generated by this SIS to identify this Academic Organization, for use by external tools that are provisioned or launched from the SIS.	No	No	text
campus_id	The foreign key to the Campus to which this Academic organization belongs. See Campus.	Yes	Yes	integer
parent_academic_organization_id	The foreign key to the parent Academic organization to which this Academic organization belongs. See Academic Organization.	No	Yes	integer
institutional_code	The Institution’s code for the Academic organization. The intention is to capture the value used as a formal shorthand used in, for example, the schedule of classes to refer to the Academic organization (e.g., “CAS” for “College of Arts & Sciences”). This value need not be unique across the Campuses of an Institution. In fact, it's more likely that the same code is used to refer to the same kind of Academic organization across institutions (e.g., the "Department of Communication" at multiple campuses will have the same Code value).	No	No	text
name	The human-readable name of the Academic organization.	No	No	text

top

Academic Program

This entity is recommended.

Entity filename: academic_program.csv.

An administrative area within the Institution to which the application is admitted and from which a student graduates.

Code (Header)	Description	Is required	Is foreign key	Datatype
sis_int_id	The key used within the SIS to identify this Academic Program.	Yes	No	text
sis_ext_id	The global key generated by this SIS to identify this Academic Program, for use by external tools that are provisioned or launched from the SIS.	No	No	text
academic_career_id	The foreign key to the Academic career to which this Academic program belongs. See Academic Career.	Yes	Yes	integer
educational_level	A code representing the educational level of the degree that can be earned in this academic program. (option set)	No	No	text
code	The institutional code that uniquely identifies an Academic major.	No	No	text
description	The institutional description of the Academic program.	No	No	text

top

Academic Session

This entity is required.

Entity filename: academic_session.csv.

An administrative unit that defines an actual instructional period during a term. Every Academic term is comprised of one or more Sessions. A Session is always unique to an Academic term and will have many Course offerings.

Code (Header)	Description	Is required	Is foreign key	Datatype
sis_int_id	The key used within the SIS to identify this Academic Session.	Yes	No	text
sis_ext_id	The global key generated by this SIS to identify this Academic Session, for use by external tools that are provisioned or launched from the SIS.	No	No	text
academic_term_id	The foreign key to the Academic term to which this Academic session belongs. See Academic Term.	Yes	Yes	integer
name	The name of the Academic session. The value is typically intended to be human-readable ("First 8-week") and, in concert with the Academic term name, fully communicate the instructional period during which a Course offering is offered.	No	No	text
instruction_begin_date	The beginning of instruction for Course sections in the Session.	No	No	date
instruction_end_date	The end of instruction for Course sections in the Sessions.	No	No	date
course_materials_bill_after_date	The date after which fee-based course materials can be billed to the institution	No	No	date

top

Academic Term

This entity is required.

Entity filename: academic_term.csv.

A calendar session in which classes are instructed.

Code (Header)	Description	Is required	Is foreign key	Datatype
sis_int_id	The key used within the SIS to identify this Academic Term.	Yes	No	text
sis_ext_id	The global key generated by this SIS to identify this Academic Term, for use by external tools that are provisioned or launched from the SIS.	No	No	text
name	The human readable name for the academic term.	No	No	text
term_type	The type of Academic term. (option set)	No	No	text
term_year	The year during which the Academic term is scheduled (e.g., "2019").	No	No	integer
term_begin_date	The date and time when the academic term formally begins.	No	No	date
term_end_date	The date and time when the academic term formally ends.	No	No	date

top

Admission Test Score

This entity is recommended.

Entity filename: admission_test_score.csv.

An individual Person's score on an admissions test, whether standardized or institutionally-specific.

Code (Header)	Description	Is required	Is foreign key	Datatype
sis_int_id	The key used within the SIS to identify this Admission Test Score.	Yes	No	text
sis_ext_id	The global key generated by this SIS to identify this Admission Test Score, for use by external tools that are provisioned or launched from the SIS.	No	No	text
person_id	The foreign key to the Person to whom this Admission test score belongs. See Person.	Yes	Yes	integer
admission_test_type	The type of admissions test for which this is a score. (option set)	No	No	text
admission_test_date	The date of the test sitting from which this score was generated.	No	No	date
standardized_test	The name of the Standardized test for which this is a score. (option set)	No	No	text
standardized_test_version	The version of the Standardized test for which this is a score. (option set)	No	No	text
standardized_test_component	The name of the Standardized test component for which this is a score. (option set)	No	No	text
institutional_test	The name of the Institutional test for which this is a score.	No	No	text
institutional_test_version	The version of the Institutional test for which this is a score.	No	No	text
institutional_test_component	The name of the Institutional test component for which this is a score.	No	No	text
score_type	The type of score for which we have a value. (option set)	No	No	text
score	The score value.	No	No	decimal

top

Campus

This entity is strongly recommended.

Entity filename: campus.csv.

The collection of departments, colleges, schools, and buildings that belong to a particular institution. All Universities have at least one campus. Some Universities are systems with multiple Campuses. These may include "virtual campuses" that represent online programs, which is common to many Unizin Members.

Code (Header)	Description	Is required	Is foreign key	Datatype
sis_int_id	The key used within the SIS to identify this Campus.	Yes	No	text
sis_ext_id	The global key generated by this SIS to identify this Campus, for use by external tools that are provisioned or launched from the SIS.	No	No	text
name	The full name of the Campus in the Institution's system.	No	No	text
abbreviation	The abbreviation for the campus name. The intent is to capture the shorthand used in schedule of classes and other administative artifacts to refer to the campus.	No	No	text

top

Course Grade

This entity is strongly recommended.

Entity filename: course_grade.csv.

The grade that a learner receives as part of their participation in a given Course section enrollment.

Code (Header)	Description	Is required	Is foreign key	Datatype
person_id	The Person to whom this Course grade is given. See Person.	Yes	Yes	integer
course_section_id	The Course section for which the Course grade is given. See Course Section.	Yes	Yes	integer
grade_inputted_by_instructor	A code representing the grade given by an instructor to a student for a Course offering. (option set)	No	No	text
grade_on_official_transcript	The official grade that appears on a student’s transcript which can be the translated value of Course Grade Instructor Input as defined by school/college grading policy or, in the case of transfer credit, the articulated Course grade to distinguish the type of credit earned. (option set)	No	No	text
grade_points_per_credit	The number of points earned for each credit, unit, or hour in a course section. This value is multiplied by the number of credits, units, or hours earned and, most frequently, is used to calculate the Grade Point Average.	No	No	decimal
grade_points	The number of grade points earned in a course section. This is usually computed by multiplying the number of Grade points per credit by the number of Credits earned (on the Course section enrollment), yielding Grade points earned in the Course offering.	No	No	decimal
is_course_grade_in_gpa	Indicates if the grade is included in the system calculated Grade Point Average.	No	No	boolean
gpa_cumulative_excluding_course_grade	The student's cumulative grade point average, excluding this Course offering, at the end of the Academic term in which this Course offering was taken by the student.	No	No	decimal
gpa_current_excluding_course_grade	The student's grade point average, excluding this Course offering, for the Academic term in which this Course offering was taken by the student.	No	No	decimal
grading_basis	The valid grading pattern for a student’s enrollment in an elected Course section. This value may vary by enrollment for students in the same Course Section. (option set)	No	No	text

top

Course Offering

This entity is required.

Entity filename: course_offering.csv.

An institutional offering of organized subject matter and learner activities chosen by learners in an academic term.

Code (Header)	Description	Is required	Is foreign key	Datatype
sis_int_id	The key used within the SIS to identify this Course Offering.	Yes	No	text
sis_ext_id	The global key generated by this SIS to identify this Course Offering, for use by external tools that are provisioned or launched from the SIS.	No	No	text
lms_ext_id	A global key generated by the LMS used match records between the SIS and LMS. See the LMS's Course Offering Entity .	No	No	text
campus_id	The foreign key to the Campus to which this Course offering belongs. See Campus.	No	Yes	integer
academic_session_id	The foreign key to the Academic session to which this Course offering belongs. See Academic Session.	No	Yes	integer
academic_career_id	The foreign key to the Academic career for which this Course offering is primarily offered (note: the Course offering may still be available to other Academic careers at the institution; what is required here is the primary Academic career for which this Course offering is offered). See Academic Career.	No	Yes	integer
cip_code2k	A code representing the Classification of Instructional Program for the Course offering.	No	No	text
subject	The alphabetic abbreviation of the academic department or discipline offering the course. It is one part of the total course Id number. E.g., "BIO" in "BIO 101.”	No	No	text
number	The official reference number portion of a course Id. This number normally designates the level of the course as well as the level of the individual expected to enroll in the course. E.g. "101" in "BIO 101. This is sometimes called the catalog number.	No	No	text
title	The title of the Course Offering.	No	No	text
description	The Course Offering description.	No	No	text
status	The workflow state of the Course offering, usually in relation to its availability for teaching and learning. (option set)	No	No	text
available_credits	Measured in Carnegie units, the amount of credit available to a student who successfully meets the objectives of the Course Offering.	No	No	decimal
multiple_meeting_patterns	Indicates whether the class has multiple meeting patterns.	No	No	boolean
start_date	The date and time of the first Course offering meeting, which may be different from the first Course section meeting. Note: If more than one meeting pattern exists, the first meeting pattern will be chosen.	No	No	date
end_date	The date and time of the last Course offering meeting, which may be different from the last Course section meeting. Note: If more than one meeting pattern exists, the first meeting pattern will be chosen.	No	No	date

top

Course Section

This entity is required.

Entity filename: course_section.csv.

An administrative and instructional sub-organization of a Course offering. Instructors may be assigned to one or more sections of a particular Course offering.

Code (Header)	Description	Is required	Is foreign key	Datatype
sis_int_id	The key used within the SIS to identify this Course Section.	Yes	No	text
sis_ext_id	The global key generated by this SIS to identify this Course Section, for use by external tools that are provisioned or launched from the SIS.	No	No	text
lms_ext_id	A global key generated by the LMS used match records between the SIS and LMS. See the LMS's Course Section Entity .	No	No	text
course_offering_id	The course offering to which this Course section belongs. See Course Offering.	Yes	Yes	integer
academic_organization_id	The foreign key to the Academic organization to which this Course section belongs. See Academic Organization.	No	Yes	integer
section_number	The unique number of a particular Course section.	No	No	text
class_number	A number that uniquely identifies the Course section within an Academic term. This may or may not be the same as the SIS Internal Course section identifier.	No	No	text
type	The type of instruction delivered in this section. Institutions may refer to a section type as a "component" of a Course offering. (option set)	No	No	text
combined_section_id	The unique identifier given to each Course section in a group of Course sections that have been combined on any basis.	No	No	text
combined_section_basis	Indicates the primary basis for combining sections together. (option set)	No	No	text
is_combined_section_parent	Indicates whether this Course section, in a set of combined Course sections, is the Parent Course section.This is only meaningful if the Course section is part of a combined set of Course sections.	No	No	boolean
is_honors	Indicates whether the Course section is considered an honors Course section.	No	No	boolean
is_graded	Indicates whether the Course section is the graded Course section, if multiple Course sections are available to the student for this Course offering.	No	No	boolean
delivery_mode	The delivery mode for the instruction given in this Course Section. (option set)	No	No	text
max_enrollment	Maximum number of students who can be enrolled in the Course Section.	No	No	integer

top

Course Section Enrollment

This entity is required.

Entity filename: course_section_enrollment.csv.

The association of a Person to a Course section, usually defined by a particular role.

Code (Header)	Description	Is required	Is foreign key	Datatype
person_id	The Person to whom this Course section enrollment applies. See Person.	Yes	Yes	integer
course_section_id	The foreign key to the Course section to which this Course section enrollment belongs. See Course Section.	Yes	Yes	integer
role	The role of the Person in the Section, as defined by a UCDM option set. (option set)	Yes	No	text
role_status	The status of the Person in their role as a member of this Course section. (option set)	Yes	No	text
entry_date	The timestamp when the Person started this role in the Course section.	No	No	timestamp
exit_date	The timestamp indicating when the Person ended this role in the Course section.	No	No	timestamp
repetition_basis	Indicates whether the student’s enrollment in a particular Course section is on a repeat basis. (option set)	No	No	text
credits_taken	The number of credits the Person intended to earn in the Course section.	No	No	decimal
credits_earned	The number of credits the Person actually earned in the Course section.	No	No	decimal

top

Facility

This entity is recommended.

Entity filename: facility.csv.

A building on an Academic campus in which instruction may take place.

Code (Header)	Description	Is required	Is foreign key	Datatype
sis_int_id	The key used within the SIS to identify this Facility.	Yes	No	text
sis_ext_id	The global key generated by this SIS to identify this Facility, for use by external tools that are provisioned or launched from the SIS.	No	No	text
campus_id	The foreign key to the Campus to which this Facility belongs. See Campus.	Yes	Yes	integer
facility_type_id	The type of Facility (option set)	No	No	text
name	The name of the Facility.	No	No	text
abbreviation	The abbreviation for the Facility. This is often used as shorthand or codes in documentation, etc.	No	No	text
gps_coordinates	The Global Positioning System coordinates that define the location of the Facility.	No	No	text
street_number	The street number for the address of the Facility.	No	No	text
street_name	The street name for the address of the Facility.	No	No	text
city	The city in which the Facility is located.	No	No	text
state	The US state in which the facility is located.	No	No	text
zip_code	The Zip code for the address of the facility.	No	No	text

top

Institutional Affiliation

This entity is required.

Entity filename: institutional_affiliation.csv.

The association of a Person to an academic institution, and the description of the general or primary capacity in which they act at that institution.

Code (Header)	Description	Is required	Is foreign key	Datatype
person_id	The person affilitated with the University. See Person.	Yes	Yes	integer
directory_block	A variable used to describe Persons who are currently electing to block their directory information as per FERPA, or those who previously had a block but are requesting it be removed. A `null` value indicates that the related person does not have a FERPA directory block, and values may be shared in accordance with standard data agreements. This block is only valid for institutional affiliated records. (option set)	No	No	text

top

Person

This entity is required.

Entity filename: person.csv.

An individual participating, in any capacity, in the design, delivery, or evaluation of teaching and learning processes and environments.

Code (Header)	Description	Is required	Is foreign key	Datatype
sis_int_id	The key used within the SIS to identify this Person.	Yes	No	text
sis_ext_id	The global key generated by this SIS to identify this Person, for use by external tools that are provisioned or launched from the SIS.	No	No	text
fed_identity	The individual identifier released by an Institution's Identity Provider to Service Providers in an SSO integration scenario. In Shibboleth, for example, this value will usually correspond to the eduPersonPrincipalName (EPPN).	No	No	text
first_name	Legal first name of the person.	No	No	text
middle_name	Legal middle name or names of the person.	No	No	text
last_name	Legal family name of the person	No	No	text
preferred_first_name	The preferred first name of the person at the institution.	No	No	text
suffix	Suffix for the person.	No	No	text
sex	The legal sex of the person. (option set)	No	No	text
gender	The person’s self-identified gender. (option set)	No	No	text
gender_pronoun	The gender pronouns to which the individual self-identifies. (option set)	No	No	text
is_black_african_american	If true, indicates that the individual identifies as Black or African American.	No	No	boolean
is_american_indian_alaska_native	If true, indicates that the individual identifies as American Indian or Alaska Native.	No	No	boolean
is_asian	If true, indicates that the individual identifies as Asian.	No	No	boolean
is_hawaiian_pacific_islander	If true, indicates that the individual identifies as Hawaiian or Pacific Islander.	No	No	boolean
is_hispanic_latino	If true, indicates that the individual identifies as Hispanic or Latino/a.	No	No	boolean
is_white	If true, indicates that the individual identifies as White.	No	No	boolean
is_other_american	If true, indicates that the individual identifies as another American race or ethnicity.	No	No	boolean
is_no_race_indicated	If true, indicates that the individual refused to assert their race or ethnicity.	No	No	boolean
is_first_generation_hed_student	Indicates whether the sudent is in the first generation of their family to attend an institution of higher education.	No	No	boolean
is_english_first_language	Indicates whether English is the first language of the Person. If false, it is assumed that some other language is the individauls first language even if the student is proficient in English.	No	No	boolean
was_veteran_at_admissions	Indicates whether a student self-identified as being a veteran during the admission process.	No	No	boolean
citizenship_one	A code representing a student's first or only country of citizenship. (option set)	No	No	text
citizenship_two	A code representing a student's second country of citizenship. (option set)	No	No	text
citizenship_three	A code representing a student's third country of citizenship. (option set)	No	No	text
country_first_foreign_permanent_residence	A code representing the country of the Person's first permanent foreign residence. (option set)	No	No	text
zip_code_first_us_permanent_residence	The postal code of a Person's first United States permanent residence.	No	No	text
zip_code_at_time_of_application	The zip code of the Person's permanent address at time of there application to the University.	No	No	text
neighborhood_cb_cluster_code_at_time_of_application	The neighborhood cluster code, as defined by College Board, for the neighborhood of the student's permanent address at time of their college application.	No	No	text
estimated_gross_family_income	Represents a student’s estimated gross family income. Note: This data is usually self-reported on the student’s admission application. (option set)	No	No	text
parent_dependents_count	The number of dependents for a student's parent(s). Note: This data is self-reported on the student's admission application.	No	No	integer
edu_level_paternal	The highest level of education attained by a person's father or paternal guardian(s). (option set)	No	No	text
edu_level_maternal	The highest level of education attained by a person's mother or maternal guardian(s). (option set)	No	No	text
edu_level_parental	The highest level of education attained by a person's parent or guardian(s). Use this if the available data is not specific to a mother/maternal guardian or father/paternal guardian. (option set)	No	No	text
parent_is_single_parent	Indicates whether or not a person was raised by a single parent. Note: This data is self-reported on the student's admission application.	No	No	boolean
hs_cb_cluster_code	The neighborhood cluster code, as defined by College Board, for the neighborhood of the student's primary High school.	No	No	text
hs_ceeb_code	The College Entrance Examination Board (CEEB) code for the student's High school. CEEB codes are issued by Educational Testing Service (ETS). These 4- to 6-digit codes are primarily used in the college entrance exams.	No	No	text
hs_zip_code	The zip or postal code of the primary High school that a student attended, as determined by the Institution.	No	No	text
hs_state_code	A code representing the state portion of the primary high school address for the High school the student attended, as determined by the Institution (option set)	No	No	text
hs_city_name	The city portion of the High school address for the primary High school that the student attended, as determined by the Institution.	No	No	text
hs_gpa	Student’s reported cumulative high school grade point average. This value is intended to capture the primary GPA used by your institution to evaluate this student’s admission.	No	No	decimal
hs_percentile_rank	The student's percentile ranking at their graduating school, as reported. The percentile is usually based on their GPA.	No	No	decimal
hs_graduating_month	The month of the year that the student graduated from High school with a diploma.	No	No	text
hs_graduating_year	The year that the student graduated from High school with a diploma.	No	No	integer
last_undergraduate_school	The name of the undergraduate school most recently attended by the student, or the school with the greatest relevance, as determined and entered by the unit.	No	No	text
last_undergraduate_school_institution_code	The Institution’s identifier for the undergraduate school most recently attended by the student, or the school with the greatest relevance, as determined and entered by the unit.	No	No	text
last_undergraduate_school_ceeb_code	A code representing the College Entrance Examination Board (CEEB) code of the student's last school attended. CEEB codes are issued by the Educational Testing Service (ETS). These 4- to 6-digit codes are primarily used in the college entrance exams.	No	No	text
last_undergraduate_school_type	The type of undergraduate school most recently attended by the student, or the school with the greatest relevance, as determined and entered by the unit. (option set)	No	No	text
last_undergraduate_school_end_date	The date on which the student ended their Academic career at their last undergraduate school attended.	No	No	date

top

Person - Academic Degree

This entity is recommended.

Entity filename: person__academic_degree.csv.

An Academic degree that was earned by a Person at the institution.

Code (Header)	Description	Is required	Is foreign key	Datatype
sis_int_id	The key used within the SIS to identify this Person - Academic Degree.	Yes	No	text
sis_ext_id	The global key generated by this SIS to identify this Person - Academic Degree, for use by external tools that are provisioned or launched from the SIS.	No	No	text
person_id	The foreign key to the Person to which this Academic degree belongs. See Person.	Yes	Yes	integer
academic_degree_id	The foreign key to the Academic degree to which this Person-Academic degree belongs. See Academic Degree.	Yes	Yes	integer
academic_term_id	The foreign key to the Academic term in which this Academic degree was earned. See Academic Term.	No	Yes	integer
academic_excellence	The academic excellence achieved by a student for the degree earned at the Institution. (option set)	No	No	text
conferred_date	The official date on which the Academic degree or certificate was awarded by the Institution. This is the date that prints on the official transcript and the diploma.	No	No	date
academic_major_1	The first Academic major associated with this particular degree.	No	No	text
academic_major_2	The second Academic major associated with this particular degree.	No	No	text
academic_major_3	The third Academic major associated with this particular degree.	No	No	text
academic_major_specialization_1	The first Academic major specialization associated with this particular degree.	No	No	text
academic_major_specialization_2	The second Academic major specialization associated with this particular degree.	No	No	text
academic_major_specialization_3	The third Academic major specialization associated with this particular degree.	No	No	text
academic_minor_1	The first Academic minor associated with this particular degree.	No	No	text
academic_minor_2	The second Academic minor associated with this particular degree.	No	No	text
academic_minor_3	The third Academic minor associated with this particular degree.	No	No	text

top

Person - Academic Major - Academic Term

This entity is recommended.

Entity filename: person__academic_major__academic_term.csv.

Denotes the the Person was pursuing the Academic major during the Academic term.

Code (Header)	Description	Is required	Is foreign key	Datatype
person_id	The foreign key to the Person to which this relationship belongs. See Person.	Yes	Yes	integer
academic_major_id	The foreign key to the Academic major to which this relationship belongs. See Academic Major.	Yes	Yes	integer
academic_term_id	The foreign key to the Academic term to which this relationship belongs. See Academic Term.	Yes	Yes	integer

top

Person - Academic Major Specialization - Academic Term

This entity is recommended.

Entity filename: person__academic_major_specialization__academic_term.csv.

Denotes the the Person was pursuing the Academic major specialization during the Academic term.

Code (Header)	Description	Is required	Is foreign key	Datatype
person_id	The foreign key to the Person to which this relationship belongs. See Person.	Yes	Yes	integer
academic_major_specialization_id	The foreign key to the Academic major specialization to which this relationship belongs. See Academic Major Specialization.	Yes	Yes	integer
academic_term_id	The foreign key to the Academic term to which this relationship belongs. See Academic Term.	Yes	Yes	integer

top

Person - Academic Minor - Academic Term

This entity is recommended.

Entity filename: person__academic_minor__academic_term.csv.

Denotes the the Person was pursuing the Academic minor during the Academic term.

Code (Header)	Description	Is required	Is foreign key	Datatype
person_id	The foreign key to the Person to which this relationship belongs. See Person.	Yes	Yes	integer
academic_minor_id	The foreign key to the Academic minor to which this relationship belongs. See Academic Minor.	Yes	Yes	integer
academic_term_id	The foreign key to the Academic term to which this relationship belongs. See Academic Term.	Yes	Yes	integer

top

Person - Academic Term

This entity is required.

Entity filename: person__academic_term.csv.

The relationships between a Person and a Term for any given term.

Code (Header)	Description	Is required	Is foreign key	Datatype
person_id	The foreign key to the Person to which this relationship belongs. See Person.	Yes	Yes	integer
academic_term_id	The foreign key to the Academic term to which this relationship belongs. See Academic Term.	Yes	Yes	integer
academic_career_id	The foreign key to the primary Academic career of the student during this Academic term. See Academic Career.	Yes	Yes	integer
registration_status	Indicates the registration status of a student for a particular Academic term. (option set)	No	No	text
cen_academic_level	The student's Academic level at the census date of an Academic term, as determined by the institution. (option set)	No	No	text
cen_academic_load	The student's Academic load at the census date of an Academic term, as determined by the Institution. (option set)	No	No	text
eot_academic_load	The student's Academic load at the end of an Academic term, as determined by the Institution. (option set)	No	No	text
gpa_credits_units_hours	The number of credits, units, or hours taken that count toward grade point average (GPA) for the Academic term, as determined by the institution.	No	No	decimal
non_gpa_credits_units_hours	The number of credits, units, or hours taken that do not count toward grade point average (GPA) for the Academic term, as determined by the institution.	No	No	decimal
grade_points_earned	The number of total grade points earned by the student in the Academic term. This is computed by, for each course grade earned, multiplying the number of credits, units, or hours that count toward the GPA with the number of grade points per credit.	No	No	decimal
gpa_academic_term	The GPA of a post-secondary student in this Academic term at the University. This is usually computed by computing the sum of Grade points earned that count toward GPA by the sum of Credits earned that count toward GPA.	No	No	decimal
gpa_cumulative	The cumulative GPA of a post-secondary student through to their most recently completed Academic term at the University, but not including the term for which this is a record. This GPA is intended to cover the whole career of a post-secondary student up until the beginning of this Academic term. This is usually computed by computing the sum of Grade points earned that count toward GPA by the sum of Credits earned that count toward GPA.	No	No	decimal
athletic_participant_sport	The sport a student is participating in as a National Collegiate Athletic Association (NCAA) athlete. (option set)	No	No	text
us_residency	The person’s residency status in the United States. (option set)	No	No	text
us_state_residency	A code representing a student's residency for fee assessment purposes, as defined by the Institution’s policy. (option set)	No	No	text
is_active_duty	Is the student/person an active duty member of the military?	No	No	boolean
is_veteran	Is the student/person a military veteran (i.e., a retired member of the military who served on active duty)?	No	No	boolean
in_honors_program	Indicates whether a student is enrolled in any honors program during the term.	No	No	boolean
is_in_supplemental_study_plans	Indicates whether a student is enrolled in any supplemental study plans.	No	No	boolean
is_in_teaching_certificate_plan	Indicates whether a student is enrolled in any teaching certificate plans.	No	No	boolean

top

Person Email

This entity is recommended.

Entity filename: person_email.csv.

The email addresses associated with a Person.

Code (Header)	Description	Is required	Is foreign key	Datatype
sis_int_id	The key used within the SIS to identify this Person Email.	Yes	No	text
sis_ext_id	The global key generated by this SIS to identify this Person Email, for use by external tools that are provisioned or launched from the SIS.	No	No	text
person_id	The foreign key to the Person to which this relationship belongs. See Person.	Yes	Yes	integer
email_address	The email address value.	No	No	text
email_type	The type of email address. Values may include "Home," "Work," etc. (option set)	No	No	text
is_primary	If true, then this is the Person's primary email address.	No	No	boolean

top

Person Phone Number

This entity is recommended.

Entity filename: person_phone_number.csv.

The phone numbers associated with a Person.

Code (Header)	Description	Is required	Is foreign key	Datatype
sis_int_id	The key used within the SIS to identify this Person Phone Number.	Yes	No	text
sis_ext_id	The global key generated by this SIS to identify this Person Phone Number, for use by external tools that are provisioned or launched from the SIS.	No	No	text
person_id	The foreign key to the Person to which this relationship belongs. See Person.	Yes	Yes	integer
phone_number	The phone number value.	No	No	text
phone_number_type	The type of phone number. Values may include "Home," "Work," etc.	No	No	text
is_primary	If true, then this is the Person's primary phone number.	No	No	boolean

top

Room

This entity is recommended.

Entity filename: room.csv.

The particular Room of a particular Facility at the Institution.

Code (Header)	Description	Is required	Is foreign key	Datatype
sis_int_id	The key used within the SIS to identify this Room.	Yes	No	text
sis_ext_id	The global key generated by this SIS to identify this Room, for use by external tools that are provisioned or launched from the SIS.	No	No	text
facility_id	The foreign key to the Facility to which this Room belongs. See Facility.	Yes	Yes	integer
ref_type_id	The type of Room. (option set)	No	No	text
code	The unique code that identifies the Room in the Facility.	No	No	text
number	The Room's unique number that identifies it at its Facility.	No	No	text
max_occupancy	A number indicating the maximum number of people who may occupy the room at once.	No	No	integer

top