Determines whether the provider automatically adds filters associated with effective dating, to tables that support effective dates.

Data Type

bool

Default Value

false

Remarks

Effective dating is a mechanism that enables entities to have an effective start date and an effective end date. A record thus becomes effective between its start date and its end date. In CData Excel Add-In for SAP SuccessFactors, effective dating means that information records are stored with associated dates (start and end date), enabling the system to manage historical, current, and future data accurately.

Note: The fromDate, toDate, and asOfDate query parameters are not exposed in the navigation properties by default. However, they can be made available in either of two ways:

• Set UseEffectiveDate to True, or
• Set IncludeNavigationParentColumns to True.

When UseEffectiveDate is set to True, the CData Excel Add-In for SAP SuccessFactors automatically appends the [FromDate='1900-01-01'] and [ToDate='9999-12-31'] filters to the tables that support effective dating. This behavior can be overridden by explicitly defining fromDate, toDate, or asOfDate in the SQL query's WHERE clause.