PowerSchool Data Access Tags (DATs) | Report and Export Codes

Below is a list of Data Access Tags that have been used by our team in PowerSchool servers and have been known to work with some version of PowerSchool(which is always changing!). These codes can be used in certain reports and exports such as:

  • Form Letters
  • Mailing Labels
  • Object Reports: Text Object
  • Report Card Header
  • Report Card Footer
  • List Students Group Function
  • Quick Export
  • GPA Student Screens page
  • AutoSend

If you need additional help, you can contact us here.

Attendance and Membership

Daily Attendance

Daily Membership(Date Range) is ^(*DM;7/1/2021;6/30/2022)
Daily Attendance(Date Range) is ^(*DA;7/1/2021;6/30/2022)
Daily Absences(Date Range) is ^(*DABS;7/1/2021;6/30/2022)
Daily Attendance Dates (Date Range) is ^(daily.att.dates;;,;A,U;7/1/2021;6/30/2022)
Count of Daily Absences by code is ^(daily.att.count;current;UA,EA;7/1/21;6/30/22)
Count of Daily Tardies by code is ^(daily.att.count;current;UT,ET;7/1/21;6/30/22)

Use the Current Date in DAT Codes by using ^(f.currentdate)
Example:
Daily Absences(Date Range) is ^(*DABS;7/1/2021;^(f.currentdate))

Meeting/Period Attendance

Period Attendance Count (Date Range) is ^(per.att;1(A);TX,TU;7/01/21;6/30/22)
Period Attendance Dates (Date Range) is ^(dates.of.attendance;P1(A);,;TX,TU;7/01/21;6/30/22)

Use the Current Date in DAT Codes by using ^(f.currentdate)
Example:
Period Attendance Count (Date Range) is ^(per.att;1(A);TX,TU;7/01/21;^(f.currentdate))

Contacts (aka Unlimited Contacts)

Step 1 of 2: Who to include

Relationships = Rel
This value depends on your particular PowerSchool setup but some common values include: Parent, Father, Mother, Step-Father, Step-Mother, Aunt, Brother, Foster Parent, Friend, Grandfather, Grandmother, Grandparents, Neighbor, Other, Sister, Uncle, Aunt & Uncle, Caseworker, Care Providers, Family Member, Daycare, Foster Parents, Parent’sPartner, Cousin, Guardian, Partner, GreatGrandmom, Host Family, Other Parent

^(*contact_info;rel=Mother;cat=demo;val=lastfirst;)
^(*contact_info;rel=Father;cat=demo;val=lastfirst;)
^(*contact_info;rel=Brother;cat=demo;val=lastfirst;)
^(*contact_info;rel=Sister;cat=demo;val=lastfirst;)

Relationship Flags = flags
Options: include-inactive, only-inactive, custodial, non-custodial, emergency, non-emergency, lives-with, not-lives-with, school-pickup, not-school-pickup, receives-mail, not-receives-mail, dataaccess, not-dataaccess, webaccount, not-webaccount

^(*contact_info;flags=dataaccess;cat=demo;val=lastfirst;)
^(*contact_info;flags=non-emergency;cat=demo;val=lastfirst;)
^(*contact_info;flags=lives-with;cat=demo;val=lastfirst;)
^(*contact_info;flags=webaccount;cat=demo;val=lastfirst;)

Step 2 of 2: What to include

Category = cat
Options: all, rel, demo, phone, email, addr

^(*contact_info;cat=rel;val=relationship;)
^(*contact_info;cat=demo;val=lastfirst;)
^(*contact_info;cat=phone;val=phone;)
^(*contact_info;cat=email;val=email;)
^(*contact_info;cat=addr;val=street;)

Value = val

Options for cat = demo: acctemail, acctid, active, employer, firstname, gender, language, lastfirst, lastname, middlename, personid, prefix, stateid, statenum, suffix

Options for cat = rel: active, custody, dataaccess, emergency, enddate, liveswith, receivesmail, relationship, schoolpickup, srexcluded, startdate

Options for cat = phone: phone, preferred, sms, type

Options for cat = email: email, primary, type

Options for cat = addr: city, country, enddate, line2, startdate, stateprovince, street, type, unit, postalcode

^(*contact_info;cat=demo;val=lastfirst;)
^(*contact_info;cat=rel;val=relationship;)
^(*contact_info;cat=phone;val=phone;)
^(*contact_info;cat=email;val=email;)
^(*contact_info;cat=addr;val=street;)

GPA

Weighted GPA is ^(*gpa method="Weighted")
Cumulative (Stored) Weighted GPA is ^(*gpa method="Weighted" type="cumulative")
Current Weighted GPA is ^(*gpa method="Weighted" type="current") Weighted GPA for Term(Year) Q1(21-22) is ^(*gpa method="Weighted" term="Q1" year="2021")
Weighted GPA for Grades 9-12 is ^(*gpa method="Weighted" grade=”9,10,11,12”)
College GPA for Grades 9-12 is ^(*gpa method="Weighted" grade=”9,10,11,12” credittype="College")) Credit Hours is ^(*credit_hours) Potential Credit Hours is ^(*potential_credit_hours)

Class Rank

The student's class rank is ^(*classrank method="{Insert Method Name}" result="rank")
The student's class rank "out of" the total number of ranked students is ^(*classrank method="{Insert Method Name}" result="rankoutof")
The student's class rank "of" the total number of ranked students is ^(*classrank method="{Insert Method Name}" result="rankof")
The total number of students on the class rank list is ^(*classrank method="{Insert Method Name}" result="outof")
The school name associated with the rank is ^(*classrank method="{Insert Method Name}" result="schoolname")
The student's GPA associated with the rank is ^(*classrank method="{Insert Method Name}" result="gpa")
The student's rank percentile, calculated to four digits is ^(*classrank method="{Insert Method Name}" result="percentile" percentiledigits="4")

Honor Roll

The student's honor roll is (if applicable) ^(*honorroll method="[method]" term="[term]" grade="[grade level]" year="[year]" result="[output result]")

Reports

Long Date is ^[letter.date]
Short Date is ^[short.date]
Formatted Date is ^[date;dateformat=dd/mm/yyyy]
Time is ^[time]
IP Address is ^[ip address]
PowerSchool version is ^[version]
Report Name is ^[reportname]

Student Information
Student First Name is ^(first_name)
Student Last Name is ^(last_name)
Student Last, First name is ^(lastfirst)
Student First Name and Last Initial is ^(first_name) ^(last_name;substring=1,1)
Student Age is ^(age)
Student Age (Long) is ^(age;long)

Smart Pronouns
He/She is ^(He/She)
he/she is ^(he/she)
His/Her is ^(His/Her)
his/her is ^(his/her)
Him/Her is ^(Him/Her)
him/her is ^(him/her)
Son/Daughter is ^(Son/Daughter)
son/daughter is ^(son/daughter)

School Information
School Abbreviation is ^(schoolabbr)
School Name is ^(schoolname)
School Year / Term Abbreviation is ^(abbryearterm)
School Year Abbreviation is ^(yearabbr)
School Year Name is ^(yearname)
Term Abbreviation is ^(termabbr)
Term Name is ^(termname)
School(Table) Name is ^([39]name)
School(Table) Address is ^([39]schooladdress)
School(Table) City is ^([39]schoolcity)
School(Table) State is ^([39]schoolstate)
School(Table) Zip is ^([39]schoolzip)
School(Table) Phone is ^([39]schoolphone)
School(Table) Fax is ^([39]schoolfax)
School(Table) Principal is ^([39]Principal)
School(Table) Principal Email Address is ^([39]PrincipalEmail)
School(Table) Assistant Principal is ^([39]AsstPrincipal)
School(Table) Assistant Principal Email is ^([39]AsstPrincipalEmail)

Scheduling (Period Info)

Replace P1(A) with your own Period Expression!

Course/Section Information
Course Name is ^(*period_info;P1(A);course_name)
Course Number is ^(*period_info;P1(A);course_number)
Section Number is ^(*period_info;P1(A);section_number)
Room is ^(*period_info;P1(A);room)

Grading Information
Current Grade is ^(*period_info;P1(A);current_grade)
Current Percent is ^(*period_info;P1(A);current_percent)
Current Citizenship is ^(*period_info;P1(A);current_citizenship)
Teacher Comment is ^(*period_info;P1(A);teacher_comment)

Teacher Information
Teacher full name(last,first) is ^(*period_info;P1(A);teacher_name)
Teacher title is ^(*period_info;P1(A);teacher_I_title)
Teacher First Name is ^(*period_info;P1(A);teacher_I_first_name)
Teacher Last Name is ^(*period_info;P1(A);teacher_I_last_name)
All teachers ever associated to a section is ^(*period_info;P1(A);all_section_teachers)
All teachers currently associated to a section is ^(*period_info;P1(A);current_section_teachers)

Stored Grades

Replace XX with your own Period Expression!
Replace TT with the store code of the desired final grade reporting term
Stored (Historical) Grades Information
^(stored.by.course.period.cached;XX;TT;Absences)
^(stored.by.course.period.cached;XX;TT;Behavior)
^(stored.by.course.period.cached;XX;TT;Comment)
^(stored.by.course.period.cached;XX;TT;Course_Name)
^(stored.by.course.period.cached;XX;TT;Course_Number)
^(stored.by.course.period.cached;XX;TT;Credit_Type)
^(stored.by.course.period.cached;XX;TT;DateStored)
^(stored.by.course.period.cached;XX;TT;EarnedCrHrs)
^(stored.by.course.period.cached;XX;TT;GPA_Points)
^(stored.by.course.period.cached;XX;TT;grade)
^(stored.by.course.period.cached;XX;TT;Percent)
^(stored.by.course.period.cached;XX;TT;PotentialCrHrs)
^(stored.by.course.period.cached;XX;TT;SchoolName)
^(stored.by.course.period.cached;XX;TT;Tardies)
^(stored.by.course.period.cached;XX;TT;Teacher_Name)
^(stored.by.course.period.cached;XX;TT;Section_Number)
^(stored.by.course.period.cached;XX;TT;School_Phone)
^(stored.by.course.period.cached;XX;TT;Email_Addr)

Standards

Standards Data Access Tags have two settings that are set in the District Admin portal if you follow the breadcrumb trail below:

District (Setup) > Standards (Grading) > Standards Data Access Tag (DAT) Formatting

Replace A.B.C with your Standard Identifier
Replace T1 with your desired reporting term

Standard Information
Name is ^(*std.info.name;A.B.C)
Description is ^(*std.info.desc;A.B.C)

Standard Grades
Grade/Mark is ^(*std.stored.transavg;A.B.C;T1)
Comment is ^(*std.stored.comment;A.B.C;T1)

Transcript Object

Percent Format
Field: Percent (format:)
Other Field/Text/Format: ##.##

Grade Level
Field: Other:
Other Field/Text/Format: ~(grade_level)

Grade Level from numeric to text
Field: Other:
Other Field/Text/Format: ~^(grade_level;text) Teacher Name Field: Other: Other Field/Text/Format: ~(teacher_name) Custom Text String/Multiple Fields Field: Other: Other Field/Text/Format: ~(course_name) taught by: ~(teacher_name)

Formatting

uppercase: Outputs the text in all upper case
Example: ^(lastfirst;uppercase) for John Doe will output JOHN DOE

dateformat: Outputs a date value in a different format than what is stored on the server
Examples:
^(dob;dateformat=MMMM D, YYYY) for 04/02/1980 will output April 2, 1980
^(dob;dateformat=MMM D, YYYY) for 04/02/1980 will output Apr 2, 1980
^(dob;dateformat=MMDDYY) for 04/02/1980 will output 040280
^(dob;dateformat=MMDDYYYY) for 04/02/1980 will output 04021980
^(dob;dateformat=MMMM D) for 04/02/1980 will output April 2
long: Outputs an Age to years, months and days Example: ^(Age;long) will output 11 years 4 months and 4 days numberformat: Example: ^(*DABS;8/19/2021;11/10/2021;format=##0) will output a whole number only without decimals.

Tab function: Move/align your text objects
<tabr 1.5>This text tabs from the right at 1.5 inches.
<tabto 1.5>This text tabs from the right at 1.5 inches.
<tabl 1.5>This text tabs from the left at 1.5 inches.
<tabc 1.5>Centers text at 1.5 inches from the left.
<tabd 1.5>Aligns decimal at 1.5 inches from the left.
<moveto 1.5,2.0>This text is located at (x=1.5, y=2.0).

Math Functions

Add, Subtract, Multiple and Divide using DAT Codes

Add(Sum) Function:  f.add
Subtract Function:  f.subt
Multiply Function:  f.mult
Divide Function:  f.div

Total High School Credits Earned is ^(f.add;^(gpa method="Grade 9 Credit");^(gpa method="Grade 10 Credit");^(gpa method="Grade 11 Credit");^(gpa method="Grade 12 Credit");format=##0.00)

If/Then/Decode Statements

Decode Format is:  ^(decode;fieldname;value;replace;value;replace;else)

Example:
Grade Level is ^ (decode;^(grade_level);0;Kinder;1;1st Grade;2;2nd Grade;3;3rd Grade; )

If/Then Format is:
^(field;if.fieldvalue.XX.then=result)
^(field;if.fieldvalue#XX.then=result)
^(field;if.blank.then=result)
^(field;if.not.blank.then=result)

Example:
Coming soon!

Field Mapping

For more information on field mapping in PowerSchool, log into PowerSchool and visit https://ps.powerschool-docs.com/pssis-data-dictionary/latest/.

Updated on May 31, 2024
Was this article helpful?
Looking For More?
Talk To A Support Consultant Immediately!
Contact Us

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.