QuickSnap Native Format
- David Webster (Unlicensed)
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 |