topic Re: Object Report School Years in Community Forum

Object Report School Years

ansmith743 — Wed, 07 Dec 2022 16:31:18 GMT

Hello!

I am using Object Reports to build a Verification of Enrollment form. They want me to place the current year and any previous years that the student has been enrolled in the district. I am not sure how to go about this. I tried making a Powerquery using the CC.Dateenrolled and CC.Dateexit fields, but I am unsure of how to make it work. I keep getting the same error message for insufficient permissions for the powerquery. Does anyone know how I can place all enrollment years on a form?

Re: Object Report School Years

ItsOnlyDoug — Thu, 08 Dec 2022 14:52:13 GMT

The CC table shows what course sections a student is enrolled in...I think you want the ReEnrollments table.

Re: Object Report School Years

HeatherWeist — Thu, 08 Dec 2022 16:03:30 GMT

@ansmith743 A student's current enrollment is in the Student's table and all previous enrollment data is in the Reenrollment table. I'm thinking you might be able to pull entry date and exit date from both tables, and use decoding of data to change it to school years.

Re: Object Report School Years

ansmith743 — Thu, 08 Dec 2022 17:37:00 GMT

So when I place the Reenrollments in the object report, like so: ^([Reenrollments]Entrydate), it returns 0/0/0. How would I make it so it returns all of the previous years?

Re: Object Report School Years

ansmith743 — Thu, 08 Dec 2022 17:40:06 GMT

So when I pull the current year from the students table it works just fine. But, when I try to pull from CC or Reenrollments it does not work. This is what it returns: 0/0/0. My thought was that it has to do with that it is returning multiple rows, maybe. Or, it is not connecting to the student id.

Re: Object Report School Years

JyotishkaB — Tue, 13 Dec 2022 21:02:20 GMT

Hi @ansmith743

The previous enrollment information is stored in the Reenrollment table which is not accessible using object report/transcript. So, there is no built-in DAT code to pull Previous Enrollment dates on the Transcript.

You can, however, use DDE to pull these records which are not available to object reports.

Re: Object Report School Years

ansmith743 — Thu, 15 Dec 2022 17:27:28 GMT

Sorry, I am a fairly new to PowerSchool, but I was under the impression that you can build your own DAT codes with a PowerQuery. Also, how would I place the DDE within the object Report?

Re: Object Report School Years

JeffG9 — Thu, 15 Dec 2022 17:33:46 GMT

You can indeed build your own DAT codes with a PowerQuery Plugin:

https://docs.powerschool.com/PSHSA/22.12/page-and-data-management/data-access-tags/powerquery-dats

DDE is Direct Database Export. You cannot place it on an object report; it is an area of PowerSchool that allows you to export data directly.