Human capital systems, analytics, and data mining

295 Pages·2018·42.94 MB·English

by  Hughes

Human Capital Systems,
Analytics, and Data Mining
Chapman & Hall/CRC
Data Mining and Knowledge Series
Series Editor
Vipin Kumar
Computational Business Analytics
Subrata Das
Data Classification
Algorithms and Applications
Charu C. Aggarwal
Healthcare Data Analytics
Chandan K. Reddy and Charu C. Aggarwal
Accelerating Discovery
Mining Unstructured Information for Hypothesis Generation
Scott Spangler
Event Mining
Algorithms and Applications
Tao Li
Text Mining and Visualization
Case Studies Using Open-Source Tools
Markus Hofmann and Andrew Chisholm
Graph-Based Social Media Analysis
Ioannis Pitas
Data Mining
A Tutorial-Based Primer, Second Edition
Richard J. Roiger
Data Mining with R
Learning with Case Studies, Second Edition
Luís Torgo
Social Networks with Rich Edge Semantics
Quan Zheng and David Skillicorn
Large-Scale Machine Learning in the Earth Sciences
Ashok N. Srivastava, Ramakrishna Nemani, and Karsten Steinhaeuser
Data Science and Analytics with Python
Jesus Rogel-Salazar
Feature Engineering for Machine Learning and Data Analytics
Guozhu Dong and Huan Liu
Exploratory Data Analysis Using R
Ronald K. Pearson
Human Capital Systems, Analytics, and Data Mining
Robert C. Hughes
For more information about this series please visit:
https://www.crcpress.com/Chapman--HallCRC-Data-
Mining-and-Knowledge-Discovery-Series/book-series/
CHDAMINODIS
Human Capital Systems,
Analytics, and Data Mining

Robert C. Hughes
CRC Press
Taylor & Francis Group
6000 Broken Sound Parkway NW, Suite 300
Boca Raton, FL 33487-2742
© 2019 Robert Clayton Hughes Jr. M.S.
CRC Press is an imprint of Taylor & Francis Group, an Informa business
No claim to original U.S. Government works
Printed on acid-free paper
International Standard Book Number-13: 978-1-4987-6478-0 (Hardback)
This book contains information obtained from authentic and highly regarded sources. Reasonable efforts have been made to
publish reliable data and information, but the author and publisher cannot assume responsibility for the validity of all materials
or the consequences of their use. The authors and publishers have attempted to trace the copyright holders of all material repro-
duced in this publication and apologize to copyright holders if permission to publish in this form has not been obtained. If any
copyright material has not been acknowledged please write and let us know so we may rectify in any future reprint.
Except as permitted under U.S. Copyright Law, no part of this book may be reprinted, reproduced, transmitted, or utilized in any
form by any electronic, mechanical, or other means, now known or hereafter invented, including photocopying, microfilming,
and recording, or in any information storage or retrieval system, without written permission from the Author.
For permission to photocopy or use material electronically from this work, please access www.copyright.com (http://www.copy-
right.com/) or contact the Copyright Clearance Center, Inc. (CCC), 222 Rosewood Drive, Danvers, MA 01923, 978-750-8400.
CCC is a not-for-profit organization that provides licenses and registration for a variety of users. For organizations that have
been granted a photocopy license by the CCC, a separate system of payment has been arranged.
Trademark Notice: Product or corporate names may be trademarks or registered trademarks, and are used only for identification
and explanation without intent to infringe.
Library of Congress Cataloging‑in‑Publication Data
Names: Hughes, Robert Clayton, Jr., author.
Title: Human capital systems, analytics, and data mining / Robert C.
Hughes.
Description: Boca Raton : CRC Press, 2018. | Series: Chapman & Hall/CRC data
mining & knowledge discovery series ; 46 | Includes bibliographical
references.
Identifiers: LCCN 2018011415 | ISBN 9781498764780 (hardback : alk.
paper)
Subjects: LCSH: Human capital--Management--Data processing. | Personnel
management--Data processing. | Personnel management--Statistical methods.
| Database management. | Data mining.
Classification: LCC HD4904.7 .H845 2018 | DDC 658.300285/57--dc23
LC record available at https://lccn.loc.gov/2018011415 [1]
Visit the Taylor & Francis Web site at
http://www.taylorandfrancis.com
and the CRC Press Web site at
http://www.crcpress.com
To Katharina and Emily

Contents
Preface, xvii
Author, xix
Trademarks and Copyrights, xxi
Chapter 1 ◾ Human Capital Management Systems 1
STATE OF AFFAIRS 1
POLICIES, SYSTEMS, AND CULTURE 2
PURPOSE AND DESIGN OF HUMAN CAPITAL MANAGEMENT SYSTEMS 4
COMPUTING ENVIRONMENTS 5
ON PREMISES, SOFTWARE AS A SERVICE, PLATFORM AS A SERVICE,
INFRASTRUCTURE AS A SERVICE, HYBRID 5
ADVANTAGES AND DISADVANTAGES OF CLOUD COMPUTING 6
ON PREMISES 7
SOFTWARE AS A SERVICE 7
PLATFORM AS A SERVICE 7
INFRASTRUCTURE AS A SERVICE 8
HYBRID 9
DEVELOPMENT, TEST, AND PRODUCTION ENVIRONMENTS 9
CLOUD/HOSTED SOLUTION CHALLENGES 9
Support 9
Performance 9
Customization 9
Security 10
SYSTEMS ACQUISITION AND DEVELOPMENT 10
NEEDS AND GAP ANALYSIS 10
SYSTEM SPECIFICATIONS AND REQUIREMENTS 10
VENDOR/SOLUTION TEAM SEARCH PROCESS 11
vii
viii ◾ Contents
DEPARTMENTAL COMPUTING 12
HCM Professional System Skills 12
CHAPTER SUMMARY 12
REVIEW QUESTIONS 13
CASE STUDY 13
REFERENCES 14
Chapter 2 ◾ Human Capital Management System Components 15
RELATIONAL DATABASE MANAGEMENT SYSTEM ORGANIZATION 15
EMPLOYEE BASE INFORMATION 15
Employee Profile 16
Rating 16
Management Level 16
Department 16
Location 16
PERFORMANCE MANAGEMENT 16
EEO Audit and Compliance 18
Position and Job Classification 18
Compensation and Benefits 21
Job-Related Database Tables 21
Job Level Table 21
Job Family 22
Occupation 23
Salary Grade/Band Related Tables 24
Structure Table 24
Region 24
Salary Grade/Band Table 25
Salary Range Table Built-In Calculation Options 26
Annual Range Data Elements 26
Salary Grade Range Data 26
Job Classification Table 27
Data Elements 27
Internal Compensation Target Table 27
Data Elements 28
Internal Staff Compensation Data Table 28
Contents   ◾   ix
Salary Survey Data Related Tables 28
Source 29
Data Elements 29
Data Status 29
Source Job Code 29
Adjustment Factors 29
Region 30
Sector 30
Variable Compensation Plan 31
SIC 31
Job Level 31
Geographic Responsibility Table 31
Competitive Survey Data Table 31
Survey Statistic Table 31
Salary Survey Statistical Analysis Components 32
Compensation Component Allocation Key Performance Indicators 32
Salary Survey Analysis Related Table Reports and Charts 32
Internal Salary Analysis Related Table Reports and Charts 33
Position Control 35
Talent Acquisition/Recruitment 36
Payroll 37
Benefit Plans 38
Departmental Computing 39
HCM Professional System Skills 39
CHAPTER SUMMARY 39
REVIEW QUESTIONS 39
CASE STUDY 40
REFERENCES 40
Chapter 3 ◾ Database Systems, Concepts, and Design 41
DATABASE SYSTEMS 41
RELATIONAL DATABASE MANAGEMENT SYSTEMS 41
RELATIONAL DATABASE MANAGEMENT SYSTEM TABLE STRUCTURES 42
Database Normalization 42