Registration Object

The Registration object contains data concerning student's registration activity. This object contains one record for each course registration per student in any of the terms for which registration data is included in the Student Data Warehouse.

---

Warehouse ID

Warehouse identification code. A unique identifying value for all persons in the Student Data Warehouse.

Data Type: Number

Example: 123456

Source: derived

Term

Code representing the term this registration data was collected. Format is YYYYTT, where YYYY = academic year and TT = term or semester, 01 = Fall, 02 = Winter, 03 = Spring, 04 = Summer, 05 = Fall Semester, 06 = Spring Semester, 07 = Summer Semester.

Data Type: 6 Characters

Example: 199502

Source: sfrstcr_term_code

Val Table: Term

Term Abbrev

Short version of term code intended for use in printing. The format is alphabetic term code (F = Fall Term, W = Winter Term, S = Spring Term, U = Summer Term, FS = Fall Semester, SS = Sprint Semester, US = Summer Semester) and the terminal calendar year digits.

Data Type: 4 Characters

Example: W 95

Source: stvterm_short_desc

CRN

The course reference number assigned to the course section. CRNs are not unique across academic years.

Data Type: 5 Characters

Example: 22823

Source: sfrstcr_crn

College

College offering the course.

Data Type: 2 Characters

Example: AS

Source: scbcrse_coll_code

Val Table: College

Dept Code

Department offering the course.

Data Type: 4 Characters

Example: MATH

Source: scbcrse_dept_code

Val Table: Department

Subj Code

Course subject code.

Data Type: 4 Characters

Example: MATH

Source: ssbsect_subj_code

Val Table: Subject

Course Numb

Course number. It may include an alpha suffix.

Data Type: 4 Characters

Example: 111

Source: ssbsect_crse_numb

Title

Title of the course.

Data Type: 30 Characters

Example: Public Speaking

Source: ssbsect_crse_title

Registration Status Code

The current registration status of this registration. Students who withdraw after the refund period (4th week) of a term are counted in official enrollment counts even though they no longer attend the class. Registration Status Codes which count toward enrollment include: AC, AU, CN, RA, RC, RE, RR, RS, WN. Registration Status Codes which do not count in enrollment include: BP, CA, CD, CW, DC, RD, WC. See "Include in Enrollment."

Data Type: 2 Characters

Example: RE

Source: sfrstcr_rsts_code

Val Table: Registration Status

Registration Status Desc

Text Description of Registration Status Code.

Data Type: 30 Characters

Example: **Registered**

Source: stvrsts_desc

Val Table: Registration Status

Include in Enrollment

This flag indicates whether or not the registration status code 'counts' in determining an enrolled status. Please note that students who withdraw without refund count in enrollment and in student credit hour calculations for academic departments.

Data Type: 1 Character

Example: Y

Source: stvrsts_incl_sect_enrl

Val Table: Registration Status

Course Level

Level of the course. 'UG' = Undergraduate, 'GR' = Graduate, 'LW' = Law.

Data Type: 2 Characters

Example: 1

Source: sfrstcr_levl_code

Val Table: Level

Credit Hours

Credit hours for which the student registered for the course.

Data Type: 2 Digit number plus 2 decimal places

Example: 3

Source: sfrstcr_credit_hr

Grading Option

Grade option chosen by student; 'G' = Graded, 'P' = Pass/No Pass, '*' = Pass/No Pass Only.

Data Type: 1 Character

Example: G

Source: sfrstcr_gmod_code

Grade

Grade given to the Student. WARNING: The grade displayed in the registration record is the grade initially assigned by the faculty through the grade submission process at the end of the term. It is not necessarily the student's final grade in the class; that will be reflected in the grade field in the student's transcript record for the course. 'AU' = Audit and 'W'' = Withdrawn are the only grades assigned before the Term/Semester grade roll process.

Data Type: 3 Characters

Example: AU

Source: sfrstcr_grde_code