PowerSchool SIS Georgia
PowerSchool SIS Georgia
Breadcrumbs

Organization Schedules

Information describing course offerings and sections available in schools.

Course Offerings

The courses available to students in each school for a specific term.

Primary PowerSchool Source Data

Core tables used in this resource:

  • [Courses]

  • [Sections]

  • [Terms]

  • [CC]

  • [S_GA_CC_X]

Selection Criteria

Business logic for publishing this resource:

  • Section must belong to the school being published

  • Section must not be excluded from reporting

  • Course must have students enrolled (CC records exist)

  • Term must match the year being published

  • Course number must not start with '00' (reserved codes)

  • Includes course override logic from S_GA_CC_X.CourseOverride

Resource Output

Expected output from the selection criteria:

  • courseReference - Reference to the course

  • schoolReference - Reference to the school

  • sessionReference - Reference to the academic term

  • localCourseCode - School-specific course code

  • localCourseTitle - School-specific course title

Automatic Publishing

Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.

Data Elements

Details of each data element published in this resource:

Data Element

Description

[Table]Data Type

Stored in [Table]Field

courseReference

Reference to the course in the course catalog

customobject

[Courses]DCID

educationOrganizationId

Organization ID where course is catalogued (typically LEA)

string

CourseOrgID - LEA organization ID

courseCode

Unique course code from course catalog

string

[Courses]Course_Number

schoolReference

Reference to the school offering this course

customobject

SchoolOrgID - formatted via formatLEASchoolID()

sessionReference

Reference to the academic term/session when course is offered

customobject

[Terms]Id

localCourseCode

School-specific code for the course offering (may differ from catalog code)

string

[Courses]Course_Number

localCourseTitle

School-specific title for the course offering

string

[Courses]Course_Name

Sections

Information describing sections taught in each school. Sections are specific instances of courses taught during a term.

Primary PowerSchool Source Data

Core tables used in this resource:

  • [Sections]

  • [Courses]

  • [terms]

  • [section_meeting]

  • [section_teacher]

  • [s_ga_cc_x]

  • [s_ga_crs_x]

Selection Criteria

Business logic for publishing this resource:

  • Section must belong to school being published

  • Section must not be excluded from reporting

  • Section must have meeting times defined

  • Section must have enrolled students (CC records)

  • Course number must not start with '00'

  • Term must match year being published

  • Course override logic creates UNION branches for alternate courses

Resource Output

Expected output from the selection criteria:

  • courseOfferingReference - Reference to the course offering

  • sectionIdentifier - Unique identifier for the section

  • sectionName - Section number or identifier

  • availableCredits - Credit value for the course

  • classPeriods - Array of class periods when section meets

  • characteristics - Array including online course indicator

Automatic Publishing

Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.

Data Elements

Details of each data element published in this resource:

Data Element

Description

[Table]Data Type

Stored in [Table]Field

courseOfferingReference

Reference to the course offering this section belongs to

customobject

[Courses]DCID | [Terms]DCID

sectionIdentifier

Unique identifier for the section within the school and term

string

[Sections]Id (DCID)

sectionName

Section number or display name

string

[Sections]Section_Number

availableCredits

Number of credits available for completing this section

number

[Sections]Credit_Hours or [Courses]CreditType

instructionLanguageDescriptor

Ed-Fi descriptor for the primary language of instruction (e.g., English, Spanish, Bilingual)

string

InstructLang_DX - mapped from [Sections]Language_Code

sectionCharacteristicDescriptor

Ed-Fi descriptor for section characteristics (e.g., Online course indicator)

string

OnlineCourse_DX from [S_GA_SEC_X]Online_Flag

classPeriods

Array of class periods during which this section meets

array

[Section_Period] and [Period]Joined via section ID

classPeriodName

Name of the period when section meets (nested in classPeriods)

string

[Period]Name from [Section_Period]Join

alternateEducationOrganizationId

GA extension: Alternate institution/system code if section is taught at alternate location (nested in _ext.Gadoe)

number

[S_GA_SEC_X]AltSysCode

classPeriodNumber

GA extension: Period number for scheduling (nested in _ext.Gadoe)

string

[Period]Period_Number