C01 - Student Level (2022-23) - Legacy

Select Schools

If run at the district level, choose one of the following:

• Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. Select schools to include in the report
• All Schools – Run the report for the entire district.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Current Selection Students

Run the report for the current selection of students or all students.

Report Start Date

Enter the start date of the report.

Note: Enter the date in a format of MM/DD/YYYY.

Report End Date

Enter the end date of the report.

Note: Enter the date in a format of MM/DD/YYYY.

File Path and File Suffix

The File Path and File Suffix must both be valid in order to save the results to a location on the server. The File Name will be the district number, date, and time, in the format dddYYYYMMDDHHmi, followed by the provided file suffix.

For example, a report run at district 999 on August 1, 2017 at 9:15 AM with a suffix of _AAA.txt will save the results to a file named 999201708010915_AAA.txt in the provided location. If no path is given, or if PowerSchool is unable to write to the given folder, the report will run but will not be saved to the server.

Choose an SFTP connection from the pop-up menu to have the report output uploaded automatically.

Please refer to Setting Up a SFTP Connection for details on how to create a SFTP connection.

C001

Fiscal Year

The fiscal year of the record.

The report extracts the year based on the last day in the current school calendar.

[Terms]LastDay

4

1

4

C002

Period

The reporting period.

Always 1.

N/A

1

5

5

C003

System Code

The school system code. This is the district number in PowerSchool.

[Prefs]Value

[Prefs]Name=districtnumber

3

6

8

C004

School Code

The school code.

Note: If the HomeSchool Override Number is set up, it will be used. If not, the alternate school number is reported if populated. Otherwise, the school number is reported.

[S_GA_STU_X]SchoolNumberOverride

[S_GA_REN_X]SchoolNumberOverride

[Schools]Alternate_School_Number

[Schools]School_Number

4

9

12

C005

Filler

Filler

N/A

9

13

21

C006

Record Type

Identifies the record layout.

Always C01.

N/A

3

22

24

C007

Gender

The student’s gender. Should be consistent with data in the GTID.

Note: The legal gender field is extracted, if populated.

[StudentCoreFields]PSCore_Legal_Gender

[Students]Gender

1

25

25

C150

Section 504

Indicates whether the student receives aids and services solely under Section 504, but not under IDEA. Extracted from State/Province – GA > Section 504 Programs Information > 504 Program Enrollment

• Selected = Y
• Not selected = N

[S_GA_STU_504_C]Is504

1

26

26

C009

Date of Birth

The student’s date of birth.

Output format: YYYYMMDD

[Students]DOB

8

27

34

C010

School System of Residence

The code for the Georgia system where the student resides while attending public school, or the System Code for the district or state from which the student was displaced due to natural disaster. Extracted from State/Province - GA > Georgia State Information > Residence and Origin Information > System of Residence.

For a list of codes, see Residence Codes.

Notes:

• This is the district number in PowerSchool for local students. For non-local students, this is the System of Residence.
• If
• If the student is a non-resident of the state of Georgia, use code 800.
• If the Residence code is 925, 926, 927, 928, 929, 930, 931, or 932, Resident Status Code must be 2 - Non-Resident, In-State, Consent.

[Prefs]Value

[Prefs]Name=districtnumber

[Students]Residence_District

3

35

37

C011

County of Residence

The code for the Georgia county where the student resides while attending public school.

For a list of codes, see Residence Codes.

Note: Should be 800 if the student is a non-resident of the state of Georgia.

[S_GA_STU_X] ResidenceCounty

3

38

40

C012

Place of Birth

The student’s country of birth.

[S_GA_STU_X]PlaceOfBirth

4

41

44

C013

Date of Entry into U.S. School

The date the student entered a U.S. school.

Note: This field is required if Place of Birth is not U.S., Guam, Puerto Rice, U.S. Virgin Islands, or U.S. Minor Outlying Islands.

Output format: YYYYMMDD

[Students]dateOfEntryIntoUSA

8

45

52

C093

Steam/Stem Participant

Indicates whether the student participates in a STEAM or STEM Program. Extracted from State/Province - GA > Georgia State Information > Georgia Student Information.

• Y - Yes
• N - No
• O - Other

[S_STU_X]SteamStemParticipant

1

53

53

C014

Retained

Indicates whether the student was retained in the same grade level at the end of the school year.

Note: Value is determined by [Students]GA_StudentStatus. When the Student Status is R then retained is Y.

[S_GA_STU_X]StudentStatus

[S_GA_REN_X]StudentStatus

1

55

55

C015

Date Entered the 9th Grade

The date the student enrolled in the 9^th grade for the first time.

Note: This value is only extracted if the student’s grade level is greater than 9 and less than or equal to 12.

Output format: YYYYMMDD

[S_GA_STU_X] EntryDate_9th

8

56

63

C016

Georgia Test Identifier (GTID)

The identification number used to uniquely identify the student throughout his/her public education years in the Georgia public school system.

[Students]State_StudentNumber

10

64

73

C017

Capstone Project

Indicates whether the student completed a career-related Work-Based Learning Program (WBL) or a career-related Capstone Project

[S_GA_STU_AandI_X]Capstone

[S_GA_REN_AandI_X]Capstone

1

74

74

C018

Active Military

Indicates whether the student has a parent or guardian who is active duty in US Armed Forces, including the National Guard or Reserve.

[S_GA_STU_X]Military_Parent

[S_GA_REN_X]Military_Parent

1

75

75

C019

Alternate Math Sequence

Indicates whether a Student with Disability (SWD) student is taking the alternate course sequence for completing high school math requirements (Y/N flag).

[S_GA_STU_SpecEd_X] AltMathSeq

[S_GA_REN_SpecEd_X] AltMathSeq

1

76

76

Indicates the student has a parent or guardian who is currently in US Armed Forces military reserve.

Must equal one of the following:

• ‘Y’ – Parent or guardian is a member of the military reserves in the U.S. Armed Forces, National Guard or Reserve.
• ‘N’ – Parent or guardian is NOT a member of the military reserves in the U.S. Armed Forces, National Guard or Reserve.
• If blank, MILITARY RESERVE will default to ‘N’.
• If student has one parent or guardian that is MILITARY RESERVE and one parent or guardian that is ACTIVE MILITARY, both data elements may be marked ‘Y’.

77

C020

Grade Level

The student’s grade level.

Note: Grade levels -1 and -2 are extracted as PK. Grade level 0 is extracted as KK.

[Students]Grade_Level

[ReEnrollments]Grade_Level

2

79

80

C021

Graduation Program of Study

The type of diploma toward which the student is working.

Note: This value should only be extracted if the student’s grade level is 9-12.

See Graduation Sets (school level) and the Graduation Progress student page in the Georgia State Reporting Setup for information on this field.

[GradReqSets]Name

1

81

81

C022

CCAE (Coordinated Career Academic Education/Project Success)

Indicates whether a student participated in CCAE (Coordinated Career Academic Education / Project Success) program at any point during the school year.

Note: This field is blank for students not in grades 9-12.

[S_GA_STU_AandI_X]CCAE

[S_GA_REN_AandI_X]CCAE

1

82

82

C023

CTI (Career Technical instruction)

Indicates whether the student was enrolled in CTI (Career Technical Instruction) program at any point during the school year.

Note: This field is blank for students not in grades 9-12.

Note: This field is blank for students who do not have a Special Education primary area selected.

[S_GA_STU_AandI_X]CTI

[S_GA_REN_AandI_X]CTI

1

83

83

C024

Non‐ESOL

Indicates the status of an EL student who is not in ESOL program. Blank for other students.

[S_GA_STU_ESOL_C]Refused

2

84

85

C025

SST/RTI

Indicates whether the student participated in the SST/RTI Level 3 process at any point during the current year.

[S_GA_STU_X] SST

[S_GA_REN_X]SST

1

86

86

Filler

Filler

Filler

N/A

1

87

87

Indicates the language the student's parent/guardian prefers for communications with the school.

Note: When the Parent Communication Language fields is blank, the report extracts 008.

Filler

Filler

Filler

N/A

14

91

101

C027

Ethnic Hispanic

Indicates whether the student is Hispanic or Latino.

[Students]Fedethnicity

1

102

102

C028

Race Indian

Indicates whether the student is American Indian or Alaska Native.

[StudentRace]racecd

[Gen]Cat=race

[Gen]Cat=federalrace

[Gen]Name=I

1

103

103

C029

Race Asian

Indicates whether the student is Asian.

[StudentRace]racecd

[Gen]Cat=race

[Gen]Cat=federalrace

[Gen]Name=S

1

104

104

C030

Race Black

Indicates whether the student is African American.

[StudentRace]racecd

[Gen]Cat=race

[Gen]Cat=federalrace

[Gen]Name=B

1

105

105

C031

Race Pacific

Indicates whether the student is New Hawaiian or Other Pacific Islander.

[StudentRace]racecd

[Gen]Cat=race

[Gen]Cat=federalrace

[Gen]Name=P

1

106

106

C032

Race White

Indicates whether the student is Asian.

[StudentRace]racecd

[Gen]Cat=race

[Gen]Cat=federalrace

[Gen]Name=W

1

107

107

C033

ESOL

Indicates whether the student enrolled in the state-funded ESOL program at any time during the school year.

[S_GA_STU_ESOL_C]ESOL

1

108

108

C034

Free or Reduced Price Meal Eligibility

Indicates whether the student was eligible for the Free or Reduced Price Meal Program at any time during the school year.

Georgia Valid values: F, R, N

Note: PowerSchool LunchStatus is converted to Georgia valid values as follows:

• Free = F
• Reduced = R
• Full Pay = N
• Exempt = N
• Temp = N
• FDC = F

[Students]LunchStatus

1

109

109

C035

Gifted Referral Code

The method used to refer the student to the Gifted program during the school year.

[S_GA_STU_GIFTED_C]ReferralCode

1

110

110

C036

Gifted Eligibility Code

Indicates the student’s eligibility status for the gifted program.

[S_GA_STU_GIFTED_C]EligCode

1

111

111

Filler

1

112

112

C038

English Learner (EL)

Indicates whether the student has limited proficiency in English.

[S_GA_STU_ESOL_C]ELFlag

1

113

113

C039

Migrant

Indicates whether the student was enrolled in the Migrant Education Program at any time during the school year.

[S_GA_STU_X]GA_Migrant

1

114

114

C040

Student Primary Language

The student’s primary spoken language. Defaults to English.

Note: When the Primary Language field is blank, the report extracts 008.

[Students]PrimaryLanguage

3

115

117

Filler

Filler

1

118

118

C042

Indicates if the student is identified as Priority For Service (PFS) by the Migrant Education Program.

Valid values:

• Blank
• Y - Yes
• N - No

Note: When Priority for Service is Null, the report outputs a blank.

Filler

Filler

C044

Student is a single parent.

A code that indicates the type of special needs for the student.

Note: Code 2 is relevant for vocational education students.

[S_GA_STU_X]SpecNeedsCode

[S_GA_REN_X]SpecNeedsCode

1

122

122

C055

Environment Code

The type of residential environment in which the student resided or the type of school the student attended this school year.

[S_GA_STU_X]Residential_Environ

[S_GA_REN_X]Residential_Environ

1

136

136

C056

Primary Area

For students in the Special Education program, indicates the student’s Primary Area (of Exceptionality).

[S_GA_STU_SpecEd_X]PAE

[S_GA_REN_SpecEd_X]PAE

1

137

137

The date the student was identified as a student needing an alternate assessment. (Alternate Content Standards (ACS) = Y)

Extracted from State / Province - GA > Georgia State Information > Georgia Special Education > GAA Eligibility Start Date.

[S_GA_STU_SpecEd_X]GaaEligibilityStartDate

[S_GA_REN_SpecEd_X]GaaEligibilityStartDate

Filler

Filler

Filler

N/A

1

146

146

C058

Extended Year Services

Indicates whether extended year services are provided to the student outside of the regular school day.

Note: This field is extracted when the student’s Primary Area of Exceptionality is populated.

[S_GA_STU_X]ExtYr

1

147

147

C059

Homeless Primary Night Shelter

Indicates the primary night shelter for homeless students.

[S_GA_STU_X]HomelessPrimaryShelter

[S_GA_REN_X]HomelessPrimaryShelter

1

148

148

C092

Date Student Identified No Longer Eligible for Alternate Content Standards (ACS)

The date the student no longer qualifies for alternate assessment.

Alternate Content Standards (ACS) = N

Extracted from State / Province - GA > Georgia State Information > Georgia Special Education > GAA Eligibility End Date.

[S_GA_STU_SpecEd_X]GaaEligibilityEndDate

[S_GA_REN_SpecEd_X]GaaEligibilityEndDate

8

157

164

Filler

C064

Diploma Type

The type of diploma earned by a high school graduate.

Note: This field is extracted if the student’s exit code for their school enrollment is G.

[S_GA_STU_X]DiplomaType

[S_GA_REN_X]DiplomaType

1

166

166

C065

Student Last Name

The student’s last name.

Note: The legal last name field is extracted if populated.

[StudentCoreFields]PSCore_Legal_Last_Name

[Students]Last_Name

30

167

196

C066

Student First Name

The student’s first name.

Note: The legal first name field is extracted if populated.

[StudentCoreFields]PSCore_Legal_First_Name

[Students]First_Name

30

197

226

Filler

Filler

Filler

N/A

7

227

233

C068

Alternate Content Standards (ACS)

The Alternate Content Standards (ACS).

The ACS FLAG is used to identify special education students that have courses accessing the general curriculum and the IEP indicates the ACS is appropriate for the student. The Alternate Content Standards (ACS) is a portfolio-based assessment for students in GRADE LEVEL ‘KK’ – ’12’ who have been identified as having the most significant cognitive disabilities and cannot participate in the general assessment program even with maximum accommodations. Students in grades K, 3-8, and 11 are assessed with the ACS.

Note: Regardless of whether an assessment occurs during the current school year, flag students "Y" for ACS if their IEP states that they will participate in the alternate assessment.

[S_GA_STU_SpecEd_X]GAA_Flag

[S_GA_REN_SpecEd_X]GAA_Flag

1

234

234

C069

Middle Name

The Student’s middle name.

Note: The legal middle name is extracted, if populated.

[StudentCoreFields]PSCore_Legal_Middle_Name

[Students]Middle_Name

30

235

264

C070

Pre-K Program Code

The program the student is participating in for education before Kindergarten.

Blank for non Pre‐K students.

[S_GA_STU_PK_X]ProgramCode

[S_GA_REN_PK_X]ProgramCode

2

265

266

Filler

Filler

Filler

N/A

Indicates whether the student was served in a 21st Century after school program this year.

Valid values:

• Y - Yes
• N - No
• blank

Note: When 21st Century Served is Null, the report outputs a blank.

Filler

Filler

Filler

N/A

4

270

273

C076

Title III Served (Supplemental Funds)

Indicates whether the ESOL student was served with Title III supplemental funds this school year.

[S_GA_STU_ESOL_C]Title3Served

1

274

274

C077

Dual Language Immersion (DLI)

Indicates whether the student is participating in a dual language immersion program where the student spends at least half of their school day in the target language and the other half-day in English.

Note: This field will display only Y if the student has a valid ESOL record at the corresponding school where the CO1 Student’s Report is run.

[S_GA_STU_ESOL_C]DLI

[S_GA_STU_PK_X]DualLanguage

[S_GA_REN_PK_X]DualLanguage

1

275

275

C078

Bi-Lit Language 1

Indicates the student's first language learned for the Graduation Program of Study Bi-Literacy Language Seal.

If there is only one language learned, Language 1 is reported.

Note: "8" - English is not valid for BI-LIT LANGUAGE.

[S_GA_STU_X]BiLitLanguage1

[S_GA_REN_X]BiLitLanguage1

3

276

278

C079

Bi-Lit Language 2

Indicates the student's second language learned for the Graduation Program of Study Bi-Literacy Language Seal.

If there are two languages learned, Language 1 and 2 are reported.

Note: "8" - English is not valid for BI-LIT LANGUAGE.

[S_GA_STU_X]BiLitLanguage2

[S_GA_REN_X]BiLitLanguage2

3

279

281

C080

Bi-Lit Language 3

Indicates the third language learned for the Graduation Program of Study Bi-Literacy Language Seal.

Language 3 is reported only when there are three languages.

Note: "8" - English is not valid for BI-LIT LANGUAGE.

[S_GA_STU_X]BiLitLanguage3

[S_GA_REN_X]BiLitLanguage3

3

282

284

Indicates the student completed all English Language Arts requirements for graduation with an overall grade point average of 3.0 or higher in the English Courses and who showed proficiency in one or more foreign languages other than English, demonstrated by passing a foreign language advanced placement exam with a score of 4 or higher. Extracted from State/Province – GA > General Info tab > Bi-Literacy Diploma Seal

Valid Values:

• Y - Yes
• N - No
• If field is blank, N is extracted
• Note: Cannot be blank if WITHDRAWAL REASON = ‘G’.

Note: When Bi-Literacy Diploma Seal is Y, Language 1 is required.

Indicates whether this is a graduating high school student who completed the social studies requirements for graduation and engaged in civic engagement activities. Extracted from State/Province – GA > General Info tab > Civic Engagement Diploma Seal.

Valid values:

• Y - Yes
• N - No
• If field is blank, N is extracted

Note: Cannot be blank if WITHDRAWAL REASON = ‘G’.

Indicates whether this is a graduating high school student who completed a Georgia Fine Arts Pathway and engaged in creative industry focus courses, extracurricular activities, and experiences that foster fine arts mastery. Extracted from State/Province – GA > General Info tab > Fine Arts Diploma Seal.

Valid values:

• Y - Yes
• N - No
• If field is blank, N is extracted

Note: Cannot be blank if WITHDRAWAL REASON = ‘G’.

Indicates whether this is a high school student who completed an international education curriculum and engaged in extracurricular activities and experiences that foster the achievement of global competencies. Extracted from State/Province – GA > General Info tab > International Skills Diploma Seal.

Valid values:

• Y - Yes
• N - No
• If field is blank, N is extracted

Note: Cannot be blank if WITHDRAWAL REASON = ‘G’.

The CTAE seal indicates that the student has completed all the requirements for a given CTAE seal. A student can earn more than one CTAE seal, but not two in the same area. Not all students who graduate will earn a CTAE seal.

Indicates the student’s CTAE Employability / Soft Skills Seal status. Extracted from State/Province – GA > General Info tab> CTAE Employability / Soft Skills Seal

• Y – Yes
• N – No
• D – Distinguished
• If field is blank, N is extracted.

Note: Cannot be blank if WITHDRAWAL REASON = ‘G’.

The CTAE seal indicates that the student has completed all the requirements for a given CTAE seal. A student can earn more than one CTAE seal, but not two in the same area. Not all students who graduate will earn a CTAE seal.

Indicates the student’s CTAE Pathway Skills Seal status. Extracted from State/Province – GA > General Info tab > CTAE Pathway Skills Seal

• Y – Yes
• N – No
• D – Distinguished
• If field is blank, N is extracted.

Note: Cannot be blank if WITHDRAWAL REASON = ‘G’.

The CTAE seal indicates that the student has completed all the requirements for a given CTAE seal. A student can earn more than one CTAE seal, but not two in the same area. Not all students who graduate will earn a CTAE seal.

Indicates the student’s CTAE Leadership Skills Seal status. Extracted from State/Province – GA > General Info tab > CTAE Leadership Skills Seal

• Y – Yes
• N – No
• D – Distinguished
• If field is blank, N is extracted.

Note: Cannot be blank if WITHDRAWAL REASON = ‘G’.

Indicates if a student has been identified with disease covered under the 504 Plan. Extracted from State/Province – GA > Section 504 tab.

Valid values:

• Y
• N

Indicates that this student participated in the program for immigrant children and youth funded under ESEA, as amended, Title III Section 3114(d)(1) using funds reserved for immigrant education this school year. For SR, E2198 will be an error, E2198 -IMMIGRANT PROGRAM PARTICIPATION is ‘Y’. U.S. SCHOOL LESS THAN 3 YEARS must be Y.

Valid values:

• Y
• N (default value)