June 2019

Reminder about the Annual Salary Increase Process & Costing Copy

June 13, 2019

Annual Salary Increase
We are coming up on the annual salary increase for Administrative Professionals, effective, July 1, 2019. The ASIP upload deadline is June 26th at 5:00 p.m.

The process is the same as last year. The updated work instructions and salary increase template are available in the Harvard Training Portal:

The new salary ranges are in PeopleSoft. For administrators who have access, the updated salary ranges can be viewed there at Navigator > Set Up HCM > Product Related > Compensation > Base Compensation > Salary Grades.... Read more about Reminder about the Annual Salary Increase Process & Costing Copy

Position Tracking and Reporting on Track for July 2019 and Oct 2019 Go-Lives

June 13, 2019

Back in April, we shared information in eNews about the Position Tracking and Reporting project.  The project remains on track to deliver new functionality in PeopleSoft and Harvard Careers for:

  • July 2019 - Beta release at the Harvard Divinity School only
  • October 2019 - All schools and units will be live with position numbers for staff and union positions. Some schools will elect an early adoption of faculty position numbers and may include other classes (ex. Post Docs, Temps etc.) at this time. Faculty position numbers will be required by April 2020.

This month, in preparation for our go-live, we had over 75 individuals across all major schools and units participate in user acceptance testing.  Participants were represented from:

  • American Repertory Theatre
  • Campus Services
  • Chan School of Public Health
  • Faculty of Arts & Sciences
  • Graduate School of Design
  • Graduate School of Education
  • Harvard Business School
  • Harvard Divinity School
  • Harvard Kennedy School
  • Harvard Law School
  • Harvard Medical School
  • Harvard School of Dental Medicine
  • Harvard University Art Museums
  • Harvard University Employees Credit Union
  • Harvard University Information Technology
  • Harvard University Library
  • Harvard University Police Department
  • Harvard University Press
  • Radcliffe Institute for Advanced Studies
  • School of Engineering and Applied Sciences
  • University Health Services
  • Vice President of Human Resources

The project team received some great feedback that we intend to incorporate into our training materials and future releases.

If you have any questions about the project please contact your local implementation manager.

... Read more about Position Tracking and Reporting on Track for July 2019 and Oct 2019 Go-Lives

The End is Near - Tips and Tricks for Year End Close

June 13, 2019

Want some ideas in how to accomplish a smooth year-end close?

Wonder about how you are going to get all of those journals done and if there are any ways to make it easier?

Do you need help on determining what you need to accrue or defer (and what that means)?

Confused on what is due when?

Please join us on Tuesday, June 18 from 1:00-2:00 in the Lamont Library, Forum Room.

To attend, please register here or send an email to financialpolicy@harvard.edu with the words “6/18 Session” in the subject line.

This session is open to all; please feel free to forward this invitation to others who may be interested.

OGC Model Contract/Agreement and Speaker Templates

June 13, 2019

The OGC has recently updated the long form for services or consulting agreement template and has created several new model speaker consent forms (paid and unpaid guest speakers, guest lecturers, panelists, performers, etc.) which may be found here.

Additional changes to the short form model services/consulting agreement is forthcoming.

FY21-25 Multi-Year Capital Plan (MYCP)

June 13, 2019

Please be aware of these dates:

  • The FY21-25 multi-year capital plans should be submitted in CPATH by August 30th; the data from the August 30th MYCP submission will be pre-populated in the Multi-Year Financial Plans (MYFP) by OFSP. Adjustments can be made through October 4th; however, the final capital spending amount reported in CPATH as of October 4th must agree with the amounts in the MYFP.
  • Please ensure the out years of the MYCP (FY24 and FY25) reflect anticipated spending; if projects are not yet identified, it is recommended that placeholders be used.
  • MYCP narratives are due to CAPS by October 11th. Narrative template will be distributed in the next few weeks. Questions will be similar to last year.
  • FY21-25 Capital Plan Guidelines will be posted to the CAPS website within the next few weeks.

Please contact a member of the FAD Capital Panning and Project Services team with any questions or send an email to the CAPS Office (caps@harvard.edu).

Analytics and Reporting (Human Resources) - Workforce Analytics Updates

June 13, 2019

Position Tracking and Reporting (PT&R)

Modifications have been made to the My Workforce and University Workforce applications:

My Workforce added Position # to:

  • Current - Job Profile
  • Job Costing - (Budget Level Indicator also added)
  • Point in Time - Job Profile
  • Actions - Actions
  • Actions - Career Summary

University Workforce added Position # to:

  • Current - Job Profile
  • Current - Job Costing
  • Point in Time - Job Profile
  • Actions - Action Inquiry
  • Actions - Career Summary
  • Other - All Jobs

Announcing New QlikView Workforce Applications!
Demographics and Mobility & Terminations

The Demographics application displays a variety of employee and job information metrics which can be used to measure and track employees and their characteristics such as race and ethnicity, gender, age and years of service. Using Demographics data, we can:

  • Analyze workforce patterns                      
  • Study and understand trends over time (employee population rates, FTE% change, generational cohorts)

Demographics - Diversity Trends

... Read more about Analytics and Reporting (Human Resources) - Workforce Analytics Updates

Ad Hoc Reporting Project Update

June 13, 2019

The Ad Hoc Reporting Project (ARP)’s mission is to implement a modernized ad-hoc reporting software solution (Tableau) and support the migration from Brio to the new platform. Our number one guiding principle for this project is to advance HUIT’s vision of empowering the Harvard community through technology that enables effortless access to data, information and knowledge.  Data Management Services (DMS) is happy to announce that the funding for the project has been released so that work can start in earnest in FY20.

Currently, DMS is actively working with Tableau to:

  • Identify consulting partners to assist Brio/IR users converting their queries to Tableau
    and
  • Identify training tracks for the Ad Hoc community
  • Provide monthly informational sessions for the Brio / IR users called Tableau Days
  • Complete a Vendor Risk Assessment to ensure proper security
  • Review and negotiate licensing options

Tableau Days

DMS is happy to state that the second Tableau Day was a success.  Justin Grosz from Harvard Business Publishing (HBP) spoke about how HBP uses Tableau for quarterly reporting automation.  Tableau’s topics included best practices, an overview of Tableau, and a review of how to create spreadsheets in the system.

Planning is currently underway for the next Tableau Day on Thursday, June 27th.  Tableau Day will be held in the 4th floor Summit Room at 784 Mount Auburn Street.  Tableau and Harvard presentations will be held from 11:00 a.m. to 1:30 p.m., with Doctor Sessions running from 1:30 p.m. through 3:00 p.m.

  • To register for the Tableau Days, please click HERE.
  • To register for the Tableau Doctor Sessions, please click HERE.

If you have topics that you would like to see covered in future Tableau Days, simply email Patty Hatch or Raj Mariadoss.

... Read more about Ad Hoc Reporting Project Update

Harvard Analytics and Reporting Tool (HART) Update

June 13, 2019

Harvard Analytics and Reporting Tool (HART), powered by OBI, includes the Accounts Receivables, CAPS, Cash Management, Chart of Accounts, CSMA, Financials, Grants Management, Procure to Pay, Travel & Expense, and User Security folders.

HART by the Numbers

  • · 0.03          % of queries that completed in over 1 minute
  • · 1                Average query time to run in seconds
  • · 714            Average # of rows in the dashboard results
  • · 25,147      Difference in the # of queries between the top 2 most frequently run dashboards (1. Transaction Listing   All, 2. Transaction Listing with Balance Forward All)

Monthly HART Release

The next monthly HART release will begin on Thursday, June 27th at 6 p.m.  All changes will be implemented, and the release completed, by 9 a.m. on Friday, June 28th.

Check out the OBI 3 Month Release Plan and Backlog wiki page for details of the dashboard changes included in this release.

Fiscal Year End Webinar

With Fiscal Year End activities in full swing, please join DMS for a webinar focusing on HART Fiscal Year End Best Practices on Friday, June 14 at 12 p.m.  Please register for the session via the Harvard Training Portal.  The Webinar link will be emailed to registered participants the day before the session.

This webinar will focus on tips and tricks for making the most use of HART during the fiscal year end.  Topics include:

  • How to use the period prompts found on the Transaction Listing dashboards to search for prior and new fiscal year entries
  • What the best ways are to get results quickly
  • What the best dashboards are to give you the specific results you need

... Read more about Harvard Analytics and Reporting Tool (HART) Update

Research Administration & Compliance Systems

June 13, 2019

New Publication Format!

The Harvard University Information Technology Research Administration and Compliance Systems team supports a number of University-wide systems. Historically, we shared system updates via separate eNews articles. However, to simplify information sharing with our community, we will now publish updates across our applications under this one eNews article heading.

GMAS

GMAS had a release May 31st which included:

  • Changes to comments
  • Changes to the current and pending support download
  • Updates to financial deliverables
  • Addition of the edit dates button on the proposal homepage
  • A new funding instrument type
  • Bug fixes, and so much more

For the detailed list of enhancements and bug fixes, please visit the GMAS Release page.

For questions about this release email contactgmas@harvard.edu

ecrt

The FY19 Q3 Certification period concluded on June 4th, 2019 with a 100% certification rate!

FY19 Q4 project statements and FY19 Annual statements important dates:

  • Review period: 9/3/19 to 9/23/19
  • Certification period: 9/24/19 to 10/23/19

The next ecrt Basics training sessions will be offered in early September on both the Cambridge and Longwood Medical Area campuses.

All Request for Proxy of Authority for Annual Effort Certifications forms must be submitted to OSP by Friday, September 13th. Tub deadlines may be earlier.

Year-end reminder: Please have any employee changes for FY20 in PeopleSoft by EOB July 1st, 2019. In any case, ecrt will use the data that is present on July 1st in PeopleSoft to determine quarterly vs. annual employee type status for FY20. This status will be locked in for FY20 and cannot be changed until FY21.

Please reach out to ecrt@harvard.edu with any questions.

... Read more about Research Administration & Compliance Systems