System queries are queries that are created by TEAM and are included with Query Scheduler.
The System check box on the Query Scheduler (General tab) indicates whether a query is standard or custom.
- If the check box is selected, TEAM created the query, so it is standard.
- If the check box is cleared, a WinTeam user created the query, so it is custom.
Here is a list of system queries, their identification numbers, and whether they are active by default.
| ID | Description | Active |
|---|---|---|
| 1 | All CA Employees with an OT Method <> 2 | No |
| 2 | Employee Birth Date greater than Hire Date | No |
| 3 | Jobs With State Not EQ PR Tax State Code | No |
| 4 | Employees with OT Method | No |
| 5 | AR Applied Amt Greater Than Inv Amt | No |
| 6 | AR Invoices Funny Amount Applied | No |
| 7 | AR Find AR Invoices Not Equal To AR Details Final | No |
| 8 | AR Invoices Amt Paid Not equal to Tax+Revenue | No |
| 9 | AR Invoices Amount Paid Not Equal To Amt Applied | No |
| 10 | AR Invoices Payment Status Correct | No |
| 11 | AR Payments Equals AR Payments Invoices | No |
| 12 | Benefits with No Tiers Problems | No |
| 13 | Benefits with Tiers Problems | No |
| 14 | GL Log Find Dups | No |
| 15 | Emp Status Hist Eff Date To Far In The Future | No |
| 16 | PAY Check Batches Posted but Not in GL | No |
| 17 | Emp with Hire date before Job Start Date | No |
| 18 | Employee with State Address diff than Tax State | No |
| 19 | AR Invoices Outstanding for More than 120 days | Yes |
| 20 | Emps with a Duplicate Primary Direct Deposit Acct | Yes |
| 21 | AR - # of days in AR by Customer | Yes |
| 23 | PR - Checks marked to be recalced | Yes |
| 24 | AR Invoices Outstanding 30, 60, 90, 120 Days | Yes |
| 25 | HR - Emp Turnover % by Supervisor | Yes |
| 26 | AR - # of days in AR by Customer | Yes |
| 27 | PR - Active Employee Phone List | Yes |
|
(not a set number) |
401K YTD |
No |