Versions Compared

Version Old Version 91 New Version 92
Changes made by

Russia Madden

Russia Madden

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 with URL information and screenshots

Burning Question? Chat with data experts on Teams > UCSD Analytics COP > request an invitation for Employee Analytics Community of Practice

Great enhancement Ideas? Check the EAH Bugs and Enhancements In Progress page first, send anything new to 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.

Want to see prior sessions (access required)? OneDrive > Employee Analytics CoP

EAH Access for Developers and Consumers

Helpful Links:

Looking for pre-built report from EAH?  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: Employee Activity Hub Report Developer Access Request form

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

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


Meeting Notes and Recordings


Ui expand
titleTEMPLATE - 2021-00-00 Employee Analytics COP

Time Tracking: ACOP-169

Recording: 

SubjectContent
SubjectContent
SubjectContent



Ui expand
title2021-02-16 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/20210216%20Employee%20COP?csf=1&web=1&e=xx2yKf

Question: How to capture joint appointmentsHow to capture employees with more than one department
SubjectContent
SubjectContent- Report Created and saved to temporary folder: Community of Practice Shared Development - content will be cleared regularly






Ui expand
title2021-01-19 Employee Analytics COP

Time Tracking: ACOP-169

Attendees:  23 people

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

Question - Where to find retirement planLooking for the UCPath field in EAH.
Question - What is the status of the column group for EAH-LLSalaryFringe-AllStill in progress



Ui expand
title2020-12-15 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/20201215%20Employee%20COP?csf=1&web=1&e=WYQYJh

SubjectContent
SubjectContent
SubjectContent



Ui expand
title2020-11-17 Employee Analytics COP

Time Tracking:  ACOP-169

Attendees: 18 people

Recording:  https://ucsdcloud-my.sharepoint.com/:f:/g/personal/jmwhite_ucsd_edu/Eha_VEb7iTxFhiLLjgK6tA8BnTkTcYVseRfRNbSlUaomZQ?e=cHxdaf

Question - When will distribution % be available?Currently still in development, no ETA at this time.
UCOP UCPath ReportsCan UCSD get access to UCOP UCPath Reports
Question about LL views

See security updates here:  EAH Security Technical Implementation Details

Where do I find the new DOPEs report?

reports.ucsd.edu

UAT due Thursday 11/19

Items in UAT: 20201113 EAH Start UAT Release Notes

Future enhancements: EAH Bugs and Enhancements In Progress

How to request a column group?

If you do not have a report, you can use the template found here:  /wiki/spaces/AH/pages/12487881

If you have a report already built, please send us that.



Ui expand
title2020-10-20 Employee Analytics COP

Time Tracking:  ACOP-169

Attendees:  21 people

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

FTE Funding %

Start in EAH-PositionFunding-View

There is no field to provide this information, it has to be calculated.

FTE In Progress

In progress:  Anna Nordeen working with ITS-BIA to create a compensation rate for employee per funding (Fin Unit, Fund, Function, Project, Task)

Requires using EAH and FINAH together.

From EAH-PositionFunding-View

  • Employee ID
  • Position
  • Position Funding Earnings Type Code
  • Position Funding CCOA Project
  • Position Funding CCOA Task
  • Position Funding Budget Sequence Indicator
  • Position Funding Budget Sequence Number
  • Job Compensation
  • Job FTE
  • Position Funding Distribution Percent
  • Employee Status = Active
  • HR Status = Active
  • Position Funding AsOf Indicator = Current
  • Position Funding Effective Sequence Indicator = Maximum

Still working through exceptions.  IE, over the cap amount, need to filter out blank earn codes.

This is the high-level formula that we are basing our work-in-progress derived FTE field from (Position Funding View in the EAH):

((Position Funding Distribution %/ SUM of Position Funding Distribution %)* Job FTE)

Again, there are nuances like the unused blank earn codes, effort bearing earn codes, OTC earn codes, etc that we are still working to hammer out. Hopefully we can share soon once we tie this effort out.

Where do you find faculty funding over time?

Goal:  build a report of faculty who were teaching summer session

Changes:  change from EAH-Workforce-View to EAH-LLSalary-View to see what has already been paid out.

Galina will follow up with Andy and Anna.

Where do you find stipends?

Andy:  Currently we don't bring in the additional pay into the EAH-PositionFunding-View, we have a separate EAH-AddlPayDetail-View.  Both are in the EAH-LLSalary-View for after the values are paid out.  Recommend bringing in the Position Funding Earning Type Code with history to see the rows but this will not bring in the $$.

Marcela will put in a request to join the EAH-AddlPayDetail-View with EAH-PositionFunding-View.

UC know issue for hire date.

Adrian Petersen:   There is a known issue with Employee Original hire date data in the EAH for some employees. I spoke with Kelly Maheu and David Mandell about it. I guess it's a known, although not by many people, issue that UCI and UCLA are also aware of and have had to create work-arounds in their reports. I'm not sure if anyone else has found this as well.

It is a manual calculation inserted into the report that looks at the minimum employee original start date for that employee. The issue has only been identified so far with Summer Session job code appointments.  So the primary job code has the correct date but the summer session appointment does not.  I've only noticed this with Summer Session Faculty job codes so far.



Ui expand
title2020-08-18 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/20200818%20Employee%20COP?csf=1&web=1&e=HvQKtV

SubjectContent
SubjectContent
SubjectContent



Ui expand
title2020-07-21 Employee Analytics COP

Time Tracking:  ACOP-169

Recording:

AnnouncementCognos Packages and Tableau Data Sources that were used for UAT will be deleted on Wednesday 7/22 morning.  If you have not re-pointed your report at the production
Question:  Is there an Appointment Hierarchy?Look under Employee Class
Question: What field do you use to group employees into 'Academic', 'Faculty', etc?

CTO and Employee Class

Employee Class

Question:  Where can we find field definitions?/wiki/spaces/AH/pages/12487881 > Employee Activity Hub FCVs and Fields > Open the drawer for "Employee Activity Hub available data - view summary".  In the drawer you can use the link for 'Glossary for UC Path' to see what UCOP has provided UCSD or you can click on "Crowd Sourced Map between PPS and EAH"
Question:  Where can we find the HR/Payroll reports if we want to modify them?
  • You can email UCPathreports@ucsd.edu to request an enhancement to any of the HR/Payroll reports found on reports.ucsd.edu and cc David Mandell and Brian Lorentz.  If HR/Payroll decides the enhancement works for the entire campus then the report will be updated.  If not, HR/Payroll can share the report with you via Cognos DEV > Business User Development > Communities of Practice Shared Development
  • In general, the report owner will need to share a report with you.  Access is not automatically give for all developers to make copies of other developer's reports.
Question:  Is there a distribution % based on chart string elements instead of distribution % on earn code?

Brian Lorentz = payroll does more of that than HR does.

Shiela Carlson = Will follow up with Nini and Pearl.

Question: Can we get a member of payroll on the Employee COP Calls?Sarah will reach out to Sheila Carlson
Question: Does anyone have a report to compare department data to campus wide data?

How can we show all campus vs department?

Sarah:  yes, submit a ticket to busintel@ucsd.edu and we can create calculated fields for the entire campus that would be the denominator for % calculations and would remain the same separate from security.

Question: Is the new Manager Flag using the same logic as the Supervisor report?Sarah & Andy:  Yes.  The Manager Flag is looking to see if the employee is listed in the "Reports To" field.  The Supervisor report is showing the person in the "Reports To" field.
Question: How do you see an Inactive person with a UCPath record?Recommend using HR Status field.  Will need other fields if you are looking for why they are inactive.
Question: Where should we send new developers that have lots of business questions?Recommend using EAH-Workforce-View to start and then move to other views as needed.  Also recommend providing more guidance and training around EAH-Workforce-View.



Ui expand
title2020-07-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/20200714%20Employee%20COP?csf=1&web=1&e=fzwFJF

LL Employee 
  • Cognos Filters, grouping and distinct explained and demonstrated



Ui expand
title2020-07-07 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/20200707%20Employee%20COP?csf=1&web=1&e=pOUEWq

Security Announcement
  • BIA has been requested to implement security on EAH such that only UCPath Transactors will be able to see UCPath data for what they are transacting upon
  • All others will need to fill out the UCPath Cognos Reports Access Request and specify the data they need
  • BIA will implement the new security into Hana QA, Tableau QA and Cognos DEV
  • You will have a week to test the new security before BIA moves it into Hana PROD, Tableau Prod, Cognos QA and Cognos PROD
  • You will also have this time to request additional access to UCPath data via EAH
Security Questions
  • Will I be able to see people who are not 100% in my department?
  • Answer = Yes.  If a person is in your requested area, even at less then 10%, you will see all of their positions and jobs as part of your requested data.
  • When will the form be ready?
  • Answer = The form will be ready by the end of the week, right now the UCPathReports team is adding some text to make instructions more clear.
  • When will prod be updated?
  • Answer = One week after we implement the new security into Hana QA, Tableau QA and Cognos DEV.
  • What if we need access to everything?
  • Answer = You can fill out the UCPath Cognos Reports Access Request and request 'University' access
  • What about when using blended data?
  • Answer = If you use EAH in your report the type of join you use in your report will drive what the consumer will see.  If you use an inner join then the user will only see data based on their approved UCPath data.  If the consumer has no access to UCPath then they will see nothing in your report.  If you use a left/right join or outer join the consumer will see their UCPath approved data + all of the other activity hub.  If the consumer has no access to UCPath then they will see blank data in the EAH fields and only the other activity hub.
  • How does this affect people who run the reports?
  • Answer
  • Will there be any views that do not have security applied?
  • How will clients get access? 
  • Answer = They will need to fill out the form or you will need to fill it out for them.
  • How is the form routed?
  • Answer = 1) goes to your supervisor, 2) data steward, 3) ITS for physical addition to the exception table.  Can email UCPathReports@ucsd.edu after 48 business hours to see if your request is stuck.
  • What are the transaction roles?  How do I know if I am one?
  • What about new hires who don't currently have access?  What forms to they fill out?
  • What do report developers need to fill out?
  • What do report consumers fill out?
Security Questions - Data Integration
  • How will this impact the data integration folks? 
  • Scenario:  Machine to machine using API = API can use the generic account, one of the parameters passed should be the AD account of the person in the application, this parameter will engage the security.  When the API pulls there needs to be a WHERE clause to identify the person in the application.
  • Scenario: Machine to machine using Nifi = Nifi can use the generic account and target application is expected to set the appropriate security.  Example: Batch Jobs
  • Mindy Peng - Please set up a meeting with Jonathan Whitman, Judy White, Sowmya Sekar, Say-Ho Tan and Russia Madden regarding APIs and security.  Sarah Parnell optional.
  • Mindy Peng - Please set up a meeting with Jonathan Whitman and Judy White regarding the future of Nifi.
Security Use Case
  • How will people look up salaries across campus for grant application? May be needed within 24 hours for turn around.  Consumer would need to see the title and salary in order to fill out their grant application.  Consumer would need access to all of campus.
  • Answer = Consumer would need to request 'University' access via the UCPath

Security Use Case

  • What about people that process Direct Retros...is that considered a transact role that gets access by default? Or do they have to request access?
  • Answer = Saparnell will ask PMBI if this is a transactor role and how users will know if they are transactors.
Common Data
  • Department Hierarchy
  • VC Area
  • CCOA
  • EAH-Role-View
How to get a data integration set up?



Ui expand
title2020-06-30 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/20200630%20Employee%20COP?csf=1&web=1&e=CddgaI

SubjectContent
SubjectContent
SubjectContent



Ui expand
title2020-06-23 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/20200623%20Employee%20COP?csf=1&web=1&e=OHwSD5

Can you confirm that IDENTITY_EMAIL_ADDRESS is ultimately sourced from affiliates_dw.affiliates_safe_attributes.vanity_email_long?

Lori: 

It comes from VANITY_EMAIL_LONG, but if that's null then it uses VANITY_EMAIL_EMAIL and yes, both are from affiliates_safe_attributes

Can you talk about the new security rules coming for EAH?

  • By default, users will see only the department they belong to.
  • Report developers can request additional departments as an exception via a form to come soon.
  • Report consumers can request additional departments as an exception via a form to come soon.
  • You can request additional departments for other people if they are unable or unwilling to fill out the form
  • If you see a person in the department, then you do see everything about that person, even if they work for another department at the same time

Is there a way to join EAH and SAH data?

In progress:  EAH Bugs and Enhancements In Progress

Enhancements to add Identitify fields like Student PID and Instructor PID.

Is there a source for ALL potential codes regardless of whether UCSD is currently using that code. It helps to know sometimes what codes exist as options but are not currently being used. It's the missing codes, the ones UCSD isn't currently using (if they exist).  For example Employee Class Code / Employee Code.

EAH-JobCodeSalaryPlan-View has all Job codes.

EAH-DepartmentHierarchy-View has all Departments.

EAH-Position-View has all Positions.

Would need to know what other codes you are interested in seeing.

Are there any upcoming changes to EAH?


BIA is removing fields that have been indicated as unnecessary, redundant, confusing or not being used at UCSD at this time.  This will make help focus EAH on critical fields.  Fields will be removed from the views but not from EAH, so we can bring the fields back whenever needed.

BIA is looking through reports published to Tableau QA, Tableau Prod and Cognos > Team Content to see if we have broken anyone's reports.  We cannot see what is saved to your desktop or in your Cognos > My Content area.  We don't want to break any reports so we don't want to remove something that people are using.

Will there be a document that has these duplicating fields grouped?

We can create one and make it available to EAH developers.

who should we contact if we found payroll transaction errors? in my case, faculty payroll index BIOFEXC (special index for this one non-BIO faculty) has vacation reimbursement Acct 611850, and the UCRP supplement assessment interest was much higher than the monthly charge from July to April.


Is the data coming from EAH matching UCPath?

Email UCPathReports@ucsd.edu or Shelia Carlson
smcarlson@ucsd.edu on the payroll team.

In the Column Group 'EAH LL Salary All', I am getting column 'LL_Salary_CCOA'. Could you describe each of the segments that make up this chart string?

If the following two segments are not part of the existing chart string, can you add these two or let me know how I can get to them if they already exist in the labor ledger data?:

a. --PRODUCT (Char 6) --> OFC_Task (PPM)

b. --CHARTFIELD2 (Char 10) --> OFC_FundingSource(PPM)

This was given to BIA by the FIS team but we do have a document we can share.

Segment

UCPath Chartfield

CCOA Label

Length

1

OPERATING_UNIT

CCOA_Entity_Code

5

2

FUND_CODE

CCOA_Fund_Code

5

3

DEPTID_CF

CCOA_FinU_Code

7

4

ACCOUNT

CCOA_Account_Code

6

5

CLASS_FLD

CCOA_Funct_Code

3

6

PROGRAM_CODE

CCOA_Program_Code

3

7

CHARTFIELD3

CCOA_Location_Code

6

8

PROJECT_ID

CCOA_Project_Code

7

9

CHARTFIELD1

CCOA_Activity_Code

6

https://esr.ucsd.edu/projects/fis/ccoa/index.html

Send Isabella Parkingson an email if you would like access to her CCOA tool.

I actually have a quick question as a follow-up to snapshots? If we want to show who was added or let go in the month, can we use EAH?  We are currently using Job Actions.

EAH-Workforce-View > Job Action Information would be the way to go

I have another quick question - is there a way to see future hires? Our departments have grad students starting at a future date but already entered in the system, but it would be great to see them in our funding report before there start date. (Marcela Alvarez)

There are no filters set to prevent future data from coming in.  If you see data in UCPath that is not in EAH please email us the examples at busintel@ucsd.edu.



Ui expand
title2020-06-19 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/20200619%20Employee%20COP?csf=1&web=1&e=TLSn7B

Recreating a snapshot report using AsOf FieldsHow To Do Snapshot Reporting with AsOf Fields
Cognos Traininghttps://blink.ucsd.edu/technology/bi/tools/cognos/training/index.html
CCOACommon Chart Of Accounts

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?

EAH is currently waiting on Oracle.  We won't load any Oracle test data into EAH b/c we don't want to create confusion.

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.

There was a lot of effort put into the names to make them as clear as possible but we are seeing that users are having a hard time converting from the old 'appointment' names to the new 'job / position' names.  Please let us know if there is any documentation, training or road shows we can put together to help your users adapt to the new names coming from UCPath.



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

The Position Funding view has all the records going back for all fiscal years. To see what is the current of Position Funding, we will need the filter.

The minimum amount of filtering that will be required to return the current or top row of Position Funding view.

  • Position Funding AsOf Indicator =Current
  • Position Funding Budget Sequence Indicator = Maximum
  • Position Funding Effective Sequence Indicator = Maximum
Sample Report Data Fields

Create a sample report using the Position Funding Effective Sequence Indicator =Maximum as filter and include the following data fields from Position Funding View.

  • Employee ID and group this data field
  • Position Funding AsOf Indicator = Current and group this data field
  • Position Funding Effective Sequence Number 
  • Position Funding Effective Sequence Indicator = Maximum
  • Position Funding Budget Sequence Number sort descending
  • Position Funding Budget Sequence Indicator
  • Position Funding CCOA
  • Position Funding Earnings Type Code
  • Position Funding Distribution Percent

The sample report is able to express distribution per earning type per UC Path.


Key Distinction for Distribution Percent between Positing Funding View and LLSalaryDetail View

Position Funding View - Planned position funding distribution for the future. 

LLSalaryDetail View - Actual distribution for the past.  It has the monetary amount associated with distribution and the user can summarize and formulate the actual distribution percentage that the user is looking for.  This is also the view that drives DOPES report that UC Path version has been released

User has question on how to view the split funding for the financial unit function for the single employee?Add the FTE data field to the report from the LLSalaryDetail View and user has question on the FTE data field and Position Funding Distribution Percent.  Andy is going to send user with more documentation and the group will continue this discussion from the beginning of next session.



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

Document that can see all EAH fields in all EAH views at once

  • The document link is at /wiki/spaces/AH/pages/12487881. The user can scroll down to the "Employee Activity Hub FCVs and Fields" to use a link that is titled “How to see all EAH fields in all EAH views at once”
  • The Employee Activity Hub FCVs and Fields link is also available at the Employee Community of Practice collab page at Analytics Community of Practice (ACP) Home
  • This link "Employee Activity Hub FCVs and Fields" is to show every view in EAH for every data field. Please note that this package as shown on the above link has no pre-joins to it so user should not build report from it.  This is a useful resource to search data fields within EAH views. Please follow the instruction on collab page on how to search the data fields in EAH views.


General Question on how to set up folder and permission in Cognos?User can email to busintel@ucsd.edu and a ticket will be created for BIA team.  The BIA team can set up the folder outside the Business User Developer area and that will be specific to the user's team area and consumer can see it in the report.  The user can decided whether they would like their consumer to see the report in Cognos DEV or Cognos QA.
How to migrate the reports to Cognos QA?User can email to busintel@ucsd.ed and the team can set up the migration process from Cognos DEV to QA or Cognos DEV to PROD.
How to access the link in collab without opening a separate window twice?User is trying to avoid double action of going to the Collab site twice, In general it would be ideal for Collab sites if it keeps the original window and launches the user to a new window so both windows are up.  The workaround is to right click the link within collab page and select open the link in the new window and it will open up another window.
UC Path Reports

UC Path reports can be found at https://reports.ucsd.edu

Ask user to email UCPathreports@ucsd.edu for more information

EAH Enhancements Request

EAH Enhancements in Progress lini is at EAH Bugs and Enhancements In Progress  We try to transparent on what we are working on and customer can provide us with the feedbacks.

Please email EAH Enhancements Request to busintel@uccsd.edu and the BIA team will contact you to gather requirements and screenshots.

Position Funding ViewAndy: Position Funding view gets to set up in the beginning of HR lifecycle.  Funding is associated with position even before a person associated with it.  Position Funding is set up ready for next paycheck distribution funding to run.  It is not the payroll history in the position distribution view.  It is established the funding source associated with the position number with history in it.  The view is not necessary have all the employees in it because it is position centric view. This is the position centric view that really has current funding information and no payroll history.
LL Salary Detail ViewAndy: This is post payroll view that will start to accumulate. This view is for employee earnings distribution level granularity of their distribution happened to be for that pay cycle. This is directly downstream from a pay run and it should have all employees pay that occurred for whatever pay run that users are going after.
Row Level SecurityRow Level Security will be in place in July 1st.  If users need additional columns in the column group, user can email to busintel@ucsd.edu and make that request.
How to Not Aggregate the data field in Cognos?Select the data field and look into the properties of the data field, change the "Detail Aggregation" to None.
Is there a data field Annual Amount/Rage that associated with Salary Plan, Salary Plan Code, Salary Grade and Salary Grade Code?Andy:  There is a view that has entire salary structure and no people in it and the view is titled "EAH-JobCodeSalaryPlan".
Status of PPS appointment start dateAndy:  The previous meeting had question about the PPS appointment start date and this is corrected in the system in production.



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


...