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