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.
You can give term, year, grade level, or credit type as a parameter.
Please let us know if this helps you.
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!
@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....
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.
Hi @twilya !
I have created this formula for our transcripts. Is this what you are looking for?
@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?
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?