CCGI Course Catalog Report | PowerSchool SIS Compliance

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 `/course_catalog/` directory upon completion. This is a required field.

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