A comma-separated list of prompt pairs, used to map SOAP operation inputs to the LastModified_Pseudo column.

Data Type

string

Default Value

"Item_Updated_From_Prompt=Item_Updated_To_Prompt,Last_Updated_On_or_After_Prompt=Last_Updated_On_or_Before_Prompt,Payment_Updated_From_Date_Prompt=Payment_Updated_To_Date_Prompt,Receipt_Last_Updated_Date_On_or_After_Prompt=Receipt_Last_Updated_Date_On_or_Before_Prompt,Update_From_Date_Prompt=Update_To_Date_Prompt,Updated_From_Date_Prompt=Updated_To_Date_Prompt,Updated_From_Moment_Prompt=Update_To_Moment_Prompt"

Remarks

In the SOAP service, operations that support filtering by last modified ranges usually expose a pair of inputs. When you set these inputs, Workday only returns records which were modified within the provided date range:

SELECT * FROM Financial_Management.Journals
WHERE Updated_From_Date_Prompt = '2020-01-01' AND Updated_To_Date_Prompt = '2021-01-01'

The server supports combining these inputs into a single column called LastModified_Pseudo. This column supports most SQL comparison operators (>, <, IS BETWEEN). Depending on your workflow, this may be more convenient than providing two separate inputs.

SELECT * FROM Financial_Management.Journals
WHERE LastModified_Pseudo IS BETWEEN '2020-01-01' AND '2021-01-01'

The Workday SOAP API does not expose metadata that would let the server determine which inputs are last modified ranges. Instead, the server looks for inputs that match this option and pairs them together to create a LastModified_Pseudo column. For example, when this option is set to Updated_From_Date_Prompt=Updated_To_Date_Prompt,Updated_From_Moment_Prompt=Updated_To_Moment_Prompt, the server creates LastModified_Pseudo columns for all tables that have Updated_From_Date_Prompt and Updated_To_Date_Prompt inputs, as well as all tables that have Updated_From_Moment_Prompt and Updated_To_Moment_Prompt inputs. Tables must have both sides of one pair to expose a LastModified_Pseudo column. Tables that match more than one pair, or don't match any, do not expose the column.

You may disable this feature by setting this property to NONE. This prevents the server from exposing the synthetic last modified column.

When using the LastModified_Pseudo column, you may provide a filter that only restricts the earliest date or the latest date. The Workday API requires the server to send both the start and end date inputs. In these situations the server uses a default value for whatever side of the range was not provided. It uses the current timestamp for the high end of the range. For the low end of the range, it uses the value of SOAPLastModifiedDefaultStart which defaults to 1900-01-01 midnight.

SELECT * FROM Financial_Management.Journals WHERE LastModified_Pseudo >= '2000-01-01';
SELECT * FROM Financial_Management.Journals WHERE LastModified_Pseudo <= '2020-01-01';

/* These are the saem as */
SELECT * FROM Financial_Management.Journals WHERE LastModified_Pseudo IS BETWEEN '2000-01-01' AND CURRENT_DATE;
SELECT * FROM Financial_Management.Journals WHERE LastModified_Pseudo IS BETWEEN '1900-01-01' AND '2020-01-01';

Note that while you can read the LastModified_Pseudo column, the value does not reflect the record's actual modification date in Workday. Most SOAP operations do not have fields reporting this information so the server has no way to obtain it. When a query reads the value of LastModified_Pseudo, the server returns the maximum value allowed by the given filters. For example, all rows returned from this query have a last modified date of 2025-01-01:

SELECT LastModified_Pseudo FROM Financial_Management.Journals WHERE LastModified_Pseudo <= '2025-01-01';

Tables that expose the LastModified_Pseudo column still expose the underlying inputs as their own columns. If a query includes filters for both the last modified column as well as the prompts it is tied to, the prompt inputs take precedence. For example, this query returns journal records modified in 2020 even though the LastModified_Pseudo column has a value of 1900-01-31 23:59:59.

SELECT * FROM Financial_Management.Journals
WHERE Updated_From_Date_Prompt = '2020-01-01' AND Updated_To_Date_Prompt = '2021-01-01'
AND LastModified_Pseudo IS BETWEEN '1900-01-01' AND '1900-02-01'