Versions Compared

Version Old Version 17 New Version 18
Changes made by

Saparnell

Saparnell

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Welcome to the Employee Analytics Community of Practice! Both Cognos,Tableau and other tool users are invited. This Community of Practice is a great place to get your questions answered and see real examples of how employee data is used at UCSD.

Monthly meetings: By invite only, must have access to EAH.  Email busintel@ucsd.edu for an invite.

Having issues?  email busintel@ucsd.edu.

Burning questions? Slack the COP at UCSD Analytics #eah_cop

Great enhancement Ideas? User Echo or email busintel@ucsd.edu

Want to keep up on Employee Analytics news?  Join our mail list: https://mailman.ucsd.edu/mailman/listinfo/employeeanalytics-cop-l or watch the /wiki/spaces/EAH/overview page for announcements.


Helpful Links:

Looking for pre-built report from EAH?Check out   https://reports.ucsd.edu (access required)

Want to invite other teammates to be an Employee report developer?  Send your teammate this form to request access to EAH: https://ucsdservicedesk.service-now.com/its?id=sc_cat_item&sys_id=1c26e456db101450dbd6f2b6af96199c Employee Activity Hub Report Developer Access Request form

Looking for EAH data integration?The data integration process can be found at   /wiki/spaces/AH/pages/12487881

Looking to search all the EAH views and fields?  Use this Cognos report to see what is available EAH FCVs and Fields

Looking for Cognos or Tableau training using EAH data?    /wiki/spaces/ACP/pages/11175625


Reference Pages

Ui children
alltrue
displayblock


Meeting Notes and Recordings


Ui expand
title2020-06-09 Employee Analytics COP

Time Tracking: ACOP-169

Recording: https://ucsdcloud-my.sharepoint.com/:f:/g/personal/jmwhite_ucsd_edu/Ev-ERHH5dSVGoXP_5XSwXyYBRyDGHHaa-SypcQEQLvNGYg?e=IVLSay

Attendees:  Sarah Parnell, Andy Beecham, Dan Xu, Kathryn Brumfield, Daniel Redfern, Ari Widjaja, Chaozi Chen, Cheryl Kettnich, Chester Yao, Chun Qian, Csilla Csori, Eric Rosenzweig, Galina Belokurova, Irene Xavier, Jonathan Whitman, Karen Gerstoft, Kenny Valdivia, Kerry Knight, Kristine Kilanski, Lucie chan, Marco Hermosillo, Mark Cheney, Michael Weinfeld, Steven Higgins, Steven Machado, Sama Hosseini Porgham

What does materialized mean?

  • It means that after UCOP sends us the data, BIA runs the scripts to re-organize the data into our set up tables and then we materialize (copy & paste as values) to the final FCV tables
  • Steve Higgins: can we also get the date time that UCOP sends us table to see when the data leaves UCOP
  • Andy: yes, we can add that
I am looking for the hourly pay rate for the hourly paid position on EAH. I searched on several views but couldn't find it. Does anyone know where it is on EAH?
  • In the meeting we check EAH-Workforce-View and EAH-PositionFunding-View but the employee examples provided were converted with an Hourly Rate of 0 so EAH was showing the same amount as seen in UCPath
I'm trying to use the EAH-PositionFunding-View but am not seeing all of the records (my own name isn't part of the data). Am I using the wrong view or will the data be loaded at a future date?
  • Not all positions are funded, we would need to confirm with a UCPath person that your position meets their criteria for funded
  • Please email busintel@ucsd.edu so we can do more research
EAH-PositionFunding-View is showing more than 100% for Position Funding Distribution Percent
  • When using that field you need to change the field aggregation to 'none' and include a filter for 'Position Funding AsOf Indicator'='Current', 'Position Funding Effective Sequence Indicator'='Maximum', and 'Position Funding Budget Sequence Indicator'='Maximum'



Ui expand
title2020-06-05 Employee Analytics COP

Time Tracking: ACOP-169

Recording: https://ucsdcloud-my.sharepoint.com/:f:/r/personal/jmwhite_ucsd_edu/Documents/ITS%20BIA/Community%20of%20Practice/Employee%20Analytics%20CoP/20200605%20Employee%20COP?csf=1&web=1&e=PRS7u2



Ui expand
title2020-06-03 Employee Analytics COP

Time Tracking: ACOP-169

Recording: https://ucsdcloud-my.sharepoint.com/:f:/r/personal/jmwhite_ucsd_edu/Documents/ITS%20BIA/Community%20of%20Practice/Employee%20Analytics%20CoP/20200603%20Employee%20COP?csf=1&web=1&e=QDB3TL



Ui expand
title2020-05-26 Employee Analytics COP

Time Tracking: ACOP-169

Recording:https://ucsdcloud-my.sharepoint.com/:f:/r/personal/jmwhite_ucsd_edu/Documents/ITS%20BIA/Community%20of%20Practice/Employee%20Analytics%20CoP/20200514%20Employee%20COP?csf=1&web=1&e=M3W8LX



Ui expand
title2020-05-14 Employee Analytics COP

Time Tracking: ACOP-169

Recording:https://ucsdcloud-my.sharepoint.com/:f:/r/personal/jmwhite_ucsd_edu/Documents/ITS%20BIA/Community%20of%20Practice/Employee%20Analytics%20CoP/20200514%20Employee%20COP?csf=1&web=1&e=M3W8LX

Resources
Where do we find sick and vacation off?
  • EAH Workforce or EAH Accrual Hours
Where do we find common chart of account fields?
  • They will be labeled 'CCOA' and are found in the 'Labor Ledger' or 'LL' views.  We've just added a default CCOA fields to Workforce which will be available in most views.
Will ps_valid_combo_tbl be added to EAH?
  • Monica Gudea: The ps_valid_combo_tbl is the UCPath tableau that has all the FAU's with combocode.
  • The ps_valid_combo_tbl is no currently in EAH.
  • EAH-PositionFunding-View has the Combo Code
  • Are you looking for the combo codes separate from the employee?
  • Patti Camancho = Combo codes separate from Funding.
  • Resolution: Andy will log this as a future enhancement for Combo Code with no Person.

Is the distribution data part of EAH Position Funding Basic column grouping?

  • yes

Is the Identity_Key field supposed to be one to one with Employee ID ?

  • No.  We are receiving duplicates from the Affiliates table but we hope to have most of that resolved as of tonight's run.

should the column group: EAH.Identity_Demographics just have the most recent record or will it have history as well?

  • No history but we are receiving duplicates from the Affiliates table but we hope to have most of that resolved as of tonight's run.  We're working with that team to identify which duplicate rows can be removed.



Ui expand
title2020-04-03 Employee Analytics COP

Time Tracking: ACOP-169

Recording: https://ucsdcloud-my.sharepoint.com/:f:/g/personal/jmwhite_ucsd_edu/EhDi3-ehCtJCg8ZWgX81U1cBuY8VLmOR30D5s473KLKQHw?e=kH64qZ

Resources
How do we validate data?
  • Hana-Prod and Hana-QA will not match.  Hana-QA is Delta test data and there is more data here.  Hana-Prod is a small set of UCOP data.
  • Can test Hana-Prod vs PPS, but will be very blank in Hana-Prod.
  • Can test Hana-Prod vs DDODS, but will be very blank in Hana-Prod and not a lot of people have access to
What happens when the column group is blank?
  • Check the Where clause, if the field name changed then you won't get an error, you will only get blank data.
  • Check the Where clause, if the field name does not exist in EAH then you won't get an error, you will only get blank data.
  • If you are looking at Hana-Prod there will be a lot of blank data.
If a developer is looking is for a field but can't find it, what do they do?
  • Search Cognos
  • Post to Slack
Can we see funding information?
  • Check EAH-PositionFunding-View, you will see the Oracle funding
Is Vice Chancellor based on Funding or Home position?
  • Person's job, not Funding



Ui expand
title2020-04-03 Employee Analytics COP

Time Tracking: ACOP-169

Recording:  https://ucsdcloud-my.sharepoint.com/:f:/r/personal/jmwhite_ucsd_edu/Documents/ITS%20BIA/Community%20of%20Practice/Employee%20Analytics%20CoP/20200403%20Employee%20COP?csf=1&web=1&e=timg2R


Ui expand
title2020-03-11 Kickoff

Time Tracking: ACOP-169

Recording:  https://ucsdcloud-my.sharepoint.com/:f:/r/personal/jmwhite_ucsd_edu/Documents/ITS%20BIA/Community%20of%20Practice/Employee%20Analytics%20CoP/20200311_Kickoff_EAH-Workforce-View?csf=1&web=1&e=7nDA2M


...