Created by: Robert M. Nitsos, Assistant Registrar, Student Records Systems
|
Code Snippits... |
|||||
|
The following code is provided "as-is" with no warranty, guarantee or any other promise. |
|||||
| Web Pages |
ver 4.x |
ver 5.x |
ver 6.x |
Description | Comment |
| Advisee List | N/A |
lmuhwskadvl.sql | N/A |
After selecting a term, the user is presented with a report that displays advisees currently assigned, including program of study for each student. This information can also be downloaded (with the students' addresses, phone numbers and email addresses) into an Excel spreadsheet. | Web for Faculty |
| Athlete Information |
N/A |
lmuhwskainf.sql | N/A | This package contains several reports that display information on Athletes coded on SGASPRT. Reports include: Team Rosters, Athlete Program of Study, Enrolled Hours, and Mid-Term Grades (to name a few). In addition to self-service pages, there is code that allows for the downloading of data to an Excel file. | Web for Faculty |
| Class Counts | lmuhwskccnt.sql | lmuhwskccnt.sql | N/A |
After selecting a term and a Subject Code or College, the user is presented with a report that displays course information, including enrollment. This information can also be downloaded into an Excel spreadsheet. | Web for Faculty |
| Class Rosters | lmuhwskclst.sql |
N/A |
N/A |
View the students enrolled in a particular section. User may enter either the CRN for the course or the SUBJ, CRS and SEC variables. List may also be downloaded into an Excel spreadsheet. | Web for Faculty |
| Course Overrides | lmuhwsksrpo.sql | lmuhwsksrpo.sql | N/A |
This page allows a faculty/advisor to view any existing permission overrides for a student. The user can also add or delete overrides for the student. | Web for Faculty |
| Degree Information | lmuhwskdegr.sql | lmuhwskdegr.sql | N/A |
This page displays degree information for the student including status, degree information, and whether the diploma has been ordered. | Web for Students |
| Demographic Data | lmuhwskdemo.sql | lmuhwskdemo.sql | N/A |
This page allows the student to update their Ethnicity, Marital Status and Religion. It also works in conjunction with lmuhwskrgtm.sql to "force" students to update this data before seeing their Registration Status. | Web for Students |
| Final Grades | lmuhwskfgrd.sql | N/A |
This page displays the current final grades for a selected course. The grade comes from the most recent record in history (SHRTCKG table) or, if no grade exists in history, from the SFASLST form (SFRSTCR table). The information can also be downloaded into an Excel spreadsheet. | Web for Faculty | |
| create_f_lmu_get_final_grades.sql |
N/A |
N/A |
Function to return a final grade for a passed PIDM, CRN and TERM_CODE. This function is used by LMUHWSKFGRA (above) to return final grades. | Function | |
| Holds/Remove Advisor Holds | N/A |
lmuhwskhold.sql | lmuhwskhold.sql | This page displays all current, past and future holds for a selected student. The user also has the ability to remove Advisor Holds (sprhold_hldd_code='AH') if they are a member of the college that applied the hold (this is based on sprhold_user). Updated to allow user to place an Advisor (AH) hold!!! | Web for Faculty |
| High School Information | lmuhwskhsch.sql | lmuhwskhsch.sql | N/A |
This page displays High School information for a selected student. | Web for Faculty |
| Mid-Term Grades | N/A |
lmuhwskmtgd.sql | N/A |
This package produces four (4) pages: 1) view MTG for selected student, 2) view MTG for students of a selected Major, 3) view MTG for students in a selected College, and 4) view MTG for assigned advisees. The user can download the data for 2-4 into an Excel file. | Web for Faculty |
| Name/ID Search/Select | lmuhwskiden.sql | lmuhwskiden.sql | N/A |
Search page similar to SOAIDEN. User can search on all or part of ID, Last Name, First Name or Middle Initial. User can select from returned results by clicking on a button. | Web for Faculty |
| Photo Class Roster | N/A |
N/A |
lmubwgkpics.sql | This page displays a class roster for a selected course that includes photos downloaded from our campus card (OneCard) system. | Web for Faculty |
| Registration Status/Information | lmuhwskrgtm.sql | lmuhwskrgtm.sql | N/A |
This page displays the same Registration Status information as the baseline "Web for" package, but also includes the registration date/time for the student (based on data from the SFRCTRL table). | Web for Students |
| Student Schedule by Day and Time | N/A |
lmubwfkssdt.sql | N/A |
This page displays a student's schedule by day and time (in grid format) in the Faculty Module. It is basically a copy of the Web for Student Schedule by Day and Time modified for use by faculty. | Web for Faculty |
| Transfer Course History | N/A |
lmuhwskthst.sql | N/A |
This page displays Transfer Articulation History for a selected institution. We currently have this page set up for "insecure" access, thus allowing users to access it directly from our public web site (without having to log into Self-Service).. | All Users |
| Transfer Information | N/A |
lmuhwsktaeq.sql | N/A |
The faculty page displays current transfer work for a selected student. The page displays work under evaluation as well as accepted courses. The page also displays other equivalent courses that could have been used as well as course attributes (for use with CAPP). The student page shows the same information to the student. | Web for Faculty & Web for Students |
| Test Scores | lmuhwsktest.sql | lmuhwsktest.sql | N/A |
This page displays test score information from the SOATEST form in Banner. | Web for Faculty |
| SQL Scripts | |||||
| File Name | Description | Comment | |||
| missing_grades.sql | SQL Script that reports courses that have outstanding grades. Requires function lmu_f_get_final_grade. | ||||
| missing_grades_w_students.sql | SQL Script that reports courses that have outstanding grades. Includes individual students that are missing grades. Requires function lmu_f_get_final_grade. | ||||
| create_lmu_f_get_final_grade.sql | SQL Script that reports courses that have outstanding grades. Requires function lmu_f_get_final_grade. | ||||
| create_lmu_r_f_get_aok.sql | SQL Script that generates function used by Transfer Course History page above. | ||||
| PowerPoint Presentations | |||||
| File Name | Description | Comment | |||
| Creating Your Own Self-Service Web Pages | Presentation outlines the steps we took (from the creation of the SQL Package to inserting the page using Web Tailor) to create a custom, self-service page in the Faculty Self-Service module. | Sungard SCT Summit - 2006 | |||
Questions? Comments? Praise? Gratitude? Email me at rnitsos@lmu.edu