~[wc:commonscripts] ~[wc:admin_header_css] ~[text:psx.html.admin_reports.runreports.start_page] > MBA Data Reference & Resource ~[wc:admin_navigation_css] ~[SetPostValue:tab=dat]

Data Access Tags

~[x:insertfile;tabs.html]

Data Access Tags (DAT)

DATs can typically be used in the following Reports and Functions:

Demographic, Formatting & Miscellaneous DATs

Student Information DAT's

Name Code Description
Student Age ^(age)

Your student, at age ^(age) is eligible for driving instruction.
Displays the student's age

Your student, at age 15 years and 6 month, is eligible for driving instruction.
Student Long Age ^(age;long)

Your student is currently ^(age;long)
Displays the student's age in long format

Your student is currently 15 years, 5 months, and 1 day old.

Note: Use an Evaluate Tage to display the exact number of years only ^(*evaluate left("^(age)",2))
Address - All Before ^(street;allbefore=[sp]) Displays information in the street field up to the first space [sp]

Example: Will display 305 of 305 N. Wilson Street
Address - All After ^(street;allafter=[sp]) Displays the remaining information in the street field after the first space [sp]

Example: Will display N. Wilson Street of 305 N. Wilson Street
Fee Balance ^(Fee_GetStudentBalance) Returns the student's current fee balance.


Smart Pronoun DAT's

Name Code Demographic>
he/she ^(he/she)

Your student said that ^(he/she) was excused.
Displays he, she, or the default gender pronoun as defined on the District Gender Pronouns page based on the student's selected gender

Your student said that he was excused.
He/She ^(He/She)

^(He/She) is doing well in class.
Displays He, She, or the default gender pronoun as defined on the District Gender Pronouns page based on the student's selected gender

She is doing well in class.
him/her ^(him/her)

Your student brought the project with ^(him/her).
Displays him, her, or the default gender pronoun as defined on the District Gender Pronouns page based on the student's selected gender

Your student brought the project with him.
His/Her ^(His/Her)

^(His/Her) grades are improving.
Displays His, Her, or the default gender pronoun as defined on the District Gender Pronouns page based on the student's selected gender

His grades are improving.
his/her ^(his/her)

^(his/her) grades are improving.
Displays his, her, or the default gender pronoun as defined on the District Gender Pronouns page based on the student's selected gender

His grades are improving.
son/daughter ^(son/daughter)

Your ^(son/daughter) is an honor roll student.
Displays son, daughter, or the default gender pronoun as defined on the District Gender Pronouns page based on the student's selected gender

Your daughter is an honor roll student.

School Information DAT's

School information fields are contained in the Schools [039] table.

Name Code Description
School Abbreviation ^(schoolabbr)

The abbreviated school name is ^(schoolabbr).
Displays the school name abbreviation

The abbreviated school name is AGHS.
School Name ^(schoolname)

Welcome to ^(schoolname)!
Displays the full school name

Welcome to Apple Grove High School!

Note: Use ^([schools]name) to pull the school name on reports if printing from the District Office
School Year/Term Abbreviation ^(abbryearterm)

This progress report is for ^(abbryearterm).
Displays the year and term in the format YY-TT

This progress report is for 08-S1.
School Year Name ^(yearname)

The grades printed inclue the ^(yearterm).
Displays the full school year name

The grades printed include the 2021-2022 School Year.
Term Abbreviation ^(termabbr)

This is your student's report card for ^(termabbr).
Displays the term abbreviation

This is your student's report card for S1.
Term Name ^(termname)

This is your student's report card for ^(termname).
Displays the full name of the term

This is your student's report card for Semester 1.

Other Information DAT's

Things to Remember:

  • By default, dates are displayed in numbers with up to two digits for the month, two for the day, and four for the year, with a slash / between each element
  • Square brackets [ ] are used instead of parentheses
Name Code Description
IP Address ^[ip address]

Report printed from ^[ip address].
Displays the IP address of the user

Printed from 102.168.0.1.
PowerSchool Version ^[version]

Printed using PowerSchool version ^[version].
Displays the version of PowerSchool

Printed using PowerSchool version 5.2.0.6.
Report Name ^[reportname]

This report is the ^[reportname].
Displays the name of the report

This report is the Final High School Transcript.
Page Number ^[pagenumber]

Page ^[pagenumber]
Displays the page number, starting with 1

Page 1
Export Result ^(fieldname;operationvalue)

11 plus 1 = ^(grade_level;+1)
Add, subtract, multiple or divide a value in a static field

11 plus 1 = 12

Formatting Date/Time DAT's

Name Code Description
Date ^[letter.date]

Today's date is ^[letter.date].
Displays today's date: Month Day Year

Today's date is October 1, 2022.
Date (short) ^[short.date]

Today's date is ^[short.date].
Displays today's date

Today's date is 10/1/2021.
Date (letter) ^[letter.date]

Today's date is ^[letter.date].
Displays today's date

Today's date is October 1, 2021.
Date Format ^[date;dateformat=xxx]

Today's date is ^[date;dateformat=dd mm yyyy].

Today's date is ^[date;dateformat=MMMM DD YYYY].
Displays today's date in the specified format

Today's date is 1 10 2022.

Today's date is January 10 2022.
Time ^[time]

The report ran at ^[time].
Displays the time in format 00:00

The report ran at 02:57.

Formatting Tab Code DAT's


Name Code Description Example
Tab Right <tabr XX> Text expands to the right of the tab stop by the specified number of inches <tabr 3.5> Tabs from the right at 3.5 inches
Tab Left <tabl XX> Text expands to the left of the tab stop by the specified number of inches <tabl 3.5> Tabs from the left at 3.5 inches
Tab Center <tabc XX> Text expands equally on both sides of the center tab stop by the specified number of inches <tabc 3.5> Center text at 3.5 inches from the left
Tab Decimal <tabd XX> Text expands on both sides of a decimal point relative to the decimal tab stop by the specified number of inches <tabd 3.5> Aligns decimal at 3.5 inches fromt the left
Tab to <tabto XX> Text expands to the right of the tab stop by the specified number of inches <tabto 3.5> Tabs from the right by 3.5 inches
Move to <moveto XX,Y> Move the object to XX inches from the left and Y inches from the top <moveto 3.5,2> Moves the object 3.5 inches fromt he left and 2 inches from the top
Repeat a symbol <tabr XX_> Repeats the underscore character from the specific number of inches to the left Signature:<tabr 7.5_>

Repeats the underscore character from 7.5 inches to the left and puts the word "Signature" at the left margin:

Signature:___________________________

Formatting Evaluation DAT's

The Evaluate Tag can be used to perform the following functions:

Function Code Description
Combining Fields ^(*evaluate "^(city), ^(state) ^(zip)")

^(*evaluate "^(First_Name) ^(Last_Name)")
Used to combine fields on an export or report

Example: Martinsburg, WV 25405
Left/Right Mason was ^(*evaluate left("^(age)",2)) in March. Renders only the number of years in the List Student Function screen, report, or form letter

Returns Mason was 17 in March.

Note: Use *evaluate left("^(age)",2) in List Students Function screen
Rounding Numbers ^(*evaluate round(^(*DABS;Q1),2))

^(*evaluate round((( ^(*DA;Q1)/^(*DM;Q1)) *100),2))
Days Absent Rounded to 2 decimal places ex: 1:00

Attendance Percentage ex: 98.46
Concatenating Fields ~(*evaluate left("~(first_name)",1))^(Last_Name)@genericsschool.org Returns 1st initial from First_Name field, all from Last_Name field and @genericschool.org

ex: EAhlberg@genericschool.org

Note the use of the tilde (~) instead of the caret (^)


Logic DATs


IF/Then/Else DAT's

Things to Remember:

  • If/Then can be used with most fields in PowerSchool
  • Currently, there are no supported logic DATs that can handle greater than or less than conditions/modifiers
  • See PowerSource Knowledge Base Article #6018 for specific examples
Code Description Example
^(field;if.XX.then=YY) A conditional argument that displays a specified result if the condition is met ^(gender;if.f.then=female)

If the gender field contains a f, display female

^(ethnicity;if.fieldvalue.h.then=Hispanic;if.fieldvalue.#h.then=Non-hispanic)

If the ethnicity field contains h, then display Hispanic

If the ethniity field does not contain h, then display Non-hispanic
^(field;if.blandk.then=) A conditional argument that displays no result if the field is blank ^(ethnicity;if.blank.then=Undisclosed)

If the gender field is blank, display Undisclosed
^(field;if.fieldvalue.#XX.then=) A conditional argument that displays no result if the value of the field does not meet the condition ^(SAT;if.fieldvalue.#1600.then=)

If the SAT field does not contain 1600, do not display a result
^(field;if.fieldvalue.XX.then=) A conditional argument that displays no result if the value int he field meets the condition ^(SAT;if.fieldvalue.400.then=)

If the SAT field contains 400, do not display a result
^(field;if.not.blank.then=) A conditional argument that displays no result if there is a value in the field ^(SAT;if.not.blank.then=)

If the SAT Field contains a value, do not display the value

Decode DAT's

Use "decode" to indicate how to display the output of data in a field.

Things to remember:

  • When using IF/TTHEN/ELSE logic, there must always be and ending ELSE statement
  • Certain characters can break a Decode statement if they're part of the value being decoded or returned
    • The most common offenders are Parenthesis and Semi-Colons, as they are both control characters for Decode
  • Basic Format - ^(decode;fieldname;value;return;value;return;else)
  • When using Decode to check for a blank value, the IF value is excluded
    • Example:
      • ^(decode;^(gender);;Blank;M;Male;F:Female;Other)
  • All parameters are required when using the decode DAT
  • Value and Return can be repeated to evaluate a field for multiple values
    • Example #1:
      • ^(decode;^(gender);M;Male;Female)
        The value Male is returned if the gender field equals M, otherwise, the value Female is returned
    • Example #2:
      • ^(decode;^(gender);M;Male;F;Female;Not Specified)
        The value Male is returned if the gender field equals M. The value Female is returned if the gender field equals F. The value Not Specified is returned if the gender field does not equal M or F.
    Name Code Description
    Fieldname ^(decode;Fieldname)

    ^(decode;^ethnicity)
    The name of the field to evaluate
    Value ^(decode;Fieldname;Value)

    ^(decode;^(ethnicity);W
    Evaluate the field against the specified value

    In this example, the field ethnicity is evaluated against the value W
    Return ^(decode;Fieldname;Value;Return

    ^(decode;^(ethnicity);W;White
    Value to return if the field matches the preceding value

    In this example, the value White is returned if the ethnicity field equals W
    Else ^(decode;Fieldname;Value:Return;Else

    ^(decode;^(ethnicity);W;White;B;Black;A;Asian;I;Indian;Other)
    Default value to return if the current field value did not match any of the evaluated values

    The associated value is returned if the gender field equals the specified value, otherwise, the value Other is returned


Decode Legal Name/Gender

Things to Remember:

  • Legal Name and Gender fields are being added to accomodate transgender students
  • Typically, the legal name and gender fields will only be populated if the legal information is different from the information on the Student Demographics Screen

Examples:

^(decode;^(StudentCoreFields.PSCORE_LEGAL_LAST_NAME);.;^(last_name);^(StudentCoreFields.PSCORE_LEGAL_LAST_NAME))

^(decode;^(StudentCoreFields.PSCORE_LEGAL_FIRST_NAME);.;^(first_name);^(StudentCoreFields.PSCORE_LEGAL_FIRST_NAME))

^(decode;^(StudentCoreFields.PSCORE_LEGAL_GENDER);.;^(gender);^(StudentCoreFields.PSCORE_LEGAL_GENDER))

Decode Blank/Null DAT's

Things to Remember:

  • Checks for Blank or Null Values
  • Especially helpful when working with Database Extention Tables


Checking for Blank/Null Values

Decode can be used to check for a blank value. To do so, exclude the IF value.
    ^(decode;^(gender);;Blank;M;Male;F;Female;Other)


Database Extensions and Other Non-Nullable Returns

If a field, when blank, returns a character, ;; can not be used in Decode to check if a field is null.

Instead, use the character which is returned when that field is null.

If ^(MyExtension.MyGenderField) returns a period character when null, the following example can be used:
  • ^(decode;^(MyExtension.MyGenderField);.;Blank;M;Male;Female;Other)


Attendance DATS

Attendance & Membership DAT's

Name Code Examples Description
Days in Atendance ^(*DA)
^(*DA;TT)
^(*DA;MM/DD/YYYY;MM/DD/YYYY)
^(*DA)
^(*DA;Q1)
^(*DA;8/21/2008;12/21/2008)
Displays total days in attendance
Displays the daily attendance total for the specified term
Displays the daily attendance total for the specified date range
Daily Membership ^(*DM)
^(*DM;TT)
^(*DM;MM/DD/YYYY;MM/DD/YYYY)
^(*DM)
^(*DM;Q1)
^(*DM;8/21/2008/;12/21/2008)
Displays the total daily membership
Displays the daily membership total for the specified term
Displays the daily membership total for the specified date range
Aggregate Membership ^(aggmemdays;date;date) ^(*aggmemdays;1/6/2009;5/31/2009) Displays the aggregate number of membership for the date range
Daily Absences ^(*DABS)
^(*DABS;TT)
^(*DABS;MM/DD/YYYY;MM/DD/YYYY)
^(*DABS)
^(*DABS;S2)
^(*DABS;7/31/2007;1/1/2008)
Returns the total number of daily absences.
Displays the total number of daily absences for the specified term
Displays the total number of daily absences for the date range
Daily Attendance Points ^(daily.att.points;school number;att code or
category;term or date range)
^(daily.att.points;;all;T3)
^(daily.att.points;;all,1/1/2008;5/30/2008)
^(daily.att.points;100;tar;S1)
Returns the total number or attendance points for daily attendance for the specified attendance codes/categories within the specified term or date range

Note - School number may be omitted
Daily Attendance Dates ^(dates.att.dates;school number;format;
att codes;term or date range)
^(daily.att.dates;;|;abs;S1) Returns a list of dates for which a student received daily attendance
This example returns a pipe separated (|) list of dates during semester 1 on which the student received an absence
Daily Attendance Count ^(daily.att.count;school number;att codes;term or date range) ^(daily.att.count;;abs;S1) Returns a count of the daily attendance occurences for an individual student
This example returns the number of daily absences during semester 1

Period Attendance DAT's

The period attendance (per.att) DAT returns attendance information for the specified expression.

  • Format: ^(per.att;XX:Y:TT:__)
  • XX: Expression
  • TT: Term or Date Range
  • Y: Attendance Code, Attendance Code list, or Attendance Category

Things to Remember:

  • When used in List Students, caret (^) and parenthesis must be omitted
  • Expression must be entered exactly as seen on the Quick Lookup page, including sections that encompass more than one day/period - all periods/days must be listed exactly as seen in the expression
  • Period_info cannot interpret two expressions. When using a DAT for more than one section, list the DAT as many times as necessary, each with a different expression. (See KB 7114 or KB 7566 for possible decode scenarios.)

Name Code Example Description
Period Attendance ^(per.att;XX)
^(per.att;XX;;TT)
^(per.att;XX:Y)
^(per.att;XX:Y:TT)
^(per.att;XX:MM/DD/YYYY)
^(per.att;XX;MM/DD/YYYY;MM/DD/YYYY)
^(per.att;1(A))
^(per.att;1(A);:Q2)
^(per.att;1(A);U)
^(per.att;1(A);A;Q2)
^(per.att;1(A);;8/21/2008)
^(per.att;1(A);;8/21/2008;12/21/2008)
Displays the total period attendance codes for the specified period
Displays the total period attendance total for the specified term
Displays the total of a specific period attendance code for the specified period
Displays the specified period attendance codes for the specified period and term
Displays the total period attendance codes for the specified period and specified date
Displays the total of a specified period attendance code for the specified period int he specified date range
Dates of Attendance ^(dates.of.attendance;expression;displayformat;
attendancedoes;mm/dd/yyyy;mm/dd/yyyy)
^(dates.of.attendance;1(A);/;T;8/1/2008;8/1/2008) Returns a list of dates for meeting attendance codes entered for an individual student

Note: The display format parameter defines how the results of the DAT will be printed; in more technical terms, it is the delimiter that will be used between each returned attendance code instance. Any character may be used as the record delimiter, such as the slash ("/") or pipe ("|").

Attendance Points DAT's

The AttPointsPeriod DAT returns the number or attendance points for the specified expression.

  • Format: ^(attpointsperiod; class expression; attendance codes or categories; term abbreviation/date range)
  • XX: Class Expression
  • TT: Term
  • Y: Attendance Code or Attendance Code Category
Name Code Example Description
Period Attendance Points ^(attpointsperiod;XX)
^(attpointsperiod;XX:TT)
^(attpointsperiod;XX:Y)

^(attpointsperiod;XX:TT;Y)
^(attpointsperiod;XX;MM/DD/YYYY;MM/DD/YYYY)
^(attpointsperiod;1(A))
^(attpointsperiod;1(A);Q2)
^(attpointsperiod;1(A);Abs)
^(attpointsperiod;1(A);A,T,U)

^(attpointsperiod;1(A);Abs;Q2)

^(attpointsperiod;1(A);U,T;;8/21/2008;12/21/2008)
Displays the total period attendance for the specified period
Displays the total period attendance points for the specified term
Displays the total period attendance points for the specified period and term
Displays the total period attendance points for the specified period and specified attendance code
Displays the total period attendance points for the specified period, specified attendance codes, and specified term
Displays the total period attendance points for the specified period, specified attendance codes, and specified date range


Grading DATs

Stored Grades DAT's

Stored grades data is extracted from the StoredGrades[031] table using the following DAT's:

  • stored.by.course.number - using the course name, store code, and field name
    • ^(stored.by.course.number;coursenumber;storecode;field)
    • ^(stored.by.course.number;ENG2100;S1;grade)
  • stored.by.course.period.cached - using the expression, stored code and field name
    • ^(stored.by.course.numberlist;coursenumber,coursenumber;storecode;field) - Multiple course in one DAT
    • ^(stored.by.course.numberlist;ENG2100,FRL3200,HIS3199;S1;grade)
  • stored.by.course.numberlist - allows users to return data for multiple courses using one DAT
    • ^(stored.by.course.period.cached;expression;storecode;field) - Based on expression
    • ^(stored.by.course.period.cached;1(A) 2-3(C) 4(4);S1;grade)


Name Code Description
Absences ^(stored.by.course.number;course number;store code;absences) Absences for the course/term
StoredGrade[031]Absences
Behavior ^(stored.by.course.number;course number;store code;behavior) Behavior/Citizenship for the course/term
StoredGrade[031]Behavior
Course Number Format: ^(stored.by.course.number;course number;term;field)

^(stored.by.course.number;MAT200;S2;grade)

^(stored.by.course.number;MAT200;Q3;absences)

S2 stored grade for course number MAT301
StoredGrade[031]grade

Total Q3 absences for course MAT301
StoredGrade[031]absence
Course Number List Format: ^(stored.by.course.numberlist;course number,course number,course number;term;field)

^(stored.by.course.numberlist;273,275,277,281,283;Q1;grade)

^(stored.by.course.numberlist;273,275,277,281,283;Q1;teacher_name)
Allows users to return data from mulitple courses using a single DAT

Returns Q1 stored grade for the course numbers identified

Returns teachers name for Q1 grades courses identified
Credit Type ^(stored.by.course.number;course number;store code;credit_type) Credit type for the course/term
StoredGrade[031]Credit_Type
Earned Credit ^(stored.by.course.number;course number;store code;earnedcrhrs) Earned credit for the course/term
StoredGrades[031]EarnedCrHrs
Grade ^(stored.by.course.number;course number;store code;grade) Grade for the course/term
StoredGrades[031]Grade
Potential Credit ^(stored.by.course.number;course number;store code;potentialcrhrs) Potential credit for the course/term
StoredGrade[031] PotentialCrHrs
Tardies ^(stored.by.course.number;course number;store code;tardies) Tardies for the course/term
StoredGrade[031]Tardies
Teacher Comments ^(stored.by.course.number;course number;store code;comment) Teacher comments for the course/term
StoredGrade[031]Comment

GPA DAT's

  • Returns a student's GPA based on specified parameters
  • Are calculated on the fly
  • Are not stored in a database table

Format: ^(gpa method="value" type="value" term="value" year="value" grade="value" credittype="value" scale="value")

Things to Remember:

  • If GPA "method" is omitted - system assumes "weighted"
  • If GPA "type" is omitted - system assumes "cumulative"
  • If a term is specified, the current year only is assumed unless otherwise specified
  • Grade_Levels used are based on Historical Grade levels set for the school
  • If any of the above options are specified in the method, they will ALWAYS OVERRIDE options in the DAT

Parameter Usage and Examples Description
method ^(*gpa method="value">

EX: ^(*gpa method="weighted")
Specify the name of the GPA calculation to use
If omitted, the weighted calculation will be used
type ^(*gpa method="value"type="value")

EX: ^(*gpa method="weighted" type="cumulative")
Specify the type of the calculation: Cumulative, Current, or Projected
If omitted, the Cumulative type is used
term ^(*gpa method="value" type="value" term="value")

EX: ^(*gpa method="weighted" type="cumulative" term="S1,S2")
Sepcify one or more term abbreviation Only grades whose store codes match the specified abbreviations are used in the GPA calculation

If omitted, any store code is permitted

If one or more term abbreviations are specified, but not grade level, only grades from the current school year are evaluated in the GPA calculation
grade ^(*gpa method="value" type="value" term="value" grade=""value")

EX: ^(*gpa method="weighted" type="cumulative" term="S1,S2" grade="9.10.11.12")
Specify one or more grade levels (separate multiple values by commas)

Only grades stored at the specific grade levels are used in the GPA calculation

If omitted, the historical grade range for the current school is used
year ^(*gpa method="value" type="value" term="value" grade="value" year="value")

EX: ^(*gpa method="weighted" type="cumulative" term="S1,S2" grade="9,10,11,12"year="2006")
Specify one or more four-digit school years (separate multiple values by commas)
For example, use 2007 to specify the 2007-2008 school year

Only grades stored for the specified school years are used in the GPA calculation
credittype ^(*gpa method="value" type="value" term="value" grade="value" year="value" credittype="value")

EX: ^(*gpa method="weighted" type="cumulative" term="S1,S2" grade="9,10,11,12" year = "2006" credittype="MAT,ENG")
Specify one or more credit types (separate multiple values by commas). Only grades associated with the specified credit types are used in the GPA calculation. If omitted, grades with any credit type (or not credit type) are used in the calculation.
scale ^(*gpa method="value" type="value" term="value" grade="value" year="value" credittype="value" scale="value")

EX: ^(*gpa method="weighted" type="cumulative" term="S1,S2" grade="9,10,11,12" year="2006" credittype="MAT,ENG" scale="HighSchool")
Specify the name of the grade scale to use for the calculation

Only grades present in the specified scale are included in the GPA calculation

If the name of the grade scale is not recognized, the Default grade scale is used

If omitted, the GPA points from the grade itself are used


Note: If Type, Term, Grade, Year, Credittype, or Scale are specified in the GPA calculation as setup at the District, the setting at the District will take precedence over the setting as specified in the GPA DAT.

For example, if the Weighted GPA is setup at the Distrcit with ENG and MAT specified as Credit Types, the following GPA DAT example will only include grades that are associated with the ENG or MAT credit types, even though credittype is not specified in the DAT:
^*gpa method="Weighted")

Honor Roll DAT's

Code Description
^(*honorroll method="HS Honors" Term="S1") Displays Honor Roll for Semester 1
^(*honorroll method="HS Honors" Term="S1" Grade="10" Displays Students grade 10 Semester 1 honor roll
^(*honorroll method="HS Honors" Term="S1" Result="Level")
^(*honorroll method="HS Honors" Term="Q3" Grade="11" Result="gpa")

Class Rank DAT's

The result parameter: the type of data that will be returned by this DAT. If this parameter is omitted, the "rank" value is used.

The values that can be passed to this parameter are:

  • "gpa" - The GPA used to determine the class rank
  • "outof" - The total number of students on the class rank list
  • "percentile" - The student's class rank percentile
  • "rank" - The student's class rank
  • "rankof" - The student's class rank out of the total number of ranked students
  • "rankoutof" - Same as "rankof", but including the word "out"
  • "schoolname" - The school that the class rank is associated with

Format: ^(*classrank method="method name" result="value")


Scheduling DATs

Name Code Description / [Table]Field Name
Course Name ^(*period_info;XX;course_name) Course name for the section with expression XX

[CC]Course_Name
Course Number ^(*period_info;XX;course_number) Course number for the section with expression XX

[CC]Course_Number
Current Citizenship ^(*period_info;XX;current_citizenship) Student's current citizenship for the seciton with expression XX

[PGFinalGrades]Citizenship
Current Grade ^(*period_info;XX;current_grade) Student's current grade for the section with expression XX

[PGFinalGrades]Grade
Current Percent ^(*period_info;XX;current_percent) Student's current percent grade for the section with expression XX

[PGFinalGrades]Percent
Room ^(*period_info;XX;room) The classroom for the section with expression XX

[Sections]Room
Section Number ^(*period_info;XX;section_number) Section number for the section taught section with expression

[CC]Section_Number
Teacher Comment ^(*period_info;XX;teacher_comment) Teacher comments for the section with expression XX

[PGFinalGrades]Comment

Note: Entered via PowerTeacher Gradebook, as opposed to the PowerSchool SIS Teacher portal.
Teacher Name ^(*period_info;XX;teacher_name) Teacher name for the section with expression XX

[CC]TeacherID
All teachers currently associated to a section ^(*period_info;1(A);current_section_teachers) Note: Name format is 'last, first'.
Only teachers with roles flagged for display on reports will be listed
Teachers are listed according to the sort order defined in the role module
~[x:insertfile;footer.html] ~[wc:admin_footer_css]