We have detected that you are using Internet Explorer to visit this website. Internet Explorer is now being phased out by Microsoft. As a result, NHS Digital no longer supports any version of Internet Explorer for our web-based products, as it involves considerable extra effort and expense, which cannot be justified from public funds. Some features on this site will not work. You should use a modern browser such as Edge, Chrome, Firefox, or Safari. If you have difficulty installing or accessing a different browser, contact your IT support team.
PLICS Guide
Acute Trust Specific Summary Report
August 2020
Overview
One of the NHS England and NHS Improvement reporting requirements is to provide information back to Acute Trusts in the form of a Trust Specific Summary Report which provides a breakdown of activity and costs based on Acute PLICS data submitted for each Trust.
This document provides details of the report produced by NHS Digital for Trusts and how Trusts access that report via SEFT, after submitting PLICS data to NHS Digital.
This guidance document is a supplementary guidance document published by NHS Digital which complements the NHS England and NHS Improvement Approved Costing Guidance documentation.
Trust Summary Report Overview
The main audience for this guidance document is the submitters of Acute PLICS Financial Year 2019/2020 data.
Report details
Trusts will only see their own data in the report which is compiled based on PLICS Acute data submitted to NHS Digital.
The file format of the report is Comma Separated Values (CSV) file format.
The filename of the report is defined as: PLICS_Acute_Summary_Report_XXX_YYYYMMDDTHHMMSS
- the ‘XXX’ denotes the Trust Code submitting the data
- the date / time stamp is included to indicate when the report was generated
Reporting criteria
The report will contain the latest data submitted by each Trust on the basis that this will include data which has passed validation at NHS Digital and has been loaded to NHS Digital systems for processing.
Reporting frequency
The report will be generated on a daily basis during the PLICS Acute submission window for any Trust which has submitted or resubmitted PLICS Acute data.
The report will normally be accessible the next working day after PLICS data has been submitted to NHS Digital (following the process of loading data to NHS Digital systems has completed).
Any data submitted to NHS Digital after 6pm on the previous working day will not be included in the report.
The reports are date / time stamped to indicate when these were generated.
- PLICS data submitted and loaded up to the date / time recorded in the filename will be included in the report
- any data submitted or loaded after the date / time specified in the filename will be made available in subsequent reports
Where Trusts have resubmitted their data to NHS Digital, a further report will be produced and Trusts should ensure they select the latest report (by carefully selecting the latest date / time stamp from the filename) to get the most up to date view of the data submitted and loaded.
In the event your report is not available by 12pm and you submitted PLICS data to NHS Digital before 6pm the previous working day, you may wish to raise a service call with the NHS Digital National Service Desk via email to: ssd.nationalservicedesk@nhs.net
Reporting levels
The report is broken down at Trust Level, ‘Department Code’(DeptCode), ‘ServiceCode’, ‘CurrencyCode’ and ‘EpisodeType’ (where relevant).
The column order of the reports is as shown in the screenshot provided below.
Field mapping
The table below maps the field names in the report to the field names defined in the PLICS Acute Extract Specification to illustrate how the report is compiled based on the submitted data.
Field name (Summary Report | Feedtype | Field name (Extract Specification) | Comments |
---|---|---|---|
OrgSubmittingID | ALL | Organisation identifier (Code of submitting organisation) | In most cases the OrgSubmittingID code will likely be the same code as OrgProviderID, (an exception would be where a Trust is submitting data on behalf of multiple trusts). |
OrgProviderID | ALL | Organisation identifier (Code of provider) | In most cases the OrgSubmittingID code will likely be the same code as OrgProviderID, (an exception would be where a Trust is submitting data on behalf of multiple trusts). |
DeptCode | APC | Point of delivery | - |
DeptCode | EC | Patient level costing care activity type code | Default feedtype code (AE) |
DeptCode | OP | Point of delivery | - |
DeptCode | SWC | Unbundled Care Activity Type | - |
DeptCode | SI | Patient level costing care activity type codetivity Type | Default feedtype code (SI) |
ServiceCode | APC | Activity treatment function code | - |
ServiceCode | EC | Emergency care department type | - |
ServiceCode | OP | Activity treatment function code | - |
ServiceCode | SWC | Critical Care Unit Function | - |
ServiceCode | SI | Unbundled Currency Scheme In Use | - |
CurrencyCode | APC | Finished consultant episode healthcare resource group | These will primarily be HRGs or unbundled HRGs. |
CurrencyCode | EC | Healthcare resource group | These will primarily be HRGs or unbundled HRGs. |
CurrencyCode | SWC | Unbundled HRG | These will primarily be HRGs or unbundled HRGs. |
CurrencyCode | OP | Healthcare resource group | These will primarily be HRGs or unbundled HRGs. |
CurrencyCode | SI | Unbundled Currency | These will primarily be HRGs or unbundled HRGs. |
EpisodeType |
APC | Episode type |
This will only be populated for APC and SWC feedtypes. For other feedtypes this will be left blank. |
EpisodeType | SWC | Critical care period type | This will only be populated for APC and SWC feedtypes. For other feedtypes this will be left blank. |
TotalActivity | ALL | Patient level costing collection activity count | Row Level total of the number of activity records associated with the combination of OrgProviderID, OrgSubmittingID, DeptCode, ServiceCode, CurrencyCode and EpisodeType. |
TotalCost | ALL | Patient level costing collection total cost | Row Level total of the sum of all costs associated with the combination of OrgProviderID, OrgSubmittingID, DeptCode, ServiceCode, CurrencyCode and EpisodeType. |
Average_Cost | N/A | N/A |
|
Accessing the report via SEFT
The Secure Electronic File Transfer (SEFT) system’s function is to transfer files securely into and out of NHS Digital. This is the same system used to submit your PLICS data.
For further details please see the quick help guide for SEFT users.
Logging on to SEFT
NHS Digital will have issued you a username and password to submit your PLICS data. Please use the same credentials provided to access your PLICS Trust Summary Report.
- Log on to SEFT: https://www.seftprod.hscic.gov.uk
- Enter your username and password
- Click on sign on
SEFT dashboard
The SEFT dashboard homepage is where you will see the transfers (downloads) available to you to access
- Select PLICS-Trust-Summary-Report under the transfer name
- Click on the above transfer name, this will take you to the folder for your organisation
3. Click on the file
4. An arrow icon will appear at the bottom of the screen
5. Click on the arrow icon to open the file
Accessing the Report using a 3rd Party Transfer Tool
You can log in to download the report suing a 3rd Party Secure File Transfer Protocol (SFTP) tool rather than the SEFT online Portal.
To log in via a 3rd party tool, in this example WinSCP which is accessible from:
https://winscp.net/eng/index.php if not already downloaded to your own computer.
Windows Secure Copy (WinSCP) is an open source free SFTP client for Windows.
Its main function is file transfer between a local and a remote computer.
Please note that if you choose to use a 3rd party tool you will need to generate a Secure Shell (SSH) key pair.
Guidance for this can be obtained by emailing seft.team@nhs.net
Logging on to WinSCP
1. From your start menu select WinSCP
2. Log on to WinSCP
3. Enter your username and password – This will be the same username and password used to access SEFT (as supplied by NHS Digital).
4. Then select Login
5. You will be able to see your own local drive on the left-hand pane and the transfers available to you on the right-hand pane
6. Note: In the right-hand pane clicking on the folder with up mark does not take you anywhere, so please ignore this.
7. Clicking on the PLICS-Trust-Summary-Report transfer takes you into the folder for your organisation
8. Note: Clicking on the up button takes you back to the previous page
9. Note: Select and drag the file to the folder of your choice in the left-hand pane
10. The file is now available to access from your Download folder