QuickSnap Native Format v4 (FIM Summary)
- David Webster (Unlicensed)
Introduction
QuickSnap Native Format v4 (FIM Summary) does not enable you to arrive at all classifications in AN-SNAP v4. It does not contain the individual items for FIM and HoNOS scales, and thus cannot group Admitted Rehabilitation classes.
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'.
- only FIM subscale totals (Motor and Cognition) which means that 'Weighted FIM Motor' as used in the Admitted Rehabilitation cannot be calculated.
- only HoNOS Summary Items: Overactive Behaviour, ADL and HoNOS Total
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. Be aware, however, that this format is only capable of grouping Overnight Episodes/Phases.
Sample Files
Here are some examples of the QuickSnap Native Format v4 (FIM Summary) file format:
- Excel Template: QuickSnap_Native_V4_FimSummary_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_FimSummary.csv- this is a sample CSV file - QuickSnap will be able to process this file
Data Items
Column | Excel | Item Name | Data 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 – Motor subscale total | Integer | FIM Motor Total [13-91] |
17 | Q | FIM – Cognition subscale total | Integer | FIM Cognition Total [5-35] |
18 | R | HoNOS Overactive, Aggressive, Disruptive Behaviour | Integer | HoNOS Overactive [0-5] |
19 | S | HoNOS Problems with Activities of Daily Living (ADL) | Integer | HoNOS ADL [0-4] |
20 | T | HoNOS Total | Integer | HoNOS Total [0-48] |
21 | U | Focus of Care | Integer | AN-SNAP Focus of Care |
22 | V | AN-SNAP Rehab Program Type | Integer | AN-SNAP Rehab Program Type [10-999] |
23 | W | Flag: Delirium or Dementia | Integer | AN-SNAP No/Yes [0 – 1] |
24 | X | GEM Clinic Type | Integer | AN-SNAP Gem Clinic Type [1-9] |
25 | Y | AN-SNAP Age Type | Integer | AN-SNAP AgeType [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+)
Notes and Assumptions
- Impairment Code is the AROC v4 Impairment Code, as specified in this document: AROCv4 Impairment Codes.pdf
- 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 [Episode Admission Date] = [Episode Discharge Date]
- Length of Stay = 1
- Else
- Length of Stay = [Episode Discharge Date] – [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
Derived Items used in AN-SNAP grouping
- Long Term Care: Long Term Care is true if 'Length of Stay' >= 92 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 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) |