Missouri-Specific Attendance DAT Setup Guide

Using Missouri Attendance DATs in PowerSchool

This guide explains how to use the new Missouri-specific Data Access Tags (DATs) to display attendance values in Object Reports and HTML pages.

Select the Correct DAT

Choose the DAT based on the type of attendance data needed:

• For standard attendance values (e.g., hours present, absent, membership, attendance %):
  Use: DAT_usa_mo_studentAttendance

• For A+ program cumulative attendance percentage:
  Use: DAT_usa_mo_studentAplusTotalAttPercent

Use the DAT in Object Reports

Use this syntax to insert DATs into an Object Report:

^(*compliance;dat.name=DAT_NAME;studentId=~([students]id);[parameters])

Example – Missouri Attendance:

^(*compliance;dat.name=DAT_usa_mo_studentAttendance;studentId=~([students]id);termId=3400;dataToReturn=PER)

Parameters:

• studentId: Always ~([students]id)

• termId: Use a valid term ID (e.g., 3400 for full year, 3401 for Semester 1)

• dataToReturn: Use one of the following:

  • PRES: Hours Present

  • ABS: Hours Absent

  • MEM: Membership Hours

  • PER: Attendance Percentage

Example – A+ Attendance:

^(*compliance;dat.name=DAT_usa_mo_studentAplusTotalAttPercent;studentId=~([students]id);curYear=34;asOfDate=endOfYear)

Parameters:

• curYear: Use the current school year value (e.g., 34 for 2024–2025)

• asOfDate: Use current or endOfYear (note: camel case)

Use the DAT in HTML Pages

DATs can also be inserted into HTML pages (e.g., custom screens). The syntax is slightly different:

~(*compliance;dat.name=DAT_NAME;studentId=~(curstudid);[parameters]) 

Example – Missouri Attendance in HTML:

<td><input type="text" value="~(*compliance;dat.name=DAT_usa_mo_studentAttendance;studentId=~(curstudid);termId=3401;dataToReturn=PER)"></td>

Example – A+ Attendance in HTML:

<td><input type="text" value="~(*compliance;dat.name=DAT_usa_mo_studentAplusTotalAttPercent;studentId=~(curstudid);curYear=34;asOfDate=endOfYear)"></td> 

Key Difference:

• studentId: In HTML, use ~(curstudid) instead of ~([students]id)

• Leading character in Object Reports is ^ instead of ~ in HTML

Validate the Output

After adding DATs:

• Confirm that values return correctly in reports or HTML

• Cross-check attendance values with Missouri state reports for accuracy

• Test for different term IDs and ensure expected results