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 |
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 |
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:
| String | [Prefs] Based on the following values. | 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:
| 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 |
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:
| String | [S_GA_SCH_X] | 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:
| 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:
| 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:
| 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 |