PS

 

How to access your childs grade and attendance data  

ParentPortal.pdf PDF Document

 

 

Discipline entry into Power School.pdfPDF Document

List of PS reports.pdfPDF Document

Dropping Student During the Summer.pdf PDF Document

Transfers - previous enrolled & in district.pdf PDF Document

quick import/export how-toPDF Document

Importing ACT scores into PowerSchoolPDF Document

 

Some PowerSchool SQL queries

Provided "as is where is" use at your own risk.

ATTENDANCE

SELECT s.lastfirst,
SUM(CASE attc.Att_Code WHEN 'UA' THEN 1 ELSE 0 END) AS UA,
SUM(CASE attc.Att_Code WHEN 'T' THEN 1 ELSE 0 END) AS T,
SUM(CASE attc.Att_Code WHEN 'TU' THEN 1 ELSE 0 END) AS TU,
SUM(CASE attc.Att_Code WHEN 'TE' THEN 1 ELSE 0 END) AS TE,
SUM(CASE attc.Att_Code WHEN 'E' THEN 1 ELSE 0 END) AS E,
SUM(CASE attc.Att_Code WHEN 'SF' THEN 1 ELSE 0 END) AS SF,
SUM(CASE attc.Att_Code WHEN 'ISS' THEN 1 ELSE 0 END) AS ISS,
SUM(CASE attc.Att_Code WHEN 'LB' THEN 1 ELSE 0 END) AS LB,
SUM(CASE attc.Att_Code WHEN 'PO' THEN 1 ELSE 0 END) AS PO,
SUM(CASE attc.Att_Code WHEN 'GO' THEN 1 ELSE 0 END) AS GO,
SUM(CASE attc.Att_Code WHEN 'AP' THEN 1 ELSE 0 END) AS AP,
SUM(CASE attc.Att_Code WHEN 'IJ' THEN 1 ELSE 0 END) AS IJ,
SUM(CASE attc.Att_Code WHEN 'CO' THEN 1 ELSE 0 END) AS CO,
SUM(CASE attc.Att_Code WHEN 'HO' THEN 1 ELSE 0 END) AS HO,
SUM(CASE attc.Att_Code WHEN 'VA' THEN 1 ELSE 0 END) AS VA,
SUM(CASE attc.Att_Code WHEN 'SRC' THEN 1 ELSE 0 END) AS SRC
FROM Attendance att
INNER JOIN Attendance_Code attc ON att.Attendance_CodeID = attc.ID
INNER JOIN students s ON att.StudentID = s.id
WHERE att.Att_Mode_Code = 'ATT_ModeMeeting'
  AND att.Att_Date >= '03-SEP-2013'
  AND att.Att_Date <= '05-AUG-2014'
  AND s.schoolid=5801
  AND s.grade_level=6
GROUP BY s.lastfirst ORDER BY s.lastfirst;

 PS-AttendanceSQL1

 

 

 GRADECAM EXPORT

select distinct
cc.termid as "Termid",
te.last_name as "TeacherLast",
te.first_name as "TeacherFirst",
te.email_addr as "TeacherEmail",
co.course_name as "CourseName",
cc.sectionid as "CourseID",
st.LAST_NAME as "StudentLast",
st.FIRST_NAME as "StudentFirst",
st.ID as"StudentID",
sm.period_number as "PeriodID"
from cc
join students st on cc.studentid = st.id
join sections s on cc.sectionid = s.id
join section_meeting sm on cc.sectionid = sm.id
join terms t on s.termid = t.id
join teachers te on s.teacher = te.id
join courses co on cc.course_number = co.course_number
where t.yearid = 24
and st.schoolid=05801
and st.enroll_status = 0
and te.email_addr is not null
and te.last_name != 'Target Studies'

 PS-GradecamSQL1

 

Police Involved Report

 Select st.lastfirst,
st.ID,
st.grade_level,
st.gender,
st.ethnicity,
log.schoolid,
log.entry_author,
log.entry_date,
log.entry,log.subject,
log.discipline_policeinvolvedflag
FROM log
Join Students st
on (st.id=log.studentid)
where log.entry_date>= '01-SEP-2013' and log.entry_date<= '20-JUN-2014'
and log.discipline_policeinvolvedflag=1
order by st.grade_level, st.lastfirst, log.entry_date

 PolicePowerSchool

 

 STUDENTS WITH NO DICIPLINE LOG ENTRIES

select s.lastfirst, s.grade_level
from students s
where s.id not in (select studentid from log
                   where logtypeid = '-100000')
                  
and enroll_status = 0
AND s.SCHOOLID = 5801
ORDER BY s.grade_level, s.lastfirst

 SQL-RealgoodKids

 

 

 

 Query for web portal logins

 ----------------------------------------------------------------------------------

Select DISTINCT st.lastfirst, st.home_room, studentid, st.grade_level, 
(case 
when usertype = 100 then DECODE ( usertype,100 , st.mother)
when usertype = 110 then DECODE ( usertype,110 , to_char(studentid)) else st.first_name end) ParentOrStudent
from logins
Join Students st
on (st.id=logins.studentid)
where usertype >= 100
and st.enroll_status = 0
and st.schoolid = 5801
and logindate>= '01-SEP-2015'
ORDER BY st.grade_level, st.home_room, st.lastfirst
-------------------------------------------------------------------------------------
 
web_portal_logins
 
if a parent logged in, I print the mothers name, if a student logs in I print the studentID...."else st.first_name" should rarely (if ever) be "true" (if it shows up...you might have to add in a 
where usertype >= 100 AND usertype < 111 )