AAR

Choose which school(s) to include in the report by selecting one of the following options:

At the school level:

• The currently selected school is the default.

At the district level:

• Select Multiple Schools – Use the Ctrl or SHIFT key on your keyboard to click each school for which you want to run the extract.
• All Schools (default) – The report includes all student records on the PowerSchool server that meet the selection criteria.

Choose which students to include in the report by selecting one of the following options:

• The Selected [number] Students Only – Run the report for students in the current selection.
• All students – Run the report for all students in the current school or district that meet the selection criteria.

Note: If you are running the AAR by Student Number, Grade, Last Initials or Student Selection,

• enter up to ten student numbers for which to run the report.
• this option is not available when running by grade level.

Select Yes or No to indicate if inactive students should be included.

Note: To print for graduates who have been transferred out, this option must be set to Yes.

Select the School Year.

During the summer when one school year has ended and the next has not yet started, enter the new school year to print transcripts for students in the upcoming year, or enter the prior school year to print for students in the prior year (such as graduated seniors). This option defaults to the current school year after the new school year starts.

Choose a student sort option.

• Name, Grade (default)
• Grade, Name.

Note: If the report is run from the district level, the report sorts first by the school and then by the selected student sort option.

Choose an option for parent/guardian information.

• Legacy Contacts
• Student Contacts

Choose a course sort option.

• Subject Area (default)
• School Year

Choose a format for how the course name is displayed.

• Abbreviated Course Name (default)
• Abbreviated Course Name - Service ID
• Local Course Name

Choose how to display the grade.

• Percent (default)
• Letter

If Percent is selected, but not populated in the stored grades record, the report examines and outputs the Letter grade if populated.

Select Yes (default) or No to indicate whether to include averages.

If yes, averages will be included if the final average store code is mapped in TX Store Code Mappings to Final Grade and to type of Average. Additionally, if the AAR Average Override field in the stored grades record is populated, this value will print in the AV column. If the Override is populated within a normal final grade store code record such as S1, or S2, the average will always display in the AV column regardless of mapping.

If ACT/SAT scores are set to be included, select an option.

• Report 1 record with highest combined scores
• Report 2 records with highest overall scores

Select an option for inclusion of EOC assessment waivers and/or substitution assessments.

• Include Both Waivers and Substitutions
• Include Waivers Only
• Include Substitutions Only
• Do Not Include Waivers or Substitutions

Incomplete grades other than "I" must be specified.

• Leave blank to use default of "I".
• Enter any other Incomplete grade code(s) used by the district; separate with commas (no spaces) if entering multiple grades.

Class Rank and GPA Options

Select Yes or No (default) to indicate whether to exclude the Class Rank.

Note: If Yes, the Class Rank displays as DNR (Does Not Rank), and the Class Size, Quartile, and Class Rank Date display as blank.

Choose display class rank for:

• All Students
• Top X % of Class Only

If Top X % is selected, specify the percentile to include: 0 for 10%, 15 for 15%, etc.

This options uses a similar percentile calculation as in the core Class Ranking Report

If 10% is specified: students with a Percentile = or < 10.00 are included.

If 15 % is specified: students with a Percentile = of < 15.00 are included.

For students whose ranks fall below the specified percentage:

Class Rank Date, Quartile and Class Size display as blank.

Class Rank displays as “DNR.”

High School Official GPA displays with the calculated GPA.

• Class Rank Table

  • If selected, the Select Class Rank/GPA Method parameter is displayed.

• Texas Stored Class Rank with these additional options

  • Graduates Only

  • All Students

  • Do Not Use

Choose the Class Rank/GPA Method. This list is populated from School > Class Rank > Class Rank Methods.

Note: This field is required if Exclude Class Rank is No.

Choose the GPA 2 method. This list is populated from District > GPA Calculations > GPA Calculation Methods. Optional.

If a GPA is selected but is not populated in PowerSchool, the report calculates the GPA as the report is run.

Choose the GPA 3 method. This list is populated from District > GPA Calculations > GPA Calculation Methods. Optional.

If a GPA is selected but is not populated in PowerSchool, the report calculates the GPA as the report is run.

Class Rank Date Override

Leave blank to use Date from Class Rank Table or Texas Stored Rank.

Enter the transcript date. This date appears as the date in the Signature Line in the school header section.

Select Yes or No (default) to indicate that the digital image of the school's official as stored in Custom Page Management should be included.

Note: To use this feature, each school's digital signature must be loaded in Custom Page Management and the Registrar Digital Signature must be selected in Schools/School Info.

Select Yes or No (default) to indicate if the graduation seal should be displayed in the lower right corner.

Note: This option applies only to graduates with a value in the Date of Graduation field on the Graduation Information page. The Graduation Seal is always suppressed for non-graduates, regardless of the parameter selection.

The student's full legal name.

Format: Last Name, First Name Middle Name Generation Code

[Students]Last_Name

[Students]First_Name

[Students]Middle_Name

StudentCoreFields.PSCore_Legal_Suffix

[Students]Address

[Students]City

[Students]State

[Students]Zip

The student's parent(s) or guardian.

Format: Father Last, First / Mother Last, First or Guardian Last /First

Sourced from Student Contacts or the Legacy Mother/Father/Guardian fields depending on the option selected at runtime in the "Source for Contacts" parameter.

Students enrolled in the 2010-11 school year or later: [Students]FedEthnicity

Students enrolled in the 2009-10 school year or earlier: [Students]Ethnicity

The student's race.

Students enrolled in the 2010-11 school year or later: [StudentRace]RaceCD

Students enrolled in the 2009-10 school year or earlier: not reported

The student’s local identification number.

[Students]Student_Number

The student's Social Security Number (SSN) or a state alternate ID.

Note: The student's SSN is only reported if the Include SSN runtime parameter is set to Yes.

[Students]SSN

The student's Texas Unique Student ID Number.

[Students]State_StudentNumber

The student's birthdate.

[Students]DOB

The student's gender.

[Students]Gender

The student's grade level.

Note: Graduates are reported as Grade 12 even if assigned a different grade level such as 99.

The name of the student's current or most recent school of enrollment.

[Students]SchoolID

[Reenrollments]SchoolID

[Schools]Name

The school's address.

[Schools]SchoolAddress

[Schools]SchoolCity

[Schools]SchoolState

[Schools]SchoolZip

County District Campus number

Note: If the Alternate_School_Number is greater than 0, this value will be used on reports rather than the School Number.

[Prefs]DistrictNumber

[Schools]School_Number

[Schools]Alternate_School_Number 

The school's College Board/ACT Campus Number.

[Schools]CBCC_Number

The school's phone number.

[Schools]SchoolPhone

A signature line where the official signature can be manually entered or stamped.

A title line where the official title of the signer can be manually entered or stamped.

The date of the transcript.

Based on the value entered at runtime in the Transcript Date parameter selection.

Schools Awarding Credit

Note: This section sorts school information in ascending order, from least recent term to most recent term.

Historical year

The academic year in the stored grades record.

[StoredGrades]TermID

CDC #

The 9-digit County District Campus Number of the Texas public school or charter awarding credit.

For coursework completed at a non-public school or a school outside of Texas, the Alternate CDC Number and School Name fields in historical grades must be entered. 

• If Alternate CDC Number is populated, the report checks for a matching CDC in the district; if a match is found, the name of the PowerSchool campus is output.
• If there is no match to a district school, the name of the School entered in the Stored Grades record is output.

[StoredGrades]Alternate_CDC

[StoredGrades]SchoolID

[Prefs]DistrictNumber

[Schools]School_Number

[Schools]Alternate_School_Number

School Name

The name of the Texas public school awarding credit.

• If an Alternate CDC Number outside the district is entered in historical grades, the corresponding Alternate School Name should also be entered and will be displayed.
• Otherwise, the district School Name is displayed.

[StoredGrades]Alternate_CDC_SchoolName

[StoredGrades]SchoolName

Courses

Note: Hierarchy of Sources

• Overrides entered in Historical Grades
• Overrides entered in Sections
• Default value from Courses

[S_TX_SGR_X]AAR_Subject_Category

[S_TX_SEC_X]AAR_Subject_Category

[S_TX_CRS_X]AAR_Subject_Category

The name of the course. The format is based on the option selected at runtime in the Course Name Format parameter.

Abbreviated Course Name:

[S_TX_SGR_X]Abbrev_Course_Name

[S_TX_SEC_X]Abbrev_Course_Name

[S_TX_CRS_X]Abbrev_Course_Name

Service ID:

[S_TX_SGR_X]Alt_Course_Number

[S_TX_SEC_X]Alt_Course_Number

[CoursesCoreFields]Alt_Course_Number

Local Course Name:

[StoredGrades]Course_Name

[Courses]Course_Name

The stored grade earned for a store code flagged as Final Grade and mapped as Final Grade Type of "S1" in TX store code mapping. 

[StoredGrades]Grade

[StoredGrades]Percent

If Percent is blank or 0 and Percent was selected at runtime in the Grade Display parameter, then the value is pulled from [StoredGrades]Grade if available.

The Explanation code or codes associated with the stored grade.

Note: If the student has an Explanation code of V, the code is not reported.

Derived from:

[S_TX_SGR_X]Explanation_Code_Combined

[S_TX_SEC_X]Explanation_Code_Combined

[S_TX_CRS_X]Explanation_Code_Combined

The stored grade earned for a store code mapped as Final Grade Type "S2" in TX store code mapping. 

[StoredGrades]Grade

[StoredGrades]Percent

If Percent is blank or 0 and Percent was selected at runtime in the Grade Display parameter, then the value is pulled from [StoredGrades]Grade if available.

Derived from:

[S_TX_SGR_X]Explanation_Code_Combined

[S_TX_SEC_X]Explanation_Code_Combined

[S_TX_CRS_X]Explanation_Code_Combined

The final average for the course. 

• The average is output for store codes mapped as Final Grade Type of "Average" (AV) in TX store code mapping.
• The runtime selection for the Include Average parameter determines if the Average is included or not.
• The runtime selection for the Grade Display parameter determines whether the percent or letter grade is displayed

[S_TX_SGR_X]AAR_AVG_Override

 [StoredGrades]Grade

[StoredGrades]Percent

If Percent is blank or 0 and Percent was selected at runtime in the Grade Display parameter, then the value is pulled from [StoredGrades]Grade if available.

An asterisk to the right of the percent or letter grade indicates that credit was not awarded due to excessive absences.

The asterisk is included if the Loss of Credit Caused by Absence field in Stored Grades = Yes, or if the Pass/Fail Credit Override in Stored Grades = 4, 5, 12.

Loss of Credit Caused by Absence: [StoredGrades]Course_Equiv = "Yes"

or

Pass/Fail Credit Override: [StoredGrades]GPA_Custom2

Derived from:

[StoredGrades]EarnedCrHrs plus the output from State Credit and Local Credit fields, listed below.

Based on the AAR Subject Category or Explanation Code for the course, if the earned credit qualifies as a State Credit, the credit amount appears in this column. 

Notes:

• Courses with an AAR Subject Category of "LC" are excluded.
• Courses with Explanation Codes of "L" (Course Taken for Local Credit Only)

AAR Subject Category:

[S_TX_SGR_X]AAR_Subject_Category

[S_TX_SEC_X]AAR_Subject_Category

[S_TX_CRS_X]AAR_Subject_Category

Explanation Codes:

[S_TX_SGR_X]Explanation_Code_Combined

[S_TX_SEC_X]Explanation_Code_Combined

[S_TX_CRS_X]Explanation_Code_Combined

Based on the Credit Type or Explanation Code for the course, if the earned credit qualifies as a Local Credit, the credit amount appears in this column.

Notes:

• Courses with a Credit Type of "LC" are included.
• Courses with Explanation Codes of "L" (Course Taken for Local Credit Only) are included.

Credit Type:

[S_TX_SGR_X]AAR_Subject_Category

[S_TX_SEC_X]AAR_Subject_Category

 [S_TX_CRS_X]AAR_Subject_Category

Explanation Codes:

[S_TX_SGR_X]Explanation_Code_Combined

[S_TX_SEC_X]Explanation_Code_Combined

[S_TX_CRS_X]Explanation_Code_Combined

EOC Columns

EOC assessments are formatted in a four-column output:

• EOC - The name of the EOC assessment.
• Level - The Performance Level the student achieved on the assessment.
• Met - Indicates if the student met the EOC Assessment Requirement (Y or N) based on the Performance Level.
• Mo/Yr - The month and year the student completed the assessment.

Performance Level – Stored in Percent Score

• 7-DidNotMeet: N is reported in the Met column.
• 8-Approaches: Y is reported in the Met column.
• 9-Meets: Y is reported in the Met column.
• 10-Masters: Y is reported in the Met column.

Waivers and Substitution Assessments

• Waived: Refer to the EOC Waivers section above
• Pass Sub: Refer to the EOC Substitution section above.

EOC

Name: [TestScore]Name
Level: [StudentTestScore]PercentScore
Mo/Yr: [StudentTest]Test_Date

Algebra I

[StudentTestScore]PercentScore

[StudentTest]Test_Date

[StudentTestScore]PercentScore

[StudentTest]Test_Date

[TestScore]Name = English_I 

[StudentTestScore]PercentScore

[StudentTest]Test_Date

[StudentTestScore]PercentScore

[StudentTest]Test_Date

[StudentTestScore]PercentScore

[StudentTest]Test_Date

ACT Columns

ACT tests are formatted in a three-column output:

• ACT: The ACT test section.
• Score: The score the student earned.
• Mo/Yr: The month and year the student took the test.

The student's ACT composite score, and the date the student took the assessment.

[TestScore]Name = ACT

[StudentTestScore]NumScore

[StudentTest]Test_Date

[TestScore]Name = ACT_ENG

[StudentTestScore]NumScore

[StudentTest]Test_Date

[TestScore]Name = ACT_READ

[StudentTestScore]NumScore

[StudentTest]Test_Date

[TestScore]Name = ACT_WRITE

[StudentTestScore]NumScore

[StudentTest]Test_Date

[TestScore]Name = ACT_MATH

[StudentTestScore]NumScore

[StudentTest]Test_Date

[TestScore]Name = ACT_SCI

[StudentTestScore]NumScore

[StudentTest]Test_Date

SAT Columns

SAT tests are formatted in a three-column output:

• SAT: The SAT test section.
• Score: The score the student earned.
• Mo/Yr: The month and year the student took the test.

Notes:

• If the student has multiple SAT results, the highest score and date for that result is reported. This applies to the Total score as well as the individual assessments.
• If the student has only one SAT record, the date is reported for the Total score only.

[TestScore]Name = SAT

[StudentTestScore]NumScore

[StudentTest]Test_Date

Mathematics

[TestScore]Name = SAT_Mathematics 

[StudentTestScore]NumScore

[StudentTest]Test_Date

The student's SAT score for Reading, and the date the student took the assessment.

Reading is the original SAT score; now reported as Evidence-Based Reading and Writing.

[TestScore]Name = SAT_Reading 

[StudentTestScore]NumScore

[StudentTest]Test_Date

[TestScore]Name = SAT_Writing_Cumulative

[StudentTestScore]NumScore

[StudentTest]Test_Date

The student's SAT score for Evidence-Based Reading and Writing, and the date the student took the assessment.

[TestScore]Name = SAT_EBRW

[StudentTestScore]NumScore

[StudentTest]Test_Date

Class Rank/GPA

Notes:

• If Calculated Class Rank = Graduated Students for the runtime parameter, fields in this section are pulled from the [S_TX_STU_X]  fields for graduated students only.
• If Calculated Class Rank = All Students for the runtime parameter, fields in this section are pulled from the [S_TX_STU_X] calculated fields for all students.
• If Exclude Class Rank = No and Use Class Rank Overrides = Yes for the runtime parameters, Class Rank and Class Size are pulled from the [S_TX_STU_X] manual entry override fields.
• If Exclude Class Rank = No and Use Class Rank Overrides = No for the runtime parameters, Class Rank and Class Size are pulled from the [ClassRank] table.

If runtime parameter Use Calculated Class Rank Fields from Class Rank Tab applies for this student: [S_TX_STU_X]Calc_Class_Rank_Date

The date specified at runtime in the Class Rank Date Override parameter selection, if populated. [S_TX_STU_X]Class_Rank_Date_Override

Otherwise,

[ClassRank]DateRanked

If runtime parameter for Exclude Class Rank = Yes, Class Rank Date is not reported.

The student's class rank.

If runtime parameter Use Calculated Class Rank Fields from Class Rank Tab applies for this student: [S_TX_STU_X]Calc_Class_Rank

[S_TX_STU_X]Class_Rank

If Class Ranks have not been calculated for the current school year and no value is found in the Class Rank Override field, the report extracts the most recent value in the [ClassRank]Rank field.

If runtime parameter for Exclude Class Rank = Yes, or if the student's Calculated Class Rank is NULL or 0, Class Rank displays as 'DNR'.

If runtime parameter Use Calculated Class Rank Fields from Class Rank Tab applies for this student: [S_TX_STU_X]Calc_Class_Size

[S_TX_STU_X]Class_Size

[ClassRank]OutOf

If runtime parameter for Exclude Class Rank = Yes, Class Size is not reported.

The quartile and date of the Class Rank.

If Class Rank is reported as any value other than 0, the Quartile is calculated as Rank/Number in Class.

Calculated based on Rank/Number in Class.

• If result is = or < 0.25 report 1st
• If result is 0.26 - 0.50, report 2nd
• If result is 0.51 - 0.75, report 3rd
• If result is > 0.75, report 4th

If runtime parameter for Exclude Class Rank = Yes, Quartile is not reported.

The Class Rank GPA sourced from the TX GPA Override field (if populated), or the stored Class Rank GPA (if populated), or the calculated Class Rank GPA based on the Class Rank Method specified in the runtime parameter.

Notes:

• If runtime parameter Exclude Class Rank = Yes, Class Rank GPA is output as blank.
• If runtime parameter Exclude Class Rank = No, the output is based on the Use GPA Override parameter options selected at runtime.

If runtime parameter Use Calculated Class Rank Fields from Class Rank Tab applies for this student: [S_TX_STU_X]Calc_Class_Rank_GPA

If runtime parameter Use GPA Override = Yes: [S_TX_STU_X]GPA_Override, if populated. Otherwise, GPA is calculated using the Class Rank/GPA Method selected at runtime.

If runtime parameter Use GPA Override = No: [ClassRank]GPA, if populated. Otherwise, GPA is calculated on-the-fly using the Class Rank/GPA Method selected at runtime.

[ClassRank]GPAMethod

The GPA Calculation Method name and calculated value for the GPA specified as GPA2 in the runtime parameter.

If runtime parameter Use Calculated Class Rank Fields from Class Rank Tab applies for this student: [S_TX_STU_X]Calc_GPA2

GPA2 name ([ClassRank]GPAMethod) and calculated value ([ClassRank]GPA), if populated. Otherwise, calculated on-the-fly using the GPA method specified at runtime.

Not reported if runtime parameter, GPA2, was not specified at runtime.

The GPA Calculation Method name and calculated value for the GPA specified as GPA3 in the runtime parameter.

If runtime parameter Use Calculated Class Rank Fields from Class Rank Tab applies for this student: [S_TX_STU_X]Calc_GPA3

GPA3 name ([ClassRank]GPAMethod) and calculated value ([ClassRank]GPA), if populated. Otherwise, calculated on-the-fly using the GPA method specified at runtime

Not reported if runtime parameter, GPA3, was not specified at runtime.

The code and description of the student's assigned Graduation Program Type, if applicable.

The date the student graduated, if applicable.

Note: If a value exists in the Certificate of Coursework Completion Date field, include that label and the value. If no value exists in Certificate of Coursework Completion field, include Graduation Date as the label and output the value if it exists.

The date on which the district awards a certificate of coursework completion to a student. This applies to students who have completed coursework for graduation, but who have not yet passed the state exit or EOC assessments.

Indicates if the student is pursuing the FHSP program, or has completed the program.

Note: The FHSP Participant Code is only reported for students with a Graduation Program Type of 34, 35, 54, 55, 56 or 57. 

[S_TX_STU_X]E1541_FHSP_Part

• Graduates:
  If the student is a graduate with Graduation Type Code of 34, 54, 55, 56, or 57: 'Completed'
• Non-graduates:
  If the student has an assigned Graduation Type Code of 34, 54, 55, 56, or 57, or has a value of 1 in the E1541_FHSP_Part field: 'Pursuing'

Indicates if the student is pursuing or has completed the requirements for the FHSP Distinguished Level of Achievement.

Note: The FHSP Distinguished Level Achievement Code applies only to students in grades 9-12 and to FHSP-type graduates.

[S_TX_STU_X]E1542_FHSP_Dist

• Graduates:
  If the student is a graduate with Graduation Type Code 34, 54, 55, 56, or 57 AND has a value of 2 for FHSP Distinguished Level: 'Completed'; otherwise blank.
• Non-graduates:
  If the student has an assigned Graduation Type Code 34, 54, 55, 56, or 57 AND has a value of 1 or 2 for FHSP Distinguished Level: 'Pursuing' or 'Completed' as entered; otherwise blank.

Performance Acknowledgements

Performance Acknowledgements apply only to students who are FHSP Participants or Graduates where the Graduation Program Type is 34, 54, 55, 56, or 57. If the student is not an FHSP Participant or FHSP Graduate, or is an FHSP student but did not earn any Performance Acknowledgements, this section is not reported. The Performance Acknowledgement only displays if the student achieved the required performance level.

The Dual Credit Performance Acknowledgement and the date earned.

• Associates Degree
• College Credit Hours

[S_TX_STU_PERF_ACKN_C]Indicator_Value where Performance_Indicator is DC

[S_TX_STU_PERF_ACKN_C]Status_Date

The Bilingualism/Biliteracy Performance Acknowledgement and the date earned.

• Acknowledgment for Bilingualism/Biliteracy

[S_TX_STU_PERF_ACKN_C]Indicator_Value where Performance_Indicator is BB

[S_TX_STU_PERF_ACKN_C]Status_Date

The College Readiness Assessments Performance Acknowledgement and the date earned.

[S_TX_STU_PERF_ACKN_C]Indicator_Value where Performance_Indicator is CR

[S_TX_STU_PERF_ACKN_C]Status_Date

The Advanced Placement Exam Performance Acknowledgement and the date earned.

• Acknowledgment for AP Exam Score of 3 or Higher: Name of Subject

[S_TX_STU_PERF_ACKN_C]Indicator_Value where Performance_Indicator is AP

[S_TX_STU_PERF_ACKN_C]Status_Date

The International Baccalaureate Exam Performance Acknowledgement and the date earned.

• Acknowledgment for IB Exam Score of 4 or Higher: Name of Subject

[S_TX_STU_PERF_ACKN_C]Indicator_Value where Performance_Indicator is IB

[S_TX_STU_PERF_ACKN_C]Status_Date

The Certification Licensure Performance Acknowledgement and the date earned.

PEIMS
[S_TX_STU_PERF_ACKN_C]Indicator_Code not = 000
FREE-FORM

[S_TX_STU_PERF_ACKN_C]Indicator_Value where
Performance_Indicator is CL

[S_TX_STU_PERF_ACKN_C]Status_Date

Other Requirements

Note: The following fields are only visible if a value is populated at the student level. If the student meets none of the following requirements, this section is not visible.

The month and year that the student met the speech requirement for an FHSP diploma.

The month and year that the student completed CPR training.

The month and year that the student completed peace officer interaction training.

[S_TX_STU_X]TE123_Peace_Off_Instr_Date

01: Financial Aid Application Form Completed

02: Exception Submitted/Opt-Out

[Users]Last_Name

[Users]First_Name

The student's name in a Last, Generation Code, First format.

[Students]Last_Name

[Students]First_Name

[S_TX_STU_X]E0706

The student's local identification number.