If you missed this webinar, a repeat webinar will be hosted April 30th at 1:00 pm EST. Click here to register. Below is a summary of Questions and Answers from yesterdays webinar.
Do you know what tables the employee attachments write to? I would love to add them programmatically.
In the database SageHRMS_Live, the table for employee attachments is HREMPATT. The attachments are done using binary data. While binary data can be added, you need to understand the functionality first as it is referenced via GUID in other table(s). The company and employee ID must match. I would suggest reaching out to Sage Professional Services to see if they can assist with this. Please note that this would be a billable service.
Are the updates for US or Canada as well?
The Sage HRMS US Payroll article ID 104155 – ‘How to set up earnings codes and tax codes associated with the Families First Coronavirus Response Act (FFCRA) in Sage HRMS’ has been updated. This pertains to US Payroll Setup in Sage HRMS. It does not apply to Canadian Payroll or Sage Abra Suite. The hotfix that is available in relation to social security is for Sage HRMS US Payroll only.
Is the hotfix for USSS and CVIDSS the only hot fix after Quarter 1 update for HRMS?
Yes. The hotfix is to be applied if you have any employees that will or have already reached the social security maximum of $137,700. This hotfix will be included in the Q2 2020 product update. See Sage Knowledgebase Article ID 10437 for more information. Please note that if you have employees that are affected by the Medicare additional tax of .9 percent, this will need to be manually calculated and the employee tax amount overridden in the employees timecard.
Could you show how to create a support case again?
Go to https://support.na.sage.com/ Click on the Cases Icon on the far right hand corner of the screen . Click ‘Submit a customer support case’. If you are not currently logged into the Sage Customer Portal, you will be prompted to enter your Username and Password. You can also sign up for a portal account or reset your password. Once you are logged into the portal select your product, Question category, and Subcategory. Enter the subject and a detailed description. You can also add an attachment.
When logging into Sage City can a company with one user license have more than one employee create a login?
You are not required to log into Sage City unless you want to Post or Respond to an article. More than one person from a company can create a Sage City logon. If you meant ‘When logging into the Customer Portal can a company with one user license have more than one employee create a login’, the answer is Yes.
Sage ESS and the Duplicate Keys Report.
Here is some additional information on the ESS Duplicate Key Report:
Duplicate keys will also cause an enrollment to error out, depending on the duplicates, they can stop you from approving enrollments and updating all the enrollment information in Sage HRMS.
We use file level backups (mdf and log) are backed up online every half hour. To restore from these we have to use the attach process. Will Sage HRMS recognize that once restored? Asking, because Nixon mentioned only Full DB backups were usable by Sage HRMS.
Yes, as long as both mdf and ldf are unmodified.
Can you explain the License Limit Alert again please?
Click the Help Icon > About Sage HRMS. You can enter the License Limit Alert. The threshold enter will dictate when you’ll receive a warning when your maximum number of employees licenses with your Sage HRMS support plan has been reached. The system will not prevent you from adding new employees. Instead, you’ll receive a warning message when you have the specified number of licenses left. For instance, if you have licenses for 100 employees in Sage HRMS, you can set your License Limit Alert to 5 and Sage HRMS will warn you when you enter your 95th employee. This way you can plan ahead and either order additional employee licenses or archive terminated employees from prior years.
The employee count includes Active and Leave of Absence employees based on the Employee Status field on the Current Job Panel. (Pe.p_active = 'A' or Pe.p_active = 'L').
The count of employees does not include the Employee Status of Terminated (T), Not Employee (N) or Dependent Cobra (D).
You can access an employee count report in Reports > Employees > Personal Information Reports. On the Standard Criteria tab select whether to count Active, LOA and/or Terminated.