Patient data file
For services located in Australia:
Data item | Item name | Location in extract | Data type | Format | Maximum length |
---|---|---|---|---|---|
PatientID | 1 | String | XXXXXX[X(14)] | 14 | |
FacilityIdentifier | 2 | String | XXXX | 4 | |
DateOfBirth | 3 | Date | DD/MM/YYYY | 10 | |
Sex | 4 | Numeric | N | 1 | |
StatisticalLinkageKey | 5 | String | XXXXXDDMMYYYYN | 14 | |
StateOrProvince | 6 | Numeric | N[N] | 2 | |
Postcode | 7 | String | NNNN | 4 | |
CountryOfBirth | 8 | Numeric | N | 1 | |
CountryOfBirthOther | 9 | String | X[28] | 28 | |
Urgency | 10 | Numeric | N | 1 | |
Flag_PedIntellectualDisability | 11 | Boolean | N | 1 | |
IndigenousStatus | 12 | Numeric | N | 1 |
For services located in New Zealand:
Data item | Item name | Location in extract | Data type | Format | Maximum length |
---|---|---|---|---|---|
PatientID | 1 | String | XXXXXX[X(14)] | 14 | |
FacilityIdentifier | 2 | String | XXXX | 4 | |
DateOfBirth | 3 | Date | DD/MM/YYYY | 10 | |
Sex | 4 | Numeric | N | 1 | |
StatisticalLinkageKey | 5 | String | XXXXXDDMMYYYYN | 14 | |
StateOrProvince | 6 | Numeric | N[N] | 2 | |
Postcode | 7 | String | NNNN | 4 | |
CountryOfBirth | 8 | Numeric | N | 1 | |
CountryOfBirthOther | 9 | String | X[28] | 28 | |
Urgency | 10 | Numeric | N | 1 | |
Flag_PedIntellectualDisability | 11 | Boolean | N | 1 | |
Flag_NZ_EthnicityEuropean | 12 | Boolean | N | 1 | |
Flag_NZ_EthnicitySamoan | 13 | Boolean | N | 1 | |
Flag_NZ_EthnicityTongan | 14 | Boolean | N | 1 | |
Flag_NZ_EthnicityChinese | 15 | Boolean | N | 1 | |
Flag_NZ_EthnicityMaori | 16 | Boolean | N | 1 | |
Flag_NZ_EthnicityCookIslands | 17 | Boolean | N | 1 | |
Flag_NZ_EthnicityNiuean | 18 | Boolean | N | 1 | |
Flag_NZ_EthnicityIndian | 19 | Boolean | N | 1 | |
Flag_NZ_EthnicityNotStated | 20 | Boolean | N | 1 | |
Flag_NZ_EthnicityOther | 21 | Boolean | N | 1 | |
NZ_EthnicityOther | 22 | String | X[64] | 64 |
Episode data file
For services located in Australia:
Data item | Item name | Location in extract | Data type | Format | Maximum length |
PatientID | 1 | String | XXXXXX[X(14)] | 20 | |
FacilityIdentifier | 2 | String | XXXX | 4 | |
EpisodeID | 3 | ||||
EpisodeIdentifier | 4 | ||||
ReferralDate | 5 | Date | DD/MM/YYYY | 10 | |
ReferralSource | 6 | Numeric | NN | 2 | |
ReferralSourceOther | 7 | String | X[64] | 64 | |
CancerPain | 8 | Boolean | N | 1 | |
EpisodeStartDate | 9 | Date | DD/MM/YYYY | 10 | |
EpisodeStartMode | 10 | Numeric | N | 1 | |
PainSource | 11 | Numeric | N[N] | 2 | |
PainSourceOtherDetail | 12 | String | X[255] | 255 | |
PainDuration | 13 | Numeric | N | 1 | |
Episode end date | EpisodeEndDate | 14 | Date | DD/MM/YYYY | 10 |
Episode end mode | EpisodeEndMode | 15 | Numeric | N | 1 |
Episode end mode: Other - detail | EpisodeEndModeOther | 16 | String | X[255] | 255 |
Health condition: chronic disease | Flag_PedHealthProblemChronicDisease | 17 | Boolean | N | 1 |
Health condition: mental health condition | Flag_PedHealthProblemMental | 18 | Boolean | N | 1 |
Health condition: cancer | Flag_PedHealthProblemCancer | 19 | Boolean | N | 1 |
Disability: sight impairment | Flag_PedDisabilitySight | 20 | Boolean | N | 1 |
Disability: hearing impairment | Flag_PedDisabilityHearing | 21 | Boolean | N | 1 |
Disability: intellectual disability | Flag_PedDisabilityIntellectual | 22 | Boolean | N | 1 |
Disability: physical disability | Flag_PedDisabilityPhysical | 23 | Boolean | N | 1 |
Other health conditions and disabilities - detail | PedHealthConditionsAndDisabilityOther | 24 | String | X[255] | 255 |
Previous pain episode | Flag_PreviouslyAttended | 25 | Boolean | N | 1 |
Compensation case | Flag_CompensationCase | 26 | Boolean | N | 1 |
Compensation case type | CompensationCaseType | 27 | Numeric | N | 1 |
Compensation case type: Other - detail | CompensationOtherDetail | 28 | String | X[64] | 64 |
For services located in New Zealand:
Data item | Item name | Location in extract | Data type | Format | Maximum length |
ePPOC Patient Identifier | PatientID | 1 | String | XXXXXX[X(14)] | 20 |
Facility Identifier | FacilityIdentifier | 2 | String | XXXX | 4 |
Episode ID | EpisodeID | 3 | |||
Episode Identifier | EpisodeIdentifier | 4 | |||
Referral Date | ReferralDate | 5 | Date | DD/MM/YYYY | 10 |
Referral Source | ReferralSource | 6 | Numeric | NN | 2 |
Referral Source: Other - detail | ReferralSourceOther | 7 | String | X[64] | 64 |
Cancer Pain | CancerPain | 8 | Boolean | N | 1 |
Episode Start Date | EpisodeStartDate | 9 | Date | DD/MM/YYYY | 10 |
Episode start mode | EpisodeStartMode | 10 | Numeric | N | 1 |
Pain Source | PainSource | 11 | Numeric | N[N] | 2 |
Pain Source: Other - detail | PainSourceOtherDetail | 12 | String | X[255] | 255 |
Pain duration | PainDuration | 13 | Numeric | N | 1 |
Episode end date | EpisodeEndDate | 14 | Date | DD/MM/YYYY | 10 |
Episode end mode | EpisodeEndMode | 15 | Numeric | N | 1 |
Episode end mode: Other - detail | EpisodeEndModeOther | 16 | String | X[255] | 255 |
Health condition: chronic disease | Flag_PedHealthProblemChronicDisease | 17 | Boolean | N | 1 |
Health condition: mental health condition | Flag_PedHealthProblemMental | 18 | Boolean | N | 1 |
Health condition: cancer | Flag_PedHealthProblemCancer | 19 | Boolean | N | 1 |
Disability: sight impairment | Flag_PedDisabilitySight | 20 | Boolean | N | 1 |
Disability: hearing impairment | Flag_PedDisabilityHearing | 21 | Boolean | N | 1 |
Disability: intellectual disability | Flag_PedDisabilityIntellectual | 22 | Boolean | N | 1 |
Disability: physical disability | Flag_PedDisabilityPhysical | 23 | Boolean | N | 1 |
Other health conditions and disabilities - detail | PedHealthConditionsAndDisabilityOther | 24 | String | X[255] | 255 |
Previous pain episode | Flag_PreviouslyAttended | 25 | Boolean | N | 1 |
Episode funded by ACC | Flag_NZ_FundedACC | 26 | Boolean | N | 1 |
Pathway data file
Data item | Item name | Location in extract | Data type | Format | Maximum length |
---|---|---|---|---|---|
ePPOC Patient Identifier | PatientID | 1 | String | XXXXXX[X(14)] | 20 |
Facility Identifier | FacilityIdentifier | 2 | String | XXXX | 4 |
Episode ID | EpisodeID | 3 | |||
Episode Identifier | EpisodeIdentifier | 4 | |||
PathwayID | PathwayID | 5 | |||
PathwayIdentifier | PathwayIdentifier | 6 | |||
Pathway type | PathwayType | 7 | Numeric | N | 1 |
Pathway start date | PathwayStartDate | 8 | Date | DD/MM/YYYY | 10 |
Pathway end date | PathwayEndDate | 9 | Date | DD/MM/YYYY | 10 |
Group program start date | GroupProgramStartDate | 10 | Date | DD/MM/YYYY | 10 |
Group program end date | GroupProgramEndDate | 11 | Date | DD/MM/YYYY | 10 |
Pathway delivery mode | DeliveryMode | 12 | Numeric | N | 1 |
Service event data file
Data item | Item name | Location in extract | Data type | Format | Maximum length |
---|---|---|---|---|---|
ePPOC Patient ID | PatientID | 1 | String | XXXXXX[X(14)] | 20 |
Facility Identifier | FacilityIdentifier | 2 | String | XXXX | 4 |
Episode ID | EpisodeID | 3 | String | ||
Episode Identifier | EpisodeIdentifier | 4 | String | ||
PathwayID | PathwayID | 5 | String | ||
PathwayIdentifier | PathwayIdentifier | 6 | String | ||
ServiceEventID | ServiceEventID | 7 | String | ||
ServiceEventIdentifier | ServiceEventIdentifier | 8 | String | ||
Service event type | ServiceEvents | 9 | Numeric | N | 1 |
Service event type: Other - detail | ServiceEventsOther | 10 | String | TBD | TBD |
Date of service event | DateOfService | 11 | Date | DD/MM/YYYY | 10 |
DurationOfService | DurationOfService | 12 | Numeric | TBD | TBD |
Telehealth flag | Flag_Telehealth | 13 | Binary | N | 1 |
Patient questionnaire data file
Data item | Item name | Location in extract | Data type | Format | Maximum length |
---|---|---|---|---|---|
ePPOC Patient ID | PatientID | 1 | String | XXXXXX[X(14)] | 20 |
Facility Identifier | FacilityIdentifier | 2 | String | XXXX | 4 |
Episode ID | EpisodeID | 3 | |||
Episode Identifier | EpisodeIdentifier | 4 | |||
PathwayID | PathwayID | 5 | |||
PathwayIdentifier | PathwayIdentifier | 6 | |||
Questionnaire schedule identifier | SurveyScheduleID | 7 | |||
Questionnaire type | SurveyCategoryID | 8 | Numeric | N | 1 |
Ad-hoc questionnaire type | SurveyCategoryOtherID | 9 | Numeric | N[N] | 2 |
Ad-hoc questionnaire type: Other - detail | SurveyDescription | 10 | String | X[100] | 100 |
Generation date | GenerationDate | 11 | Date | DD/MM/YYYY | 10 |
Paediatric questionnaire type | SurveyTypeID | 12 | |||
Survey mode | SurveyModeID | 13 | Numeric | N | 1 |
Sent status | PatientSurveySentStatusID | 14 | Numeric | N | 1 |
Completion date | PatientSurveyCompletionDate | 15 | Date | DD/MM/YYYY | 10 |
Questionnaire identifier | PatientSurveyKey | 16 | |||
Pain description | PainDescription | 17 | Numeric | ||
Site of main pain: none | Flag_PainSiteMainNone | 18 | |||
Pain site: None | Flag_PainSiteOtherNone | 19 | |||
Site of main pain | PainSiteMain | 20 | Numeric | N[N] | 2 |
Pain site: Head | Flag_PainSiteOther_Head | 21 | Boolean | N | 1 |
Pain site: Face | Flag_PainSiteOther_Face | 22 | Boolean | N | 1 |
Pain site: Neck | Flag_PainSiteOther_Neck | 23 | Boolean | N | 1 |
Pain site: Chest | Flag_PainSiteOther_Chest | 24 | Boolean | N | 1 |
Pain site: Abdomen | Flag_PainSiteOther_Abdomen | 25 | Boolean | N | 1 |
Pain site: Groin | Flag_PainSiteOther_Groin | 26 | Boolean | N | 1 |
Pain site: Upper back | Flag_PainSiteOther_UpperBack | 27 | Boolean | N | 1 |
Pain site: Mid back | Flag_PainSiteOther_MidBack | 28 | Boolean | N | 1 |
Pain site: Lower back | Flag_PainSiteOther_LowBack | 29 | Boolean | N | 1 |
Pain site: Shoulder (left) | Flag_PainSiteOther_ShoulderLeft | 30 | Boolean | N | 1 |
Pain site: Shoulder (right) | Flag_PainSiteOther_ShoulderRight | 31 | Boolean | N | 1 |
Pain site: Upper arm (left) | Flag_PainSiteOther_UpperArmLeft | 32 | Boolean | N | 1 |
Pain site: Upper arm (right) | Flag_PainSiteOther_UpperArmRight | 33 | Boolean | N | 1 |
Pain site: Elbow (left) | Flag_PainSiteOther_ElbowLeft | 34 | Boolean | N | 1 |
Pain site: Elbow (right) | Flag_PainSiteOther_ElbowRight | 35 | Boolean | N | 1 |
Pain site: Forearm (left) | Flag_PainSiteOther_ForearmLeft | 36 | Boolean | N | 1 |
Pain site: Forearm (right) | Flag_PainSiteOther_ForearmRight | 37 | Boolean | N | 1 |
Pain site: Wrist (left) | Flag_PainSiteOther_WristLeft | 38 | Boolean | N | 1 |
Pain site: Wrist (right) | Flag_PainSiteOther_WristRight | 39 | Boolean | N | 1 |
Pain site: Hand (left) | Flag_PainSiteOther_HandLeft | 40 | Boolean | N | 1 |
Pain site: Hand (right) | Flag_PainSiteOther_HandRight | 41 | Boolean | N | 1 |
Pain site: Hip (left) | Flag_PainSiteOther_HipLeft | 42 | Boolean | N | 1 |
Pain site: Hip (right) | Flag_PainSiteOther_HipRight | 43 | Boolean | N | 1 |
Pain site: Thigh (left) | Flag_PainSiteOther_ThighLeft | 44 | Boolean | N | 1 |
Pain site: Thigh (right) | Flag_PainSiteOther_ThighRight | 45 | Boolean | N | 1 |
Pain site: Knee (left) | Flag_PainSiteOther_KneeLeft | 46 | Boolean | N | 1 |
Pain site: Knee (right) | Flag_PainSiteOther_KneeRight | 47 | Boolean | N | 1 |
Pain site: Calf (left) | Flag_PainSiteOther_CalfLeft | 48 | Boolean | N | 1 |
Pain site: Calf (right) | Flag_PainSiteOther_CalfRight | 49 | Boolean | N | 1 |
Pain site: Ankle (left) | Flag_PainSiteOther_AnkleLeft | 50 | Boolean | N | 1 |
Pain site: Ankle (right) | Flag_PainSiteOther_AnkleRight | 51 | Boolean | N | 1 |
Pain site: Foot (left) | Flag_PainSiteOther_FootLeft | 52 | Boolean | N | 1 |
Pain site: Foot (right) | Flag_PainSiteOther_FootRight | 53 | Boolean | N | 1 |
Brief Pain Inventory: Worst pain | BPIWorst | 54 | Numeric | N[N] | 2 |
Brief Pain Inventory: Least pain | BPILeast | 55 | Numeric | N[N] | 2 |
Brief Pain Inventory: Average pain | BPIAverage | 56 | Numeric | N[N] | 2 |
Brief Pain Inventory: Pain now | BPINow | 57 | Numeric | N[N] | 2 |
Paediatric Quality of Life Inventory - Physical Functioning: Q1 | PedsQL_Physical_Q1 | 58 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Physical Functioning: Q2 | PedsQL_Physical_Q2 | 59 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Physical Functioning: Q3 | PedsQL_Physical_Q3 | 60 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Physical Functioning: Q4 | PedsQL_Physical_Q4 | 61 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Physical Functioning: Q5 | PedsQL_Physical_Q5 | 62 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Physical Functioning: Q6 | PedsQL_Physical_Q6 | 63 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Physical Functioning: Q7 | PedsQL_Physical_Q7 | 64 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Physical Functioning: Q8 | PedsQL_Physical_Q8 | 65 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Emotional Functioning: Q1 | PedsQL_Emotional_Q1 | 66 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Emotional Functioning: Q2 | PedsQL_Emotional_Q2 | 67 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Emotional Functioning: Q3 | PedsQL_Emotional_Q3 | 68 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Emotional Functioning: Q4 | PedsQL_Emotional_Q4 | 69 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Emotional Functioning: Q5 | PedsQL_Emotional_Q5 | 70 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Social Functioning: Q1 | PedsQL_Social_Q1 | 71 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Social Functioning: Q2 | PedsQL_Social_Q2 | 72 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Social Functioning: Q3 | PedsQL_Social_Q3 | 73 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Social Functioning: Q4 | PedsQL_Social_Q4 | 74 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Social Functioning: Q5 | PedsQL_Social_Q5 | 75 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - School Functioning: Q1 | PedsQL_School_Q1 | 76 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - School Functioning: Q2 | PedsQL_School_Q2 | 77 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - School Functioning: Q3 | PedsQL_School_Q3 | 78 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - School Functioning: Q4 | PedsQL_School_Q4 | 79 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - School Functioning: Q5 | PedsQL_School_Q5 | 80 | Numeric | N | 1 |
Work status: employed | Flag_WPAIEmployed | 81 | |||
Employment status | WPAIEmployedStatus | 82 | |||
Work hours missed | WPAINumberHoursMissed | 83 | |||
Number of hours worked | WPAINumberHoursWorked | 84 | |||
Lost productivity | WPAIProductivityLoss | 85 | |||
Reason for unemployment | WPAINotEmployedCause | 86 | |||
Functional Disability Inventory: Q1 | FDI_Q1 | 87 | Numeric | N | 1 |
Functional Disability Inventory: Q2 | FDI_Q2 | 88 | Numeric | N | 1 |
Functional Disability Inventory: Q3 | FDI_Q3 | 89 | Numeric | N | 1 |
Functional Disability Inventory: Q4 | FDI_Q4 | 90 | Numeric | N | 1 |
Functional Disability Inventory: Q5 | FDI_Q5 | 91 | Numeric | N | 1 |
Functional Disability Inventory: Q6 | FDI_Q6 | 92 | Numeric | N | 1 |
Functional Disability Inventory: Q7 | FDI_Q7 | 93 | Numeric | N | 1 |
Functional Disability Inventory: Q8 | FDI_Q8 | 94 | Numeric | N | 1 |
Functional Disability Inventory: Q9 | FDI_Q9 | 95 | Numeric | N | 1 |
Functional Disability Inventory: Q10 | FDI_Q10 | 96 | Numeric | N | 1 |
Functional Disability Inventory: Q11 | FDI_Q11 | 97 | Numeric | N | 1 |
Functional Disability Inventory: Q12 | FDI_Q12 | 98 | Numeric | N | 1 |
Functional Disability Inventory: Q13 | FDI_Q13 | 99 | Numeric | N | 1 |
Functional Disability Inventory: Q14 | FDI_Q14 | 100 | Numeric | N | 1 |
Functional Disability Inventory: Q15 | FDI_Q15 | 101 | Numeric | N | 1 |
Bath Adolescent Pain Questionnaire: Q1 | BAP_Q1 | 102 | Numeric | N | 1 |
Bath Adolescent Pain Questionnaire: Q2 | BAP_Q2 | 103 | Numeric | N | 1 |
Bath Adolescent Pain Questionnaire: Q3 | BAP_Q3 | 104 | Numeric | N | 1 |
Bath Adolescent Pain Questionnaire: Q4 | BAP_Q4 | 105 | Numeric | N | 1 |
Bath Adolescent Pain Questionnaire: Q5 | BAP_Q5 | 106 | Numeric | N | 1 |
Bath Adolescent Pain Questionnaire: Q6 | BAP_Q6 | 107 | Numeric | N | 1 |
Bath Adolescent Pain Questionnaire: Q7 | BAP_Q7 | 108 | Numeric | N | 1 |
Carer questionnaire data file
Data item | Item name | Location in extract | Data type | Format | Maximum length |
ePPOC Patient ID | PatientID | 1 | String | XXXXXX[X(14)] | 20 |
Facility Identifier | FacilityIdentifier | 2 | String | XXXX | 4 |
Episode ID | EpisodeID | 3 | |||
Episode Identifier | EpisodeIdentifier | 4 | |||
PathwayID | PathwayID | 5 | |||
PathwayIdentifier | PathwayIdentifier | 6 | |||
Questionnaire schedule identifier | SurveyScheduleID | 7 | |||
Questionnaire type | SurveyCategoryID | 8 | |||
Ad-hoc questionnaire type | SurveyCategoryOtherID | 9 | |||
Ad-hoc questionnaire type: Other - detail | SurveyDescription | 10 | |||
Generation date | GenerationDate | 11 | |||
SurveyTypeID | 12 | ||||
Survey mode | SurveyModeID | 13 | |||
Sent status | CarerSurveySentStatusID | 14 | |||
Completion date | CarerSurveyCompletionDate | 15 | |||
Questionnaire identifier | CarerSurveyKey | 16 | |||
Pain description | PainDescription | 17 | |||
Site of main pain: none | Flag_PainSiteMainNone | 18 | |||
Pain site: None | Flag_PainSiteOtherNone | 19 | |||
Site of main pain | PainSiteMain | 20 | Numeric | N[N] | 2 |
Pain site: Head | Flag_PainSiteOther_Head | 21 | Boolean | N | 1 |
Pain site: Face | Flag_PainSiteOther_Face | 22 | Boolean | N | 1 |
Pain site: Neck | Flag_PainSiteOther_Neck | 23 | Boolean | N | 1 |
Pain site: Chest | Flag_PainSiteOther_Chest | 24 | Boolean | N | 1 |
Pain site: Abdomen | Flag_PainSiteOther_Abdomen | 25 | Boolean | N | 1 |
Pain site: Groin | Flag_PainSiteOther_Groin | 26 | Boolean | N | 1 |
Pain site: Upper back | Flag_PainSiteOther_UpperBack | 27 | Boolean | N | 1 |
Pain site: Mid back | Flag_PainSiteOther_MidBack | 28 | Boolean | N | 1 |
Pain site: Lower back | Flag_PainSiteOther_LowBack | 29 | Boolean | N | 1 |
Pain site: Shoulder (left) | Flag_PainSiteOther_ShoulderLeft | 30 | Boolean | N | 1 |
Pain site: Shoulder (right) | Flag_PainSiteOther_ShoulderRight | 31 | Boolean | N | 1 |
Pain site: Upper arm (left) | Flag_PainSiteOther_UpperArmLeft | 32 | Boolean | N | 1 |
Pain site: Upper arm (right) | Flag_PainSiteOther_UpperArmRight | 33 | Boolean | N | 1 |
Pain site: Elbow (left) | Flag_PainSiteOther_ElbowLeft | 34 | Boolean | N | 1 |
Pain site: Elbow (right) | Flag_PainSiteOther_ElbowRight | 35 | Boolean | N | 1 |
Pain site: Forearm (left) | Flag_PainSiteOther_ForearmLeft | 36 | Boolean | N | 1 |
Pain site: Forearm (right) | Flag_PainSiteOther_ForearmRight | 37 | Boolean | N | 1 |
Pain site: Wrist (left) | Flag_PainSiteOther_WristLeft | 38 | Boolean | N | 1 |
Pain site: Wrist (right) | Flag_PainSiteOther_WristRight | 39 | Boolean | N | 1 |
Pain site: Hand (left) | Flag_PainSiteOther_HandLeft | 40 | Boolean | N | 1 |
Pain site: Hand (right) | Flag_PainSiteOther_HandRight | 41 | Boolean | N | 1 |
Pain site: Hip (left) | Flag_PainSiteOther_HipLeft | 42 | Boolean | N | 1 |
Pain site: Hip (right) | Flag_PainSiteOther_HipRight | 43 | Boolean | N | 1 |
Pain site: Thigh (left) | Flag_PainSiteOther_ThighLeft | 44 | Boolean | N | 1 |
Pain site: Thigh (right) | Flag_PainSiteOther_ThighRight | 45 | Boolean | N | 1 |
Pain site: Knee (left) | Flag_PainSiteOther_KneeLeft | 46 | Boolean | N | 1 |
Pain site: Knee (right) | Flag_PainSiteOther_KneeRight | 47 | Boolean | N | 1 |
Pain site: Calf (left) | Flag_PainSiteOther_CalfLeft | 48 | Boolean | N | 1 |
Pain site: Calf (right) | Flag_PainSiteOther_CalfRight | 49 | Boolean | N | 1 |
Pain site: Ankle (left) | Flag_PainSiteOther_AnkleLeft | 50 | Boolean | N | 1 |
Pain site: Ankle (right) | Flag_PainSiteOther_AnkleRight | 51 | Boolean | N | 1 |
Pain site: Foot (left) | Flag_PainSiteOther_FootLeft | 52 | Boolean | N | 1 |
Pain site: Foot (right) | Flag_PainSiteOther_FootRight | 53 | Boolean | N | 1 |
Brief Pain Inventory: Worst pain | BPIWorst | 54 | Numeric | N[N] | 2 |
Brief Pain Inventory: Least pain | BPILeast | 55 | Numeric | N[N] | 2 |
Brief Pain Inventory: Average pain | BPIAverage | 56 | Numeric | N[N] | 2 |
Brief Pain Inventory: Pain now | BPINow | 57 | Numeric | N[N] | 2 |
Paediatric Quality of Life Inventory - Physical Functioning: Q1 | PedsQL_Physical_Q1 | 58 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Physical Functioning: Q2 | PedsQL_Physical_Q2 | 59 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Physical Functioning: Q3 | PedsQL_Physical_Q3 | 60 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Physical Functioning: Q4 | PedsQL_Physical_Q4 | 61 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Physical Functioning: Q5 | PedsQL_Physical_Q5 | 62 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Physical Functioning: Q6 | PedsQL_Physical_Q6 | 63 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Physical Functioning: Q7 | PedsQL_Physical_Q7 | 64 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Physical Functioning: Q8 | PedsQL_Physical_Q8 | 65 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Emotional Functioning: Q1 | PedsQL_Emotional_Q1 | 66 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Emotional Functioning: Q2 | PedsQL_Emotional_Q2 | 67 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Emotional Functioning: Q3 | PedsQL_Emotional_Q3 | 68 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Emotional Functioning: Q4 | PedsQL_Emotional_Q4 | 69 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Emotional Functioning: Q5 | PedsQL_Emotional_Q5 | 70 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Social Functioning: Q1 | PedsQL_Social_Q1 | 71 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Social Functioning: Q2 | PedsQL_Social_Q2 | 72 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Social Functioning: Q3 | PedsQL_Social_Q3 | 73 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Social Functioning: Q4 | PedsQL_Social_Q4 | 74 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - Social Functioning: Q5 | PedsQL_Social_Q5 | 75 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - School Functioning: Q1 | PedsQL_School_Q1 | 76 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - School Functioning: Q2 | PedsQL_School_Q2 | 77 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - School Functioning: Q3 | PedsQL_School_Q3 | 78 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - School Functioning: Q4 | PedsQL_School_Q4 | 79 | Numeric | N | 1 |
Paediatric Quality of Life Inventory - School Functioning: Q5 | PedsQL_School_Q5 | 80 | Numeric | N | 1 |
Work status: employed | Flag_WPAIEmployed | 81 | |||
Work status: employment status | WPAIEmployedStatus | 82 | |||
Work status: work hours missed | WPAINumberHoursMissed | 83 | |||
Work status: number of hours worked | WPAINumberHoursWorked | 84 | |||
Work status: lost productivity | WPAIProductivityLoss | 85 | |||
Work status: reason for unemployment | WPAINotEmployedCause | 86 | |||
Parent/Carer postcode | CarerPostCode | 87 | |||
Parent/Carer sex | CarerSex | 88 | |||
Parent/carer relationship to patient | CarerRelationship | 89 | |||
Parent/carer relationship to patient: Other - description | CarerRelationshipOther | 90 | |||
Parent/carer requires communication assistance | Flag_CarerRequiresHelpWithCom | 91 | |||
Height | Height | 92 | |||
Weight | Weight | 93 | |||
Current school level | SchoolLevel | 94 | |||
Current school level: Other - description | SchoolLevelOther | 95 | |||
School days missed | SchoolDaysMissedFortnight | 96 | |||
Health service use: general practitioner | CountHSUGP | 97 | |||
Health service use: specialist | CountHSUSpecialist | 98 | |||
Health service use: allied health | CountHSUAlliedHealth | 99 | |||
Health service use: other therapists | CountHSUOtherTherapists | 100 | |||
Health service use: emergency department | CountHSUED | 101 | |||
Health service use: hospital admissions | CountHSUHospital | 102 | |||
Health service use: diagnostic tests | CountHSUDiagnosticTests | 103 | |||
Medication use: Paracetamol-only | MedicationParacetamolOnly | 104 | |||
Medication use: Anti-inflammatory non-prescription | MedicationAntiInflamatoryCounter | 105 | |||
Medication use: Anti-inflammatory prescription | MedicationAntiInflamatoryPrescription | 106 | |||
Medication use: Opioid containing codeine | MedicationOpioidWithCodeine | 107 | |||
Medication use: Opioid other than codeine | MedicationOpioidNotCodeine | 108 | |||
Medication use: Nerve | MedicationNerve | 109 | |||
Medication use: Alternative | MedicationAlternative | 110 | |||
XXXX | Flag_ChildCompletedQuestionnaire | 111 | |||
XXXX | NonCompletedReason | 112 | |||
XXXX | NonCompletedReasonOther | 113 |
Carer impact questionnaire data file
Data item | Item name | Location in extract | Data type | Format | Maximum length |
---|---|---|---|---|---|
ePPOC Patient ID | PatientID | 1 | String | XXXXXX[X(14)] | 20 |
Facility Identifier | FacilityIdentifier | 2 | String | XXXX | 4 |
Episode ID | EpisodeID | 3 | |||
Episode Identifier | EpisodeIdentifier | 4 | |||
PathwayID | PathwayID | 5 | |||
PathwayIdentifier | PathwayIdentifier | 6 | |||
Questionnaire schedule identifier | SurveyScheduleID | 7 | |||
Questionnaire type | SurveyCategoryID | 8 | |||
Ad-hoc questionnaire type | SurveyCategoryOtherID | 9 | |||
Ad-hoc questionnaire type: Other - detail | SurveyDescription | 10 | |||
XXXX | SurveyTypeID | 11 | |||
XXXX | SurveyModeID | 12 | |||
Generation date | GenerationDate | 13 | |||
XXXX | CarerImpactSurveySentStatusID | 14 | |||
Completion date | CarerImpactSurveyCompletionDate | 15 | |||
XXXX | CarerImpactSurveyCompletedStatusID | 16 | |||
Bath Parent Impact Questionnaire - Section 1: Q1 | BAPPIQ_S1_Q1 | 17 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 1: Q2 | BAPPIQ_S1_Q2 | 18 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 1: Q3 | BAPPIQ_S1_Q3 | 19 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 1: Q4 | BAPPIQ_S1_Q4 | 20 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 1: Q5 | BAPPIQ_S1_Q5 | 21 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 1: Q6 | BAPPIQ_S1_Q6 | 22 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 1: Q7 | BAPPIQ_S1_Q7 | 23 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 1: Q8 | BAPPIQ_S1_Q8 | 24 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 1: Q9 | BAPPIQ_S1_Q9 | 25 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 2: Q1 | BAPPIQ_S2_Q1 | 26 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 2: Q2 | BAPPIQ_S2_Q2 | 27 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 2: Q3 | BAPPIQ_S2_Q3 | 28 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 2: Q4 | BAPPIQ_S2_Q4 | 29 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 2: Q5 | BAPPIQ_S2_Q5 | 30 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 2: Q6 | BAPPIQ_S2_Q6 | 31 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 3: Q1 | BAPPIQ_S3_Q1 | 32 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 3: Q2 | BAPPIQ_S3_Q2 | 33 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 3: Q3 | BAPPIQ_S3_Q3 | 34 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 3: Q4 | BAPPIQ_S3_Q4 | 35 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 3: Q5 | BAPPIQ_S3_Q5 | 36 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 4: Q1 | BAPPIQ_S4_Q1 | 37 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 4: Q2 | BAPPIQ_S4_Q2 | 38 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 4: Q3 | BAPPIQ_S4_Q3 | 39 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 4: Q4 | BAPPIQ_S4_Q4 | 40 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 4: Q5 | BAPPIQ_S4_Q5 | 41 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 4: Q6 | BAPPIQ_S4_Q6 | 42 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 4: Q7 | BAPPIQ_S4_Q7 | 43 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Has No Partner | Flag_HasNoPartner | 44 | Boolean | N | 1 |
Bath Parent Impact Questionnaire - Section 5: Q1 | BAPPIQ_S5_Q1 | 45 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 5: Q2 | BAPPIQ_S5_Q2 | 46 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 5: Q3 | BAPPIQ_S5_Q3 | 47 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 5: Q4 | BAPPIQ_S5_Q4 | 48 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 5: Q5 | BAPPIQ_S5_Q5 | 49 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 5: Q6 | BAPPIQ_S5_Q6 | 50 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 5: Q7 | BAPPIQ_S5_Q7 | 51 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 6: Q1 | BAPPIQ_S6_Q1 | 52 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 6: Q2 | BAPPIQ_S6_Q2 | 53 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 6: Q3 | BAPPIQ_S6_Q3 | 54 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 6: Q4 | BAPPIQ_S6_Q4 | 55 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 6: Q5 | BAPPIQ_S6_Q5 | 56 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 6: Q6 | BAPPIQ_S6_Q6 | 57 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 6: Q7 | BAPPIQ_S6_Q7 | 58 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 6: Q8 | BAPPIQ_S6_Q8 | 59 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 7: Q1 | BAPPIQ_S7_Q1 | 60 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 7: Q2 | BAPPIQ_S7_Q2 | 61 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 7: Q3 | BAPPIQ_S7_Q3 | 62 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 7: Q4 | BAPPIQ_S7_Q4 | 63 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 7: Q5 | BAPPIQ_S7_Q5 | 64 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 7: Q6 | BAPPIQ_S7_Q6 | 65 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 7: Q7 | BAPPIQ_S7_Q7 | 66 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 7: Q8 | BAPPIQ_S7_Q8 | 67 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 7: Q9 | BAPPIQ_S7_Q9 | 68 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 7: Q10 | BAPPIQ_S7_Q10 | 69 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 7: Q11 | BAPPIQ_S7_Q11 | 70 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 8: Q1 | BAPPIQ_S8_Q1 | 71 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 8: Q2 | BAPPIQ_S8_Q2 | 72 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 8: Q3 | BAPPIQ_S8_Q3 | 73 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 8: Q4 | BAPPIQ_S8_Q4 | 74 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 8: Q5 | BAPPIQ_S8_Q5 | 75 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 8: Q6 | BAPPIQ_S8_Q6 | 76 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 8: Q7 | BAPPIQ_S8_Q7 | 77 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 8: Q8 | BAPPIQ_S8_Q8 | 78 | Numeric | N | 1 |
Bath Parent Impact Questionnaire - Section 8: Q9 | BAPPIQ_S8_Q9 | 79 | Numeric | N | 1 |