| Search: | Browse by Category: |
| 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? |
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 |