Skip to main content
Skip table of contents

Saudi Arabia Localization - Power Query DATs

DAT Access Tag

Description

Portal Page

Optional Parameters

Available

Version

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

We are using this DAT to display the student's full name. (first name, middle name, third name , last name)

  • Student demographics

Object Report

24.9.0.0

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

We are using this DAT to display the student's full name in alternate language (first name, middle name, third name , last name)

  • Student demographics

Object Report

24.9.0.0

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

We are using this DAT to display the student's National ID

  • Student demographics

Object Report

24.9.0.0

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

We are using this DAT to display the student's birth place.

  • Student demographics

Object Report

24.9.0.0

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

We are using this DAT to display the student's Nationality

  • Student demographics

Object Report

24.9.0.0

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

We are using this DAT to display the student's third name alone.

  • Student demographics

Object Report

24.9.0.0

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

We are using this DAT to display the student's first name alone in alternate language

  • Student demographics

Object Report

24.9.0.0

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

We are using this DAT to display the student's middle name alone in alternate language

  • Student demographics

Object Report

24.9.0.0

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

We are using this DAT to display the student's third name alone in alternate language

  • Student demographics

Object Report

24.9.0.0

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

We are using this DAT to display the student's last name alone in alternate language

  • Student demographics

Object Report

24.9.0.0

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

We are using this DAT 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

24.9.0.0

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

We are using this DAT 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

24.9.0.0

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

We are using this DAT 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

24.9.0.0

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

We are using this DAT 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

24.9.0.0

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

We are using this DAT 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

24.9.0.0

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

We are using this DAT 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

24.9.0.0

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

We are using this DAT 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

24.9.0.0

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

We are using this DAT 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

24.9.0.0

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

We are using this DAT 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

24.9.0.0

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

We are using this DAT to display the student’s district

  • Student demographics

  • arg.type

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

eg;arg.type=mailing

Object Report

24.9.0.0

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

We are using this DAT to display the student’s additional number

  • Student demographics

  • arg.type

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

eg;arg.type=mailing

Object Report

24.9.0.0

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

We are using this DAT 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

24.9.0.0

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

We are using this DAT to display the student's province

  • 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

24.9.0.0

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

We are using this DAT to display the student’s zip code

  • Student demographics

  • arg.type

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

eg;arg.type=mailing

Object Report

24.9.0.0

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

We are using this DAT 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

24.9.0.0

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

We are using this DAT to display the student's emergency contact name

  • Student Demographics

  • student ->health->Emergency and Medical Contacts

  • arg.rowno

Here, "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

24.9.0.0

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

We are using this DAT to display the student's emergency contact name in alternate language

  • Student Demographics

  • student ->health->Emergency and Medical Contacts

  • arg.rowno

Here, "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

24.9.0.0

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

We are using this DAT to display the student's emergency contact relationship.

  • Student Demographics

  • student ->health->Emergency and Medical Contacts

  • arg.rowno

Here, "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

24.9.0.0

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

We are using this DAT to display the student's emergency phone number

  • Student Demographics

  • student ->health->Emergency and Medical Contacts

  • arg.rowno

Here, "rowno" defines the priority of the contact.

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

Object Report

24.9.0.0

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

We are using this DAT to display the type of phone number for the student's emergency contact.

  • Student Demographics

  • student ->health->Emergency and Medical Contacts

  • arg.rowno

Here, "rowno" defines the priority of the contact.

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

Object Report

24.9.0.0

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

We are using this DAT to display the province of the school

  • School info

  • arg.locale

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

Object Report

24.9.0.0

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

We are using this DAT 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

24.9.0.0

Report Card DAT’s

~(*powerquery;query=com.powerschool.common.dat.gradescore;fields=coursename)

This DAT is used get the list of courses based on termbin storecode eg: S1,S2

  • arg.gradesystem;

need to pass termbin storeCode to get course related to it

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gradescore;fields=altcoursename)

This DAT is used get the list of courses in arabic based on termbin storecode eg: S1, S2

  • arg.gradesystem;

need to pass termbin storeCode to get course related to it

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gradescore;fields=gradesystem1)

This DAT is used get the list of Grades against course name on first termbin storecode available in arg.gradesystem parameter

  • arg.gradesystem;

need to pass termbin storeCode to get grade information related to it

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gradescore;fields=gradesystem2)

This DAT is used get the list of Grades against course name on second termbin storecode available in arg.gradesystem parameter

  • arg.gradesystem;

need to pass termbin storeCode to get grade information related to it

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gradescore;fields=gradesystem3)

This DAT is used get the list of Grades against course name on third termbin storecode available in arg.gradesystem parameter

  • arg.gradesystem;

need to pass termbin storeCode to get grade information related to it

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gradescore;fields=gradepercent1)

This DAT is used get the list of percent against course name on first termbin storecode available in arg.gradesystem parameter

  • arg.gradesystem;

need to pass termbin storeCode to get grade information related to it

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gradescore;fields=gradepercent2)

This DAT is used get the list of percent against course name on second termbin storecode available in arg.gradesystem parameter

  • arg.gradesystem;

need to pass termbin storeCode to get grade information related to it

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gradescore;fields=gradepercent3)

This DAT is used get the list of percent against course name on third termbin storecode available in arg.gradesystem parameter

  • arg.gradesystem;

need to pass termbin storeCode to get grade information related to it

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gradescore;fields=yearlygrade)

This DAT is used get the list of garde against each course name for final Marks (Storecode='Y1')

  • arg.gradesystem;

need to pass termbin storeCode to get grade information related to it

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gradescore;fields=yearly)

This DAT is used get the list of garde against each course name for final Marks (Storecode='Y1')

  • arg.gradesystem;

need to pass termbin storeCode to get grade information related to it

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gradescore;fields=credithrs)

This DAT is used get the list of earned Credit hour against each course name (Storecode='Y1')

  • arg.gradesystem;

need to pass termbin storeCode to get grade information related to it

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gradescore;fields=gpapoints)

This DAT is used get the list of GPA points against each course name (Storecode='Y1')

  • arg.gradesystem;

need to pass termbin storeCode to get grade information related to it

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.reportcard;fields=header1)

This DAT is used to get the description for term abbreviation of the first element gradesystem argument

eg:arg.gradesystem=S1|S2

  • arg.gradesystem;

need to pass term Abbrevation to get name of the term

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.reportcard;fields=header2)

This DAT is used to get the description for term abbreviation of the second element in gradesystem argument

eg:arg.gradesystem=S1|S2

  • arg.gradesystem;

need to pass term Abbrevation to get name of the term

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.reportcard;fields=header3)

This DAT is used to get the description for term abbreviation of the first element gradesystem argument

eg:arg.gradesystem=S1|S2|

  • arg.gradesystem;

need to pass term Abbrevation to get name of the term

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gradescoresum;fields=gradepercent1sum)

This DAT is used to get the sum of first termbin storecode in gradesystem argument

eg:arg.gradesystem=S1|S2|

  • arg.gradesystem;

need to pass set of termbins storecode

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gradescoresum;fields=gradepercent2sum)

This DAT is used to get the sum of second termbin storecode in gradesystem argument

eg:arg.gradesystem=S1|S2|

  • arg.gradesystem;

need to pass set of termbins storecode

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gradescoresum;fields=gradepercent3sum)

This DAT is used to get the sum of third termbin storecode in gradesystem argument

eg:arg.gradesystem=S1|S2|

  • arg.gradesystem;

need to pass set of termbins storecode

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gradescoresum;fields=yearlyavg)

This DAT is used to get the sum of final year and percentage

  • arg.gradesystem;

need to pass set of termbins storecode

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gradescoresum;fields=yearlypercent)

This DAT is used to get the final year percentage for all course listed

  • arg.gradesystem;

need to pass set of termbins storecode

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gradescoresum;fields=yearlysum)

This DAT is used to get the sum of final year marks for all course listed

  • arg.gradesystem;

need to pass set of termbins storecode

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gradescoresum;fields=credithoursesum)

This DAT is used to get the sum of Credit Hours for all course listed

  • arg.gradesystem;

need to pass set of termbins storecode

Eg:arg.gradesystem=S1|S2

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gpagrade;fields=grade)

This DAT is used to get the grade against the grade scale DCID by passing arg.dcid and arg.percent

eg:arg.dcid=1;

arg.percent= ~(*powerquery;query=com.powerschool.common.dat.gradescoresum;fields=yearlypercent)

  • arg.gradesystem;

need to pass set of termbins storecode

Eg:arg.gradesystem=S1|S2

  • arg.DCID

need to pass the DCI from the gradescle item screen which Gradescale item they are going to use

eg:arg.dcid=1

arg.percent

need to pass the yearly percentage what we get from this DAT Query

~(*powerquery;query=com.powerschool.common.dat.gradescoresum;fields=yearlypercent)

Eg:arg.percent=~(*powerquery;query=com.powerschool.common.dat.gradescoresum;fields=yearlypercent)

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gpagrade;fields=gpa)

This DAT is used to get the GPA against the grade scale DCID by passing arg.dcid and arg.percent

eg:arg.dcid=1;

arg.percent=~(*powerquery;query=com.powerschool.common.dat.gradescoresum;fields=yearlypercent)

  • arg.gradesystem;

need to pass set of termbins storecode

Eg:arg.gradesystem=S1|S2

  • arg.DCID

need to pass the DCI from the gradescle item screen which Gradescale item they are going to use

eg:arg.dcid=1

arg.percent

need to pass the yearly percentage what we get from this DAT Query

~(*powerquery;query=com.powerschool.common.dat.gradescoresum;fields=yearlypercent)

Eg:arg.percent=~(*powerquery;query=com.powerschool.common.dat.gradescoresum;fields=yearlypercent)

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.term;fields=alttermname)

This DAT is used to get the Alternative School Year

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gradelevel;fields=grade)

This DAT is used to get the Student grade level based on current year id selection

Object Report

24.9.0

~(*powerquery;query=com.powerschool.common.dat.gradelevel;fields=nextgrade)

This DAT is used to get the Student Next grade level based on current year id selection(it will bring +1 from the above DAT)

Object Report

24.9.0

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

We are using this DAT to display the student's current Grade level in alternate language

  • Student demographics

  • arg.locale=ar

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

Object Report

24.10.0.0

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close