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?

13 Replies
ParitoshT
Community Support Expert
Community Support Expert

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
Journeyman

@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

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

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
Journeyman

@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
Journeyman

@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 

alaskamya
Journeyman

Hi, i was reading this thread and this is exactly what i need, and i can't seem to find the way to apply (coding) it to my transcript do you have the code for adding this. I would truly appreciate it, if i could have it.

ParitoshT
Community Support Expert
Community Support Expert

Hi @alaskamya,

 

I recommend reviewing this article on Transcript Setup that might help you. Other PowerSchool SIS users might have shared their solutions to this on Exchange. We also encourage the other Community members to share their insight on this post if they have been able to find a solution to this.

 

ParitoshT
Community Moderator

 

alaskamya
Journeyman

not helpful at all

Lezlo
Journeyman

Hello Dulce 

This is exactly what I need to show on our transcript.

Will you please share how you did this?

dulceperez29
Practitioner

Hey! Sorry Lezlo and peeps,

 

 My area has stopped using poweschool so I have been off doing other SISs and stuff but this is what I used for reference each one for total credits/units, earned and missing. Please let me know if you guys can figure it out or I am more than happy to walk you guys through it 🙂 

 

^(*credit_hours.credit_type.ENG)
^(*credit_hours.credit_type.WH)
^(*credit_hours.credit_type.USH)
^(*credit_hours.credit_type.CIV)
^(*credit_hours.credit_type.ECON)
^(*credit_hours.credit_type.MATH)
^(*credit_hours.credit_type.PHYSCI)
^(*credit_hours.credit_type.LIFSCI)
^(*credit_hours.credit_type.VPAWLCTE)
^(*credit_hours.credit_type.PHYEDU)
^(*credit_hours.credit_type.WKRD)
^(*credit_hours.credit_type.ELEC)
^(*credit_hours)

^(*evaluate round(if((30-^(*credit_hours.credit_type.ENG))<=0,"0.00",30-^(*credit_hours.credit_type.ENG)),2))
^(*evaluate round(if((10-^(*credit_hours.credit_type.WH))<=0,"0.00",10-^(*credit_hours.credit_type.WH)),2))
^(*evaluate round(if((10-^(*credit_hours.credit_type.USH))<=0,"0.00",10-^(*credit_hours.credit_type.USH)),2))
^(*evaluate round(if((5-^(*credit_hours.credit_type.CIV))<=0,"0.00",5-^(*credit_hours.credit_type.CIV)),2))
^(*evaluate round(if((5-^(*credit_hours.credit_type.ECON))<=0,"0.00",5-^(*credit_hours.credit_type.ECON)),2))
^(*evaluate round(if((20-^(*credit_hours.credit_type.MATH))<=0,"0.00",20-^(*credit_hours.credit_type.MATH)),2))
^(*evaluate round(if((10-^(*credit_hours.credit_type.PHYSCI))<=0,"0.00",10-^(*credit_hours.credit_type.PHYSCI)),2))
^(*evaluate round(if((10-^(*credit_hours.credit_type.LIFSCI))<=0,"0.00",10-^(*credit_hours.credit_type.LIFSCI)),2))
^(*evaluate round(if((10-^(*credit_hours.credit_type.VPAWLCTE))<=0,"0.00",10-^(*credit_hours.credit_type.VPAWLCTE)),2))
^(*evaluate round(if((20-^(*credit_hours.credit_type.PHYEDU))<=0,"0.00",20-^(*credit_hours.credit_type.PHYEDU)),2))
^(*evaluate round(if((0-^(*credit_hours.credit_type.WKRD))<=0,"0.00",0-^(*credit_hours.credit_type.WKRD)),2))
^(*evaluate round(if((0-^(*credit_hours.credit_type.ELEC))<=0,"0.00",0-^(*credit_hours.credit_type.ELEC)),2))
^(*evaluate round(^(f.add;^(*evaluate round(if((30-^(*credit_hours.credit_type.ENG))<=0,"0.00",30-^(*credit_hours.credit_type.ENG)),2));^(*evaluate round(if((10-^(*credit_hours.credit_type.WH))<=0,"0.00",10-^(*credit_hours.credit_type.WH)),2));^(*evaluate round(if((10-^(*credit_hours.credit_type.USH))<=0,"0.00",10-^(*credit_hours.credit_type.USH)),2));^(*evaluate round(if((5-^(*credit_hours.credit_type.CIV))<=0,"0.00",5-^(*credit_hours.credit_type.CIV)),2));^(*evaluate round(if((5-^(*credit_hours.credit_type.ECON))<=0,"0.00",5-^(*credit_hours.credit_type.ECON)),2));^(*evaluate round(if((20-^(*credit_hours.credit_type.MATH))<=0,"0.00",20-^(*credit_hours.credit_type.MATH)),2));^(*evaluate round(if((10-^(*credit_hours.credit_type.PHYSCI))<=0,"0.00",10-^(*credit_hours.credit_type.PHYSCI)),2));^(*evaluate round(if((10-^(*credit_hours.credit_type.LIFSCI))<=0,"0.00",10-^(*credit_hours.credit_type.LIFSCI)),2));^(*evaluate round(if((10-^(*credit_hours.credit_type.VPAWLCTE))<=0,"0.00",10-^(*credit_hours.credit_type.VPAWLCTE)),2));^(*evaluate round(if((20-^(*credit_hours.credit_type.PHYEDU))<=0,"0.00",20-^(*credit_hours.credit_type.PHYEDU)),2));^(*evaluate round(if((5-^(*credit_hours.credit_type.WKRD))<=0,"0.00",5-^(*credit_hours.credit_type.WKRD)),2));^(*evaluate round(if((0-^(*credit_hours.credit_type.ELEC))<=0,"0.00",0-^(*credit_hours.credit_type.ELEC)),2))),2))

 

 

^(*evaluate round(if((30-^(*credit_hours.credit_type.ENG))<=0,"0.00",30-^(*credit_hours.credit_type.ENG)),2))
^(*evaluate round(if((10-^(*credit_hours.credit_type.WH))<=0,"0.00",10-^(*credit_hours.credit_type.WH)),2))
^(*evaluate round(if((10-^(*credit_hours.credit_type.USH))<=0,"0.00",10-^(*credit_hours.credit_type.USH)),2))
^(*evaluate round(if((5-^(*credit_hours.credit_type.CIV))<=0,"0.00",5-^(*credit_hours.credit_type.CIV)),2))
^(*evaluate round(if((5-^(*credit_hours.credit_type.ECON))<=0,"0.00",5-^(*credit_hours.credit_type.ECON)),2))
^(*evaluate round(if((20-^(*credit_hours.credit_type.MATH))<=0,"0.00",20-^(*credit_hours.credit_type.MATH)),2))
^(*evaluate round(if((10-^(*credit_hours.credit_type.PHYSCI))<=0,"0.00",10-^(*credit_hours.credit_type.PHYSCI)),2))
^(*evaluate round(if((10-^(*credit_hours.credit_type.LIFSCI))<=0,"0.00",10-^(*credit_hours.credit_type.LIFSCI)),2))
^(*evaluate round(if((10-^(*credit_hours.credit_type.VPAWLCTE))<=0,"0.00",10-^(*credit_hours.credit_type.VPAWLCTE)),2))
^(*evaluate round(if((20-^(*credit_hours.credit_type.PHYEDU))<=0,"0.00",20-^(*credit_hours.credit_type.PHYEDU)),2))
^(*evaluate round(if((0-^(*credit_hours.credit_type.WKRD))<=0,"0.00",0-^(*credit_hours.credit_type.WKRD)),2))
^(*evaluate round(if((0-^(*credit_hours.credit_type.ELEC))<=0,"0.00",0-^(*credit_hours.credit_type.ELEC)),2))
^(*evaluate round(^(f.add;^(*evaluate round(if((30-^(*credit_hours.credit_type.ENG))<=0,"0.00",30-^(*credit_hours.credit_type.ENG)),2));^(*evaluate round(if((10-^(*credit_hours.credit_type.WH))<=0,"0.00",10-^(*credit_hours.credit_type.WH)),2));^(*evaluate round(if((10-^(*credit_hours.credit_type.USH))<=0,"0.00",10-^(*credit_hours.credit_type.USH)),2));^(*evaluate round(if((5-^(*credit_hours.credit_type.CIV))<=0,"0.00",5-^(*credit_hours.credit_type.CIV)),2));^(*evaluate round(if((5-^(*credit_hours.credit_type.ECON))<=0,"0.00",5-^(*credit_hours.credit_type.ECON)),2));^(*evaluate round(if((20-^(*credit_hours.credit_type.MATH))<=0,"0.00",20-^(*credit_hours.credit_type.MATH)),2));^(*evaluate round(if((10-^(*credit_hours.credit_type.PHYSCI))<=0,"0.00",10-^(*credit_hours.credit_type.PHYSCI)),2));^(*evaluate round(if((10-^(*credit_hours.credit_type.LIFSCI))<=0,"0.00",10-^(*credit_hours.credit_type.LIFSCI)),2));^(*evaluate round(if((10-^(*credit_hours.credit_type.VPAWLCTE))<=0,"0.00",10-^(*credit_hours.credit_type.VPAWLCTE)),2));^(*evaluate round(if((20-^(*credit_hours.credit_type.PHYEDU))<=0,"0.00",20-^(*credit_hours.credit_type.PHYEDU)),2));^(*evaluate round(if((5-^(*credit_hours.credit_type.WKRD))<=0,"0.00",5-^(*credit_hours.credit_type.WKRD)),2));^(*evaluate round(if((0-^(*credit_hours.credit_type.ELEC))<=0,"0.00",0-^(*credit_hours.credit_type.ELEC)),2))),2))

----
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!
rodriguez_ashley

Can you give me a step by step from the begging on how to create this?

dulceperez29
Practitioner

@rodriguez_ashley  Did you figure this out yet? I basically added the sections in the transcript categories to where the code falls under that category and then referenced this in the transcript. It is a lot of setup so you can pull the code later on. 

----
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!