PowerSchool SIS Georgia
PowerSchool SIS Georgia
Breadcrumbs

Organization Info

Information describing established organizational structures, programs, and statistics within the education organization.

Programs

The programs associated with each organization.

Primary PowerSchool Source Data

Core tables used in this resource:

  • [cst_pubCodeValue]

  • [cst_pubCodeset]

Selection Criteria

Business logic for publishing this resource:

  • Only published at the district office (p_schoolid = 0)

  • Retrieved from programTypeDescriptors codeset

  • Filters by CST_PUBProfileID and ResourceName = 'programTypeDescriptors'

  • One record per program type descriptor value

Resource Output

Expected output from the selection criteria:

  • programTypeDescriptor - Ed-Fi descriptor code for the program

  • programName - Description of the program type

  • programId - Unique identifier from codevalue

Automatic Publishing

Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.

Data Elements

Details of each data element published in this resource:

Data Element

Description

[Table]Data Type

Stored in [Table]Field

educationOrganizationReference

Reference to the LEA (District) that operates this program

customobject

LEAOrgID via CST_PUBWORKFLOW.formatLEADistrictID()

programTypeDescriptor

Ed-Fi descriptor identifying the type of program (e.g., Special Education, Gifted and Talented, ESOL, Homeless, Food Service)

string

[CST_PubCodeValue]CodeValue

programName

Human-readable name of the program derived from code description

string

[CST_PubCodeValue]ShortDescription

programId

Unique identifier for the program record

string

[CST_PubCodeValue]ID

Class Periods

Information describing established class periods within a school.

Primary PowerSchool Source Data

Core tables used in this resource:

  • [period]

  • [bell_schedule_items]

  • [Schools]

Selection Criteria

Business logic for publishing this resource:

  • School must not be excluded from reporting (sch.state_excludefromreporting = 0)

  • Period number must be greater than 0

  • Year ID matches the published year (per.year_id = p_yearid)

  • One record per period per school

Resource Output

Expected output from the selection criteria:

  • schoolReference - Reference to the school

  • classPeriodName - Formatted as [SchoolID]-[PeriodNumber]

  • meetingTimes - Array of start and end times from bell schedule items

Automatic Publishing

Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.

Data Elements

Details of each data element published in this resource:

Data Element

Description

[Table]Data Type

Stored in [Table]Field

schoolReference

Reference to the school that defines this class period

customobject

SchoolOrgID via CST_PUBWORKFLOW.formatLEASchoolID()

classPeriodName

Unique identifier for the class period, formatted as school ID concatenated with period number

string

[Period]DCID (composite: SchoolID-PeriodNumber)

officialAttendancePeriod

Boolean indicator of whether this period is used for attendance tracking (optional)

boolean

[Period]AttendancePeriod

meetingTimes

Array of meeting times for this class period

array

[Bell_Schedule_Items]Start_Time, [Bell_Schedule_Items]End_Time

startTime

Start time of class period in HH:MI:SS format (nested in meetingTimes)

string

[Bell_Schedule_Items]Start_Time

endTime

End time of class period in HH:MI:SS format (nested in meetingTimes)

string

[Bell_Schedule_Items]End_Time

School Statistics

The statistics associated with a School, including CPR training, dual enrollment awareness, and social work indicators.

Primary PowerSchool Source Data

Core tables used in this resource:

  • [Schools]

  • [s_ga_sch_x]

  • [s_sch_x]

  • [cst_pubpublished_tmp]

Selection Criteria

Business logic for publishing this resource:

  • School must be in published list (CST_PUBPUBLISHED_TMP)

  • School must not be excluded from reporting

  • School must not be the graduated school (school_number <> 999999)

  • One record per school

Resource Output

Expected output from the selection criteria:

  • schoolReference - Reference to the school

  • cprTrainingProvided - Boolean for high schools only

  • dualEnrollmentAwareness - Grades 8-11 awareness indicators

  • behaviorIncidentCounts - Array of counts by behavior descriptor

  • socialWorkCounts - Arrays for cases, referrals, and service interventions

Automatic Publishing

Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.

Data Elements

Details of each data element published in this resource:

Data Element

Description

[Table]Data Type

Stored in [Table]Field

schoolReference

Reference to the school for which statistics are reported

customobject

[Schools]DCID

cprTrainingProvided

Boolean indicator of whether CPR/AED training is provided (only for high schools, grades 9-12)

boolean

[S_GA_SCH_X]GA_CPR_AED custom field

dualEnrollmentAwarenessGrade8

Boolean indicator of dual enrollment awareness at grade 8

boolean

[Schools]DualEnrollAware_Grade8

dualEnrollmentAwarenessGrade9

Boolean indicator of dual enrollment awareness at grade 9

boolean

[Schools]DualEnrollAware_Grade9

dualEnrollmentAwarenessGrade10

Boolean indicator of dual enrollment awareness at grade 10

boolean

[Schools]DualEnrollAware_Grade10

dualEnrollmentAwarenessGrade11

Boolean indicator of dual enrollment awareness at grade 11

boolean

[Schools]DualEnrollAware_Grade11

onlineSchool

Boolean indicator of whether school operates primarily online

boolean

[S_SCH_X]OnlineSchool

titleIPartASchoolDesignationDescriptor

Ed-Fi descriptor for Title I Part A school designation (e.g., Schoolwide Program, Targeted Assistance)

string

[S_GA_SCH_X]TitleIPartASchDesignation_DX

stemSteamSchoolDescriptor

Descriptor indicating STEM/STEAM school status

string

[S_GA_SCH_X]SteamSteamSchool

behaviorIncidentCounts

Array of behavior incident counts organized by behaviorIncidentDescriptor. Includes counts of incidents by category.

array

[S_GA_SCH_X]NCLB_* (NCLB_AB, NCLB_ACM, NCLB_ASB, NCLB_AS, NCLB_AR, NCLB_FDA, NCLB_K, NCLB_M, NCLB_R, NCLB_VM, NCLB_NFD, NCLB_FD, NCLB_FW, NCLB_TT) with counts aggregated

behaviorIncidentDescriptor

Ed-Fi descriptor for behavior incident types (nested within behaviorIncidentCounts array). Values: Aggravated Battery, Aggravated Child Molestation, Aggravated Sexual Battery, Aggravated Sodomy, Armed Robbery, First Degree Arson, Kidnapping, Murder, Rape, Voluntary Manslaughter, Non Felony Drugs, Felony Drug, Felony Weapons, Terroristic Threats

string

[S_GA_SCH_X]UnPivot descriptor (behavior category name)

collectedCount

Count of behavior incidents for this descriptor category (nested within behaviorIncidentCounts)

number

COUNT of matching records

socialWorkCaseCounts

Array of social work case counts organized by socialWorkCaseDescriptor

array

[S_GA_SCH_X]SWC_* (SWC_ADS, SWC_ASID, SWC_AS, SWC_FHPSS, SWCC_Homeless, SWC_DS, SWC_SE, SWCC_SuicRef, SWC_HS, SWC_FCS) with counts aggregated

socialWorkCaseDescriptor

Ed-Fi descriptor for social work case types (values from unpivot: Academic Support, Attendance/Dropout Prevention Services, Child Abuse and Neglect Services, Family Services, Homeless Services, Behavior/Discipline Services, Special Education, Suicide Risk, Health Services, Foster Care Services)

string

[S_GA_SCH_X]UnPivot descriptor (social work case category name)

socialWorkReferralCounts

Array of social work referral counts organized by socialWorkReferralDescriptor

array

[S_GA_SCH_X]SWR_* (SWR_Other, SWR_DFCS, SWR_PH, SWR_JC, SWR_MH) with counts aggregated

socialWorkReferralDescriptor

Ed-Fi descriptor for social work referral types (values from unpivot: Community Agencies, Dept Of Family and Children Services (DFCS), Health Services, Juvenile And Other Court, Mental Health Services)

string

[S_GA_SCH_X]UnPivot descriptor (social work referral category name)

socialWorkServiceInterventionCounts

Array of social work service intervention counts organized by socialWorkServiceInterventionDescriptor

array

[S_GA_SCH_X]SWS_* (SWS_AgencyVisits, SWS_CWPF, SWS_CWO, SWS_CrisisInterv, SWS_EAS, SWS_GrpInterv, SWS_HAV, SWS_CWS, SWS_CRT, SWS_SC, SWS_CP, SWS_SP) with counts aggregated

socialWorkServiceInterventionDescriptor

Ed-Fi descriptor for social work service intervention types (values from unpivot: Agency Visits, Conferences With Parents or Guardians, Consults With School Staff, Crisis Interventions, Economic Aid Support, Group Interventions, Home Visits, Conferences with Students, Crisis Response Team, Supervisory Conferences, Community Participation, Special Programs)

string

[S_GA_SCH_X]UnPivot descriptor (service intervention category name)

socialWorkStudentCount

Total count of students receiving social work services at the school

number

[S_GA_SCH_X]SocialWorkStuCount

LEA Statistics

The statistics associated with a LEA (district), including psychological services evaluations and private/home school counts.

Primary PowerSchool Source Data

Core tables used in this resource:

  • [cst_pubpublished_tmp]

  • [lea_indicators]

Selection Criteria

Business logic for publishing this resource:

  • Only published at the district office (p_schoolid = 0)

  • One record per LEA

Resource Output

Expected output from the selection criteria:

  • educationOrganizationReference - Reference to the LEA

  • tkes90PercentAllTeachersIncluded - Boolean for TKES evaluation

  • psychologicalServicesEvaluationCounts - Array of evaluation type counts

  • privateOrHomeSchooledStudentCounts - Arrays for initial, re-evaluation, and eligible counts

Automatic Publishing

Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.

Data Elements

Details of each data element published in this resource:

Data Element

Description

[Table]Data Type

Stored in [Table]Field

educationOrganizationReference

Reference to the Local Education Agency (District)

customobject

LEAOrgID

tkes90PercentAllTeachersIncluded

Boolean indicator of whether TKES (Teacher Keys Effectiveness System) evaluation includes 90% of all teachers

boolean

[Prefs]TKES90

psychologicalServicesEvaluationCounts

Array of psychological services evaluation counts by service type. Valid descriptors: Cognitive Assessment, Emotional/Behavioral Assessment, Speech/Language Pathology Evaluation, Occupational Therapy Evaluation, Physical Therapy Evaluation, Assistive Technology Evaluation, Medical Evaluation, Classroom Observation, Parent Interview, Student Interview, Other Evaluation

array

[LEA_Indicators]Services_DX with CollectedCount

psychologicalServicesEvaluationDescriptor

Ed-Fi descriptor for psychological services evaluation types (nested in psychologicalServicesEvaluationCounts)

string

Services_DX - CASE mapped to: 1='Cognitive', 2='Emotional/Behavioral', 3='SpeechLang', 4='OccupTherapy', 5='PhysTherapy', 6='AssistiveTech', 7='Medical', 8='ClassObserv', 9='ParentIntv', 10='StudIntv', 11='Other'

privateOrHomeSchooledStudentCounts

Array of student counts for private/home school students organized by status type (Initial Evaluation, Re-evaluation, Eligible)

array

[Prefs]PHInitial, PHReEvaluation, PHEligible with respective counts

privateOrHomeSchooledStudentDescriptor

Ed-Fi descriptor for private/home school student status (nested in privateOrHomeSchooledStudentCounts). Valid values: Initial Evaluation, Re-evaluation, Eligible

string

PHInitial | PHReEvaluation | PHEligible mapped to descriptor codes