We are a large district that is migrating from eSchoolPLUS. eSchool plus has a field called curriculum code which is a date track code that we use to identify different groups of students. Within "curriculum code" there is a pull down menu with a list of two digit codes from a validation table that users can choose from. I am thinking the best way to do this in PowerSchool is to create a "Special Program" but I need a pull down menu in that program for users to choose from. Does anyone have anything like this?
gcmerk
Thu, 02/22/2018 - 8:43am
Permalink
Tracking Needed?
Do you need to track, or search off when those students entered, and exited the curriculum code?
T_HOMA-EHPS
Fri, 03/23/2018 - 5:50am
Permalink
Special Programs Table/View locations
The Special Programs are listed in the GEN & SPENROLLMENTS tables
where GEN.ID=SPENROLLMENTS.PROGRAM.ID you could probably code to use a dropdown menu
** I know the code will work in APEX, not sure if there is a way to code directly into the page though
Hope this helps,
Tim Homa
Information Technology Manager