State Courses
This category represents the official course catalog for the state of Arizona, including state Course Codes, Course Titles, and other related information as downloaded from the state. The State Courses category includes the following data views and resources:
State Course Listing
This view captures the valid list of Arizona 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 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 be prevented from publishing.
courses
This course 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 the state Course Code in the downloaded course resource. | String | Data element downloaded from State Stored in: [CST_PubCourse]Code Also stored in: [Sections]AZ_CourseID [Courses]Alt_Course_Number | R |
courseTitle | The descriptive name given to a course of study offered in a school or other institution or organization. This is the state Course Title in the downloaded course resource. | String | State Course Title 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 |
academicSubjectDescriptor | The intended major subject area of the course. | Descriptor | Data element downloaded from State Stored in: [CST_PubCourse]AcadSubjectDesc Default: 'Other' | R |
courseDescription | A description of the content standards and goals covered in the course. Reference may be made to state or national content standards. | String | Data element downloaded from State Stored in: [CST_PubCourse]Description | O |
dateCourseAdopted | The date the district adopted the course. | Date | Data element downloaded from State Stored in: [CST_PubCourse]SchoolYear | O |
educationOrganizationReference/ | 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: '79275' Stored in: [CST_PubCourse]EduOrgID | R |