UD Seal
IT Activity ReportOctober 2017
October 2017 Activity Report | Business Systems

Business Systems

Web forms and business applications

Equipment Activity: Return to Campus
The University tracks the return to campus of off-campus equipment. Based on a need identified by departments, the Equipment Activity Web Form has been enhanced to allow an equipment tag number to be entered to initiate a return. Previously, the Web Form request ID associated with equipment’s move off campus was required to initiate a Return to Campus form. This change also accommodates the return of equipment that was transferred off-campus without a Web Form.

New Excused Absence Notification Web Form
The Excused Absence Notification form has been added to the Web Forms system. IT-Web Development (IT-WD) partnered with the Office of the Registrar for this change, as part of the launch of the Blue Hen Success Collaborative (BHSC). Assistant deans who look for the Excused Absence Notification form in its former location in the Advising Notes Manager will be redirected to the new Web Form.

The new Excused Absence Notification Web Form still includes the absence date and a customized message for a student’s instructors. However, instead of receiving the results in email, instructors will need to log in to Web Forms to view the absence information. This process ensures the security of private information that may relate to a student’s absence.

Courses Search update
Courses Search allows students to search for course information for current, future, and past semesters. The Courses Search application was updated to include additional search options for Capstone Requirements, map links with improved accuracy, and a link to My UD in the navigation bar. In addition, the application was upgraded to use the responsive Bootstrap framework, making Courses Search more mobile friendly.

Haven and AlcoholEdu
Before the start of the fall 2017 semester, IT-WD collaborated with the Office of Equity and Inclusion and the Office of Student Wellness and Health Promotion to move those programs behind UD’s Central Authentication Service (CAS). “Haven: Understanding Sexual Assault” is a program required for all incoming students and new employees. “AlcoholEdu,” an alcohol misuse prevention program, is mandatory for all incoming undergraduates under the age of 26.

Previously, access to the AlcoholEdu and Haven programs was through the old UD Network page. IT-WD set up a database to manage students and employees required to complete the programs. Now when a user tries to access one of the new Haven or AlcoholEdu programs, they are required to authenticate through CAS, and if their ID is included in the new database they will be allowed to access the appropriate programs. Additionally, IT-WD now maintains and sends reminder emails about these programs to both students and employees

Photo Roster
IT-WD recently partnered with the Office of the University Registrar to update Photo Roster, an application which permits faculty to view the UD ONEcard photo of students enrolled in courses they are teaching. Updates included adding responsive design and a new search feature that allows authorized users to request the photo of a specific student or subset of students. The new search feature can also filter results for larger course sections. Prior to the update, faculty could only view a single student photo at a time. Now, faculty can view a course’s complete photo roster.

Database Administration (DBA) report

PeopleSoft and software upgrade
The Financial Accounting PeopleSoft Tools and application software is being upgraded to the latest version. Currently, changes have been made in the test environment. Updating the production version is scheduled for spring 2018.

PeopleSoft databases moved

UDSIS updates

Financial systems update

Cash management implementation
IT-MIS deployed the PeopleSoft Cash Management (Treasury) module for the Cashier's office in June. With this module in place, cash forecasting, cash positioning, fund transfers, and wire payments can be done within the PeopleSoft Cash Management module. The Cashier's office is now able to automate the bank statement reconciliation process with enhanced business rules.

At the same time, IT-MIS also deployed PeopleSoft Financial Gateway functionality for the Procurement office. This functionality centralizes payment processing. It is a single platform for processing all payments and receipts from payables, receivables, and third-party systems.

Facility online manager billing
IT-MIS has automated the Controller Office’s process of creating journals for the UD NanoFab Facility. The new process Integrates NanoFab's application “Facility Online Manager” (FOM) with the PeopleSoft General Ledger application. This process notifies the departments with chartfield exceptions and provides the capability to correct those exceptions online.

Incremental data warehouse load for UDataGlance
To improve "All Funds" report performance on UDataGlance, IT-MIS has built a data warehouse in PeopleSoft Financials and an incremental load process to update that warehouse data every night. After each update is completed, the warehouse data will be moved into the report instance for UDataGlance users to access. This new process will reduce concurrent data access on the production database, thereby improving performance.

Tic and Tie comparison reports
IT-MIS has developed a new report to compare General Ledger balances in production with data warehouse tables in the report instance of UD Financials, thereby validating the accuracy of data warehouse tables each night. Existing “Tic and Tie” reports between General Ledger and the Balances Reporting table had a flaw that generated a warning at the beginning of a new fiscal year when the prior year was still open for adjustments.

Utility to delete journals
IT-MIS has developed a utility for the Controller's office to search for and delete journals which were erroneously uploaded. This utility reduces staff effort to correct these errors.

New bill type (NIIMBL)
IT-MIS modified the non-student bill load process to generate invoices with the new NIIMBL bill type for University researchers.