A powerful element that can help you accomplish many things, but that requires some advanced PowerSchool knowledge. PowerSchool Data Access Tags are the primary feature that can be used, but other PowerSchool Keywords can be used as well. 


Enter the PowerSchool Data Access Tag or T-List SQL statement into the Description property of the element. When the form is viewed against a student or user record, the value represented by the PowerSchool Data Access Tag or T-List SQL statement will display. These values will be read-only.

Useful Data Tags

~[schoolname] – Displays the name of the school the student is enrolled in or the teacher’s home school.

~(yearname) – Displays version of the current school year, by default something like 2015-2016.

^(*gpa method=”weighted” type=”cumulative” term=”S1,S2”) – The GPA tag has many options for

producing various grade point averages. Please see PowerSchool’s documentation for more detail on its

usage.

~(*credit_hours) – Displays the number of the student’s cumulative historical earned credit hours.

~(wm_tier; if.fieldvalue.1.then=yes;if.fieldvalue.0.then=no;if.fieldvalue.blank.then=no) – A method for

decoding the value of a PowerSchool field (in this example wm_tier) whose values need interpreting for

end-users.

~[tlist_sql] - Use to display the results of a SQL query.

SQL Queries

The PowerSchool Tag element is the only way to view data on a form that isn't stored in the Student/User table. Data from other tables can be displayed via a SQL query using the T-List tag.


Here is an example displaying information on a student's attendance by year.

<table class="linkDescList">

 <thead>

     <tr>

         <th>Year</th>

         <th>School</th>

         <th>Absences</th>

         <th>Tardies</th>

     </tr>

 </thead>

 <tbody> ~ [tlist_sql; 

SELECT MAX(T.NAME) TERMNAME, max(SCH.NAME) SCHOOLNAME,

    SUM(CASE WHEN AC.PRESENCE_STATUS_CD = 'Absent' THEN 1 ELSE 0 END) ABS,

    SUM(CASE WHEN upper(to_char(AC.DESCRIPTION)) = 'TARDY' THEN 1 ELSE 0 END) tar 

FROM ATTENDANCE ATT JOIN ATTENDANCE_CODE AC ON AC.ID = ATT.ATTENDANCE_CODEID 

    AND (AC.PRESENCE_STATUS_CD = 'Absent' OR UPPER(TO_CHAR(AC.DESCRIPTION)) = 'TARDY') 

    JOIN SCHOOLS SCH ON SCH.SCHOOL_NUMBER = ATT.SCHOOLID 

    JOIN TERMS T ON T.ID = ATT.YEARID || '00' AND T.ISYEARREC = 1 AND T.SCHOOLID = ATT.SCHOOLID           

WHERE ATT.STUDENTID = ~ (curstudid) 

GROUP BY ATT.YEARID, ATT.STUDENTID 

ORDER BY att.yearid, att.studentid]

<tr>

     <td>~ (1;t)</td>

     <td>~ (2;t)</td>

     <td>~ (3;t)</td>

     <td>~ (4;t)</td>

</tr>

 [/tlist_sql] </tbody> 

</table>