Skip to main content

Validity dates

The ValidFrom and ValidTo properties are different field types in SAP and Omada Identity. In SAP they are data only field, when in the Omada Identity they are date or time field. This means it is required to add timestamp in the Queries and mappings for the SAP collector.

important

The Valid To contains an expression using the TERMDATE property value. If the TERMDATE property is not configured, a value from the ValiTo property is taken instead.

There are following alias mappings for the SAP components in the SAP Collector in Omada Identity:

  • INF00START_DATE - it is mapped to ValidFrom
  • INF00END_DATE - it is mapped to ValidTo
  • TERMDATE - it is mapped to TERMDATE

For more information, go to SAP mappings to Data Warehouse.

Valid From​

The value for the ValidFrom date is obtained from the Start Date field of the first Hire action in the SAP HCM (Info type 0000).

The obtained value can be found in the INF00START_DATE property in the employee web service or stored in the /OMADA/HRCACHE.

Rehire scenario​

In a scenario when an employee is rehired, the INF00SART_DATE property value can be update to utilize the start date from the upcoming re-hire action. For more information, go to the Start dates.

By default the employee record is available in the import on the date of the rehire action. Prior, the termination record is the current active action for the SAP HCM. You can determine how many days or months, prior to the rehire date, the record should be available in the import to the Omada Identity. For more information, go to Rules for dates used for conditions or exceptions.

rules-for-dates-used-for-conditions-or-exceptions

Valid To​

The value for the ValidTo date is obtained from the End Date field value for the current active action in the SAP HCM (Info type 0000).

Termination scenario​

When the termination is the next scheduled future action, there is a TERMDATE value calculated by subtracting one day from the start day of the termination action. You can find this value in the employee web service or in the /OMADA/HRCACHE table.

example

In this example the termination action starts at 01.06.2023. The INF00END_DATE is set to 31.10.2023, as this is the end date for the current active action. Based on the formula the TERMDATE is set to 31.05.2023.

sap-hcm-termination-date

employee-web-service-enddate

sap-hcm-termdate