Mexico Localization - Power Query DATs
DAT Access Tag | Description | Portal Page | Optional Parameters | Available | Version |
|---|---|---|---|---|---|
~(*powerquery;query=com.powerschool.dat.reports.students.nameinfo;fields=firstname) | This DAT is used to display the student's first name 2. | Student demographics | Object Report | 25.5.0 | |
~(*powerquery;query=com.powerschool.dat.reports.students.nameinfo;fields=middlename) | This DAT is used to display the student's first name 2. | Student demographics | Object Report | 25.5.0 | |
~(*powerquery;query=com.powerschool.dat.reports.students.nameinfo;fields=lastname) | This DAT is used to display the student's paternal name. | Student demographics | Object Report | 25.5.0 | |
~(*powerquery;query=com.powerschool.dat.reports.students.nameinfo;fields=thirdname) | This DAT is used to display the student's maternal name. | Student demographics | Object Report | 25.5.0 | |
~(*powerquery;query=com.powerschool.dat.reports.students.nameinfo;fields=fullname) | This DAT is used to display the student's full name. (first name, first name 2, paternal name, maternal name). | Student demographics | Object Report | 25.5.0 | |
~(*powerquery;query=com.powerschool.dat.reports.students.guardianinfo;fields=firstname;contacttype=Mother) | This DAT is used to display the first name 1 of the parent. | Student demographics |
Specify the contact type to be obtained. eg: arg.contacttype=father | Object Report | 25.5.0 |
~(*powerquery;query=com.powerschool.dat.reports.students.guardianinfo;fields=middlename;contacttype=Mother) | This DAT is used to display the first name 2 of the parent. | Student demographics |
Specify the contact type to be obtained. eg: arg.contacttype=father | Object Report | 25.5.0 |
~(*powerquery;query=com.powerschool.dat.reports.students.guardianinfo;fields=lastname;contacttype=Mother) | This DAT is used to display the Paternal Name of the parent. | Student demographics |
Specify the contact type to be obtained. eg: arg.contacttype=father | Object Report | 25.5.0 |
~(*powerquery;query=com.powerschool.dat.reports.students.guardianinfo;fields=thirdname;contacttype=Mother) | This DAT is used to display the Maternal Name of the parent. | Student demographics |
Specify the contact type to be obtained. eg: arg.contacttype=father | Object Report | 25.5.0 |
~(*powerquery;query=com.powerschool.dat.reports.students.guardianinfo;fields=fullname;contacttype=Mother) | This DAT is used to display the full name (first name, first name 2, paternal name, maternal name) of the parent. | Student demographics |
Specify the contact type to be obtained. eg: arg.contacttype=father | Object Report | 25.5.0 |
~(*powerquery;query=com.powerschool.dat.reports.students.guardianinfo;fields=phonenumber;contacttype=Mother) | This DAT is used to display the phone number of the parent. | Student demographics |
Specify the contact type to be obtained. eg: arg.contacttype=father | Object Report | 25.5.0 |
~(*powerquery;query=com.powerschool.dat.reports.students.addressinfo;fields=building) | This DAT is used to display the building number of the student. | Student demographics |
Specify the address type to retrieve. eg: arg.type=mailing | Object Report | 25.5.0 |
~(*powerquery;query=com.powerschool.dat.reports.students.addressinfo;fields=street) | This DAT is used to display the street name of the student. | Student demographics |
Specify the address type to retrieve. eg: arg.type=mailing | Object Report | 25.5.0 |
~(*powerquery;query=com.powerschool.dat.reports.students.addressinfo;fields=unit) | This DAT is used to display the unit number of the student. | Student demographics |
Specify the address type to retrieve. eg: arg.type=mailing | Object Report | 25.5.0 |
~(*powerquery;query=com.powerschool.dat.reports.students.addressinfo;fields=neighborhood) | This DAT is used to display the neighborhood of the student. | Student demographics |
Specify the address type to retrieve. eg: arg.type=mailing | Object Report | 25.5.0 |
~(*powerquery;query=com.powerschool.dat.reports.students.addressinfo;fields=municipality) | This DAT is used to display the municipality of the student. | Student demographics |
Specify the address type to retrieve. eg: arg.type=mailing | Object Report | 25.5.0 |
~(*powerquery;query=com.powerschool.dat.reports.students.addressinfo;fields=city) | This DAT is used to display the city of the student. | Student demographics |
Specify the address type to retrieve. eg: arg.type=mailing | Object Report | 25.5.0 |
~(*powerquery;query=com.powerschool.dat.reports.students.addressinfo;fields=provience) | This DAT is used to display the state of the student. | Student demographics |
Specify the address type to retrieve. eg: arg.type=mailing | Object Report | 25.5.0 |
~(*powerquery;query=com.powerschool.dat.reports.students.addressinfo;fields=zip) | This DAT is used to display the postal code of the student. | Student demographics |
Specify the address type to retrieve. eg: arg.type=mailing | Object Report | 25.5.0 |
~(*powerquery;query=com.powerschool.dat.reports.students.addressinfo;fields=country) | This DAT is used to display the country of the student. | Student demographics |
Specify the address type to retrieve. eg: arg.type=mailing | Object Report | 25.5.0 |
~(*powerquery;query=com.powerschool.dat.reports.students.addressinfo;fields=address_line1) | This DAT is used to display the building number, street name and unit number of the student together. | Student demographics |
Specify the address type to retrieve. eg: arg.type=mailing | Object Report | 25.5.0 |
~(*powerquery;query=com.powerschool.dat.reports.students.addressinfo;fields=address_line2) | This DAT is used to display the neighborhood, municipality and city of the student together. | Student demographics |
Specify the address type to retrieve. eg: arg.type=mailing | Object Report | 25.5.0 |
~(*powerquery;query=com.powerschool.dat.reports.students.addressinfo;fields=address_line3) | This DAT is used to display the postal code, country and state of the student together. | Student demographics |
Specify the address type to retrieve. eg: arg.type=mailing | Object Report | 25.5.0 |
~(*powerquery;query=com.powerschool.dat.reports.students.otherinfo;fields=placeofbirth) | This DAT is used to display the place of birth of the student. | Student demographics | Object Report | 25.5.0 | |
~(*powerquery;query=com.powerschool.dat.reports.students.otherinfo;fields=countryoforigin) | This DAT is used to display the country of birth of the student. | Student demographics | Object Report | 25.5.0 | |
~(*powerquery;query=com.powerschool.dat.reports.students.otherinfo;fields=state_studentnumber) | This DAT is used to display the National ID of the student. | Student demographics | Object Report | 25.5.0 | |
~(*powerquery;query=com.powerschool.dat.reports.students.otherinfo;fields=nationalitydisplayvalue) | This DAT is used to display the Nationality of the student. | Student demographics | Object Report | 25.5.0 | |
~(*powerquery;query=com.powerschool.dat.reports.students.otherinfo;fields=foreignid) | This DAT is used to display the Foreign ID of the student. | Student demographics | Object Report | 25.5.0 | |
~(*powerquery;query=com.powerschool.dat.reports.schools.addressinfo;fields=building) | This DAT is used to display the building number of the school. | School info | Object Report | 25.5.0 | |
~(*powerquery;query=com.powerschool.dat.reports.schools.addressinfo;fields=schooladdress) | This DAT is used to display the street of the school. | School info | Object Report | 25.5.0 | |
~(*powerquery;query=com.powerschool.dat.reports.schools.addressinfo;fields=unit) | This DAT is used to display the unit number number of the school. | School info | Object Report | 25.5.0 | |
~(*powerquery;query=com.powerschool.dat.reports.schools.addressinfo;fields=countynbr) | This DAT is used to display the neighborhood of the school. | School info | Object Report | 25.5.0 | |
~(*powerquery;query=com.powerschool.dat.reports.schools.addressinfo;fields=countyname) | This DAT is used to display the municipality of the school. | School info | Object Report | 25.5.0 | |
~(*powerquery;query=com.powerschool.dat.reports.schools.addressinfo;fields=schoolcity) | This DAT is used to display the city of the school. | School info | Object Report | 25.5.0 | |
~(*powerquery;query=com.powerschool.dat.reports.schools.addressinfo;fields=schoolzip) | This DAT is used to display the postal code of the school. | School info | Object Report | 25.5.0 | |
~(*powerquery;query=com.powerschool.dat.reports.schools.addressinfo;fields=countrydisplayvalue) | This DAT is used to display the Country of the school. | School info | Object Report | 25.5.0 | |
~(*powerquery;query=com.powerschool.dat.reports.schools.addressinfo;fields=statedisplayvalue) | This DAT is used to display the State of the school. | School info | Object Report | 25.5.0 | |
~(*powerquery;query=com.powerschool.common.dat.emergency;arg.rowno=1;fields=contactname) | This DAT is used to display the name of the first emergency contact of the student. |
|
Specify the number of the emergency contact. eg: arg.rowno=2 | Object Report | 25.5.0 |
~(*powerquery;query=com.powerschool.common.dat.emergency;arg.rowno=1;fields=phonenumber) | This DAT is used to display the phone number of the first emergency contact of the student. |
|
Specify the number of the emergency contact. eg: arg.rowno=2 | Object Report | 25.5.0 |
~(*powerquery;query=com.powerschool.common.dat.emergency;arg.rowno=1;fields=contactrelationshipdesc) | This DAT is used to display the relationship of the first emergency contact of the student. |
|
Specify the number of the emergency contact. eg: arg.rowno=2 | Object Report | 25.5.0 |