Petitions
Problem Description :
Petitions
Resolution :
Petitions
A petition is added in BannerWeb
Create Review
Vulture\d: batch\create_students_petition_records.bat
Vulture\d: batch\sqls\create_student_petition_review_records.sql
Runs every 30 minutes
Audit table - wsppeta
Petition Details
select * from wsppetn where wsppetn_id = 'ID'
Petition Type Details
select * from wspptyp
Petition Routing and Status
select * from wspprev where wspprev_id = 'ID'
A
Scheduling Class Load for More Than max allowed for semester
Routing
1.STUDENT.ADVISOR_PIDM ('student pidm') IF NULL '99999999'
2.SELECT student.spriden_pidm (dept_chair) FROM v_faculty WHERE pidm = student.advisor_pidm ('student pidm') IF NULL Susan Finazzo
3.N/A
4.Janet Barras
B
Degree Requirement Exception/ Substitution
Physical Education Waiver
Routing
1.STUDENT.ADVISOR_PIDM ('student pidm') IF NULL '99999999'
2.SELECT student.spriden_pidm (dept_chair) FROM v_faculty WHERE pidm = student.advisor_pidm ('student pidm') AND divs_code = 'GC2000' IF NULL '99999999'
3.SELECT student.spriden_pidm (divs_chair) FROM v_faculty WHERE pidm = student.advisor_pidm ('student pidm') IF NULL Susan Finazzo
4.Janet Barras
C
Complete withdrawal from all classes after mid-term for hardship or extenuating circumstances
Routing
1.('inst_pidm') IF NULL '99999999' --(inst_cur, input from vce.pidm, vce.term)
2.SELECT student.spriden_pidm (dept_chair )FROM v_faculty WHERE pidm = 'inst_pidm' AND divs_code = 'GC2000' IF NULL '99999999'
3.SELECT student.spriden_pidm (divs_chair)FROM v_faculty WHERE pidm = 'inst_pidm' IF NULL '99999999'
4.Janet Barras
D
Requesting the change of date/ time for final exam
Routing
1.('inst_pidm') IF NULL '99999999' –(course_cur, input from vce.pidm, vce.term, vc.crn)
2.SELECT student.spriden_pidm (dept_chair )FROM v_faculty WHERE pidm = 'inst_pidm' AND divs_code = 'GC2000' IF NULL '99999999'
3.SELECT student.spriden_pidm (divs_chair) FROM v_faculty WHERE pidm = 'inst_pidm' AND divs_code IN ('GC4000', 'GC5000') IF NULL '99999999'
4.Janet Barras
E
Drop/ withdrawal of part of a schedule after mid-term for hardship or extenuating circumstances
Appeal of previously assigned grades
Routing
1.('inst_pidm') IF NULL '99999999' –(course_cur, input from vce.pidm, vce.term, vc.crn)
2.SELECT student.spriden_pidm (dept_chair )FROM v_faculty WHERE pidm = 'inst_pidm' AND divs_code = 'GC2000' IF NULL '99999999'
3.SELECT student.spriden_pidm (divs_chair)FROM v_faculty WHERE pidm = 'inst_pidm' IF NULL '99999999'
4.Janet Barras
Deleting Petitions
Can only be deleted if someone has not signed off (has to have a status of NR for every level), contact Janet if a petition cannot be deleted
Status – NR=not reviewed, A=Approved, D=Denied
To delete
Delete from wspprev where wspprev_id = #
Delete from wsppetn where wsppetn_id = #
Csd/Tracy/sql/csd sqls/petition_delete
Per Academic advisor, the script routes to their department chair, then their division chair
select rowid,wspprev .* from wspprev where wspprev_id = '1197'
Student petitions email sql:
Runs at 7:12 am every weekday
select
student.email_address(a.wspprev_rev_pidm) fac_email,
student.pref_first_name(a.wspprev_rev_pidm) fac_fname,
student.name(a.wspprev_rev_pidm,11) fac_lname,
student.email_address(student.spriden_pidm(VF.DEPT_CHAIR)) div_chair,
count(a.wspprev_id) pcount
from wspprev a, v_faculty vf
where
vf.pidm = a.wspprev_rev_pidm
and a.wspprev_status = 'NR'
and a.wspprev_rev_level <= 2
and a.wspprev_rev_level = (
select min(b.wspprev_rev_level)
from wspprev b, v_faculty vfb
where
vfb.pidm = b.wspprev_rev_pidm
and b.wspprev_status = 'NR'
and b.wspprev_id = a.wspprev_id
and vfb.dept_code = vf.dept_code
)
and not exists (
select 'X'
from wspprev c
where
c.wspprev_id = a.wspprev_id
and c.wspprev_status != 'NR'
and C.WSPPREV_REV_LEVEL > a.wspprev_rev_level
)
group by student.email_address(a.wspprev_rev_pidm),student.pref_first_name(a.wspprev_rev_pidm),student.name(a.wspprev_rev_pidm,11),student.email_address(student.spriden_pidm(VF.DEPT_CHAIR))
Revision Date : 4/14/2016