Start a new topic

Academic Plan Query or Reports

We are using the individualized academic plan for the first time. Does anyone have queries that they have already build to see who has not submitted a request? Is there any reports? 


1 person has this question

Within APL and APC, what do the Transaction codes mean with A, P. D, etc?  

Approved, Pending, Denied

Something we're noticing when adding courses to an academic plan is that the Grade option displays "No course request packets are available." when student's next grade is 12, even though there are applicable packets for 12th graders.

I had a similar question, here are two queries that may help

​For students with a Student Academic Plan:
LIST STU HSG APC CRS STU.ID STU.LN STU.FN STU.GR APC.GR HSG.GRT APC.CN CRS.CN CRS.CO CRS.S1 HSG.CD HSG.RQ HSG.PL BY STU.LN STU.FN APC.GR CRS.DC IF HSG.PL # 0 AND CRS.S1 = HSG.CD AND APC.GR > STU.GR  

For Student without a Student Academic Plan: 
SKIP STU APC IF ( APC.GR > STU.GR  AND STU.GR < 12 ) OR STU.NG = 13 OR STU.TG # " "
Once you run this query you will have only students that do not have a plan you can then run a query to get a list of students. 
LIST STU LN FN GR ID 

Login to post a comment