PSCB - Custom Reports (Student Data Verification)

Description

The bundle includes five Student Data Verification reports.

    Demographics
    Enrollment Data
    Ethnicity / Federal Race Categories
    Field Data Verification / Count
    Physical / Mailing Address

IMPORTANT NOTE

- The Field Data Verification / Count report requires prior completion of the Custom Fields Migration process.
- Users are responsible for establishing security permissions to control individual or group access to the reports.

Acknowledgements

PSCB Development Team
Rob Staats
Manjit Basra
Michael Moore

Version Info
1.0 (2018-09-16)
- Initial Release

1.1 (2019-04-03)
- Added Student - Field Data Verification report.

1.2 (2019-04-10)
- Added Student Selection Filter Options to the Student - Field Data Verification report.
Active & Inactive, Active Only, Inactive Only, Pre Registered and Current Selection.

1.3 (2019-05-16)
- The update includes one new report: Student - Contacts Verification with the following data elements

1.4 (2019-08-31)
- The Students - Contacts report has been moved to the PSCB - Custom Reports (Public Portal) v2.0 bundle. This plugin is scheduled for release in mid-September.
- Added additional column filter menu options to all reports.
- Added Field Count Summary option to the Field Data Verification / Count report.
- The Field Data Verification / Count report honors Field Level Security settings.
- A ~[cust.insertion_point:pscb.studentdataverify] was added to the Student Data Verification Reports menu (PSCB_studentdataverify.html). This provides users with a method to add links for their own custom grading reports to the Student Data Verification Menu.

1.5 (2019-09-10)
Added Student Email to the Email / Physical / Mailing Address report.

Powerschool Compatible Versions
12.x,19.x

Additional Plugin Requirements

The following PSCB plugins should be installed prior to the installation of this reports bundle.

PSCB - Base Resources
PSCB - Custom Reports (_Home Page)

Installation

Install in System > System Settings > Plugin Management Configuration
Do not unzip the plugin. Install the entire zip file. Be sure to enable the plugin once it's installed.

If you are updating, you can now click on the Plugin name and then use the Update button, and then browse to the new file and click Submit and it will then load the update and then ask you to enable it.

Instructions

Select a school and go to the Powerschool start page.
Click on the PSCB Custom Reports link on the left navigation menu.
Click on the Student Data Verification link to access the Student Data Verification Reports menu.

PS Verions

11.x: 
N
12.x: 
Y
19.4: 
Y
Plugin: 
Y
CPM Import Friendly: 
Y

Comments

i have installed this update on 19.4. when running many of the reports even though i select current selection, 358, i only get 19 records, when i select active, i only get 24 records. something isn't working right...

Jason Pfahl
Director of Technology
Clinton Central School Corp
INdiana

Please send me a specific list of some of the reports that are not working properly for you.

Thanks - Rob Staats

--
Rob Staats
PSCB Development

Could you make Email Only one of the options in the drop-down, please?

Peggy Medema

Thanks for your suggestion. A Email Only option will be added to the report in the next release of the PSCB - Custom Reports (Student Data Verification) plugin.

--
Rob Staats
PSCB Development

Thank you!

I only have 4 reports in this plugin after installation. I'm missing the Field Data Verification report. Do I need to do something else to make this report appear for use?

Also, I was wondering if these would ever be similar to the functionality of the old Custom Reports Field Data Verification report that would let us make changes to update different fields right there on the report itself. I relied on that old report a lot and have just been instructed to remove it because it might cause performance issues.

Thanks, Debbie Cabe

The Field Data Verification report is school based only. You will not see the menu link if you are at the District level.

The report results are view only. The PSCB will not be developing a field data modification version of the report.

--
Rob Staats
PSCB Development

Hi,
I am trying to build a SQL report with student email added to course information. I am struggling getting it to run. Here is the code, can anyone help me get it to work? Thank you!

SELECT
STUDENTS.LASTFIRST, STUDENTS.STUDENT_NUMBER, PSM_STUDENTCONTACT.EMAIL, COURSES.COURSE_NAME, TEACHERS.LASTFIRST, SECTIONS.EXPRESSION, SECTIONS.SECTION_NUMBER

FROM ((CC INNER JOIN SECTIONS ON CC.SECTIONID = SECTIONS.ID) INNER JOIN COURSES ON SECTIONS.COURSE_NUMBER = COURSES.COURSE_NUMBER) INNER JOIN TEACHERS ON (SECTIONS.TEACHER = TEACHERS.ID) INNER JOIN PGFINALGRADES ON (CC.STUDENTID = PGFINALGRADES.STUDENTID) AND (CC.SECTIONID = PGFINALGRADES.SECTIONID) INNER JOIN STUDENTS ON (CC.STUDENTID = STUDENTS.ID) INNER JOIN PSM_STUDENTCONTACT ON (CC.STUDENTID = PSM_STUDENTCONTACT.STUDENTID) INNER JOIN SYNC_STUDENTMAP ON (PSM_STUDENTCONTACT.STUDENTID = SYNC_STUDENTMAP.STUDENTID) INNER JOIN PSM_STUDENTCONTACTTYPE ON (PSM_STUDENTCONTACT.STUDENTCONTACTTYPEID = PSM_STUDENTCONTACTTYPE.ID) AND LEFT OUTER JOIN SECTIONREADINESS ON (PGFINALGRADES.SECTIONID = SECTIONREADINESS.SECTIONDCID)

Alison Blazey
ablazey@ehtp.org
Data and Systems Manager
KIPP NYC College Prep

Subscribe to Comments for "PSCB - Custom Reports (Student Data Verification)"