Skip to main content

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.

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.

Screenshot of reporting levels

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


Row Level calculation of TotalCost divided by TotalActivity for that combination of OrgProviderID, OrgSubmittingID, DeptCode, ServiceCode, CurrencyCode and EpisodeType.

 

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.

Screenshot of SEFT log on

SEFT dashboard

The SEFT dashboard homepage is where you will see the transfers (downloads) available to you to access

Screenshot of SEFT dashboard

  1. Select PLICS-Trust-Summary-Report under the transfer name
  2. Click on the above transfer name, this will take you to the folder for your organisation

Screenshot of PLICS trust summary transfer

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
Screenshot of WinSCP login

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

Screenshot of Login box

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

Screenshot of local drive

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

Screenshot of PLICS trust summary report folder

9.    Note: Select and drag the file to the folder of your choice in the left-hand pane

image of drag to folder

10.    The file is now available to access from your Download folder 

Last edited: 22 January 2021 11:39 am