PAYROLL EDIT TABLE INQUIRY

Use this screen to access the audit trail that is maintained for the Employee Payroll table. This screen displays all employee-related information in the Maintain Payroll Edit Table screen. In addition, the screen displays information specifying by whom and on what date modifications were made to the record.

Use this screen whenever you need to review changes made to the Maintain Payroll Edit Table screen. Employee Payroll table information must already exist, and only modifications made when the Payroll Edit Table checkbox is selected in the Payroll Settings screen will be displayed.

Select

Use this group box to select the parameters pertaining to the records you want to review. You can select records for review based on the types of transactions, the employee whose record was changed, the system user who made the modifications, and/or the date of any modifications. Once you have made your selections, use the Execute button on the toolbar to fill the table window with the records you selected.

Transaction Type

Use the options in this group box to select which type of transactions to display in the retrieved records table.

Add

Select this checkbox to include "Add" transactions.

Delete

Select this checkbox to include "Delete" transactions.

Update

Select this checkbox to include "Update" transactions.

Identification

Use the fields in this group box to select which employee's records to include in your review. You can also elect to review only the modifications made by a single system user.

Employee

Enter, or use Lookup to select, the employee ID for the employee whose records you wish to include in the record selection process. This is an optional field; if this field is left blank, the system will include all employees in the search.

User

Enter the user ID (Costpoint Login ID) for the system user who is responsible for the modifications you wish to include in the record selection process. This is an optional field; if this field is left blank, the system will include records regardless of who made the modifications.

Date Modified

Enter, or use Lookup to select, the date of the transaction modifications to include in the displayed output. This is an optional field; if this field left blank, the system will include records regardless of when the modifications were made. The system format for date is "MM/DD/YYYY."

Federal/State Wages and Taxes

Trans Type

This non-editable field displays the type of modification for the specific transaction displayed: "A" (Add transaction), "D" (Delete transaction), or "U" (Update transaction).

Disb Code

This non-editable field displays the disbursement code, "C" (Check) or "D" (Direct deposit advice), for the employee referenced in this transaction.

Employee

This non-editable field displays the ID of the employee whose record was modified.

Name

This non-editable field displays the name that corresponds to the employee ID for this transaction.

Modified By (User)

This non-editable field displays the user ID (Costpoint login ID) for the system user who made the modification(s) shown in this transaction.

Date Modified

This non-editable field displays the date on which the modification took place for this transaction.

Check Type

This non-editable field displays the check type for the employee referenced in this transaction. The field will contain an "R" (Regular Paycheck), "B" (Bonus Paycheck), or "X/Y" (Paycheck without Timesheet).

Pay Cycle

This non-editable field displays the pay cycle assigned to the employee referenced in this transaction.

Pay Cycle End Date

This non-editable field displays the pay cycle end date for this transaction.

Company

This non-editable field displays the company to which the employee in this transaction is assigned.

Check Number

This non-editable field displays the paycheck number issued for this transaction.

Check Date

This non-editable field displays the date on which the paycheck was issued for the check referenced in this transaction.

Gross Pay

This non-editable field displays the amount of gross pay for the employee and check referenced in this transaction.

Reimbursement Amount

This non-editable field displays the total reimbursement amount excluded from gross earnings for the payroll record.  This total includes any earnings amount from the Reimbursements field in the Maintain Payroll Edit Table screen (where the Pay Type's Reimbursement-Exclude from Gross field is "Y" in the Pay Types subtask in the Maintain Payroll Edit Table screen).

Net Pay

This non-editable field displays the net pay for the employee and check referenced in this transaction.

Total Hours

This non-editable field displays the total hours that were charged from the timesheets that were processed for the employee referenced in this transaction.

Federal Exempt Pay Types

This non-editable field displays the total of the federal exempt pay types for the employee referenced in this transaction.

Federal Exempt Deductions

This non-editable field displays the total of the federal exempt deductions for the employee referenced in this transaction.      

Federal Taxable Wages

This non-editable field displays the federal taxable wages for the employee referenced in this transaction.

Soc Sec Exempt Pay Types

This non-editable field displays the total of the social security exempt pay types for the employee referenced in this transaction.

Soc Sec Exempt Deductions

This non-editable field displays the total of the social security exempt deductions for the employee referenced in this transaction.

Soc Sec Taxable Wages

This non-editable field displays the social security taxable wages for the employee referenced in this transaction.

Medicare Exempt Pay Types

This non-editable field displays the total of the Medicare exempt pay types for the employee referenced in this transaction.

Medicare Exempt Deductions

This non-editable field displays the total of the Medicare exempt deductions for the employee referenced in this transaction.

Medicare Taxable Wages

This non-editable field displays the Medicare taxable wages for the employee referenced in this transaction.

Federal Withheld

This non-editable field displays the amount of federal income taxes withheld for the employee referenced in this transaction.

Social Security Withheld

This non-editable field displays the amount of social security taxes withheld for the employee referenced in this transaction.

Social Security Accrued

This non-editable field displays the employer expense accrued for social security for the employee referenced in this transaction.

Medicare Withheld

This non-editable field displays the amount of Medicare taxes withheld for the employee referenced in this transaction.

Medicare Accrued

This non-editable field displays the employer expense accrued for Medicare for the employee referenced in this transaction.

Advance EIC Taxable

This non-editable field displays the amount of advance EIC for the employee referenced in this transaction.

FUTA Taxable Wages

This non-editable field displays the amount of FUTA taxable wages for the employee referenced in this transaction.

FUTA Accrued Exp

This non-editable field displays the amount of FUTA accrued expense for the employee referenced in this transaction.

SUTA State

This non-editable field displays the two-character code for the SUTA state assigned to the employee referenced in this transaction.

SUTA Taxable Wages

This non-editable field displays the amount of SUTA taxable wages for the employee referenced in this transaction.

SUTA Accrued Exp

This non-editable field displays the amount of SUTA accrued expense for the employee referenced in this transaction.

Withholding State

This non-editable field displays the two-character code for the withholding state assigned to the employee referenced in this transaction.

State Taxable Wages

This non-editable field displays the amount of state taxable wages for the employee referenced in this transaction.

State Withheld

This non-editable field displays the amount of state income taxes withheld for the employee referenced in this transaction.

Pay Types

Select this pushbutton to open the Pay Types Inquiry subtask.

Worker's Comp

Select this pushbutton to open the Worker's Comp Inquiry subtask.

State Taxes Inquiry

STATE TAXES INQUIRY

Deductions

Select this pushbutton to open the Deductions Inquiry subtask.

Contributions

Use this pushbutton to open the Contributions Inquiry subtask.

Localities

Use this pushbutton to open the Localities Inquiry subtask.

Source Tables

Deductions - DED_CD

Basic Employee Info - EMPL

Pay Types - PAY_TYPE

Worker's Comp - WORK_COMP

Payroll Edit Table Audit - EMPL_PAYROLL_ADT

EMPL_PR_CNTRB_ADT

EMPL_PR_DED_ADT

EMPL_PR_LOCAL_ADT

EMPL_PR_PAY_TP_ADT

EMPL_WC_ADT