ESRParser
ESR Parser – Generic Outbound Data Warehouse Interface
Summary (SEO Meta Description):
The ESR Parser in WeHub parses NHS ESR Data Warehouse Interface files into structured workflow objects.
Configure separators, truncate settings, and select data warehouse segments for parsing.
Overview
The Generic Outbound Data Warehouse Interface action parses ESR (Electronic Staff Record) Data Warehouse Interface files.
It transforms raw ESR export files into structured objects that can be consumed by workflows for analysis, reporting, or integration with downstream systems.
Users can configure separators, enable truncation, and select which data warehouse segments should be included in the parsing process.
⚙️ Configuration Options
| Field | Type | Description |
|---|---|---|
| Label | String | Custom name for the node (e.g., "Parse ESR Payroll Export"). |
| Separator | String | Character used to separate fields in the ESR file (e.g., ` |
| Truncate Fields | Boolean | Toggle to shorten large fields when enabled. |
| Truncate Level | Integer | Depth/length limit applied when truncation is enabled. |
| Data Warehouse Segments | Enum (Multi-select) | Choose which ESR data warehouse segments to parse. Options: PR, AS, OR, PO, LC, PI, AB, CD, CM, CO, DT, EL, ET, QL, ST, TR. |
| Schema | Schema | Optional schema to validate parsed ESR data. |
💡 Example Use Cases
- Healthcare (NHS) → Parse ESR staff rostering data into structured JSON for analytics.
- HR & Payroll → Extract payroll (
PR), assignments (AS), and positions (PO) from ESR exports. - Ops → Integrate parsed ESR files into reporting pipelines or dashboards.
FAQ
Q: What are ESR segments?
A: Segments represent different parts of the ESR Data Warehouse export, such as PR (Payroll), AS (Assignments), PO (Positions), etc.
Q: Do I need to select all segments?
A: No, you can select only the segments relevant to your workflow to improve efficiency.
Q: What happens if an ESR file contains unexpected fields?
A: They are ignored unless captured by schema validation.
Keywords: WeHub ESR Parser, ESR Data Warehouse, NHS ESR, parse ESR, staff record export, payroll, assignments