Introduction

QuickSnap Native Format is a comprehensive file format which contains all the data items required to arrive at any SNAP 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).

It uses the 'native' AN-SNAP 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 same 'labels'.

If you have a data extract which conforms to the IPHA's DSS/DRS formats you should consider using the QuickSnap DSS Compatible Format. Be aware, however, that this format is only capable of grouping Overnight Episodes/Phases.

Sample Files

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

Excel Template: QuickSnap_Native_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_Native_sample.csv- this is a sample CSV file in QuickSnap DSS Compatible format - QuickSnap will be able to process this file

Data Items

Column	Excel	Item Name	Type	CodeSet / Notes
1	A	RecordIdentifier	String	Up to 64 characters
2	B	AN-SNAP Case Type	Integer	AN-SNAP Case Type [1 – 5]
3	C	AN-SNAP Episode Type	Integer	AN-SNAP Episode Type [1 – 5]
4	D	Assessment Only	Integer	AN-SNAP Yes/No [0 – 1]
5	E	AN-SNAP Phase Type	Integer	AN-SNAP Phase Type [1 – 5]
6	F	Phase Start Date	Date	Phase Start Date (Palliative Care Phases Only)
7	G	Phase End Date	Date	Phase End Date (Palliative Care Phases Only)
8	H	Impairment Code	Decimal	Rehabilitation Impairment Codes
9	I	Date of Birth	Date
10	J	Episode Admission Date	Date
11	K	Episode Discharge Date	Date
12	L	Leave Days	Integer
13	M	RUG – Activities of Daily Living (RUG-ADL)	Integer	RUG-ADL Total [4-18]
14	N	PCPSS	Integer	PCPSS Total [0-12]
15	O	FIM – Motor subscale total	Integer	FIM Motor Total [13-91]
16	P	FIM – Cognition subscale total	Integer	FIM Cognition Total [5-35]
17	Q	HoNOS Overactive, Aggressive, Disruptive Behaviour	Integer	HoNOS Overactive [0-4]
18	R	HoNOS Problems with Activities of Daily Living (ADL)	Integer	HoNOS ADL [0-4]
19	S	HoNOS Total	Integer	HoNOS Total [0-48]
20	T	Focus of Care	Integer	SNAP Focus of Care
21	U	SNAP Maintenance Type	Integer	SNAP Maintenance Type
22	V	Provider Type: Medical	Integer	SNAP Yes/No [0 – 1]
23	W	Provider Type: Nursing	Integer	SNAP Yes/No [0 – 1]
24	X	Provider Type: Physical Therapy	Integer	SNAP Yes/No [0 – 1]
25	Y	Provider Type: Psychosocial Therapy	Integer	SNAP Yes/No [0 – 1]

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]

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' > 90 days

SNAP Code Sets

AN-SNAP Case Type

Value	Description
1	Palliative Care
2	Rehabilitation
3	Psychogeriatric
4	GEM
5	Maintenance

AN-SNAP Episode Type

Value	Description
1	Overnight
2	Same Day
3	Outpatient
4	Community

AN-SNAP Yes/No

Value	Description
0	No
1	Yes

AN-SNAP Phase Type

Value	Description
1	Stable
2	Unstable
3	Deteriorating
4	Terminal
5	Bereavement

AN-SNAP Focus of Care

Value	Description
1	Acute
2	Not Acute

AN-SNAP Maintenance Type

Value	Description
1	Respite
2	Nursing Home Type
3	Convalescent Care
4	Other Maintenance

Browser not supported