VIEW PAYROLL EDIT TABLE

Use this screen to access the audit trail that is maintained for the Employee Payroll table. This screen displays all employee-related information on the Manage Payroll Records 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 Manage Payroll Records screen. Employee Payroll table information must already exist, and only modifications made when the Payroll Edit Table check box is selected on the Configure Payroll Settings screen are displayed.

Location

Selection Criteria

Use this block 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 user who made the modifications, and/or the date of any modifications. After you have made your selections, use 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 check box to include Add transactions.

Delete

Select this check box to include Delete transactions.

Update

Select this check box to include Update transactions.

Identification

Use 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 user.

Employee

Enter, or click 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 program includes all employees in the search.

User

Enter, or click to select, the user ID (Costpoint Login ID) for the 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 program includes records regardless of who made the modifications.

Date Modified

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

Federal/State Wages and Taxes

Transaction Type

This non-editable field displays the type of modification for the specific transaction:

• A — Add transaction

• D — Delete transaction

• 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.

Employee 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 user who made the modifications 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 types are:

• R — Regular

• B — Bonus

• V — Voided

• W — Represents the positive values of a replacement check

• X — Can be used any time you want to generate a paycheck without first entering a 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.

Taxable Entity

This non-editable field displays the taxable entity 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 on the Manage Payroll Records screen (where the Pay Type's Reimbursement Exclude from Gross check box is selected on the Pay Types subtask of the Manage Payroll Records 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.

Subtasks

• Table Information

  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