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 UCSD.Monthly meetings: By invite only, use at UC San Diego.

Employee Analytics CoP Resources

Monthly 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

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 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 your teammate them this form to request access to EAH: https://ucsdservicedesk.service-now.com/its?id=sc_cat_item&sys_id=1c26e456db101450dbd6f2b6af96199c

Meeting Notes and Recordings

Time Tracking: ACOP-169

Recording: 

Employee Activity Hub Report Developer Access Request form

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

• 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

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

• 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