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
- Academic Term
- Course Offering
- Course Section
- Course Section Enrollment
- Institutional Affiliation
- Person
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 |
term_type |
The type of Academic term. (option set) | No | No | text |
session_type |
The type of session for your Academic term, usually describing the length of the term. (option set) | No | No | text |
session_name |
The human readable name for the academic term. | No | No | text |
term_begin_date |
The date and time when the academic term formally begins. | No | No | timestamp |
term_end_date |
The date and time when the academic term formally ends. | No | No | timestamp |
instr_begin_date |
The date and time when instruction begins. | No | No | timestamp |
instr_end_date |
The date and time when instruction ends. | No | No | timestamp |
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 |
term_id |
The globally unique, SIS-generated internal ID for the term to which the course offering belongs. See Academic Term. | Yes | Yes | integer |
course_subj |
The alphabetic abbreviation of the academic department or discipline offering the course. It is one part of the total Course offering Id number. E.g., "BIO" in "BIO 101." | No | No | text |
course_no |
The official reference number portion of a Course offering 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." | 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 |
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 |
course_offering_id |
The course offering to which this Course section belongs. See Course Offering. | Yes | Yes | integer |
academic_term_id |
The Academic term to which this Course section belongs. See Academic Term. | Yes | Yes | integer |
section_number |
The unique number of a particular Course section. | No | No | text |
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 |
Course Section Enrollment
This entity is required.
Entity filename: course_section_enrollment.csv.
The association of a Person to an organization, 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 Course section to whom this Course section enrollment applies. 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 |
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 |
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 |
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 |
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 |
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 |
suffix |
Suffix for the person. | No | No | text |
sex |
The legal sex of the person. (option set) | No | No | text |
ethnicity |
The self-reported ethnicity of the student. (option set) | No | No | text |
zip_code |
The zip code of the student’s permanent address at time of his or her application. | No | No | text |
us_residency |
The person’s residency status in the United States. (option set) | 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 |
col_gpa_cum |
The cumulative GPA of a post-secondary student through to their most recent term. This GPA score is intended to cover the whole career of a post-secondary student. | No | No | decimal |
active_duty |
Is the student/person an active duty member of the military? (option set) | No | No | text |
veteran |
Is the student/person a military veteran (i.e., a retired member of the military who served on active duty)? (option set) | No | No | text |
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 |
enrollment_level |
The enrollment type of this person (student) at your institution. (option set) | No | No | text |
course_count |
Number of courses undertaken by student from date of SIS data availability to present, regardless of pass/fail. | No | No | integer |
sat_math_pre_2016 |
The non-concorded, pre-2016 SAT Math score from the student's best sitting. | No | No | text |
sat_math_post_2016 |
The post-2016 SAT Math score from the student's best sitting. | No | No | text |
sat_math_combined |
The combined SAT Math score from the student's best sitting. A combined score combines the actual post-2016 score with concorded (translated) pre-2016 score. | No | No | text |
sat_verbal_pre_2016 |
The non-concorded, pre-2016 SAT Verbal score from the student's best sitting. | No | No | text |
sat_reading_post_2016 |
The post-2016 SAT Reading score from the student's best sitting. | No | No | text |
sat_verbal_reading_combined |
The combined SAT Verbal and Reading scores from the student's best sitting. A combined score combines the concorded (translated) pre-2016 Verbal score with the actual post-2016 Reading score. | No | No | text |
sat_writing_pre_2016 |
The non-concorded, pre-2016 SAT Writing score from the student's best sitting. | No | No | text |
sat_writing_post_2016 |
The post-2016 SAT Writing score from the student's best sitting. | No | No | text |
sat_writing_combined |
The combined SAT Writing scores from the student's best sitting. A combined score combines the concorded (translated) pre-2016 Writing score with the actual post-2016 Writing score *except* if the pre-2016 Writing score is missing, in which case this field is `null`. | No | No | text |
sat_total_combined |
Total Combined SAT score. This score combines concorded Math, Reading, and Writing scores except if a Writing score is unavailable, in which case this score is null. | No | No | text |
act_reading |
Score on ACT Reading exam. | No | No | text |
act_math |
Score on ACT Math exam. | No | No | text |
act_english |
Score on ACT English exam. | No | No | text |
act_science |
Score on ACT Science exam. | No | No | text |
act_composite |
Composite ACT score. | No | No | text |
phone_number |
The university’s primary number for contacting a person by phone. | No | No | text |
phone_type |
The type of phone number that is the primary method of contact for the person by phone. (option set) | No | No | text |
email_address |
The university’s primary address for contacting a person by email.| | No | No | text |
email_type |
The type of email address that is the primary method of contact for the person by email. (option set) | No | No | text |