BI - Cognos: Modify F Calc Months In Job function

100%

Status

Cancelled [Cancelled]

100% complete, updated on Fri 6/25/21 5:35 PM by Mike Pusey

Changed Status from New to Cancelled.
Cancelling project per Diana Combs (sponsor) due to Workday migration.

Details

Dates
Wed 12/2/20 - Fri 6/25/21

Acct/Dept

Institutional Research and Strategic Analytics

Service

Cognos / Cognos Enhancement/Management Request

Type

IT-General / BI/DBA

Health

None - No health has been set

Classification

Transform

Created

Wed 12/2/20 7:33 AM

Modified

Fri 6/25/21 5:35 PM

Closed

Fri 6/25/21 5:35 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 will server for years prior to 2005

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?

Accuracy of data for report to external reporting agency

What is the desired completion date?

Please note that projects will be completed based on resource availability and prioritization.

04/30/2020

What are the factors driving the desired completion date?

Are there campus activities, legal requirements, dependent efforts or goals that are driving a date?

Report required or External Reporting Agency

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.

Monique Sendze

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.

Unknown at this time.

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?

none

Description

Cognos Function: f_calc_months_in_job is not returning a value for employees hired prior to 7/1/2005. Revision to the code where clause for position_change_reason may need to be expanded, as well as other where clauses revised or added.

Manager

Jackie Twehues

Alternate Manager(s)

Mike Pusey

Sponsor

Diana Combs

Stakeholders (1)