Skip to content
Item Detail
Property lastDateWorked Now Filterable in OData APIs EmpEmployment and EmpEmploymentTermination
General Availability Info Only Automatically On Impact: Low AI Enriched
Description

You can now use the lastDateWorked property as a filter when you query the OData APIs EmpEmployment and EmpEmploymentTermination.See More

Detailed Description

EmpEmploymentTermination You can now use the lastDateWorked property as a filter when you query the OData APIs EmpEmployment and EmpEmploymentTermination. For example, to retrieve employment records with a last working day between August 1, 2025 and September 1, 2025, you can use the following request: Sample Code https://<api-server>/odata/v2/EmpEmployment?$format=json&$select=lastDateWorked&$filter=lastDateWorked ge datetime'2025-08-01T00:00' and lastDateWorked le datetime'2025-09-01T00:00'This will return records where the last working day falls within the specified date range. This enhancement enables you to retrieve specific employment records based on the last working day.

Impact Assessment

This feature has limited impact but should be reviewed to confirm alignment with business processes in Employee Data implementations. EmpEmploymentTermination You can now use the lastDateWorked property as a filter when you query the OData APIs EmpEmployment and EmpEmploymentTermination. For example, to retrieve employment records with a last working day between August 1, 2025 and September 1, 2025, you can use the following request: Sample Code https://<api-server>/odata/v2/EmpEmployment?$format=json&$select=lastDateWorked&$filter=lastDateWorked ge datetime'2025-08-01T00:00' and lastDateWorked le datetime'2025-09-01T00:00'This will return records where the last working day falls within the specified date range. Implementation teams should verify that existing configurations remain valid and test core business scenarios after the upgrade to confirm correct behavior.

Test Recommendations
• Verify the feature is enabled and accessible from the expected navigation path or configuration area in a test environment. • Test the end-to-end scenario with representative test data covering both happy paths and error conditions. • Validate correct behavior across all relevant user roles and permission configurations (admin, manager, employee). • Test edge cases: empty or missing values, boundary conditions, concurrent users, and large data sets. • Confirm that existing integrations, workflows, and downstream processes are not affected by the change. • Test integration endpoints and API calls for correct data exchange, authentication, and error handling.
Product: Employee Central
Modules: Employee Data Integration and Extension
Feature: API
Reference: ECT-252818
Version: 2H 2025
Valid as Of: Nov 14, 2025
Latest Revision: Oct 03, 2025
Affected Areas:
Employee Central Employee Data Integration & APIs