Enter into SQLSYSSETTING.EXE within the manexSQL root directory.


Enter password when prompted

Select Production > Time & Attendance Types from the menu



The following screen will be displayed:


On the toolbar, add, edit, and delete buttons are available.

Add a type by selecting the Add button from the main toolbar and entering the type in the entry field box. Time and Attendance Types indicate how the hours are to be collected. 

Pay: checking the pay box means the company will pay for that type.  For example, an unexcused absence would not be checked, but jury duty could be checked, if it is company policy to pay for jury duty.

Allow to enter hours directly in Time Log Management [...]: If the "Allow to enter hours directly in Time Log Management [...]" box is checked, the user will be able to enter hours directly in the time used field for that type in the Time Log Management module. Once a user adds a new record for a time log type, which is allowed to enter hours directly, the time in and time out fields will be blanked out and disabled, and the user can enter an amount of hours for that record. Otherwise, the user has to enter time in/out.  

 

The system only allows a user to enter "RT," no "OT" can be entered.  Therefore, a user cannot check type "W" or "T" to enter hours directly.  The system will have to calculate the total login time and determine what the RT and OT for type "W" and "T."

 

The time in and out will also be blank, if the type is "H" (holiday). And the system will use the shift to calculate the RT, but no OT will be calculated.


Overtime hours are established for determining overtime pay, if the timeclock function is used without shift data per person. Hours entered in excess of the allotted hours per day, or week, would be counted as overtime.

Enforce Breaks: this box only applies to type "T" (Time Card).  When checked, it will deduct lunch 1 and 2, but does not deduct the break times from the total hours. If unchecked, it does not deduct lunch 1 and 2, or break times from the total hours. For an example, see the following attachment: File IconPrint Screens_2006-02-09_a.doc 


User Work Shift: user will check this radial if they want this as a work shift.

Maximum hours logged on in the system is the number of hours which, if a user has remained logged on, the system would automatically log them off, assuming that they left without logging off. 

Note: manex suggests that you populate this field with numbers between 1-24. If left empty or with a "0," the automatic logout process will not run and will not logout the user automatically. This field is restricted to only allow a minimum entry of "0" and a maximum entry of "24."


Shift Tolerance: allows users to consider a line at the timeclock. If an employee logs in a few minutes early, or late, the system will log them in at the beginning of their shift.

Once you have completed all modifications, select the Save or Abandon changes button from the main tool bar. 

These items may be sorted in any order by clicking on and dragging the box on the left side to the desired position. The order you make will be displayed in the pull-down menus, when using this list in other modules within the system. 


Suggestion: have the most used item at the top of the list.
 

Where Used:  In all job logging functions for a product’s work orders.