|
|
 |
|
|
|
|
| |
|
|
| |
|
| |
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". |
|
| |
|
|
| |
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.
-
COHORT Table Structure
|
|
| |
|
|
| |
The AWARDS table is a detail table that
links back to the COHORT table on the field "SSN".
There is one record for each award earned by a student over
the cohort tracking period. If a student earned more than one
award, there will be multiple records for that students' SSN.
The student could have earned the award at any college within
the CCC system.
-
AWARDS Table Structure
|
|
| |
|
|
| |
The ENROLLMENT table is a detail table
that links back to the COHORT table on the field "SSN".
There is one record for each enrollment attempted by a student
over the cohort tracking period at any college in the CCC system.
This table includes all courses completed and attempted, all
grades, withdrawls, CR, pass/fails and incompletions, along
with units attempted, earned, and grades.
-
ENROLLMENT Table Structure
|
|
| |
|
|
| |
The XFER table is a detail table that
links back to the COHORT table on the field "SSN".
There is one record for each student in the COHORT table who
transferred to another institution outside the CCC system during
the cohort tracking period. This table shows where and when
the student transferred. The 1995 XFER table structure has been
changed effective January 1, 2000. The new table structure includes
National Student Loan Clearinghouse matches for those colleges
that are NSLC members.
-
XFER Table Structure |
|
| |
|
|
| |
This details the structure of the IPEDS
table and ASCII (.txt) reporting format used only on the 1994
cohort. The 1995 IPEDS-GRS reports are now available in Excel
format and are located in your colleges' data download area.
|
|
| |
|
|
| |
The following are (.csv) lookup tables
that can be downloaded and saved to the same directory as
your ESRTK files for viewing and querying. These tables have
been designed to "auto-join" in BrioQuery.
cccoll.csv
- A table that has all California Community
Colleges by Name.
cdscodes.csv
- A table that has all community college
CDS Codes.
topcodes.csv
- A table that has all community college
Top Codes.
xfercoll.csv
- A table that has all Transfer Colleges
by FICE and Name.
|
|
| |
95_99_cohort
- An excel file that has all the cohort
years 1995 to 1999.
|
|
|
|
|
|
|
