Create and maintain the Pay Type records used in Payroll, Labor Journal and Remote Time entries.
Regular, holiday, sick, overtime, etc.
Required for Payroll Processing / Export
Referenced in Records: Workers Compensation Category, Work Order, and Employee.
Referenced in Journals: Labor, Payroll, Job, And Remote Time.
Note: this Help Topic lists the standard configuration of all fields that may be included in this record. If you are using a customized system, the fields displayed on your screen may not exactly match the fields described in this Topic.
Pay Type Id: (15 character, only . and - special characters)
A unique Id for this pay type. This field is required.
Description: (40 character)
A brief description. This field is optional.
Check Label: (10 character)
The text that will appear on payroll checks for this type of pay (e.g., overtime, regular, holiday, etc.).
If you enter <OMIT> in this field, the detail information for this pay type will not be printed on the check stub. The dollars from this Pay Type will still be included in the gross.
To Show PTO Pay Types as Dollars instead of Hours on the Check Stub Recap
If the sys-report-rprchck registry ShowPTOAvailableAs=dollars is implemented, the Check Label field MUST include a dollar sign ($) to define which PTO Pay Types will be displayed as a dollar amount on the ‘PTO Available’ section of the Recap portion of the check stub.
Example:
Suppose that you want your employee’s available sick time to appear as dollars, management sick time to appear as hours, and all vacation time to appear as hours.
Emp. Sick Time Pay Type Check Label: Sick $
Mgr. Sick Time Pay Type Check Label: Sick Hours
Vacation Time Pay Type Check Label: Vac. Hours
The check label "Various" will be used when the number and type of Pay Types on the check stub exceed the available space.
Example:
If for a particular payroll run an employee has the following PTO types (Holiday, Vacation, Sick, Personal). The results on the check stub for labels may be something like Holiday, Vacation, Various. This is also true for other pay types and deductions as well.
Rate Factor (numeric format 0.000)
The system uses this field and the Pay Rate in the Employee Record to calculate Pay Rates in Labor and Payroll Adjustment journal entries. For example, the Rate Factor for regular Pay Type wages would generally be set to 1.0; an employee would be paid at his regular pay rate for this Pay Type. For a Pay Type of doubletime, however, the Rate Factor would be set to 2.0 so that an employee would be paid at double his normal pay rate. Typically, the rate factor for overtime would be set to 1.5.
Show Rate on Check?
Flag this field (by double-clicking on it or pressing the spacebar when the caret is on it) if this rate should be printed on payroll checks.
Hours Type: Worked PTO Other
The Worked option should be selected for Pay Types used for actual work (regular, travel, etc.). Depending upon how you elect to handle overtime pay, it might or might not be flagged as Worked.
The PTO option would be selected for hours that were paid but not worked (sick, vacation, etc.).
The Other option could be used to define an overtime premium for hours worked over the your standard work week. For example, suppose an employee enters 50 hours of straight time on a standard 40 hour week. On reviewing this employee's entries, the Payroll department would then add a journal entry for 10 hours (50-40 hours) of Overtime Premium pay (at a rate factor of, for example, .5) . In this way, the employee would be compensated for the work, but the overtime cost could be charged to an overhead job. Contact your Data-Basics support representative for further details.
Remote Time Entry
Pay types marked as Worked and PTO will be available for use from the Remote Time applet. Pay type marked as Other will not be available for use from the Remote Time applet.
Category: Regular Overtime Doubletime Vacation Holiday Other
During data conversion, the system will set the new field's value based on the existing Hours Type field. The rules are as follows: If the Hours Type is 'Worked' then set the Category to 'Regular', otherwise set the Category to 'Other'.
The Vacation and Holiday fields are used in the Compute Payroll process that calculates percent-of-wage PTO earnings accruals for Employees with a PTO line having the Percent field filled in. Validation code has been added to enforce proper use of Hours Type and Category combinations as follows:
When Hours Type is 'Worked', Category must be 'Regular', 'Overtime', or 'Doubletime'.
When Hours Type is 'PTO', Category must be 'Holiday', 'Sick', 'Vacation' or 'Other'.
When Hours Type is 'Other', Category must be 'Other'.
Canadian Installations:
PTO Accrual Method: Hours - Percent - CurrentPayRate
This field allows for specification of the PTO Accrual Method. Three options are currently supported.
'Hours' is the general default.
'Percent' is the method implemented for Canadian Vacation pay only.
'CurrentPayRate' is the alternate methodology implemented with the registry entry ShowPTOAvailableAs=dollar in sys-report-rprchck.
The Pay Type viewer will default the methodology to 'Percent' for Canadian v.cus file users whenever the Pay Type's Category is set to Vacation for new or changed records. Note that Pay Types that existed before these enhancements should be manually updated.
The Employee viewer validates the use of the PTO amounts (hours or percent) relative to the Pay Type's Accrual Method.
PTO Accrual Exclusions
Exclude Regular?
Exclude Overtime?
Exclude Doubletime?
Exclude Vacation?
Exclude Holiday?
Exclude Sick?
Exclude Other?
Prior to this release, only vacation wages were excluded from the vacation accrual wage base. For example, when an employee takes a week of vacation, no additional vacation pay is earned for that week. The Province of Alberta allows the employer to excluded overtime wages as well.
These fields are only applicable if this Pay Type is set to PTO and the PTO Accrual Method is set to Percent. If so, these fields enable the user to specify which types of Pay Types for Hours Worked will exclude this PTO Pay Rate from accrual.
Important Upgrade Note: it is necessary to flag Exclude Vacation for these wages to be excluded from the accrual wage base. After upgrading from 7.3 or earlier, carefully review your Pay Type records to see if any changes should be made.
Example:
For the case of Alberta, the fields would be set as follows for the Vacation PTO accrual:
Hours Type: PTO
Category: Vacation
PTO Accrual Method: Percent
PTO Accrual Exclusions
Flag the following: Exclude Overtime?, Exclude Doubletime?, Exclude Vacation?
Union Exempt:
This box should ONLY be flagged if this Pay Type is used for certain types of union-exempt pay. Wages connected to union-exempt Pay Types (vacation, holiday, etc) post a zero to the PR History Earnings Group column so they will not be picked up by Union reports. Two things happen differently when time is charged to a Pay Type that is Union Exempt when Compute Payroll is run:
1. All fringe-type lines from the Earnings Group are ignored.
2. All lines from the Deduction Group are ignored.
GL Account Id:
The expense account pay is charged (debited) against. Double-click on this field to select from a list. Note that if this field is completed, it will override the GL Account entered in the Earnings record for journal entries. Therefore, the Pay Type GL Account should only be filled in if all Earnings associated with this pay type should be charged against the same GL Account. For example, you could charge Holiday and Vacation Pay Types to an administrative GL Account, regardless of the type of work the employee normally does. For a Pay Type of Regular, however, you would most likely leave this field blank, specifying the appropriate GL Expense Account in your Earnings record.
Default Earnings Group Id:
If completed, this Earnings Group will override the Earnings Group found in the Employee record when time is entered for this Pay Type.
Default Deductions Group Id:
If completed, this Deductions Group will override the Deductions Group found in the Employee record when time is entered for this Pay Type.
Job Use: All Direct Indirect
The default value of All preserves the existing validation behavior which means there are no restrictions on the combinations. Direct and Indirect (Overhead) are used to indicate the type of jobs that can be used with records having this attribute.
The following viewers are affected by this functionality, and will not allow records with the Job Use field set to Direct to be used with Indirect (Overhead) Jobs. Likewise, Direct Jobs (Overhead flag not checked) may not be used with Pay Types flagged as Indirect.
Employee viewer Job viewer (Employee Overrides)
Job Journal Labor Journal
Work Order viewer Work Order Entry viewer
PRS Pay Code:
Paycor Users:
Hours entered with a Pay Type using the Categories ‘Doubletime’ or ‘Other’ are listed as Coded Hours and require a Paycor code (consult your Paycor documentation for a list of valid codes). If this field is completed, it will be used to set this code; if this field is blank, the Pay Type Id will be used instead.
For Bonuses, the Pay Type PRS Pay Code: field (if completed) will be used to set the Ern Cde 1 column; otherwise, the Pay Type Id will be used.
Note: the PRS Pay Code should NOT be set for Regular or OT Pay Types.
To Skip Hours Sent to Paycor:
To skip the hours sent to Paycor for a specific Pay Type, enter <skip> in the PRS Pay Code field.
Paychex Users:
Paychex requires that Pay Types of all Pay Categories (Regular, Overtime, Doubletime and Other) are associated with a valid Paychex Earnings Code. The PRS Pay Code field will be used (if completed); if this field is blank, the Pay Type Id will be used to set the Earnings Code. Consult your Paychex documentation for a list of valid, 2 character Earnings Codes.
ADP Users:
Any hours charged to a pay type with a Category of Regular or Overtime will automatically be classified as Regular Hours or OT Hours in ADP. No additional ADP coding is required. Pay Types with a Category of Doubletime or Other must include the applicable ADP Codes. The system uses the following fields hierarchy for ADP codes:
Pay Type PRS Pay Code (overrides User 1 and Id)
Pay Type User 1 (overrides Id)
Pay Type Id
The export will process all pay types unless the Pay Type User1 field is set to N/A. Pay Type User1 should be set to N/A if it should not be processed (N/A is not supported in the PRS Pay Code field). IMPORTANT: TechAnywhere also uses the PRS Codes/User 1 fields: do NOT change your setup with consulting your TechAnywhere and SAMPro support reps.
Pay Type User1: User2: User3: User4: User5: (30 character)
These optional fields may be used for entering any information your company wishes to retain (e.g., additional account numbers). It may also be used for ADP Coding (see above) or TechAnywhere.
Obsolete?
If this field is checked, the record is considered Obsolete, and it may not be directly specified during data-entry (either by entering the Id or selecting it from a list). Obsoleted records can be edited and the Obsolete flag cleared when necessary. When you check the Obsolete field, the following message box will be displayed:
“You have elected to obsolete this record. Would you like to see existing references to this record?”
If you click Yes, the system will display a viewer that provides click-through access to all tables referencing this record: see References List for details.