Data Access Tags

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 (^)

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 & 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

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
• Format: ^(stored.by.course.number;coursenumber;storecode;field)
• Example: ^(stored.by.course.number;ENG2100;S1;grade)
• stored.by.course.period.cached - using the expression, stored code and field name
• Format: ^(stored.by.course.numberlist;coursenumber,coursenumber;storecode;field) - Multiple course in one DAT
• Example: ^(stored.by.course.numberlist;ENG2100,FRL3200,HIS3199;S1;grade)
• stored.by.course.numberlist - allows users to return data for multiple courses using one DAT
• Format: ^(stored.by.course.period.cached;expression;storecode;field) - Based on expression
• Example: ^(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")