Appendix F – Reference Tables

The Reference Tables contain all the codes for the system other than organization levels.  Below is a list of options users can select from:

 

Accrual Codes – Listing of accrual codes that are assigned to accrual plans (Vacation, Sick or Personal).

 

Accrual Pay Type – Mapping of pay types to accrual codes.

 

Accrual Transaction Type – Listing of accrual transaction types that will display on Employee Maintenance – Employee Information – Accrual Summary.

 

Address Type Codes – Available address types that will be listed for employees.

 

Attendance Categories – Listing of available attendance categories that are used with the attendance module.  Five user-definable attendance categories are available for tracking special attendance situations.

 

NOTE – The attendance category listing is automatically filtered by the first company in your system. If you would like to view attendance categories for a different company, use the 'Filter by Company ID drop-down to select the company or 'All' to list attendance categories for all companies.

 

Attendance reason code assignments – Stores reason codes that are assigned to a specific attendance category.

 

Attendance Reason codes – Stores reason codes that can be applied through the Daily Procedures – Exceptions – Attendance page.

 

Clock Language table – Clock defaults to the language of English and this table stores that information which is found on the Employee Maintenance – Employee Information - Profile page.

 

Countries – Listing of countries.

 

DNS lookup servers – DNS restriction options that will be available on both User and Group Security pages under “Restrict access by IP address or DNS”.

 

Earning Codes – Listing of available codes used for selection under Company Setup – Earning Groups. Under the Earnings Codes section, add all codes that employees are able to allocate hours to. To use these codes for payroll, when possible use the same code as the payroll system.

 

Email Type Codes – Listing of email types that will be available for employees on the Employee Maintenance – Employee Information – Contact Info page.

 

Employment Status Codes – Listing of employment status codes that will be available for employees on the Employee Maintenance – Employee Information - Profile page.

 

Export Data Map – Listing of valid mapping types for exports.

 

Gender Codes – Listing of available codes to select from on the Demographics tab on the Employee Maintenance – Employee Information - Profile page.

 

Holiday Definitions – Listing of holiday names. 

 

NOTE – These holidays will be available on the Company Setup– Holidays page when generating holidays.

 

Hours Accrual Codes – Listing of different accrual transaction codes that can be seen on the Accrual Summary page.

 

Hours Type Codes – Ability to specify a code as the regular pay type or not for overtime calculation (not in use at this time).

 

Input Devices – Listing of valid input devices. All clock numbers must be listed in this option or punches will not post in TimeStar™.

 

Marital Status Codes – Listing of marital status codes available for employees that will be available for selection on Employee Maintenance – Employee Information - Profile.

 

Pay Period Type Codes – Pay period types available in TimeStar™.

 

Pay Status Codes – Listing of pay status codes available for employees on the Employee Maintenance – Employee Information - Profile page.

 

Pay Types – Pay types available in the system. 

 

NOTE – The pay type listing is automatically filtered by the first company in your system. To view pay types for a different company, use the ‘Select Company’ drop-down to select the company or 'All' to list pay types for all companies.

 

Field Name

Description

Company ID

Company the pay type is associated with.

Pay Type

Pay Type code that will be displayed on reports.

Name

Pay Type name that will display when entering time within TimeStar™.

Description

Description of Pay Type.

Active Flag

Active status – If a pay type is not active, it will not be available for selection.

Dollars Flag

Select ‘Yes’ if the pay type is to be used for entering dollar amounts (will appear on the dollars screen).

Hours Flag

Select ‘Yes’ if the pay type is to be used for entering hours (will appear on the hours screen).

Regular Flag

Select ‘Yes’ if the pay type is a regular hours pay type. This is used by reports to place the regular hours in the ‘REG’ column.

Overtime Flag

Select ‘Yes’ if the pay type is an overtime hours pay type. This is used by reports to place overtime hours in the ‘OVT’ column.

Request Flag

Select ‘Yes’ if employees may request paid time off with this pay type.

Absent Flag

Select ‘Yes’ if an employee is considered absent if this pay type is entered on a timesheet. This option is used for the absentee report to determine absence percentages.

Attendance Category

If the pay type is to transfer to the attendance module, select the attendance category. Please contact Insperity Time and Attendance for additional setup.

Mileage Flag

This option determines if the pay type will be available on the Mileage option on Dollars page.

Pay Factor

 

 

This determines the rate at which the earnings are calculated. For example, if you pay time and a half for overtime, and this is the Overtime panel, the factor would be established as 1.5. If no factor amount applies, set the pay factor to ‘1’. This field applies to TimeStar™ reports only.

Select the checkbox and ‘Delete Selected’ to remove the pay type from TimeStar™.

 

Phone Type Codes – Listing of phone types available when entering employee information on the Employee Maintenance – Employee Information - Contact Info page.

 

Premium Rate Types – Listing of premium rate types available for selection on the Company Setup – Premium Setup – Premium Rules page.

 

Punch Category Codes – Listing of available punch categories that will display on Daily Procedures – Data Entry - Punches.

 

Race Codes – Listing of race codes available when entering employees on the Employee Maintenance – Employee Information - Employee Profile page.

 

Shift Types – Listing of shift codes that will be used in differential pay calculation and the list of shift types available for selection on Employee Maintenance – Employee Information - Employee Profile.

 

States – Listing of states & provinces in the US, Mexico & Canada.

 

Tax Filing Status Codes – Listing of tax filing codes available for employees (Married, Single) that will be listed on the Employee Maintenance – Employee Information - Employee Profile page.

 

Termination Codes – Listing of termination codes available to employees on the Employee Maintenance – Employee Information - Employee Profile.

 

Time Zone – Listing of global time zones.

 

Unit Types – Listing of unit types to be used on the Daily Procedures – Data Entry - Units page.

 

Valid Punch categories – TimeStar™ does not currently use this reference table.

 

Vehicles – Enter vehicles to be used for the mileage module on this panel. Vehicle rates may be specified up to 3 decimal places.