qsqpdefined
QueryScan/QueryPear Defined
Two new query conversations:
The Administrative Information System known as HEPPS Inquiry has been modified to include two new query conversations:
QRYSCAN — To query the SCAN Distribution File
QRYPEAR — To query the PEAR Distribution File
Account entries in each file sort current positive pay time transactions and/or payroll expenses into the appropriate department zip code for on-line display or hard copy forms printing.
Payroll Services staff maintains each file based on information provided by departments. The accuracy of the data contained within these files drives the correct distribution of both positive pay and PEAR transactions to the correct individuals responsible for entering, reviewing, or approving the data.
Payroll Services must be notified by department personnel whenever new salary accounts are established.
SCAN DISTRIBUTION FILE
As part of the SCAN create process, the funding source for each active appointment is compared to the SCAN Distribution File. If no account match is found, then the positive pay time transactions print on hard copy Unit Pay Report form (commonly known as a SCAN Sheet) and is routed to Payroll Services.
Payroll staff must determine where each time transaction must be routed before the release of any SCAN Sheets. This exact procedure occurs for departments using DEPTPAY, i.e., if no account match is found, then hard copy SCAN Sheets will be produced and the department must come to Payroll Services and retrieve the SCAN Sheets (if off campus, SCANS will be faxed).
This can be avoided if Payroll Services is notified about any new salary accounts before SCANS are printed.
HOW QRYSCAN WORKS
There are three (3) ways to view account information in the SCAN file:
1. To view entire file, press PF1
2. To view accounts by department zip code, press PF3, key in zip code, press ENTER.
3. To view specific account details, key in account (budget and project), press ENTER.
Off-campus units have unique zip codes assigned by Payroll Services and the zip code in the SCAN file may be different in the PEAR file. Press PF1 to view entire file to determine the zip code assigned by Payroll.
If the account number is not found in the file the message Record Was Not Found 2 will appear in the top left-hand corner of the screen. All new account numbers must be found in Balances and must be active.
The SCAN file attributes are:
Attribute | Column | Length | Rules |
Budget | 1-4 | N4 | See below |
Project | 6-9 | N4 | See below |
Dept. Zip | 12-15 | A4 | NNNN |
Dept. Name | 17-31 | A15 | |
AIS User ID Primary | 32-38 | A8 | |
AIS User ID Secondary 1 | 39-46 | A8 | |
AIS User ID Secondary 2 | 47-54 | A8 | |
AIS User ID Secondary 3 | 55-62 | A8 | |
AIS User ID Secondary 4 | 63-70 | A8 |
BUDGET/PROJECT ACCEPTABLE VALUES
Values | Example |
BBBBPPPP | One Account |
BBBBPPPX | One Budget, As Many as 10 Projects |
BBBBPPXX | One Budget, As Many as 100 Projects |
BBBBPXXX | One Budget, As Many as 1,000 Projects |
BBBBXXXX | One Budget, All Projects |
BBBXXXXX | As Many As 10 Budgets and All Projects |
BBXXXXXX | As Many as 100 Budgets and All Projects |
Example: | |
BBBBPPPP | HEPPS USER ID’S |
1234XXXX | SMITH, JONES |
12340010 | MILLER, ANDERSON |
SMITH and JONES will have access to ALL accounts for budget 1234 EXCEPT 1234-0010, which ONLY MILLER and ANDERSON will have access to. Generally speaking, access at any level in the wildcard hierarchy is across the board, except that any access specified at lower levels in the same hierarchy structure is excluded.
Department personnel may revise their account configurations to eliminate redundant table entries.
PEAR DISTRIBUTION FILE
During the payroll calculation process, the funding source for each payroll expense is compared to the PEAR Distribution File. If no match is found, then the payroll expenses detail is printed on a hard copy Payroll Expenditure Audit Report form and it is routed to Payroll Services.
Payroll staff must determine where each payroll expense must be routed before the release of any PEARS. This exact procedure occurs for departments using DEPTPAY, i.e., if no account match is found, then hard copy PEARS will be produced and the department must come to Payroll Services and retrieve the PEAR reports (if off-campus, PEARS will be faxed). This can be avoided if Payroll is notified about new salary accounts before PEARS are printed.
HOW QRYPEAR WORKS
1. To view entire file, press PF1
2. To view accounts by department zip code, press PF2, key in zip code, press ENTER.
3. To view specific account details, key in account (budget and project), press ENTER.
Off-campus units have unique zip codes assigned by Payroll Services and the zip code in the PEAR file may be different in the SCAN file. Press PF1 to view entire file to determine the zip code assigned by Payroll.
If the account number is not found in the file the message Record Was Not Found 2 will appear in the top left-hand corner of the screen. All new account numbers must be found in BALANCES and must be active.
The PEAR file attributes are:
Attribute | Column | Length | Rules |
Budget | 1-4 | N4 | See below |
Project | 6-9 | N4 | See below |
Dept. Zip | 12-15 | A5 | NNNN or NNNNA |
Dept. Name | 19-43 | A25 | |
Dept. Contact Phone | 51-58 | A8 | |
Work County Code | 68-69 | N2 | |
Print 3rd Copy | 80 | A1 | |
AIS User ID Primary User | 81-88 | A8 | |
AIS User ID Secondary 1 | 89-96 | A8 | |
AIS User ID Secondary 2 | 97-104 | A8 | |
AIS User ID Secondary 3 | 105-112 | A8 | |
AIS User ID Secondary 4 | 113-120 | A8 |
BUDGET/PROJECT ACCEPTABLE VALUES
Values | Example |
BBBBPPPP | One Account |
BBBBPPPX | One Budget, As Many as 10 Projects |
BBBBPPXX | One Budget, As Many as 100 Projects |
BBBBPXXX | One Budget, As Many as 1,000 Projects |
BBBBXXXX | One Budget, All Projects |
BBBXXXXX | As Many As 10 Budgets and All Projects |
BBXXXXXX | As Many as 100 Budgets and All Projects |
Example: | |
BBBBPPPP | HEPPS USER ID’S |
1234XXXX | SMITH, JONES |
12340010 | MILLER, ANDERSON |
SMITH and JONES will have access to ALL accounts for budget 1234 EXCEPT 1234-0010, which ONLY MILLER and ANDERSON will have access to. Generally speaking, access at any level in the wildcard hierarchy is across the board, except that any access specified at lower levels in the same hierarchy structure is excluded.
Department personnel may revise their account configurations to eliminate redundant table entries.
Changes in the SCAN and/or PEAR Distribution Files may be made for various reasons, such as:
- Department name change
- Department zip code change
- Primary/Secondary AIS User ID changes
- To consolidate account entries
- To establish table entries for new account(s)
Notify Payroll Services via e-mail to payroll@wsu.edu (or a memorandum addressed to the Payroll Officer) and include the following data:
- Name and phone number of department contact person
- Department zip code
- Which file to update — SCAN, PEAR or both
- Account(s) to be updated
- Description of requested change
Change requests affecting SCANS should be received in Payroll Services two (2) days before SCANS are scheduled to be distributed. Change requests affecting PEARS should be received in Payroll Services two (2) days before PEARS are scheduled to be distributed.
Consult the Payroll Documents Schedule for distribution dates.