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
localEducationAgencyReference A reference to the related School resource.				R
/localEducationAgencyId	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

Back to top