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 | DSS Care AN-SNAP Case Type | IntegerDSS | Care TypeAN-SNAP Case Type [1 – 5] |
3 | C | AN-SNAP Episode Type | Integer | AN-SNAP Episode Type [1 – 5] |
4 | DDSS | Episode of Admitted Patient Care – clinical assessment only indicatorAssessment Only | IntegerDSS Assessment Only | AN-SNAP Yes/No [0 – 1] |
5 | E | DRS Palliative Care AN-SNAP Phase Type | Integer | DRS Palliative Care 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] |
1516 | OP | FIM – Cognition subscale total | Integer | FIM Cognition Total [5-35] |
1617 | PQ | HoNOS 65+ Overactive, Aggressive, Disruptive Behaviour | Integer | HoNOS 65+ Overactive [0-54] |
1718 | QR | HoNOS 65+ Problems with Activities of Daily Living (ADL) | Integer | HoNOS 65+ ADL [0-4] |
1819 | RS | HoNOS 65+ Total | Integer | HoNOS 65+ Total [0-48] |
1920 | ST | DSS Episode Focus of Admitted Patient Care - type of maintenance providedCare | Integer | SNAP Focus of Care |
21 | U | SNAP Maintenance Type | Integer | DSS Maintenance TypeSNAP 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+)
...