Introduction
QuickSnap Native Format v4 (Full Detail) 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 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
- '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'
- 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
If you have a data extract which conforms to the IPHA's DSS/DRS formats you should consider using the QuickSnap DSS Compatible Format v4.
Sample Files
Here are some examples of the QuickSnap Native v4 (Full Detail) file format:
- Excel Template: QuickSnap_Native_V4_Detail_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_V4_Detail.csv- this is a sample CSV file - 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 No/Yes |
[0 – 1] | ||||
5 | E | AN-SNAP Phase Type | Integer | AN-SNAP Phase Type [1 – 5] |
6 | F | Flag: First Phase In Episode | Integer | AN-SNAP No/Yes |
[0-1] | ||||
7 | G | Phase Start Date | Date | Phase Start Date (Palliative Care Phases Only) |
8 | H | Phase End Date | Date | Phase End Date (Palliative Care Phases Only) |
9 | I | Impairment Code | Decimal | AROC Rehabilitation Impairment Codes |
10 |
J | Date of Birth | Date |
|
11 |
K |
Episode Admission Date | Date |
12 |
L |
Episode Discharge Date | Date |
13 |
M | Leave Days | Integer |
|
14 |
N | RUG – Activities of Daily Living (RUG-ADL) | Integer | RUG-ADL Total [4-18] |
15 |
O | PCPSS | Integer | PCPSS Total [0-12] |
16 |
P | FIM Eating | Integer | FIM Item Score [1-7] |
17 |
Q | FIM Grooming | Integer | FIM Item Score [1-7] |
18 |
R | FIM Bathing | Integer | FIM Item Score [1-7] |
19 |
S | FIM Dressing Upper Body | Integer | FIM Item Score [1-7] |
20 |
T | FIM Dressing Lower Body | Integer | FIM Item Score [1-7] |
21 |
U | FIM Toileting | Integer | FIM Item Score [1-7] |
22 |
V | FIM Bladder Management | Integer | FIM Item Score [1-7] |
23 |
W | FIM Bowel Management | Integer | FIM Item Score [1-7] |
24 |
X | FIM Transfer to Bed/Chair/Wheelchair | Integer | FIM Item Score [1-7] |
25 |
Y | FIM Transfer to Toilet | Integer | FIM Item Score [1-7] |
26 |
Z | FIM Transfer to Bath/Shower | Integer | FIM Item Score [1-7] |
27 |
AA | FIM Locomotion | Integer | FIM Item Score [1-7] |
28 |
AB | FIM Stairs | Integer | FIM Item Score [1-7] |
29 |
AC | FIM Comprehension | Integer | FIM Item Score [1-7] |
30 |
AD | FIM Expression | Integer | FIM Item Score [1-7] |
31 |
AE | FIM Social Interaction | Integer | FIM Item Score [1-7] |
32 |
AF | FIM Problem Solving | Integer | FIM Item Score [1-7] |
33 |
AG | FIM Memory | Integer | FIM Item Score [1-7] |
34 |
AH | HoNOS Behavioural disturbance (= Overactive Behaviour) | Integer | HoNOS Item Score [0-4] |
35 |
AI | HoNOS Non-accidental Self Injury | Integer | HoNOS Item Score [0-4] |
36 |
AJ | HoNOS Problem drinking or drug use | Integer | HoNOS Item Score [0-4] |
37 |
AK | HoNOS Cognitive problems | Integer | HoNOS Item Score [0-4] |
38 |
AL | HoNOS Problems related to physical illness or disability | Integer | HoNOS Item Score [0-4] |
39 |
AM | HoNOS Problems associated with hallucinations and delusions | Integer | HoNOS Item Score [0-4] |
40 |
AN | HoNOS Problems associated with depressive symptoms | Integer | HoNOS Item Score [0-4] |
41 |
AO | HoNOS Other mental and behavioural problems | Integer | HoNOS Item Score [0-4] |
42 |
AP | HoNOS Problems with social or supportive relationships | Integer | HoNOS Item Score [0-4] |
43 |
AQ | HoNOS Problems with activities of daily living (= ADL) | Integer | HoNOS Item Score [0-4] |
44 |
AR | HoNOS Overall problems with living conditions | Integer | HoNOS Item Score [0-4] |
45 |
AS | HoNOS Problems with work and leisure activities ... | Integer | HoNOS Item Score [0-4] |
46 |
AT | Focus of Care | Integer | AN-SNAP Focus of Care |
47 |
AU | AN-SNAP Rehab Program Type | Integer | AN-SNAP Rehab Program Type [10-999] |
48 |
AV | Flag: Delirium or Dementia | Integer | AN-SNAP No/Yes |
[0 – 1] |
49 |
AW | GEM Clinic Type | Integer | AN-SNAP Gem Clinic Type [1-9] | |
50 | AX | AN-SNAP Age Type | Integer | AN-SNAP Age Type [1, 2, 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+)
...
- 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 DateCase 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 Age will be derived by the following calculation:
- Age = Episode Admission Date – Date of Birth
- Age Type: is the primary determiner of Adult/Paediatric classification for Palliative Care and Rehabilitation:
- If Age Type = 9 (Not Specified): Age will be used to determine Age Type
- If Age Type = 1 (Paediatric): Age will be validated, Age must be <= 19
- If Age Type = 2 (Adult): Age will be validated, Age must be >= 16
- Length of stay will be derived by the following logic/calculation:
- If [End Episode Admission Date] = [Start Episode Discharge Date]
- Length of Stay = 1
- Else
- Length of Stay = [End Episode Discharge Date] – [Start Episode Admission 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
...
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 No/Yes
...
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 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 |
|
AN-SNAP Age Type
Value | Description |
1 | Paediatric |
2 | Adult |
9 | Not Specified (determined by Age) |