HCM DataMart Business Requirement



Requirements DocumentforHCM DataMartERP Business Transformation Program ‘Zeus’People and Talent & Payroll DepartmentVersion 1.0Prepared by: DCWTable of Contents TOC \o "1-3" \h \z \u Document Revision History PAGEREF _Toc25750884 \h 11.Introduction PAGEREF _Toc25750885 \h 41.1.Purpose PAGEREF _Toc25750886 \h 41.2.Document Conventions/Acronyms PAGEREF _Toc25750887 \h 41.3.Intended Audience PAGEREF _Toc25750888 \h 42.General Description PAGEREF _Toc25750889 \h 42.1.Product Perspective PAGEREF _Toc25750890 \h 42.2.Business Requirements PAGEREF _Toc25750891 \h 42.3.Assumptions & Dependencies PAGEREF _Toc25750892 \h 63.Infrastructure Requirements PAGEREF _Toc25750893 \h 73.1.Overview PAGEREF _Toc25750894 \h 73.2.Clients PAGEREF _Toc25750895 \h 73.3.Servers PAGEREF _Toc25750896 \h 73.working Equipment PAGEREF _Toc25750897 \h 73.5.Peripherals PAGEREF _Toc25750898 \h 74.Detailed Requirements PAGEREF _Toc25750899 \h 74.1.User Classes & Characteristics PAGEREF _Toc25750900 \h 74.2.Application Features PAGEREF _Toc25750901 \h 84.3.Data Elements details PAGEREF _Toc25750902 \h 84.3.1.Payroll PAGEREF _Toc25750903 \h 84.3.2.Timesheet PAGEREF _Toc25750904 \h 94.3.3.People and Talent (HCM) PAGEREF _Toc25750905 \h 104.4.Security Requirements PAGEREF _Toc25750906 \h 124.5.Interface Requirements PAGEREF _Toc25750907 \h 124.5.1.User Interfaces PAGEREF _Toc25750908 \h 124.5.2.Interfaces To/From Other Systems PAGEREF _Toc25750909 \h 234.6.Nonfunctional Requirements PAGEREF _Toc25750910 \h 234.6.1.Accessibility Requirements PAGEREF _Toc25750911 \h 234.6.2.Audit Requirements PAGEREF _Toc25750912 \h 234.6.3.Availability Requirements PAGEREF _Toc25750913 \h 234.6.4.Backup & Recovery Requirements PAGEREF _Toc25750914 \h 234.6.5.Capacity Requirements PAGEREF _Toc25750915 \h 244.6.6.Maintainability Requirements PAGEREF _Toc25750916 \h 244.6.7.Performance Requirements PAGEREF _Toc25750917 \h 244.6.8.Usability Requirements PAGEREF _Toc25750918 \h 244.6.9.Redundancy Requirements PAGEREF _Toc25750919 \h 24Approvals PAGEREF _Toc25750920 \h 25Appendices PAGEREF _Toc25750921 \h 26Appendix A: Reports Output PAGEREF _Toc25750922 \h 26Works Cited/References PAGEREF _Toc25750923 \h 30IntroductionPurpose DC Water is currently undergoing a major business transformation initiative by implementing Oracle ERP Cloud Fusion Applications suite replacing legacy tools, systems and applications (Lawson – financial, Procurement- Zycus, HCM/Payroll/Time – Ceridian Dayforce, Latitude, SourceTime Pro, Learning Management System – Cornerstone, Applicants Tracking System-Evolve, Licenses and Certifications- Fleetwave) that are currently used to support a variety of operational business reporting functions in the areas of financial, human capital and supply chain management.DCW plan is not to migrate all the historical data to the new Oracle ERP System but only the minimum data required as per the company or legal compliance whereas the historical data will be stored in an enterprise data warehouse. Specifically, for this requirement, DC Water is currently looking for developing an enterprise data warehouse based on historical data from Ceridian Dayforce, Cornerstone, Evolve, Latitude (HPL), SourceTime Pro and Fleet wave. Document Conventions/Acronyms DCW – District of Columbia Water and Sewer AuthoritySME – Subject Matter ExpertIntended Audience This document is intended for, such as enterprise architects, functional consultants, developers, project managers, users, testers, and documentation writers.General DescriptionProduct Perspective Business RequirementsReq. #DescriptionPhase/CommentBR-01Consolidate historical data from below source systems: - 1. Ceridian Dayforce (Version 57) 2. Cornerstone (Version 19.4.0.13)3. Evolve (SQL Data backup available)4. Latitude (HPL) (Version 3.9)5. Fleet wave (Version 2.38)6. SourceTime Pro (Version 6.60.38)Normalize and consolidate the data from above source systems into a single DataMart.Phase 1BR-02Develop web user interface (reports & dashboards) allowing Employee Self Service and administration by HCM Administrators (Payroll, Time & Labor, Core HCM System, Benefit, Succession, Goal and Performance, Learning and Development, Recruitment, Superadmin)Phase 1BR-03Authentication and access control will be tied to DC Water’s Active Directory (AD) using Single Sign On (SSO). Data should be encrypted while loading in the DataMart and decrypted while accessing with the proper authenticated roles. Phase 1BR-04Employee should be able to access Web application and can view key reports based on predefined parameters (downloadable to excel sheet and PDF formats as applicable). Refer Appendix A to see the layouts of each of the key reports.Phase 1BR-05Access Roles for: EmployeeAdministrator (s)PayrollTimekeeperFinance userManagerCore HCM SystemsBenefitsGoal and PerformanceLearning and DevelopmentLabor and ComplianceCompensationSuperadminWrite accessProvision Security accessPhase 1BR-06Mapping above roles for accessing specific reports as per role (User Interface Section)Phase 1BR-07Deploy to DC Water defined environment (e.g. Azure) and TestingPhase 1BR-08After the initial implementation of data mart from all the source systems, data transfer from the source systems should be able to periodically update or a full load to DataMart till the Oracle Cloud HCM go-live (planned April,2021).Phase 1BR-09Develop Training material and provide training to DCW on how to use the Web Application to access reports or PDF layouts for employees and administrators.Phase 1BR-10Ongoing regular sync from Oracle Cloud HCM (once it is live, planned for April,2021) into Data Mart. Data transfer from Oracle Cloud HCM to Data Mart should be done periodically (preferably weekly and should have an option to do adhoc manually also) Phase 2Assumptions & Dependencies DCW has approximately 1200 active employees but based on the future growth and to keep historical data for the inactive employees also due to legal compliance reasons, assume the employee base of approximately 1500 active employees till the Oracle ERP Cloud in April,2021.DCW Azure SQL Database will hold the Data Mart. Vendor will be provided the tenant access of DCW Microsoft Azure.No real-time transactions will be done in the consolidated DataMart and will be kept only for read and view access. In case needed few key resources (Superadmin) should have the access to update incorrect plete Data Extract from source systems (Ceridian Dayforce, Cornerstone) will be provided to the Vendor or access to these systems will be provided to the selected vendor. Vendor needs to provide their approach in their solution proposal. DCW will provide SQL data backup for Evolve and Latitude (HPL).Type of data available in the systems: -Core HR, Benefits, Payroll, Time and Labor: Dayforce and Latitude (HPL)Succession, Performance and Learning: CornerstoneApplicant Tracking: Dayforce and EvolveLicenses and Certifications: FleetwaveTimeSheet History: SourceTime ProData availability/access type from the systemsDayforce – Data Backup or via Reports (DB Size: 35GB)Cornerstone – Data Backup or via Reports (DB Size: <10GB)Latitude (HPL) – SQL Server Data Backup (DB Size ~ 7 GB)Evolve – SQL Server Data Backup (DB Size ~ 2GB)Fleetwave – Data extract via Reports (DB Size: <1GB)SourceTime Pro – Data extract via Reports All the above systems (except Fleetwave) are planned to be replaced by Oracle ERP Cloud in April,2021. PayrollPaycheck history Jan,2000 till April,2021 (approximately 21 years)Pay check history in Latitude (HPL): Jan 2000 - March 2018 (18 years)Pay check history in Ceridian Dayforce: April,2018- April,2021 (3 years)Payroll reporting - capture report gross to net, with filtersPayroll reporting - custom PDF report generation and/or Excel. Also, need Dayforce W-2s/W-2Cs for 2018, 2019 & 2020. (FYI, SeeMyW2 system has this till 2017 and it is accessible to administrators currently so there is NO need to do anything with SeeMyW2 as far as scope of this document is concerned).Time and Labora. All timesheet records since 7/26/15 in DayForce. SourceTime Pro system has the timesheet records prior to 7/26/2015 b. PDF report generation – TimesheetsPeople and Talent Managementa. Some key reports will be generated in Excel or PDF layouts 11. After the implementation of data mart from all the source systems, kindly ensure that the data transfer from the source systems (Ceridian Dayforce and Cornerstone) should be periodically transferred (preferably monthly and option to have it adhoc manually) to DataMart till the Oracle Cloud HCM go-live (planned April,2021).12. Vendor should have good knowledge of the data elements of above source systems as DCW Process SMEs will not have much bandwidth to explain in detail about these systems fields)13. Ongoing regular sync from Oracle Cloud HCM into Data Mart. Data transfer from Oracle Cloud HCM to Data Mart should be done periodically (preferably weekly and should have an option to do adhoc manually also). DCW is considering this particular requirement as a part of phase 2 requirements, so need the efforts, timelines and cost to take the decision whether to implement this requirement or not. Infrastructure RequirementsNoneOverview N/AClientsN/AServers N/ANetworking Equipment N/APeripherals N/ADetailed RequirementsUser Classes & Characteristics There are three types of high level User Groups: -Employees [User base: 1500]Administrators Payroll [User base: 10]Time and Labor [User base: 250] (includes the admin/timekeepers-40, finance users-10 and Managers-200)Core HCM Systems [User base: 10]Benefits [User base: 10]Goals and Performance [User base: 10]Learning and Development [User base: 10]Recruitment [User base: 10]Superadmin [User base: 5]Application Features The application should be self-contained DataMart which allows end users to access data via reports on dashboard as per their specific roles assigned.Data Elements detailsFollowing data needs to be exported to a consolidated DataMart to be accessed later whenever needed. Below are some major data types/elements but it’s not the exhaustive list as complete data backup will be provided.Payroll IDField NameDescriptionPayroll001Pay Date002Pay Period – Start003Pay Period – End004Check Number005Deposit Advice Number006Employee Name007Employee Number008Employee Address009Base Pay Rate010Employee Department011Employee Job012Federal Filing Status013State Filing Status014Federal Exemptions015State Exemptions016Federal Addl Tax Adjustment017State Addl Tax Adjustment018Hoursmultiple columns for each type019Pay Ratemultiple columns for each type020Amountmultiple columns for each type021Taxable Benefitsmultiple columns for each type022Pre-Tax Deductionsmultiple columns for each type023Taxesmultiple columns for each type024Post-Tax Deductionsmultiple columns for each type025Net Pay026Direct Deposit Account(s)multiple columns for each type027Check Amount028YTD – Hoursmultiple columns for each type029YTD – Earningsmultiple columns for each type030YTD - Taxable Benefitsmultiple columns for each type031YTD - Pre-Tax Deductionsmultiple columns for each type032YTD – Taxesmultiple columns for each type033YTD - Post-Tax Deductionsmultiple columns for each type034YTD - Net Pay035Sick Balance036Sick Accrued037Annual Balance038Annual Accrued039Personal Balance040Personal AccruedTimesheetIDField NameDescriptionTimesheet001Date002Employee Number003Employee Name004Employee Department005Employee Location006Employee Job007Pay Code Namee.g. Regular, Vacation etc.008Hours Amount?009Earnings Amount?010Actual/Rounded Punch Timerounded time011Scheduled Work Time?012Raw Punch Time?013Time Clock Name?014Project Code?015Warningse.g. Arrived-Late, Arrived-Early, etc.016Approver Name?017Date and Time Approved?People and Talent (HCM)IDField NameDescriptionStatus Record001Status Reason002Employment Status003Employee ID004Salary005I-9006Manager007Labor codes008Date of Termination009Seniority date010Recent hire date011Union affiliation012Licenses and certifications013Next Step increase014Original DoH (or rehire)015Eligibility for Re-hire016Pay Class017Essential Status018Comp ReasonEmployee personal information019Confidential EEO- Gender, race, Veteran, Disabled020Address021Phone022Email023DOB024Marital status025SSN026Emergency contactsWork Assignment027Assignment of employees to particular jobs/positions028Work assignment and reason029Business Title030LocationJobs/Positions031Job & Positions table032Job Title033EEO 4034PCN035FTE036Paygrade037Required license and credentials038DepartmentAbsence Management039Leave accruals040Leave BalancesBenefits041Benefit elections042Dependent and Beneficiaries043benefit deductions044Plan Types045Benefit plan tablePayroll046Deductions047Earnings048Hours 049Benefit arrearsApplicant Tracking050Applicant information (personal, experience, skills, education, work history)051Applicant pools052Requisitions052Resumes053ApplicationsLearning054Employee training profiles (curriculums), materials, videos, ILT training, online course055Employee Transcripts056Education Application and outside training request forms057Listing of completed courses with dates058Training Profile tied to JobSuccession059Ratings and Successors060Employee Talent profile (skills, attributes, education, work history, training, courses, etc...)Goals & Performance061Overall performance rating062Goals and competency scores (finals and interim)063Employee goalsLabor Relations and Compliance064Equal Employment Opportunity Commission (EEOC) charges and complaints065Grievances066Disciplinary actionsSecurity RequirementsAuthentication and access control will be tied to DC Water’s Active Directory (AD)Employees can only access or view data only specific to themAdministrators (Payroll, Time and Labor, People and Talent departments e.g. Core HCM Systems, Benefits, Goal and Performance, Learning and Development, Succession) can access, view and generate reports (excel or PDF) as per each process area needs. These roles need to be created.Data should be encrypted while loading in the DataMart and decrypted while accessing with the proper authenticated roles.PayrollEmployees are restricted to only view and print their own information in the PDF output format.Time and LaborManagers and Timekeepers are restricted from viewing earnings.Finance users are restricted to only view labor reporting data.Employees are restricted to only view and print their own information in a PDF output.People and TalentEmployees are restricted to only view or access only their individual recordsAdministrators will be having access to historical data and generate some key reports (in excel or pdf format) as per their process area.Interface RequirementsUser InterfacesEmployee Self Service UI Ability to access or view historical data specific to the user onlyAbility to generate employee specific reports pdf format.Administrator UI Ability to access or view historical data and generate reports (excel or PDF) as per each process area needs.SuperadminAbility to edit data if needed for correction.Ability to assign role provisioning to any employeePayroll and TimeEmployee Self Service (UI)PayrollPaycheck Selection Criteria/Filter byPaycheck Date (Mandatory)Output layoutRefer to the ‘Appendix A: Reports Output’ sectionSample Reports (PDF only)W2 and W2CSelection Criteria/Filter byCalendar Year (Mandatory)Output layoutRefer to the ‘Appendix A: Reports Output’ sectionSample Reports (PDF only)Time and LaborTimesheetSelection Criteria/Filter byDate Range (Mandatory)OutputRefer to the ‘Appendix A: Reports Output’ sectionSample Reports (PDF only)Payroll Administrator (UI)PayrollPayCheck ReportSelection Criteria/Filter byPaycheck Date (Mandatory)Employee Name (Optional)Employee Number (Optional)Earning Name (Optional)Taxable Benefit Name (Optional)Pre-Tax Deduction Name (Optional)Tax Name (Optional)Post-Tax Deduction Number (Optional)Note: Drop-down values are neededSample Reports (Excel only)Refer to the ‘Appendix A: Reports Output’ sectionW2/W2CSelection Criteria/Filter byCalendar Year (Mandatory)Employee Name (Mandatory)Employee Number (Optional)Note: No Drop-down values are neededSample Reports (PDF only)Refer to the ‘Appendix A: Reports Output’ sectionTime and Labor Administrator (UI)Time and LaborTimesheet hours ReportSelection Criteria/Filter byWork Date Range (Mandatory)Employee Name (Mandatory)Employee Number (Optional)Department (Optional)PayCode Name (Optional)Project Code (Optional)Note: Drop-down values are neededSample Reports (Excel only)Refer to the ‘Appendix A: Reports Output’ sectionPunch Time ReportSelection Criteria/Filter byWork Date Range (Mandatory)Employee Name (Mandatory)Employee Number (Optional)Note: No Drop-down values are neededSample Reports (Excel only)Refer to the ‘Appendix A: Reports Output’ sectionPeople and TalentEmployee Self Service (UI)Year_End_Performance_Review Selection Criteria/Filter byPerformance Review Name (Mandatory)Note: Drop-down values are neededReports Output FormatSample Reports (PDF only)Refer to the ‘Appendix A: Reports Output’ sectionAdministrator (UI)Note: 1. Please refer ‘Appendix A: Reports Output’ section for all the below reports. 2. Need the option to generate below reports in both Excel and PDF formats.All Hours ReportSelection Criteria/Filter byPay Class (Mandatory)Employee Pay Summary Start Date (Mandatory)Employee Pay Summary End Date (Mandatory)Note: Drop-down values are neededReports Output FormatEmp NumberTime CodeLast NameFirst NameUnionDepartmentDateHoursPay ClassPay DateSample Reports (Excel only)EEO diversity reportSelection Criteria/Filter byAs of Date (Mandatory)Note: Drop-down values are neededReports Output FormatEmployee IDGENDERETHNICITYVETERNSTATUSDISABILITYSALARYPAY GRADEEEO ClassificationFuture Retirement EligibleSelection Criteria/Filter byPay Class (Mandatory)Employment Status (Mandatory)As of date (Mandatory)Note: Drop-down values are neededReports Output FormatClockLast NameFirst NameDate of BirthAgeCurrent DateFive years from nowTen years from nowFifteen years from nowRecent Hire DateOriginal Hire DateYears of Service From Service Comp DateBenefit Calculation DateComp Start DateEmployeePCNPCN DescriptionJob ClassFederal/District/WASAPay Grade CodePay Grade DescriptionEmployee AuditSelection Criteria/Filter byEmployee Number (Mandatory)Employment Status (Optional)Note: Drop-down values are neededReports Output FormatEmployee NumberEmployee Reference CodeEmployee Display NameLast NameFirst NameMiddle NameSuffixEthnicity DescriptionEmployee GenderEmployeeBirth DateAgeMarital Status NameBusiness EmailHire DateOriginal Hire DateSeniority DateYears of ServiceStatus Effective StartLatest Comp Change DateLatest Comp ChangePay Group NameEmployment Status NamePay ClassEmp Job CodePCNJob DescriptionJob TitleBusiness/Acting TitlePrevious JobEEO Job GroupJob Family Reference CodeJob Family NameIs Non ServicePosition FTEDepartment Reference CodeDepartmentDivisionCodeDivisionSiteFederal/District/WASAUnion Reference CodeUnion DescriptionFLSA StatusReference CodeFLSA Status DescriptionFLSA Status IdPay Grade NamePay Grade DescriptionMin RateControl RateMid-rateMax RateBase SalaryPrevious SalaryCompensation ChangeChange DateCurrent StepFrequencyDate in StepNext Step DateManager NameManager NumberPerformance Review ScoresSelection Criteria/Filter byUser Status (Optional)Task Name (Optional)Is not removed from Task (Mandatory)Note: Drop-down values are neededReports Output FormatUser IDUser Full NameTask NameTask StatusStep TitleStep StatusStep Due DateCompletion DateExpiration DatePositionDepartmentUser Manager NameUnion DescriptionUser StatusCompetency NameCompetency Rating ScoreTask Raw RatingTask Raw Rating TextQuestionQuestion Response Rating ScoreQuestion Response Rating TitleUser Manager EmailUser EmailStep Assigned ToStep Reviewer IDStep Reviewer NamePerformance Review StatusSelection Criteria/Filter byUser Status (Optional)Task Name (Optional)Is not removed from Task (Mandatory)Note: Drop-down values are neededReports Output FormatUser IDUser Full NameStep Due DateStep StatusStep TitleStep SequenceExpiration DateTask NameCompletion DatePositionDepartmentUser Manager NameUser EmailUser Manager EmailTask Raw RatingTask Raw Rating TextCo-Planner (ID)Co-Planner (Name)Goal exception reportSelection Criteria/Filter byUsers(Mandatory) Date From and To (Mandatory)Note: Drop-down values are neededReports Output FormatUserUser IDManagerGoal Status ReportSelection Criteria/Filter byUser Status (Optional)Union (Optional)Note: Drop-down values are neededReports Output FormatUser IDUser Full NameDepartmentUnion DescriptionUnionTitleStatusGoal Created By (Name)Start DateDue DateProgressUser Manager NameUser Manager IDUser Manager EmailUser EmailTranscript reportSelection Criteria/Filter byTranscript Status (Optional)User Status (Optional)Training Title (Optional)Note: Drop-down values are neededReports Output FormatTranscript StatusUser IDUser First NameUser Last NameUser EmailDepartmentLocationTraining TitleTranscript Completed DateUnionStatus AuditSelection Criteria/Filter byEmployment Status (Mandatory)Status start date (optional)Status end date (optional)Note: Drop-down values are neededReports Output FormatEmployee IDEmployee Reference CodeEmployee Display NameEmployee Employment StatusEffective StartEmployee Employment Status Effective EndStatus Reason NameEmployment Status NamePay Class NamePay Type NameEmployee Schedule Policy NamePunch Policy NamePay Policy NamePayroll Policy NamePay Holiday Group NamePay Group NameEntitlement Policy NameTime Off Policy NameShift Rotation NameBase SalaryBase RateEmp Status IDEmployee Employment Status Last Modified TimestampEmployee Employment Status Last Modified HR Import TimestampWork Assignment AuditSelection Criteria/Filter byEmployment Status (Mandatory)Work assignment start date (optional)Work assignment end date (optional)Note: Drop-down values are neededReports Output FormatEmployee Reference CodeEmployee NumberEmployee Display NamePrimary Work AssignmentWork AssignmentEffective Start Work Assignment Effective EndLocation NameJob NameDepartment NameWork Assignment IDWork Assignment Last Modified TimestampEmployee Work Assignment Last Modified HR Import TimestampComp ChangesSelection Criteria/Filter byEmployee Name (Optional)Employment Status (Optional)Pay Class (Optional)Employment Status Start Date (Optional)Employment Status End Date (Optional)Note: Drop-down values are neededReports Output FormatEmployee NameEmployee NumberStart DateBase SalaryPrevious SalaryAmount of ChangePercentPrevious ReasonStatus Reason NamePrevious Status Effective StartDepartment NamePrevious PositionPosition NamePay Grade NamePrevious Pay GradeInterfaces To/From Other SystemsUser Interface will fetch data based on the search queries provided by the user from the DataMart going to be developed from the source systems Ceridian Dayforce, Cornerstone, Latitude, Evolve, Fleetwave, SourceTime Pro. Nonfunctional RequirementsAccessibility RequirementsDataMart should be available for access either from DCW office or remotely during office hours.Audit RequirementsAudit table should be available that allows who accessed the DataMart and who run the reports with the date and time stamp.Availability RequirementsDataMart should be available for access either from DCW office or remotely during 24 hours.Backup & Recovery RequirementsDCW should be able to back up the environment as the single entity. The database and reports should be able to backed up in one entity.Capacity RequirementsNoneMaintainability RequirementsApplication should be maintainable with current and future licenses tools (e.g. Microsoft SQL Server, Oracle database and BI etc.)Performance RequirementsNone Usability RequirementsThe user documentation and help should be complete and Live demo to the DCW users for the Business SMEs must be given for all the functionalitiesRedundancy RequirementsNone ApprovalsThe undersigned acknowledge they have reviewed the RD and agree that the requirements detailed in this document are in fact the requirements that will fulfill the business needs to the best of the parties’ knowledge. Changes to this requirement document will be coordinated with and approved by the undersigned or their designated representatives (DC WATER USE ONLY)Controller (signature required) NameSignature: Title: Department: Date: Payroll Manager (signature required) Name: Signature: Title: Department: Date: HCM Manager (signature required) Name: Signature: Title: Department: Date: AppendicesAppendix A: Reports OutputPayrollDC Water Employee Pay Statement (PDF Output)DC Water Employee W-2 W-2C (PDF Output) Sample PDF data output is attached below.Paycheck (Excel Output)Sample Excel data output is attached below.TimeDC Water Employee Timesheet (PDF Output)Timesheet Hours Report (Excel Output)Punch Time Report (Excel Output)Sample Excel reports for Timesheet hours and Punch time report is attached below.People and TalentAll Hours Report - Detailed report of hours workedEEO diversity report - For EEO reporting and submissionFuture Retirement Eligible - Retirement eligible employees current, in 5 years, 10 years and 15 yearsEmployee Audit - Data dump of most used fieldsPerformance Review Scores - Lists all employees and scores within a performance period. List is shared with compensation to determine bonuses.Performance Review Status - Determine which employee have incomplete performance evaluationsGoal exception report - Determine which employees do not have goalsGoal Status Report - Determined employees that have goals that are aligned with 'parent goals'Transcript report - Report of training that employees have registered forStatus Audit - History of all personal actions and status changesWork Assignment Audit - History of all work assignment (jobs, location) changesComp Changes - History of all compensation changesAll the report layouts (Excel) are in the attached format. Year End Performance Review (PDF Format)Works Cited/References BIBLIOGRAPHY There are no sources in the current document. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download