reset password

Original Data

The original data of IRP consists of four tables: FTF_COHORTS, TERMS, CLASSES+UNITS, and FINAID. The columns of these tables are described below.

FTF_COHORTS

ID Student ID
STRM The term (i.e. quarter) in which the student entered the program. The first 3 digits of the quarter code represents year, e.g. 206 is 2006, 213 is 2013, and so on. The last digit represents quarter, with 1 for Winter, 3 for Spring, 6 for Summer, and 9 for Fall.
BDATE Birthday
SEX Male or Female
ETHNIC2 Ethnicity
ENSTAT Enrollment Status. 5 means First-Time Freshman.
STULEVEL Student level: 1 = freshman, 2 = sophomore, 3 = junior, 4 = senior. Some first time students entered the program at level 2, 3, or 4. Level 3 or 4 freshmen sometimes have just been errors in the past.
IOC Institution of Origin Code. In this case, the codes of the high schools from which they graduated.
INSTI2 Type of institution attended before entering the program, e.g. public/private high school.
LOCAL? From local regions or not.
PELL_ELIG The student applied for financial aid and was Pell eligible (based on low-income status).
EPTS English Placement Test Status. Numerical values indicate how many remedial English courses they are required to take. U means they are not exempt but have not taken the EPT. Other alphabetic values are codes for why they are exempt.
EPT_RESULTS Results of English Placement Test.
ELMS Entry Level Mathematics Status. Numerical values indicate how many remedial math courses they are required to take. U means they are not exempt but have not taken the ELM. Other alpha values are codes for why they are exempt.
ELM_RESULTS Results of Entry Level Mathematics exam.
HSGPA High School GPA
SATCOMP SAT Composite, i.e. the total score of math, critical reading, and writing in SAT (out of 2400).
ACTCOMP ACT Composite, i.e. the composite score of science, reading, and math in ACT (out of 36).
FT/PT Full-Time or Part-Time. Full-Time =  enrolled for 12 state-supported units or more in current term.
UNITS State-supported units registered for in current term.
UNITSLD Lower Division UNITS
UNITSUD Upper Division UNITS
UNITSGRD Graduate UNITS
COLL College
DEPT Department
PLAN Degree Program
DEG_STRM The term in which the degree was awarded.
DEG_COLL The college that awarded the degree.
DEG_DEPT The department that awarded the degree.
DEG_PLAN The program that awarded the degree.
GD_RATE The number of years the student took to complete the degree. PERS means they haven't graduated yet but are still enrolled.

CLASSES

ID Student ID
STRM Term (i.e. quarter)
ACAD_CAREER Academic Career, i.e. undergraduate or graduate.
CLASS_NBR Class Number
ACAD_GROUP The college that offered the class.
SUBJECT The subject code of the course, e.g. "CS" in "CS101".
CATALOG_NBR The number code of the course, e.g. "101" in "CS101".
CLASS_SECTION Section Number
DESCR Course Title
SSR_COMPONENT Class Type, e.g. lecture, lab, activity, seminar, etc.
STDNT_ENRL_STATUS Student Enrollment Status: E for Enrolled and D for Dropped.
CRSE_GRADE_OFF Grade
ENRL_ADD_DT The date on which the student added the class.
ENRL_DROP_DT The date on which the student dropped the class.
STATUS_DT Status Date, which seems to be either the Add Date or the Drop Date.
UNT_PRGRSS Units registered for the class.

TERMS

ID Student ID
ACAD_CAREER Academic Career, i.e. undergraduate or graduate.
STRM Term (i.e. quarter)
ACAD_LEVEL Academic Level: B1 for Freshman (0 - 44.99 units), B2 for Sophomore (45 - 89.99 units), B3 for Junior (90 - 134.99 units), B4 for Senior (135 - 167.99 units), BP for 2nd Baccalaureate (201+ units). Other labels are BP for Transitory, and XE for Extended Education.
UNT_TAKEN_PRGRSS Units taken in that term.
UNT_PASSD_GPA GPA units passed in that term.
UNT_PASSD_NOGPA Non-GPA units passed in that term. This can include pass-fail and remedial classes.
TRF_PASSED_GPA Number of units transferred in that term that count toward GPA.
TRF_PASSED_NOGPA Number of units transferred in that term that do not count toward GPA.
TOT_CUMULATIVE State-supported units earned since first enrollment (not including current term).
CUR_GPA GPA for current term.
CUM_GPA Cumulative GPA through current term.

FINAID

ID Student ID
AID_YEAR The academic year for which the financial aid was awarded. The number shows the latter part of the academic year, e.g. 2007 means 2006-2007 academic year.
AWARDED? Whether the financial aid was awarded.
OFFER_AMOUNT Award amount offered to the student.
ACCEPT_AMOUNT Award amount accepted by the student.

 
This page has been viewed 6866 times.