PowerSchool Master List of Codes

    The tables below discuss two types of PowerSchool codes: Static Data Codes, Derived Data Codes. Static Data Codes and Derived Data Codes are used to insert information in Form Letters, Report Cards, Transcripts, export files, and the HTML of Custom Screens.

    The tables below list each of these codes and their functions.

    In addition to the codes found on this page, there are also codes that can you can use in reports such as class rosters. For a list of these codes see: Class Roster Codes.
Static Codes

Result

Code

Description / Function

Cumulative GPA (weighted)

^(*gpa)

The cumulative GPA for the student.

Cumulative GPA (simple)

^(*gpa.simple)

The cumulative GPA for the student using the simple calculation method.

Cumulative credit hours earned

^(*credit_hours)

Includes all courses from each student’s Historical Grades page.

Class rank (Based on cumulative weighted GPA)

^(*class_rank_out_of;gpa)

Inserts the student’s class rank.

You can use any valid GPA type as the GPA parameter (for example, gpa.simple or gpa.percent)

Cumulative avg. % earned in all classes (weighted)

^(*gpa.percent)

Inserts the student’s cumulative average percent in all classes using the weighted calculation method.

Cumulative avg. % earned in all classes (simple)

^(*gpa.percent)

Inserts the student’s cumulative average percent in all classes using the simple calculation method.

GPA for Quarter 1 (weighted)

^(*gpa;Q1)

Calculates the GPA for Q1 of the current school year (the year in which the user is currently working in PowerSchool).

Note: Your school must previously store the Q1 grades for the code to insert the correct GPA.

GPA for the student's entire junior year

^(*gpa;11)

Calculates the GPA for grade 11.

GPA for Q1 of the student's junior year

^(*gpa;11;Q1)

Calculates the student’s Quarter 1 GPA while they were enrolled in Grade 11.

Note: You can enter the codes in any order; if you enter ^(*gpa;Q1;11), the system inserts the same number if you enter ^(*gpa;11;Q1).

GPA for the year 1999

^(*gpa;1999)

Calculates the GPA for 1999 for the current student.

GPA for Quarter 3 (simple)

^(*gpa.simple;Q3)

Same as above but using the simple GPA calculation method.

You can enter percent instead of simple if you want to insert the percent GPA for the quarter.

The current GPA (simple)

^(*gpa.current)

Inserts the each student’s current grade from the Quick Lookup page.

Note: The system always uses the simple calculation method to calculate current grades.

Weighted GPA by Credit Type

^(*gpa.credit_type.ENG)

The weighted GPA for all historical grades for the current student that are of the credit type ENG.

Weighted GPA by Credit Type by Grade

^(*gpa.credit_type.ENG;12)

The student’s weighted GPA for all historical grades that are of the credit type ENG that he or she earned in the twelfth grade.

The average % being earned in the current classes (simple)

^(*gpa.current.percent)

Uses each student’s current grades on the Quick Lookup page to calculate.

School Name

^(schoolname)

Inserts the name of the current school.

School Name Abbreviation

^(schoolabbr)

Inserts the abbreviation of the current school.

Students Age

^(age)

Inserts the current age of each student in the following format: 15 years 3 months.

Students Age (long)

^(age;long)

Inserts the current age of each student in the following format: 15 years, 3 months, and 22 days.

Term Name

^(termname)

The name of the term current for the system (for example, 99-00 Quarter 4).

School Year / Term Abbreviation

^(abbryearterm)

For example, 99-00 Q4.

School Year Name

^(yearname)

For example, 1999-2000 School Year.

School Year Abbreviation

^(yearabbr)

For example, 99-00.

Term Abbreviation

^(termabbr)

For example, Q4.

Teacher Comments

^(teachercomments)

Inserts each teacher’s comments preceded by the label Per (number).

Note: This code is often inserted in report card footers if you do not include the teacher comments in the schedule listing.

Attendance Points (per class)

^(attpointsperiod;2)

Total attendance points in the student’s current period 2 class.

Attendance Points (per quarter)

^(attpointsperiod;2;Q4)

Total attendance points in the student’s period 2 class during Quarter 4.

Attendance Points (by date)

^(attpointsperiod;2;1/1/99;3/1/99)

Attendance points the student earned in his or her period 2 class between 1/1/99 and 3/1/99.

Absences (per class)

^(per.att;2)

Total absences in the student’s current period 2 class.

Tardies

^(per.att;2;tar)

Total tardies in the student’s current period 2 class.

Total H Attendance Marks

^(per.att;2;H)

Total number of H attendance codes entered for the student in his or her period 2 class.

Total H Attendance Marks (per quarter)

^(per.att;2;H;Q4)

Total number of H attendance codes entered for the student in his or her period 2 class during Quarter 4 only.

Total H Attendance Marks (by date)

^(per.att;2;H;1/1/99;3/1/99)

Total number of H attendance codes entered for the student in his or her period 2 class during the specified dates.

Daily Membership (by date)

~(*DM;5/1/2000;5/31/2000;true)

Days of membership by date for a single student. Use in reports and exports.

Daily Attendance (by date)

~(*DA;5/1/2000;5/31/2000;true)

Days of attendance by date for a single student. Use in reports and exports.

Period Information

^(*period_info;1;current_grade;Q1)

The student’s current letter grade in his or her period 1 class in the specified term.

Period Information

^(*period_info;1;current_percent)

The student’s current percent grade in his or her period 1 class.

Period Information

^(*period_info;1;current_citizenship)

The student’s current citizenship grade in his or her period 1 class.

Period Information

^(*period_info;01;teacher_name)

The name of the teacher who teaches the student’s period 1 class.

Period Information

^(*period_info;1;teacher_comment)

The student’s current teacher comment in his or her period 1 class.

Period Information

^(*period_info;1;course_name)

The name of the student’s period 1 course.

Period Information

^(*period_info;1;course_number)

The course number of the student’s period 1 course.

Period Information

^(*period_info;1;room)

The room in which the student’s period 1 class meets.

Period Information

^(*period_info;1;section_number)

The section number of the student’s period 1 class.

Smart Pronouns

Smart Pronouns

^(His/Her)

Inserts His or Her based on the student’s gender.

Smart Pronouns

^(he/she)

Inserts he or she based on the student’s gender.

Smart Pronouns

^(He/She)

Inserts He or She based on the student’s gender.

Smart Pronouns

^(him/her)

Inserts him or her based on the student’s gender.

Smart Pronouns

^(Him/Her)

Inserts Him or Her based on the student’s gender.

Smart Pronouns

^(son/daughter)

Inserts son or daughter based on the student’s gender.

Derived Codes
Result Code/Examples Description / Function
Period Information

*period_info

Examples:
*period_info;03;teacher_name
*period_info;03;course_name
*period_info;03;course_number
*period_info;03;room
*period_info;03;current_grade;S2
*period_info;03;current_percent;Q3
*period_info;03;current_citizenship
*period_info;03;section_number
*period_info;03;teacher_comment

Inserts period-specific schedule information from the students’ current schedule.
GPA

*gpa

Examples:
*gpa
*gpa.simple
*gpa;S1
*gpa.simple;Q3
*gpa;1999
*gpa;1999;S1
*gpa.simple;9
*gpa.simple;10;S1
*gpa.credittype.Math
*gpa.credittype.Math;S2
*gpa.credittype.Math;1999
*gpa.credittype.Math;11
*gpa.credittype.Math;9;S1
*gpa.credittype.Math;1999;S1
*gpa.percent
*gpa.simple.percent
*gpa.percent;S1
*gpa.percent.simple;Q3
*gpa.percent;1999
*gpa.percent.simple;9
*gpa.percent.simple;10;S1

Use the gpa codes to create many different gpas for a student. You can use parameters for specific gpa’s for year, term, grade level, and credit type. You can also use these parameters for percentage gpa’s.
Period Attendance Point Totals

^(attpointsperiod)

Examples:
^(attpointsperiod;02)
^(attpointsperiod;02;Q3)
^(attpointsperiod;02;2/1/2001;5/31/2001)

Inserts period-specific attendance points totals. You can restrict by term and by date.
Period Attendance Code Totals

^(per.att)

Examples:
^(att.per;03)
^(att.per;03;T)
^(att.per;03;S1)
^(att.per;03;Q2;E)
^(att.per;03;2/1/2001;4/1/2001)
^(att.per;03;2/1/2001;4/1/2001;I)

Inserts period-specific attendance code totals. You can restrict by term, code(s), and date. The default attendance code is ABS for all absences.
Daily Membership Totals

*DM

Examples:
*DM;S1
*DM;1/16/2001;5/31/2001

Inserts membership totals. You can restrict by term and by date.
Daily Attendance Totals

*DA

Examples:
*DA;S1
*DA;1/16/2001;5/31/2001

Use the Daily Attendance code to pull attendance totals. You can restrict by term and by date.
If/Then

^(field;if.fieldvalue.xxx.then=)

^(field;if.fieldvalue.#xxx.then=)
^(field;if.blank. then=)
^(field;if.not.blank. then=)

Examples:
^(ethnicity;if.fieldvalue.white.then=Caucasian)
^(ethnicity;if.fieldvalue.#white.then=Other)
^(polio3;if.blank.then=)
^(bus;if.#blank.then= ride bus)

Use this code when you have primary and secondary fields. The most common use is that of the street field. PowerSchool can automatically replace the street field with the mailing_street field if the street field is empty.
Stored Grades

~(stored.by.course.number)

Examples:
^(stored.by.course.number;120;Q2;grade)
^(stored.by.course.number;120;Q2;behavior)
^(stored.by.course.number;120;Q2;absences)
^(stored.by.course.number;120;Q2;comments)
^(stored.by.course.number;120;Q2;tardies)
^(stored.by.course.number;120;Q2;credittype)
^(stored.by.course.number;120;Q2;earnedcrhrs)
^(stored.by.course.number;120;Q2;potentialcrhrs)

Inserts stored grade information.
Standards Scores

^(std)

Examples:
^(*std.avg;LA11.2.3)
^(*std.transhigh;M12.4.5)
^(*std.num;FL3)

Extrapolates standards scores for a student. You must identify which standard code you want and the identifier.

If you do not include specific terms or dates, the default is current standard cumulative scores. You may choose average score, high score, translated score, translated high score, number of scores, and a note.

Stored Standards Scores

^(std.stored)

Examples:
^(*std.stored.transavg;LA11.2.3;S1)
^(*std.stored.avg;SC3.5.12;Q4)
^(*std.stored.high;FL2.5;T1;1999)
^(*std.stored.num;FA5.12;S2;11)

Extrapolates stored standards scores for a student. You must identify which standard code you want and the identifier.

If you do not include specific terms or dates, the default is current standard cumulative scores. You may choose average score, high score, translated score, translated high score, number of scores, and a note. The differences between the std code and this code are the term, year, and grade qualifiers.

Standard Information

^(std.info)

Examples:
^(*std.info.name;LA11.2.3)
^(*std.info.desc;SC3.5.12)
^(*std.info.type;FL2.5)

Labels standards on the page. You can pull the description, name identifiers, and other standard information.
Aggregate Membership Days ~(aggmemdays)

Calculates the aggregate membership days per student for the term in which you are currently working in PowerSchool.

Aggregate membership days are the total number of days the student was enrolled at the school. In some states, this number is reduced by factors such as enrollment in special programs.

You can use this code on custom pages and in student export files.

Aggregate Membership Days by date ~(aggmemdays;date;date)

Examples:
~(aggmemdays;10/1/99;11/1/99)

Note: The system uses only days in the current school year in the total.

If you enter two dates within the code, the system inserts the total number of membership days per student that fall within the specified date range.

You can use this code on custom pages and in student export files.

Decode Values ~(decode;fieldname;value;replace;value;
replace;else)

Examples:
~(decode;~(grade_level);9;Freshman;
10;
Sophomores;Upper Class), the report, file, or page displays Freshman instead of 9, Sophomore instead of 10, and Upper Class for any other grade level.

This code translates values you store in PowerSchool into other values in export files, reports, and custom pages.

Time ^[time] Inserts the current time such as 11:34 AM.
No Update ~[no.update]

Note: This code is for custom pages only.

If you insert this code in a custom page, and your school uses automatic PowerSchool updates, the PowerSchool update ignores this page; and the page is not updated.

Date (short) ^[short.date] For example, 2/24/99.
Date (letter) ^[letter.date] For example, February 24, 1999.

Copyright © 2002 Apple Computer, Inc.