Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Want to see a prior session?  OneDrive > Tableau CoP

Time Tracking= ACOP-388

2024-10-16 - Cancelled

2024-09-18

Topic

Notes

Reminder

All sessions are recorded and saved to the OneDrive link above.

How to find specific rows in EAH-Workforce-View?

EAH-Workforce-View Quick Start Guide

Name vs Name Current

For Name fields, Current and non-Current will always show the same.

AH Name fields show Lived Name as of Today (midnight) when the Lived Name is provided. If there is no Lived Name provided then the Legal Name will be displayed. This is true for all AHs and all Person Name Fields (First, Middle, Last, Display, Full).

There are restricted views that show Legal and Lived name at the same time but the data steward must approve and grant you access. Email busintel@ucsd.edu for further information.

P4 Data = https://security.ucop.edu/policies/institutional-information-and-it-resource-classification.html

EAH Current vs As Of

Current = Today or Most Recent Value

As Of = the value seen on a specific date, use with the associated date field (history)

Job Action Effective Date

SAH Current, First, Term Based

Current = Today’s Term or Most Recent Value

First = First Term Enrolled/Admit/Accepted at UCSD

Term Based = the vales seen during a specific term (history)

EAH Questions?

Best place to get support is bah.ucsd.edu > https://bah.ucsd.edu/hr-payroll/index.html > Ask Question/Report Issue link

How to share Tableau twb files

Best Practice:

  • Shared drive location to save the .twb files

  • Team DEV folder on Tableau Prod so you can download anything in progress

AH Field List Report

https://tableau.ucsd.edu/#/views/ActivityHubFieldList/CoreViews?:iid=2

Check out the Core Views tab vs the Restricted Views tab

Search for a keyword rather than a full field name

Download the crosstab of data to see all the fields in a view

Restricted Views and P4 fields required additional approval for access, so while they are on the list you may not be able to see them

...