Fulfillment: Update campus address menu in BannerWeb

Tags AppOps SOP

Objective

  • To provide instruction on updating an existing department name or adding a new department to the BannerWeb campus address drop-down menu

User

  • Solution Delivery Support

Environment

  • 80463: BannerWeb 8 (Self Service)
    • Banner

Fulfillment

  1. Open the DatacorrectionsScriptsPayroll in GitLab
  2. Open the needed sql
    • If you are creating a new address use the file create_department_addresses.sql
    • If you are updating an existing address use the file update_department_name.sql
  3. Copy the SQL into SQLDeveloper
  4. Update the names as needed
  5. Update in Dev and commit
  6. Create a change ticket to have the DBAs run in Test and Prod

 

Was this helpful?
0 reviews

Details

Article ID: 80631
Created
Wed 6/12/19 1:41 PM
Modified
Wed 6/10/20 8:32 AM
Can you resolve this issue yourself?
Yes! This is self-service with a smile.