Domain: hr

System prompt:
# HR MANAGEMENT ASSISTANT POLICY

**Role:** HR Management Assistant

**System Scope:** Internal Employee Services, HR Case Management, Personnel Data, and Policy Fulfillment.

**Compliance Level:** Strict, especially regarding PII/PHI.

You are an HR Management Assistant. Your primary goal is to facilitate the efficient, secure, and compliant delivery of Human Resources services to all employees. Your functions include: registering HR cases, managing employee profile data, processing approvals, assigning fulfillment tasks, maintaining document integrity, and ensuring strict adherence to internal policies and privacy regulations (PII/PHI).

You must always act based on **confirmed user context**, **existing record relationships**, and **database integrity best practices**. You are strictly prohibited from assuming data values, executing ambiguous commands, providing information outside the verified system state, or performing actions that violate employee privacy or security.

## 1. GENERAL OPERATIONAL INSTRUCTIONS AND CONSTRAINTS

* **Policy Violation:** If a user request or internal process step violates any protocol listed in this document, you must halt the operation and provide a citation of the specific policy restriction before pausing.

* **Atomic Operations:** Perform one distinct operation at a time. Do not chain sequential actions if the failure of an initial step compromises the integrity or security of subsequent steps.

* **Knowledge Scope:** Do not provide knowledge, procedures, or employee-specific data that cannot be retrieved directly from the authenticated HR system tables. Do not generate or fabricate record IDs or data fields.

* **User Clarification:** Do not ask for any information or confirmation from the user. If you cannot proceed (e.g., ambiguous query, missing mandatory field), provide the precise reason for the inability to proceed and pause.

* **No Assumptions:** When identifiers such as names or IDs are missing, perform lookups, verify that you are reusing correct values from previous responses, and proceed using the retrieved data. Never assume or fabricate IDs.

## 2. ROLES AND ACCESS SCOPE

Access is strictly compartmentalized by the system role defined in the `role` table.

**Administrator (`admin`)**

* **Authority:** Global system configuration and maintenance.

* **Capabilities:** Full read/write access to all tables (`hr_service`, `workflow`, `assignment_rule`, `user`, `role`, etc.).

* **Restrictions:** Must not perform routine HR case work. Direct modification of Employee PII/PHI is only permissible for data correction or bulk migration under audited procedures.

**HR Specialist (`agent`)**

* **Authority:** Frontline processing of employee requests and fulfillment tasks.

* **Capabilities:**

* Create, update, and manage HR Cases (`hr_case`), Work Notes, and Fulfillment Tasks (`hr_case_task`).

* View and update non-sensitive fields of an employee's HR Profile (`hr_profile`).

* Associate Knowledge Articles (`hr_knowledge`) with a case.

* Manage Case assignment, status, and resolution fields.

* **Restrictions:** Cannot modify core user data, approval records, or system configuration. Sensitive PII fields are read-only and masked.

**HR Manager (`manager`)**

* **Authority:** Supervision, escalation, and approval of HR processes.

* **Capabilities:** Includes all `agent` privileges plus:

* Reassign HR Cases and Tasks across groups.

* Escalate cases and override standard priority settings.

* Approve or reject pending `hr_approval` records.

* Monitor SLA adherence.

* **Restrictions:** Cannot modify system configuration or roles.

**Employee (`employee`)**

* **Authority:** Access to personal HR records and the Service Catalog.

* **Capabilities:**

* Create HR Cases via the Service Catalog.

* Track the status of their own cases.

* View their own HR Profile (except restricted fields).

* View `external` Knowledge Articles.

* Manage their own `hr_approval` requests.

* **Restrictions:** Limited strictly to their own data (`hr_profile_id` matching the authenticated user).

## 3. CORE OPERATIONS: HR CASE AND TASK MANAGEMENT

### 3.1 Registering an HR Case

* **Initiation:** Identify `opened_for` (the subject employee) and `opened_by` (the requester).

* **Mandatory Inputs:**

* `hr_service_id`: Must reference an active service.

* `short_description`: Free-form text (30-120 chars).

* `priority`: If not provided, default is **moderate**.

* **Default Status:** All new cases default to **`status = draft`** or **`ready`**.

* **Automated Action:** The system runs the entitlement check and assignment rule upon creation.

### 3.2 Case Assignment and Task Fulfillment

* **Assignment:** Cases/Tasks must be assigned to an active user in the specified `assignment_group`.

* **Task Generation:** When an HR case moves to `status = work_in_progress`, fulfillment tasks (`hr_case_task`) are generated based on the service template.

* **Task Types:** `checklist`, `survey`, `hr service`, `mark when complete`, `url`.

* **Closure Constraint:** A case cannot move to a closed status (`closed_complete` or `closed_incomplete`) until all mandatory tasks are inactive or closed.

### 3.3 Case Lifecycle Management

Valid `status` transitions must be strictly followed:

* `draft` / `ready` → `work_in_progress`, `awaiting_approval`, `suspended`, or `cancelled`.

* `work_in_progress` → `awaiting_acceptance`, `awaiting_approval`, `suspended`, `closed_complete`, `closed_incomplete`.

* `awaiting_approval` → `work_in_progress` (if rejected) / `closed_complete` (if approved).

* `closed_complete` / `closed_incomplete` → `awaiting_acceptance`.

* `awaiting_acceptance` → `closed` (final internal state).

* `cancelled` is a final state.

### 3.4 Approvals Management

* **Trigger:** When a case requires authorization, it transitions to `status = awaiting_approval`, triggering an `hr_approval` record.

* **Status:** The approval record `request_status` transitions: `requested` → `approved` / `rejected`.

* **Actor:** Only `manager` or `admin` roles may approve/reject.

## 4. SERVICE LEVELS AND KNOWLEDGE MANAGEMENT

* **SLA Breach:** If `resolution_time` is exceeded, set the case escalation flag to true.

* **Knowledge Linking:**

* Only articles with `state = published` are linkable.

* **Visibility:** `internal` (Agents/Managers only) vs. `external` (All employees).

* **Linking Type:** `suggested`, `applied`, `resolution`.

## 5. EMPLOYEE PROFILE AND PII/PHI HANDLING

### 5.1 Employee Profile Management

* **Table:** `hr_profile`.

* **Integrity:** `department_id` and `manager_id` must reference active records.

* **Employment Type:** Valid values for `hr_profile.type` are `full-time`, `part-time`, `contractor`.

### 5.2 Strict PII Security

* **Encryption:** Fields like `national_tax_id` and `bank_account` must be encrypted.

* **Audit:** Read/write operations on PII must be logged in `security_audit`.

* **No Public Disclosure:** Do not output PII in chat/email responses.

## 6. VALIDATION AND LOGGING

* **Validation:** Ensure `user`, `hr_profile`, `hr_case`, and `hr_service` exist and are active before processing.

* **Logging:** Update `sys_updated_on` and `updated_by` automatically. Log failures in `operation_log`.

## 7. PREDEFINED LISTS (ENUMERATIONS)

Usage of values outside these lists results in an `INVALID_ENUM_VALUE` error.

* **user.role:** `admin`, `manager`, `agent`, `employee`

* **hr_service.fulfillment_type:** `manual`, `service_activity`, `workflow`, `lifecycle event`, `advanced`, `flow`

* **hr_profile.type:** `full-time`, `part-time`, `contractor`

* **hr_case.source:** `self-service`, `phone`, `email`, `chat`, `walk-in`, `virtual-agent`

* **hr_case.priority:** `critical`, `high`, `moderate`, `low`, `planning`

* **hr_case.status:** `draft`, `ready`, `awaiting_approval`, `work_in_progress`, `closed_complete`, `closed_incomplete`, `awaiting_acceptance`, `suspended`, `cancelled`

* **hr_case_task.type:** `checklist`, `survey`, `hr service`, `mark when complete`, `url`

* **hr_approval.request_status:** `requested`, `approved`, `rejected`

* **hr_knowledge.state:** `draft`, `published`, `retired`

* **hr_knowledge.visibility:** `internal`, `external`

* **case_knowledge.used_as:** `suggested`, `applied`, `resolution`

* **hr_document.type:** `onboarding_form`, `policy`, `contract`, `performance_review`

## 8. FREE FORM TEXT POLICIES

* **Character Limits:** 15–120 characters for `short_description` and `worknotes`.

* **Case Short Description Format:** "Service: ``, Subject: ``, Detail: ``."

* **Knowledge Article Title:** "Resolution Guide: `` fulfillment steps for ``."

* **Resolution Notes:** Summary < 120 chars; Body < 2000 chars.

Task:
Andrew Bell is officially transitioning into his new Administration role and will be working out of the main office starting today. I've been tracking this through his onboarding record, HRC0000721 and TAX-12-0021. Please update his work location to Office Based and set his new position in his HR profile. While you're at it, update his contact record with the new office line: +1-212-555-0199. I also need you to check the New Hire Onboarding Service details to ensure we're following the manual workflow. Find his pending tasks for that case and mark the cultural orientation video as completed. Finally, move the entire case to work in progress, set the priority to high, and assign it to Joanne Simpson.

Available tools:
fetch_hr_profiles
update_hr_profile
get_hr_service_by_name
list_hr_cases
update_hr_case_task
update_user_details
list_hr_case_tasks
update_hr_case

Verification checks:
[{"verifier_type": "database_state", "name": "hr_case_task_update_verification", "description": "Verifies that task HRT0001025 (hr_case_task_id=26) for the cultural orientation video was marked as closed_complete and remains active under parent case 11.", "gym_name": "sn-hr-internal", "validation_config": {"query": "SELECT COUNT(*) FROM hr_case_task WHERE hr_case_task_id = 26 AND number = 'HRT0001025' AND status = 'closed_complete' AND short_description = 'Watch Cultural Orientation Video' AND task_type = 'url' AND parent_case = 11 AND active = true;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "hr_case_update_verification", "description": "Verifies that case HRC0000721 (hr_case_id=11) was updated to work_in_progress status, high priority, and assigned to Joanne Simpson.", "gym_name": "sn-hr-internal", "validation_config": {"query": "SELECT COUNT(*) FROM hr_case WHERE hr_case_id = 11 AND number = 'HRC0000721' AND status = 'work_in_progress' AND priority = 'high' AND assigned_to = 4 AND short_description = 'Request Onboarding case for Andrew Bell' AND hr_case_id = 11 AND opened_for = 21;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "hr_profile_update_verification", "description": "Verifies that Andrew Bell\u2019s HR profile was updated with position Administration and location_type Office Based.", "gym_name": "sn-hr-internal", "validation_config": {"query": "SELECT COUNT(*) FROM hr_profile WHERE hr_profile_id = 21 AND number = 'HRP00021' AND user_id = 21 AND national_tax_id = 'TAX-12-0021' AND position = 'Administration' AND location_type = 'Office Based' AND personal_email = 'andrew.bell.21@personal.example.com';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "user_contact_update_verification", "description": "Verifies that Andrew Bell\u2019s user record was updated with the new office phone number.", "gym_name": "sn-hr-internal", "validation_config": {"query": "SELECT COUNT(*) FROM user WHERE user_id = 21 AND first_name = 'Andrew' AND last_name = 'Bell' AND phone = '+12125550199' AND email = 'andrew.bell58@averyltd.com' AND role = 'employee' AND active = true;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "comprehensive_cross_table_state_verification", "description": "Comprehensive verifier that confirms updates across hr_case_task, hr_case, hr_profile, and user tables all succeeded.", "gym_name": "sn-hr-internal", "validation_config": {"query": "SELECT CASE WHEN ((SELECT COUNT() FROM hr_case_task WHERE hr_case_task_id = 26 AND status = 'closed_complete' AND parent_case = 11) = 1 AND (SELECT COUNT() FROM hr_case WHERE hr_case_id = 11 AND status = 'work_in_progress' AND priority = 'high' AND assigned_to = 4) = 1 AND (SELECT COUNT() FROM hr_profile WHERE hr_profile_id = 21 AND position = 'Administration' AND location_type = 'Office Based' AND national_tax_id = 'TAX-12-0021') = 1 AND (SELECT COUNT() FROM user WHERE user_id = 21 AND phone = '+12125550199') = 1) THEN 1 ELSE 0 END AS all_updates_verified;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "audit_trail_verification", "description": "Verifies that all updated records have updated_at timestamps later than their previous baseline, confirming persistence.", "gym_name": "sn-hr-internal", "validation_config": {"query": "SELECT CASE WHEN ((SELECT COUNT() FROM hr_case_task WHERE hr_case_task_id = 26 AND updated_at > '2023-02-15T10:05:00') = 1 AND (SELECT COUNT() FROM hr_case WHERE hr_case_id = 11 AND updated_at > '2023-02-15T10:00:00') = 1 AND (SELECT COUNT() FROM hr_profile WHERE hr_profile_id = 21 AND updated_at > '2023-01-01T00:00:00') = 1 AND (SELECT COUNT() FROM user WHERE user_id = 21 AND updated_at > '2025-08-27T15:34:35') = 1) THEN 1 ELSE 0 END AS audit_trail_verified;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "referential_integrity_verification", "description": "Verifies that all foreign key relationships remain intact after updates across tasks, cases, profiles, and users.", "gym_name": "sn-hr-internal", "validation_config": {"query": "SELECT CASE WHEN ((SELECT COUNT() FROM hr_case_task hct INNER JOIN hr_case hc ON hct.parent_case = hc.hr_case_id WHERE hct.hr_case_task_id = 26 AND hc.hr_case_id = 11) = 1 AND (SELECT COUNT() FROM hr_case hc INNER JOIN user u ON hc.assigned_to = u.user_id WHERE hc.hr_case_id = 11 AND u.user_id = 4 AND u.first_name = 'Joanne' AND u.last_name = 'Simpson') = 1 AND (SELECT COUNT(*) FROM hr_profile hp INNER JOIN user u ON hp.user_id = u.user_id WHERE hp.hr_profile_id = 21 AND u.user_id = 21 AND u.first_name = 'Andrew' AND u.last_name = 'Bell') = 1) THEN 1 ELSE 0 END AS referential_integrity_verified;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "hr_case_task_update_verification", "description": "Verifies that task HRT0001025 (hr_case_task_id=26) for the cultural orientation video was marked as closed_complete and remains active under parent case 11.", "gym_name": "sn-hr-internal", "validation_config": {"query": "SELECT COUNT(*) FROM hr_case_task WHERE hr_case_task_id = 26 AND number = 'HRT0001025' AND status = 'closed_complete' AND short_description = 'Watch Cultural Orientation Video' AND task_type = 'url' AND parent_case = 11 AND active = true;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "hr_case_update_verification", "description": "Verifies that case HRC0000721 (hr_case_id=11) was updated to work_in_progress status, high priority, and assigned to Joanne Simpson.", "gym_name": "sn-hr-internal", "validation_config": {"query": "SELECT COUNT(*) FROM hr_case WHERE hr_case_id = 11 AND number = 'HRC0000721' AND status = 'work_in_progress' AND priority = 'high' AND assigned_to = 4 AND short_description = 'Request Onboarding case for Andrew Bell' AND hr_case_id = 11 AND opened_for = 21;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "hr_profile_update_verification", "description": "Verifies that Andrew Bell\u2019s HR profile was updated with position Administration and location_type Office Based.", "gym_name": "sn-hr-internal", "validation_config": {"query": "SELECT COUNT(*) FROM hr_profile WHERE hr_profile_id = 21 AND number = 'HRP00021' AND user_id = 21 AND national_tax_id = 'TAX-12-0021' AND position = 'Administration' AND location_type = 'Office Based' AND personal_email = 'andrew.bell.21@personal.example.com';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "user_contact_update_verification", "description": "Verifies that Andrew Bell\u2019s user record was updated with the new office phone number.", "gym_name": "sn-hr-internal", "validation_config": {"query": "SELECT COUNT(*) FROM user WHERE user_id = 21 AND first_name = 'Andrew' AND last_name = 'Bell' AND phone = '+12125550199' AND email = 'andrew.bell58@averyltd.com' AND role = 'employee' AND active = true;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "comprehensive_cross_table_state_verification", "description": "Comprehensive verifier that confirms updates across hr_case_task, hr_case, hr_profile, and user tables all succeeded.", "gym_name": "sn-hr-internal", "validation_config": {"query": "SELECT CASE WHEN ((SELECT COUNT() FROM hr_case_task WHERE hr_case_task_id = 26 AND status = 'closed_complete' AND parent_case = 11) = 1 AND (SELECT COUNT() FROM hr_case WHERE hr_case_id = 11 AND status = 'work_in_progress' AND priority = 'high' AND assigned_to = 4) = 1 AND (SELECT COUNT() FROM hr_profile WHERE hr_profile_id = 21 AND position = 'Administration' AND location_type = 'Office Based' AND national_tax_id = 'TAX-12-0021') = 1 AND (SELECT COUNT() FROM user WHERE user_id = 21 AND phone = '+12125550199') = 1) THEN 1 ELSE 0 END AS all_updates_verified;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "audit_trail_verification", "description": "Verifies that all updated records have updated_at timestamps later than their previous baseline, confirming persistence.", "gym_name": "sn-hr-internal", "validation_config": {"query": "SELECT CASE WHEN ((SELECT COUNT() FROM hr_case_task WHERE hr_case_task_id = 26 AND updated_at > '2023-02-15T10:05:00') = 1 AND (SELECT COUNT() FROM hr_case WHERE hr_case_id = 11 AND updated_at > '2023-02-15T10:00:00') = 1 AND (SELECT COUNT() FROM hr_profile WHERE hr_profile_id = 21 AND updated_at > '2023-01-01T00:00:00') = 1 AND (SELECT COUNT() FROM user WHERE user_id = 21 AND updated_at > '2025-08-27T15:34:35') = 1) THEN 1 ELSE 0 END AS audit_trail_verified;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "referential_integrity_verification", "description": "Verifies that all foreign key relationships remain intact after updates across tasks, cases, profiles, and users.", "gym_name": "sn-hr-internal", "validation_config": {"query": "SELECT CASE WHEN ((SELECT COUNT() FROM hr_case_task hct INNER JOIN hr_case hc ON hct.parent_case = hc.hr_case_id WHERE hct.hr_case_task_id = 26 AND hc.hr_case_id = 11) = 1 AND (SELECT COUNT() FROM hr_case hc INNER JOIN user u ON hc.assigned_to = u.user_id WHERE hc.hr_case_id = 11 AND u.user_id = 4 AND u.first_name = 'Joanne' AND u.last_name = 'Simpson') = 1 AND (SELECT COUNT(*) FROM hr_profile hp INNER JOIN user u ON hp.user_id = u.user_id WHERE hp.hr_profile_id = 21 AND u.user_id = 21 AND u.first_name = 'Andrew' AND u.last_name = 'Bell') = 1) THEN 1 ELSE 0 END AS referential_integrity_verified;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "hr_case_task_update_verification", "description": "Verifies that task HRT0001025 (hr_case_task_id=26) for the cultural orientation video was marked as closed_complete and remains active under parent case 11.", "gym_name": "sn-hr-internal", "validation_config": {"query": "SELECT COUNT(*) FROM hr_case_task WHERE hr_case_task_id = 26 AND number = 'HRT0001025' AND status = 'closed_complete' AND short_description = 'Watch Cultural Orientation Video' AND task_type = 'url' AND parent_case = 11 AND active = true;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "hr_case_update_verification", "description": "Verifies that case HRC0000721 (hr_case_id=11) was updated to work_in_progress status, high priority, and assigned to Joanne Simpson.", "gym_name": "sn-hr-internal", "validation_config": {"query": "SELECT COUNT(*) FROM hr_case WHERE hr_case_id = 11 AND number = 'HRC0000721' AND status = 'work_in_progress' AND priority = 'high' AND assigned_to = 4 AND short_description = 'Request Onboarding case for Andrew Bell' AND hr_case_id = 11 AND opened_for = 21;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "hr_profile_update_verification", "description": "Verifies that Andrew Bell\u2019s HR profile was updated with position Administration and location_type Office Based.", "gym_name": "sn-hr-internal", "validation_config": {"query": "SELECT COUNT(*) FROM hr_profile WHERE hr_profile_id = 21 AND number = 'HRP00021' AND user_id = 21 AND national_tax_id = 'TAX-12-0021' AND position = 'Administration' AND location_type = 'Office Based' AND personal_email = 'andrew.bell.21@personal.example.com';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "user_contact_update_verification", "description": "Verifies that Andrew Bell\u2019s user record was updated with the new office phone number.", "gym_name": "sn-hr-internal", "validation_config": {"query": "SELECT COUNT(*) FROM user WHERE user_id = 21 AND first_name = 'Andrew' AND last_name = 'Bell' AND phone = '+12125550199' AND email = 'andrew.bell58@averyltd.com' AND role = 'employee' AND active = true;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "comprehensive_cross_table_state_verification", "description": "Comprehensive verifier that confirms updates across hr_case_task, hr_case, hr_profile, and user tables all succeeded.", "gym_name": "sn-hr-internal", "validation_config": {"query": "SELECT CASE WHEN ((SELECT COUNT() FROM hr_case_task WHERE hr_case_task_id = 26 AND status = 'closed_complete' AND parent_case = 11) = 1 AND (SELECT COUNT() FROM hr_case WHERE hr_case_id = 11 AND status = 'work_in_progress' AND priority = 'high' AND assigned_to = 4) = 1 AND (SELECT COUNT() FROM hr_profile WHERE hr_profile_id = 21 AND position = 'Administration' AND location_type = 'Office Based' AND national_tax_id = 'TAX-12-0021') = 1 AND (SELECT COUNT() FROM user WHERE user_id = 21 AND phone = '+12125550199') = 1) THEN 1 ELSE 0 END AS all_updates_verified;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "audit_trail_verification", "description": "Verifies that all updated records have updated_at timestamps later than their previous baseline, confirming persistence.", "gym_name": "sn-hr-internal", "validation_config": {"query": "SELECT CASE WHEN ((SELECT COUNT() FROM hr_case_task WHERE hr_case_task_id = 26 AND updated_at > '2023-02-15T10:05:00') = 1 AND (SELECT COUNT() FROM hr_case WHERE hr_case_id = 11 AND updated_at > '2023-02-15T10:00:00') = 1 AND (SELECT COUNT() FROM hr_profile WHERE hr_profile_id = 21 AND updated_at > '2023-01-01T00:00:00') = 1 AND (SELECT COUNT() FROM user WHERE user_id = 21 AND updated_at > '2025-08-27T15:34:35') = 1) THEN 1 ELSE 0 END AS audit_trail_verified;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "referential_integrity_verification", "description": "Verifies that all foreign key relationships remain intact after updates across tasks, cases, profiles, and users.", "gym_name": "sn-hr-internal", "validation_config": {"query": "SELECT CASE WHEN ((SELECT COUNT() FROM hr_case_task hct INNER JOIN hr_case hc ON hct.parent_case = hc.hr_case_id WHERE hct.hr_case_task_id = 26 AND hc.hr_case_id = 11) = 1 AND (SELECT COUNT() FROM hr_case hc INNER JOIN user u ON hc.assigned_to = u.user_id WHERE hc.hr_case_id = 11 AND u.user_id = 4 AND u.first_name = 'Joanne' AND u.last_name = 'Simpson') = 1 AND (SELECT COUNT(*) FROM hr_profile hp INNER JOIN user u ON hp.user_id = u.user_id WHERE hp.hr_profile_id = 21 AND u.user_id = 21 AND u.first_name = 'Andrew' AND u.last_name = 'Bell') = 1) THEN 1 ELSE 0 END AS referential_integrity_verified;", "expected_value": 1, "comparison_type": "equals"}}]