PowerSchool SIS - Administrator
PowerSchool SIS - Administrator
Breadcrumbs

UAE Localization - Power Query DATs

DAT Access Tag

Description

Portal Page

Optional Parameters

Available

Version

~(*powerquery;query=com.powerschool.report.dat.studentinfo;fields=studentname)

This DAT is used to display the student's full name (first name, middle name, third name, last name).

  • Student demographics

 

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentinfo;fields=altstudentname)

This DAT is used to display the student's full name in alternate language (first name, middle name, third name, last name).

  • Student demographics

 

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentinfo;fields=emiratesid)

This DAT is used to display the student's Emirate ID.

  • Student demographics

 

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentinfo;fields=placeofbirth)

This DAT is used to display the student's birth place.

  • Student demographics

 

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentinfo;fields=nationality)

This DAT is used to display the student's nationality.

  • Student demographics

 

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentinfo;fields=thirdname)

This DAT is used to display the student's third name alone.

  • Student demographics

 

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentinfo;fields=altfirstname)

This DAT is used to display the student's first name alone in alternate language.

  • Student demographics

 

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentinfo;fields=altmiddlename)

This DAT is used to display the student's middle name alone in alternate language.

  • Student demographics

 

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentinfo;fields=altthirdname)

This DAT is used to display the student's third name alone in alternate language.

  • Student demographics

 

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentinfo;fields=altlastname)

This DAT is used to display the student's last name alone in alternate language.

  • Student demographics

 

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentinfo;fields=mothername)

This DAT is used to display the full name of student's mother.

  • Student demographics

  • arg.locale

To obtain the translation text for the specified fields, eg;arg.locale=ar.

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentinfo;fields=altmothername)

This DAT is used to display the full name of student's mother in alternate language.

  • Student demographics

  • arg.locale

To obtain the translation text for the specified fields, eg;arg.locale=ar.

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentinfo;fields=fathername)

This DAT is used to display the full name of student's father.

  • Student demographics

  • arg.locale

To obtain the translation text for the specified fields, eg;arg.locale=ar.

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentinfo;fields=altfathername)

This DAT is used to display the full name of student's father in alternate language.

  • Student demographics

  • arg.locale

To obtain the translation text for the specified fields, eg;arg.locale=ar.

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentinfo;fields=guardianname)

This DAT is used to display the full name of student's guardian.

  • Student demographics

  • arg.locale

To obtain the translation text for the specified fields, eg;arg.locale=ar.

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentinfo;fields=altguardianname)

This DAT is used to display the full name of student's guardian in alternate language.

  • Student demographics

  • arg.locale

To obtain the translation text for the specified fields, eg;arg.locale=ar.

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentaddressinfo;fields=building)

This DAT is used to display the student’s building.

  • Student demographics

  • arg.type

Specify the type of address that has to be displayed(mailing or home)

eg;arg.type=mailing

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentaddressinfo;fields=street)

This DAT is used to display the student’s street address.

  • Student demographics

  • arg.type

Specify the type of address that has to be displayed(mailing or home)

eg;arg.type=mailing

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentaddressinfo;fields=unit)

This DAT is used to display the student’s unit number.

  • Student demographics

  • arg.type

Specify the type of address that has to be displayed(mailing or home)

eg;arg.type=mailing

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentaddressinfo;fields=locality)

This DAT is used to display the student’s locality.

  • Student demographics

  • arg.type

Specify the type of address that has to be displayed (mailing or home)

eg;arg.type=mailing

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentaddressinfo;fields=landmark)

This DAT is used to display the student’s landmark.

  • Student demographics

  • arg.type

Specify the type of address that has to be displayed (mailing or home)

eg;arg.type=mailing

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentaddressinfo;fields=city)

This DAT is used to display the student's city.

  • Student demographics

  • arg.type

Specify the type of address that has to be displayed(mailing or home)

eg;arg.type=mailing

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentaddressinfo;fields=emirate)

This DAT is used to display the student's Emirate.

  • Student demographics

  • arg.type

Specify the type of address that has to be displayed (mailing or home)

eg;arg.type=mailing

  • arg.locale

To obtain the translation text for the specified fields, eg;arg.locale=ar

 

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentaddressinfo;fields=poboxnumber)

This DAT is used to display the student’s PO Box Number.

  • Student demographics

  • arg.type

Specify the type of address that has to be displayed (mailing or home)

eg;arg.type=mailing

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.report.dat.studentaddressinfo;fields=country)

This DAT is used to display the student’s country.

  • Student demographics

  • arg.type

Specify the type of address that has to be displayed (mailing or home)

eg;arg.type=mailing

  • arg.locale

To obtain the translation text for the specified fields, eg;arg.locale=ar

 

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.common.dat.emergency;fields=contactname)

This DAT is used to display the student's emergency contact name.

  • Student Demographics

  • student, health, Emergency and Medical Contacts

  • arg.rowno

In this case, rowno defines the priority of the contact.

For example, if rowno=2, retrieve the details of the second emergency contact.

  • arg.locale

To obtain the translation text for the specified fields, eg;arg.locale=ar

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.common.dat.emergency;fields=altcontactname)

This DAT is used to display the student's emergency contact name in alternate language.

  • Student Demographics

  • student, health, Emergency and Medical Contacts

  • arg.rowno

In this case, rowno defines the priority of the contact.

For example, if rowno=2, retrieve the details of the second emergency contact.

  • arg.locale

To obtain the translation text for the specified fields, eg;arg.locale=ar

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.common.dat.emergency;fields=contactrelationshipdesc)

This DAT is used to display the student's emergency contact relationship.

  • Student Demographics

  • student, health, Emergency and Medical Contacts

  • arg.rowno

In this case, rowno defines the priority of the contact.

For example, if rowno=2, retrieve the details of the second emergency contact.

  • arg.locale

To obtain the translation text for the specified fields, eg;arg.locale=ar

 

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.common.dat.emergency;fields=phonenumber)

This DAT is used to display the student's emergency phone number.

  • Student Demographics

  • student, health, Emergency and Medical Contacts

  • arg.rowno

In this case, rowno defines the priority of the contact.

For example, if rowno=2, retrieve the details of the second emergency contact.

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.common.dat.emergency;fields=phonetype)

This DAT is used to display the type of phone number for the student's emergency contact.

  • Student Demographics

  • student, health, Emergency and Medical Contacts

  • arg.rowno

In this case, rowno defines the priority of the contact.

For example, if rowno=2, retrieve the details of the second emergency contact.

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.admin.dat.school;fields=school_emirate)

This DAT is used to display the Emirate of the school.

  • School info

  • arg.locale

To obtain the translation text for the specified fields, eg;arg.locale=ar

Object Report

25.7.0.0

~(*powerquery;query=com.powerschool.admin.dat.school;fields=school_Country)

This DAT is used to display the country of the school.

  • School info

  • arg.locale

To obtain the translation text for the specified fields, eg;arg.locale=ar

Object Report

25.7.0.0