Employee Activity Monitor Screen

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.

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:

• AMSACTVCAT
• AMSACTVGRP
• AMSACTVGRPCAT
• AMSACTVGRPCATTBL
• AMSACTVGRPEMPL
• AMSACTVREVIEW
• AMSACTVSEARCH
• AMSACTVSTAT
• AMSACTVUPDATE
• AMSCODEVALUEREL
• AMSNOTE
• AMSTBLCOLALIAS 

Benefits

• 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.