PowerSchool TechNote:

PowerSchool: Quick Export Codes


The following Quick Export Codes can be used in the Quick Export screen in PowerSchool (copy & paste in the blue text shown below).


Basic Student Data Export (works best when run at the school level):

[students]student_number
[students]State_StudentNumber
[schools]abbreviation
[students]last_name
[students]first_name
[students]middle_name
[students]DOB
[students]Mailing_Street
[students]Mailing_City
[students]Mailing_State
[students]Mailing_Zip
[students]mother
[students]father
[students]grade_level

 

Advanced Student Data Export with decoded School Name & District of Residence (works only when run at the district level):

[students]student_number
[students]State_StudentNumber
[students]Enrollment_SchoolID
^(decode;^(schoolid);25;AAHS;28;BTHS;4;CHS;10;HTHS;20;MAST;3;CLASS;5;KIVA;40;C.C.;1050;Aberdeen;1052;CEC;1053;CHS-ST;1054;Freehold;1055;Hazlet;1056;Keyport;1051;LB;1057;Mtown;1058;AnnexST;1059;AppAcad;888;Archive;999;TA;999999;GraduatedStudents; )
[students]last_name
[students]first_name
[students]middle_name
[students]DOB
[students]Mailing_Street
[students]Mailing_City
[students]Mailing_State
[students]Mailing_Zip
[students]mother
[students]father
[students]grade_level
^(f.table_info;table=gen;*cat=districts;fn=value;field=name;condfield1=value;condfieldtype1=text;comparator1=.eq.;condval1=^(districtofresidence);delim=)

 

If there are any questions, please contact the Tech Group.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Need help from the Tech Group? Use the Online
MCVSD "Information Technology Help Request" form
https://www.mcvsd.org/techhelp/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

Back to the MCVSD Tech Tips site