Local Course Catalog
This view captures the entries into the course catalog for the courses offered by the LEA/District during a session. The layout provides the School Name, Course Number, Course Name, Minimum Available Credits, Maximum Available Credits, Course Identifier, Last Publish Date, Publishing ID, and Resource ID.
courses
This educational resource represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.
Primary PowerSchool Source Data
Tables:
COURSES (crs),
COURSESCOREFIELDS (ccf),
S_TX_CRS_X (crsx),
CST_PUBCOURSE (cst)
Selection Criteria
Records are published if the following criteria are met:
The school must not be excluded from state reporting.
The course is not excluded from Ed-Fi.
Courses with alt_course_number will be published.
Resource Output
A single record is published for each course defined in the school course catalog for the selected school year.
The courses resource is dependent on the prior publishing of Ed-Fi resources: localEducationAgencies.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | TX Element | Data Type | Stored in [Table]Field | Required? |
|---|---|---|---|---|---|
educationOrganizationReference A reference to the related educationOrganization resource. | Required | ||||
/educationOrganizationID | The Education Organization that defines the curriculum and courses offered. | Integer | Derived from: If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: | Required | |
courseCode | The code that identifies the organization of subject matter and related learning experiences provided for the instruction of students. | String | ccf.alt_course_number | Required | |
courseIdentificationSystemDescriptor | Descriptor - Publish local and state identifiers | E1089 | Descriptor | ''LEA course code'; 'State course code' | Required |
identificationCode - LEA Code | Local Educational Agency (LEA) Code. | E1194 | String | crs.course_number | Required |
identificationCode - State Code | The state code. | E0724 | String | CoursesCoreFields.alt_course_number | Required |
educationOrganizationId | The LEA of which the school is an organizational component | E0266 | Integer | Derived from: [Prefs]Name=DistrictNumber | Required |
academicSubjectDescriptor | Academic subject Descriptor | N/A | Descriptor | PS source for TX: | Optional |
courseTitle | The descriptive name given to a course of study offered in a school or other institution or organization. | String | [crs]Course_Name | Required | |
courseLevelCharacteristicDescriptor | |||||
minimumAvailableCredits | The minimum amount of credit available to a student who successfully completes the course. | Number | crs.maxcredit | Optional | |
maximumAvailableCredits | The maximum amount of credit available to a student who successfully completes the course. | Number | crs.credit_hours | Optional | |
courseIdentificationCodes An unordered collection of courseIdentificationCodes. A standard code that identifies the organization of subject matter and related learning experiences provided for the instruction of students. | |||||
/courseIdentification | A unique number or alphanumeric code that is reflects the entity authorizing the course. | Descriptor | 'LEA course code' 'State course code' | Required | |
/identificationCode | A unique number or alphanumeric code assigned to a space, room, site, building, individual, organization, program, or institution by a school, school system, a state, or other agency or entity. | String | [Courses]Course_Number [Courses]Alt_Course_Number | Required | |