The Complete Guide to the Student Right-to-Know Database

Background
In order to complete the IPEDS-GRS/SRTK Federal Reporting Requirements, the Student Right-To-Know Task Force has designed a series of four downloadable tables to host the requisite information about your SRTK cohort. Additionally, in an effort to provide a means to derive other pertinent measures from consistent data across all California Community Colleges, the cohort of students in these tables has been "Expanded" to include all first-time freshmen (excludes noncredit students) in a full-year cohort. The ESRTK dataset is a portable, ASCII text-based relational database that can be viewed and queried in its native format by BrioQuery. A copy of BrioQuery (one per college) was sent to all District MIS/Research departments in 1997. In order to have BrioQuery read the ESRTK files, you will need to perform a one-time setup procedure, explained in the "Brio Query Connections Cookbook".

District/College Dataset Downloads (Secured)
SRTK Table Information
Cohort TableAwards TableEnrollment TableTransfer Table

The COHORT table


This is the main table of the set. There exists one record in the cohort table for each student in the cohort; its keyfields are "college_id" and "SSN". To be a member of the cohort, the student must be a first-time freshman between the Fall term of the cohort year and the following Spring term (students who are first-time in the Summer term prior to the primary Fall term are normally coded as first-time freshmen in the Fall term and would be included). The COHORT table includes many demographical fields about the student as they were submitted as of the students' first term. The COHORT table also includes flagged fields denoting whether the student is part of the IPEDS-GRS cohort (a subset), whether they earned any type of award, became "Student Transfer Prepared", or transferred to another 4-year institution.

 
data mart
regional training
data element dictionary
data timeline

data timeline