Transcripts and Credits

twilya
New Member

Transcripts and Credits

Is there a way to run a report that will show the total number of credits each students has by cohort year?

6 Replies
ParitoshT
Community Support Expert
Community Support Expert

Re: Transcripts and Credits

Hi @twilya,

 

Thank you for posting in the Community.

 

There is not an option built-in PowerSchool SIS to pull the credit hours by cohort year but the following solution might help you.

 

You can use the DAT code ^(*credit_hours to pull the credit hours earned by a student.

 

Format: ^(*credit_hours;[parameters])

 

You can give term, year, grade level, or credit type as a parameter.

 

Please let us know if this helps you.

 

Paritosh Tyagi
PowerSchool Community Moderator

 

Remember to give Kudos to suggestions that help you!
If another user helps solve your issue, please select Accept As Solution on their post so others can see the solution, too!

WilliamB14
Rookie

Re: Transcripts and Credits

@ParitoshT Can you please explain this part a little more: Format: ^(*credit_hours;[parameters])

 

I am trying to export a list of students and earned credit hours with each column by the type of credit earned.  I can get a list of the total credit hours but can't figure out how to get a list of the total credits by type Eng, SS, Math, Sci....

Reshma
Community Support Expert
Community Support Expert

Re: Transcripts and Credits

Hi @WilliamB14,

 

The credit_hours DAT returns cumulative, historical, earned credit hours earned by the student.  The source of data for this DAT is [StoredGrades]EarnedCrHrs. Historical Grades (StoredGrades) requires both Potential Credit Hours and Earned Credit Hours for the ^(*credit_hours) to pull the source data EarnedCrHrs.

 

I recommend searchig for the documentation on 'Cumulative Credit Hours DAT ^(*credit_hours)' within the Community to find more details on this.



Reshma
PowerSchool Community Support Expert

Remember to give Kudos to suggestions that help you!
If another user helps solve your issue, please select Accept As Solution on their post so others can see the solution, too!
dulceperez29
Practitioner

Re: Transcripts and Credits

Hi @twilya !

 

I have created this formula for our transcripts. Is this what you are looking for?

 

dulceperez29_0-1609885104476.png

 

----
Dulce Perez


Remember to give Kudos to suggestions that help you! If a suggestion solves your issue, please select Accept As Solution on the post so others can see the solution, too!
WilliamB14
Rookie

Re: Transcripts and Credits

@dulceperez29 This is exactly the kind of thing I am trying to produce except I am using it to send "on track/not on track for graduation" letters.  What DAT are you using to pull the earned credits number?

JulieN5
Padawan

Re: Transcripts and Credits

@dulceperez29 

 

I am trying to create something similar to that to display on a form that I am building. Can you share the DAT tags or SQL that you used to create that?

 

Thanks!

Julie