Employee Activity Monitor Screen is a robust DNAapp that enables users to monitor, review, and approve/reject user-defined categorization of employee activities. This application displays maintenance activities that have occurred based upon user defined criteria such as Status, Group and Categories, date range and employees designated to that group.
This application also allows users to identify employees who are not linked to an activity user group that have performed the specified maintenance activities within the user defined date range.
Easily view, monitor or mark for review specific maintenance activities conducted by employees within DNA.
Categorize activities based on the DNA database Tables, Activity Type and Activity User Groups.
View activities based upon a wide range of flexible, user specified search criteria.
Review the activity performed and set the review status.
Increase usability by using the column alias feature to rename difficult database columns.
Focus on relevant activities by eliminating unnecessary data.
This application consists of a batch program PG_AMSACTVUPDATE.SQT that will delete orphaned records in the OSIEXTN. AMSACTVUPDATE table. This program will check the OSIEXTN tables against OSIBANK.ACTV table using Activity Number as the search key. If the Activity Number exists in OSIEXTN.AMSACTVUPDATE table and not in OSIBANK.ACTV table then the records from OSIEXTN. AMSACTVUPDATE table will be purged.
Following tables are created by this application in the OSIEXTN schema:
Write Your Own Review
Only registered users can write reviews. Please, log in
DNA 4.1 or higher
Employees must have permissions set up for the following Authorization Items to access the Employee Activity Monitoring: