validate_effective_dating
Detect gaps and overlaps in effective-dated records for time-sliced entities to prevent silent data bugs that cause missing active records on specific dates.
Instructions
Validate effective dating for time-sliced entities.
Detects gaps and overlaps in effective-dated records. These are the most silent and destructive data bugs — an employee may appear to have no active record on a specific date due to a gap.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| entity | Yes | Effective-dated entity to check: 'EmpJob', 'EmpCompensation', 'PerPersonal' | |
| user_ids | No | ||
| data_center | No | ||
| auth_user_id | No | ||
| auth_password | No | ||
| max_employees | No | Max employees to check (1-200) |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||