School Report Card in Thai (Grade 10-12)

1. ชื่อโรงเรียน (School Name)

• Old Name: school_value

• Object Name: school name

• PowerQuery: ~([39]Name)

• Screen: School info

Description: This DAT is used to display theschool name of the student. If the user needs to display the alternate school name use the DAT ~([schools.schoolscorefields]altschoolname).

2. ที่อยู่โรงเรียน (School Address)

• Old Name: schoolAddress_value

• Object Name: school address

• PowerQuery: ~([schools.s_tha_schools_x]school_HouseNo) ~([schools.s_tha_schools_x]school_Village) ~([schools.s_tha_schools_x]school_Moo) ~([schools.s_tha_schools_x]school_Alleyway) ~([39]schooladdress) ~([schools.s_tha_schools_x]school_Road) ~(*powerquery;query=com.powerschool.th.admin.dat.schoolinfo;fields=school_provience) ~(*powerquery;query=com.powerschool.th.admin.dat.schoolinfo;fields=school_district) c ~(*powerquery;query=com.powerschool.th.admin.dat.schoolinfo;fields=school_zip)

• Screen: School info

Description:

• ~([schools.s_tha_schools_x]school_HouseNo) - This DAT is used to display theHouse No of the school

• ~([schools.s_tha_schools_x]school_Village) - This DAT is used to display theVillage/Building of the school

• ~([schools.s_tha_schools_x]school_Moo) - This DAT is used to display theMoo of the school

• ~([schools.s_tha_schools_x]school_Alleyway) - This DAT is used to display theAlleyway of the school

• ~([39]schooladdress) - This DAT is used to display theSchool Address (Full) of the school

• ~([schools.s_tha_schools_x]school_Road) - This DAT is used to display theRoad of the school

• ~(*powerquery;query=com.powerschool.th.admin.dat.schoolinfo;fields=school_provience) - This DAT is used to display theSchool Province

• ~(*powerquery;query=com.powerschool.th.admin.dat.schoolinfo;fields=school_district) - This DAT is used to display theSchool District

• ~(*powerquery;query=com.powerschool.th.admin.dat.schoolinfo;fields=school_zip) - This DAT is used to display theSchool Zipcode

3. ชื่อนักเรียน (Student Name)

• Old Name: studentName_value

• Object Name: student name

• PowerQuery: ^(First_Name) ^(Middle_Name) ^(Last_Name)

• Screen: Student Demographics

Description:

• ^(First_Name) - This DAT is used to display thealternate first name of the student. Use ~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=altfirstname) to get the alternate first name of the student.

• ^(Middle_Name) - This DAT is used to display themiddle name of the student. Use ~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=altmiddlename) to get the alternate middle name of the student.

• ^(Last_Name) - This DAT is used to display thelast name of the student. Use ~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=altlastname) to get the alternate last name of the student.

4. เพศ (Sex)

• Old Name: gender_value

• Object Name: student gender

• PowerQuery: ~(gender)

• Screen: Student Demographics

Description: This DAT is used to display the gender of the student.

5. หมายเลขประจําตัวประชาชน (ID Number)

• Old Name: nationalId_value

• Object Name: student NationalID

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

• Screen: Student Demographics

Description: We are using this DAT to present the student's national ID in the Thai format, which is X XXXX XXXXX XX X.

6. สัญชาต(Nationality)

• Old Name: nationality_value

• Object Name: student nationality

• PowerQuery:
  ~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=nationality;arg.locale=US_th)

• Screen: Student Demographics

Description: This DAT is used to display thenationality of the student.

7. ศาสนา( Religion)

• Old Name: religion_value

• Object Name: student religion

• PowerQuery:
  ~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=religion;arg.locale=US_th)

• Screen: Student Demographics

Description: This DAT is used to display theReligion of the student.

8. วันเกิด(DOB)

• Old Name: dob_value

• Object Name: student dob

• PowerQuery: ~(dob;dateformat=MMMM d,yyyy)

• Screen: Student Demographics

Description: This DAT is used to display the DOB after the formatted gregorian date in the argument to Thai date format. Ex :10-01-2001, output(Thaidate) :10 มกราคม 2257

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

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

9. บ้านเกิด(Place of Birth)

• Old Name: placeofbirth_value

• Object Name: student placeofbirth

• PowerQuery: ^(S_THA_STU_X.PlaceOfBirth)

• Screen: Student Demographics

Description: This DAT is used to display thePlace of Birth of the Student. Use the DAT ^(S_THA_STU_X.altPlaceOfBirth) to display the alternate place of birth.

10. ที่อยู่บ้าน (Home Address)

• Old Name: homeaddress_value

• Object Name: student homeaddress

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

• Screen: Student Demographics

Description: This DAT is used to display theHome Address of the student. To get the alternate home address, use the DAT ^(S_THA_STU_X.althomeAddress).

11. ชื่อผู้ปกครอง(หรือ ผู้ปกครอง)

• Old Name: parents_value

• Object Name: parent/guardian name

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

• Screen: Contact Management

Description: This DAT is used to display thefather name and mother name of the student in the (Prefix, given name, middle name, surname) format. Use the DATs ~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=fathernameenglish) ~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mothernameenglish) to get the alternate names instead of default.

12. วันที่รับสมัคร(Date of Admission)

• Old Name: admissionDate_Value

• Object Name: admission date

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

• Screen: Student Enrollment

Description: This DAT is used to display the Date of Admission after the formatted gregorian date in the argument to Thai date format. Ex :10-01-2001, output(Thaidate) :10 มกราคม 2257.

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

13. ชื่อโรงเรียนเดิม (Former School)

• Old Name: formerschool_value

• Object Name: former school name

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

• Screen: Historical Grades

Description: This DAT is used to display theformer school of the student.

14. เกรด (โรงเรียนเก่า)(Former School Grade)

• Old Name: formergrade_value

• Object Name: former school grade

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

• Screen: Historical Grades

Description: This DAT is used to display theformer grade in which the student was studying in the former school.

15. ไม่ใช่ จํานวนเครดิตที่ได้รับ(โรงเรียนเก่า)[Credits Earned in Former School]

• Old Name: formercredit_value

• Object Name: former credit

• PowerQuery: ~(*powerquery;query=com.powerschool.th.report.dat.formerschooldetails;fields=credit;arg.storecode=Y1)

• Screen: Historical Grades

Description: This DAT is used to display thetotal credits the student earned at their previous school.

16. เกรด 10( ภาค 1 and ภาค 2)

• Old Name: grade10_table

• Object Name: grade10 table

• PowerQuery: This object contains a total of six PowerQuery DAT calls

  Semester 1 (storecode = S1)

  ^(*powerquery;query=com.powerschool.th.report.dat.courseinfotable;tableformat;fields=course_number,course_name,earnedcrhrs,gpa_points;arg.storecode=S1;arg.gradelevel=10;arg.credittypelist=basic;arg.excludedcreditlist=basir;arg.locale=US_th)

  ^(*powerquery;query=com.powerschool.th.report.dat.courseinfotable;tableformat;fields=course_number,course_name,earnedcrhrs,grade;arg.storecode=S1;arg.gradelevel=10;arg.credittypelist=lda;arg.shownumber=n;arg.excludedcreditlist=ld;arg.locale=US_th)

  ^(*powerquery;query=com.powerschool.th.report.dat.courseinfotable;tableformat;fields=course_number,course_name,earnedcrhrs,grade;arg.storecode=S1;arg.gradelevel=10;arg.credittypelist=elec;arg.shownumber=n;arg.excludedcreditlist=el,ec;arg.locale=US_th)

  Semester 2 (storecode = S2)

  The same DATs are reused for Semester 2.
  The only change is the storecode: arg.storecode=S2

  ^(*powerquery;query=com.powerschool.th.report.dat.courseinfotable;tableformat;fields=course_number,course_name,earnedcrhrs,gpa_points;arg.storecode=S2;arg.gradelevel=10;arg.credittypelist=basic;arg.excludedcreditlist=basir;arg.locale=US_th)

  ^(*powerquery;query=com.powerschool.th.report.dat.courseinfotable;tableformat;fields=course_number,course_name,earnedcrhrs,grade;arg.storecode=S2;arg.gradelevel=10;arg.credittypelist=lda;arg.shownumber=n;arg.excludedcreditlist=ld;arg.locale=US_th)

  ^(*powerquery;query=com.powerschool.th.report.dat.courseinfotable;tableformat;fields=course_number,course_name,earnedcrhrs,grade;arg.storecode=S2;arg.gradelevel=10;arg.credittypelist=elec;arg.shownumber=n;arg.excludedcreditlist=el,ec;arg.locale=US_th)

• Screen: Course Info, Historical Grades

Description: This object uses multiple instances of the courseinfotable DAT to display academic records for Grade 10, covering both Semester 1 and Semester 2.

All DATs retrieve course-level data by using arguments such as storecode, gradelevel, credittypelist, excludedcreditlist, showgpa, shownumber, and showgrade.
These arguments determine which courses are included, how they are grouped, and which fields are displayed.

The DAT returns the following fields:

• course_number – Standard course number

• course_name – Official course name

• earnedcrhrs – Earned credit hours

• grade – Final awarded grade (if shown)

DAT Arguments

• arg.storecode (Required) – Specifies the storecode (e.g., S1 or S2).

  • Example: arg.storecode=S1

• arg.gradelevel (Required) – Specifies the student’s grade level.

  • Example: arg.gradelevel=10

• arg.credittypelist (Required) – Groups courses by credit type (basic, lda, elec).

  • Example: arg.credittypelist=basic

• arg.excludedcreditlist – Excludes specific credit types.

  • Example: arg.excludedcreditlist=ld

• arg.showgpa – Shows or hides GPA points.

  • Example: arg.showgpa=y

• arg.shownumber – Shows or hides the course number.

  • Example: arg.shownumber=n

• arg.showgrade – Shows or hides the grade.

  • Example: arg.showgrade=y

Semester 1 & Semester 2 inside the same object

The same object includes queries for both semesters.
The only difference is:

• Semester 1 → arg.storecode=S1

• Semester 2 → arg.storecode=S2

All other arguments and field structures remain the same.

17. เกรด 11( ภาค 1 and ภาค 2)

• Old Name: grade11_table

• Object Name: grade11 table

• PowerQuery: This object contains a total of six PowerQuery DAT calls

  Semester 1 (storecode = S1)
  ^(*powerquery;query=com.powerschool.th.report.dat.courseinfotable;tableformat;fields=course_number,course_name,earnedcrhrs,gpa_points;arg.storecode=S1;arg.gradelevel=11;arg.credittypelist=basic;arg.excludedcreditlist=basir;arg.locale=US_th)

  ^(*powerquery;query=com.powerschool.th.report.dat.courseinfotable;tableformat;fields=course_number,course_name,earnedcrhrs,grade;arg.storecode=S1;arg.gradelevel=11;arg.credittypelist=lda;arg.shownumber=n;arg.excludedcreditlist=ld;arg.locale=US_th)

  ^(*powerquery;query=com.powerschool.th.report.dat.courseinfotable;tableformat;fields=course_number,course_name,earnedcrhrs,grade;arg.storecode=S1;arg.gradelevel=11;arg.credittypelist=elec;arg.shownumber=n;arg.excludedcreditlist=el,ec;arg.locale=US_th)

  Semester 2 (storecode = S2)

  The same DATs are reused for Semester 2.
  The only change is the storecode:arg.storecode=S2.

  ^(*powerquery;query=com.powerschool.th.report.dat.courseinfotable;tableformat;fields=course_number,course_name,earnedcrhrs,gpa_points;arg.storecode=S2;arg.gradelevel=11;arg.credittypelist=basic;arg.excludedcreditlist=basir;arg.locale=US_th)

  ^(*powerquery;query=com.powerschool.th.report.dat.courseinfotable;tableformat;fields=course_number,course_name,earnedcrhrs,grade;arg.storecode=S2;arg.gradelevel=11;arg.credittypelist=lda;arg.shownumber=n;arg.excludedcreditlist=ld;arg.locale=US_th)

  ^(*powerquery;query=com.powerschool.th.report.dat.courseinfotable;tableformat;fields=course_number,course_name,earnedcrhrs,grade;arg.storecode=S2;arg.gradelevel=11;arg.credittypelist=elec;arg.shownumber=n;arg.excludedcreditlist=el,ec;arg.locale=US_th)

• Screen: Course Info, Historical Grades

Description: This object uses multiple instances of the courseinfotable DAT to display academic records for Grade 11, covering both Semester 1 and Semester 2.

(Same wording as เกรด 10 — unchanged)

18. เกรด 12( ภาค 1 and ภาค 2)

• Old Name: grade12_table

• Object Name: grade12 table

• PowerQuery: This object contains a total of six PowerQuery DAT calls

  Semester 1 (storecode = S1)
  ^(*powerquery;query=com.powerschool.th.report.dat.courseinfotable;tableformat;fields=course_number,course_name,earnedcrhrs,gpa_points;arg.storecode=S1;arg.gradelevel=12;arg.credittypelist=basic;arg.excludedcreditlist=basir;arg.locale=US_th)

  ^(*powerquery;query=com.powerschool.th.report.dat.courseinfotable;tableformat;fields=course_number,course_name,earnedcrhrs,grade;arg.storecode=S1;arg.gradelevel=12;arg.credittypelist=lda;arg.shownumber=n;arg.excludedcreditlist=ld;arg.locale=US_th)

  ^(*powerquery;query=com.powerschool.th.report.dat.courseinfotable;tableformat;fields=course_number,course_name,earnedcrhrs,grade;arg.storecode=S1;arg.gradelevel=12;arg.credittypelist=elec;arg.shownumber=n;arg.excludedcreditlist=el,ec;arg.locale=US_th)

  Semester 2 (storecode = S2)

  The same DATs are reused for Semester 2.
  The only change is the storecode: arg.storecode=S2.

  ^(*powerquery;query=com.powerschool.th.report.dat.courseinfotable;tableformat;fields=course_number,course_name,earnedcrhrs,gpa_points;arg.storecode=S2;arg.gradelevel=12;arg.credittypelist=basic;arg.excludedcreditlist=basir;arg.locale=US_th)

  ^(*powerquery;query=com.powerschool.th.report.dat.courseinfotable;tableformat;fields=course_number,course_name,earnedcrhrs,grade;arg.storecode=S2;arg.gradelevel=12;arg.credittypelist=lda;arg.shownumber=n;arg.excludedcreditlist=ld;arg.locale=US_th)

  ^(*powerquery;query=com.powerschool.th.report.dat.courseinfotable;tableformat;fields=course_number,course_name,earnedcrhrs,grade;arg.storecode=S2;arg.gradelevel=12;arg.credittypelist=elec;arg.shownumber=n;arg.excludedcreditlist=el,ec;arg.locale=US_th)

• Screen: Course Info, Historical Grades

Description: This object uses multiple instances of the courseinfotable DAT to display academic records for Grade 12, covering both Semester 1 and Semester 2.

(Same wording as เกรด 10 — unchanged)

19. สรุปผล - นักวิชาการ ป(Academic Year)

• PowerQuery:
  ^(*powerquery;query=com.powerschool.th.report.dat.stuyearbygradelevel;fields=thaiyear;arg.storecode=Y1;arg.gradelevel=10)
  ^(*powerquery;query=com.powerschool.th.report.dat.stuyearbygradelevel;fields=thaiyear;arg.storecode=Y1;arg.gradelevel=11)

  ^(*powerquery;query=com.powerschool.th.report.dat.stuyearbygradelevel;fields=thaiyear;arg.storecode=Y1;arg.gradelevel=12)

• Screen: Historical Grades

Description: We are using this DAT to present the student's study year based on the arguments storecode and gradelevel, which will retrieve the following fields.

DAT Arguments:

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

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

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

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

 The DAT returns the following fields:

• thaiyear: Retrieves the Thai academic year based on the provided arguments.

20. สรุปผล - จำนวนหน่วยกิต ลง ทะเบียน (คอร์สหลัก & หลักสูตรคัดเลือก) Credits enrolled

• PowerQuery:
  ^(*powerquery;query=com.powerschool.th.report.dat.credithrsbygradelevel;fields=enrolledcredits;arg.storecode=Y1;arg.gradelevel=10;arg.credittypelist=basic)
  ^(*powerquery;query=com.powerschool.th.report.dat.credithrsbygradelevel;fields=enrolledcredits;arg.storecode=Y1;arg.gradelevel=11;arg.credittypelist=basic)

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

  ^(*powerquery;query=com.powerschool.th.report.dat.credithrsbygradelevel;fields=enrolledcredits;arg.storecode=Y1;arg.gradelevel=10;arg.credittypelist=lda,elec)

  ^(*powerquery;query=com.powerschool.th.report.dat.credithrsbygradelevel;fields=enrolledcredits;arg.storecode=Y1;arg.gradelevel=11;arg.credittypelist=lda,elec)

  ^(*powerquery;query=com.powerschool.th.report.dat.credithrsbygradelevel;fields=enrolledcredits;arg.storecode=Y1;arg.gradelevel=12;arg.credittypelist=lda,elec)

• Screen: Historical Grades, Grade scale

Description: This DAT is used to retrieve the total number of credits enrolled by the student for Grade Levels 10, 11, and 12, including both Core courses (basic) and Selective courses (lda, elec).

The query filters the stored grades by:

• storecode (Y1)

• gradelevel (10/11/12)

• credittypelist (basic, lda, elec)

and calculates the total enrolled credit hours from the courses table.
Only the enrolledcredits field is returned, representing the total credits the student attempted for that grade level across all selected credit types.

Based on the arguments storecode, gradelevel, and credittypelist, the DAT calculates the total enrolled credit hours for each grade level. It pulls data from the storedgrades table (grade-level and storecode filtering) and the courses table (credit hours and credit type filtering).

DAT Arguments:

arg.storecode:
Required argument specifying which store code to use.
Example: storecode=Y1

arg.gradelevel:
Required argument determining the student’s grade level.
Example: gradelevel=10

arg.credittypelist:
Optional argument used to filter by credit type.
Example: credittypelist=basic

The DAT returns the following field:

enrolledcredits:
Returns the total number of Core or Selective Course credits the student enrolled in for the selected grade level based on the arguments passed.

21. สรุปผล - จำนวนหน่วยกิต ผ่าน (คอร์สหลัก & หลักสูตรคัดเลือก) Credits Passed

• PowerQuery:
  ^(*powerquery;query=com.powerschool.th.report.dat.credithrsbygradelevel;fields=passedcredits;arg.storecode=Y1;arg.gradelevel=10;arg.credittypelist=basic)
  ^(*powerquery;query=com.powerschool.th.report.dat.credithrsbygradelevel;fields=passedcredits;arg.storecode=Y1;arg.gradelevel=11;arg.credittypelist=basic)

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

  ^(*powerquery;query=com.powerschool.th.report.dat.credithrsbygradelevel;fields=passedcredits;arg.storecode=Y1;arg.gradelevel=10;arg.credittypelist=lda,elec)

  ^(*powerquery;query=com.powerschool.th.report.dat.credithrsbygradelevel;fields=passedcredits;arg.storecode=Y1;arg.gradelevel=11;arg.credittypelist=lda,elec)

  ^(*powerquery;query=com.powerschool.th.report.dat.credithrsbygradelevel;fields=passedcredits;arg.storecode=Y1;arg.gradelevel=12;arg.credittypelist=lda,elec)

• Screen: Historical Grades, Grade scale

Description: This DAT is used to retrieve the total number of credits passed by the student for Grade Levels 10, 11, and 12, covering both Core courses (basic) and Selective courses (lda, elec).

The query applies the same filtering—storecode, gradelevel, and credittypelist—but returns the passedcredits field, which calculates the total earned credit hours from the stored grades table.

This value represents the credits the student successfully completed within each grade level.

DAT Arguments:

• arg.storecode: Required.
  Example: storecode=Y1

• arg.gradelevel: Required.
  Example: gradelevel=10

• arg.credittypelist: Optional filter for credit types.
  Example: credittypelist=basic,lda,elec]

The DAT returns the following field:

passedcredits:
Total number of Core or Selective credits successfully passed for the selected grade level.

22. สรุปผล -หน่วยกิตรวมที่ลงทะเบียนและผ่าน (คอร์สหลัก & หลักสูตรคัดเลือก) - Total credits (passed & enrolled)

• PowerQuery:
  ^(*powerquery;query=com.powerschool.th.report.dat.credithrsbymultiplegradelevels;fields=enrolledcredits;arg.storecode=Y1;arg.mingradelevel=10;arg.maxgradelevel=12;arg.credittypelist=basic)

  ^(*powerquery;query=com.powerschool.th.report.dat.credithrsbymultiplegradelevels;fields=passedcredits;arg.storecode=Y1;arg.mingradelevel=10;arg.maxgradelevel=12;arg.credittypelist=basic)

  ^(*powerquery;query=com.powerschool.th.report.dat.credithrsbymultiplegradelevels;fields=enrolledcredits;arg.storecode=Y1;arg.mingradelevel=10;arg.maxgradelevel=12;arg.credittypelist=lda,elec)

  ^(*powerquery;query=com.powerschool.th.report.dat.credithrsbymultiplegradelevels;fields=passedcredits;arg.storecode=Y1;arg.mingradelevel=10;arg.maxgradelevel=12;arg.credittypelist=lda,elec)

  ^(*powerquery;query=com.powerschool.th.report.dat.credithrsbymultiplegradelevels;fields=enrolledcredits;arg.storecode=Y1;arg.mingradelevel=10;arg.maxgradelevel=12;arg.credittypelist=basic,lda,elec)

  ^(*powerquery;query=com.powerschool.th.report.dat.credithrsbymultiplegradelevels;fields=passedcredits;arg.storecode=Y1;arg.mingradelevel=10;arg.maxgradelevel=12;arg.credittypelist=basic,lda,elec)

• Screen: Historical Grades, Grade scale

Description: This DAT calculates the total credits a student has enrolled in and passed across multiple grade levels. It supports retrieval for:

• Core Courses (basic)

• Selective Courses (lda, elec)

• Both Core and Selective Courses combined (basic, lda, elec)

Instead of retrieving credits grade-by-grade, this DAT summarizes the totals across a range of grade levels using the arguments mingradelevel and maxgradelevel.

It pulls data from the following tables:

• storedgrades — earned credit hours, grade levels, store codes

• courses — credit hours, credit type

• students — student identification

DAT Arguments:

• arg.storecode:
  Specifies the store code used for selecting historical grades.
  Example: storecode=Y1

• arg.mingradelevel
  Lower boundary of the grade level range.
  Example: mingradelevel=10

• arg.maxgradelevel
  Upper boundary of the grade level range.
  Example: maxgradelevel=12

• arg.credittypelist
  Filters the credits by credit type.
  Can be: basic for Core, lda, elec for Selective, or basic, lda, elec for both

The DAT returns the following field:

enrolledcredits

Total number of credits attempted (enrolled) in the selected grade level range and credit type(s)

passedcredits

Total number of credits successfully earned (passed) in the selected grade level range and credit type(s)

23. สรุปผล - เกรดเฉลี่ย(GPA)

• Old Name: page2_gpacolonlabel

• Object Name: page2 gpa

• PowerQuery :

  CODE

  : ~(*powerquery;query=com.powerschool.th.report.dat.totalcreditweightedavg;arg.storecode=Y1;arg.mingradelevel=10;arg.maxgradelevel=12;arg.credittypelist=basic;fields=avg_weighted_credit)

• Screen: Course info, Historical Grades

Description: This DAT is used to display theAverage Weighted GPA for the student across the specified grade range (Grades 10 to 12).
This calculation considers only the courses that fall within the given store code, grade boundaries, and optional credit type filters (core, selective, or basic).
Weighted GPA is computed based on the GPA points earned for each course, with weighting applied depending on the course level or type.

DAT Arguments:

• arg.storecode:
  Specifies the store code used for selecting historical grades.
  Example: storecode=Y1

• arg.mingradelevel
  Lower boundary of the grade level range.
  Example: mingradelevel=10

• arg.maxgradelevel
  Upper boundary of the grade level range.
  Example: maxgradelevel=12

• arg.credittypelist
  Filters the credits by credit type.
  Can be: basic for Core, lda, elec for Selective, or basic, lda, elec for both

24. สรุปผล- ผลลัพธ์เพิ่มเติมของนักเรียน(Student Additional Results)

• Old Name: page-2_summaryresultlabel

• Object Name: page-2 Additional Result

• PowerQueries Used :

  1. ผลของทักษะการอ่าน การคิดวิเคราะห์ และการเขียน(Result of Reading, Analytical Thinking and Writing Skills)
     ~(*powerquery;query=com.powerschool.th.report.dat.overallgradegroupbymultiplegradelevels;arg.storecode=Y1;arg.mingradelevel=10;arg.maxgradelevel=12;arg.excludedcreditlist=el,ec;arg.credittypelist=elec;fields=result)
     Screen: Historical Grades, Grade Scale

  2. ผลลัพธ์ของลักษณะที่ต้องการ(Result of Desired Characteristics)
     ~(*powerquery;query=com.powerschool.th.report.dat.overallgradegroupbymultiplegradelevels;arg.storecode=Y1;arg.mingradelevel=10;arg.maxgradelevel=12;arg.excludedcreditlist=el,ec;arg.credittypelist=elec;fields=result)
     Screen: Historical Grades, Grade Scale

  3. ผลของกิจกรรมพัฒนาผู้เรียน(Result of Learner Development Activities)
     ~(*powerquery;query=com.powerschool.th.report.dat.overallgradegroupbymultiplegradelevels;arg.storecode=Y1;arg.mingradelevel=10;arg.maxgradelevel=12;arg.excludedcreditlist=el,ec;arg.credittypelist=lda;fields=result)
     Screen: Historical Grades, Grade Scale

  4. บริการชุมชน(Community Service Hours)
     ^(*powerquery;query=com.powerschool.th.report.dat.credithrsbymultiplegradelevels;fields=passedhours;arg.storecode=Y1;arg.mingradelevel=10;arg.maxgradelevel=12;arg.coursenumberlist=ASTRO1234)
     Screen: Historical Grades, Grade Scale

  5. วันที่สําเร็จการศึกษา(Date of Graduation)
     ~(*powerquery;query=com.powerschool.th.report.dat.thaidateformat;arg.gregoriandate=~(*powerquery;query=com.powerschool.th.report.dat.graduationdetails;arg.gradelevel=12;arg.dateformat=DD-MON-YYYY;fields=graduationdate);fields=thaidate;)
     Screen: Graduation Detail

  6. วันที่ออกเดินทาง(Date of Leaving)
     ~(*powerquery;query=com.powerschool.th.report.dat.thaidateformat;arg.gregoriandate=~(*powerquery;query=com.powerschool.th.report.dat.reenrollmentdetails;arg.gradelevel=12;fields=exitdate);fields=thaidate)
     Screen: Re-enrollment

Description: This object displays a set of student academic and co-curricular results collected from multiple PowerQueries that evaluate performance across grade levels.

Result of Reading, Analytical Thinking and Writing Skills / Desired Characteristics / Learner Development Activities

These fields display the overall result score for the selected category by aggregating course performance from Grades 10 to 12.
The query filters values based on the given storecode, includes only the specified credittypelist (such as elec or lda), and excludes credit types listed in excludedcreditlist (el, ec).
Only the final result value is returned.

arg.storecode = Y1 – Uses Year 1 final grades.

arg.mingradelevel = 10 / arg.maxgradelevel = 12 – Filters data from Grades 10–12.

arg.credittypelist = elec / lda – Limits the category being evaluated.

arg.excludedcreditlist = el, ec – Removes specified credit types from the calculation.

fields = result – Returns only the aggregated category result.

Community Service Hours

This DAT is used to display thetotal passed community service hours completed by the student within Grades 10 to 12, based on a specific course number list.

arg.storecode = Y1 – Uses Year 1 final grades.

arg.mingradelevel = 10 / arg.maxgradelevel = 12 – Filters data from Grades 10–12.

arg.coursenumberlist = ASTRO1234 – Filters only community service courses.

fields = passedhours
Date of Graduation

This DAT is used to display thestudent’s graduation date for Grade 12 in the format MONTH DD YYYY.

arg.gradelevel: Required argument indicating the grade level of the students. Example: gradelevel=10 (This sets the grade level to 10)

arg.dateformat: Required argument indicating the date format. Example: arg.dateformat=DD-MM-YYYY (This sets the date formate to DD-MM-YYYY)

arg.dateformat: This argument specifies which Gregorian date you want to convert into Thai format.
Date of Leaving

arg.gradelevel: Required argument indicating the grade level of the students. Example: gradelevel=10 (This sets the grade level to 10)

arg.dateformat: Required argument indicating the date format. Example: arg.dateformat=DD-MM-YYYY (This sets the date formate to DD-MM-YYYY)

arg.dateformat: This argument specifies which Gregorian date you want to convert into Thai format.

24. นายทะเบียน(Registrar)

• Old Name: page2_registrar_labelpart

• Object Name: page2 registrar

• PowerQuery: (~([39]Registrar_name))
  นายทะเบียน
  ~(*powerquery;query=com.powerschool.th.report.dat.thaidateformat;fields=thaidate;arg.gregoriandate=^(f.currentdate;dateformat=DD-MM-YYYY))

• Screen: School info

Description: This DAT is used to display the registrar’s name of the school.

• ^(f.currentdate;dateformat=DD-MM-YYYY) is used to print the current date in the format DD-MM-YYYY

• arg.dateformat: This argument specifies which Gregorian date you want to convert into Thai format.

25. Director

• Old Name: page2_director_labelpart

• Object Name: page2 director

• PowerQuery: (~([39]Principal))
  ผู้จัดการ
  ~(*powerquery;query=com.powerschool.th.report.dat.thaidateformat;fields=thaidate;arg.gregoriandate=^(f.currentdate;dateformat=DD-MM-YYYY))

• Screen: School info

Description: This DAT is used to display the principal name of the school.

• ^(f.currentdate;dateformat=DD-MM-YYYY) is used to print the current date in the format DD-MM-YYYY

• arg.dateformat: This argument specifies which Gregorian date you want to convert into Thai format.