...
# | Comment | Owner |
|---|---|---|
| 1 | How should the NULL MainSiteID post rows be associated with a LocalOfifce, using ManagingDeanery, Site, Trust or NationlaPostNumber prefix | Joanne Watson (Unlicensed) |
| 2 |
TIS is using the [vwPost].ManagingDeanery field to determine the LocalOffice value in TIS, and will NOT be using the Hicom [vwLocalOffice] data derived via the
...
The current sites with a NULL MainSiteID;
| LocalOfficeName_MS | Status | managingdeaneryletb | mapped_lo | FundingBodyTrustID | LocalOfficeName_Trust | ntn_lo | rc |
|---|---|---|---|---|---|---|---|
| NULL | Current | NULL | UNKNOWN | NULL | NULL | NULL | 5 |
| NULL | Current | NULL | UNKNOWN | NULL | NULL | NA | 1 |
| NULL | Current | NULL | UNKNOWN | 129200612 | HELASE | KSS | 2 |
| NULL | Current | Health Education England West Midlands | HEWM | 8140607 | HENW | WMD | 1 |
| NULL | Current | Health Education England West Midlands | HEWM | 8140607 | HEEM | WMD | 1 |
| NULL | Current | Health Education England West Midlands | HEWM | 8140607 | HEEOE | WMD | 1 |
| NULL | Current | Health Education England West Midlands | HEWM | 8140607 | HELASE | WMD | 1 |
| NULL | Current | Health Education England West Midlands | HEWM | 8140607 | HEWM | WMD | 1 |
| NULL | Current | Severn Local Office - HESW | HESW | NULL | NULL | NULL | 1 |
| NULL | Current | Health Education England North West | HENW | 6500118 | HELASE | NWN | 2 |
| NULL | Current | Health Education England North West | HENW | 6500118 | HENW | NWN | 2 |
| NULL | Current | Health Education England North West | HENW | 8139427 | HENW | NWN | 3 |
| NULL | Current | Health Education England North West | HENW | 8139859 | HENW | NWN | 3 |
| NULL | Current | Health Education England North West | HENW | 8140080 | HENW | NWN | 8 |
| NULL | Current | Health Education England North West | HENW | 8140588 | HENW | NWN | 3 |
| NULL | Current | Health Education England North East | HENE | NULL | NULL | NTH | 1 |
Posts with a NULL vwPost.MainSiteID value
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
select * from [HEELIVE].[vwTrust] where TrustID in (8140607,6500118) |
| RecordOrigin | STATUS | TrustName | TrustKnownAs | TrustNumber | DeaneryLETB | TrustID |
|---|---|---|---|---|---|---|
| HEELIVE | Current | Central Manchester University Hospitals NHS Foundation Trust | Central Manchester University Hospitals NHS Foundation Trust | RW3 | North Western | 6500118 |
| HEELIVE | Current | St Helens and Knowsley Hospital Services NHS Trust | St Helens and Knowsley Hospital Services NHS Trust | RBN | Mersey | 8140607 |