Transcripts and Credits

[twilya]

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

[ParitoshT]

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]

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

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.

[dulceperez29]

Hi @twilya !

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

[WilliamB14]

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

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

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]

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]

not helpful at all

[Lezlo]

Hello Dulce 

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

Will you please share how you did this?

[dulceperez29]

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

[rodriguez_ashley]

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

[dulceperez29]

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