DAT Code for Indicating Contact Info

DAT Code for Indicating Contact Info

Any report that contains the parent (contact) data has to use DAT codes. This is the code for the 5160 Mailing Label Parent Name re: Student Name

I replaced
^(Father)
With
^(*contact_info;rel=mother,father;val=firstname, lastname)

This pulls one or the other. If both mother and father are available, it pulls mother.
If mother is not available, it pulls father.
If there is neither a mother or father, it is blank and so admins need to fix the student record.


https://docs.powerschool.com/PSHSA/20.4/page-and-data-management/data-access-tags/contact-information-dats#id-.Con

    • Related Articles

    • Print Labels in Powerschool

      To print mailing labels in PowerSchool, the first step is always going to be to select the students. This can be done using the Start page or you can use a report to select the students by running the report and then clicking the Make Current ...

    • SQL Code for Student Emails

      The change in student contacts requires a change in code for the student email. Unfortunately, this isn't great for combining DAT for contacts and student data in one. When you use List Students, for example, you can use the DAT Builder to get the ...

    • Next Year Planning Reports

      The following reports are listed in the Next Year Planning category in SQL Reports.  1. Demographic Counts by NEXT School BSD K-12 A/P       Criteria:             Active and Pre-registered             Next School is not (EEC, BTC, SC, IRA, Grads, ...

    • Primary Contacts Email and Phone

      SQL Reports/Contacts/Primary Contacts Email and Phone This report will return the active contacts for students and the primary email address and phone number for each contact.

    • Primary Contacts Email and Phone with Demographihcs

      SqL Reports/Contacts3 This report shows data for either the current school or the current selection.   The report shows the primary contact and demographic info for students - it will display None if there is no contact - and the primary email ...