Feature - Add CSV Support to Payroll History Reports

Feature - Add CSV Support to Payroll History Reports

Release Date: 3/10/2016

Added CSV support to Payroll History Reports: Payroll Check History By Paid Period and
Payroll Check History By Check Date

Note: Support was just added on 3/1/16 to the PRHISFIL for the vacation, holiday and sick 
hours so these fields will not be populated in older data.

If the user chooses to generate the CSV file, one record will be generated for every record
printed on the report. The following headings will be used:

Emp# for Employee Number
Name for Employee Name
SS# for Social Security Number
StrtDate for Pay Period Start Date
EndDate for Pay Period End Date
Tp for Transaction Type
Check# for Check Number
CheckDt for Check Date
GrossPay for Gross Pay
FwtGross for Pay subject to Federal withholding taxes - TAXABLE-GROSS-PAY
SSTax for Social Security Tax withheld
Medicare for Medicare Tax withheld
Fwt for Federal withholding taxes
Swt for State withholding taxes
Ost for Other state taxes
Cwt for City withholding taxes
TtlDed for Total Deductions withheld
TtlAllow for Total Allowances
EIC for Earned Income Credit
NetPay for Net Pay
WksWrk for Weeks worked
RegHrs for Regular hours
OvtHrs for Overtime hours
VacHrs for Vacation hours
HolHrs for Holiday hours
SickHrs for Sick hours
SpecHrs for Special hours 


Modified programs: PRHSTSCN, PRHSTRPT
DLM




    • Related Articles

    • Feature - AP Check History CSV Creation

      Release date: 11/21/17 In AP --> Reports --> Check History --> Print --> Checks History report, the ability to create a CSV file has been added: Fields on the CSV include: Vendor#, Name, Check#, CheckDate, Voucher#, PO#, Invoice#, InvoiceDate, ...
    • PRHISTSC Payroll History Reports: Index

      Due to the size of the document entitled "PRHISTSC Payroll History Reports," we have divided it into several sections within the Knowledge Base. What follows is an index listing the contents of each section, along with a link to each one. PRHISTSC ...
    • PRHISTSC Payroll History Reports 2

      Entry Field Descriptions Payroll Check History Report Name Type and Description 1. Print Report ? Y or N. Defaults to Y. 2. Purge File ? Y or N. Defaults to N. Be certain the file is to be purged before answering YES to the Purge File? question. Once ...
    • AP11S1 Accounts Payable Check History Report

      Check History Report Application Overview The Check History Report accesses the A/P Open Item File for check information. The A/P Open Item File contains information since the last purge date (date for which the Purge A/P Open Item File was last ...
    • PRHISTSC Payroll History Reports 3

      Print Payroll Check History Report Print Deduction/Earning History Report L And I Code Menu L And I History Report By L And I Code L And I History Report By Employee L And I History Report By State