EAH-Compensation-View Quick Start Guide

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.