Requesting Changes/Updates/Features to Banner PL/SQL or SQL Query or Process

Summary

How to request changes (Adding functionality, changes, etc) to existing PL/SQL queries or processes

Body

Issue/Question

Requesting assistance with updating a PL/SQL query or process in Banner or SQL

Please add the student status field to the requested report below. Housing needs to be able to determine if a student is an active or inactive student.

Requesting student status field - Starrez

Requesting information on understanding the GPA in Banner and the related tables; SHRLGPA, SFRSTCR, SFRSTCA

 

Environment

  • Banner
  • Microsoft SQL
  • PL/SQL

Cause

A change to a current query is being requested, or more information is requested regarding an existing query

Resolution

  1.  Please contact the Service Desk with the following information: 
    1. The query or process you would like changed
    2. Requested changes
    3. Reason for change 

ITS STAFF ONLY

  1. Follow Changing Banner PL/SQL Processes

Details

Details

Article ID: 3859
Created
Thu 8/29/19 1:31 PM
Modified
Tue 11/9/21 9:33 AM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated