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+)
...
Value | Description |
1 | Respite |
2 | Nursing Home Type |
3 | Convalescent Care |
4 | Other Maintenance |