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
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
Meeting Notes and Recordings
| title | 2020-05-14 Employee Analytics COP |
|---|
Time Tracking: ACOP-169
Recording:
- 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.
| title | 2020-04-03 Employee Analytics COP |
|---|
Time Tracking: ACOP-169
Looking for EAH data integration? The data integration process can be found at /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
| Ui expand | ||
|---|---|---|
| ||
Time Tracking: ACOP-169 |
| title | 2020-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=7nDA2MLooking to search all the EAH views and fields? Use this Cognos report to see what is available EAH FCVs and Fields
| Child pages (Children Display) | ||
|---|---|---|
|