Skip to main content
Skip table of contents

Organization Schedules

This category captures the organization course, section, and bell schedule information for the school year. The Organization Schedules category includes the following data views and resources:

Course Offerings

This view captures the detailed list of Course Offerings as published in the CourseOffering resource within the Organization Schedules category. The layout includes the School Name, Course Number, Course Name, and Term.

courseOfferings

This resource represents an entry in the course catalog of available courses offered by the school during a session. A separate Course Offering record is published for each unique combination of course and section scheduled at each school.

Primary PowerSchool Source Data

  • [Courses]

  • [Sections]

  • [Terms]

  • [COURSESCOREFIELDS]

Selection Criteria

Records are published if the following criteria are met:

  • The school where the course is offered must not be excluded from state reporting.

  • The course is offered during the year for the Term selected in the PowerSchool UI.

  • The course is not excluded from Ed-Fi, where S_CRS_X.excludefromedfi is not 1.

Resource Output

  • A separate Course Offering record is published for each unique combination of course and term scheduled at each school.

Note: In PowerSchool, CourseOffering records are derived from section, course, and term records. A single CourseOffering record is published for all sections of a course offered during the same term.

  • The CourseOfferring resource is dependent on the prior publishing of the following resources: Sessions and Courses.

  • 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

Data Type

Stored in [Table]Field

Req'd

schoolId

The school that offers the course.

Schools with a six-digit school id and preferixed with 700 are published as DISTID+700


Integer

State-assigned value based on [Sections]schoolid

R

localCourseCode

The local code assigned by the LEA that identifies the organization of subject matter and related learning experiences provided for the instruction of students.

String

[Courses]Course_Number

CoursesCoreFields.Alt_Course_Number

R

courseReference

R

/courseCode

The course being offered by the school.

String

[COURSESCOREFIELDS]alt_course_number
if not set then [COURSES]course_number

R

/educationOrganizationId

The Education Organization that defines the curriculum and courses offered - often the LEA or school. This organization identifier matches the EducationOrganizationId in the Course resource, usually the SEAId.

Integer

[Prefs]Name=districtnumber
[Prefs]Value

R

sessionReference

R

/schoolId

The school for the section's classroom.

Integer

Derived from:
[Terms]SchoolId

R

/schoolYear

The identifier for the school year.

Type

[Terms]YearId

R

/sessionName

The type of the session.

Format: [TERMS]schooled - [TERMS]abbreviation - [TERMS]dcid

Descriptor

Composite based on

[TERMS]schooled

[TERMS]abbreviation

[TERMS]dcid

R

localCourseTitle

The descriptive name given to a course of study offered in the school, if different from the CourseTitle.

String

[Courses]Course_Name

O

courseLevelCharacteristics

/courseLevelCharacteristicDescriptor



Derived from [COURSES]course_number


OfferedGradeLevels

/gradeLevelDescriptor

List of grades that this course applies to.


Derived from [COURSES]course_number

first character = '1' then report grade levels 0 through 6
If first character = '2' then report grade levels 7 and 8
If first character IN ('3','4','5','6','8') then report grade levels 9 through 12


Course

This view captures all courses along with the course codes offered in South Carolina and as published in the Course resource within the Organization Schedules category. The layout includes the School Name, Course Number, Course Name, Suject Area, Course Identifier, Last Publish Date, Publishing ID, and Resource ID.

course

This resource represents an entry in the course catalog of the courses offered by the school during a session. A separate Course Offering record is published for each unique combination of course and section scheduled at each school.

Primary PowerSchool Source Data

  • [Courses]

  • [courseidentificationcode]

Selection Criteria

Records are published if the following criteria are met:

  • The school where the course is offered must not be excluded from state reporting.

  • The course is not excluded from Ed-Fi, where S_CRS_X.excludefromedfi is not 1.

Resource Output

  • A separate course record is published for each unique course number in the district.

  • LEAs 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

Data Type

Stored in [Table]Field

Req'd

courseCode

A unique alphanumeric code assigned to a course.

String

[Courses]Course_Number


identificationCodes





 /courseIdentificationSystemDescriptor

The course being offered by the school.

String

uri://ed-fi.org/CourseIdentificationSystemDescriptor

[Courses]Course_Number

uri://ed.sc.gov/CreditTypeDescriptor

If [StoredGrades]Credit_Type is not null


 /identificationCodes

A unique number or alphanumeric code assigned to a course by the school, school system, state, or other agency or entity. For multi-part course codes, concatenate the parts separated by a "/".

For example, consider the following SCED code- subject = 20, Math course = 272, Geometry level = G, and General credits = 1.00, then course sequence 1 of 1 is entered as 20/272/G/1.00/1 of 1.

String

[courseidentificationcode]identificationcode

[StoredGrades]Credit_Type


educationOrganizationReference

 /educationOrganizationID

The identifier assigned to an education organization.

Integer

[Courses]educationorganizationid


courseTitle

The name of the course offered in the school or other institution or organization.

String

[Course]coursetitle


numberOfParts

The number of parts identified for a course.

Integer

[Course]numberofparts

Hardcode '1'


Sections

This view captures the course sections offered at each school as published in the sections resource of the Organization Schedules category. The layout includes School Name, Course Name, Course Number, Section Number, Term, Period Number, Last Publish Date, Publishing ID, and Resource ID.

sections

This resource represents a setting in which organized instruction of course content is provided, in-person or otherwise, to one or more students for a given period of time. In Ed-Fi, a course offering may be scheduled for more than one section, but for PowerSchool there is currently a one-to-one correspondence between each course offering and its corresponding section.

Primary PowerSchool Source Data

  • [Sections]

  • [Courses]

  • [Terms]

  • [Period]

Selection Criteria

Records are published if the following criteria are met:

  • The school where the section is taught must not be excluded from state reporting.

  • The section must not be excluded from state reporting.

  • The section is taught during the year for the Term selected in the PowerSchool UI.

Resource Output

  • A separate sections record is published for each unique combination of school, course, and section based on the year for the Term selected in the PowerSchool UI.

  • The sections resource is dependent on the prior publishing of the following resources: courseOffering, location, and classPeriods.

  • 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

Data Type

Stored in [Table]Field

Req’d

schoolID

The school for the class period.

Schools with a six-digit school id and preferixed with 700 are published as DISTID+700


Integer

Derived from:

[Sections]SchoolID

R

sectionIdentifier

Unique identifier of a section.

FORMAT: [sec]schoolid - [crs]course_number - [sec]section_number - [sec].dcid

String

Composite based on [SECTIONS]schoolid, course_number, section_number, dcid

R

courseOfferingReference

A reference to the related courseOffering resource.

R

/localCourseCode

The code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students.

String

[Courses]Course_Number

[CoursesCoreFields]Alt_Course_Number

R

/schoolID

State-assigned for the school offering the course.

Integer

Derived from:

[SECTIONS]SchoolID

R

/schoolYear

The identifier for the school year.

Type

[Terms]YearID + 1991

R

/sessionname

An indication of the portion of a typical daily session in which students receive instruction in a specified subject. For example, morning, sixth period, block period, or AB schedules.

Format: [Terms]schoolid - [Terms]abbreviation - [Terms]dcid

String

Composite based on [TERMS]schoolid, [TERMS]abbreviation, [TERMS]dcid

R

courseLevelCharacteristics

/courseLevelCharacteristicDescriptor

Indication of the nature and difficulty of instruction: Remedial, Basic, Honors, Ap, IB, Dual Credit, CTE, etc.


sectioncourselevelcharacteristic.courselevelcharcteristicdescriptorId

excludeADA: [sec]Exclude_ADA
genderRestricted: [sc_sec]GenderRestricted
homeroom: [sc_sec]Homeroom
excludedFromGPA: [sec]excludefromgpa

R

OfferedGradeLevels

gradeLevelDescriptor

The grade levels of students either enrolled in the course or for which the course is targeted.


[COURSES]course_number

If first character is '1' then report grade levels 0 through 6
If first character is '2' then report grade levels 7 and 8
If first character IN ('3','4','5','6','8') then report grade levels 9 through 12

R

availableCredits

Credits or units of value awarded for the completion of a course.


[COURSES]credit_hours


educationalEnvironmentDescriptor

The setting in which a student receives education and related services; defaults to 'Classroom' if blank.


coalesce[S_SEC_EDFI_X]EducationalEnvironment if populated

Otherwise, 'Classroom'


sequenceOfCourse

If a section is part of a sequence of parts for a course, the number in the sequence. If the course has only one part, the value should be 1.


coalesce [S_SEC_X]sced_sequence or 1


mediumOfInstructionDescriptor

Identifies the instructional type for this section.


[sc_sec]InstrType


classPeriods/classPeriodReference

/classPeriodName

An indication of the portion of a typical daily session in which students receive instruction in a specified subject. For example, morning, sixth period, block period, or AB schedules.

Format: [sch]school_number - coalesce( [per]abbreviation, [per]period_number ) - [cy]letter


Composite based on school_number, period, and cycle day

R

/SchoolID

State-assigned for the school offering the course.

Schools with a six-digit school id and preferixed with 700 are published as DISTID+700



Derived from:

[SECTIONS]SchoolID

R

offeredGradeLevels

/gradeLevelDescriptor

The ID for the grade scale attached to this course.


[SECTIONS]COURSE_NUMBER

If first character = '1' then report grade levels 0 through 6

If first character = '2' then report grade levels 7 and 8

If first character IN ('3','4','5','6','8') then report grade levels 9 through 12


locationSchoolReference

/schoolid

State-assigned for the school offering the course.



[SECTIONS]SchoolID


locationReference

/classroomIdentificationCode

A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or resource.


[SECTIONS]wheretaughtdistrict

if wheretaughtdistrict or wheretaught is NOT NULL, then CONCAT (sec.wheretaughtdistrict, sec.wheretaught). If either of those two fields are blank then use '0000' for wheretaughtdistrcit and/or '000' for wheretaught.


Bell Schedules

This view captures the details on the bell schedules for each grade level within each school, and for each date in the school calendar as published in the BellSchedule resource within the Organization Schedules category. The layout includes School Name, School ID and Bell Schedule.

bellSchedules

This resource represents the schedule of class period meeting times.

Primary PowerSchool Source Data

  • [Bell_Schedule]

  • [Cycle_Day]

  • [Period]

Selection Criteria

Records are published if the following criteria are met:

  • The school must not be excluded from state reporting.

  • The bell schedule exists within the year for the Term selected in the PowerSchool UI.

Resource Output

  • A separate BellSchedule record is published for each unique BellSchedule defined at each school, for each grade level, and for each date that the BellSchedule is in use during the year for the Term selected in the PowerSchool UI.

  • 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

Data Type

Stored in [Table]Field

Req'd

bellScheduleName

Name or title of the bell schedule.

Format: [Bell_Schedule]schoolid - [Bell_Schedule]name - [Cycle_Day]letter


Derived

Composite based on school number, bell schedule name, and cycle day.

R

classPeriods


/classPeriodName

Composite based on school number, period abbreviation/number, and cycle day.

Format: [sec]schoolid - coalesce([Period]abbreviation, [Period]period_number ) - [Cycle_Day]letter


Derived

R

/schoolId

State-assigned value based on [PERIOD]schoolid.

Integer

Derived from:
[PERIOD]schoolid

R

schoolReference

/schoolId

State-assigned value for the school for which the bell schedule is defined.

Schools with a six-digit school id and preferixed with 700 are published as DISTID+700



Based on [Bell_Schedule]schoolId

R

alternateDayName



[Cycle_Day]letter


dates

/date

The in session dates for which the Bell Schedule is published.


[bellscheduledate]date

Derived from calendar_day


totalInstructionalTime

The total instructional time in minutes per day for the bell schedule.


Derived from [Bell_Schedule]

Sum of durations of all periods marked as Counts for ADA within the bell schedule.



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.