Work Rate Relay is a ServiceNow scoped application designed to streamline employee performance reviews by automating data entry, notification delivery, and reporting. Built using ServiceNow Studio and Git source control, this project showcases practical application development across custom tables, workflows, email notifications, and real-time analytics.
This app was developed as part of a training project to demonstrate end-to-end capabilities in ServiceNow development — including table design, email triggers, report configuration, and scoped app packaging.
- ServiceNow Studio (Scoped Application)
- Git Integration with Source Control
- ServiceNow Tables & Dictionary
- Email Notifications
- Pie Chart Reporting
- HTML Fields & Choice Fields
| Module | Description |
|---|---|
| Employee Table | Stores employee name (linked to sys_user), and their work done for FY24 |
| Manager Table | Stores manager's reviews, ratings, and linked employee |
| Email Notifications | Auto-send to manager when employee logs entry; notify employee when rated |
| Rating Reports | Pie chart view summarizing employee ratings |
🧑💼 Employee Table
- Employee ID (auto-generated)
- Employee Name (Reference: sys_user)
- Work Done in FY24 (HTML)
👨💼 Manager Table
- Manager Name (Reference: sys_user)
- Employee Name (Reference: sys_user)
- Performance Review (HTML)
- Rating (Choice: Excellent, Very Good, Good, Bad)
-
When an employee creates a new record, the system:
- Sends an email to the assigned manager
- Includes all "Work Done in FY24" details
-
When a manager updates the rating field:
- The system sends an email to the employee
- Includes the rating and performance review text
Emails are triggered using standard Notification Rules configured via Conditions and Template Variables.
-
Pie Chart report categorizes employee performance by rating level:
- Excellent: 2 employees
- Very Good: 5 employees
- Good: N employees
- Bad: N employees
-
Accessible via Reporting → Create New → Chart → Table: Manager
-
The application changes are stored in an Update Set called: sys_remote_update_set_011924eec36a2e1049ccbd0ed40131a6.xml
-
This allows easy export/import into other instances if needed.
- Clone this repository.
- Open your PDI (Personal Developer Instance).
- Go to Studio → Import from Source Control.
- Connect to this GitHub repo and pull changes.
- Activate Email Notification Plugin (if not already enabled).
- Preview and commit each file in the Update Set to move changes.
- Form layout for Employee table
- Manager review interface
- Example email template
- Sample Pie Chart report
Hi, I’m Anu — a developer passionate about business process automation and ITSM platforms. This project reflects my learning journey in ServiceNow platform development, and I hope it helps others
This repository now includes the Work Rate Relay scoped application created in ServiceNow Studio. The scoped app encapsulates all custom tables, forms, notifications, and reports related to managing employee performance reviews.
- The scoped application work-rate-relay in ServiceNow Studio is linked to this GitHub repository for version control and collaborative development.
- Source control is managed using ServiceNow Studio's built-in Git integration.
- Changes pushed from ServiceNow Studio will sync with this repo's branches, ensuring a consistent development workflow.
/update_sets— Exported Update Set XML files (if any)/docs— Project documentation, including notification specs/screenshots— UI and report screenshots/data— Sample data or test records.gitignore,LICENSE, and thisREADME.md— At root for project metadata and git management
- Continue developing features within the scoped app using ServiceNow Studio.
- Commit and push updates regularly to this GitHub repository.
- Keep documentation and sample data up to date for easier onboarding and review.
Developed by Anu — www.linkedin.com/in/anurampallichitta