Skip to end of banner
Go to start of banner

QuickSnap DSS Compatible Format

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Introduction

The purpose of this file format is to provide a file format which is easy to generate from the data already being collected in hospitals.

For this reason, it uses DSS and DRS Code Sets and items already defined in DSS.

There are some limitations to the grouping which can be performed using this file format, because it doesn't contain a few data items which are required for grouping ambulatory data:

Specifically, the excluded data items are:

  • Provider Flags: Medical, Nursing, Physical Therapy, Psychosocial Therapy - these are used for most ambulatory AN-SNAP classes
  • Focus of Care: this is used for classifying Psychogeriatric Ambulatory episodes
  • PCPSS: this is used for Palliative Care Ambulatory phases

 Please see the section 'Notes and Assumptions' below to understand more about how these data items are interpreted by QuickSnap when this file format is used.

Data Items

Col

Item Name

Data Type

CodeSet / Notes

1

RecordIdentifier

String

Up to 64 characters

2

DSS Case Type

Integer

DSS Case Type

3

SNAP Episode Type

Integer

SNAP Episode Type [1 – 5]

4

DSS Episode of Admitted Patient Care – clinical assessment only indicator

Integer

DSS Assessment Only

5

DRS Palliative Care Phase Type

Integer

DRS Palliative Care Phase Type

6

Impairment Code

Decimal

Rehabilitation Impairment Codes

7

Date of Birth

Date

 

8

Start Date

Date

formerly Episode Admission Date

9

End Date

Date

formerly Episode Discharge Date

10

Leave Days

Integer

 

11

RUG – Activities of Daily Living (RUG-ADL)

Integer

RUG-ADL Total [4-18]

12

FIM – Motor subscale total

Integer

FIM Motor Total [13-91]

13

FIM – Cognition subscale total

Integer

FIM Cognition Total [5-35]

14

HoNOS 65+ Overactive, Aggressive, Disruptive Behaviour

Integer

HoNOS 65+ Overactive [0-5]

15

HoNOS 65+ Problems with Activities of Daily Living (ADL)

Integer

HoNOS 65+ ADL [0-4]

16

HoNOS 65+ Total

Integer

HoNOS 65+ Total [0-48]

17

DSS Episode of Admitted Patient Care -  type of maintenance provided

Integer

DSS Maintenance Type

Abbreviations

  • RUG: Resource Utilisation Groups
  • PCPSS: Palliative Care Problem Severity Score
  • FIM: Functional Independence Measure
  • HoNOS 65+: Health of the Nation Outcome Scale 65+

Notes and Assumptions

  • Episode Type is not part of DSS but will need to be included in the file as it is a core SNAP data item.  Generally the assumption would be: Episode Type = Overnight (1)
  • Start Date and End Date: these data items have been modified from the previous description of Episode Admission Date and Episode Discharge Date to generalise because Palliative Care groups on Phase rather than Episode. 
    • Thus we have the distinction:
      • Case Type: Palliative Care: Start Date = Phase Start Date, End Date = Phase End Date
      • Case Type: all except Palliative Care: Start Date = Episode Start Date, End Date = Episode End Date
  • Age and Length of Stay will be derived using the rules as per QuickSnap Native Format
  • PCPSS has been omitted from this file format because it is not part of the DSS Data Set. 
    • QuickSnap will assume PCPSS = ‘missing’
    • This will result in most Episodes with Case Type: Palliative Care, Episode Type: Ambulatory (Same Day, Outpatient, Community) being ungroup-able
  • HoNOS 65+ Scores provided in DSS will be mapped directly to HoNOS scores used in AN-SNAP
  • Focus of Care has been omitted from this file format because it is not part of the DSS Data Set
    • QuickSnap will assume Focus of Care = ‘missing’
    • This will result in most Episodes with Case Type: Psychogeriatric, Episode Type: Ambulatory (Same Day, Outpatient, Community) being ungroup-able
  • Provider Type Flags (Medical, Nursing, Physical Therapy, Psychosocial Therapy) have been omitted from the file format because they are not part of the DSS Data Set
    • QuickSnap will assume all of these data items are ‘missing’
    • This would result in grouping errors for the following Case Type/Episode Type combinations:
      • Palliative Care – All Ambulatory (Same Day, Outpatient, Community)
      • Rehabilitation – Outpatient, Community
      • GEM – Outpatient, Community
      • Maintenance – All Ambulatory (Same Day, Outpatient, Community)
    • Due to the fact that Outpatient and Community ‘Episode Types’ are not relevant for DSS Data Collection, in practise this will only result in grouping errors for Palliative Care and Maintenance All Ambulatory episodes
  • Different Code Sets: The following data items use different code sets to the native QuickSnap Native Format.  QuickSnap will accept the DSS/DRS Code Set and map to the relevant SNAP Code Set as outlined in the tables below: 
    • DSS Case Type
    • DSS clinical assessment only indicator
    • DRS Palliative Care Phase Type
    • DSS type of maintenance provided

DSS Compatible Format Code Sets and Mappings

DSS Case Type

Value

Description

SNAP Case Type Mapping

2

Rehabilitation Care

Rehabilitation (2)

3

Palliative Care

Palliative Care (1)

4

Geriatric Evaluation and Management

GEM (4)

5

Psychogeriatric Care

Psychogeriatric (3)

6

Maintenance Care

Maintenance (5)

DSS clinical assessment only indicator

Value

Description

SNAP Assessment Only Mapping

1

Yes

Yes (1)

2

No

No (0)

3

Unknown

Unknown

9

Not Stated

Unknown

Because 3 and 9 map to ‘Unknown’ these values will result in grouping errors for Case Type/Episode Type combinations which require the ‘Assessment Only’ flag.

DRS Palliative Care Phase Type

Value

Description

SNAP Phase Type Mapping

1

Stable

Stable (1)

2

Unstable

Unstable (2)

3

Deteriorating

Deteriorating (3)

4

Terminal

Terminal (4)

9

Not reported

Unknown

Because 9 maps to ‘Unknown’, records with this value will result in grouping errors for Case Type/Episode Type combinations which require Phase Type (almost all Palliative Care episodes)

DSS Maintenance Type

Value

Description

SNAP Maintenance Type Mapping

1

Convalescent Care

Convalescent Care (3)

2

Respite Care

Respite (1)

3

Nursing home type Care

Nursing home type (2)

4

Other maintenance Care

Other Maintenance (4)

98

Unknown

Unknown

99

No Stated/Inadequately Described

Unknown

Because 98 and 99 map to ‘Unknown’, these values will result in grouping errors for Case Type/Episode Type combinations which require Maintenance Type (Case Type: Maintenance,  Episode Type: Overnight)

  • No labels