BI - Cognos: Modify F Calc Appl Resource Total function

0 %

Status

Project is 0 % complete, starting on Mon 3/15/21 and ending on Fri 4/30/21.

On Hold - Waiting for Internal Resources [Waiting for internal resources]

0% complete, updated on Tue 2/15/22 12:32 PM by Andi Niess

Changed Status from New to On Hold - Waiting for Internal Resources.
Changed Health from None - No health has been set to On Hold.

Details

Dates
Mon 3/15/21 - Fri 4/30/21
Acct/Dept
Financial Aid
Service
Cognos / Cognos Enhancement/Management Request
Type
IT-General / BI/DBA
Health
On Hold
Portfolio(s)
Classification
Run
Created
Tue 3/16/21 10:25 AM
Modified
Thu 5/12/22 3:11 PM

New Project Request

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

Alternate Manager(s)

Sponsor

Stakeholders (4)

AN
Andi Niess
ETL Developer
Responsible
Responsible
Tue 3/16/21 10:23 AM
JT
Jackie Twehues
Business Intelligence Manager
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
BI Reporting Administrator
Responsible
Responsible
Tue 3/16/21 10:24 AM