ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
KEY
2
New Mapping for v7
3
Deprecated
4
In Review/Issue
5
Submitted (case number)
6
7
Modified DateStatusSC Unique IDPowerSchool Element GroupingEntitySubEntityElementSubElementDistrict dataODS table.fieldPS TablePS ColumnPS SourceComments
8
legalOrganization Info
Tables: PERIOD (per), SCHOOLS (sch), CYCLE_DAY (cy)
School is enabled for reporting (not excluded), school year is enabled in Ed-Fi configuration, and period number > 0. SC would like this resource moved for excluded schools as well.
9
12/19/2023
Ticket submitted by WS on 12/19/2023: case 07605299
013_SC_01Organization InfoclassPeriodsclassPeriodName
ClassPeriod.ClassPeriodName
(DERIVED)
Composite based on school_number, bell_schedule, period, and cycle day
FORMAT: sch.school_number '-' bsi.Bell_Schedule_ID '-' coalesce( per.abbreviation, per.period_number ) '-' cy.letter
10
013_SC_02Organization InfoclassPeriodsschoolReferenceschoolId
ClassPeriod.schoolid
PERIODSCHOOLIDState-assigned value based on PERIOD.schoolid
11
013_SC_03Organization InfoclassPeriodsmeetingTimesstartTime
classperiodmeetingtime.starttime
BELL_SCHEDULE_ITEMSSTART_TIMEstart_time( select distinct to_char(to_date(bsi.end_time, 'sssss'),'hh24:mi:ss') as end_time,
to_char(to_date(bsi.start_time, 'sssss'),'hh24:mi:ss') as start_time ,
per.dcid as period_dcid , cy.dcid as cycle_dcid , bsi.DAILY_ATTENDANCE_CODE as official_attendanceperiod
from period per
join schools sch on per.schoolid = sch.school_number
join cycle_day cy on cy.schoolid = per.schoolid and cy.year_id = per.year_id
join BELL_SCHEDULE_ITEMS bsi on bsi.PERIOD_ID=per.id AND sch.state_excludefromreporting = 0
and per.period_number > 0 and per.year_id = p_yearid
) Meetingtime
12
013_SC_04Organization InfoclassPeriodsmeetingTimesendTime
classperiodmeetingtime.endtime
BELL_SCHEDULE_ITEMSEND_TIMEend_time
13
013_SC_05Organization InfoclassPeriodsofficialAttendancePeriod
ClassPeriod.OfficialAttendancePeriod
BELL_SCHEDULE_ITEMSDaily_Attendance_CodeDaily_Attendance_Code
14
043_SC_01Organization InfolocationsschoolReferenceschoolId
Location.schoolid
SECTIONSSCHOOLID
State-assigned value based on SECTIONS.schoolid
15
043_SC_02Organization InfolocationsmaximumNumberOfSeats
Location.MaximumNumberOfSeats
(DERIVED)ROOM.occupancy_maximum (when set), or SECTIONS.maxenrollment (when set)
16
11/21/2023Submitted043_SC_03Organization InfolocationsclassroomIdentificationCode
Location.classroomIdentificationCode
(DERIVED)
Move the unique classroom locations within a school
17
2/27/2024
Submitted (07715875)
056_SC_06Organization InfoSchoolseducationOrganizationCategories
educationOrganizationCategoryDescriptor
educationOrganizationCategory.educationOrganizationCategoryDescriptorId
SchoolsIsSummerSchool
When Schools.IsSummerSchool = "1" then educationOrganizationCategoryDescriptor = "Summer School"
18
2/27/2024
Submitted (07715875)
056_SC_07Organization InfoSchoolseducationOrganizationCategories
educationOrganizationCategoryDescriptor
educationOrganizationCategory.educationOrganizationCategoryDescriptorId
SchoolsState_ExcludeFromReporting
When Schools.State_ExcludeFromReporting = "1" then educationOrganizationCategoryDescriptor = "Exclude From Reporting"
19
056_SC_08Organization InfoSchoolseducationOrganizationCategories
educationOrganizationCategoryDescriptor
educationOrganizationCategory.educationOrganizationCategoryDescriptorId
(DERIVED)
If neither "Summer School" or "Exclude from Reporting" is selected then hard-code educationOrganizationCategoryDescriptor = "Independent"
If neither "Summer School" or "Exclude from Reporting" is selected then hard-code educationOrganizationCategoryDescriptor = "Independent"
20
2/27/2024
Submitted (07715875)
056_SC_09Organization InfoSchoolsgradeLevels
gradeLevelDescriptor
schools.gradeLevelDescriptorId
(DERIVED)Take the low grade and high grade for each school, and every grade in between, and assign a descriptor from uri://ed.sc.gov/GradeLevelDescriptor
21
2/27/2024
Submitted (07715875)
056_SC_10Organization InfoSchoolsschoolId
schools.schoolid
SCHOOLSSCHOOLID
State-assigned value based on SCHOOLS.schoolid
22
2/27/2024
Submitted (07715875)
056_SC_11Organization InfoSchoolsnameOfInstitution
schools.nameOfInstitution
SCHOOLSNAMETake the value indicated; else leave blank
23
4/16/2024
Submitted via email
056_SC_12Organization InfoSchoolsAddresses
educationOrganizationAddress
addressTypeDescriptor
EducationOrganizationAddress.addressTypeDescriptorId
school (derived)name (derived)
If schools.name IS NOT NULL or blank then send a addressTypeDescriptor codeValue of Physical
Our intent is that a addressTypeDescriptor codeValue of Physical is always sent for any South Carolina school.
24
4/16/2024
Submitted via email
056_SC_13Organization InfoSchoolsAddresses
educationOrganizationAddress
stateAbbreviationDescriptor
EducationOrganizationAddress.StateAbbreviationDescriptorId
school (derived)name (derived)
If schools.name IS NOT NULL or blank then send a stateAbbreviationDescriptor codeValue of SC
Our intent is that a stateAbbreviationDescriptor codeValue of SC is always sent for any South Carolina school.
25
4/16/2024
Submitted via email
056_SC_14Organization InfoSchoolsAddresses
educationOrganizationAddress
city
EducationOrganizationAddress.City
schoolsschoolcityschools.schoolcity
26
4/16/2024
Submitted via email
056_SC_15Organization InfoSchoolsAddresses
educationOrganizationAddress
postalCode
EducationOrganizationAddress.PostalCode
schoolsschoolzipschools.schoolzip
27
4/16/2024
Submitted via email
056_SC_16Organization InfoSchoolsAddresses
educationOrganizationAddress
streetNumberName
EducationOrganizationAddress.StreetNumberName
schoolsschooladdressschools.schooladdress
28
Calendars
Tables: SCHOOLS (sch), S_SCH_CALENDARS_C (cal)
29
011_SC_01CalendarscalendarDatesdate
CalendarDate.Date
CALENDAR_DAYDATE_VALUECALENDAR_DAY.date_value
30
011_SC_02CalendarscalendarDatescalendarReferencecalendarCode
CalendarDate.CalendarCode
(DERIVED)Composite based on SCHOOLS.school_number and may have hyphen plus track letter appended if calendar describes a track.
31
011_SC_03CalendarscalendarDatescalendarReferenceschoolId
CalendarDate.schoolid
SCHOOLSSCHOOL_NUMBER
State-assigned value based on SCHOOLS.school_number
32
011_SC_04CalendarscalendarDatescalendarReferenceschoolYear
CalendarDate.schoolyear
(DERIVED)Based on context of data being published
33
011_SC_05CalendarscalendarDatescalendarEvents
calendarEventDescriptor
CalendarDateCalendarEvent.CalendarEventDescriptorId
CALENDAR_DAYMEMBERSHIPVALUE
if calendar_day.MembershipValue> 0 then send CalendarEvent Descriptor value of M
if calendar_day.MembershipValue = 0 then send CalendarEvent Descriptor value of Q
SC Ed-Fi Descriptors
The idea is that schools will have a maximum of three descriptors per day, In-Session/Not In-Session
(from calendar_day.insession),
Membership/Not Membership (from calendar_day.membership), and
Type (from calendar_day.type).
34
011_SC_06CalendarscalendarDatescalendarEvents
calendarEventDescriptor
CalendarDateCalendarEvent.CalendarEventDescriptorId
CALENDAR_DAYinsession
if calendar_day.InSession = 0 then send CalendarEventDescriptor value of T
if calendar_day.InSession = 1 then send CalendarEventDescriptor value of N
SC Ed-Fi Descriptors
The idea is that schools will have a maximum of three descriptors per day, In-Session/Not In-Session
(from calendar_day.insession),
Membership/Not Membership (from calendar_day.membership), and
Type (from calendar_day.type).
35
011_SC_07CalendarscalendarDatescalendarEvents
calendarEventDescriptor
CalendarDateCalendarEvent.CalendarEventDescriptorId
CALENDAR_DAYtype
The calendar_day.type values should map one-to-one to SC Namespaced CalendarEvent Descriptor values (for example, when calendar_day.type = H then PowerSchool should send the following descriptor: H)
SC Ed-Fi Descriptors
The idea is that schools will have a maximum of three descriptors per day, In-Session/Not In-Session
(from calendar_day.insession),
Membership/Not Membership (from calendar_day.membership), and
Type (from calendar_day.type).
36
012_SC_01CalendarscalendarscalendarCode
Calendar.CalendarCode
(DERIVED)Composite based on SCHOOLS.school_number and may have hyphen plus track letter appended if calendar describes a track.
37
012_SC_02CalendarscalendarsschoolReferenceschoolId
Calendar.schoolid
SCHOOLSSCHOOL_NUMBERSCHOOLS.school_number
38
012_SC_03CalendarscalendarsschoolYearTypeReferenceschoolYear
Calendar.SchoolYear
(DERIVED)Based on context of data being published
39
012_SC_04CalendarscalendarscalendarTypeDescriptor
Calendar.CalendarTypeDescriptorId
(DERIVED)Default to 'School'Ed-Fi Descriptors
40
035_SC_01CalendarsgradingPeriodsschoolReferenceschoolId
GradingPeriod.schoolid
TERMSSCHOOLIDState-assigned value based on TERMS.schoolid
41
035_SC_02CalendarsgradingPeriodsschoolYearTypeReferenceschoolYear
GradingPeriod.schoolyear
(DERIVED)TERMS.yearid + 1991
42
035_SC_03CalendarsgradingPeriodsbeginDate
GradingPeriod.BeginDate
TERMSFIRSTDAYTERMS.firstday
43
035_SC_04CalendarsgradingPeriodsgradingPeriodDescriptor
GradingPeriod.GradingPeriodDescriptorId
(DERIVED)
Uses code mapping based on TERMS.abbreviation
44
035_SC_05CalendarsgradingPeriodsendDate
GradingPeriod.EndDate
TERMSLASTDAYTERMS.lastday
45
035_SC_06CalendarsgradingPeriodstotalInstructionalDays
GradingPeriod.TotalInstructionalDays
(DERIVED)
Sum of insession days between TERMS.firstday and TERMS.lastday
46
035_SC_07CalendarsgradingPeriodsperiodSequence
GradingPeriod.PeriodSequence
(DERIVED)
Single digit number derived from TERMS.portion and TERMS.abbreviation
WHEN TERMS.abbreviation = 'S3' then '1' -- 'Summer Semester'
WHEN TERMS.portion = 1 then '1'
WHEN substr(TERMS.abbreviation, length(TERMS.abbreviation), 1) in ('1','2','3','4','5','6') then substr(TERMS.abbreviation, length(TERMS.abbreviation), 1)
ELSE '1' -- default
47
2/19/2024
Submitted (07712237)
035_SC_08CalendarsgradingPeriodsgradingPeriodName
GradingPeriodPeriod.GradingPeriodName
(DERIVED)
Composite based on districtCode and TERMS.abbreviation
FORMAT: districtCode '-' TERMS.abbreviation (i.e. 9998-S3)
48
8/28/2023
To be submitted when schools resource change happens next year
056_SC_01CalendarsschoolsschoolTypeDescriptor
School.SchoolTypeDescriptorId
schoolsIsSummerSchoolschools.issummerschoolWHEN 1 then 'True' : ELSE 'False'
49
8/28/2023
To be submitted when schools resource change happens next year
056_SC_02CalendarsschoolsSchoolCategories
SchoolCategoryDerscriptor
SchoolCategory.SchoolCategoryDerscriptorId
schoolsState_ExcludeFromReportingschool.excludeWHEN 1 then 'True' : ELSE 'False'
50
056_SC_03CalendarsschoolsSchoolId
School.schoolid
schoolsSCHOOLID
State-assigned value based on SCHOOLS.schoolid
51
8/28/2023
To be submitted when schools resource change happens next year
056_SC_04CalendarsschoolsgradeLevels
gradeLevelDescriptor
SchoolGradeLevel.GradeLevelDescriptorId
(DERIVED)Take the low grade and high grade for each school, and every grade in between, and assign a descriptor from uri://ed.sc.gov/GradeLevelDescriptor
52
8/28/2023
To be submitted when schools resource change happens next year
056_SC_05CalendarsschoolsnameOfInstitution
EducationOrganization.nameOfInstitution
SchoolsNameTake the value indicated; else leave blank
53
059_SC_01CalendarssessionsschoolReferenceschoolId
Session.SchoolId
TERMSSCHOOLIDState-assigned value based on TERMS.schoolid
54
059_SC_02CalendarssessionsschoolYearTypeReferenceschoolYear
Session.SchoolYear
(DERIVED)TERMS.yearid + 1991
55
059_SC_03CalendarssessionstermDescriptor
session.termdescriptorid
(DERIVED)
Derived in code based on TERMS.portion and TERMS.abbreviation
56
059_SC_04CalendarssessionssessionName
Session.SessionName
(DERIVED)
Composite based on TERMS.schoolid, TERMS.abbreviation, TERMS.dcid
FORMAT: t.schoolid '-' t.abbreviation '-' t.dcid
57
059_SC_05CalendarssessionsbeginDate
Session.BeginDate
TERMSFIRSTDAYTERMS.firstday
58
059_SC_06CalendarssessionsendDate
Session.EndDate
TERMSLASTDAYTERMS.lastday
59
059_SC_07CalendarssessionstotalInstructionalDays
Session.TotalInstructionalDays
(DERIVED)
Sum of insession days between TERMS.firstday and TERMS.lastday
60
059_SC_08CalendarssessionsgradingPeriods
gradingPeriodReference
schoolId
SessionGradingPeriod.SchoolId
TERMSSCHOOLIDState-assigned value based on TERMS.schoolid
61
059_SC_09CalendarssessionsgradingPeriods
gradingPeriodReference
gradingPeriodDescriptor
SessionGradingPeriod.GradingPeriodDescriptorId
(DERIVED)
Uses code mapping based on TERMS.abbreviation
62
Corrected this from gradingPeriodSequence to gradingPeriodName. (gradingPeriodSequence is not found on the Sessions resource and gradpingPeriodName was missing.)
059_SC_10CalendarssessionsgradingPeriods
gradingPeriodReference
gradingPeriodName
sessionGradingPeriod.GradingPeriodName
(DERIVED)
Composite based on districtCode and TERMS.abbreviation
FORMAT: districtCode '-' TERMS.abbreviation (i.e. 9998-S3)
63
059_SC_11CalendarssessionsgradingPeriods
gradingPeriodReference
schoolYear
SessionGradingPeriod.SchoolYear
(DERIVED)TERMS.yearid + 1991
64
Organization Schedules
Tables: SECTIONS (sec), COURSES (crs), TERMS (t), COURSESCOREFIELDS (cf)
Courses excluded where S_CRS_X.excludefromedfi = 1. One CourseOffering per term per state course that has at least one section taught.
65
020_SC_01Organization SchedulescourseOfferingsschoolReferenceschoolId
courseoffering.schoolid
SECTIONSSCHOOLID
State-assigned value based on SECTIONS.schoolid
66
020_SC_02Organization SchedulescourseOfferingslocalCourseCode
courseoffering.LocalCourseCode
(DERIVED)courses.course_numberLocal course number
67
020_SC_03Organization SchedulescourseOfferingscourseReferencecourseCode
courseoffering.CourseCode
COURSECOREFIELDSCOURSES.course_numberPerforms lookup against downloaded state course codes (CST_PUBCOURSE) using local course_number.
If 1st character is 'H' then changed to '0'. First attempt is to find EXACT MATCH.
If not exact match then attempts match on: first 4 + '00' + last 2 characters
If still no match then attempts match on: first 4 + '0000'
Otherwise, results in match failure -> Error or Dependency
68
020_SC_04Organization SchedulescourseOfferingscourseReference
educationOrganizationId
courseoffering.EducationOrganizationId
Hard-coded as '1'ODS only accepts a value of '1' for state
69
020_SC_05Organization SchedulescourseOfferingssessionReferenceschoolIdTERMSSCHOOLIDState-assigned value based on TERMS.schoolidThis row is an API reference only and the value in the referred table is created as part of the Session entity.
This element (schoolid) is used in multiple/different contexts within the main "courseofferings"entity -SC/RT.
70
020_SC_06Organization SchedulescourseOfferingssessionReferenceschoolYear
CourseOffering.SchoolYear
(DERIVED)TERMS.yearid + 1991
71
020_SC_07Organization SchedulescourseOfferingssessionReferencesessionName
CourseOffering.SessionName
(DERIVED)
Composite based on TERMS.schoolid, TERMS.abbreviation, TERMS.dcid
FORMAT: t.schoolid '-' t.abbreviation '-' t.dcid
72
020_SC_08Organization SchedulescourseOfferingslocalCourseTitle
courseoffering.LocalCourseTitle
COURSESCOURSE_NAMECOURSES.course_name
73
020_SC_09Organization SchedulescourseOfferingscourseLevelCharacteristics
courseLevelCharacteristicDescriptor
CourseOfferingCourseLevelCharacteristic.CourseLevelCharacteristicDescriptorId
(DERIVED)Derived from COURSES.course_numberRefer to separate CourseLevelCharacteristics tab for logic
74
020_SC_10Organization SchedulescourseOfferingsOfferedGradeLevels
gradeLevelDescriptor
courseofferedgradelevel.GradeLevelDescriptorId
(DERIVED)Derived from COURSES.course_numberWHEN first character = '1' then report grade levels 0 through 6
WHEN first character = '2' then report grade levels 7 and 8
WHEN first character IN ('3','4','5','6','8') then report grade levels 9 through 12
75
058_SC_01Organization SchedulessectionslocationReferenceschoolId
section.schoolid Location.SchoolId
SECTIONSSCHOOLID
State-assigned value based on SECTIONS.schoolid
76
058_SC_02Organization SchedulessectionssectionIdentifier
Section.SectionIdentifier
(DERIVED)
Composite based on SECTIONS schoolid, course_number, section_number, dcid
FORMAT: sec.schoolid '-' crs.course_number '-' sec.section_number '-' sec.dcid
77
058_SC_03Organization SchedulessectionscourseOfferingReference
localCourseCode
section.localcoursecode
(DERIVED)courses.course_numberLocal course number
78
058_SC_04Organization SchedulessectionscourseOfferingReferenceschoolId
Section.SchoolId
SECTIONSSCHOOLID
State-assigned value based on SECTIONS.schoolid
79
058_SC_05Organization SchedulessectionscourseOfferingReferenceschoolYear
Section.Schoolyear
(DERIVED)TERMS.yearid + 1991
80
058_SC_06Organization SchedulessectionscourseOfferingReferencesessionName
Session Section.SessionName
(DERIVED)
Composite based on TERMS.schoolid, TERMS.abbreviation, TERMS.dcid
FORMAT: t.schoolid '-' t.abbreviation '-' t.dcid
81
8/25/2023submitted058_SC_07Organization SchedulessectionscourseLevelCharacteristics
courseLevelCharacteristicDescriptor
SectionCourseLevelCharacteristic.CourseLevelCharacteristicDescriptorId
(DERIVED)excludeADA: sections.Exclude_ADA
genderRestricted: s_sc_sec_X.GenderRestricted
homeroom: s_sc_sec_X.Homeroom
excludedFromGPA: sections.excludefromgpa
82
10/18/2023058_SC_18Organization SchedulessectionscourseLevelCharacteristics
courseLevelCharacteristicDescriptor
SectionCourseLevelCharacteristic.CourseLevelCharacteristicDescriptorId
(DERIVED)
When s_sc_sec_X.Exclude_ADA = '1' then courseLevelCharacteristicDescriptor = 'Exclude_ADA',
SC Custom Descriptors
83
10/18/2023058_SC_19Organization SchedulessectionscourseLevelCharacteristics
courseLevelCharacteristicDescriptor
SectionCourseLevelCharacteristic.CourseLevelCharacteristicDescriptorId
(DERIVED)
When s_sc_sec_X.GenderRestricted = '1' then courseLevelCharacteristicDescriptor = 'Gender Restricted',
SC Custom Descriptors
84
10/18/2023058_SC_20Organization SchedulessectionscourseLevelCharacteristics
courseLevelCharacteristicDescriptor
SectionCourseLevelCharacteristic.CourseLevelCharacteristicDescriptorId
(DERIVED)
When s_sc_sec_X.Homeroom = '1' then courseLevelCharacteristicDescriptor = 'Homeroom',
SC Custom Descriptors
85
10/18/2023058_SC_21Organization SchedulessectionscourseLevelCharacteristics
courseLevelCharacteristicDescriptor
SectionCourseLevelCharacteristic.CourseLevelCharacteristicDescriptorId
(DERIVED)
When sections.excludefromgpa = '1' then courseLevelCharacteristicDescriptor = 'Exclude From GPA';
SC Custom Descriptors
86
2/2/2024
PSSR-339908 ; Case 07672366
058_SC_08Organization SchedulessectionsofferedGradeLevels
gradeLevelDescriptor
sectionOfferedGradeLevel.gradeLevelDescriptorId
SECTIONSCOURSE_NUMBER
WHEN first character of SECTIONS.COURSE_NUMBER IN ('01','1') then gradeLevelDescriptor codevalues to send are:
gradeLevelDescriptor codevalue = 0
gradeLevelDescriptor codevalue = 1
gradeLevelDescriptor codevalue = 2
gradeLevelDescriptor codevalue = 3
gradeLevelDescriptor codevalue = 4
gradeLevelDescriptor codevalue = 5
gradeLevelDescriptor codevalue = 6
WHEN first character of SECTIONS.COURSE_NUMBER IN ('02','2', '03') then gradeLevelDescriptor codevalues to send are:
gradeLevelDescriptor codevalue = 7
gradeLevelDescriptor codevalue = 8
WHEN first character of SECTIONS.COURSE_NUMBER IN ('3', '04','4', '05','5','6', '7','8', '9') then gradeLevelDescriptor codevalues to send are:
gradeLevelDescriptor codevalue = 9
gradeLevelDescriptor codevalue = 10
gradeLevelDescriptor codevalue = 11
gradeLevelDescriptor codevalue = 12
WHEN first character of SECTIONS.COURSE_NUMBER IN ('06', '07', '08', '09') then gradeLevelDescriptor codevalues to send are:
gradeLevelDescriptor codevalue = 0
gradeLevelDescriptor codevalue = 1
gradeLevelDescriptor codevalue = 2
gradeLevelDescriptor codevalue = 3
gradeLevelDescriptor codevalue = 4
gradeLevelDescriptor codevalue = 5
gradeLevelDescriptor codevalue = 6
gradeLevelDescriptor codevalue = 7
gradeLevelDescriptor codevalue = 8
gradeLevelDescriptor codevalue = 9
gradeLevelDescriptor codevalue = 10
gradeLevelDescriptor codevalue = 11
gradeLevelDescriptor codevalue = 12
This logic is intended to NOT look at the SECTIONS.GRADE_LEVEL field; rather, the logic uses Sections.Course_Number (i.e., the course number associated with this section) to derive the multiple descriptor code values sent. We may need to change this logic at a later date when SCED course codes are implemented.
87
058_SC_09Organization SchedulessectionsavailableCredits
section.availablecredits
COURSESCREDIT_HOURSCOURSES.credit_hours
88
058_SC_10Organization SchedulessectionseducationalEnvironmentDescriptor
section.EducationalEnvironmentDescriptorId
(DERIVED)
coalesce(xts.educationalenvironment, 'Classroom')
89
058_SC_11Organization SchedulessectionssequenceOfCourse
Section.SequenceOfCourse
(DERIVED)coalesce(xts.sced_sequence, 1)Publish '1' if null
90
058_SC_12Organization SchedulessectionsmediumOfInstructionDescriptor
section.MediumOfInstructionDescriptorid
S_SC_SEC_XSC_INSTRTYPEsc_sec.InstrTypeUse the SC Custom Descriptors
91
12/19/2023
Case 07605299
058_SC_13Organization SchedulessectionsclassPeriods
classPeriodReference
classPeriodName
sectionClassPeriod.classPeriodName
(DERIVED)
Composite based on school_number, bell_schedule, period, and cycle day
FORMAT: sch.school_number '-' bsi.Bell_Schedule_ID '-' coalesce( per.abbreviation, per.period_number ) '-' cy.letter
92
058_SC_14Organization SchedulessectionsclassPeriods
classPeriodReference
SchoolID
sectionClassPeriod.schoolId
(DERIVED)SCHOOLID
State-assigned value based on SECTIONS.schoolid
93
058_SC_16Organization SchedulessectionslocationSchoolReferenceschoolid
section.LocationSchoolId
(DERIVED)Sections.SchoolID
94
058_SC_17Organization SchedulessectionslocationReference
classroomIdentificationCode
location.classroomIdentificationCode
(DERIVED)
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 wheretaughtdistrict and/or '000' for wheretaught.
95
009_SC_01Organization SchedulesbellSchedulesbellScheduleName
bellschedule.BellScheduleName
(DERIVED)
Composite based on school number, bell schedule name, and cycle day
FORMAT: bs.schoolid '-' bs.name '-' cy.letter
96
12/19/2023
Case 07605299
009_SC_02Organization SchedulesbellSchedulesclassPeriods
classPeriodReference
classPeriodName
BellScheduleClassPeriod.ClassPeriodName
(DERIVED)
Composite based on school_number, bell_schedule, period, and cycle day
FORMAT: sch.school_number '-' bsi.Bell_Schedule_ID '-' coalesce( per.abbreviation, per.period_number ) '-' cy.letter
97
009_SC_03Organization SchedulesbellSchedulesclassPeriods
classPeriodReference
schoolId
BellScheduleClassPeriod.schoolid
PERIODSCHOOLIDState-assigned value based on PERIOD.schoolid
98
009_SC_04Organization SchedulesbellSchedulesschoolReferenceschoolId
bellschedule.schoolid
BELL_SCHEDULESCHOOLID
State-assigned value based on BELL_SCHEDULE.schoolid
99
009_SC_05Organization SchedulesbellSchedulesalternateDayName
BellSchedule.AlternateDayName
CYCLE_DAYLETTERCYCLE_DAY.letter
100
009_SC_06Organization SchedulesbellSchedulestotalInstructionalTime
bellschedule.totalInstructionalTime
Derived from Bell_SCHEDULE
Can PowerSchool calculate each number of minutes in bell schedule and populate this field? We're wanting to calculate the total instructional time in minutes per day for the bell schedule.