Content Comparison

Welcome to the Employee Analytics Community of Practice! Both Users of Cognos, Tableau and other tool users are invited. This reporting and analytics tools using employee data are invited to join the Employee Analytics Community of Practice (Employee Analytics CoP). This community is a great place to get have your questions answered and see real examples of how employee data is used at UCSDuse at UC San Diego.

Employee Analytics CoP Resources

Monthly meetings: By invite only, Meetings Group meetings are online and by invitation only. Attendees must have access to EAH data.  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

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

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

Meeting Notes and Recordings

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

• 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

• 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

• 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'

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

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

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

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

• /wiki/spaces/EAH/overview
• Employee Activity Hub Report Developer Access Request form
• /wiki/spaces/AH/pages/12487881
• /wiki/spaces/ACP/pages/11175625

• EAH Workforce or EAH Accrual Hours

• 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.

• 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.

Time Tracking: ACOP-169

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

a meeting invitation.

See Prior Meeting Sessions (access required) on the Employee Analytics CoP Pages

Employee Data Issues  Email busintel@ucsd.edu with the URL, information and screenshots.

Burning Questions Chat with data experts on the Microsoft Teams Employee Analytics Community of Practice Channel.

Enhancement Ideas First check the EAH Bugs and Enhancements In Progress and, if you don't see something similar, send your idea to busintel@ucsd.edu.

Keep up on Employee Analytics News  Subscribe by joining the Employee Analytics Community of Practice Google Group at https://groups.google.com/u/1/a/ucsd.edu/g/EmployeeAnalyticsCoP-g

 Getting Access to Employee Data

Additional Resources

Pre-built EACH reports Business Analytics Hub, bah.ucsd.edu

Invite teammates to be an Employee report developer  Send them this form to request access to EAH: Employee Activity Hub Report Developer Access Request form

EAH data integration  /wiki/spaces/AH/pages/12487881

• 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

• 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.

• Search Cognos
• Post to Slack

• Check EAH-PositionFunding-View, you will see the Oracle funding

• Person's job, not Funding

Time Tracking: ACOP-169

Search all EAH views and fields  EAH FCVs and Fields

Miss an Employee Analytics CoP Meeting?

Find notes and recordings here:  /wiki/spaces/ACP/pages/11175054

Additional Support