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_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', Special Program: Special Education: If [S_SC_STU_X]InstrSetting,1,2='SE' 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 |
Schools
This view captures a detailed list of schools defined in PowerSchool. The layout includes the School Name and school ID.
This resource represents an educational organization that includes staff and students who participate in classes and educational activity groups.
Primary PowerSchool Source Data
[Schools]
Selection Criteria
Records are published if the following criteria are met:
This resource has no specific selection criteria.
Resource Output
The schools resource is dependent on the prior publishing of the following resources: localEducationAgencies.
LEAs and Schools may upload (publish) data to the 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 |
|---|---|---|---|---|
educationOrganizationCategories | String | [Schools]IsSummerSchool If [Schools]IsSummerSchool = 1 then educationOrganizationCategoryDescriptor = Summer School [Schools]State_ExcludeFromReporting If [schools]State_ExcludeFromReporting = 1 then educationOrganizationCategoryDescriptor = Exclude From Reporting If neither Summer School or Exclude from Reporting is selected then educationOrganizationCategoryDescriptor = Independent | R | |
gradeLevels | The grade levels of students. | String | uri://ed.sc.gov/GradeLevelDescriptor | R |
schoolId | The state-assigned value for the school. | Numeric | [Schools]SCHOOLID | R |
nameOfInstitution | The name of the school. | String | [Schools]NAME | R |
Address /educationOrganizationAddress | ||||
addressTypeDescriptor | Physical | [Schools]name Physical | ||
stateAbbreviationDescriptor | SC | [Schools]name SC | ||
city | The city where school is located. | [Schools]schoolcity | ||
postalCode | The zip code of the school. | [Schools]schoolzip | ||
streetNumberName | The school’s street address. | [Schools]schooladdress | ||