Data Access Tags (DAT)
DATs can typically be used in the following Reports and Functions:
- Form Letters
- Mailing Labels
- Object Reports: Text Object
- Report Card Headers/Footers
- List Students Group Functions
- Quick Exports
- GPA Student Screens/Cumulative Info
- Autosends
Demographic, Formatting & Miscellaneous DATs
- Student Information DATs
- Smart Pronouns
- School Information DATs
- Other Information DATs
- Format - Date/Time DATs
- Format - Tab Code DATs
- Format - Evaluate 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)
- Example:
- 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
- ^(decode;^(gender);M;Male;Female)
- 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.
- ^(decode;^(gender);M;Male;F;Female;Not Specified)
- Example #1:
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.
|
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:
|
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 |