create_peci_transform
Generates an XSLT 2.0 transform that flattens Workday PECI or PICOF output into a delimited or fixed-width vendor file for payroll, benefits, and retirement feeds.
Instructions
Generate an XSLT 2.0 transform that flattens Workday PECI (or PICOF) output into a delimited or fixed-width vendor file, written to ws/WSAR-INF/ of a Studio project.
Use it for payroll, benefits, retirement or other vendor feeds built on the PECI/PICOF connectors. Call analyze_peci_output on a sample file first to discover the exact element paths and change flags in the tenant's output, then pass those paths as columns.
Handles: namespace declarations, RFC 4180 CSV quoting, any delimiter, header row, CRLF/LF, fixed-width padding and truncation, date re-formatting, first-non-blank fallback chains, constants, event-code filters (HIR, TERM, DTA...), and change-only rows (peci:isAdded / isUpdated / isDeleted flags).
See get_patterns topic "PECI and PICOF Output Transforms" for the design rules.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"project_name": "<project_name>",
"file_name": "<file_name>",
"columns": "<columns>"
},
"name": "create_peci_transform"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| source | No | Connector output being transformed. Default "peci". Sets the default namespace. | |
| columns | Yes | Output columns in order. | |
| delimiter | No | Field delimiter for csv output. Default ",". Use "|" for pipe or "\t" for tab. | |
| file_name | Yes | XSLT file name, e.g. "PECI_To_Vendor_CSV.xsl". Placed in ws/WSAR-INF/. | |
| overwrite | No | Replace the file if it already exists. Default false. | |
| quote_all | No | Quote every csv field. Default false: quote only when needed. | |
| row_scope | No | One output row per peci:Effective_Change (default — change/event feeds) or one row per peci:Worker (current-state feeds). | |
| description | No | What this transform produces, for the file header comment. | |
| event_codes | No | Only emit rows whose peci:Derived_Event_Code is in this list (effective_change scope). | |
| line_ending | No | Default "CRLF", which most payroll and benefits vendors expect. | |
| changed_only | No | Only emit rows where something inside the row context carries an isAdded / isUpdated / isDeleted flag. | |
| project_name | Yes | The Studio project name | |
| namespace_uri | No | Override the source namespace URI (default urn:com.workday/peci, or urn:com.workday/picof). | |
| output_format | No | Default "csv" (any delimiter). | |
| include_header | No | Write a header row. Default true for csv, false for fixed_width. | |
| extra_namespaces | No | Additional prefix → URI declarations used in column XPaths (e.g. custom field namespaces). | |
| exclude_event_codes | No | Skip rows whose peci:Derived_Event_Code is in this list (effective_change scope). |