KBACE Payment Register

Description

Purpose

The KBACE Payment Register Report includes two work sheets each with a pivot table. The first work sheet is Employee Counts. The second work sheet is Payment Register. Also available on drill down are all employees paid and the associated values.

Frequency

This report can be viewed after a payroll run.

Understanding the Output

A Pivot Table report is an interactive table that combines and compares large amounts of data. You can rotate its rows and columns to see different summaries of the source data, and you can display the details for areas of interest.

Fields at the top of the spreadsheet can be used to create summarized subsets of information. By clicking on the arrow next to a field you can select a specific value to be used to summarize the data in the report.

The field selected to summarize data can be moved into the table pivot table report.

To drill down to the detail data, double click on a field in the summarized pivot table to see the detail data.

Refer to Help in Excel for information on using pivot tables.

Pivot Table Fields (Rows Displayed at Top of Report in Order) - Summary Options

Name	Description
Organization	Specific location and specific department at the location to which the person is assigned. This is NOT the Operating Location Organization. For example: 010-Small Business Development Center
Operating Location	Location where the employee works.
Effective Date	Date of payroll run.

Pivot Table Columns (Summarized Data) Displayed in Order

Name	Description
Payroll Method	Method used to make payment. Examples: check, direct deposit
Check/Advice Count	Total number of transactions processed for a check or direct deposit.
Payment Amount	Total amount of payments.

Detailed Data Fields Displayed on the First Drill down in column Order

Name	Description
Person Name	Last name and first name (separated by a comma) of the person that was paid.
Last Name	Last name of the person that was paid.
First Name	First name of the person that was paid.
Middle	Middle name of the person that was paid.
Title	Title that precedes the person's name. For example: Mrs.
Assignment Number	System generated employee number used as a unique identifier of a person whose record is in the RF Oracle business system.
Social Security Number	Social security number of the person that was paid.
Mailstop	Delivery drop where paycheck or stub was delivered.
Check Number	If the Payment Method used is Check, this field will hold the check number.
Check Amount	Amount of check
Effective Date	Date of payroll run.
Payment Method	Method used to make payment. Examples: check, direct deposit
Account Type	If Payment Method is Direct Deposit this will indicate whether the deposit was to a checking or savings account.
Account Number	Number of the bank account.
Bank Name	If Payment Method is Direct Deposit this is the Bank where the money was sent.
Routing Number	Code that identifies the bank to which the employee's funds will be transferred.
Organization	Specific location and specific department at the location to which the person is assigned . This is NOT the Operating Location Organization. For example: 010-Small Business Development Center
Operating Location	Location where the employee works.

Helpful Tips

For complete details on running Oracle reports, refer to the Run a Report help topic.

Effective Date: 1/31/2007 9:58:02 AM