C01 - Student Level (2019-20) - 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

C008

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 Ninth 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 Parent

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

C026

US School less than 3 Years

Indicates whether the student has been enrolled in a US school for less than 3 years (i.e., accumulated 36 months).

[S_GA_STU_X]LT_3_YearsUSSch

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

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.

C043

The reason the student exited the EL program. Extracted from State/Province > Georgia State Information > EL/ESOL > EL Exit Reason.

Valid values:

• 1 – ACCESS for EL proficiency
• 2 – Language Assessment Conference (LAC)
  
• 3 – Exited out of state or from a non-public school
• 4 – Reclassification Team Decision
• Blank – N/A

Notes:

• EL Exit Reason must be populated when EL Information Code = 1, 2, 3, or 4
• EL Exit Reason 2 - (LAC) is only valid when EL Information Code = 2, 3, or 4

1

120

120

Filler

Filler

Filler

N/A

1

121

121

C044

Special Needs Code

A code that indicates the student’s special needs.

[S_GA_STU_X]SpecNeedsCode

[S_GA_REN_X]SpecNeedsCode

1

122

122

C045

Title I Participant Code – Reading / English / Language Arts

Indicates whether the student received Title I funded service in Reading, English and/or Language Arts this school year.

[S_GA_STU_TitleI_X]RELA

[S_GA_REN_TitleI_X]RELA

1

123

123

C046

Title I Participant Code – Mathematics

Indicates whether the student received Title I funded service in Mathematics this school year.

[S_GA_STU_TitleI_X]Math

[S_GA_REN_TitleI_X]Math

1

124

124

C047

Title I Participant Code – Science

Indicates whether the student received Title I funded service in Science this school year.

[S_GA_STU_TitleI_X]Science

[S_GA_REN_TitleI_X]Science

1

125

125

C048

Title I Participant Code – Social Studies

Indicates whether the student received Title I funded service in Social Studies this school year.

[S_GA_STU_TitleI_X]SocStud

[S_GA_REN_TitleI_X]SocStud

1

126

126

Filler

Filler

Filler

N/A

3

127

129

C049

Title I Participant Code – Guidance / Counseling / Social Work

Indicates whether the student received Title I funded service in Guidance, Counseling and/or Social Work this school year.

[S_GA_STU_TitleI_X]GCSocWrk

[S_GA_REN_TitleI_X]GCSocWrk

1

130

130

C050

Title I Participant Code – Health / Dental

Indicates whether the student received Title I funded service in Health and/or Dental this school year.

[S_GA_STU_TitleI_X]HealthDental

[S_GA_REN_TitleI_X]HealthDental

1

131

131

C051

Title I Participant Code – Nutrition

Indicates whether the student received Title I funded service in Nutrition this school year.

[S_GA_STU_TitleI_X]Nutrition

[S_GA_REN_TitleI_X]Nutrition

1

132

132

C052

Title I Participant Code – Pupil Transportation

Indicates whether the student received Title I funded service in Pupil Transportation this school year.

[S_GA_STU_TitleI_X]Transport

[S_GA_REN_TitleI_X]Transport

1

133

133

C053

Title I Participant Code – Job Preparation

Indicates whether the student received Title I funded service in Job Preparation this school year.

[S_GA_STU_TitleI_X]JobPrep

[S_GA_REN_TitleI_X]JobPrep

1

134

134

C054

Title I Participant Code – High School Equivalency / GED

Indicates whether the student received Title I funded service in High School Equivalency this school year.

[S_GA_STU_TitleI_X]HSGED

[S_GA_REN_TitleI_X]HSGED

1

135

135

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

Special Education – 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. 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 GAA

The date the student no longer qualifies for GAA. 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

Indicates if this 8th grade student completed a Career Aptitude Inventory during the academic year and saved the results in their personal career portfolio.

[S_GA_STU_X]CareerAptitudeInv8thGrade

[Students]Grade_Level

[ReEnrollments]Grade_Level

Blank for students not in 8th grade.

Indicates whether this 10th grade student completed a Career Aptitude Inventory during the academic year and saved the results in their personal career portfolio.

[S_GA_STU_X]CareerAptitudeInv10thGrade

[Students]Grade_Level

[ReEnrollments]Grade_Level

Blank for students not in 10th grade.

Filler

Filler

Filler

N/A

5

229

233

C068

GAA

The Georgia Alternate Assessment.

The GAA FLAG is used to identify special education students that have courses accessing the general curriculum and the IEP indicates the GAA is appropriate for the student. The Georgia Alternate Assessment (GAA) 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 GAA.

Note: Regardless of whether an assessment occurs during the current school year, flag students "Y" for GAA 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

C071

Career Interest Inventories (MS)

The number of Career Interest Inventories completed by the student in the current year. Valid for Grade Levels 06 thru 08.

[S_GA_STU_AandI_X]CareerInventories

[S_GA_REN_AandI_X]CareerInventories

Blank for students not in grades 6-8.

2

267

268

C072

Career Awareness Lessons (ES)

The number of Career Awareness Lessons completed by the student in the current year. Valid for Grade Levels 01 thru 05.

[S_GA_STU_AandI_X]CareerAwareness

[S_GA_REN_AandI_X]CareerAwareness

Blank for students not in grades 1-5.

2

269

270

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.

C073

Filler

Filler

N/A

1

270

272

C075

Individual Graduation

Plan (MS)

The Y/N designation for 8th grade students based on the status of completing Individual Graduation Plan (Middle School).

[S_GA_STU_AandI_X]IndGradPlan

[S_GA_REN_AandI_X]IndGradPlan

Blank for students not in grade 8.

1

273

273

C076

Title III Served

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

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.

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

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

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

[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: 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

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

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

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.

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.

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.