1. DARTS
  2. Data, Analytics & Reporting Technology Services
  3. UMS Index of Reporting Tables

DARTS : Human Resources Tables

Created by Corina C Larsen, last modified on May 14, 2021

The tables below are used across all functional areas using Human Resources data.  Click on the table to see the fields used.

Image of three generic people heads

  • ACCT_CD_TBL - Account Codes
  • ADDL_PAY_DATA - Additional Pay Detail
  • EMPLOYEES - Non terminated Employees
  • EMPLOYMENT - EE General Employment Data
  • HEALTH_BENEFIT - EE Health Benefit Elections
  • HR_GENDER_DAT - Gender Identity Staging Record
  • JOB - EE Job History
  • PAY_CHECK_EARNS - Pay Check Earnings
  • PAY_CHECK- Pay Check
  • PERSON_GENDER - Person Gender Details
  • PERSON_NAME - Current Primary Name View
  • PERSONAL_DATA - PERSONAL_DATA for Rpting (HR)
  • POSITION_VIEW - Posn Descr - Employment Titles
  • Recommended Tables for Reporting in HR
  • UM_CLS_SCH_FCL
  • UM_DISTRIB_TBL - Clone of DEPT_BUDGET
  • UM_EARN_ACCT_VW
  • UM_F_ANNUAL_DIS - Account Distributions
  • UM_F_EMP_CENSVW - Employee Census Table VW
  • UM_F_EMPL_VW - Employee Flat Table
  • UM_F_EMPLOYE_VW - Employee Flat Table
  • UM_F_POS_BUD_VW - view of Posi & Budget extract
  • UM_FRINGE_RATE - Fringe Percentage Rates
  • UM_PATFA_DTL
  • UM_PATFA_LOAD - Staging record to load PATFA
  • UM_PAYEARNS_VW
  • VALID_COMBO_TBL - Valid Combination Codes

You may also be interested in

Recommended Tables for Reporting in HR

Click the link above for a listing of the most frequently used tables



Icons designed by Freepik from Flaticon

Attachments:

network.png (image/png)

Document generated by Confluence on Dec 19, 2024 09:18

Atlassian