PowerSchool SIS - Administrator
PowerSchool SIS - Administrator
Breadcrumbs

Thai Localization - Power Query DATs

DATAccess Tag

Description

Portal Page

Optional Parameters

Available

Version

 

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

We are using this DAT to display the student's full name in Thai.

  • Student Demographics

 

Object Report

24.7.0

 

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

We are using this DAT to display Student’s Full Name in English

  • Student Demographics

 

Object Report

24.7.0

 

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

We use this DAT to show the full name of the student's mother in Thai.

  • Student Demographics

 

Object Report

24.7.0

 

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

We use this DAT to display the full name of the student's mother in English.

  • Student Demographics

 

Object Report

24.7.0

 

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

We use this DAT to show the full name of the student's father in Thai.

  • Student Demographics

 

Object Report

24.7.0

 

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

We are using this DAT to display the full name of the student's father in English.

  • Student Demographics

 

Object Report

24.7.0

 

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

We are using this DAT to display the student's mailing address line 1 (house number, village/building, Moo).

  • Student Demographics

 

Object Report

24.7.0

 

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

We are using this DAT to display the student's mailing address, including Address Line 2 Alleyway, Soi, Road).

  • Student Demographics

 

Object Report

24.7.0

 

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

We are using this DAT 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

24.7.0

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

we are using this DAT to display Student Home Address Line1(House no,Village/Building,Moo)

  • Student Demographics

 

Object Report

24.7.0

 

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

We are using this DAT to display the student's home address line 2 (alleyway, soi, road).

  • Student Demographics

 

Object Report

24.7.0

 

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

We are using this DAT 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)

We are using this DAT to display the student's home house number.

  • Student Demographics

 

Object Report

24.7.0

 

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

We are using this DAT 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)

We are using this DAT to display Student’s Home Moo

  • Student Demographics

 

Object Report

24.7.0

 

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

We are using this DAT to display Student’s Home street

  • Student Demographics

 

Object Report

24.7.0

 

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

We are using this DAT to display the student's home road

  • Student Demographics

 

Object Report

24.7.0

 

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

We are using this DAT to display the student's home alleyway.

  • Student Demographics

 

Object Report

24.7.0

 

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

We are using this DAT to display the student's full home address.

  • Student Demographics

 

Object Report

24.7.0

 

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

We are using this DAT 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)

We are using this DAT 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)

We are using this DAT 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)

We are using this DAT 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)

We are using this DAT to display the student's mailing house number

  • Student Demographics

 

Object Report

24.7.0

 

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

We are using this DAT to display the student's mailing village/building.

  • Student Demographics

 

Object Report

24.7.0

 

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

We are using this DAT to display the student's mailing moo

  • Student Demographics

 

Object Report

24.7.0

 

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

We are using this DAT to display the student's mailing street.

  • Student Demographics

 

Object Report

24.7.0

 

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

We are using this DAT to display the student's mailing road.

  • Student Demographics

 

Object Report

24.7.0

 

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

We are using this DAT to display the student's mailing alleyway.

  • Student Demographics

 

Object Report

24.7.0

 

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

We are using this DAT to display the student's full mailing address

  • Student Demographics

 

Object Report

24.7.0

 

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

We are using this DAT 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)

We are using this DAT 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)

We are using this DAT 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)

We are using this DAT 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)

We are using this DAT 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)

We are using this DAT 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)

We are using this DAT 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)

We are using this DAT 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)

We are using this DAT to display the type of phone number for the student's emergency contact.

  • Student Demographics

  • student ->health->Emergency and Medical Contacts

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)

We are using this DAT 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)

We are using this DAT 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)

We are using this DAT 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)

We are using this DAT 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)

We are using this DAT 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)

We are using this DAT to display the student's emergency contact relationship.

  • Student Demographics

  • student ->health->Emergency and Medical Contacts

  • arg.rowno

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

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

  • arg.locale

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

Object Report

24.10.0.0