FINAH-ProjectPersonnelRole-View Quick Start Guide

This view is to see what person role relationship for a person is related to.

Data Loads:

Data is loaded each night.  To see when the data completed being loaded by UCSD into FINAH see this report: Tableau > Public > AH Data Load Status Report

Granularity:

Granularity is the scale or level of detail present in a set of data.  It identifies where levels of uniqueness exists in the data.  The data lives in the view at the lowest level, but each BI tool totals the levels differently.

1st Level: Person Employee ID

2nd Level: Person Role

3rd Level: Person Role Relationship 

4th Level: Person Role Start Date Time


Key Fields:

  • Person Employee ID
  • Person Role
  • Person Role Relationship 
  • Person Role Start Date Time

Key Fields to use as filters:

  • Person Role
  • Person Role Relationship 
  • Person Role Start Date Time


The following is a link to a knowledge base article with definitions of roles in Oracle (OFC)

https://support.ucsd.edu/finance?id=kb_article_view&sys_kb_id=4272ad2ddb23a410d4781c7913961935