P01 - Student Class (2018-2019) - 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.

Report Count Date

Enter the DOE count date for the report.

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

Include Local Courses (00.)

Select "Yes" from the popup to include section enrollments associated with course numbers beginning with 00. These are excluded by default (see Selection Criteria).

Select a Numeric Grade output:

• Percent - Outputs the numeric value in Percent field/Grade field for Numeric Grade and non-numeric value in Grade field for Alpha Grade.
• Alpha Grade - Outputs the non-numeric value in Grade field for Alpha Grade. Numeric Grade will always be Blank.

Select a Content Completer output:

• Set all values to P -  Outputs the Content Completer as P.
• Percent - Output is based on [StoredGrades] table as follows:
  • [StoredGrades]Percent is 0 output P
  • [StoredGrades]Percent is >0 and < 70 output F
  • [StoredGrades]Percent is >= 70 output P
  • [StoredGrades]Percent is null output blank
• Use Alpha Grade - Output is based on [StoredGrades]Grade as follows:
  • StoredGrades]Grade is (A, B, C, D, E, M, P) output P
  • [StoredGrades]Grade is (F, N) output F
  • [StoredGrades]Grade is not (A, B, C, D, E, F, M, N, P) output blank

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, 2014 at 9:15 AM with a suffix of _AAA.txt will save the results to a file named 999201408010915_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 an SFTP connection.

P001

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

P002

Period

The code that represents the reporting period for the collection cycle.

Must equal ‘A’ for all periods: 'A' - All PERIODS (July, August, September, October, November, December, January, February, March, April, May, June)

N/A

1

P003

System Code

The 3-digit system code that identifies the school district for state reporting.

[Prefs]Value

[Prefs]Name=districtnumber

3

P004

School Code

The 4-digit school code that identifies the school for state reporting. School Code will check against the Facilities database for active, FTE data reporting schools (E050).

Note: The alternate school number is reported, if populated. Otherwise, the school number is reported.

[Schools]Alternate_School_Number

[Schools]School_Number

4

P005

Record Type

Identifies the record type.

The value is extracted as Pnn where nn is used to list the number of courses assigned to the student, from 01 to 75.

N/A

3

P006

Filler

Filler

N/A

9

P007

GTID

The student’s Georgia Testing Identifier.

[Students]State_StudentNumber

10

P008

Student Last Name

The student last name.

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

[StudentCoreFields]PSCore_Legal_Last_Name

[Students]Last_Name

30

P009

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

P010

Student 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

P011

Grade Level

The student’s grade level.

[Students]Grade_Level

[ReEnrollments]Grade_Level

2

P012

Filler

Filler

N/A

25

P013

Marking Period

The length of the course for which the final grade is awarded.

Note: The report refers to the term associated with the section and uses the term portion field to determine the marking period. The term portion is set when creating terms for the school year via School Setup > Years & Terms > Edit Terms.

[Terms]Portion = 1, 2, 3, 4, or 6

[CC]TermID = [Terms]ID

2

P014

Course Number

The number designating an official course.

Note: By default, the report does not include courses with a course number that begins with 00.

Note: The Course_Number is formatted with a decimal in the third position.

[Courses]Course_Number

10

P015

Class Section Number

The section number, used to identify a unique meeting of the course.

[Sections]Section_Number

3

P016

Class Period

The start period for the course in the student’s schedule, based on the section expression. For example, if the expression is 2-3 (A-B), then the starting period is 02.

[Sections]Expression

2

P017

Filler

N/A

1

Note: There is a run-time option to control the data in this field. See Report Input information above.

The numerical final grade for the marking period.

The report rounds partial percentage grades to whole numbers.

Examples: 87.49 or less becomes 87; 86.5 or greater becomes 87.

Notes:

• If the Alpha Grade is A, B, C, D, E, M, or P and the Numeric Grade is 0 or blank, the Numeric Grade is reported as null.
• If Alpha Grade is I or Z, Numeric Grade is reported as null.
• If no grade is expected from this course, this field is reported as null.

[StoredGrades]Percent

[StoredGrades]Grade

[S_GA_SGR_X]NoGradeExpected

[S_GA_CC_X]NoGradeExpected

[S_GA_SEC_X]NoGradeExpected

[S_GA_CRS_X]NoGradeExpected

The letter final grade for the marking period.

Notes:

• If Alpha Grade is I or Z, Numeric Grade is reported as null.
• Dropped classes are reported as Z.
• If no grade is expected from this course, this field is reported as Z.

[StoredGrades]Grade

[S_GA_SGR_X]NoGradeExpected

[S_GA_CC_X]NoGradeExpected

[S_GA_SEC_X]NoGradeExpected

[S_GA_CRS_X]NoGradeExpected

P020

Filler

Filler

N/A

1

P021

Online Course

Indicates if the student is taking this course online.

Valid values:

• Y
• N
• Blank

[S_GA_CRS_X]LocEnroll

[S_GA_SEC_X]LocEnroll

[S_GA_SCH_X]OnlineSchool

[S_GA_CC_X]OnlineCourse

1

P022

Filler

Filler

N/A

15

P023

Course Teacher Code

Identifies the teacher of the course.

Note: If the Override Teacher SSN is set up, it will be extracted.

[Users]SSN

[SectionTeacher]Teacherid = [Teachers]ID

[SectionTeacher]Sectionid = [Sections]id

[S_GA_SEC_X]TEACHER_SSN_OVERRIDE

[S_GA_CRS_X]TEACHER_SSN_OVERRIDE

9

P024

Additional Course Teacher Code 1

Identifies the Additional Course Teacher Code 1 of the teacher assigned to assist this student or all students in the class.

[Sections]GA_AdditionalTeacher1

P025

Additional Course Teacher Code 2

Identifies the Additional Course Teacher Code 2 of the teacher assigned to assist this student or all students in the class.

[Sections]GA_AdditionalTeacher2

P026

Additional Course Teacher Code 3

Identifies the Additional Course Teacher Code 3 of the teacher assigned to assist this student or all students in the class.

[Sections]GA_AdditionalTeacher3

P027

# of Paraprofessionals

A paraprofessional employee assigned to provide support to the entire class.

[Sections]GA_ParaPro

1

P028

Co-Teacher

Enter ‘Y’ if this class has a co- teacher assigned. Enter ‘N’ if no co-teacher is assigned to the class.

Determined based on the whether the class uses the co-teaching special education delivery model.

[S_GA_SEC_X]SPED_Delivery_Model=3

1

P029

Filler

Filler

N/A

9

P030

Primary Area

Indicates the student’s primary area of exceptionality.

Note: Primary Area is only extracted when course numbers end with .8 or .9, or begin with PK.00300xx or PK.00400xx, or when the inclusion code is not blank.

[S_GA_STU_SpecEd_X]PAE

[S_GA_CC_XInclusionCode

[S_GA_SEC_X]InclusionCode

[S_GA_CRS_X]InclusionCode

1

P031

Inclusion Code

The Inclusion Code indicates that a student with disabilities has an individualized education program (IEP) that identifies the general education classroom as the least restrictive environment for the delivery of special education services for that course.

[S_GA_CC_X]InclusionCode

[S_GA_SEC_X]InclusionCode

[S_GA_CRS_X]InclusionCode

1

P032

Gifted Delivery Model

The Gifted Delivery Model represents the method by which gifted services are delivered.

[Sections]GA_GiftedDelivery

Or, if blank, then:

[S_GA_CRS_X]GiftedDelivery

1

P033

ESOL Delivery Model

The ESOL Delivery Model represents the method EL LEARNER services are delivered.

[S_GA_SEC_X]ESOLDelivery

[S_GA_STU_ESOL_C]ESOL

[S_GA_STU_ESOL_C]EnrollmentDate

[S_GA_STU_ESOL_C]ExitDate

1

P034

EIP Delivery Model

The EIP Delivery Model represents the instructional model used to deliver EIP services to students.

[S_GA_SEC_X]EIPDelivery

1

P035

Credit Recovery

Flag to indicate that the student is taking this course as Credit Recovery.

[S_GA_SGR_X]CreditRecovery

[StoredGrades]Sectionid = [Sections]id

[S_GA_CC_X]CreditRecovery

[S_GA_SEC_X]CreditRecovery

[S_GA_CRS_X]CreditRecovery

1

P036

N/A

13

The number of Carnegie Units the high school student earned for the course.

Note: If Alpha Grade = Z, and the associated Course Number does not have a three (3) as the fifth digit after the decimal (xx.xxxx3xx), this field is reported as null.

[StoredGrades]EarnedCrHrs

4

P038

N/A

1

P039

Local Course Name

The local course name used to identify the course on the teacher roster and grade book. If blank, default display will be the official course name as defined in board rule.

[Courses]Course_Name

31

P040

Student Class Start Date

Enter the date the student enrolled in the class.

[CC] DateEnrolled

8

P041

Student Class End Date

Enter the date the student exited the class.

[CC]DateLeft

8

P042

Primary Teacher Last Name

Enter the last name of the primary teacher (Course Teacher Code field).

Note: If the Override Teacher Last Name is set up, it will be extracted.

[S_GA_USER_X]Tch_Legal_Last_Name

[Users]Last_Name

[S_GA_SEC_X]TEACHER_LASTNAME_OVERRIDE

[S_GA_CRS_X]TEACHER_LASTNAME_OVERRIDE

30

P043

Primary Teacher First Name

Enter the FIRST NAME of the primary teacher (Course Teacher Code field).

Note: If the Override Teacher First Name is set up, it will be extracted.

[S_GA_USER_X]Tch_Legal_First_Name

[Users] First_Name

[S_GA_SEC_X]TEACHER_FIRSTNAME_OVERRIDE

[S_GA_CRS_X]TEACHER_FIRSTNAME_OVERRIDE

30

P044

Filler

Filler

N/A

35

P045

Alternate System Code

Enter the system code for the alternate school code reported for the course.

The alternate system code must be entered in a program enrollment for the program linked to the section where the student is enrolled.

[Courses]ProgramID

[Sections]ProgramID

[S_GA_SEN_X]AltSchNumber

3

P046

Alternate School Code

Enter the alternate school code for the program or school where the student is concurrently enrolled. EX: If the student takes the course at a GNETS program, then enter the program code for GNETS.

The alternate school code must be entered in a program enrollment for the program linked to the section where the student is enrolled.

[Courses]ProgramID

[Sections]ProgramID

[S_GA_SEN_X]AltSchNumber

4

[S_GA_SEC_X]ImmersionLanguage

P048

Indicates whether the instructor taught the course for at least 90% of the class instructional days.

Note: Teacher 90% fields will be reported based on the higher priority override fields. If no override is provided, the calculated value of Yes/No will be extracted. 

Valid values:

• Y - Yes (Default)
• N - No
• Blanks are extracted as 'N'.

[S_GA_STC_X]CRSTCHCD90PERATTOVERRIDE

Or

[S_GA_STC_X]CRSTCHCD90PERATTENDANCE

Calculated: (Total number of school days the Lead Teacher is assigned to the section/ Number of school days in the term) *100

1

Indicates whether the additional instructor taught the course for at least 90% of class instructional days.

Note: Teacher 90% fields will be reported based on the higher priority override fields. If no override is provided, the calculated value of Yes/No will be extracted. 

Valid values:

• Y - Yes (Default)
• N - No
• Blanks are extracted as 'N'.

[S_GA_STC_X]ADDCRSTCHCD190PERATTOR

Or

[S_GA_STC_X]CRSTCHCD90PERATTENDANCE

Calculated: (Total number of school days the Additional Teacher 1 is assigned to the section/ Number of school days in the term) *100

Indicates whether the additional instructor taught the course for at least 90% of class instructional days.

Note: Teacher 90% fields will be reported based on the higher priority override fields. If no override is provided, the calculated value of Yes/No will be extracted. 

Valid values:

• Y - Yes (Default)
• N - No
• Blanks are extracted as 'N'.

[S_GA_STC_X]ADDCRSTCHCD290PERATTOR

Or

[S_GA_STC_X]CRSTCHCD90PERATTENDANCE

Calculated: (Total number of school days the Additional Teacher 2 is assigned to the section/ Number of school days in the term) *100

Indicates whether the additional instructor taught the course for at least 90% of class instructional days.

Note: Teacher 90% fields will be reported based on the higher priority override fields. If no override is provided, the calculated value of Yes/No will be extracted. 

Valid values:

• Y - Yes (Default)
• N - No
• Blanks are extracted as 'N'.

[S_GA_STC_X]ADDCRSTCHCD390PERATTOR

Or

[S_GA_STC_X]CRSTCHCD90PERATTENDANCE

Calculated: (Total number of school days the Additional Teacher 3 is assigned to the section/ Number of school days in the term) *100

Indicates whether the student was present for at least 90% of class instructional days.

Note: Student 90% field will be reported based on the higher priority override fields. If no override is provided, the calculated value of Yes/No will be extracted. 

Valid values:

• Y - Yes (Default)
• N - No

[S_GA_CC_X]STUD90PERATTOVERRIDE

Or

[S_GA_CC_X]STUD90PERATTENDANCE

Calculated: ((Number of days the student is enrolled in the class and the class is in session - Number of days student is absent in the class and the class is in session) / Number of days the class is in-session) * 100

Indicates the type of Work-Based Learning Program in which a student is enrolled.

Valid values:

• Blanks are extracted as 'N'.
• C - Cooperative Education
• I - Internship
• G - Great Promise Partnership
• E - Employability Skills Development
• Y - Youth Apprenticeship Program

[S_GA_CC_X]CATOFWBLPRG

[S_GA_SEC_X]CATOFWBLPRG

[S_GA_CRS_X]CATOFWBLPRG