Atrieve Payroll

Storage Bank Hours Pay Out Process

The Storage Bank Hours Pay Out Process allows you to pay out storage bank hours using the pay rate from the employee's master function line. This option generates timesheet entries with a wide range of employee/function line selections and up to five sets of exclusion criteria. Terminated and On Leave employees will be omitted as well as employee with a Lump sum master function lines. Employees with a master function line that is inactive due to being out of cycle or shut down based on the dates, will be bypassed. Only positive hour balances will be paid out. Employees with a negative or zero balance storage bank will be omitted.

Note: There is an option to define a FIXED Payout Rate on Accrual and Increment Storage Bank Tables. That FIXED Payout Rate would be used for this process in place of the employee's function line rate.

Both the selection criteria value and the exclusion criteria value allow the use of the wild card '?' character. The '?' character means that the element value is to be taken from the employee's applicable code to form a new selection code or a new exclusion code. For example, enter a selection salary grid with the value of SU????, means include employees where on the master function line the salary grid begins with 'SU'.

This process includes the option to maintain multiple sets of stored prompts.

Name the prompt sets by defining a title up to 10 characters, with a 30-character description.

On the first prompt click the Report Defaults icon to select an existing set of prompt values. You can delete prompt sets or change the description from the Report Default icon.

This option will run in batch only.

Select Employee's by Code 

Employee Number

EM


Pay Code

PC

Location Code

LC


COST Centre

CS

Salary Grid

GR


Occupation Code

OC

Pay CYCLE Code

CY


Employee Type

ET

Pay Type

PT


Shift Code

SC

  • Enter a 2-character code to define the field to use for employee/function line selection.

Enter 'EM' to select employees based on employee number.

When employee selection is by Employee Number:

Report All or Selected Employees

When employee selection is based on any field other than employee number, you are prompted to Enter one or more of that code or value. You may Enter valid codes or any combination using the wild card '?'. The wild card is not a valid entry for numeric fields such as hours. The list of values entered will determine if an employee's function line will be selected.

Select Item for Code Exclusion #1

Employee Number

EM


Pay Code

PC

Location Code

LC


COST Centre

CS

Salary Grid

GR


Occupation Code

OC

Pay CYCLE Code

CY


Employee Type

ET

Pay Type

PT


Shift Code

SC

Accept the default when no more exclusion criteria are to be entered. After completing the exclusion definitions all exclusion codes will be listed for reference.

  • Enter one of the 2-character codes to define which field will be used for employee/function line exclusion.

  • Enter 'EM' to select specific employees based on employee number.

You can omit all exclusion criteria or define up to 5 different exclusion criteria sets. When multiple exclusion criteria have been defined, the employee will be excluded if the employee meets any of the exclusion definitions.

When employee exclusion is based on any field other than employee number, you are prompted to Enter one or more of that code or value. You may Enter valid codes or any combination using the wild card '?'. The list of values entered will determine if an employee's function line will be excluded.

Enter hours Storage Bank to pay out

  • Enter a valid storage bank code to be paid out. The storage bank must be defined to have Hours.

Enter Banks Table to pay out

  • Enter the storage bank table code to be used along with the storage bank code entered above.

You can Enter a specific storage bank table code or leave the storage bank table code blank and the system will load the bank table code with the wild card code '?????'.

When the bank table code has been defined as '?????' then all tables for the given storage bank will be paid out.

Enter Batch Period 

  • Enter the pay period under which these timesheet entries will be processed.

Enter Timesheet Entry Date

  • Enter the date to be used for the timesheet entries.

Enter Batch Type Code

  • Enter a valid batch type code.

Enter Batch Pay Code 

  • Enter a valid pay code. Money only pay codes cannot be used.

The pay code entered must be set to Withdrawal from all Storage banks defined to be paid out.

Enter override occupation code 

Leave this prompt blank when an override occupation code is not required.

  • Enter a valid occupation code to be used instead of the occupation code from the employee's master function lines. Entering an override occupation code allows you to prevent the occupation premium from being taken.

Enter override shift code

Leave this prompt blank when an override shift code is not required.

  • Enter a valid shift code to be used instead of the shift code from the employee's master function lines. Entering an override shift code allows you to prevent the shift premium from being taken.

Report Only or Process

  • Enter 'R' to generate just a report. The timesheet batch will not be generated.

  • Enter 'P' to generate the reports and process the timesheet entry batch. Batches generated during the process run will be balanced and closed automatically.

The reports list the following:

The #####E.LST reports non selected or excluded employee's and/or function lines

This#####E.LST report lists the following:

  • The employee number, name and applicable function line number

  • Reason for employee and/or function line non-selection or exclusion

  • Total records excluded

  • Total records selected

The ######. LST Timesheet Entry report lists the following:

  • The employee numbers

  • The date of the entry

  • The function line number

  • The shift code used

  • The pay code and description

  • The hours generated, (storage bank hours balance)

  • The rate per hour

  • The rate including all premiums

  • The pay code, shift and occupation premium amounts

  • The GL account code used

The #####R.LST Timesheet Entry Rejection report lists the following:

  • The employee number and date

  • The original record numbers

  • The message describing the reason the record is invalid

  • Total number of rejected records