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
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 | |||