find_data_anomalies
Detect empty fields, duplicates, future dates, and orphan references across SuccessFactors entities to maintain data quality.
Instructions
Detect data anomalies in SF entities.
Types:
'empty': Find records where the specified field is blank/null
'duplicates': Find duplicate values in the specified field
'future_dates': Find date fields with values in the future
'orphan': Find records referencing non-existent FO/user records
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"entity": "<entity>",
"field": "<field>",
"anomaly_type": "<anomaly_type>"
},
"name": "find_data_anomalies"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| field | Yes | Field to analyze | |
| entity | Yes | Entity to check (e.g., 'EmpJob', 'User', 'FODepartment') | |
| data_center | No | ||
| max_results | No | Max anomalous records to return | |
| anomaly_type | Yes | Type of anomaly: 'empty' (blank required fields), 'duplicates' (duplicate values), 'orphan' (references to non-existent records), 'future_dates' (dates in the future) | |
| auth_user_id | No | ||
| scope_filter | No | ||
| auth_password | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||