Search: Browse by Category:
FAQ Main Page > General
ASK QUESTION
For auditing purposes, how would I access the information stored in Temps Plus to show the user and date/time something was entered or changed?
 
Print
Tell A Friend
Author: writeAuthor
Views: 41
Votes: 1

 

Temps Plus tracks this audit type information for the following tables:

 

Customers

Employees

Applicants

Appointments

Attachments

CheckHistoryAudit (Checks changed in History)

CurrentBatch (Time card entries)

CurrentHistory Voids (Checks voided in History)

CurrentVoidChecks (Checks voided in Current Period)

Orders

PeriodBatch

Placements

Pr3Eded (automatic employee deductions)

 

 

Since these items are somewhat of a sensitive nature to some folks, you would need to run a query, or a custom report to get the info. If you are just looking occasionally at a record as needed, here are queries you can run to see the information without the trouble of creating a custom report (you need to be logged in as SUPER to create a query).

 

Customers

SELECT Customer, CustomerName, CustSetupBy, CustSetupDate FROM Customers WHERE Customer = CustomerCode

 

Employees

SELECT PR3MSTR.EmployeeNumber, Applicants.LastNameFirst, Applicants.ApplicantID, EmpChangedBy, EmpChangedDate FROM Pr3Mstr INNER JOIN Applicants ON Applicants.ApplicantID = PR3MSTR.ApplicantID WHERE Applicants.ApplicantID = EnterApplicantID

 

Applicants

SELECT LastNameFirst, ApplicantID, AppChangedBy, AppChangedDate FROM Applicants WHERE ApplicantID = EnterApplicantID

 

 

Last update: 07:28 PM Tuesday, July 11, 2006

Related Questions: