# M-pathways Time and Labor Data Dictionary

 старонка 1/7 Дата канвертавання 24.04.2016 Памер 1.35 Mb.
##### 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

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.

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.