Field Name | Field Descr |
CRSE_ID | Code for the Course ID |
STRM | Code for Term |
SESSION_CODE | Session Code, within a term (most useful in Summer) |
CLASS_SECTION | Class Section |
ACAD_GROUP | Code for Academic Group, or School |
SUBJECT | Class subject |
CATALOG_NBR | Class Catalog Number |
ACAD_CAREER | Code for Academic Career. Value attached to the class. |
DESCR | Class description |
CLASS_NBR | Class Number, a unique value within each term for a class section. |
SSR_COMPONENT | Category for class (lecture, lab, etc.) |
ENRL_STAT | Status of class (open, closed, etc.) |
CLASS_STAT | Class Enrollment Status, open, closed, etc. |
CLASS_TYPE | Class Type (graded, not graded) |
ENRL_CAP | Enroll capacity for a class section |
WAIT_CAP | Wait List Capacity for a class |
MIN_ENRL | Minimum enrollment required for a class |
ENRL_TOT | Total enrollment in a class section |
WAIT_TOT | Student count on wait list for class |
ACAD_ORG | Code for Academic Organization, or Department, used in Acad Org tree. |
LOCATION | Location code for class |
END_DT | Class end date |
START_DT | Class start date |
COMBINED_SECTION | Flag denoting if the section is combined with another |
Join to this table from STDNT_ENRL to bring in Subject, Catalog Number, and Class Section. |
This table also has the ACAD_GROUP and the ACAD_ORG for the class. |
You need only join by STRM and CLASS_NBR (SESSION_CODE is optional), if the automatic join includes EMPLID then it will pull no data. |
To pull classes that count as full-time status: SSR_COMPONENT in list FTS,INT,COP |
Beginning Spring 2015 LOCATION as populated to CLASS_TBL was refined. Expected values: |
ABROAD |
MAIN |
MAINWTRVL (regularly meets on campus, has a travel component that will be a separate meeting pattern) |
OFFSITE (within Texas) |
OUTOFSTATE (a specific facility in another state) |
PLANO |
TAOS |
STDNTSPEC (wherever the student is, for online, distance, internships, etc., student location is based on OFFC address or HOME address.) |