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 | DSS Care Type | Integer |
5
DSS Care Type | ||||
3 | C | AN-SNAP Episode Type | Integer | AN-SNAP Episode Type [1 – 5] |
4 |
Assessment Only
Integer
AN-SNAP Yes/No [0 – 1]
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 |
15
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 |
PCPSS
Integer
PCPSS Total [0-12]
N | FIM – Motor subscale total | Integer | FIM Motor Total [13-91] |
15 | O | FIM – Cognition subscale total | Integer | FIM Cognition Total [5-35] |
16 |
P | HoNOS 65+ Overactive, Aggressive, Disruptive Behaviour | Integer | HoNOS 65+ Overactive [0-5] |
17 |
Q | HoNOS 65+ Problems with Activities of Daily Living (ADL) | Integer | HoNOS 65+ ADL [0-4] |
18 | R | HoNOS 65+ Total | Integer | HoNOS 65+ Total [0-48] |
20
Focus of Care
Integer
SNAP Focus of Care
21
19 | S | DSS Episode of Admitted Patient Care - type of maintenance provided | Integer |
SNAP Maintenance Type
22
Provider Type: Medical
Integer
SNAP Yes/No [0 – 1]
23
Provider Type: Nursing
Integer
SNAP Yes/No [0 – 1]
24
Provider Type: Physical Therapy
Integer
SNAP Yes/No [0 – 1]
25
Provider Type: Psychosocial Therapy
Integer
DSS Maintenance Type |
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+)
...
Value | Description |
1 | Respite |
2 | Nursing Home Type |
3 | Convalescent Care |
4 | Other Maintenance |