State Courses
This category represents the official course catalog for the state of Tennessee including state Course Codes, Course Titles and other related information as downloaded from the state in the Course resource within the Education Organization category.
State Course Listing
This view captures the valid list of Tennessee courses. In order to support the exchange of both current year information as well as student transcripts, courses from current and past years are included. The layout includes the State Course Code, Academic Subject Area, and State Course Title, along with the HS Course Requirement indicator, the number of Course Parts, and the Effective Begin and End Date for each course.
All course data that is subsequently published to the state from PowerSchool must bear a valid state course code. If a CourseCode does not match a CourseCode in the downloaded Course resource, it will typically result in an error and/or be prevented from publishing.
Course
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.
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
|---|---|---|---|---|
CourseCode | The code that identifies the organization of subject matter and related learning experiences provided for the instruction of students. This is typically the CourseCode in the downloaded Course resource, usually the state CourseCode. If local courses are included, this is the LEA CourseCode. | Varchar(60) | Data element downloaded from State Stored in: [CST_PubCourse]Code Also stored in: [Courses]Alt_Course_Number | M |
CourseTitle | The descriptive name given to a course of study offered in a school or other institution or organization. | Varchar(60) | Data element downloaded from State Stored in: [CST_PubCourse]Title The title may or may not match the local course title in PowerSchool. | R |
NumberOfParts | The number of parts identified for a course. | Integer | Data element downloaded from State Stored in: [CST_PubCourse]NumberOfParts Default: '1' | R |
AcademicSubject | AcademicSubjectDescriptor - The intended major subject area of the course. | Descriptor | Data element downloaded from State Stored in: [CST_PubCourse]AcadSubjectDesc | R |
CourseDescription | A description of the content standards and goals covered in the course. Reference may be made to state or national content standards. | Varchar(1024) | Data element downloaded from State Stored in: [CST_PubCourse]Description | O |
DateCourseAdopted | The date the district adopted the course. | Numeric | Data element downloaded from State Stored in: [CST_PubCourse]SchoolYear | O |
EducationOrganizationReference/EducationOrganizationIdentity | EducationOrganizationId - The Education Organization that defines the curriculum and courses offered; the SEA ID for downloaded or state-defined courses. | Integer | SEAId - Data element downloaded from State: '47' Stored in: [CST_PubCourse]EduOrgId | M |