PW - Employee Pay Wage Detail

  • History report Detail topic.

  • Accesses data from the Employee Payments and Employee Time Cards files.

  • Provides data about employee wage records by pay summary group, Pa payment number and date, and time record.

  • Valid only with the Payroll system.

  • Data loaded by all time records, Manual Payment (PR80.1) and Adjustment (PR82.1). Payroll Close (PR197) creates records.

An asterisk (*) indicates a database field used for date range searches.

Item name Description
Account Category Account category
Activity Employee's work activity
Department Department where the wage expenses are distributed
Dist Account Number Account number where the payment or adjustment is posted
Dist Account Unit Accounting unit to which you want to post the time record amount
Dist Company Company where the payment is posted
Dist Full Account Full account (accounting unit, account, and subaccount) where the payment is posted
Dist Subaccount Subaccount where the payment or adjustment is posted
Hours Total number of hours for the pay summary group
Job Code Employee's job code associated with this record
Overtime Premium Overtime premium portion of the wages
Pay Code Pay code that identifies the kind of pay
Pay Code Description Pay code description
Pay Sum Group Desc Pay summary group description
Pay Summary Group Pay summary group for this record
Payment Date* Date of payment or adjustment
Payment Date - Day Payment day
Payment Date - Month Payment month
Payment Date - Year Year in which payment or adjustment is made
Payment Department Employee's home department at time of payment or adjustment
Payment Description Pay summary group description printed on the payment
Payment Number Receipt or payment number of payment
Payment Proc Level Employee's home process level at time of payment
Payment Status Status of payment
Payment Type Payment type
Payroll Year Calendar year
Per End Date - Day Period ending day
Per End Date - Year Period ending year
Percent Distribution Indicates if a percent distribution record exists for the pay code
Period Ending Date Period ending date for payment
Position Employee's position
Process Level Process level where the wage expenses are distributed
Quarter Number Quarter number within the payroll year
Rate Rate on time record
Shift Shift associated with the pay
Shift Diff Rate Shift differential rate
Shift Differential Shift differential associated with the pay code
Temp Payment Number Internal identification number of payment
Time Record Date Time record date
Unit of Measure Pay unit of measure
Unemployment State Employee's work state at time of payment.
Union Employee's current union code
WC State Worker's compensation state associated with the payment or adjustment
Wage Amount Total wage amount for the pay summary group, including overtime premium amount
Work State, Tax Prov Employee work state or tax province