A contact lookup. Each provider supplies the ULN and whatever contact details are held. Everything else about the learner comes from the WYCA extract, matched on the ULN.
Provider file
| # | Agreed column name | Type | Required |
|---|---|---|---|
| 1 | ULN | Text (10 digits) | Req |
| 2 | Text | Opt | |
| 3 | Mobile | Text | 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 |
| Provider Name | Text | Provider folder |
Grain
- One row per learner.
- The ULN plus whatever contact details are held.
- A learner with neither email nor mobile is still valid.
Location
- WYCA SharePoint.
Access
The following have access to the folder:
- IBP
- Providers
- WYCA
- Disseminate
- Service account
Folder
- Hierarchy: Year → Month → Provider.
- Each provider submits one file into their own provider folder.
- The provider folder must be named exactly as that provider appears in the Provider Name column of the WYCA 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 learners since the previous file, not a full re-send.