🚀 Excited to share my latest build for #BuildMoreWithBuildAgent
Built a "Global Career Program" app on ServiceNow to streamline cross-border employee relocations.
Designed for HR teams, it manages the entire lifecycle from initiation to onboarding.
Integrated seamlessly with HR Service Delivery (HRSD) and Employee Center.
Built robust data models covering visa, travel, housing, expenses, and dependents.
Added PPP-based salary adjustment logic for fair global compensation.
Enabled role-based access control for HR, Finance, Managers, and Employees.
Created an intuitive HR dashboard and a self-service employee portal.
A great hands-on experience building scalable, real-world HR solutions!
LinkedIn post link - https://www.linkedin.com/posts/prasanna-kumar-servicenowdeveloper_buildmorewithbuildagent-servicenow...
Pasting the Prompt Used to Build the App with the help of AI -
Build a ServiceNow application named "Global Career Program" scoped under the namespace x_global_career_prog. This application is designed exclusively for HR teams to manage end-to-end employee transitions when an employee relocates from one country to another as part of an international career mobility program. The application must integrate with HR Service Delivery (HRSD) and the Employee Center / Portal.
---
APPLICATION SCOPE & PURPOSE
The application manages the full lifecycle of a cross-border employee relocation, from case initiation by HR Admin through to successful onboarding completion at the destination country. It must support multi-phase workflow orchestration, role-based access control, task management, document tracking, salary adjustment, and a self-service portal view for the employee.
---
DATA MODEL — TABLES REQUIRED
Create the following custom tables with the specified fields:
1. GCP Relocation Case [x_gcp_relocation_case]
- Employee (reference → sys_user)
- Case Number (auto-generated, read-only)
- Source Country (string)
- Destination Country (string)
- Planned Relocation Date (date)
- Actual Start Date (date)
- Expected End Date (date)
- Case Status (choice: Draft, Active, In Progress, On Hold, Completed, Cancelled)
- Assigned HR Business Partner (reference → sys_user)
- Manager (reference → sys_user)
- Current Phase (choice: Initiation, Travel & Visa, Relocation Logistics, Destination Onboarding, Salary Adjustment, Completed)
- Overall Progress % (integer, calculated)
- Notes / Comments (journal field)
2. GCP Visa & Work Permit [x_gcp_visa_permit]
- Parent Case (reference → x_gcp_relocation_case)
- Permit Type (choice: Work Visa, Residency Permit, Work Permit, Dependent Visa)
- Country (string)
- Application Date (date)
- Approval Date (date)
- Expiry Date (date)
- Status (choice: Not Started, In Progress, Submitted, Approved, Rejected, Expired)
- Document Reference (string)
- Remarks (string)
3. GCP Travel Logistics [x_gcp_travel_logistics]
- Parent Case (reference → x_gcp_relocation_case)
- Flight Booking Reference (string)
- Departure Date (date/time)
- Arrival Date (date/time)
- Origin Airport (string)
- Destination Airport (string)
- Booking Status (choice: Pending, Confirmed, Cancelled, Completed)
- Number of Dependents Travelling (integer)
- Special Requirements (string)
4. GCP Housing & Accommodation [x_gcp_housing]
- Parent Case (reference → x_gcp_relocation_case)
- Accommodation Type (choice: Company-Provided, Hotel, Serviced Apartment, Employee-Arranged)
- Address (string)
- Check-in Date (date)
- Check-out Date (date)
- Status (choice: Pending, Arranged, Confirmed, Completed)
- Vendor / Provider (string)
- Monthly Rent / Cost (decimal)
- Currency (string)
5. GCP Relocation Expense [x_gcp_expense]
- Parent Case (reference → x_gcp_relocation_case)
- Expense Category (choice: Flight, Housing, Shipping, Dependent Relocation, Miscellaneous)
- Amount (decimal)
- Currency (string)
- Submitted By (reference → sys_user)
- Submission Date (date)
- Approval Status (choice: Draft, Submitted, Approved, Rejected, Reimbursed)
- Approved By (reference → sys_user)
- Remarks (string)
6. GCP Dependent [x_gcp_dependent]
- Parent Case (reference → x_gcp_relocation_case)
- Full Name (string)
- Relationship (choice: Spouse, Child, Parent, Other)
- Date of Birth (date)
- Passport Number (string)
- Visa Required (boolean)
- Visa Status (choice: Not Required, Pending, Approved, Rejected)
7. GCP Onboarding Checklist [x_gcp_onboarding_task]
- Parent Case (reference → x_gcp_relocation_case)
- Task Name (string)
- Task Category (choice: IT Setup, Benefits Enrollment, Compliance, Payroll & Banking, Buddy Assignment, Office Access & ID)
- Assigned To (reference → sys_user)
- Due Date (date)
- Status (choice: Not Started, In Progress, Completed, Blocked)
- Completion Date (date)
- Notes (string)
8. GCP PPP Salary Index [x_gcp_ppp_index]
- Country (string, unique)
- PPP Index Value (decimal) — represents the Purchasing Power Parity index relative to a base country (e.g., USD baseline = 1.00)
- Currency Code (string)
- Last Updated (date)
- Updated By (reference → sys_user)
9. GCP Salary Adjustment [x_gcp_salary_adjustment]
- Parent Case (reference → x_gcp_relocation_case)
- Source Country (string, auto-populated from case)
- Destination Country (string, auto-populated from case)
- Current Gross Salary (decimal)
- Current Currency (string)
- Source PPP Index (decimal, auto-looked up from x_gcp_ppp_index)
- Destination PPP Index (decimal, auto-looked up from x_gcp_ppp_index)
- PPP Adjustment Factor (decimal, calculated: destination PPP / source PPP)
- Adjusted Gross Salary (decimal, calculated: current salary × PPP adjustment factor)
- Destination Currency (string, auto-looked up from x_gcp_ppp_index)
- HR Recommended Salary (decimal, editable override by HR)
- Finance Approval Status (choice: Pending, Approved, Rejected)
- Finance Reviewer (reference → sys_user)
- Effective Date (date)
- Justification Notes (string)
---
ROLES & ACCESS CONTROL
Define and apply the following custom roles with strict ACL enforcement:
- x_gcp_admin: Full read/write access to all tables and all cases. Can create, edit, delete, and manage all GCP records. Can manage the PPP Index table.
- x_gcp_hr_bp: Read/write access to all relocation case records assigned to them. Can manage all child records (visa, travel, housing, expenses, dependents, onboarding tasks, salary adjustment). Cannot delete cases.
- x_gcp_finance_reviewer: Read-only access to all tables. Write access restricted to the Finance Approval Status and Finance Reviewer fields on x_gcp_salary_adjustment only.
- x_gcp_manager: Read access to relocation cases where they are the assigned Manager. Can approve or reject salary adjustment recommendations.
- x_gcp_employee: Read-only access via Employee Center / Portal to their own relocation case and all associated child records. Cannot edit any data directly.
---
WORKFLOW & FLOW DESIGNER AUTOMATION
Build the following automated flows using Flow Designer:
Flow 1 — Case Initiation Flow
Trigger: Record created on x_gcp_relocation_case
Actions:
- Set Case Status to "Active"
- Set Current Phase to "Initiation"
- Auto-generate onboarding checklist tasks on x_gcp_onboarding_task for all 6 categories: IT Setup, Benefits Enrollment, Compliance & Policy Acknowledgement, Payroll & Banking Setup, Buddy Assignment, Office Access & ID Provisioning. Assign each task to the HR Business Partner by default with a due date of 14 days after the Planned Relocation Date.
- Send email notification to the Employee, Manager, and Assigned HR Business Partner confirming case creation, with case number and expected relocation date.
Flow 2 — Phase Progression Flow
Trigger: All checklist tasks under a given phase category marked "Completed"
Actions:
- Automatically advance the Current Phase on the parent case to the next phase in sequence.
- Send email notification to the HR Business Partner and Employee informing of phase advancement.
Flow 3 — Salary Adjustment Calculation Flow
Trigger: Record created or Source/Destination Country updated on x_gcp_salary_adjustment
Actions:
- Look up Source PPP Index from x_gcp_ppp_index by source country.
- Look up Destination PPP Index from x_gcp_ppp_index by destination country.
- Calculate PPP Adjustment Factor = Destination PPP / Source PPP.
- Calculate Adjusted Gross Salary = Current Gross Salary × PPP Adjustment Factor.
- Populate all calculated fields automatically.
Flow 4 — Expense Approval Flow
Trigger: Expense record on x_gcp_expense set to "Submitted"
Actions:
- Assign approval task to the HR Business Partner.
- On approval, set Approval Status to "Approved" and notify the Employee.
- On rejection, set Approval Status to "Rejected", notify Employee with rejection reason.
Flow 5 — Salary Finance Approval Flow
Trigger: HR Recommended Salary populated on x_gcp_salary_adjustment
Actions:
- Set Finance Approval Status to "Pending"
- Send approval task to all users with role x_gcp_finance_reviewer.
- On approval, notify HR Admin and HR Business Partner.
- On rejection, return to HR Business Partner for revision with rejection comments.
Flow 6 — Case Completion Flow
Trigger: All onboarding tasks across all categories marked "Completed"
Actions:
- Set Case Status to "Completed" and Current Phase to "Completed".
- Set Overall Progress % to 100.
- Send a case completion notification to Employee, Manager, HR Business Partner, and HR Admin.
---
EMPLOYEE CENTER / PORTAL EXPERIENCE
Create a dedicated Employee Center portal page titled "My Relocation" for employees with the x_gcp_employee role. This page must display:
- A summary card showing their active relocation case: case number, source and destination country, planned relocation date, current phase, and overall progress percentage as a visual progress bar.
- A timeline or phase tracker showing all phases (Initiation → Travel & Visa → Relocation Logistics → Destination Onboarding → Salary Adjustment → Completed) with the current phase highlighted.
- Read-only sections for: Visa & Work Permits, Travel Details, Housing & Accommodation, Dependents, Onboarding Checklist (with completion status per task), and Salary Adjustment outcome (visible only after Finance Approval).
- A section to view submitted and approved expense claims.
- The page must be fully read-only for the employee. No edit access.
---
HR ADMIN DASHBOARD
Create a dedicated HR Admin workspace / dashboard with the following components:
- A summary metrics row showing: Total Active Cases, Cases by Phase (as a breakdown), Overdue Onboarding Tasks, and Pending Salary Approvals.
- A list view of all active relocation cases with columns: Employee Name, Source Country, Destination Country, Planned Relocation Date, Current Phase, Case Status, and Assigned HR Business Partner.
- Filterable by: Status, Current Phase, Destination Country, and Assigned HR Business Partner.
- Quick-action buttons on each row: View Case, Open Salary Adjustment, View Checklist.
---
PPP INDEX MANAGEMENT
The x_gcp_ppp_index table must be manageable exclusively by the x_gcp_admin role. Provide a clean list view and form view for HR Admins to maintain the PPP index values per country. Pre-populate the table with at least 15 sample country records with realistic PPP index values (using USD as the baseline at 1.00).
---
SECURITY & GOVERNANCE
- All tables must have row-level ACLs enforced by role as described above.
- The Employee record must only see their own case (ACL condition: current user = employee field on x_gcp_relocation_case).
- Audit logging must be enabled on x_gcp_relocation_case, x_gcp_salary_adjustment, and x_gcp_expense tables.
- The application scope must prevent any cross-scope writes to HRSD base tables; use only read references to sys_user and HRSD case tables where needed.
---
UI & UX STANDARDS
- All forms must use section dividers to group related fields logically.
- Case forms must display the Current Phase as a visual step indicator at the top of the record.
- All date fields must have date validation (no past dates for planned relocation).
- The Salary Adjustment form must display the PPP calculation breakdown clearly: Source PPP, Destination PPP, Adjustment Factor, and Adjusted Salary in a read-only summary panel before the HR Recommended Salary input field.
- All list views must support column sorting and filtering.
- Use consistent, professional colour theming aligned with ServiceNow's standard HR application palette.
#ServiceNow #LowCode #Automation #ServiceNowDeveloper #BuildMoreWithBuildAgent #AgenticAI #BuildAgent #Now #NowAIPlatform
