Resource Overview
-
Ed-Fi endpoint:
/data/v3/sections -
Published view/entity: Section
-
Purpose: Information describing sections taught in each school
-
Source query:
Section -
Dependencies:
courseOfferings,locations
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 a one-to-one correspondence between each course offering and its corresponding section.
Note: The Ed-Fi publishing process attempted to publish sections without a section meeting, resulting in a dependency on course offerings at the section level. The publishing process has been updated to ignore sections that do not have an expression set.
Primary PowerSchool Source Data
-
[Sections]
-
[Courses]
-
[S_TN_SEC_X]
-
[S_TN_SEC_HONORS_X]
-
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.
-
The course must have a valid state course code.
Resource Output
|
Data Element (Ed-Fi target) |
Data View Column Name |
Submission |
[Table]Field (PowerSchool Source) |
Business Rules |
Comments |
|---|---|---|---|---|---|
|
courseOfferingReference.localCourseCode |
LocalCourseCode |
Y |
[Courses]DCID; [Courses]Course_Number; [Sections]DCID; [Sections]ID; [Sections]Section_Number; Transformation: EDFI_TN_LIB.formaLocalCourseCode(p_profileid, crs.dcid, crs.course_number, p_yearid, sec.dcid, sec.id, sec.section_number) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: LocalCourseCode. |
|
courseOfferingReference.schoolId |
SchoolOrgID |
Y |
Publishing framework or supporting query Query alias: SchoolOrgID |
Required by the production resource definition when the resource is published. |
JSON type: number. Query alias: SchoolOrgID. |
|
courseOfferingReference.schoolYear |
SchoolYear |
Y |
Staging rule: Sections p_yearid + 1991 |
Required by the production resource definition when the resource is published. |
JSON type: number. Query alias: SchoolYear. |
|
courseOfferingReference.sessionName |
SessionName |
Y |
[CST_PUBPUBLISHED_TMP]RUNTIMEPROP_7 |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: SessionName. |
|
locationReference.schoolId |
SchoolOrgID |
Y |
Publishing framework or supporting query Query alias: SchoolOrgID |
Required by the production resource definition when the resource is published. |
JSON type: number. Query alias: SchoolOrgID. |
|
locationReference.classroomIdentificationCode |
ClassroomIdentificationCode |
Y |
[Sections]DCID; [Sections]Room; Transformation: CST_PUBWORKFLOW_LIB.formaClassroomCodeBase(p_profileid, sec.dcid, sec.room) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: ClassroomIdentificationCode. |
|
locationSchoolReference.schoolId |
LocSchoolOrgID |
Y |
[Sections]Schoolid; [Sections]Wheretaught [Sections]WheretaughtDistrict; Transformation: case when sec.schoolid = p_schoolid and sec.wheretaught > 0 and sec.wheretaught != sec.schoolid then (case when sec.wheretaughtdistrict > 0 then lpad(sec.wheretaughtdistrict, 3, '0') || lpad(sec.wheretaught, 4, '0') else EDFI_TN_LIB.FormatLEASchoolid(p_profileid, sec.wheretaught) end) else EDFI_TN_LIB.FormatLEASchoolid(p_profileid, p_schoolid) end |
Required by the production resource definition when the resource is published. |
JSON type: number. Query alias: LocSchoolOrgID. |
|
sectionIdentifier |
UniqueSectionCode |
Y |
[Sections]DCID; Transformation: CST_PUBWORKFLOW_LIB.formaSectionCodeBase(p_profileid, sec.dcid, p_orgid) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: UniqueSectionCode. |
|
sequenceOfCourse |
SequenceOfCourse |
Conditional |
Staging rule: Sections '1' |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: number. Query alias: SequenceOfCourse. |
|
availableCredits |
AvailableCredits |
Conditional |
[Courses]Credit_Hours |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: number. Query alias: AvailableCredits. |
|
educationalEnvironmentDescriptor |
EducationalEnvironment_DX |
Conditional |
[S_TN_SEC_X]ClassType |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: EducationalEnvironment_DX. |
|
instructionLanguageDescriptor |
InstructionLanguage_DX |
Conditional |
Publishing framework or supporting query Query alias: InstructionLanguage_DX |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: InstructionLanguage_DX. |
|
mediumOfInstructionDescriptor |
MediumOfInstruction_DX |
Conditional |
[S_TN_SEC_X]TeachingMethod |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: MediumOfInstruction_DX. |
|
populationServedDescriptor |
PopulationServed_DX |
Conditional |
Publishing framework or supporting query Query alias: PopulationServed_DX |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: PopulationServed_DX. |
|
characteristics[].sectionCharacteristicDescriptor |
Characteristic_DX |
Y |
[S_TN_SEC_Honors_X]TestAdminWindow; Transformation: case when trim(xth.testadminwindow) = 'T' then 'Year-long' when trim(xth.testadminwindow) = 'F' then 'Fall Block' when trim(xth.testadminwindow) = 'S' then 'Spring Block' end |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: Characteristic_DX. |
|
courseLevelCharacteristics[].courseLevelCharacteristicDescriptor |
CourseLevelCharacteristic_DX |
Y |
[S_TN_SEC_Honors_X]StateDualCredit; [S_TN_SEC_Honors_X]DualEnrollment; [S_TN_SEC_Honors_X]ClassIndicator; [S_TN_SEC_Honors_X]LocalDualCredit; Transformation: case when xth.StateDualCredit = 'Y' then 'SDC' when xth.DualEnrollment = 'Y' then 'DE' when xt.HonorsClassIndicator = 'Y' then 'H' when xth.LocalDualCredit = 'Y' then 'LDC' else 'General' end |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: CourseLevelCharacteristic_DX. |
|
classPeriods[].classPeriodReference.schoolId |
SchoolOrgID |
Y |
Publishing framework or supporting query Query alias: SchoolOrgID |
Required by the production resource definition when the resource is published. |
JSON type: number. Query alias: SchoolOrgID. |
|
classPeriods[].classPeriodReference.classPeriodName |
PeriodName |
Y |
[Period]DCID; [Period]Abbreviation; [Period]Period_number; Transformation: EDFI_TN_LIB.formaPeriodName(p_profileid, p.dcid, p.abbreviation, p.period_number) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: PeriodName. |
|
programs[].programReference.educationOrganizationId |
EducationOrganizationId |
Y |
[CODESET]REPORTEDVALUE; [S_TN_SEC_Honors_X]SECONDARYINSTUITION; Transformation: coalesce(cs.REPORTEDVALUE,xth.SECONDARYINSTUITION) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: EducationOrganizationId. |
|
programs[].programReference.programTypeDescriptor |
ProgramType_DX |
Y |
[S_TN_SEC_Honors_X]LOCALDUALCREDIT; [S_TN_SEC_Honors_X]DUALENROLLMENT; Transformation: CASE WHEN NVL(xth.LOCALDUALCREDIT, 'N') = 'Y' THEN 'Local Dual Credit' WHEN NVL(xth.DUALENROLLMENT, 'N') = 'Y' THEN 'Dual Enrollment' END |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: ProgramType_DX. |
|
programs[].programReference.programName |
ProgramName |
Y |
[S_TN_SEC_Honors_X]LOCALDUALCREDIT; [S_TN_SEC_Honors_X]DUALENROLLMENT; Transformation: CASE WHEN NVL(xth.LOCALDUALCREDIT, 'N') = 'Y' THEN 'Local Dual Credit' WHEN NVL(xth.DUALENROLLMENT, 'N') = 'Y' THEN 'Dual Enrollment' END |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: ProgramName. |
|
sectionName |
sectionName |
Conditional |
[Sections]Expression |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: sectionName. |