Skip to main content
Skip table of contents

Organization Info

This category provides information about SC districts and schools as published within the Education Organization category. The Education Organization category includes the following data views and resources:

Class Periods

This view captures the available class period meeting times reflected in the scheduling configurations for each school as published in the ClassPeriod resource within the Education Organization category. The layout provides the School Name, Period Name, and Period Number.

classPeriods

This resource represents the designation of a regularly scheduled series of class meetings at designated times and days of the week.

Primary PowerSchool Source Data

  • [Period]

  • [Schools]

  • [Cycle_Day]

Selection Criteria

Records are published if the following criteria are met:

  • The school must not be excluded from state reporting.

Resource Output

  • A single record is published for each unique class period at each school based on the year for the Term selected in the PowerSchool UI.

  • The courses resource is not dependent on the prior publishing of other Ed-Fi resources.

  • 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

classPeriods





classPeriodName

A unique number or alphanumeric code assigned to a classroom period of a typical daily session in which students receive instruction in a specified subject, for example, morning, sixth period, or block period.

Format: [school]school_number - [bsi]Bell_Schedule_ID - coalesce [per]abbreviation and [per]period_number - [cy]letter


Derived from school_number, period, cycle day, and Grades resource

Format:


schoolId

The school associated with this period.

Integer

Derived from:

[Period]SchoolID

R

  /startTime

The start time of the classroom period.


[BELL_SCHEDULE_ITEMS]start_time

R

  /endTime

The end time of the classroom period.


[BELL_SCHEDULE_ITEMS]end_time

R

officialAttendancePeriod

The code indicates whether it has to be counted for schools Daily Attendance.


[BELL_SCHEDULE_ITEMS]daily_attendance_code


locations





 schoolId

The school number of the associated school's record.


[SECTIONS]SCHOOLID

R

maximumNumberOfSeats

Maximum number of students who can be in the room.


[ROOM]occupancy_maximum (when set), or [SECTIONS]maxenrollment (if set)

R

classroomIdentificationCode

The identidication code for a classroom where the seciton is taught.


if wheretaughtdistrict or wheretaught is not null, then

CONCAT of [Section]wheretaughtdistrict and [Section]wheretaught

If either of those two fields are blank then '0000' is used for wheretaughtdistrcit and/or '000' for wheretaught.

R

    /yearID

The identifier for the school year.


[Cycle_Day]Year_ID

R

Programs

This view captures the program(s) that the students participate in or are served by. The layout provides the School Name, Program Type, and Program Name.

programs

This resource represents any program designed to work in conjunction with, or as a supplement to, the main academic program. Programs may provide instruction, training, services, or benefits through federal, state, or local agencies. Programs may also include organized extracurricular activities for students.

Primary PowerSchool Source Data

  • [Prefs]

Selection Criteria

Records are published if the following criteria are met:

  • The school must not be excluded from state reporting.

Resource Output

  • 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

educationOrganizationId

Relates the program to an Education Organization, typically the LEA.

Integer

[Prefs]Name=districtnumber

[Prefs]Value

[Gen]Value where cat=’districts’

[s_sc_stu_cate_x]cate_remoteschcode if not null, if null then [students]schoolid

R

programName

The formal name of the program of instruction, training, services, or benefits available.


If S_SC_STU_CATE_X.CATE_ConcntrInd1 or S_SC_STU_CATE_X.CATE_CompleterInd1 is NOT NULL then programName='CTE Program 1',




If S_SC_STU_CATE_X.CATE_ConcntrInd2 or S_SC_STU_CATE_X.CATE_CompleterInd2 is NOT NULL then programName='CTE Program 2';




If s_sc_stu_wbl_x.wbl_expodeccr is ‘C’ then programname = ‘C-Cooperative Education, 




If s_sc_stu_wbl_x.wbl_expodeccr is ‘I’ then programname = ‘I-Internship’, 




If s_sc_stu_wbl_x.wbl_expodeccr is ‘R’ programname = ‘R-Registered Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expodeccr is ‘Y’ then programname = ‘Y-Youth Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expode1 is ‘C’ then programname = ‘C-Cooperative Education, 




If s_sc_stu_wbl_x.wbl_expode1 is ‘I’ then programname = ‘I-Internship’, 




If s_sc_stu_wbl_x.wbl_expode1 is ‘R’ programname = ‘R-Registered Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expode1 is ‘Y’ then programname = ‘Y-Youth Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expode1 is ‘B’ then programname = ‘B-CTE Internship Credit Bearing Course’, 




If s_sc_stu_wbl_x.wbl_expode1 is ‘F’ then programname = ‘F-School-Based Enterprise, 




If s_sc_stu_wbl_x.wbl_expode1 is ‘L’ then programname = ‘L-Service Learning’, 




If s_sc_stu_wbl_x.wbl_expode1 is ‘M’ then programname = ‘M-Mentoring’, 




If s_sc_stu_wbl_x.wbl_expode1 is ‘S’ then programname = ‘S-Shadowing: On-Site’, 




If s_sc_stu_wbl_x.wbl_expode1 is ‘U’ then programname = ‘U-Structured Field Study’, 




If s_sc_stu_wbl_x.wbl_expode1 is ‘V’ then programname = ‘V-Shadowing: Virtual’; 




If s_sc_stu_wbl_x.wbl_expode2 is ‘C’ then programname = ‘C-Cooperative Education, 




If s_sc_stu_wbl_x.wbl_expode2 is ‘I’ then programname = ‘I-Internship’, 




If s_sc_stu_wbl_x.wbl_expode2 is ‘R’ programname = ‘R-Registered Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expode2 is ‘Y’ then programname = ‘Y-Youth Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expode2 is ‘B’ then programname = ‘B-CTE Internship Credit Bearing Course’, 




If s_sc_stu_wbl_x.wbl_expode2 is ‘F’ then programname = ‘F-School-Based Enterprise, 




If s_sc_stu_wbl_x.wbl_expode2 is ‘L’ then programname = ‘L-Service Learning’, 




If s_sc_stu_wbl_x.wbl_expode2 is ‘M’ then programname = ‘M-Mentoring’, 




If s_sc_stu_wbl_x.wbl_expode2 is ‘S’ then programname = ‘S-Shadowing: On-Site’, 




If s_sc_stu_wbl_x.wbl_expode2 is ‘U’ then programname = ‘U-Structured Field Study’, 




If s_sc_stu_wbl_x.wbl_expode2 is ‘V’ then programname = ‘V-Shadowing: Virtual’; 




If s_sc_stu_wbl_x.wbl_expode3 is ‘C’ then programname = ‘C-Cooperative Education, 




If s_sc_stu_wbl_x.wbl_expode3 is ‘I’ then programname = ‘I-Internship’, 




If s_sc_stu_wbl_x.wbl_expode3 is ‘R’ programname = ‘R-Registered Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expode3 is ‘Y’ then programname = ‘Y-Youth Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expode3 is ‘B’ then programname = ‘B-CTE Internship Credit Bearing Course’, 




If s_sc_stu_wbl_x.wbl_expode3 is ‘F’ then programname = ‘F-School-Based Enterprise, 




If s_sc_stu_wbl_x.wbl_expode3 is ‘L’ then programname = ‘L-Service Learning’, 




If s_sc_stu_wbl_x.wbl_expode3 is ‘M’ then programname = ‘M-Mentoring’, 




If s_sc_stu_wbl_x.wbl_expode3 is ‘S’ then programname = ‘S-Shadowing: On-Site’, 




If s_sc_stu_wbl_x.wbl_expode3 is ‘U’ then programname = ‘U-Structured Field Study’, 




If s_sc_stu_wbl_x.wbl_expode3 is ‘V’ then programname = ‘V-Shadowing: Virtual’; 




 




If s_sc_stu_wbl_x.wbl_expode4 is ‘C’ then programname = ‘C-Cooperative Education, 




If s_sc_stu_wbl_x.wbl_expode4 is ‘I’ then programname = ‘I-Internship’, 




If s_sc_stu_wbl_x.wbl_expode4 is ‘R’ programname = ‘R-Registered Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expode4 is ‘Y’ then programname = ‘Y-Youth Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expode4 is ‘B’ then programname = ‘B-CTE Internship Credit Bearing Course’, 




If s_sc_stu_wbl_x.wbl_expode4 is ‘F’ then programname = ‘F-School-Based Enterprise, 




If s_sc_stu_wbl_x.wbl_expode4 is ‘L’ then programname = ‘L-Service Learning’, 




If s_sc_stu_wbl_x.wbl_expode4 is ‘M’ then programname = ‘M-Mentoring’, 




If s_sc_stu_wbl_x.wbl_expode4 is ‘S’ then programname = ‘S-Shadowing: On-Site’, 




If s_sc_stu_wbl_x.wbl_expode4 is ‘U’ then programname = ‘U-Structured Field Study’, 




If s_sc_stu_wbl_x.wbl_expode4 is ‘V’ then programname = ‘V-Shadowing: Virtual’; 




If s_sc_stu_wbl_x.wbl_expode5 is ‘C’ then programname = ‘C-Cooperative Education, 




If s_sc_stu_wbl_x.wbl_expode5 is ‘I’ then programname = ‘I-Internship’, 




If s_sc_stu_wbl_x.wbl_expode5 is ‘R’ programname = ‘R-Registered Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expode5 is ‘Y’ then programname = ‘Y-Youth Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expode5 is ‘B’ then programname = ‘B-CTE Internship Credit Bearing Course’, 




If s_sc_stu_wbl_x.wbl_expode5 is ‘F’ then programname = ‘F-School-Based Enterprise, 




If s_sc_stu_wbl_x.wbl_expode5 is ‘L’ then programname = ‘L-Service Learning’, 




If s_sc_stu_wbl_x.wbl_expode5 is ‘M’ then programname = ‘M-Mentoring’, 




If s_sc_stu_wbl_x.wbl_expode5 is ‘S’ then programname = ‘S-Shadowing: On-Site’, 




If s_sc_stu_wbl_x.wbl_expode5 is ‘U’ then programname = ‘U-Structured Field Study’, 




If s_sc_stu_wbl_x.wbl_expode5 is ‘V’ then programname = ‘V-Shadowing: Virtual’; 




If s_sc_stu_wbl_x.wbl_expode6 is ‘C’ then programname = ‘C-Cooperative Education, 




If s_sc_stu_wbl_x.wbl_expode6 is ‘I’ then programname = ‘I-Internship’, 




If s_sc_stu_wbl_x.wbl_expode6 is ‘R’ programname = ‘R-Registered Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expode6 is ‘Y’ then programname = ‘Y-Youth Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expode6 is ‘B’ then programname = ‘B-CTE Internship Credit Bearing Course’, 




If s_sc_stu_wbl_x.wbl_expode6 is ‘F’ then programname = ‘F-School-Based Enterprise, 




If s_sc_stu_wbl_x.wbl_expode6 is ‘L’ then programname = ‘L-Service Learning’, 




If s_sc_stu_wbl_x.wbl_expode6 is ‘M’ then programname = ‘M-Mentoring’, 




If s_sc_stu_wbl_x.wbl_expode6 is ‘S’ then programname = ‘S-Shadowing: On-Site’, 




If s_sc_stu_wbl_x.wbl_expode6 is ‘U’ then programname = ‘U-Structured Field Study’, 




If s_sc_stu_wbl_x.wbl_expode6 is ‘V’ then programname = ‘V-Shadowing: Virtual’; 




If s_sc_stu_wbl_x.wbl_expode7 is ‘C’ then programname = ‘C-Cooperative Education, 




If s_sc_stu_wbl_x.wbl_expode7 is ‘I’ then programname = ‘I-Internship’, 




If s_sc_stu_wbl_x.wbl_expode7 is ‘R’ programname = ‘R-Registered Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expode7 is ‘Y’ then programname = ‘Y-Youth Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expode7 is ‘B’ then programname = ‘B-CTE Internship Credit Bearing Course’, 




If s_sc_stu_wbl_x.wbl_expode7 is ‘F’ then programname = ‘F-School-Based Enterprise, 




If s_sc_stu_wbl_x.wbl_expode7 is ‘L’ then programname = ‘L-Service Learning’, 




If s_sc_stu_wbl_x.wbl_expode7 is ‘M’ then programname = ‘M-Mentoring’, 




If s_sc_stu_wbl_x.wbl_expode7 is ‘S’ then programname = ‘S-Shadowing: On-Site’, 




If s_sc_stu_wbl_x.wbl_expode7 is ‘U’ then programname = ‘U-Structured Field Study’, 




If s_sc_stu_wbl_x.wbl_expode7 is ‘V’ then programname = ‘V-Shadowing: Virtual’; 




If s_sc_stu_wbl_x.wbl_expode8 is ‘C’ then programname = ‘C-Cooperative Education, 




If s_sc_stu_wbl_x.wbl_expode8 is ‘I’ then programname = ‘I-Internship’, 




If s_sc_stu_wbl_x.wbl_expode8 is ‘R’ programname = ‘R-Registered Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expode8 is ‘Y’ then programname = ‘Y-Youth Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expode8 is ‘B’ then programname = ‘B-CTE Internship Credit Bearing Course’, 




If s_sc_stu_wbl_x.wbl_expode8 is ‘F’ then programname = ‘F-School-Based Enterprise, 




If s_sc_stu_wbl_x.wbl_expode8 is ‘L’ then programname = ‘L-Service Learning’, 




If s_sc_stu_wbl_x.wbl_expode8 is ‘M’ then programname = ‘M-Mentoring’, 




If s_sc_stu_wbl_x.wbl_expode8 is ‘S’ then programname = ‘S-Shadowing: On-Site’, 




If s_sc_stu_wbl_x.wbl_expode8 is ‘U’ then programname = ‘U-Structured Field Study’, 




If s_sc_stu_wbl_x.wbl_expode8 is ‘V’ then programname = ‘V-Shadowing: Virtual’; 




If s_sc_stu_wbl_x.wbl_expode9 is ‘C’ then programname = ‘C-Cooperative Education, 




If s_sc_stu_wbl_x.wbl_expode9 is ‘I’ then programname = ‘I-Internship’, 




If s_sc_stu_wbl_x.wbl_expode9 is ‘R’ programname = ‘R-Registered Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expode9 is ‘Y’ then programname = ‘Y-Youth Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expode9 is ‘B’ then programname = ‘B-CTE Internship Credit Bearing Course’, 




If s_sc_stu_wbl_x.wbl_expode9 is ‘F’ then programname = ‘F-School-Based Enterprise, 




If s_sc_stu_wbl_x.wbl_expode9 is ‘L’ then programname = ‘L-Service Learning’, 




If s_sc_stu_wbl_x.wbl_expode9 is ‘M’ then programname = ‘M-Mentoring’, 




If s_sc_stu_wbl_x.wbl_expode9 is ‘S’ then programname = ‘S-Shadowing: On-Site’, 




If s_sc_stu_wbl_x.wbl_expode9 is ‘U’ then programname = ‘U-Structured Field Study’, 




If s_sc_stu_wbl_x.wbl_expode9 is ‘V’ then programname = ‘V-Shadowing: Virtual’; 




If s_sc_stu_wbl_x.wbl_expode10 is ‘C’ then programname = ‘C-Cooperative Education, 




If s_sc_stu_wbl_x.wbl_expode10 is ‘I’ then programname = ‘I-Internship’, 




If s_sc_stu_wbl_x.wbl_expode10 is ‘R’ programname = ‘R-Registered Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expode10 is ‘Y’ then programname = ‘Y-Youth Apprenticeship’, 




If s_sc_stu_wbl_x.wbl_expode10 is ‘B’ then programname = ‘B-CTE Internship Credit Bearing Course’, 




If s_sc_stu_wbl_x.wbl_expode10 is ‘F’ then programname = ‘F-School-Based Enterprise, 




If s_sc_stu_wbl_x.wbl_expode10 is ‘L’ then programname = ‘L-Service Learning’, 




If s_sc_stu_wbl_x.wbl_expode10 is ‘M’ then programname = ‘M-Mentoring’, 




If s_sc_stu_wbl_x.wbl_expode10 is ‘S’ then programname = ‘S-Shadowing: On-Site’, 




If s_sc_stu_wbl_x.wbl_expode10 is ‘U’ then programname = ‘U-Structured Field Study’, 




If s_sc_stu_wbl_x.wbl_expode10 is ‘V’ then programname = ‘V-Shadowing: Virtual’;


If [S_SC_STU_X]Title1MathInd or [S_SC_STU_X]Title1ReadInd or [S_SC_STU_X]Title1AsstTypeCode or [S_SC_STU_X]Title1AsstTypeCode is not null then studentTitleIPartAProgramAssociations

If [S_SC_STU_X]InstrSetting is not null then Special Education

If [S_SC_STU_X]night_residence is not null then Homeless Program

If [S_SC_STU_X]Engl_Prof,1,1) not in ('8','9') then ESOL

R

programTypeDescriptor

The type of program.

String

CTE:

If S_SC_STU_CATE_X.CATE_ConcntrInd1 or S_SC_STU_CATE_X.CATE_CompleterInd1 is NOT NULL then programTypeDescriptor='CTE Program 1',




If S_SC_STU_CATE_X.CATE_ConcntrInd2 or S_SC_STU_CATE_X.CATE_CompleterInd2 is NOT NULL then programTypeDescriptor='CTE Program 2';

Special Program:




if SpEnrollments.ProgramID NOT NULL then ProgramTypeDescriptor = ‘Special Program’;




If s_sc_stu_wbl_x.wbl_expcodeccr is NOT NULL then programTypeDescriptor ='WBL CR Experience'; 




If s_sc_stu_wbl_x.wbl_expcode1 is NOT NULL then programTypeDescriptor='WBL 1', 




If s_sc_stu_wbl_x.wbl_expcode2 is NOT NULL then programTypeDescriptor='WBL 2', 




If s_sc_stu_wbl_x.wbl_expcode3 is NOT NULL then programTypeDescriptor='WBL 3', 




If s_sc_stu_wbl_x.wbl_expcode4 is NOT NULL then programTypeDescriptor='WBL4', 




If s_sc_stu_wbl_x.wbl_expcode5 is NOT NULL then programTypeDescriptor='WBL5', 




If s_sc_stu_wbl_x.wbl_expcode6 is NOT NULL then programTypeDescriptor='WBL6', 




If s_sc_stu_wbl_x.wbl_expcode7 is NOT NULL then programTypeDescriptor='WBL7', 




If s_sc_stu_wbl_x.wbl_expcode8 is NOT NULL then programTypeDescriptor='WBL8', 




If s_sc_stu_wbl_x.wbl_expcode9 is NOT NULL then programTypeDescriptor='WBL9', 




If s_sc_stu_wbl_x.wbl_expcode10 is NOT NULL then programTypeDescriptor='WBL10';

Special Education:

If [S_SC_STU_X]InstrSetting,1,2='SE' then ProgramTypeDescriptor = 'Special Education Enrollment'




If [S_SC_STU_X]InstrSetting,1,2='SR' then ProgramTypeDescriptor = 'Special Education Enrollment'




If [S_SC_STU_X]InstrSetting,1,2='SP' then ProgramTypeDescriptor = 'Special Education Enrollment'




If [S_SC_STU_X]InstrSetting,1,2='RS' then ProgramTypeDescriptor = 'Special Education Enrollment'




If [S_SC_STU_X]InstrSetting,1,2='RP' then ProgramTypeDescriptor = 'Special Education Enrollment'




If [S_SC_STU_X]InstrSetting,1,2='PR' then ProgramTypeDescriptor = 'Special Education Enrollment'




If [S_SC_STU_X]InstrSetting,1,2='PS' then ProgramTypeDescriptor = 'Special Education Enrollment'




If [S_SC_STU_X]InstrSetting,1,2='504' then ProgramTypeDescriptor = 'Special Education Enrollment'

TitleIPartA:

If [S_SC_STU_X]Title1MathInd = 'Y' then ProgramTypeDescriptor = 'Mathematics Instructional Services'

If [S_SC_STU_X]Title1ReadInd='Y' then ProgramTypeDescriptor ='Reading/Language Instructional Services'

If [S_SC_STU_X]Title1AsstTypeCode = 'T' then ProgramTypeDescriptor = 'Public Targeted Assistance Program' else ProgramTypeDescriptor = "Was not served"

If [S_SC_STU_X]Title1AsstTypeCode = 'T' then ProgramTypeDescriptor = 'Public Targeted Assistance Program' else ProgramTypeDescriptor = "Was not served"

Homeless Program: If [S_SC_STU_X]night_residence is not null then Homeless Program

ESOL: If [S_SC_STU_X]Engl_Prof,1,1) not in ('8','9')

R


JavaScript errors detected

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

If this problem persists, please contact our support.

Contact Support Close