EAH-Compensation-View Quick Start Guide

This view contains components of an employee's base pay. This is a child of the JOB record.  Start here and then branch out if you are need finding the data you need.

Fields that make up the primary key:

  • Employee ID
  • Employee Record
  • Job Action Effective Date
  • Job Effective Sequence Number
  • Compensation Effective Sequence

Key Fields to use as filters:

  • Job AsOf Indicator Code
  • Job Effective Sequence Indicator Code
  • Job Indicator
  • Organizational Relationship
  • HR Status - Values of Active and Inactive
  • Employee Status - 6 Values of Active Paid Leave of Absence, Retired, etc. 
  • Job Action has values - Hire, termination, Position Change etc.
  • Job Action Reason has values - Academic Students, Permanent IncreaseIn Time etc..
  • Compensation Rate Code
  • Employee Class - Values of Academic, Staff, Student etc.
  • Salary Grade has values - Professor, Assistant Professor, Technical Assistant etc.
  • Salary Plan has values - RX Salary Plan, Career Tracks etc.
  • Job Compensation Frequency has values - Hourly, Monthly etc.
  • Compensation Rate Code has values - UCPDMO, UCANNL etc.