TransType Codes

Overview

When payroll is entered or processed, the system creates payroll details for each pay.

Payroll details consist of things such as earnings, deductions, taxes, etc.

The TransType assigned to the payroll detail tells how that item is/was used within the software.

TransTypes are used in several tables in the ReadyPay database. These tables are:

• EPayEntryDetail
• EPayHistDetail
• ELaborDist
• EPayPreCalcDetail
• EPayManualDetail

TransTypes are used to identify how a particular payroll detail item was entered into the system. Examples of this include (but are not limited to) AutoPost, Time Import or User Entry.

TransTypes also identify payroll details created by payroll processing. Examples of this include (but are not limited to) Employer Taxes, Memo entries or dropped deductions. Typically you will find more TransTypes in use by the tables populated by payroll processing (EPayHistDetail, ELaborDist).

Following is a list of the TransTypes used by ReadyPay and a description of their function.

Code	Description
M	Memo Earning or Deduction (e.g., ER Match, ER Medical Costs)
X	Dropped Deduction (e.g., Insufficient net on deduction without Partial Drop)
C	Calculated Amount (The Payroll detail could change if Check is reprocessed)
Y	Setting that tells system to NOT recalculate (e.g., Manual Check Details)
R	Employer Tax
Z	Matching Item (e.g., Matching Deduction such as Tips Out)
I	Transaction was posted as an Insurance entry
T	Time Import
A	Auto Post (originates from Company Auto Post and/or Employee Auto Pays Tabs)
U	Entry made by User in Payroll and not reclassified to another trans type for reporting purposes by ReadyPay

Working with TransTypes

TransTypes need to be considered when building Crystal Reports or SQL Queries that use any of the tables listed above.

Failure to consider them will result in erroneous data returned by the report or the query.

For example, you want the total of all the earnings for a particular check. That check has Memo entries (TransType M). Your filter statement includes all entries with a DET (Deduction/Earnings/Taxes) value of E for earnings. The returned totals will be overstated by the Memo entries unless you filter your selection to exclude Trans Type M items: DET = 'E' and transtype <> 'M'.

If you only want memo items, filter should be for DET = 'E' and transtype = 'M'.

The same logic applies to Tax Details (DET = 'T'). If you want to include only Employee Tax details, you must filter to exclude the TransType of R.

For Employer Taxes only, filter for DET = 'T' and transtype <> 'R'.