Skip to main content
Skip table of contents

MEA 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.8.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.8.0.0

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

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

  • Student demographics

 

Object Report

25.8.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.8.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.8.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.8.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.8.0.0

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

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

  • Student demographics

 

Object Report

25.8.0.0

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

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

  • Student demographics

 

Object Report

25.8.0.0

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

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

  • Student demographics

 

Object Report

25.8.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, for example, arg.locale=ar.

Object Report

25.8.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, for example, arg.locale=ar.

Object Report

25.8.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, for example, arg.locale=ar.

Object Report

25.8.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, for example, arg.locale=ar.

Object Report

25.8.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, for example, arg.locale=ar.

Object Report

25.8.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, for example, arg.locale=ar.

Object Report

25.8.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).

For example, arg.type=mailing

Object Report

25.8.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).

For example, arg.type=mailing

Object Report

25.8.0.0

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

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

  • Student demographics

  • arg.type

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

For example, arg.type=mailing

Object Report

25.8.0.0

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

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

  • Student demographics

  • arg.type

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

For example, arg.type=mailing

Object Report

25.8.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).

For example, arg.type=mailing

Object Report

25.8.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).

For example, arg.type=mailing

Object Report

25.8.0.0

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

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

  • Student demographics

  • arg.type

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

For example, arg.type=mailing

  • arg.locale

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

 

Object Report

25.8.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).

For example, arg.type=mailing

  • arg.locale

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

 

Object Report

25.8.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

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, for example, arg.locale=ar

Object Report

25.8.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

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, for example, arg.locale=ar

Object Report

25.8.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

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, for example, arg.locale=ar

 

Object Report

25.8.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

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

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

Object Report

25.8.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

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

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

Object Report

25.8.0.0

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

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

  • School info

  • arg.locale

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

Object Report

25.8.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, for example, arg.locale=ar

Object Report

25.8.0.0

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

This DAT is used to display the religion of the student.

  • Student Demographics

  • arg.locale

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

Object Report

25.8.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 and gradelevel.
For example, S1,S2 & 1, 2, 10.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT is used get the list of courses(displayname ) in arabic based on termbin storecode and gradelevel.
For example, S1, S2 & 1, 2, 10.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT is used get the list of courses in arabic based on termbin storecode and gradelevel.
For example, S1, S2 & 1, 2, 10.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT is used get the list of course numbers based on termbin storecode and gradelevel.
For example, S1,S2 & 1, 2, 10.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT is used get the list of course numbers in arabic based on termbin storecode and gradelevel.
For example, S1, S2 & 1, 2, 10.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT retrieves the list of grades for a course based on the first term bin store code available in arg.gradesystem, along with the student's grade in the specified parameter.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT retrieves the list of grades for a course based on the second term bin store code available in arg.gradesystem, along with the student's grade in the specified parameter.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT retrieves the list of grades for a course based on the third term bin store code available in arg.gradesystem, along with the student's grade in the specified parameter.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT retrieves the list of grades for a course based on the fourth term bin store code available in arg.gradesystem, along with the student's grade in the specified parameter.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT retrieves the list of grades for a course based on the first term bin store code available in arg.gradesystem, along with the student's grade in the specified parameter.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT retrieves the list of percent against course name based on the first term bin store code available in arg.gradesystem, along with the student's grade in the specified parameter.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT retrieves the list of percent against course name based on the second term bin store code available in arg.gradesystem, along with the student's grade in the specified parameter.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT retrieves the list of percent against course name based on the third term bin store code available in arg.gradesystem, along with the student's grade in the specified parameter.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT retrieves the list of percent against course name based on the fourth term bin store code available in arg.gradesystem, along with the student's grade in the specified parameter.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT retrieves the list of percent against course name based on the fifth term bin store code available in arg.gradesystem, along with the student's grade in the specified parameter.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT retrieves the list of credits for course name based on the first term bin store code available in arg.gradesystem, along with the student's grade in the specified parameter.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT retrieves the list of credits for course name based on the second term bin store code available in arg.gradesystem, along with the student's grade in the specified parameter.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT retrieves the list of credits for course name based on the third term bin store code available in arg.gradesystem, along with the student's grade in the specified parameter.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT retrieves the list of credits for course name based on the fourth term bin store code available in arg.gradesystem, along with the student's grade in the specified parameter.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT retrieves the list of credits for course name based on the fifth term bin store code available in arg.gradesystem, along with the student's grade in the specified parameter.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT retrieves the list of grades for each course name associated with final marks (Storecode='Y1'), along with the student's grade in the specified parameter.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT is used get the list of final numeric grade percentage for the course (Storecode='Y1').

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.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 course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.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 course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.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.

For example, arg.gradesystem=S1|S2.

  • arg.gradesystem;

Need to pass term Abbrevation to get name of the term.

For example, arg.gradesystem=S1|S2.

Object Report

25.8.0.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.

For example, arg.gradesystem=S1|S2.

  • arg.gradesystem;

Need to pass term Abbrevation to get name of the term.

For example, arg.gradesystem=S1|S2.

Object Report

25.8.0.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.

For example, arg.gradesystem=S1|S2.

  • arg.gradesystem;

Need to pass term Abbrevation to get name of the term.

For example, arg.gradesystem=S1|S2.

Object Report

25.8.0.0

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

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

For example, arg.gradesystem=S1|S2.

  • arg.gradesystem;

Need to pass term Abbrevation to get name of the term.

For example, arg.gradesystem=S1|S2.

Object Report

25.8.0.0

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

This DAT calculates the sum of the percent score for the first term bin store code in the gradesystem argument.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3.

Object Report

25.8.0.0

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

This DAT calculates the sum of the percent score for the second term bin store code in the gradesystem argument.

arg.gradesystem;

Need to pass termbin storeCode to get course related to it.

For example, arg.gradesystem=S1|S2.

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3.

Object Report

25.8.0.0

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

This DAT calculates the sum of the percent score for the third term bin store code in the gradesystem argument.

arg.gradesystem;

Need to pass termbin storeCode to get course related to it.

For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

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

This DAT calculates the sum of the percent score for the fourth term bin store code in the gradesystem argument.

arg.gradesystem;

Need to pass termbin storeCode to get course related to it

For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT calculates the sum of the percent score for the fifth term bin store code in the gradesystem argument.

arg.gradesystem;

Need to pass termbin storeCode to get course related to it

For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT calculates the sum of the credits for the first term bin store code in the gradesystem argument.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT calculates the sum of the credits for the second term bin store code in the gradesystem argument.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT calculates the sum of the credits for the third term bin store code in the gradesystem argument.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT calculates the sum of the credits for the fourth term bin store code in the gradesystem argument.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.0

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

This DAT calculates the sum of the credits for the fifth term bin store code in the gradesystem argument.

  • arg.gradesystem;

    Need to pass termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3

Object Report

25.8.0.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 termbin storeCode to get course related to it.

    For example, arg.gradesystem=S1|S2

  • arg.skipyearid;
    Need to pass ‘Y' to skip the current year and 'N' to keep the current year.

    For example, arg.skipyearid=’N';

  • arg.gradelevel;
    Need to pass the grade level of students to retrieve course related data for a particular grade level.

    For example, arg.gradelevel=3t of termbins storecode.

For example, arg.gradesystem=S1|S2.

Object Report

25.8.0.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.

For example, arg.gradesystem=S1|S2.

Object Report

25.8.0.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.

For example, arg.gradesystem=S1|S2.

Object Report

25.8.0.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.

For example, arg.gradesystem=S1|S2.

Object Report

25.8.0.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.gradedcid and arg.percent

For example, arg.gradedcid=1;

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

  • arg.gradesystem;

Need to pass set of termbins storecode

For example, arg.gradesystem=S1|S2

  • arg.gradedcid

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

For example, 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).

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

Object Report

25.8.0.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.gradedcid and arg.percent

For example, arg.gradedcid=1;

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

  • arg.gradesystem;

Need to pass set of termbins storecode

For example, arg.gradesystem=S1|S2

  • arg.gradedcid

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

For example, 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)

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

Object Report

25.8.0.0

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

This DAT is used to get the School Year.

Object Report

25.8.0.0

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

This DAT is used to get the Alternative School Year.

Object Report

25.8.0.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

25.8.0.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

25.8.0.0

~(*powerquery;query=com.powerschool.common.report.dat.date;fields=current_date_en)

This dat is used to display the english date in format dd month, yyyy.

Object Report

25.8.0.0

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

This DAT is used 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, For example, arg.locale=ar.

Object Report

25.8.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