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 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? Slack the COP at UCSD Analytics #eah_cop

Great enhancement Ideas? Check the EAH Enhancements In Progress page first, send anything new .

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.

Want to keep Keep up on Employee Analytics news?  Join our mail list: News  Subscribe by joining the Employee Analytics Community of Practice Google Group at https://mailmangroups.ucsdgoogle.educom/mailmanu/listinfo/employeeanalytics-cop-l or watch the /wiki/spaces/EAH/overview page for announcements.

Helpful Links:

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

Want to invite other 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: Employee Activity Hub Report Developer Access Request form

Looking for EAH data integration? integration  /wiki/spaces/AH/pages/12487881

Looking to search Search all the EAH views and fields?    EAH FCVs and Fields

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

Reference Pages

Meeting Notes and Recordings

Time Tracking: ACOP-169

Recording:

At present in Position Funding CCOA, Task is filled with “Task Description”. When will this be filled with actual data?

Is there a timeline for including the CCOA into the views other than Position Funding View?

Is there anyone who has a project to humanize the names in the EAH fields, in a consistent manner? They are very descriptive, but also very database-like. It would be nice if we could in a standard way, come up with Alias’ that make sense.

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/20200612%20Employee%20COP?csf=1&web=1&e=9utrot

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

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

Miss an Employee Analytics CoP Meeting?

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

Additional Support