Skip to main content
Skip table of contents

C01 - Student Level (2018-19) - Legacy

Introduction

The C01 – Student Level (2018-19) report extracts student level demographic, enrollment, and program participation data for the 2018-19 school year. One record is transmitted for each student at each school in the system. Students may have multiple student level records, but not more than one at the same school.

Selection Criteria

Selection criteria determine which database records are used in the report.

Student Selection

  • The student must be enrolled in the school chosen at report runtime. Students who are enrolled in multiple schools during the report period will have separate records for each school if the report is run district wide.
  • The student must have been enrolled on or before the current date.
  • The student must not be excluded from state reporting.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

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.

SFTP Connections


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.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

ID

Data Element

Description

 [Table]FieldName

Length

Start

End

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

(Formerly Student ID)

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

Filler

Filler

Filler

N/A

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.

Note: This is the district number in PowerSchool for local students. For non-local students this is the System of Residence.       

Note: Use code of 800 if the student is a non-resident of the state of Georgia.

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

Note: Use code of 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

Filler

Filler

Filler

N/A

2

53

54

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 9th 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

C081Military Reserve

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’.
[S_GA_STU_X]MilitaryReserve177

77

FillerFillerFiller
17878

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

C099Parent Communication Language

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

[S_GA_STU_X]ParentCommunicationLang38890

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

FillerFillerN/A

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.

[Students]primarylanguage

3

115

117

C041

Remedial Education Subject Code

The academic subjects for which the student received Remedial Education Program (REP) services at any time during this school year.

Note: This value should only be extracted if the student’s grade level is 6-12 and the student is not at an elementary school.

[S_GA_STU_X]RESC

[S_GA_REN_X]RESC

1

118

118

C042

Priority for Service

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.

[S_STU_X]PriorityForService1119119

C043

EL Monitor BasisIndicates the student's El Monitor Basis.[S_GA_STU_ESOL_C]EL_MonitorBasis

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

C057

Filler

(Formerly Previous Student ID)

N/A

9

138

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

C100Date of ELP ScreenerThe date the student was first tested for EL program eligibility.[S_GA_STU_X]DateofELPScreener8149156

Filler

Filler

Filler

N/A

8

157

164

C081Diploma Seal

Indicates the diploma seal for which the student qualifies.

[S_GA_STU_X]DiplomaSeal1165165

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

C080Career Aptitude Inventory 8th Grade

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.

1227227
C081Career Interest Aptitude Inventory 10th Grade

Indicates if 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.

1228228

Filler

Filler

Filler

N/A

1

229

232

C067

EIP Subject Code

Academic subject(s) in which the student received Early Intervention Program (EIP) services at any time during this school year.

[S_GA_STU_EIP_C]SubjectCode

1

233

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

C08821st Century Served

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

Valid values:

  • Blank
  • Y - Yes
  • N - No

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

[S_STU_X]TwentyFirstCenturyServed1269269

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 that 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 that 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 first language learned for the Graduation Program of Study Bi-Literacy Language Seal.

If only one language to report, use Language 1.

[S_GA_STU_X]BiLitLanguage1

[S_GA_REN_X]BiLitLanguage1

3

276

278

C079

Bi-Lit Language 2

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

If two languages to report, use Language 1 and 2.

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

Only use Language 3 when reporting three languages.

[S_GA_STU_X]BiLitLanguage3

[S_GA_REN_X]BiLitLanguage3

3

282

284

FillerFillerFillerN/A16285300

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.