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

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

We are using this DAT to display the religion of the student

  • Student Demographics

  • arg.locale

To obtain the translation text for the specified fields, eg;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.
eg:S1,S2 & 1, 2 , 10

  • arg.gradesystem;

    need to pass termbin storeCode to get course related to it

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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.
eg :S1, S2 & 1, 2 , 10

  • arg.gradesystem;

    need to pass termbin storeCode to get course related to it

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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.
eg :S1, S2 & 1, 2 , 10

  • arg.gradesystem;

    need to pass termbin storeCode to get course related to it

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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.
eg:S1,S2 & 1, 2 , 10

  • arg.gradesystem;

    need to pass termbin storeCode to get course related to it

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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.
eg :S1, S2 & 1, 2 , 10

  • arg.gradesystem;

    need to pass termbin storeCode to get course related to it

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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

    Eg:arg.gradesystem=S1|S2

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

    ex:arg.skipyearid=’N';

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

    ex: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

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.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.common.dat.reportcard;fields=header4)

This DAT is used to get the description for term abbreviation of the first element gradesystem argument eg:arg.gradesystem=S1

  • arg.gradesystem; need to pass term Abbrevation to get name of the term Eg:arg.gradesystem=S1

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 Eg:arg.gradesystem=S1|S2 * arg.skipyearid; need to pass ‘Y' to skip the current year and 'N' to keep the current year ex:arg.skipyearid=’N'; * arg.gradelevel; Need to pass the grade level of students to retrieve course related data for a particular grade level. ex: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 Eg:arg.gradesystem=S1|S2 * arg.skipyearid; need to pass ‘Y' to skip the current year and 'N' to keep the current year ex:arg.skipyearid=’N'; * arg.gradelevel; Need to pass the grade level of students to retrieve course related data for a particular grade level. ex: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 Eg:arg.gradesystem=S1|S2 * arg.skipyearid; need to pass ‘Y' to skip the current year and 'N' to keep the current year ex:arg.skipyearid=’N'; * arg.gradelevel; Need to pass the grade level of students to retrieve course related data for a particular grade level. ex: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 Eg:arg.gradesystem=S1|S2 * arg.skipyearid; need to pass ‘Y' to skip the current year and 'N' to keep the current year ex:arg.skipyearid=’N'; * arg.gradelevel; Need to pass the grade level of students to retrieve course related data for a particular grade level. ex: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 Eg:arg.gradesystem=S1|S2 * arg.skipyearid; need to pass ‘Y' to skip the current year and 'N' to keep the current year ex:arg.skipyearid=’N'; * arg.gradelevel; Need to pass the grade level of students to retrieve course related data for a particular grade level. ex: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 Eg:arg.gradesystem=S1|S2 * arg.skipyearid; need to pass ‘Y' to skip the current year and 'N' to keep the current year ex:arg.skipyearid=’N'; * arg.gradelevel; Need to pass the grade level of students to retrieve course related data for a particular grade level. ex:arg.gradelevel=3

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 Eg:arg.gradesystem=S1

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 Eg:arg.gradesystem=S1

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 eg:arg.gradedcid=1;arg.percent=~(*powerquery;query=com.powerschool.common.dat.gradescoresum;fields=yearlypercent)

 

S2 * arg.gradedcid 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

25.8.0.0

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

This DAT is used to get the School Year

 

 

Object Report

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

JavaScript errors detected

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

If this problem persists, please contact our support.

Contact Support Close