CCGI Student File Report
Overview
The CCGI Student Data Elements report is a California state-specific report designed to generate a list of students with demographic and enrollment details required for College Career Guidance Initiative (CCGI) submission. This report is part of California's effort to provide comprehensive student data for college and career planning initiatives.
Purpose
This report serves as one of the core data files required for CCGI submission, providing essential student information, including:
Student identification and demographic information
Academic performance data (GPA)
Program eligibility indicators
Special population identifiers (Foster Youth, English Learners, Students with Disabilities, etc.)
Enrollment and contact information
Report Requirements
Important: Verify that all students have valid SSIDs (State Student ID Numbers) and grade levels before running the report.
Eligibility
This report includes students in grades 9-12 who meet the selection criteria.
Report Input
Field | Description |
|---|---|
Select Schools | Unique identifiers for set of schools for which to generate report content. Select the schools to include in the report. Multiple schools can be selected using Ctrl+Click. Only schools that are not excluded from state reporting will be available for selection. This is a required field. |
Select Students | Use the Student Selection page to filter and select specific students (grades 9-12) to include in the report. This is a required field. |
School Year | Select the school year for which to generate the CCGI student data. Choose from available year records for the current school. This is a required field. |
GPA Method | Select the GPA calculation method for this report from the configured options (e.g., Weighted, Unweighted, College). This method will calculate student GPAs in the report. This is a required field. |
GPA Type Display Text | Select the GPA Type display text for the report output. This labels the GPA type in the output file. Options include:
This is a required field. |
SFTP connections | Select the SFTP (Secure File Transfer Protocol) connection to upload the report file. The report uploads automatically to the selected SFTP server upon completion. This is a required field. |
Report Output
Data Element | Description | [Table]FieldName |
|---|---|---|
PrimaryCDSCode | The primary County-District-School (CDS) code for the student's school. Combination of district number and school state number. | [Prefs]districtnumber + [S_CA_SCH_X]StateSchoolNumber |
LocalStudentID | The student's local identification number assigned by the district. | [Students]Student_Number |
StateID | The 10-digit California State Student ID (SSID) assigned to the student. | [Students]State_StudentNumber |
FirstName | The student's legal first name. | [StudentCoreFields]PSCORE_Legal_First_Name |
PreferredFirstName | The student's preferred first name (if different from legal name). | [Students]First_Name |
MiddleName | The student's legal middle name. | [StudentCoreFields]PSCORE_Legal_Middle_Name |
PreferredMiddleName | The student's preferred middle name (if different from legal name). | [Students]Middle_Name |
LastName | The student's legal last name. | [StudentCoreFields]PSCORE_Legal_Last_Name |
PreferredLastName | The student's preferred last name (if different from legal name). | [Students]Last_Name |
Suffix | The student's name suffix (e.g., Jr., Sr., III). | [S_CA_STU_X]NameSuffix |
DateOfBirth | The student's date of birth in MM/DD/YYYY format. | [Students]DOB |
Gender | The student's legal gender. | [StudentCoreFields]PSCORE_Legal_Gender |
GradeLevel | The student's current grade level (09, 10, 11, or 12). | [Students]Grade_Level |
GPA | The student's Grade Point Average calculated using the selected GPA method. | Calculated based on GPA Method selection |
GPAType | The type of GPA being reported (e.g., Weighted, Unweighted, College, Other). | User-selected parameter (GPA Type Display Text) |
CalGrantGPA | The student's Cal Grant GPA (if applicable). | N/A (Reserved for future implementation) |
LOTECert | Language Other Than English (LOTE) Certificate indicator. Valid values: Y (Yes), N (No). Default: N. | [S_CA_STU_X]LOTECert |
LOTECertSource | The source of the LOTE certification. | [S_CA_STU_X]LOTECertSource |
LanguageCode | The language code for the LOTE certification. | [S_CA_STU_X]LOTECode |
FosterYouth | Indicates whether the student is a foster youth. Valid values: Y (Yes), N (No). Based on Program Code 109. | [S_CA_STU_CALPADSPrograms_C]ProgramCode = 109 |
HispanicEthnicity | Indicates whether the student is of Hispanic or Latino ethnicity. Valid values: Y (Yes), N (No). | [Students]FedEthnicity |
RaceCode1 | The student's primary race code. | [StudentRace]RaceCd (1st record) |
RaceCode2 | The student's secondary race code (if applicable). | [StudentRace]RaceCd (2nd record) |
RaceCode3 | The student's third race code (if applicable). | [StudentRace]RaceCd (3rd record) |
RaceCode4 | The student's fourth race code (if applicable). | [StudentRace]RaceCd (4th record) |
RaceCode5 | The student's fifth race code (if applicable). | [StudentRace]RaceCd (5th record) |
EnrollmentStartDate | The student's enrollment start date at the school in MM/DD/YYYY format. | [Students]EntryDate |
EnrollmentEndDate | The student's enrollment end date at the school in MM/DD/YYYY format (if applicable). | [Students]ExitDate |
DistrictAssignedStudentEmailAddress | The district-assigned email address for the student. | [EmailAddress]EmailAddress |
SWDIndicator | Students With Disabilities indicator. Valid values: Y (Yes), N (No). Based on Program Code 144 or SWD Indicator field. | [S_CA_STU_X]SWDIndicator or [S_CA_STU_CALPADSPrograms_C]ProgramCode = 144 |
504ProgramIndicator | Section 504 Program participation indicator. Valid values: Y (Yes), N (No). Based on Program Code 101. | [S_CA_STU_X]Program504Indicator or [S_CA_STU_CALPADSPrograms_C]ProgramCode = 101 |
EL | English Learner indicator. Valid values: Y (Yes), N (No). Based on ELA status (RFEP = N, all others = Y). | [S_CA_STU_ELA_C]ELAStatus |
AB469OptOut | Assembly Bill 469 Opt-Out indicator. Valid values: Y (Yes), N (No). Default: N. | [S_CA_STU_X]AB469OptOut |
Homeless | Homeless student indicator. Valid values: Y (Yes), N (No). Based on Program Code 191. | [S_CA_STU_X]Homeless or [S_CA_STU_CALPADSPrograms_C]ProgramCode = 191 |
Migrant | Migrant student indicator. Valid values: Y (Yes), N (No). Based on Program Code 135. | [S_STU_X]Immigrant or [S_CA_STU_CALPADSPrograms_C]ProgramCode = 135 |
ParentGuardianEdLevel | The highest education level of the student's parent or guardian. | [S_CA_STU_X]ParentEd |