PCG Monitor Costing System - User Day 2019 Agenda Multi-level - - PowerPoint PPT Presentation

PCG Monitor Costing System

• User Day 2019

2

Agenda

Multi-level Splits (Rachel Lei) Overheads, Matching and Reallocation (Gary House) Activity and Ledger Validation (Rachel Lei) Analyse Costs and Extract Configuration (Ric Morgan) NHS National Cost Collection 2019 (Rachel Lei)

Multi levels split functions - Pay costs

3 www.publicconsultinggroup.co.uk PCG Monitor Costing System

Ledger Pay Costs Individual Pay Costs Split with Payroll feed (level 1 split) Yes No Service Level Job Plans Split with Job Plans (level 2 split) Cost Quantum Activity Code

Theatre - surgical care SGA081 Ward care SLA097 Outpatient care SLA135 Critical care SLA104 / SLA114

Cost Quantum Activity Code

Adult critical care - medical care SLA104 Paediatric critical care - medical care SLA114

Split with Actual Activities (level 3 split) A c t i v i t y D e f i n i t i o n s Individual Job Plans

www.publicconsultinggroup.co.uk PCG Monitor Costing System 4

Multi-level Split Rules & Results

www.publicconsultinggroup.co.uk PCG Monitor Costing System 5

Multi-level Split Build-up

Payroll Feed Job Plans Actal Activity Built Table Actual Activity Check List Built Table Allocation Code Re-assign

• Please see Gary’s separate OH slides/ Matching /Reallocation down to patient

level

www.publicconsultinggroup.co.uk PCG Monitor Costing System 6

www.publicconsultinggroup.co.uk PCG Monitor Costing System 7

Validation – Activity Update

Latest Updated Results

Activity update rule Update Activity Results

Backup 1 before RULE_DA TA_ORG ANISE_1

Backup 2 before RULE_DATA_ORGANISE_2

www.publicconsultinggroup.co.uk PCG Monitor Costing System 8

Validation – Activity Definitions

Activity Definition rule Activity Definition Results

Click Activity Validation – Report Menu – Activity Definition, Enter search criteria

www.publicconsultinggroup.co.uk PCG Monitor Costing System 9

Validation – Ledger

Buttons to check the Results of various Process

Undefined Results Costing Quantum

www.publicconsultinggroup.co.uk PCG Monitor Costing System 10

Validation – Ledger with Activity Check

Activity Definition rule Undefined Activity Validation Activity out of costing period Sum function for up to 5 numerical fields Change List to change to required filter Change Fields to add extra column for up to 15 fields bespoke report

Analyse Costs and Extract Configuration

www.publicconsultinggroup.co.uk PCG Monitor Costing System 11

• The data produced in the Analyse Costs Qlik-integrated tab and the Extracts that

are produced is fully configurable.

• Easy to use AnalyseCostsFields and individual extract configuration Excel files

make customisation of reports and extracts easy to follow.

Note: Your config files should be stored in: PCGMonitorShared\QlikView\Live Documents\TemplateFiles

Analyse Costs Configuration

www.publicconsultinggroup.co.uk PCG Monitor Costing System 12

Analyse Costs Configuration

www.publicconsultinggroup.co.uk PCG Monitor Costing System 13

Analyse Costs Configuration

www.publicconsultinggroup.co.uk PCG Monitor Costing System 14

Analyse Costs Configuration

www.publicconsultinggroup.co.uk PCG Monitor Costing System 15

Extract Configuration

www.publicconsultinggroup.co.uk PCG Monitor Costing System 16

• Customise Output

Table Name

• Customise Base/

Costable Events

• Customise

Support/Costed Items

• Customise

Ledger Outputs

• Apply Extract

filters

Extract Process

www.publicconsultinggroup.co.uk PCG Monitor Costing System 17

Extract Creation

www.publicconsultinggroup.co.uk PCG Monitor Costing System 18

• You can copy an existing REP extract and rename it to

create a new extract which can be uniquely configured to suit your reporting purposes.

• Copy the extract in the Qlikview\Live

Documents\TemplateFiles\Extracts folder, rename it and store it in the same folder.

• Do the same process for the config file in Qlikview\Live

Documents\TemplateFiles\ExtractsConfigurationFiles. Ensure that the config file name matches the new extract file name.

www.publicconsultinggroup.co.uk PCG Monitor Costing System 19

NHS National Cost Collection 2019

NCC Setup Check list

Item Area Description Check 1 Activity - Core Dummy activity for excluded service [ ] 2 Activity - Core Data for mandotary fields as DVT [ ] 3 Activity - Core Cost_Group fields have been updated for all core records [ ] 4 Activity - Core Service_ID field have been updated for all excluded items, with EXC*** [ ] 5 Activity - Support HRG_Event fields have been populated for High Cost Drug, Unbundled

• utpatient Diagnostic Imaging and Direct Access Imaging

[ ] 6 Activity - Grouper Install 2018-19 RC grouper to data loader and run through scripts [ ] 7 Activity - Grouper Grouper Outputs are named as 'GrouperOut_APCE_1819RCSubmission' and 'GrouperOut_Rehab_1819RCSubmission' [ ] 8 Ledger - Income

PNI = INCOME to all ‘Income From Activities’ (i.e. excluded from the CTP quantum)

[ ] 9 Ledger - Income

PNI = 'Other INCOME' to all net off income

[ ] 10 Ledger - Resource Code

Main national resource code to RESOURCE_CODE

[ ] 11 Ledger - Resource Code

Map the T1 Cost Types into RESOURCE_GROUP_01

[ ] 12 Ledger - Resource Code

FINCode to RESOURCE_GROUP_04

[ ] 13 Ledger - Resource Code

Collection Resource Code to RESOURCE_GROUP_05

[ ] 14 Ledger - Overhead

Overheads costs not apportion to PNI=INCOME and any codes that have been flagged to not receive overhead

[ ] 15 Ledger - Activity Code

National Activity Code into ACTIVITY_CODE

[ ] 16 Ledger - Activity Code

Collection Activity Code into ACTIVITY_GROUP_5

[ ]

Detail Notes and Procedures will be circulated after NHSI publishing DVT for 2019 NCC