CCGI Course Catalog Report
Overview
The CCGI Course Catalog Report is a California state-specific report designed to extract course catalog data elements for College Career Guidance Initiative (CCGI) submission. This report provides a comprehensive listing of all courses offered by the district/schools with details required for CCGI reporting.
Purpose
This report serves as a catalog file for CCGI submission, providing essential course information including:
Course identification and titles
Graduation requirements alignment (UC/CSU A-G)
Course credit values
Academic rigor designations (AP, IB, Honors)
School type and year information
Generate course catalog data for CCGI submission packages
Report Requirements
Important: Ensure all course records are up-to-date and courses not offered should be excluded from state reporting.
Eligibility
This report includes all courses from the district that are:
Not excluded from state reporting (course level and school level)
Available across all schools in the district
Report Input
Field | Description |
|---|---|
SFTP connections | Select the SFTP (Secure File Transfer Protocol) connection to use for uploading the report file. The report will be automatically uploaded to the selected SFTP server under the |
Note: This report has minimal input parameters. It automatically extracts all eligible courses from all schools in the district.
Report Output
Data Element | Description | [Table]FieldName |
|---|---|---|
CDSCode | The County-District-School (CDS) code where the course is offered. This is a 14-digit code combining the district number from system preferences and the school's state school number. If school number is missing, defaults to '0000000'. | [Prefs]DistrictNumber + [S_CA_SCH_X]StateSchoolNumber |
GraduationRequirements | The first character of the UC/CSU subject area code indicating graduation requirements category (e.g., 'A', 'B', 'C', 'D', 'E', 'F', 'G'). If not specified, displays "no data provided". | SUBSTR([S_CA_CRS_X]UCCSU_Area, 1, 1) |
Subject | The scheduled course subject area code. This typically represents the department or subject classification (e.g., ENG, MTH, SCI). | [Courses]Sched_CourseSubjectAreaCode |
CourseTitle | The course title as it should appear in the catalog. Priority order: 1. Transcript course name (if specified) 2. Course name 3. "no data provided" (if both are null) | [S_CA_CRS_X]TranscriptCourseName or [Courses]Course_Name |
Description | The course description/name. Uses the course name from the Courses table. If null, displays "no data provided". | [Courses]Course_Name |
CourseNumber | The local course number/identifier assigned by the district. If null, defaults to '9999'. | [Courses]Course_Number |
CourseDuration | The duration of the course (e.g., semester, year). Note: This field is currently reserved for future implementation and returns NULL. | N/A (Reserved - Currently NULL) |
Academic | Academic designation or classification. Note: This field is currently reserved for future implementation and returns NULL. | N/A (Reserved - Currently NULL) |
Credits | The number of credit hours awarded for successful completion of the course. | [Courses]Credit_Hours |
Honors | The academic rigor designation for the course. Values determined by: • Honors - If instructional level = 14 • AP - If AP/IB code reference description contains '(AP)' • IB - If AP/IB code reference description contains '(IB)' • NULL - If none of the above conditions are met | Calculated from [S_CA_CRS_X]NS_Instructional_Lvl and [PS_Common_Code]Description (CA_AB_IB_COURSE_CODES) |
Offered | Indicates whether the course is currently offered. All courses in the report have this set to 'Y' (Yes), as excluded courses are filtered out. | N/A (Calculated - Always 'Y') |
SchoolType | The type of school where the course is offered. Values: • Middle - If department grade level range = 'MID' • High - If department grade level range = 'SEC' • NULL - If not specified | [S_CA_CRS_X]Dept_Grade_Lvl_Range |
Year | The most recent school year from the system. Retrieved from the terms table for the district level (schoolid = 0) with the highest year ID. | [Terms]Name (where SchoolID = 0 and IsYearRec = 1, most recent) |
StateCourseCode | The California state course code. If alternate course number is specified, uses that value; otherwise defaults to '9999'. | [CoursesCoreFields]Alt_Course_Number |