Skip to main content
Skip table of contents

Organization Info

This category represents information about organization class periods and locations (rooms defined in sections). The Organization Setup category includes the following data views and resources:

Note: Organization Setup resources are only published for public schools.

Programs

This view captures the physical space where students gather for a particular class/section. The published view layout includes the School Name, Room Number, Last Publish Date, and Publishing ID.

programs

Primary PowerSchool Source Data

  • GADOE downloaded data

Selection Criteria

Records are published based on the programTypeDescriptors that are downloaded from the state.

Resource Output

  • Program records will be created for each programTypeDescriptors downloaded from the state.

Note: Click Export to export the data collection results to an Excel spreadsheet.                       

Data Element

Description

[Table]Data Type

Stored in [Table]Field

Req’d

educationOrganizationReference

 A reference to the related LEA resource. 

R

/educationOrganizationId

The LEA associated with this program.

String

[CourseTranscripts]LEAOrgID

R

programTypeDescriptor

The Descriptor Name provided by the downloads.

String

[studentSpecialEducationAssociationEvents]ProgramType_DX

R

programName

The Descriptor Name provided by the downloads.

String

[SchedulingTermTbl]Name

R

programId

The Id provided by the downloads.

String

[SpecialEnrollmentTbl]ProgramID

R

Class Periods

This data view represents the designation of a regularly scheduled series of class meetings at designated times and days of the week. The published view layout provides the School Name, Period Name, Period Number, Last Publish Data, and Publishing ID.

classPeriods

Primary PowerSchool Source Data

  • [Period]

Selection Criteria

Records are published if the following criteria are met:

  • The school must not be excluded from state reporting.

  • The school must have an Ed-Fi State School number.

  • The school must have a Georgia Reporting option.

  • The period number associated with the period name must be equal or greater than 0.

Resource Output

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

  • The classPeriod 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

[Table]Data Type

Stored in [Table]Field

Req’d

schoolReference

A reference to the related School resource.

R

/schoolID

The school associated with this period.

String

[studentSpecialEducationAssociationEvents]SchoolOrgID

R 

classPeriodName

A unique number or alphanumeric code assigned to a classroom period.

String

[SchedulingTermTbl]Name

officialAttendancePeriod

Boolean

[ClassPeriods]AttendancePeriod

meetingTimes

Array

meetingStartEndTimes

The meeting start and end time.

startTime

Start time of the class period.

String

[MeetingTimes]StartTime

endTime

End time of the class period.

String

[MeetingTimes]EndTime

R 

Local Education Agency Statistics

This data view represents the Statistics related to the LEA as part of the A01 System Report.

localEducationAgencyStatistics

Primary PowerSchool Source Data

  • [Prefs]

Resource Output

  • A single localEducationAgencyStatisticsrecord is published for each district.

Note: Click Export to export the data collection results to an Excel spreadsheet.                       

Data Element

Description

Data Type

Stored in [Table]Field

Req’d

educationOrganizationReference

A reference to the related School resource.

R

/educationOrganizationId

The school associated with this LEA.

Integer

[CourseTranscripts]LEAOrgID

R 

tkes90PercentAllTeachersIncluded

Publishes as True when the GA_Tkes_Teach value is A.

String

[LocalEducationAgencyStatistics]TKES90

R 

psychologicalServicesEvaluationCounts

/psychologicalServicesEvaluationDescriptor

Based on what field of data is being published using the following logic: 

  • WHEN 'GA_PSEC_CESESP' THEN 'System-Employed School Psychologists'

  • WHEN 'GA_PSEC_CENSEP' THEN 'Non-System-Employed School Psychologists'

  • WHEN 'GA_PSEC_LTCEAP' THEN 'Less Than Comprehensive All Psychologists'

  • WHEN 'GA_PSEC_IRNS' THEN 'Initial Referrals Not Seen'

  • WHEN 'GA_PSEC_RNC' THEN 'ReEvaluations Not Completed'

  • WHEN 'GA_PSEC_SESESPS' THEN 'Evaluated by System-Employed School Psychologists'

  • WHEN 'GA_PSEC_SEOPS' THEN 'Students to Be Evaluated by other Psychologists'

  • WHEN 'GA_PSCC_CWPO' THEN 'Consultations With Parents Only'

  • WHEN 'GA_PSCC_CWSST' THEN 'Consultations With Student Support Teams'

  • WHEN 'GA_PSCC_SC' THEN 'Student Consultations'

  • WHEN 'GA_PSCC_OSC' THEN 'Other School Consultations'

  • WHEN 'GA_PSCC_AOCSP' THEN 'All Other Provided Consultations And Services'

String

[LEAIndicators]Services_DX

R

/collectedCount

The value of the given A01 data.

Number

SchoolSWReferral]CollectedCount

R

privateOrHomeSchooledStudentCounts/privateOrHomeCounts1

R

/privateOrHomeSchooledStudentDescriptor

WHEN 'GA_PHS_SSIE' THEN 'Initial Evaluation

String

[LocalEducationAgencyStatistics]PHInitial

R

/collectedCount

The value of the given A01 data.

Integer

[LocalEducationAgencyStatistics]PHInitialCounts

R

privateOrHomeSchooledStudentCounts/privateOrHomeCounts2

/privateOrHomeSchooledStudentDescriptor

WHEN 'GA_PHS_SSRE' THEN 'Re-Evaluation'

String

[LocalEducationAgencyStatistics]PHReEvaluation

/collectedCount

The value of the given A01 data.

Number

[LocalEducationAgencyStatistics]PHReEvaluationCounts

privateOrHomeSchooledStudentCounts/privateOrHomeCounts3

/privateOrHomeSchooledStudentDescriptor

WHEN 'GA_PHS_SSFIE' THEN 'Found to be initially eligible'

String

[LocalEducationAgencyStatistics]PHEligible

/collectedCount

The value of the given A01 data.

Number

[LocalEducationAgencyStatistics]PHEligibleCounts

School Statistics

This data view represents the designation of a regularly scheduled series of class meetings at designated times and days of the week. The published view layout provides the School Name, Period Name, Period Number, Last Publish Data, and Publishing ID.

schoolStatistics

Primary PowerSchool Source Data

  • [S_GA_SCH_X]

Selection Criteria

Records are published if the following criteria are met:

  • The school must not be excluded from state reporting.

Resource Output

  • A single schoolStatistics record is published for each school included in reporting.

Note: Click Export to export the data collection results to an Excel spreadsheet.                       

Data Element

Description

Data Type

Stored in [Table]Field

Req’d

schoolReference

A reference to the related School resource.

R

/schoolID

The school associated with this period.

String

[StudentSpecialEducationAssociationEvents]SchoolOrgID

R 

cprTrainingProvided

When the school's grade levels are between 9 and 12 and GA_CPR_AED is checked, then a value of true is published. Otherwise, false is published.

Boolean

[SchoolStatistics]CPRTrainingProvided

R 

dualEnrollmentAwarenessGrade8

When DualEnrollAware_Grade8 is set to Yes, then a value of true is published. Otherwise, false is published.

Boolean

[SchoolStatistics]DualEnrollAwareGrade8

R 

dualEnrollmentAwarenessGrade9

When DualEnrollAware_Grade9 is set to Yes, then a value of true is published. Otherwise, false is published.

Boolean

[SchoolStatistics]DualEnrollAwareGrade9

R 

dualEnrollmentAwarenessGrade10

When DualEnrollAware_Grade10 is set to Yes, then a value of true is published. Otherwise, false is published.

Boolean

[SchoolStatistics]DualEnrollAwareGrade10

R 

dualEnrollmentAwarenessGrade11

When DualEnrollAware_Grade11 is set to Yes, then a value of true is published. Otherwise, false is published.

Boolean

[SchoolStatistics]DualEnrollAwareGrade11

R 

onlineSchool

When GA_OnlineSchool is checked, then a value of true is published. Otherwise, false is published.

Boolean

[SchoolStatistics]OnlineSchool

R 

titleIPartASchoolDesignationDescriptor

Title I School Code Value.

String

[SchoolStatistics]TitleIPartASchDesignation_DX

R 

stemSteamSchoolDescriptor

The Steam/Stem value of the school.

String

[SchoolStatistics]SteamSteamSchool

R 

behaviorIncidentCounts

R 

/behaviorIncidentDescriptor

Based on what field of data is being published using the following logic: 

  • WHEN 'NCLB_AB' THEN 'Aggravated Battery'

  • WHEN 'NCLB_ACM' THEN 'Aggravated Child Molestation'

  • WHEN 'NCLB_ASB' THEN 'Aggravated Sexual Battery'

  • WHEN 'NCLB_AS' THEN 'Aggravated Sodomy'

  • WHEN 'NCLB_AR' THEN 'Armed Robbery'

  • WHEN 'NCLB_FDA' THEN 'First Degree Arson'

  • WHEN 'NCLB_K' THEN 'Kidnapping'

  • WHEN 'NCLB_M' THEN 'Murder'

  • WHEN 'NCLB_R' THEN 'Rape'

  • WHEN 'NCLB_VM' THEN 'Voluntary Manslaughter'

  • WHEN 'NCLB_NFD' THEN 'Non Felony Drugs'

  • WHEN 'NCLB_FD' THEN 'Felony Drug'

  • WHEN 'NCLB_FW' THEN 'Felony Weapons'

  • WHEN 'NCLB_TT' THEN 'Terroristic Threats'

String

[SchoolBehaviors]Behavior_DX

R 

/collectedCount

The value of the given B01 data.

Number

[SchoolSWReferral]CollectedCount

R 

socialWorkCaseCounts/socialWorkCaseCounts1

R 

/socialWorkCaseDescriptor

Based on what field of data is being published using the following logic: 

  • WHEN 'SWC_ADS' THEN 'Academic Support'

  • WHEN 'SWC_ASID' THEN 'Attendance/Dropout Prevention Services'

  • WHEN 'SWC_AS' THEN 'Child Abuse and Neglect Services'

  • WHEN 'SWC_FHPSS' THEN 'Family/Health/Social Services'

  • WHEN 'SWCC_Homeless' THEN 'Homeless Services'

  • WHEN 'SWC_DS' THEN 'School Safety Services'

  • WHEN 'SWC_SE' THEN 'Special Education'

  • WHEN 'SWCC_SpecProg' THEN 'Special Programs'

  • WHEN 'SWCC_SuicRef' THEN 'Suicide Referrals'

String

[SchoolSocialWork]Social_DX

R 

/collectedCount

The value of the given B01 data.

Number

[SchoolSWReferral]CollectedCount

R 

socialWorkReferralCounts/socialWorkReferralCounts1

R 

/socialWorkReferralDescriptor

Based on what field of data is being published using the following logic: 

  • WHEN 'SWR_Other' THEN 'Community Agencies'

  • WHEN 'SWR_DFCS' THEN 'Dept Of Family and Children Services DFCS'

  • WHEN 'SWR_PH' THEN 'Health Services'

  • WHEN 'SWR_JC' THEN 'Juvenile And Other Court'

  • WHEN 'SWR_MH' THEN 'Mental Health Services'

String

[SchoolSWReferral]Referral_DX

R 

/collectedCount

The value of the given B01 data.

Number

[SchoolSWReferral]CollectedCount

R 

socialWorkServiceInterventionCounts/socialWorkServIntervCounts1

R 

/socialWorkServiceInterventionDescriptor

Based on what field of data is being published using the following logic: 

  • WHEN 'SWS_AgencyVisits' THEN 'Agency Visits'

  • WHEN 'SWS_CWPF' THEN 'Conferences With Parents Guardians'

  • WHEN 'SWS_CACR' THEN 'Consults With Agencies'

  • WHEN 'SWS_CWO' THEN 'Consults With School Staff'

  • WHEN 'SWS_CrisisInterv' THEN 'Crisis Interventions'

  • WHEN 'SWS_EAS' THEN 'Economic Aid Sessions'

  • WHEN 'SWS_GrpInterv' THEN 'Group Interventions'

  • WHEN 'SWS_HAV' THEN 'Home Visits'

  • WHEN 'SWS_CWS' THEN 'Student Interventions'

String

[SchoolServiceInter]Intervention_DX

R 

/collectedCount

The value of the given B01 data.

Number

[SchoolSWReferral]CollectedCoun

R 

socialWorkStudentCount

Count of students involved in social work.

Number

[SchoolStatistics]socialWorkStuCount

LEA Statistics View

This data view is available under Org Info and will have only one record per district.

This view has the following fields:

  • School name - The name of the LEA office.

  • District ID - The district number.

  • Last Publish Date - The date on which the record was last published.

  • Publishing ID - ID Assigned for publishing.

  • Resource ID - The resource ID.

JavaScript errors detected

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

If this problem persists, please contact our support.

Contact Support Close