Trust summary report overview

Trusts will only see their own data in the report which is compiled based on PLICS data submitted to NHS Digital.

The file format of the report is Comma Separated Values (CSV) file format.

This report is the PLICS_AMB_Summary_Report.

The file name is defined as 

• PLICS_AMB_Summary_Report_XXX_YYYYMMDDTHHMMSS
• the ‘XXX’ denotes the Trust Code submitting the data
• the date / time stamp is included in the form of YYYYMMDDTHHMMSS to indicate when the report was generated.

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.

The report will be generated on a daily basis during the PLICS Ambulance collection submission window, for any Trust which has submitted or resubmitted PLICS data to NHS Digital which has passed the relevant schema validation.

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 10pm on the previous working day will not be included in the report(s).

The report(s) 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.

This PLICS_AMB_Summary_Report is produced if data for the AMB Feed Type has been submitted.

The report is broken down at two levels for each trust

• OrgSubmittingID > OrgProviderID > Feedtype > Incident Currency
• OrgSubmittingID > OrgProviderID > Feedtype > Incident Currency > Call Category

The column order of the report is as shown in this screen shot.

This table maps the field names in the report to the field names defined in the PLICS Ambulance Extract Specification to illustrate how the report is compiled based on the submitted data. Details of fields which are calculated are also shown.