EAH-ExtendedAbsence-View Quick Start Guide

This view contains employee extended absence types and dates.  Start here and then branch out if you are need finding the data you need.

Fields that make up the primary key:

  • Employee ID
  • Extended Absence Employee Record
  • Extended Absence Transaction Number

Key Fields to use as filters:

  • Extended Absence AsOf Indicator Code
  • Job Action Code - Values of LOA, PLA
  • Job Action Reason Code - Values of PDL, PER, MED, SFP, FSP etc.
  • Job Code = CONV are converted records that can be filtered out if not needed
  • Employee Status - 6 Values of Active Paid Leave of Absence, Retired, etc. 
  • Extended Absence Action
  • Extended Absence Reason
  • Extended Absence CFRA Eligibility
  • Extended Absence UC Reason
  • HR Status - Values of Active and Inactive
  • Union Code has values - Service, Technical, Academic Researchers etc.
  • FLSA Status has values - Exempt, Nonexempt