Thai Localization - Power Query DATs

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=stufullname)

This DAT is used to display the student's full name in Thai.

• Student Demographics

 N/A

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=stufullnameenglish)

This DAT is used to display Student’s Full Name in English

• Student Demographics

  N/A

Object Report

24.7.0

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

This DAT is used to show the full name of the student's mother in Thai.

• Student Demographics

  N/A

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mothernameenglish)

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

• Student Demographics

  N/A

Object Report

24.7.0

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

This DAT is used to show the full name of the student's father in Thai.

• Student Demographics

  N/A

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=fathernameenglish)

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

• Student Demographics

  N/A

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=madderine1)

This DAT is used to display the student's mailing address line 1 (house number, village/building, Moo).

• Student Demographics

  N/A

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=madderine2)

This DAT is used to display the student's mailing address, including Address Line 2 Alleyway, Soi, Road).

• Student Demographics

  N/A

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=madderine3)

This DAT is used to display the student's mailing address, including Line 3 (province, district, sub-district, zip code).

• Student Demographics

• arg.locale

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

Object Report

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=addressline1)

This DAT is used to display Student Home Address Line1(House no, Village/Building, Moo)

• Student Demographics

  N/A

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=addressline2)

This DAT is used to display the student's home address line 2 (alleyway, soi, road).

• Student Demographics

  N/A

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=addressline3)

This DAT is used to display the student's home address Line 3 (Province, District, Sub-District, Zip).

• Student Demographics

• arg.locale

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

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=homeunit)

This DAT is used to display the student's home house number.

• Student Demographics

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=homecustomstring1)

This DAT is used to display the student's home village or building.

• Student Demographics

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=homecustomstring2)

This DAT is used to display Student’s Home Moo

• Student Demographics

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=homestreet)

This DAT is used to display Student’s Home street

• Student Demographics

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=homelinetwo)

This DAT is used to display the student's home road

• Student Demographics

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=homeline3)

This DAT is used to display the student's home alleyway.

• Student Demographics

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=homeaddress)

This DAT is used to display the student's full home address.

• Student Demographics

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=hprov)

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

• Student Demographics

• arg.locale

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

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=hdist)

This DAT is used to display the student's home district.

• Student Demographics

• arg.locale

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

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=hsubdist)

This DAT is used to display the student's home sub-district.

• Student Demographics

• arg.locale

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

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=hzip)

This DAT is used to display the student's home zip.

• Student Demographics

• arg.locale

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

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mailunit)

This DAT is used to display the student's mailing house number

• Student Demographics

  N/A

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mailcustomstring1)

This DAT is used to display the student's mailing village/building.

• Student Demographics

  N/A

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mailcustomstring2)

This DAT is used to display the student's mailing moo

• Student Demographics

  N/A

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mailstreet)

This DAT is used to display the student's mailing street.

• Student Demographics

  N/A

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=maillinetwo)

This DAT is used to display the student's mailing road.

• Student Demographics

  N/A

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mailline3)

This DAT is used to display the student's mailing alleyway.

• Student Demographics

  N/A

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mailaddress)

This DAT is used to display the student's full mailing address

• Student Demographics

  N/A

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mprov)

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

• Student Demographics

• arg.locale

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

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mdist)

This DAT is used to display the student's mailing district.

• Student Demographics

• arg.locale

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

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=msubdist)

This DAT is used to display the student's mailing sub-district

• Student Demographics

• arg.locale

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

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mzip)

This DAT is used to display the student's mailing ZIP code.

• Student Demographics

• arg.locale

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

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.emergency;arg.rowno=1;fields=contactname)

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

• Student Demographics

• student ->health->Emergency and Medical Contacts

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

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

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.emergency;arg.rowno=1;fields=contactnameenglish)

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

• Student Demographics

• student ->health->Emergency and Medical Contacts

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

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

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.emergency;arg.rowno=1;fields=contactrelationshipdesc)

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

• Student Demographics

• student ->health->Emergency and Medical Contacts

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

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

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.emergency;arg.rowno=1;fields=phonenumber)

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

• Student Demographics

• student ->health->Emergency and Medical Contacts

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

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

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.dat.emergency;arg.rowno=1;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

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

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

Object Report

24.7.0

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

This DAT is used to display the school province.

• School info

• arg.locale

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

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.admin.dat.schoolinfo;fields=school_district)

This DAT is used to display the school district.

• School info

• arg.locale

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

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.admin.dat.schoolinfo;fields=school_subdistrict)

This DAT is used to display the school sub-district

• School info

• arg.locale

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

Object Report

24.7.0

~(*powerquery;query=com.powerschool.th.admin.dat.schoolinfo;fields=school_zip)

This DAT is used to display the school ZIP code.

• School info

• arg.locale

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

Object Report

24.7.0

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

This DAT is used to display the student's current Grade level in alternate language

• Student demographics

• arg.locale=th

To obtain the translation text for the specified fields,

eg;arg.locale=th.

Object Report

24.10.0

~(*powerquery;query=com.powerschool.th.dat.emergency;fields=altcontactrelationshipdesc)

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, eg;arg.locale=th

Object Report

24.10.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=formatted_nationalid)

This DAT is used to present the student's national ID in the Thai format, which is "X XXXX XXXXX XX X".

• Student Demographics

 N/A

object Report

25.3.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=thaiPrefix)

This DAT is used to display the student's prefix in Thai.

• Student Demographics

 N/A

object Report

25.3.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=englishPrefix)

This DAT is used to display the student's prefix in English.

• Student Demographics

 N/A

object Report

25.3.0

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

This DAT is used to display the student's first name in English.

• Student Demographics

 N/A

object Report

25.3.0

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

This DAT is used to display the student's middle name in English.

• Student Demographics

 N/A

object Report

25.3.0

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

This DAT is used to display the student's last name in English.

• Student Demographics

 N/A

object Report

25.3.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=firstname)

This DAT is used to display the student's first name in Thai.

• Student Demographics

 N/A

object Report

25.3.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=middlename)

This DAT is used to display the student's middle name in Thai.

• Student Demographics

 N/A

object Report

25.3.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=lastname)

This DAT is used to display the student's last name in Thai.

• Student Demographics

 N/A

object Report

25.3.0

~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=studentnumber)

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

• Student Demographics

 N/A

object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.courseinfotable;fields=fields=course_number,alt_course_number,course_name,alt_course_name,earnedcrhrs,gpa_points,credits,grade)

Example:a DAT with full aruguments for reference

~(*powerquery;query=com.powerschool.th.report.dat.courseinfotable;arg.shownumber=y;arg.storecode=S1;arg.gradelevel=7;arg.credittype=basic;arg.excludedcreditlist=ld;arg.showgpa=y;arg.showgrade=y;fields=course_number,alt_course_number,course_name,alt_course_name,earnedcrhrs,gpa_points,credits,grade)

NOTE: Only include the fields that you want to print on the report.

This DAT is used to display the course information with the arguments storecode, gradelevel, credittype, excludedcreditlist, showgpa, shownumber, and showgrade. These arguments will retrieve the following fields:

• course_number: This field retrieves the course number based on the arguments.

• alt_course_number: This field retrieves the alternative course number based on the arguments.

• course_name: This field retrieves the name of the course.

• alt_course_name: This field retrieves the alternative name of the course.

• earnedcrhrs: This field retrieves the earned credit hours for the course.

• gpa_points: This field retrieves the GPA points associated with the course.

• credits: This field retrieves the credits earned for the course.

• grade: This field retrieves the grade received for the course.

• Course info

• Historical Grades

• arg.storecode: Required argument indicating the storecode of the student.

• Example: arg.storecode=S1 (This sets the store code to "S1")

• arg.gradelevel: Required argument indicating the gradelevel of the student .

• Example: arg.gradelevel=7 (This sets the grade level to 7)

• arg.credittype: Required argument Specifying the credit type to group the course based on the credit type.

• Example: arg.credittype=basic (This sets the credit type to basic we use like elec,lda)

• arg.excludedcreditlist: Excludes the credit type that is not needed from the list.

• Example: arg.excludedcreditlist=ld (This excludes the credit type "ld")

• arg.showgpa: Specifies whether the GPA should be displayed.

• Example: arg.showgpa=y (This will display the GPA) and arg.showgpa=n (This will not display the GPA)

• arg.shownumber: Specifies whether the course number should be displayed.

• Example: arg.shownumber=y (This will display the course number)

• arg.showgrade: Specifies whether the grade should be displayed.

• Example: arg.showgrade=y (This will display the grade) and arg.showgrade=n (This will not display the grade)

• arg.orderwith: This argument specifies the order by which to sort the results:

  • credittype

  • course_number

  • course_name

  If this argument is not provided, the default order is by credit type. To sort by course name or course number, use the following examples:

• Example:

  • arg.orderwith=course_number

  • arg.orderwith=course_name

Object Report

25.8.0

~(*powerquery;query=com.powerschool.th.report.dat.totalcredithours;fields=course_name,credit_hours,weighted_credit);

Example: A DAT with full arguments for reference

~(*powerquery;query=com.powerschool.th.report.dat.totalcredithours;fields=course_name,credit_hours,weighted_credit;arg.storecode=Y1;arg.credittypelist=basic;arg.mingradelevel=10;arg.maxgradelevel=12)

Note: Only include the fields that you want to print on the report.

This DAT is used to present the average weighted and credit hours for the course based on the given grade levels, using the arguments storecode, credittypelist, mingradelevel, and maxgradelevel. to retrieve the following fields:

• course_name: Retrieves the name of the course.

• credit_hours: Retrieves the credit hours associated with the course.

• weighted_credit: Retrieves the weighted credit hours for the course.

• Course info

• Historical Grades

• arg.storecode: Required argument indicating the store code.

• Example: storecode=Y1 (This sets the store code to "Y1")

• arg.credittypelist: Required argument indicating the list of credit types to include.

• Example: credittypelist=basic (This includes the "basic" credit type)

• arg.mingradelevel: Required argument indicating the minimum grade level to include.

• Example: mingradelevel=10 (This sets the minimum grade level to 10)

• arg.maxgradelevel: Required argument indicating the maximum grade level to include.

• Example: maxgradelevel=12 (This sets the maximum grade level to 12)

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.totalcreditweightedavg;fields=sum_credit_hours,avg_weighted_credit;)

Example: A DAT with full arguments for reference

~(*powerquery;query=com.powerschool.th.report.dat.totalcreditweightedavg;fields=sum_credit_hours,avg_weighted_credit;arg.storecode=Y1;arg.mingradelevel=7;arg.maxgradelevel=9;arg.credittypelist=basic;)

NOTE: Only include the fields that you want to print on the report.

This DAT is used to present the average weighted and total credit hours for the course, retrieved from the DAT, using the arguments storecode, credittypelist, mingradelevel, and maxgradelevel. This retrieves the following fields:

• sum_credit_hours: Retrieves the total credit hours based on the provided arguments.

• avg_weighted_credit: Retrieves the average weighted credit hours based on the provided arguments.or the course.

• Course info

• Historical Grades

• arg.storecode: Required argument indicating the store code.

• Example: storecode=Y1 (This sets the store code to "Y1")

• arg.credittypelist: Required argument indicating the list of credit types to include.

• Example: credittypelist=basic (This includes the "basic" credit type)

• arg.mingradelevel: Required argument indicating the minimum grade level to include.

• Example: mingradelevel=10 (This sets the minimum grade level to 10)

• arg.maxgradelevel: Required argument indicating the maximum grade level to include.

• Example: maxgradelevel=12 (This sets the maximum grade level to 12)

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.overallgradegroupbygradelevel;fields=result)

Example: A DAT with full arguments for reference

~(*powerquery;query=com.powerschool.th.report.dat.overallgradegroupbygradelevel;arg.storecode=Y1;arg.gradelevel=6;arg.credittype=lda;arg.excludedcreditlist=d;fields=result)

Note: The above DAT return grade based on the gradescale alienged to the credit type if he is fail then DAT will return F or else it give the Grade only

By using the decode in report user can display respective text against the grade

Example:

~(decode;~(*powerquery;query=com.powerschool.th.report.dat.overallgradegroupbygradelevel;fields=result;arg.storecode=Y1;arg.credittype=elec;arg.gradelevel=9);F;ล้มเหลว
;ผ่าน

This DAT is used to determine the grade achieved for a specific credit type of course at the single grade level, using the arguments storecode, gradelevel, credittype, and, excludedcreditlist to retrieve the field:

• Result: Retrieves the grade data based on the provided arguments from the assigned grade scale.

• Historical Grades

• Grade scale

• arg.storecode: Required argument indicating the store code.

• Example: arg.storecode=Y1 (This sets the store code to "Y1")

• arg.gradelevel: Required argument indicating the grade level.

• Example: arg.gradelevel=8 (This sets the grade level to 8)

• arg.credittype: Required argument specifying the credit type.

• Example: arg.credittype=basic (This sets the credit type to "basic")

• arg.excludedcreditlist: Excludes the credit type that is not needed from the list.

• Example: arg.excludedcreditlist=ld (This excludes the credit type "ld")

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.totalcredithours;fields=course_name,credit_hours,weighted_credit);

Example: A DAT with full arguments for reference

~(*powerquery;query=com.powerschool.th.report.dat.totalcredithours;fields=course_name,credit_hours,weighted_credit;arg.storecode=Y1;arg.credittypelist=basic;arg.mingradelevel=10;arg.maxgradelevel=12)

NOTE: Only include the fields that you want to print on the report.

This DAT is used to display the average weighted and credit hours for the course based on the given grade levels, using the arguments storecode, credittypelist, mingradelevel, and maxgradelevel to retrieve the following fields

• course_name: Retrieves the name of the course.

• credit_hours: Retrieves the credit hours associated with the course.

• weighted_credit: Retrieves the weighted credit hours for the course.

• Course info

• Historical Grades

• arg.storecode: Required argument indicating the store code.

• Example: storecode=Y1 (This sets the store code to "Y1")

• arg.credittypelist: Required argument indicating the list of credit types to include.

• Example: credittypelist=basic (This includes the "basic" credit type)

• arg.mingradelevel: Required argument indicating the minimum grade level to include.

• Example: mingradelevel=10 (This sets the minimum grade level to 10)

• arg.maxgradelevel: Required argument indicating the maximum grade level to include.

• Example: maxgradelevel=12 (This sets the maximum grade level to 12)

• arg.orderwith: This argument specifies the order by which to sort the results:

  • credittype

  • course_number

  • course_name

  If this argument is not provided, the default order is by credit type. To sort by course name or course number, use the following examples:

• Example:

  • arg.orderwith=course_number

  • arg.orderwith=course_name

Object Report

25.8.0

~(*powerquery;query=com.powerschool.th.report.dat.overallgradegroupbymultiplegradelevels;fields=result)

Example: A DAT with full arguments for reference

~(*powerquery;query=com.powerschool.th.report.dat.overallgradegroupbymultiplegradelevels;fields=result;arg.storecode=Y1;arg.mingradelevel=7;arg.credittype=elec;arg.maxgradelevel=9)

Note: The above DAT return grade based on the gradescale alienged to the credit type if he is fail then DAT will return F or else it give the Grade only

By using the decode in report user can display respective text against the grade

Example:~(decode;~(*powerquery;query=com.powerschool.th.report.dat.overallgradegroupbymultiplegradelevels;fields=result;arg.storecode=Y1;arg.mingradelevel=7;arg.credittype=elec;arg.maxgradelevel=9);F;ล้มเหลว
;ผ่าน

This DAT is used to determine the grade achieved for a specific credit type of course at the given grade level, using the arguments storecode, gradelevel, credittype, and excludedcreditlist to retrieve the following field:

• Result: Retrieves the grade data based on the provided arguments from the assigned grade scale.

• Historical Grades

• Grade scale

• arg.storecode: Required argument indicating the store code.

• Example: arg.storecode=Y1 (This sets the store code to "Y1")

• arg.mingradelevel: Required argument indicating the grade level.

• Example: arg.gradelevel=7 (This sets the min grade level to 8)

• arg.maxgradelevel: Required argument indicating the max grade level.

• Example: arg.gradelevel=9 (This sets the grade level to 8)

• arg.credittype: Required argument specifying the credit type.

• Example: arg.credittype=basic (This sets the credit type to "basic")

• arg.excludedcreditlist: Excludes the credit type that is not needed from the list.

• Example: arg.excludedcreditlist=ld (This excludes the credit type "ld")

Object Report

25.3.0

^(*powerquery;query=com.powerschool.th.report.dat.credithrsbygradelevel;fields=enrolledcredits,passedcredits,passedhours,enrolledhours)

Example: A DAT with full arguments for reference

^(*powerquery;query=com.powerschool.th.report.dat.credithrsbygradelevel;fields=enrolledcredits;arg.storecode=Y1;arg.gradelevel=7;arg.credittypelist=basic)

Note: Only include the fields you want to print on the report. This DAT will provide information for a single grade level.

This DAT is used to display the credit hours and credits based on the provided arguments: storecode, gradelevel, credittypelist, and coursenumberlist. The retrieved fields are:

• enrolledcredits: The total number of credit hours (divided by 40) a student is currently registered for in a given store code.

• passedcredits: The number of credit hours (divided by 40) a student has successfully completed and is registered for in a given store code.

• passedhours: The total number of hours associated with the courses that a student has successfully completed and is registered for in a given store code.

• enrolledhours: The total number of hours a student is currently registered for in a given store code.

• Historical Grades

• Grade scale

• arg.storecode: Required argument indicating the store code.

• Example: arg.storecode=Y1 (This sets the store code to "Y1")

• arg.gradelevel: Required argument indicating the grade level

• Example: arg.gradelevel=7 (This sets the grade level to 7)

• arg.credittypelist: specifying the list of credit types to include.

• Example: arg.credittypelist=basic (This includes the "basic" credit type)

• arg.coursenumberlist: Specifies the list of course numbers to include.

• Example: arg.coursenumberlist=101,102,103 (This includes the course numbers 101, 102, and 103)

• Note: Either arg.coursenumberlist or arg.credittypelist must be provided.

Object Report

25.3.0

^(*powerquery;query=com.powerschool.th.report.dat.credithrsbymultiplegradelevels;fields=enrolledcredits,passedcredits,passedhours,enrolledhours)

Example: A DAT with full arguments for reference

^(*powerquery;query=com.powerschool.th.report.dat.credithrsbymultiplegradelevels;fields=enrolledcredits;arg.storecode=Y1;arg.mingradelevel=7; arg.maxgradelevel=9; arg.credittypelist=basic)

Note: Only include the fields you want to print on the report. This DAT will provide information of an average based-on minimum and maximum grade level.

This DAT is used to display the credit hours and credits based on the provided arguments: storecode, mingradelevel, maxgradelevel, credittypelist, and coursenumberlist. The retrieved fields are:

• enrolledcredits: The total number of credit hours (divided by 40) a student is currently registered for in a given store code.

• passedcredits: The number of credit hours (divided by 40) a student has successfully completed and is registered for in a given store code.

• passedhours: The total number of hours associated with the courses that a student has successfully completed and is registered for in a given store code.

• enrolledhours: The total number of hours a student is currently registered for in a given store code.

• Historical Grades

• Grade scale

• arg.storecode: Required argument indicating the store code.

• Example: arg.storecode=Y1 (This sets the store code to "Y1")

• arg.mingradelevel: Required argument indicating the minimum grade level

• Example: arg.gradelevel=7 (This sets the grade level to 7)

• arg.maxgradelevel: Required argument indicating the minimum grade level

• Example: arg.gradelevel=10 (This sets the grade level to 10)

• arg.credittypelist: specifying the list of credit types to include.

• Example: arg.credittypelist=basic (This includes the "basic" credit type)

• arg.coursenumberlist: Specifies the list of course numbers to include.

• Example: arg.coursenumberlist=101,102,103 (This includes the course numbers 101, 102, and 103)

• Note: Either arg.coursenumberlist or arg.credittypelist must be provided.

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.test.validate;arg.testname=O-NET;arg.gradelevel=9;fields=result);

Note: The above DAT will provide a "Y" or "N" to determine whether a student has appeared for the test. If you want to perform any manipulation based on this result, use the decode function as shown in the example.

Example:~(decode;~(*powerquery;query=com.powerschool.th.report.dat.test.validate;arg.testname=O-NET;arg.gradelevel=9;fields=result);Y;O-NET ชั้นประถมศึกษาปีที่ 6
<tabl 0.52>ภาษาไทย<tabl 1.13>คะแนนเต็ม<tabl 1.69>100<tabl 1.89>ได้<tabl 2.04>~(*powerquery;query=com.powerschool.th.report.dat.testscore;arg.preffield=districtname;arg.testname=O-NET;arg.subjectname=THAI;arg.gradelevel=6;fields=numscore); ;)

This DAT is used to determine whether the student has appeared for any of the subjects in the test specified in the testname argument, retrieving the following field:

Result: This field indicates whether the student has appeared for any of the Subjects for the specified test in the argument. It provides a "Y" (appeared for at least one of the subject listed under the testname in the argument) or an "N" (did not appear for any of the subject listed under the testname in the argument).

• Tests

• TestScores

• arg.testname: Required argument indicating the name of the test to validate.

• Example: testname=O-NET (This sets the test name to "O-NET")

• arg.gradelevel: Required argument indicating the grade level of the students to validate.

• Example: gradelevel=9 (This sets the grade level to 9)

Note: These arguments help in determining whether students in the specified grade level have appeared for the specified test.

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.testscore.validate;arg.testname=O-NET;arg.subjectname=MATH;arg.gradelevel=9;fields=result);

Note: The above DAT will provide a "Y" or "N" to determine whether a student has appeared for the test for a specific subject. If you want to perform any manipulation based on this result, use the decode function as shown in the example.

Example:~(decode;~(*powerquery;query=com.powerschool.th.report.dat.testscore.validate;arg.testname=O-NET;arg.subjectname=MATH;arg.gradelevel=9; fields=result);Y;O-NET ชั้นประถมศึกษาปีที่ 6
<tabl 0.52>ภาษาไทย<tabl 1.13>คะแนนเต็ม<tabl 1.69>100<tabl 1.89>ได้<tabl 2.04>~(*powerquery;query=com.powerschool.th.report.dat.testscore;arg.preffield=districtname;arg.testname=O-NET;arg.subjectname=THAI;arg.gradelevel=6;fields=numscore); ;)

This DAT is used to determine whether the student has appeared for the specific subjects in the test specified by the testname and subjectname arguments, retrieving the following field:

• Result: This field indicates whether the student has appeared for the particular subject in the specified test. It provides a "Y" (appeared for the subject under the testname in the argument) or an "N" (did not appear for any of the subjects under the testname in the argument).

• Tests

• TestScores

• arg.testname: Required argument indicating the name of the test to validate.

• Example: testname=O-NET (This sets the test name to "O-NET")

• arg.subjectname: Required argument indicating the name of the test to validate.

• Example: subjectname=MATH (This sets the test name to "O-NET")

• arg.gradelevel: Required argument the grade level of the students to validate.

• Example: gradelevel=9 (This sets the grade level to 9)

Note: These arguments help in determining whether students in the specified grade level have appeared for the specified test.

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.testscore;arg.testname=O-NET;arg.subjectname=THAI;arg.gradelevel=6;fields=testname,subjectname,percentscore,numscore,alphascore;)

Note: Only include the fields you want to print on the report.

This DAT is used to determine the score for a test for the specified subject, test name and gradelevel in argument and retrieving the following fields:

• Testname: The name of the test for which the scores are being retrieved.

• Subjectname: The name of the subject within the test for which the scores are being retrieved.

• Percentscore: The percentage score achieved by the student in the specified subject of the test.

• Numscore: The numerical score achieved by the student in the specified subject of the test.

• Alphascore: The alphabetical grade or score achieved by the student in the specified subject of the test.

• Tests

• TestScores

• Student testscore

• arg.testname: Required argument indicating the name of the test

• Example: testname=O-NET (This sets the test name to "O-NET")

• arg.subjectname: Required argument indicating the name of the subject within the test.

• Example: subjectname=THAI (This sets the subject name to "THAI")

• arg.gradelevel: Required argument indicating the grade level of the students.

• Example: gradelevel=6 (This sets the grade level to 6)

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.gpax;fields=gradeweight,testweight,result;)

Example: A DAT with full arguments for reference

~(*powerquery;query=com.powerschool.th.report.dat.gpax;arg.storecode=Y1;arg.mingradelevel=7;arg.credittypelist=basic;arg.maxgradelevel=9;arg.testcolumn=numscore;arg.testweight=30;arg.gradeweight=70;arg.testname=O-NET;fields=gradeweight,testweight,result;)

Note: Only include the fields you want to print on the report.

This DAT is used to display the GPAX calculation by passing the required arguments: testname, credittypelist, mingradelevel, maxgradelevel, testweight, and gradeweight. This will retrieve the following fields:

• gradeweight: The percentage calculated for the grade level within the range specified by the mingradelevel and maxgradelevel arguments, using the percentage provided in the gradeweight argument.

• testweight: The percentage calculated for the test scores, using the percentage provided in the testweight argument.

• result: The final calculated result based on sum of grade weight and test weight.

• Historical Grades

• Test Score

• arg.storecode: Required argument indicating the store code.

• Example: storecode=Y1 (This sets the store code to "Y1")

• arg.mingradelevel: Required argument indicating the minimum grade level to include.

• Example: mingradelevel=7 (This sets the minimum grade level to 7)

• arg.maxgradelevel: Required argument indicating the maximum grade level to include.

• Example: maxgradelevel=9 (This sets the maximum grade level to 9)

• arg.credittypelist: Required argument indicating the list of credit types to include.

• Example: credittypelist=basic (This includes the "basic" credit type).

• arg.testname: Required argument indicating the name of the test.

• Example: testname=O-NET (This sets the test name to "O-NET")

• arg.testcolumn: Required argument indicating the column containing the test scores whether gradeweight and testweight field calculation should be happen based on numscore or percentage

• Example: testcolumn=numscore (This sets the test score column to "numscore")

• testcolumn=percentscore (This sets the test score column to "percentscore")

• arg.testweight: Required argument indicating the weight assigned to the test scores in the calculation.

• Example: testweight=30 (This sets the test weight to 30)

• arg.gradeweight: Required argument indicating the weight assigned to the grade scores in the calculation.

• Example: gradeweight=70 (This sets the grade weight to 70).

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.formerschooldetails;fields=schoolname;arg.storecode=Y1)

This DAT is used to display former school name of the student.

• Historical Grades

arg.storecode: Required argument indicating the store code.

• Example: storecode=Y1 (This sets the store code to "Y1")

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.formerschooldetails;fields=altschoolname;arg.storecode=Y1)

This DAT is used to display former alternate school name of the student.

• Historical Grades

arg.storecode: Required argument indicating the store code.

• Example: storecode=Y1 (This sets the store code to "Y1")

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.formerschooldetails;fields=gradelevel;arg.storecode=Y1)

This DAT is used to display former school grade level of the student.

• Historical Grades

arg.storecode: Required argument indicating the store code.

• Example: storecode=Y1 (This sets the store code to "Y1").

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.formerschooldetails;fields=schoolprovince;arg.storecode=Y1)

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

• Historical Grades

arg.storecode: Required argument indicating the store code.

• Example: storecode=Y1 (This sets the store code to "Y1")

• arg.locale: This is an optional argument. By default, the province will be displayed in Thai. If you need it to be displayed in another locale, please specify the desired locale in this argument.

• Example: arg.locale=en

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.formerschooldetails;fields=earnedcrhrs;arg.storecode=Y1)

This DAT is used to display earned credit hours in the former school of the student.

• Historical Grades

arg.storecode: Required argument indicating the store code.

• Example: storecode=Y1 (This sets the store code to "Y1")

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.formerschooldetails;fields=credits;arg.storecode=Y1)

This DAT is used to display credits in the former school of the student.

• Historical Grades

arg.storecode: Required argument indicating the store code.

• Example: storecode=Y1 (This sets the store code to "Y1").

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.graduationdetails;arg.gradelevel=9;fields=transcriptnumber)

This DAT is used to display the transcript number of the student against the grade level given in the argument.

• Graduation Detail

• arg.gradelevel: Required argument indicating the grade level of the students.

• Example: gradelevel=9 (This sets the grade level to 9)

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.graduationdetails;arg.gradelevel=9;fields=runningnumber)

This DAT is used to display running number of the student against grade level given in the argument.

• Graduation Detail

• arg.gradelevel: Required argument indicating the grade level of the students.

• Example: gradelevel=9 (This sets the grade level to 9)

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.graduationdetails;arg.gradelevel=9;fields=graduationnumber)

This DAT is used to display graduation number of the student against grade level given in the argument.

• Graduation Detail

• arg.gradelevel: Required argument indicating the grade level of the students.

• Example: gradelevel=9 (This sets the grade level to 9)

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.graduationdetails;arg.gradelevel=9;fields=graduationdate)

This DAT is used to display graduation date of the student against grade level given in the argument.

• Graduation Detail

• arg.gradelevel: Required argument indicating the grade level of the students.

• Example: gradelevel=9 (This sets the grade level to 9)

• arg.dateformat: Required argument indicating the date format.

• Example: arg.dateformat=DD-MM-YYYY (This sets the date format to DD-MM-YYYY)

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.graduationdetails;arg.gradelevel=9;arg.dateformat=DD-MM-YY;fields=transcriptnumber,runningnumber,graduationdate,gradelevel)

This DAT is used to display transcript number, running number, graduation number, graduation date, grade of the student against grade level given in the argument.

• Graduation Detail

• arg.gradelevel: Required argument indicating the grade level of the students.

• Example: gradelevel=9 (This sets the grade level to 9)

• arg.dateformat: Required argument indicating the date format.

• Example: arg.dateformat=DD-MM-YYYY (This sets the date format to DD-MM-YYYY)

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.reenrollmentdetails;arg.gradelevel=9;arg.dateformat=DD-MM-YYYY;fields=exitdate)

This DAT is used to display exit date of the student against grade level given in the argument.

• Re-enrollment

• arg.gradelevel: Required argument indicating the grade level of the students.

• Example: gradelevel=9 (This sets the grade level to 9)

• arg.dateformat: Required argument for indicating the date format.

• Example: arg.dateformat=DD-MM-YYYY (This sets the date format to DD-MM-YYYY)

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.reenrollmentdetails;arg.gradelevel=9;fields=exitreason)

This DAT is used to display exit reason of the student against grade level given in the argument.

• Re-enrollment

• arg.gradelevel: Required argument indicating the grade level of the students.

• Example: gradelevel=9 (This sets the grade level to 9)

• arg.locale: This is an optional argument. By default, the exit reason will be displayed in Thai. If you need it to be displayed in another locale, please specify the desired locale in this argument.

• Example: arg.locale=en

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.reenrollmentdetails;arg.gradelevel=9;fields=exitcode)

This DAT is used to display exit code of the student against grade level given in the argument.

• Re-enrollment

• arg.gradelevel: Required argument indicating the grade level of the students.

• Example: gradelevel=9 (This sets the grade level to 9)

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.reenrollmentdetails;arg.gradelevel=9;fields=exitcode,exitreason,exitdate,gradlevel)

This DAT is used to display exit code, exit reason, exit date and gradelevel of the student against grade level given in the argument.

• Re-enrollment

• arg.gradelevel: Required argument indicating the grade level of the students.

• Example: gradelevel=9 (This sets the grade level to 9).

• arg.dateformat: Required argument for indicating the date format.

• Example: arg.dateformat=DD-MM-YYYY (This sets the date format to DD-MM-YYYY).

• arg.locale: This is an optional argument. By default, the exit reson will be displayed in Thai. If you need it to be displayed in another locale, please specify the desired locale in this argument.

• Example: arg.locale=en

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.thaidateformat;fields=thaidate;arg.gregoriandate=^(DOB;dateformat=DD/MM/YYYY))

Note: This DAT Gregorian date is input argument it must be DD-MM-YYYY format

This DAT is used to display the date after the formatted Gregorian date in the argument to Thai date format.

Example:

arg.gegoriandate:10-01-2001

output (Thai date):10 มกราคม 2257

 N/A

• arg.gregoriandate: Required argument indicating the Gregorian date to be converted to the Thai date format.

• Example: gregoriandate=^(DOB;dateformat=DD/MM/YYYY) (This sets the Gregorian date to the date of birth (DOB) in the format DD/MM/YYYY)

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.thaidateformat;fields=thaiday;arg.gregoriandate=^(DOB;dateformat=DD/MM/YYYY))

Note:

1. For this DAT Gregorian date is input argument it must be in DD-MM-YYYY format

2. To ensure the Gregorian Date passed in the argument is valid, it should not be null or in the format 0/00/0000. Use the decode function for validation, as shown in the example below.

^(decode;^(DOB;dateformat=DD/MM/YYYY);00/00/0000; ;~(*powerquery;query=com.powerschool.th.report.dat.thaidateformat;fields=thaidate;arg.gregoriandate=^(DOB;dateformat=DD/MM/YYYY)))

This DAT is used to display day in the date after the formatted Gregorian date in the argument.

Example:

arg.gegoriandate:10-01-2001

output(Thaiday):10

 N/A

• arg.gregoriandate: Required argument indicating the Gregorian date to be converted to the Thai date format.

• Example: gregoriandate=^(DOB;dateformat=DD/MM/YYYY) (This sets the Gregorian date to the date of birth (DOB) in the format DD/MM/YYYY)

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.thaidateformat;fields=thaimonth;arg.gregoriandate=^(DOB;dateformat=DD/MM/YYYY))

Note:

1.For this DAT Gregorian date is input argument it must be DD-MM-YYYY format

2. To ensure the Gregorian Date passed in the argument is valid, it should not be null or in the format 0/00/0000. Use the decode function for validation, as shown in the example below.

^(decode;^(DOB;dateformat=DD/MM/YYYY);00/00/0000; ;~(*powerquery;query=com.powerschool.th.report.dat.thaidateformat;fields=thaidate;arg.gregoriandate=^(DOB;dateformat=DD/MM/YYYY)))

This DAT is used to display month in the date after the formatted Gregorian date in the argument to Thai date format.

Example:

arg.gegoriandate: 10-01-2001

output(thaimonth): มกราคม

 N/A

• arg.gregoriandate: Required argument indicating the Gregorian date to be converted to the Thai date format.

• Example: gregoriandate=^(DOB;dateformat=DD/MM/YYYY) (This sets the Gregorian date to the date of birth (DOB) in the format DD/MM/YYYY)

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.thaidateformat;fields=thaiyear;arg.gregoriandate=^(DOB;dateformat=DD/MM/YYYY))

Note:

1.For this DAT Gregorian date is input argument it must be DD-MM-YYYY format

2. To ensure the Gregorian Date passed in the argument is valid, it should not be null or in the format 0/00/0000. Use the decode function for validation, as shown in the example below.

^(decode;^(DOB;dateformat=DD/MM/YYYY);00/00/0000; ;~(*powerquery;query=com.powerschool.th.report.dat.thaidateformat;fields=thaidate;arg.gregoriandate=^(DOB;dateformat=DD/MM/YYYY)))

This DAT is used to display year in the date after the formatted Gregorian date in the argument to Thai date format.

Example:

arg.gegoriandate:10-01-2001

output(Thaiyear):: 2257

 N/A

• arg.gregoriandate: Required argument indicating the Gregorian date to be converted to the Thai date format.

• Example: gregoriandate=^(DOB;dateformat=DD/MM/YYYY) (This sets the Gregorian date to the date of birth (DOB) in the format DD/MM/YYYY)

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.thainumbers;fields=thai_number;arg.engnumber=123)

This DAT is used to provide numerics into Thai numerics by passing math numerical as argument.

Example:

arg.engnumber=123

output(thai_number)=๑๒๓

arg.engnumber=abcd123

output(thai_number)=abcd๑๒๓

 N/A

• arg.engnumber: Required argument indicating the math number to be converted to the Thai number format.

• Example: engnumber=123 (This sets the English number to "123")

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.pref;arg.preffield=districtname;fields=value)

This DAT is used to display the district name of the school.

• District office

• arg.preffield: Required argument indicating the field in name column in pref table retrieve the value column in pref table.

• Example: preffield=districtname (This sets the field name to "districtname")

Object Report

25.3.0

~(*compliance;dat.name=DAT_localization_currentselectionids)

This DAT is used to get the ID’s of the selected students in the search.

• Student Search screen

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.studentcountongender;fields=totalcount;arg.studentids=~(*compliance;dat.name=DAT_localization_currentselectionids))

This DAT is used to display the total count of student selected to generate report.

• Student Search screen

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.studentcountongender;fields=malecount;arg.studentids=~(*compliance;dat.name=DAT_localization_currentselectionids))

This DAT is used to display the male count of student selected to generate report.

• Student Search screen

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.studentcountongender;fields=femalecount;arg.studentids=~(*compliance;dat.name=DAT_localization_currentselectionids))

This DAT is used to display the female count of student selected to generate report.

• Student Search screen

Object Report

25.3.0

~(*compliance;dat.name=DAT_localization_seqno;evenmax=14;oddmax=10;seqno=1)

This DAT is used to display Sequence number in object report.

 N/A

evenmax: Need to give the total no of students/max sequence print on even pages.

oddmax: Need to give the total no of students/sequence print on odd pages.

seqno: Need to give the sequence no/position of student in a given page.

Note: The seqno, even max, and odd max should be provided as inputs in the object report, with seqno starting from 1 and incrementing for each row on every page.

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.parentnamevalidation;fields=remark)

This DAT is used to display remark in report Graduation Report in Thai language as per smart requirement:

Case 1: If father or mother has value that is “-“, Report display: “ไม่มีหลักฐานตามกฎหมายว่าด้วยการทะเบียนราษฎร”

Case 2: Could you match the student’s last name with the parent’s last name?

If diff., Report display: “ไม่มีหลักฐานตามกฎหมายว่าด้วยการทะเบียนราษฎร

 N/A

N/A

Object Report

25.3.0

~(*powerquery;query=com.powerschool.th.report.dat.credittypegrouping;fields=credit_hours,weighted_credit);

Example: A DAT with full arguments for reference

~(*powerquery;query=com.powerschool.th.report.dat.credittypegrouping;fields=credit_hours,weighted_credit;arg.storecode=Y1;arg.credittypelistlist=01basicTH,02basicTH;arg.mingradelevel=10;arg.maxgradelevel=12)

NOTE: Only include the fields that you want to print on the report.

This DAT is used to display the average weighted and credit hours for the course based on the given grade levels, using the arguments storecode, credittypelistlist, mingradelevel, and maxgradelevel. to retrieve the following fields:

• credit_hours: Retrieves the total credit hours for the course based on the credittypelist argument.

• weighted_credit: Retrieves the average weighted credit for the course based on the credittypelist argument.

• Course info

• Historical Grades

• arg.storecode: Required argument indicating the store code.

• Example: storecode=Y1 (This sets the store code to "Y1").

• arg.credittypelistlist: Required argument indicating the list of full credit types to include.

• Example: credittypelistlist=basic (This includes the "basic" credit type).

• arg.mingradelevel: Required argument indicating the minimum grade level to include.

• Example: mingradelevel=10 (This sets the minimum grade level to 10).

• arg.maxgradelevel: Required argument indicating the maximum grade level to include.

• Example: maxgradelevel=12 (This sets the maximum grade level to 12).

Object Report

25.12.0

~(*powerquery;query=com.powerschool.th.report.dat.evelutioncoursedetails;fields=course_name,course_number,grade,percent,gpa_points)

Example: A DAT with full arguments for reference

~(*powerquery;query=com.powerschool.th.report.dat.evelutioncoursedetails;fields=,grade,percent,gpa_points;arg.storecode=Y1;arg.gradelevel=7;arg.credittype=RD;)

Note:

1. from this query, you can get only one result against a specific credit type, course number, or both base on argument

2. By using the decode in report user can display respective text against the grade

eg:~(decode;~(*powerquery;query=com.powerschool.th.report.dat.evelutioncoursedetails;fields=grade;arg.storecode=Y1;arg.gradelevel=7;arg.credittype=RD;);F;ล้มเหลว
;ผ่าน)

This DAT is used to determine the grade, percent, gpa points achieved for a specific credit type of course at the given grade level, using the arguments storecode, gradelevel, credittype, coursenumber,and to retrieve the following field.

• gpa_points: This field retrieves the GPA points associated with the course.

• Percent: This field retrieves the percent earned for the course.

• grade: This field retrieves the grade received for the course.

• Historical Grades

• Grade scale

• arg.storecode: Required argument indicating the store code.

• Example: arg.storecode=Y1 (This sets the store code to "Y1")

• arg.gradelevel: Required argument indicating the grade level.

• Example: arg.gradelevel=7 (This sets the min grade level to 8)

• arg.credittype: Required argument specifying the credit type.

• Example: arg.credittypelist=RD (This sets the credit type to "RD")

• arg.coursenumber: argument specifying the coursenumber.

• Example: arg.coursenumber=RD100

Object Report

25.12.0

~(*powerquery;query=com.powerschool.th.report.dat.currentdate.thaidateformat;fields=thaiday_localized)

This DAT is used to display the current day in Thai format.

• arg.dayformat

defaults value is FMDD, which outputs days without a preceding zero. To include a preceding zero for days, pass this argument as DD

eg:arg.dayformat=DD

object Report

25.12.0

~(*powerquery;query=com.powerschool.th.report.dat.currentdate.thaidateformat;fields=thaimonth_localized)

This DAT is used to display the current month alone in Thai.

object Report

25.12.0

~(*powerquery;query=com.powerschool.th.report.dat.currentdate.thaidateformat;fields=thaiyear_localized)

This DAT is used to display the current year in Thai format.

object Report

25.12.0

~(*powerquery;query=com.powerschool.th.report.dat.currentdate.thaidateformat;fields=thaidate_localized)

This DAT is used to display the current date in Thai format.

• arg.dayformat

defaults value is FMDD, which outputs days without a preceding zero. To include a preceding zero for days, pass this argument as DD

eg:arg.dayformat=DD

object Report

25.12.0

~(*powerquery;query=com.powerschool.th.dat.student_graduation_plan;fields=graduation_plans)

This DAT is used to display the student's enrolled graduation plan (Study Plan).

Mass Graduation Plan Selection

Object Report

25.12.0

~(*powerquery;query=com.powerschool.th.dat.calculate.gpax;fields=gpax;arg.storecode=Q1,Q2)

This DAT is used to display the student's GPAX calculation based on given arguments. It does not accept grade level as a separate argument. Instead, if the student falls under any grade between grades 1-6, it displays the GPAX for subjects within grades 1-6; similarly for grades 7-9 and 10-12.

Historical Grades

• arg.credittypelist
  specifies the credit type of the subjects that should be included in the gpax calculation. multiple credit types can be given separated by commas.

• Example : arg.credittypelist=basic,elective

• arg.storecode
  Specifies the store code of the terms for which the GPAX should be calculated. multiple storecodes can be given separated by commas.

• Example : arg.storecode=Q1,Q2

Object Report

25.12.0

~(*powerquery;query=com.powerschool.th.report.dat.studentpercentilerank;fields=percentile_rank;arg.storecodes=Q1,Q2;arg.credittypes_elementary=basic;arg.credittypes_lower_secondary=basic;arg.credittypes_upper_secondary=basic)

This DAT is used to display the student's Percentile Rank calculation based on given arguments. It evaluates all stored grades for the selected store codes and applies credit-type filtering based on grade-level groups (Elementary, Lower Secondary, Upper Secondary).

Historical Grades

• arg.storecode
  Specifies the store code of the terms for which the PR should be calculated. Multiple storecodes can be given separated by commas.
  Example : arg.storecode=Q1,Q2

• arg.credittypes_elementary

  Applies only for Grade 1–6 stored grades.
  Filters which credit types should be considered for percentile calculation.
  Example:

  arg.credittypes_elementary=basic

• arg.credittypes_lower_secondary
  Applies only for Grade 7–9 stored grades.Filters which credit types should be considered for percentile calculation.
  Example:
  arg.credittypes_lower_secondary=basic,elective

• arg.credittypes_upper_secondary
  Applies only for Grade 10–12 stored grades. Filters which credit types should be considered for percentile calculation.
  Example:

  arg.credittypes_upper_secondary=basic,elective
  

Object Report

25.12.0

~(*powerquery;query=com.powerschool.th.dat.graduation_status;fields=status;arg.locale=US_en)

This DAT is used to display the graduation or studying status of the student. Returns localized text indicating either Graduated from or Studying at based on the student's graduation record. You can change the message key for the text in the SIS portal.

Graduation Details

• arg.locale
  give the country code followed by and '_' then the language code. It displays the text in English and thai based on the language code given.

• Example : arg.locale=US_th

Object Report

25.12.0

~(*powerquery;query=com.powerschool.th.dat.graduation_status;fields=grade_level;arg.locale=US_en)

This DAT is used to display the grade level of the student. For graduated students, displays the grade level they graduated from (6, 9, or 12 with localized labels). For current students that are not yet graduated, displays their current grade level with localized label if not available.

Graduation Details

• arg.locale
  give the country code followed by and '_' then the language code. It displays the text in English and thai based on the language code given.

• Example : arg.locale=US_th

25.12.0

~(*powerquery;query=com.powerschool.th.dat.graduation_status;fields=year)

This DAT is used to display the academic year in standard numeric format (e.g., 2024). For graduated student, it displays the year they got graduated and for current students it displays the current year.

Graduation Details

Object Report

25.12.0

~(*powerquery;query=com.powerschool.th.dat.graduation_status;fields=graduated_year_localized)

This DAT is used to display the academic year converted to Thai numerals (๐๑๒๓๔๕๖๗๘๙) for display purposes. Translates standard digits 0-9 to their Thai equivalents.For graduated student it displays the year they got graduated and for current students it displays the current year.

Graduation Details

Object Report

25.12.0

~(*powerquery;query=com.powerschool.th.dat.graduation_status;fields=school_name)

This DAT is used to display the name of the school. For graduated students, displays the school from which they graduated. For current students, displays their current school.

Graduation Details

Object Report

25.12.0

~(*powerquery;query=com.powerschool.th.dat.graduation_status;fields=alt_school_name)

This DAT is used to display the alternate name of the school. For graduated students, displays the school from which they graduated. For current students, displays their current school.

Graduation Details

Object Report

25.12.0