Timesheets business rule templates

You can use these Infor TS business rule templates to create the these types of business rules:

Timesheets business rule templates Definition
Absence Activity Cannot Be Overtime or Double Time Labor Type Ensures that labor type is not overtime or double time when the charge code activity is Absence. See Absence Activity Cannot Be Overtime or Double Time Labor Type template.
Absences To Be Taken in Full Day Increments Ensures that employees report absences in full-day increments. See Absences to be Taken in Full Day Increments Policy template.
Absence Taken Not Part of Benefit Bank Requires employees to explain absences that are not included in company benefits banks. See All Timesheet Line Items Must be in Reporting Period Policy template.
All Charge Codes Must be Valid Requires that all charge codes are validated. See Not Defined template.
All Charge Codes Must Comply to Billable Requires that all charge codes are billable. See Not Defined template.
All Timesheet Line Items Must Be In Reporting Period Requires that the dates for all timesheet line items created for a project occur within the current reporting period. See All Timesheet Line Items Must be in Reporting Period Policy template.
All Timesheets Must be Signed When Approved Requires a signature that is entered electronically when the timesheet is approved. See Electronic Signature Policy template.
All Timesheets Must be Signed When Submitted Requires a signature that is entered electronically when the timesheet is submitted. See Electronic Signature Policy template.
Arrival Time Earlier or Later Than Official Start Time Policy Determines if a user arrives a set number of minutes before or after the official start time. See Early/Late Arrival Policy template.
Benefit Bank Balance Changed Requires employees to confirm that changes have occurred to their benefit bank. See Benefit Bank Balance Changed Policy template.
Benefit Bank Exceeds Threshold Policy Prohibits an employee from exceeding the allowed negative balance in the benefit bank. See Benefit Bank Exceeds Threshold Policy template.
Benefit Bank Negative Balance Policy Requires a user to provide an explanation when the submission of paid time off creates a negative PTO balance. See Benefit Bank Negative Balance Policy template.
Calculate Total Overtime and Double Time Hours for a Timesheet Calculates total overtime and double time hours for a specific timesheet. See Not Defined template.
Charge Code Billing Limit Sets the limit on the number of hours per week that can be charged to a specific project. See Project Hours Limit Policy template.
Creating a Timesheet for a Future Reporting Period Sets the policy for when a timesheet can be submitted for a future reporting period. See Timesheet Reporting Period Policy template.
Date of Hire/Term Policy Verifies that a timesheet is not being submitted before an employee was hired or after an employee was terminated. See Date of Hire/Term Policy template.
Either Time or Time Off Entry Is Needed Determines if time or time off hours entries are entered. See Either Time or Time off Entry is Needed template.
Employees Must Account for all Hours Requires that employees account for all the hours that they are reporting for a project. See Validate Timesheet Total Working Hours in a Reporting Period Policy template.
End Time Cannot Be Before Start Time Check to make sure the end time does not occur before the start time on standard or project line items. See End Time Cannot Be Before Start Time Policy template.
Enforce The Entered Hours In The Increments Of A Quarter Hour This rule requires users to specify hours in increments of a quarter hour such as .00, .25, .50, or .75. It fires on update of TS line items and checks that the time specified on the line item is in the increment of a quarter hour. If the time is not in a quarter hour increment, the rule fires. See Enforce the Entered Hours in the Increments of a Quarter Hour template.
Enforce The Entered Hours In the Specified Increments This rule requires users to specify hours in specific increments. The increments can be set to various fractions. For example, 0.25 - quarter hour increment 0.50 - half hour increment 1.00 - full hour increment It fires on update of TS line items and checks that the time specified on the line item is in the specific increment. If the time is not in the specific increment, the rule fires. See Enforce the Entered Hours in the Specified Increments template.
Entry on Timesheet Tab Date Validity Checking Verifies that entries made from the Timesheet tab occur on dates within the reporting period. See Entry on Timesheet Tab Date Validity Checking template.
Entry on Timesheet Tab Uniqueness Checking Verifies that entries made from the Timesheet tab are not duplicates. See Entry on Timesheet Tab Uniqueness Checking template.
In and Out Times are in Pairs Policy Determines if timesheet line items are filled out in pairs. See In and Out Times of Line Item of Timesheet Tab are in Pairs Policy template.
In and Out Times Required for Line Items Entered on Timesheet Tab Verify that the In and Out times are required for line item created on the Timesheet tab. See In and Out Times Required for Regular Line Items on Timesheet Tab template.
Insert Delinquent Report Entry Policy When a TS document is rejected, data needs to be added into Late Time Sheet document/report tables This rule adds an entry to the alts_delinquent_report table when a timesheet is rejected and removes an entry from the alts_delinquent_report table if an entry was added as a presubmitted timesheet This business rule works together with the Remove Delinquent Timesheet Flag Policy which removes an entry from the alts_delinquent_report table when a timesheet is submitted. When a timesheet is presubmitted, an entry is added to the table with presubmitted set to 1.
In Time Must Be Before Out Time Determines if the In time is before the Out time on line items. See In Time must be before out Time Policy template.
Insert Delinquent Report Entry Inserts a delinquent report entry when a timesheet is rejected. This business rule is only necessary if timesheet delinquent submit notification background process is running. See Insert Delinquent Report Entry template.
Labor Type Validation Set the policy that determines that all line items have their labor type correctly recorded as defined by their calculation method. See Labor Type Validation template.
Matching Standard Line Item Location Requires any tax location to match the location specified in any of the timesheet standard line items for the corresponding day. See Matching Standard Line Item Location template.
Maximum Consecutive Days Enforce company policy regarding the number of days that employees may work consecutively. See Maximum Consecutive Days Policy template.
Maximum Differential Between Timecard Hours and Billable Hours Requires that the total differential between timesheet hours and billable hours does not exceed its maximum allowance. See Maximum Differential Between Timecard Hours and Billable Hours template.
Maximum Hours Worked in a Reporting Period Determines if an employee has worked more than the maximum number of hours allowed for the reporting period. See Validate Timesheet Total Working Hours in a Reporting Period Policy template.
Maximum Number of Attendance Hours Charged Per Day Policy Determines if an employee bills too many hours in a day. See Maximum Number of Attendance Hours Charged Per Day Policy template.
Maximum Number of Consecutive Hours Policy Checks that employees take breaks at required intervals by not charging more than a maximum number of consecutive hours. See Maximum Number of Consecutive Hours Policy template.
Maximum Number of Hours Charged Per Day Policy Requires that no more than a maximum number of hours can be charge for each day to standard line items. See Maximum Number of Hours Charged Per Day Policy template.
Maximum Number of Timesheets Per Period Requires that there is no more than the maximum number of timesheets for each reporting period. See Maximum Number of Timesheets Per Period Policy template.
Maximum Number of Work and Absence Hours Claimed Per Day Enforces a company rule that employees may not charge more than a predetermined number of hours on a timesheet to a project or as absence time. You can also use this template to create a business rule that enforces company policies regarding the maximum number of work hours reported. See Maximum Work and Absence Hours Claimed Per Day Policy template.
Missed Payroll Cutoff Enforces company cutoff policies. See Missed Cutoff Policy template.
Missed Submission Cutoff Enforces company cutoff policies. Missed Cutoff Policy template.
Negative Hours Data Entry Checks if user entered negative hours. See Negative Hours Data Entry template.
No Empty Timesheet Line Items Policy Determines that there are at least a minimum number of line items attached to the timesheet. See No Empty Line Items on Timesheet Tab Policy template.
No Work Hours for Being On Call Enforces company policies regarding on-call hours. See No Work Hours for Being On Call Policy template.
Only One On-Call Entry Per Day Enforces company policies regarding the number of entries an employee can create when on call. See Only One On-Call Per Day Policy template.
Pre-Submissions of Work Hours Policy Enforces company policies that prohibit employees from submitting timesheets including work hours too soon before the close of the reporting period. See Timesheet Reporting Period Policy template.
Pre-Submissions of Absences Policy Enforces company policies that prohibit employees from submitting timesheets with absences only too soon before the close of the reporting period. See Timesheet Reporting Period Policy template.
Project Date Range Check Checks that all dates are within the project date range. See Project Date Range Check Policy template.
Project Hours Limit Policy Sets the limit on the number of hours per week that can be billed to a specific project. See Project Hours Limit Policy template.
Remove Delinquent Timesheet Flag Removes a delinquent timesheet record once the timesheet is submitted. See Remove Delinquent Timesheet Flag Policy.
Return From Meal Time Must be After its Leave Time Determines that an employee has entered the proper in/out times for all entries on a timesheet. See Return from Meal Time Must Be After Its Leave Time template.
Submit Timesheet With Overtime Hours Requires that employees explain why they are submitting timesheets that contain overtime hours. See Submit Timesheet with Overtime Policy template.
Time Overlap Not Allowed on Timesheet Policy Prevents time entries for multiple project codes on the same day from overlapping. See Time Overlap Not Allowed on Timesheet Policy Template.
Timesheet Data Modified by Manager Requires managers to explain why they are modifying timesheet line items that they are reviewing. See Timesheet Data Modified by Manager Policy template.
Timesheet Submitted too Early Enforces company policies that prohibit employees from submitting timesheets too soon before the close of the reporting period. See Timesheet Reporting Period Policy template.
Timesheet Tax Location Exists Determines if there is a tax location entry for each day on which a timesheet standard line item has been entered. See Timesheet Tax Location Exists template.
Validate Timesheet Daily Total Working Hours Validates daily total working hours against scheduled work hours on a timesheet. See Validate Timesheet Daily Total Working Hours template.
Validate Timesheet Total Working Hours in a Reporting Period Validates that employees have accounted for all hours in the reporting period. See Validate Timesheet Total Working Hours in a Reporting Period Policy template.
Work on Non-Workday Requires part-time employees to explain why they are reporting hours worked on holidays. See Work on Non-Workday Policy template.