QuickSnap DSS Compatible Format v4

Introduction

QuickSnap DSS Compatible Format v4 is a comprehensive file format which contains all the data items required to arrive at any AN-SNAP class in the AN-SNAP v4 Classification.

It uses codesets from the DSS/DRS definitions, but also includes items which are not part of those collections in order to make it capable of arriving at any AN-SNAP v4 class.

It is a CSV file format, and the data items and code sets are described below.

Using this file format will allow you to group both Overnight and Ambulatory (Same Day, Community and Outpatient) Episodes (and Palliative Care phases).

Items used in this format

DSS compatible code sets, which are described below. Please note that the 'native' AN-SNAP code sets are not the same as IPHA's DSS/DRS code sets, despite containing the similar 'labels'
individual FIM Items which enable the calculation of 'Weighted FIM Motor' as used in the Admitted Rehabilitation classes for AN-SNAP v4
individual HoNOS Items, and derives HoNOS Total, HoNOS Overactive Behaviour and HoNOS ADL values
items which are not part of the DSS/DRS data collections (for example SNAP Rehab Program Type, Flag: Delerium or Dementia, GEM Clinic Type)

Sample Files

Here are some examples of the QuickSnap DSS Compatible v4 file format:

Excel Template: QuickSnap_DSS_Compatible_V4_template.xlsx - this file contains a header row and is in Excel format - QuickSnap cannot process this file but it displays the column headers for each data item
CSV Sample: QuickSnap_DSS_Compatible_V4.csv- this is a sample CSV file - QuickSnap will be able to process this file

Data Items

Column	Excel	Item Name	Data Type	CodeSet / Notes
1	A	RecordIdentifier	String	Up to 64 characters
2	B	DSS Care Type	Integer	DSS Care Type
3	C	AN-SNAP Episode Type	Integer	AN-SNAP Episode Type [1 – 5]
4	D	DSS Episode of Admitted Patient Care – clinical assessment only indicator	Integer	DSS Assessment Only
5	E	DRS Palliative Care Phase Type	Integer	DRS Palliative Care Phase Type
6	F	Flag: First Phase In Episode	Integer	AN-SNAP Yes/No [0-1]
6	G	Impairment Code	Decimal	AROC Rehabilitation Impairment Codes
7	H	Date of Birth	Date
8	I	Start Date	Date
9	J	End Date	Date
10	K	Leave Days	Integer
11	L	RUG – Activities of Daily Living (RUG-ADL)	Integer	RUG-ADL Total [4-18]
12	M	PCPSS	Integer	PCPSS Total [0-12]
13	N	FIM Eating	Integer	FIM Item Score [1-7]
14	O	FIM Grooming	Integer	FIM Item Score [1-7]
15	P	FIM Bathing	Integer	FIM Item Score [1-7]
16	Q	FIM Dressing Upper Body	Integer	FIM Item Score [1-7]
17	R	FIM Dressing Lower Body	Integer	FIM Item Score [1-7]
18	S	FIM Toileting	Integer	FIM Item Score [1-7]
19	T	FIM Bladder Management	Integer	FIM Item Score [1-7]
20	U	FIM Bowel Management	Integer	FIM Item Score [1-7]
21	V	FIM Transfer to Bed/Chair/Wheelchair	Integer	FIM Item Score [1-7]
22	W	FIM Transfer to Toilet	Integer	FIM Item Score [1-7]
23	X	FIM Transfer to Bath/Shower	Integer	FIM Item Score [1-7]
24	Y	FIM Locomotion	Integer	FIM Item Score [1-7]
25	Z	FIM Stairs	Integer	FIM Item Score [1-7]
26	AA	FIM Comprehension	Integer	FIM Item Score [1-7]
27	AB	FIM Expression	Integer	FIM Item Score [1-7]
28	AC	FIM Social Interaction	Integer	FIM Item Score [1-7]
29	AD	FIM Problem Solving	Integer	FIM Item Score [1-7]
30	AE	FIM Memory	Integer	FIM Item Score [1-7]
31	AF	HoNOS Behavioural disturbance (= Overactive Behaviour)	Integer	HoNOS Item Score [0-4]
32	AG	HoNOS Non-accidental Self Injury	Integer	HoNOS Item Score [0-4]
33	AH	HoNOS Problem drinking or drug use	Integer	HoNOS Item Score [0-4]
34	AI	HoNOS Cognitive problems	Integer	HoNOS Item Score [0-4]
35	AJ	HoNOS Problems related to physical illness or disability	Integer	HoNOS Item Score [0-4]
36	AK	HoNOS Problems associated with hallucinations and delusions	Integer	HoNOS Item Score [0-4]
37	AL	HoNOS Problems associated with depressive symptoms	Integer	HoNOS Item Score [0-4]
38	AM	HoNOS Other mental and behavioural problems	Integer	HoNOS Item Score [0-4]
39	AN	HoNOS Problems with social or supportive relationships	Integer	HoNOS Item Score [0-4]
40	AO	HoNOS Problems with activities of daily living (= ADL)	Integer	HoNOS Item Score [0-4]
41	AP	HoNOS Overall problems with living conditions	Integer	HoNOS Item Score [0-4]
42	AQ	HoNOS Problems with work and leisure activities ...	Integer	HoNOS Item Score [0-4]
43	AR	Focus of Care	Integer	AN-SNAP Focus of Care
44	AS	SNAP Rehab Program Type	Integer	AN-SNAP Rehab Program Type [10-999]
45	AT	Flag: Delirium or Dementia	Integer	AN-SNAP Yes/No [0 – 1]
47	AU	GEM Clinic Type	Integer	AN-SNAP Gem Clinic Type [1-9]

Abbreviations

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

Notes and Assumptions

Impairment Code is the AROC v4 Impairment Code, as specified in this document: AROCv4 Impairment Codes.pdf
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 will be derived by the following calculation:

Age = Start Date – Date of Birth

Length of stay will be derived by the following logic/calculation:

If [End Date] = [Start Date]
- Length of Stay = 1
Else
- Length of Stay = [End Date] – [Start Date] – [Leave Days]

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 AN-SNAP Code Set as outlined in the tables below:
- DSS Care Type
- DSS clinical assessment only indicator
- DRS Palliative Care Phase Type

Note there is some ambiguity about calculation of ‘Length of Stay’ for palliative care phases, however Length of Stay is not actually used for grouping of palliative care so this does not present a problem for the grouper

Derived Items used in AN-SNAP grouping

Long Term Care: Long Term Care is true if 'Length of Stay' >= 92 days

SNAP Code Sets

DSS Care Type

Value	Description	AN-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	Non-Acute (5)

AN-SNAP Episode Type

Value	Description
1	Overnight
2	Same Day
3	Outpatient
4	Community

DSS clinical assessment only indicator

Value	Description	AN-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.

AN-SNAP Yes/No

Value	Description
0	No
1	Yes

DRS Palliative Care Phase Type

Value	Description	AN-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)

AN-SNAP Focus of Care

Value	Description
1	Acute
2	Not Acute

AN-SNAP Rehab Program Type

Value	Description
10	Stroke Program
20	Brain Dysfunction Program
40	Spinal Cord Dysfunction Program
70	Pain Syndromes Program
80	Orthopaedic Conditions Program
90	Cardiac Program
999	Other Program

AN-SNAP GEM Clinic Type

Value	Description
1	Single Day of Care without Ongoing Care Plan
2	Falls Clinic
3	Memory Clinic
9	Other Clinic