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.

Integer

[Prefs] DistrictNumber

R

programTypeDescriptor

The Descriptor Name provided by the downloads.

String

R

programName

The Descriptor Name provided by the downloads.

Integer

R

Back to top

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.

Integer

SchoolId downloaded from State

Derived from:

[S_WI_SCH_X]EdFi_StateSchoolNumber, or if this field is blank then

[Schools]Alternate_School_Number] if greater than 0

Otherwise, [Schools]School_Number

R 

name

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

String

[Period]Name

R 

Back to top

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 period.

Integer

[Prefs] DistrictNumber

R 

tkes90PercentAllTeachersIncluded

Publishes as True when the GA_Tkes_Teach value is A.

String

[Prefs] GA_Tkes_Teach 

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

[Prefs]  Based on the following values.
GA_PSEC_CESESP
GA_PSEC_CENSEP
GA_PSEC_LTCEAP
GA_PSEC_IRNS
GA_PSEC_RNC
GA_PSEC_SESESPS
GA_PSEC_SEOPS
GA_PSCC_CWPO
GA_PSCC_CWSST
GA_PSCC_SC
GA_PSCC_OSC
GA_PSCC_AOCSP

R

     /collectedCount

The value of the given A01 data.

Integer

[Prefs]  Based on the following values.
GA_PSEC_CESESP
GA_PSEC_CENSEP
GA_PSEC_LTCEAP
GA_PSEC_IRNS
GA_PSEC_RNC
GA_PSEC_SESESPS
GA_PSEC_SEOPS
GA_PSCC_CWPO
GA_PSCC_CWSST
GA_PSCC_SC
GA_PSCC_OSC
GA_PSCC_AOCSP

R

privateOrHomeSchooledStudentCounts

R

     /privateOrHomeSchooledStudentDescriptor

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

  • WHEN 'GA_PHS_SSIE' THEN 'Initial Evaluation'

  • WHEN 'GA_PHS_SSRE' THEN 'Re-Evaluation'

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

String

[Prefs]  Based on the following values.
GA_PHS_SSIE
GA_PHS_SSRE
GA_PHS_SSFIE

R

     /collectedCount

The value of the given A01 data.

Integer

[Prefs]  Based on the following values.
GA_PHS_SSIE
GA_PHS_SSRE
GA_PHS_SSFIE

R

Back to top

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.

Integer

Derived from:

[Prefs] DistrictNumber +

[Schools]Alternate_School_Number] if greater than 0

Otherwise, [Schools]School_Number

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

[S_GA_SCH_X] GA_CPR_AED

R 

dualEnrollmentAwarenessGrade8

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

Boolean

[S_GA_SCH_X] DualEnrollAware_Grade8

R 

dualEnrollmentAwarenessGrade9

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

Boolean

[S_GA_SCH_X] DualEnrollAware_Grade9

R 

dualEnrollmentAwarenessGrade10

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

Boolean

[S_GA_SCH_X] DualEnrollAware_Grade10

R 

dualEnrollmentAwarenessGrade11

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

Boolean

[S_GA_SCH_X] DualEnrollAware_Grade11

R 

onlineSchool

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

Boolean

[S_GA_SCH_X] GA_OnlineSchool

R 

titleIPartASchoolDesignationDescriptor

Title I School Code Value

String

[S_GA_SCH_X] T1SC

R 

stemSteamSchoolDescriptor

The Steam/Stem value of the school.

String

[S_SCH_X] SteamStem

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

[S_GA_SCH_X]
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

R 

     /collectedCount

The value of the given B01 data.

Integer

[S_GA_SCH_X]
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

R 

socialWorkCaseCounts

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

[S_GA_SCH_X]
SWC_ADS
SWC_ASID
SWC_AS
SWC_FHPSS
SWCC_Homeless
SWC_DS
SWC_SE
SWCC_SpecProg
SWCC_SuicRef

R 

     /collectedCount

The value of the given B01 data.

Integer

R 

socialWorkReferralCounts

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

[S_GA_SCH_X]
SWR_Other
SWR_DFCS
SWR_PH
SWR_JC
SWR_MH

R 

     /collectedCount

The value of the given B01 data.

Integer

R 

socialWorkServiceInterventionCounts

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

[S_GA_SCH_X]
SWS_AgencyVisits
SWS_CWPF
SWS_CACR
SWS_CWO
SWS_CrisisInterv
SWS_EAS
SWS_GrpInterv
SWS_HAV
SWS_CWS

R 

     /collectedCount

The value of the given B01 data.

Integer

R 

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