Contains response data documents generated from effective change queries, providing structured outputs for reporting, auditing, and compliance purposes.

Table Specific Information

Select

The Workday connector requires filtering on Effectivechanges_Id in order to perform the query.

For example:

SELECT * FROM EffectiveChangesResponseDataDocuments WHERE Effectivechanges_Id = '12345';

Workday Resource Information

Generates effective change data for organizations or workers based on request parameters.

Secured by: Manage: Data Changes On Demand+TG

Scope: Global Payroll Connect

Aggregate Fields

The connector represents the following fields as aggregates containing JSON text. Each of them conforms to their respective schema. Fields marked with an asterisk are required and must be included if their parent object is. Fields marked with a hyphen are read-only and must not be included when calling stored procedures or when performing an INSERT or UPDATE.

This information is derived from the Workday REST API specification which does not explicitly list all business rules and validations that apply to each object. More fields may be required than what is listed here.

DocumentTags_Aggregate

[{
  descriptor: Text /* A preview of the instance */
  id: Text /* Id of the instance */
}]

Columns

Name	Type	ReadOnly	Description
EffectiveChanges_Id	String	False	The unique Workday identifier (WID) of the EffectiveChanges record that contains this document. Use this Id to reference the specific record.
DocumentId	String	False	The unique identifier of the document. Use this Id with the Blobitory API to retrieve the document content.
DocumentTags_Aggregate	String	False	A list of tags associated with the document, providing metadata for categorization and search. Each tag is separated by a comma with 1 space after each comma.
FileName	String	False	The name of the document file, including its extension. This name is typically user-assigned or system-generated.
Organization_Descriptor	String	False	A textual preview or short description of the organization instance associated with the document.
Organization_Id	String	False	The unique identifier of the organization instance linked to this document. This Id is used for referencing the specific organization.