WYCA extract
| # | Agreed column name | Type | Required | WYCA extract |
|---|---|---|---|---|
| 1 | Provider Name | Text | Req | Provider name |
| 2 | Provider UKPRN | Text | Req | — |
| 3 | Learner Reference Number | Text | Req | Learner reference number |
| 4 | ULN | Text (10 digits) | Req | Unique learner number |
| 5 | Given Names | Text | Req | Given Names |
| 6 | Family Name | Text | Req | Family Name |
| 7 | Date of Birth | Date | Req | Date of birth |
| 8 | Postcode | Text | Req | Postcode prior to enrolment |
| 9 | Learning Aim Reference | Text (8 char) | Req | Learning aim reference |
| 10 | Learning Aim Title | Text | Req | Learning aim title |
| 11 | Aim Start Date | Date | Req | — |
| 12 | Aim Planned End Date | Date | Req | — |
| 13 | Leaver Date | Date | Opt | — |
Derived columns
Added on load. Not supplied in the file.
| Column | Type | Derived from |
|---|---|---|
| Return Month | Int (YYYYMMDD) | Year / Month folder, e.g. 20260301 |
| SSA Tier 2 | Text | Look up using Learning Aim Reference against LARS |
| Notional NVQ Level | Text | Look up using Learning Aim Reference against LARS |
| Category | Text | To be agreed with WYCA and IBP |
Grain
- One row per learner per aim.
- A learner on several aims appears on several rows.
- Their personal details repeat on each row.
Location
- WYCA SharePoint.
Access
The following have access to the folder:
- IBP
- Providers
- WYCA
- Disseminate
- Service account
Folder
- Hierarchy: Year → Month → Provider.
- The WYCA file contains all providers' learner data in one file, and goes in the WYCA folder.
- Each provider's folder must be named exactly as that provider appears in the Provider Name column of this extract.
2026/ ├─ 09/ │ ├─ WYCA/ │ ├─ Bradford College/ │ └─ Leeds College of Building/ └─ 10/ ├─ WYCA/ ├─ Bradford College/ └─ Leeds College of Building/
Workbook
- The workbook name is not defined. One workbook per provider folder is loaded, whatever it is called.
- If more than one workbook is present, the most recently modified is used.
Worksheet
- The worksheet name is not defined. The first worksheet is loaded.
- Row 1 is the header, using the agreed column names; data from row 2.
Incremental
- Only changes are sent each month.
- New or updated records since the previous file, not a full re-send.