BI - Cognos: F Calc Appl Resource Total Function - modify

100%

Status

Completed [Completed]

100% complete, updated on Thu 1/5/23 12:13 PM by Andi Niess

Changed Status from On Hold - Waiting for Internal Resources to Completed.
Changed Health from On Hold to None.
Changed Percent Complete from 0% to 100%.
Completed by Mike Pusey 12/22 - see Sprint 6 of BI - Cognos: All Enhancements Plan project 422944

Details

Dates
Mon 3/15/21 - Thu 1/5/23
Acct/Dept
Financial Aid
Service
Cognos / Cognos Enhancement/Management Request
Type
IT-General / BI/DBA
Health
None - No health has been set
Portfolio(s)
Classification
Run
Created
Tue 3/16/21 10:25 AM
Modified
Thu 1/5/23 12:13 PM
Closed
Thu 1/5/23 12:13 PM

New Project Request

Point of Contact
This can either be the project manager or the person who knows the most about the project. Note that the project manager is assigned after the project is created.
How can we help you?
Please provide details regarding your request? Do you have a solution defined or do you need support identifying a solution?
function F_CALC_APPL_RESOURCE_TOTAL needs to be updated.
Provide the background of this request.
What events or discussions preceded this request? Have there been previous efforts related to this request? Are you working with a vendor already? What are the benefits of this initiative?
Due to changes in business practices in FinAid and Bursars office regarding Grad Contracts, the function is no longer valid
What is the desired completion date?
Please note that projects will be completed based on resource availability and prioritization.
04/30/2021
What are the factors driving the desired completion date?
Are there campus activities, legal requirements, dependent efforts or goals that are driving a date?
need to utilize in reports
Provide the executive leader(s) who will champion this initiative?
These individuals support the success of this effort, such as removing obstacles, sending strategic communication and promoting necessary policy changes.
Jackie Twehues
What team members have been identified to help drive this initiative?
Please note that involvement of department team members is critical to the success of this inititive.
Andi Niess, Jackie Twehues, Mike Pusey, Jerry Martinez
Any additional information about this request that you would like to include?
Who does this project help? What happens if this project is not completed?
no

Description

Financial aid currently has two reports in Cognos used to identify students that are over need and over their cost of attendance. We have recently discovered our graduate students with a RA/TA contract are no longer being pulled into the report based on the new process for RA/TA contracts in Banner.

We are currently using a function for resources in the over cost of attendance report - F_CALC_APPL_RESOURCE_TOTAL([PERSON_UID],[AID_YEAR]), however it is no longer accurately pulling the resources for our RA/TA contracts in the Banner page RPAARSC.

Due to changes in business practices in FinAid and Bursars office regarding Grad Contracts, the function needs to be updated.

Systems Affected

  1. Cognos

  2. ODS

Manager

AN
Andi Niess

Alternate Manager(s)

JT
Jackie Twehues

Sponsor

JM
Jerry Martinez

Stakeholders (4)

AN
Andi Niess
ETL Developer
Responsible
Responsible
Tue 3/16/21 10:23 AM
JT
Jackie Twehues
Business Intelligence Mgr
Accountable
Accountable
Tue 3/16/21 10:23 AM
JM
Jerry Martinez
Assoc Dir Fin Aid
Consulted
Responsible
Tue 3/16/21 10:24 AM
MP
Mike Pusey
Temporary Faculty-Non Academic
Responsible
Responsible
Tue 3/16/21 10:24 AM