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:

CODE

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

Example – Missouri Attendance Current Year EOY:

CODE

^(*compliance;dat.name=DAT_usa_mo_studentAttendance;studentId=~([students]id);curYear=35;asOfDate=endOfYear;dataToReturn=PER)

Example – Missouri Attendance (Current Year YTD):

CODE

^(*compliance;dat.name=DAT_usa_mo_studentAttendance;studentId=~([students]id);curYear=35;asOfDate=current;dataToReturn=PER)

Parameters:

studentId: Always ~([students]id)
curYear: Use the current school year value (e.g., 35 for 2025–2026)
asOfDate: Use current for YTD or endOfYear for full-year calculations (note: camel case)
dataToReturn: Use one of the following:
- PRES: Hours Present
- ABS: Hours Absent
- MEM: Membership Hours
- PER: Attendance Percentage

Example – A+ Attendance:

CODE

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

Parameters:

curYear: Use the current school year value (e.g., 35for 2025–2026)
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:

CODE

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

Example – Missouri Attendance in HTML (Current Year YTD):

CODE

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

Example – A+ Attendance in HTML:

CODE

<td><input type="text" value="~(*compliance;dat.name=DAT_usa_mo_studentAplusTotalAttPercent;studentId=~(curstudid);curYear=35;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
Ensure that the Include Virtual Absences preference is set correctly if virtual attendance should be included