Need Help?
  • Application Remote Support
  • Infrastructure Remote Support
  • Sage HRMS Remote Support
  • Helpdesk
  • General Inquiry
1-800-719-3307
Net at Work Net at Work
  • Solutions & Services
    • ERP/Accounting

      ERP Services
      Acumatica
      NetSuite
      Sage X3
      Sage Intacct
      Sage 100 ERP
      Sage 300 ERP
      Sage 500 ERP

      CRM

      Strategic Advisory Services
      Digital Marketing Solutions
      CRM Training Camp
      Salesforce
      Microsoft Dynamics 365 CRM
      Sage CRM
      Infor CRM (formerly Saleslogix)

      Employer Solutions

      Sage HRMS
      Sage People
      Criterion
      Miviva

      Enterprise Content Management

      Imaging / Scanning
      Document Management
      Workflow Automation
      Solutions

      Nonprofit Solutions

      Abila by Community Brands
      NetSuite
      Sage
      Salesforce

      IT and Security Services

      Managed IT Services
      Fractional CIO Services
      Cloud Services
      Cloud at Work
      DR/Business Continuity Planning
      Compliance & Security
      Storage & Recovery
      Networking
      IT Security Services
      Communications

      Web Solutions

      Services Overview
      B2B Technology Suite
      Magento eCommerce
      WordPress CMS
      Systems Integration
      Website Managed Services
      Online Marketing & SEO
      ERP eCommerce Integration

      Additional Solutions

      Enterprise Business Intelligence
      Avalara Automated Tax Solutions
      Fortis Payments
      LeaseQuery Lease Accounting
      Sage Fixed Assets
      Vertex SMB Sales and Use Tax
  • Industries
    • Industries

      Healthcare
      Chemicals
      Food & Beverage
      Medical Devices
      Nonprofit
  • Learning Center
    • Online Resources

      Recorded Webinars
      Whitepapers
      Ebooks

      Upcoming Events

      Live Webinars
      Seminars
      Virtual Training Courses

      Training Courses

      View all available training course options
  • Company
    • Why Us

      Who We Are
      Management
      Our Partners
      Locations
      Careers

      News

      Press Releases
      Success Stories
      Net at Work Blog

      Contact Us

      1.800.719.3307
      Email Us

      Programs

      Alliance Partnership Program
      Women at Work
      Diversity and Inclusion
  • Blog
  • Contact Us
  • Contact Us

Home » Newsletters » Employer Solutions / HRMS Newsletter – August 2016 » Tracking Employee Data with Custom Screens

Employer Solutions / HRMS Newsletter – August 2016

Keeping You Up-To-Date With Information About Employer Solutions / HRMS

Tracking Employee Data with Custom Screens

By: Net at Work Team

All HRMS systems track employee information and most track the same things: employee indicative data, employee history, benefits, training, and payroll information. However, many employers have data they need to track about employees that fall outside of those norms.

So after spending time and money to establish a Human Resources Management System (HRMS) and importing or inputting all of that data, you are left with some data that just ‘doesn’t fit’. And that data goes into Excel spreadsheets, homemade databases or on paper. What kinds of data might that be? Examples include:

  • Equipment issued to employees
  • Testing results especially in health care organizations
  • Company vehicle or licensing and insurance information
  • Licenses or certifications, especially with expiration dates
  • Onboarding documentation
  • HIPAA-sensitive information that should not be comingled with other employee notes
  • Specialized data to carry forward to third-party timekeeping or payroll systems

The Single Point of Truth
The problems with multiple locations for employee data are many. Employee indicative data like employee numbers or other identifiers may not match making reporting an issue. Even if there is a common field, it is often costly and time-consuming to create and maintain a method for reporting the data together. (VLOOKUP() anyone?) Plus, when data changes, you have to remember all the places where it might need to be changed, added or deleted.

Seeing the analytical ‘bigger picture’ that your data can provide is lost if data cannot be put side-by-side for analysis. Issues big and small can arise. For example,

  • if you don’t know all of the equipment an employee was issued, what are the chances that it will all be accounted for when the employee leaves?
  • If your employee’s Superintendent Certification has expired in your job site’s State, is it a good idea to assign them to that job site?
  • If your location’s day care license is under review, how quickly can you show the result of your employee background checks?

The solution is to have a single point of truth, a single location that acts as a repository for all employee data. One point for data entry with the ability to record – and report – all of the employee data that is critical to your business.

Customization versus Configuration
How then, do you go about creating that single point of truth that includes everything you need to know about your employees? For some products that involves customization. Customization often involves special skills in coding, database management and presentation. Customizable programs are highly flexible but that flexibility comes at a steep price both in terms of software investment and in specialized consulting.

A better choice is a configurable solution like Sage HRMS. Configurable solutions give the end user the ability with minimal instruction to create their own databases, screens and reports without specialized knowledge. Sage HRMS allows you to quickly built custom screens using simple click-and-drag techniques and enter or import data. After you have created your custom screen you can integrate it alongside the standard screens, include the screen in standard Tasks like New Hire and Termination. Additionally, you can out information using the wizard-driven Secure Query tool, or create Crystal Reports.

Creating a Custom Screen is Easy in Sage HRMS
Sage HRMS custom screens can be single record (like the Demographic detail) or multi-record (like the Benefits detail), depending on your need. The screen can have up to 5 individual tabs and 18 fields per tab. Fields can be from the HR master table (items like organizational level, supervisor, and Job Title) as well as custom fields. Custom fields can be drop-down\menu driven, date, text, numeric or calculations.

In this screen, we are tracking company property issued to Hugh Allen. While the list of property items is custom, the header with Hugh’s employee data is consistent with all of the other screens in HRMS

If we needed to add an additional column, we could open the System Setup and click in the location where we want the field to appear. A list of standard or custom fields will appear to choose from.


Increase the Value of Your Custom Data
Once you have created your screen, you can add it to your tasks. Here we are adding the Company Property Screen as a step in our Termination Employee Task.

Secure Query Makes Reporting Easy
Getting data into a system is only as good as getting data out of a system. With Secure Query, you can quickly build a report from your custom data.

Next Steps
Look for our list of upcoming webinars for a free session on creating custom screens or contact us here at Employer Solutions at Net at Work for assistance from one of our skilled consultants. They can assist you in learning how to design and deploy your own custom screens. For additional information check us out at https://www.netatwork.com/services_1/bizsol_1/sage-hrms/ or contact us at 800-719-3307.

Informative Webinars
Aug 24th: The Benefits of Automating Time and Attendance
Sept 7th: SQL Migration: Why Make the Change to Sage HRMS SQL Version?
Sept 8th: Meeting the Cybersecurity Challenge
Sept 9th: New Overtime Rules: It’s Here! The Official Changes to the FLSA White-Collar Exemptions
Sept 13th: InfinityHR – Complete HR Automation Has Never Been More Within Your Reach!
Sept 14th: Crystal Reports: Basics
Sept 16th: HR Technology Tools 2016: Why it’s more important than ever to use an HRMS
Sept 20th: Crystal Reports: Beyond the Basics
Sept 22nd: Strategies for Responding to the Changes in FLSA Overtime Eligibility
Sept 27th: Sage HRMS HR Actions – Create, Route, Approve, and Save Paperless Web-Based Forms
Sept 30th: Using Tax Credits & Incentives to Improve Cash Flows and Grow Your Business: Tax Credits and their Importance

« Return to Newsletter

In This Issue
  • From the Desk of the Employer Solutions Practice Director
  • Fair Labor Standards Act Exemptions from Overtime Redefined
  • Cybersecurity: The New Business Priority
  • Tax Credits and Their Importance
  • Total Compensation Statements Encourage Employee Engagement
  • Tracking Employee Data with Custom Screens
  • Employer Solutions Employee Spotlight

  • Live Webinars

    Performance Management Strategies – Bringing Together ERP & HR Systems for Actionable Data
    Date: May 25, 2022
    Time: 2pm – 3pm ET
    Learn More / Register

    Hosting Your Sage HRMS in the Cloud
    Date: June 1, 2022
    Time: 2pm – 3pm ET
    Learn More / Register

    Best Practices: Creating Amazing Employee Experiences through Purposeful Employee Engagement
    Date: June 8, 2022
    Time: 2pm – 3pm ET
    Learn More / Register

    Employer Solutions/HR – Live Webinar Calendar
    Browse webinars, register now, or mark your calendar for future scheduled sessions.
    Learn More / Register

    Popular Recorded Webinars

    New Options from the Premium Version of Sage HRMS and More

    Building a Business Case for Next Gen HR Technology

    How Learning Management Systems are Changing the Way People Learn, Everywhere

    Next Generation Human Capital Management Systems

    HRMS Support

    Helpdesk:
    P: 888.494.9479
    E: helpdesk@netatwork.com

    HRMS Knowledge Center

    Sage HRMS Online Training Center
    See more courses and gain knowledge about Sage HRMS business topics important to you without committing a full day or more!

     Refer a friend, get a $100 Gift Card!

    Submit a Referral / Learn More!
    Do you have a friend or colleague whose company might benefit from utilizing a Net at Work service or solution? If so, refer them to us below and receive a $100 gift card or donation to your charity of choice!

    HRMS Resource Archive

    View our library of Employee Solutions / HR resources.

    HRMS Newsletter Archive

    Read our previous Sage HRMS Newsletters here

    Connect With Us

    Business Applications

    • Overview
    • ERP/Accounting
    • Cloud ERP
    • CRM
    • Employer Solutions
    • ECM
    • Nonprofit Solutions

    Learning Center

    • White Papers & Guides
    • Ebooks
    • Training Courses
    • Virtual Training Courses
    • Success Stories
    • Live Webinars
    • Recorded Webinars
    • Trials

    Infrastructure Solutions

    • Overview
    • Solutions
    • Managed IT Services
    • Fractional CIO & Advisory Services
    • Cloud Services
    • Cloud at Work
    • Compliance & Security
    • DR/Business Continuity

    Support

    • Application Remote Support
    • Infrastructure Remote Support
    • Sage HRMS Remote Support
    • General Inquiry
    • Helpdesk

    Web Development

    • Services Overview
    • Magento eCommerce
    • WordPress CMS
    • Systems Integration
    • Website Managed Services
    • ERP eCommerce Integration

    Company Information

    • Why Us
    • Alliance Partnership Program
    • Women at Work
    • Diversity and Inclusion
    • Partners
    • Careers
    • News
    • Blog
    • Privacy Policy
    • Contact Us

    Additional Solutions

    • Enterprise Business Intelligence
    • Avalara Automated Tax Solutions
    • Fortis Payments
    • LeaseQuery Lease Accounting
    • Sage Fixed Assets (Sage FAS)
    • Vertex SMB Sales and Use Tax

    Industries

    • Healthcare
    • Chemicals
    • Food & Beverage
    • Medical Devices
    • Nonprofit
    Net at Work
    Net at Work (HQ)
    575 8th Ave
    New York, NY 10018

    P: (800) 719-3307
    info@netatwork.com
    Locations Across North America »
    Visit our sister companies:
    Cloud at Work - Sage Application Hosting
    Pixafy - An eCommerce Agency
    Docutrend
    WordPress Image Lightbox Plugin