Skip to main content
Skip table of contents

Thai Localization - Power Query DATs

Thai Localization 25.3.0.0 - Power Query DATs

DATAccess Tag

Description

Portal Page

Optional Parameters

Available

Version

~(*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.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.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

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

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

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

JavaScript errors detected

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

If this problem persists, please contact our support.