|
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
D a t a D i c t i o n a r y
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
This page was last updated on February 15, 2000.
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
|
|
