Profile avatar Mark Rechsteiner | Time Off Management

Time Off Management Application

A custom ServiceNow application built to manage Annual and Sick leave requests through a Record Producer, Service Portal, approval flow, and automated balance tracking.

Application Overview

This project was built to practice custom table design, Record Producers, Catalog Client Scripts, GlideAjax, Business Rules, and Service Portal development in ServiceNow. The application allows users to request time off, view available balances, submit requests for manager approval, and automatically update balance records when requests are approved.

Quick Walkthrough

  1. Service Portal: Time Off Portal homepage with navigation tiles and calendar.
  2. Record Producer: Submit Annual or Sick time requests.
  3. Balance Display: Show available Vacation and Sick balances on the request form.
  4. Business Rules: Calculate available balance and balance after request.
  5. Approval Logic: Manager approval updates the user’s balance record.

Click here to view the full PDF documentation (design, tables, and fields).

Time Off Application Walkthrough Videos

Placeholder preview for Time Off Portal walkthrough Now playing
Time Off Portal homepage, navigation tiles, and calendar view.
Placeholder preview for Time Off Record Producer walkthrough Now playing
Record Producer, available balance display, and request submission.
Placeholder preview for Time Off approval walkthrough Now playing
Approval process, Business Rules, and balance deduction logic.

App Screenshots

Click any screenshot to view full size.

Time Off app — Service Portal homepage Service Portal Homepage Time Off app — My Requests page My Requests Page Time Off app — Calendar page Calendar Page Time Off app — Record Producer Record Producer Time Off app — Request form Request Form Time Off app — Time Off Balance table Time Off Balance Table Time Off app — Business Rule Business Rule Logic Time Off app — Approval flow Approval Logic

What This App Does Behind the Scenes

  • Custom Tables: Stores user balances and submitted time off requests.
  • Business Rules: Calculate available balance and remaining balance for each request.
  • Approval Logic: Approved requests update the balance table automatically.
  • GlideAjax + Script Include: Retrieves live Vacation and Sick balances and displays them on the Record Producer.
  • Service Portal: Provides a user-facing portal with homepage navigation, request tracking, and calendar views.

Improvements I am currently considering:

  • UI polish: Improve the catalog landing experience and reduce extra clicks.
  • Reporting: Add dashboard views for employee balances and request history.
  • Manager tools: Create a manager-facing dashboard for pending approvals.
  • Notifications: Expand approval and rejection messaging.
  • Policy controls: Add optional warnings or restrictions for low/negative balances.