M-pathways Time and Labor Data Dictionary




старонка1/7
Дата канвертавання24.04.2016
Памер1.35 Mb.
  1   2   3   4   5   6   7
U-M Data Warehouse



M-Pathways

Time and Labor

Data Dictionary




Copyright  2007

The Regents of The University of Michigan


All rights reserved. This document may be reproduced or reprinted, in whole or in part, without permission as long as the above copyright statement and source are clearly acknowledged. This publication or any reproductions may not be sold. Copyrights, trademarks, and service marks referred to in this documentation are the property of their respective owners.
Michigan Administrative Information Services

University of Michigan

January 2007



Comments and Suggestions
Your feedback is very important to us. As an M-Pathways user, we encourage you to tell us what you like or dislike about this Data Dictionary. Your comments and suggestions will help us improve this and other M-Pathways documentation for you in the future.
Please email your comments and suggestions to mpathways.documentation@umich.edu. Thank you.


Contents



Time and Labor Tables Diagrams


1

Time and Labor Tables Description


8

Time and Labor Data Element Dictionary

10



Time and Labor Tables Diagrams

The Time and Labor Tables Diagrams illustrate the logical relationships among the various Time and Labor tables. A logical link (connecting line) between two tables indicates that there is a direct data relationship between the two tables. Physically, any tables with a common element can be joined. However, two tables with common elements may not necessarily have logical links to one another. Joining tables without logical links may produce undesired results; a thorough understanding of the data is needed to guarantee accurate results.


All tables within a data set are not necessarily refreshed on the same schedule. It is extremely important to query the status table to determine when the data in each table was last refreshed and to determine the impact this will have on query results.
Note: The Time and Labor Tables Diagrams are shown on pages 2 through 7.


















Time and Labor Tables Description

The Time and Labor Tables Description provides the following information for each table in the U-M Data Warehouse Time and Labor data set:




Physical Table Name

Name for the table you can use in SQL queries.

Logical Table Name

Descriptive name of the table.

Data Set Locations

The names of the data sets in which the table resides.

Table Description

Description of the table.

The tables are ordered alphabetically by table physical name.




Physical Table Name

Logical Table Name

Data Set Locations

Table Description

CALENDAR

Calendar

M_TLDW1

Information about calendar date

DEPT_BUDGET_ERN

Department Budget Earnings

M_HRDW1

Information about the distribution, across shortcodes, of job compensation, including overtime.

EARNINGS_TBL

Earnings Table

M_PYDW1

Information about how earnings are calculated and taxed

HE_DEPT_TBL

Higher Education Department

M_HRDW1

Historical characteristics of departments, such as department name. This table includes Human Resource specific information as well, such as benefit group and timekeeping system information.

HRMS_RPT_RECIPIENT

Human Resource Management Systems Report Recipient

M_HRDW1

The name and delivery address where a department's Human Resource Management Systems (HRMS) reports, such as gross pay register, and personnel reports, are delivered.

JOB

Job

M_TLDW1

Characteristics and history of employee jobs, such as begin and end dates and compensation rates. An employee can have multiple simultaneous jobs.

NO_VARIANCE_TBL

No Variance Table

M_TLDW1

Information about time periods when an employee had no deviation from their normal work schedule.

PAY_CHECK


Pay Check

M_PYDW1

Summary information of the outcome of the payroll confirmation process. It contains paycheck information by individual including pay period identification fields, name and total gross and net amounts.

PAY_EARNINGS

Pay Earnings

M_PYDW1

The standard regular earnings from Job Data.

PAY_ERN_DIST

Pay Earnings Distribution

M_PYDW1

Employees’ gross earnings distribution across shortcodes.

PAY_OTH_EARNS

Pay Other Earnings

M_PYDW1

All other earnings in addition to the standard regular earnings from Job Data.

TL_EMPL_DATA

Time and Labor Employee Data

M_TLDW1

Employee enrollment effective dates and employee status in time and labor reporting groups such as paygroup, workgroup, and taskgroup.

TL_EMPL_PGM

Time and Labor Employee Program

M_TLDW1

Information about employee’s program used to determine which leave program they will have for time off including eligibility dates and next renewal dates.

TL_GROUP_DTL

Time and Labor Group Detail

M_TLDW1

Information about specific employees assigned to a static group within time and labor.

TL_LEAVE_DATA

Time and Labor Leave Data

M_TLDW1

Information about employees’ time off usage, accruals, adjustments and balance, including near max and missing time flag information.

TL_LEAVE_PLAN

Time and Labor Leave Plan

M_TLDW1

Information about employee’s time off plans. For example: vacation, PTO, sick, extended sick, etc.

TL_LVACR_GRND

Time and Labor Leave Accrual Grandfathered

M_TLDW1

Information about employees who were grandfathered into existing time off plans. The term grandfathered means a change was made to a group of employees that affected their leave program and/or leave plans, and an exception was made for individual employees by using this grandfathered flag.

TL_MISS_TIME

Time and Labor Missing Time

M_TLDW1

Information about time not being reported for an employee for a given pay period.

TL_PAYABLE_TIME

Time and Labor Payable Time

M_TLDW1

Information about how employees will be paid for reported time after that time has been processed by Time Administration. This table contains data for the current month and the prior 24 months.

TL_RPTD_ELPTIME

Time and Labor Reported Elapsed Time

M_TLDW1

Information about how employees’ time was reported. This table contains data for the current month and the prior 24 months.

TL_TRC_TBL

Time and Labor Time Reporting Code Table

M_TLDW1

Information about Time Reporting Codes (TRC) including which matching earn code goes with the TRC.

TL_TSKPRF_DETL

Time and Labor Task Profile Detail

M_TLDW1

Information about time and labor task profiles including the distribution of funds for an individual including short codes and allocation amounts.

TL_WRKGRP_TBL

Time and Labor Workgroup Table

M_TLDW1

Information about groups of employees that have similar work rules, time reporting codes and holiday schedules.
  1   2   3   4   5   6   7


База данных защищена авторским правом ©shkola.of.by 2016
звярнуцца да адміністрацыі

    Галоўная старонка