Introduction
QuickSnap DSS Compatible Format v4 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 uses codesets from the DSS/DRS definitions, but also includes items which are not part of those collections in order to make it capable of arriving at any AN-SNAP v4 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).
Items used in this format
- DSS/DRS compatible 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 similar '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
...
- .
- DRS Palliative Care Linking Key: this item enables QuickSnap to derive ‘Flag: First Phase in Episode’ but relies on assumptions listed below.
- DRS Diagnosis Array: this item enables QuickSnap to derive ‘Flag: Delirium or Dementia’. The item must be supplied in exactly the format described specification referenced (ABF_APC_Specifications_2015-16 – APC data specs, Item 44)
- Items which are not part of the DSS/DRS data collections
...
- : AN-SNAP Rehab Program Type,
...
- GEM Clinic Type. These items are only required for grouping of Non-Admitted episodes, Admitted episodes are able to be grouped using only items from existing collections.
Assumptions; pre-sorting records for grouping of Palliative Care Phases
In order to derive ‘Flag: First Phase in Episode’ SnapGrouper relies on the following assumptions for any given file submitted to SnapGrouper:
- ALL Phases are included for each Episode whose Phases are represented in the file.
- DRS Palliative Care Linking Key is unique for each Episode whose Phases are represented in the file.
- The submitted file is pre-sorted by the following data items, with this priority:
- Palliative Care Linking Key
- Start Date (representing Phase Start Date)
- End Date (representing Phase End Date)
If these assumptions are not met, QuickSnap will not be able to correctly determine the value of ‘Flag: First Phase in Episode’ and this will result in potentially incorrect grouping for Unstable phases, where the grouping specification relies on this flag.
Sample Files
Here are some examples of the QuickSnap DSS Compatible v4 file format:
- Excel Template: QuickSnap_DSS_Compatible_V4_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_DSS_Compatible_V4.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 | DSS Care Type | Integer | DSS Care Type | |||
3 | C | AN-SNAP Episode Type | Integer | AN-SNAP Episode Type [1 – 5] | |||
4 | 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 | |||
| 6 | F | Flag: First Phase In Episode | Integer | AN-SNAP Yes/No [0-1] | 6DRS Palliative Care Linking Key | String | DRS Palliative Care Linking Key |
7 | G | Impairment Code | Decimal | AROC Rehabilitation Impairment Codes | |||
78 | H | Date of Birth | Date |
| |||
89 | I | Start Date | Date |
| |||
910 | J | End Date | Date |
| |||
1011 | K | Leave Days | Integer |
| |||
1112 | L | RUG – Activities of Daily Living (RUG-ADL) | Integer | RUG-ADL Total [4-18] | |||
1213 | M | PCPSS | Integer | PCPSS Total [0-12] | |||
1314 | N | FIM Eating | Integer | FIM Item Score [1-7] | |||
1415 | O | FIM Grooming | Integer | FIM Item Score [1-7] | |||
| 1516 | P | FIM Bathing | Integer | FIM Item Score [1-7] | |||
| 1617 | Q | FIM Dressing Upper Body | Integer | FIM Item Score [1-7] | |||
| 1718 | R | FIM Dressing Lower Body | Integer | FIM Item Score [1-7] | |||
| 1819 | S | FIM Toileting | Integer | FIM Item Score [1-7] | |||
| 1920 | T | FIM Bladder Management | Integer | FIM Item Score [1-7] | |||
| 2021 | U | FIM Bowel Management | Integer | FIM Item Score [1-7] | |||
| 2122 | V | FIM Transfer to Bed/Chair/Wheelchair | Integer | FIM Item Score [1-7] | |||
| 2223 | W | FIM Transfer to Toilet | Integer | FIM Item Score [1-7] | |||
| 2324 | X | FIM Transfer to Bath/Shower | Integer | FIM Item Score [1-7] | |||
| 2425 | Y | FIM Locomotion | Integer | FIM Item Score [1-7] | |||
| 2526 | Z | FIM Stairs | Integer | FIM Item Score [1-7] | |||
| 2627 | AA | FIM Comprehension | Integer | FIM Item Score [1-7] | |||
| 2728 | AB | FIM Expression | Integer | FIM Item Score [1-7] | |||
| 2829 | AC | FIM Social Interaction | Integer | FIM Item Score [1-7] | |||
| 2930 | AD | FIM Problem Solving | Integer | FIM Item Score [1-7] | |||
| 3031 | AE | FIM Memory | Integer | FIM Item Score [1-7] | |||
3132 | AF | HoNOS Behavioural disturbance (= Overactive Behaviour) | Integer | HoNOS Item Score [0-4] | |||
3233 | AG | HoNOS Non-accidental Self Injury | Integer | HoNOS Item Score [0-4] | |||
3334 | AH | HoNOS Problem drinking or drug use | Integer | HoNOS Item Score [0-4] | |||
| 3435 | AI | HoNOS Cognitive problems | Integer | HoNOS Item Score [0-4] | |||
| 3536 | AJ | HoNOS Problems related to physical illness or disability | Integer | HoNOS Item Score [0-4] | |||
| 3637 | AK | HoNOS Problems associated with hallucinations and delusions | Integer | HoNOS Item Score [0-4] | |||
| 3738 | AL | HoNOS Problems associated with depressive symptoms | Integer | HoNOS Item Score [0-4] | |||
| 3839 | AM | HoNOS Other mental and behavioural problems | Integer | HoNOS Item Score [0-4] | |||
| 3940 | AN | HoNOS Problems with social or supportive relationships | Integer | HoNOS Item Score [0-4] | |||
| 4041 | AO | HoNOS Problems with activities of daily living (= ADL) | Integer | HoNOS Item Score [0-4] | |||
| 4142 | AP | HoNOS Overall problems with living conditions | Integer | HoNOS Item Score [0-4] | |||
| 4243 | AQ | HoNOS Problems with work and leisure activities ... | Integer | HoNOS Item Score [0-4] | |||
4344 | AR | Focus of Care | Integer | AN-SNAP Focus of Care | |||
4445 | AS | AN-SNAP Rehab Program Type | Integer | AN-SNAP Rehab Program Type [10-999] | |||
4546 | AT | Flag: Delirium or Dementia | Integer | AN-SNAP Yes/No [0 – 1] | |||
4746 | AUAT | GEM Clinic Type | Integer | AN-SNAP Gem Clinic Type [1-9] | |||
| 47 | AU | DRS Diagnosis Array [as specified in ABF_APC_Specifications_2015-16 – APC data specs, Item 44] | String | DRS Diagnosis Array |
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 | Overnight |
2 | Same Day |
3 | Outpatient |
4 | Community |
...
DSS clinical assessment only indicator
...
Value | Description | AN-SNAP Assessment Only Mapping |
1 | Yes | Yes (1) |
2 | No | No (0) |
3 | Unknown | Unknown |
9 | Not Stated | Unknown |
Because 3 and 9 map to ‘Unknown’ these values will result in grouping errors for Case Type/Episode Type combinations which require the ‘Assessment Only’ flag.
AN-SNAP Yes/No
Value | Description |
0 | No |
1 | Yes |
...
Value | Description |
1 | Single Day of Care without Ongoing Care Plan |
2 | Falls Clinic |
3 | Memory Clinic |
9 | Other Clinic |