Patient data file
For services located in Australia:
...
Data item
...
Item name
...
Location in extract
...
Data type
...
Format
...
Maximum length
...
/wiki/spaces/EV2DC/pages/92012545
...
PatientID
...
1
...
String
...
XXXXXX[X(14)]
...
14
...
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 |
...
Data item | Item name | Location in extract | Data type | Format | Maximum length | |||
PatientID | 1 | String | XXXXXX[X(14)] | 20 | ||||
FacilityIdentifier | 2 | String | XXXX | 4Episode ID | ||||
EpisodeID | 3Episode Identifier | |||||||
EpisodeIdentifier | 4Referral Date | |||||||
ReferralDate | 5 | Date | DD/MM/YYYY | 10 | Referral Source | DD/MM/YYYY | 10 | |
ReferralSource | 6 | Numeric | NN | 2Referral Source: Other - detail | ||||
ReferralSourceOther | 7 | String | X[64] | 64Cancer Pain | ||||
CancerPain | 8 | Boolean | N | 1Episode Start Date | ||||
EpisodeStartDate | 9 | Date | DD/MM/YYYY | 10Episode start mode | ||||
EpisodeStartMode | 10 | Numeric | N | 1Pain Source | ||||
PainSource | 11 | Numeric | N[N] | 2Pain Source: Other - detail | ||||
PainSourceOtherDetail | 12 | String | X[255] | 255Pain duration | ||||
PainDuration | 13 | Numeric | N | 1Episode end date | ||||
EpisodeEndDate | 14 | Date | DD/MM/YYYY | 10Episode end mode | ||||
EpisodeEndMode | 15 | Numeric | N | 1Episode end mode: Other - detail | ||||
EpisodeEndModeOther | 16 | String | X[255] | 255Health condition: chronic disease | ||||
Flag_PedHealthProblemChronicDisease | 17 | Boolean | N | 1Health condition: mental health condition | ||||
Flag_PedHealthProblemMental | 18 | Boolean | N | 1 | Health condition: cancer | 1 | ||
Flag_PedHealthProblemCancer | 19 | Boolean | N | 1Disability: sight impairment | ||||
Flag_PedDisabilitySight | 20 | Boolean | N | 1Disability: hearing impairment | ||||
Flag_PedDisabilityHearing | 21 | Boolean | N | 1Disability: intellectual disability | ||||
Flag_PedDisabilityIntellectual | 22 | Boolean | N | 1Disability: physical disability | ||||
Flag_PedDisabilityPhysical | 23 | Boolean | N | 1Other health conditions and disabilities - detail | ||||
PedHealthConditionsAndDisabilityOther | 24 | String | X[255] | 255Previous pain episode | ||||
Flag_PreviouslyAttended | 25 | Boolean | N | 1Compensation case | ||||
Flag_CompensationCase | 26 | Boolean | N | 1Compensation case type | ||||
CompensationCaseType | 27 | Numeric | N | 1Compensation case type: Other - detail | ||||
CompensationOtherDetail | 28 | String | X[64] | 64 |
...
Data item | Item name | Location in extract | Data type | Format | Maximum lengthePPOC Patient Identifier | ||||
PatientID | 1 | String | XXXXXX[X(14)] | 20Facility Identifier | |||||
FacilityIdentifier | 2 | String | XXXX | 4Episode ID | |||||
EpisodeID | 3Episode Identifier | ||||||||
EpisodeIdentifier | 4Referral Date | ||||||||
ReferralDate | 5 | Date | DD/MM/YYYY | 10Referral Source | |||||
ReferralSource | 6 | Numeric | NN | 2Referral Source: Other - detail | |||||
ReferralSourceOther | 7 | String | X[64] | 64 | Cancer Pain | CancerPain | 8 | Boolean64 | |
CancerPain | 8 | Boolean | N | 1 | |||||
EpisodeStartDate | 9 | Date | DD/MM/YYYY | 10 | |||||
EpisodeStartMode | 10 | Numeric | N | 1Episode Start Date | |||||
EpisodeStartDate | 911 | Date | DD/MM/YYYY | 10Episode start mode | |||||
EpisodeStartMode | 1012 | Numeric | N | 1Pain Source | |||||
PainSource | 1113 | Numeric | N[N] | 2Pain Source: Other - detail | |||||
PainSourceOtherDetail | 1214 | String | X[255] | 255Pain duration | |||||
PainDuration | 1315 | Numeric | N | 1Episode end date | |||||
EpisodeEndDate | 1416 | Date | DD/MM/YYYY | 10Episode end mode | |||||
EpisodeEndMode | 1517 | Numeric | N | 1Episode end mode: Other - detail | |||||
EpisodeEndModeOther | 1618 | String | X[255] | 255Health condition: chronic disease | |||||
Flag_PedHealthProblemChronicDisease | 1719 | Boolean | N | 1Health condition: mental health condition | |||||
Flag_PedHealthProblemMental | 1820 | Boolean | N | 1 | Health condition: cancer1 | ||||
Flag_PedHealthProblemCancer | 1921 | Boolean | N | 1Disability: sight impairment | |||||
Flag_PedDisabilitySight | 2022 | Boolean | N | 1Disability: hearing impairment | |||||
Flag_PedDisabilityHearing | 2123 | Boolean | N | 1Disability: intellectual disability | |||||
Flag_PedDisabilityIntellectual | 2224 | Boolean | N | 1Disability: physical disability | |||||
Flag_PedDisabilityPhysical | 2325 | Boolean | N | 1Other health conditions and disabilities - detail | |||||
PedHealthConditionsAndDisabilityOther | 2426 | String | X[255] | 255Previous pain episode | |||||
Flag_PreviouslyAttended | 2527 | Boolean | N | 1Episode funded by ACC | |||||
Flag_NZ_FundedACC | 2628 | Boolean | N | 1 |
Pathway data file
Data item | Item name | Location in extract | Data type | Format | Maximum length | ||
|---|---|---|---|---|---|---|---|
ePPOC Patient Identifier/wiki/spaces/EV2DC/pages/92012545 | PatientID | 1 | String | XXXXXX[X(14)] | 20Facility Identifier | ||
FacilityIdentifier | 2 | String | XXXX | 4Episode ID | |||
EpisodeID | 3Episode Identifier | ||||||
EpisodeIdentifier | 4 | PathwayID | 4 | ||||
PathwayID | 5PathwayIdentifier | ||||||
PathwayIdentifier | 6Pathway type | ||||||
PathwayType | 7 | Numeric | N | 1Pathway start date | |||
PathwayStartDate | 8 | Date | DD/MM/YYYY | 10Pathway end date | |||
PathwayEndDate | 9 | Date | DD/MM/YYYY | 10Group program start date | |||
GroupProgramStartDate | 10 | Date | DD/MM/YYYY | 10Group program end date | |||
GroupProgramEndDate | 11 | Date | DD/MM/YYYY | 10Pathway 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/wiki/spaces/EV2DC/pages/92012545 | PatientID | 1 | String | XXXXXX[X(14)] | 20Facility Identifier |
FacilityIdentifier | 2 | String | XXXX | 4Episode ID | |
EpisodeID | 3 | StringEpisode Identifier | |||
EpisodeIdentifier | 4 | StringPathwayID | |||
PathwayID | 5 | StringPathwayIdentifier | |||
PathwayIdentifier | 6 | StringServiceEventID | |||
ServiceEventID | 7 | StringServiceEventIdentifier | |||
ServiceEventIdentifier | 8 | StringService event type | |||
ServiceEvents | 9 | Numeric | N | 1Service event type: Other - detail | |
ServiceEventsOther | 10 | String | TBD | TBDDate of service event | |
DateOfService | 11 | Date | DD/MM/YYYY | 10DurationOfService | |
DurationOfService | 12 | Numeric | TBD | TBDTelehealth flag | |
Flag_Telehealth | 13 | Binary | N | 1 |
...
Data item | Item name | Location in extract | Data type | Format | Maximum length |
|---|---|---|---|---|---|
ePPOC Patient ID/wiki/spaces/EV2DC/pages/92012545 | PatientID | 1 | String | XXXXXX[X(14)] | 20Facility Identifier |
FacilityIdentifier | 2 | String | XXXX | 4Episode ID | |
EpisodeID | 3Episode Identifier | ||||
EpisodeIdentifier | 4PathwayID | ||||
PathwayID | 5PathwayIdentifier | ||||
PathwayIdentifier | 6Questionnaire schedule identifier | ||||
SurveyScheduleID | 7Questionnaire type | ||||
SurveyCategoryID | 8 | Numeric | N | 1Ad-hoc questionnaire type | |
SurveyCategoryOtherID | 9 | Numeric | N[N] | 2Ad-hoc questionnaire type: Other - detail | |
SurveyDescription | 10 | String | X[100] | 100Generation date | |
GenerationDate | 11 | Date | DD/MM/YYYY | 10 | |
Paediatric questionnaire type | SurveyTypeID | 12 | |||
Survey mode | SurveyModeID | 13 | Numeric | N | 1Sent status |
PatientSurveySentStatusID | 14 | Numeric | N | 1Completion date | |
PatientSurveyCompletionDate | 15 | Date | DD/MM/YYYY | 10Questionnaire identifier | |
PatientSurveyKey | 16Pain 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] | 2Paediatric Quality of Life Inventory - Physical Functioning: Q1 |
PedsQL_Physical_Q1 | 58 | Numeric | N | 1Paediatric Quality of Life Inventory - Physical Functioning: Q2 | |
PedsQL_Physical_Q2 | 59 | Numeric | N | 1Paediatric Quality of Life Inventory - Physical Functioning: Q3 | |
PedsQL_Physical_Q3 | 60 | Numeric | N | 1Paediatric Quality of Life Inventory - Physical Functioning: Q4 | |
PedsQL_Physical_Q4 | 61 | Numeric | N | 1Paediatric Quality of Life Inventory - Physical Functioning: Q5 | |
PedsQL_Physical_Q5 | 62 | Numeric | N | 1Paediatric Quality of Life Inventory - Physical Functioning: Q6 | |
PedsQL_Physical_Q6 | 63 | Numeric | N | 1Paediatric Quality of Life Inventory - Physical Functioning: Q7 | |
PedsQL_Physical_Q7 | 64 | Numeric | N | 1Paediatric Quality of Life Inventory - Physical Functioning: Q8 | |
PedsQL_Physical_Q8 | 65 | Numeric | N | 1Paediatric Quality of Life Inventory - Emotional Functioning: Q1 | |
PedsQL_Emotional_Q1 | 66 | Numeric | N | 1Paediatric Quality of Life Inventory - Emotional Functioning: Q2 | |
PedsQL_Emotional_Q2 | 67 | Numeric | N | 1Paediatric Quality of Life Inventory - Emotional Functioning: Q3 | |
PedsQL_Emotional_Q3 | 68 | Numeric | N | 1Paediatric Quality of Life Inventory - Emotional Functioning: Q4 | |
PedsQL_Emotional_Q4 | 69 | Numeric | N | 1Paediatric Quality of Life Inventory - Emotional Functioning: Q5 | |
PedsQL_Emotional_Q5 | 70 | Numeric | N | 1Paediatric Quality of Life Inventory - Social Functioning: Q1 | |
PedsQL_Social_Q1 | 71 | Numeric | N | 1Paediatric Quality of Life Inventory - Social Functioning: Q2 | |
PedsQL_Social_Q2 | 72 | Numeric | N | 1Paediatric Quality of Life Inventory - Social Functioning: Q3 | |
PedsQL_Social_Q3 | 73 | Numeric | N | 1Paediatric Quality of Life Inventory - Social Functioning: Q4 | |
PedsQL_Social_Q4 | 74 | Numeric | N | 1Paediatric Quality of Life Inventory - Social Functioning: Q5 | |
PedsQL_Social_Q5 | 75 | Numeric | N | 1Paediatric Quality of Life Inventory - School Functioning: Q1 | |
PedsQL_School_Q1 | 76 | Numeric | N | 1Paediatric Quality of Life Inventory - School Functioning: Q2 | |
PedsQL_School_Q2 | 77 | Numeric | N | 1Paediatric Quality of Life Inventory - School Functioning: Q3 | |
PedsQL_School_Q3 | 78 | Numeric | N | 1Paediatric Quality of Life Inventory - School Functioning: Q4 | |
PedsQL_School_Q4 | 79 | Numeric | N | 1Paediatric Quality of Life Inventory - School Functioning: Q5 | |
PedsQL_School_Q5 | 80 | Numeric | N | 1Work status: employed | |
Flag_WPAIEmployed | 81Employment status | ||||
WPAIEmployedStatus | 82Work hours missed | ||||
WPAINumberHoursMissed | 83Number of hours worked | ||||
WPAINumberHoursWorked | 84Lost productivity | ||||
WPAIProductivityLoss | 85Reason for unemployment | ||||
WPAINotEmployedCause | 86Functional Disability Inventory: Q1 | ||||
FDI_Q1 | 87 | Numeric | N | 1Functional Disability Inventory: Q2 | |
FDI_Q2 | 88 | Numeric | N | 1Functional Disability Inventory: Q3 | |
FDI_Q3 | 89 | Numeric | N | 1Functional Disability Inventory: Q4 | |
FDI_Q4 | 90 | Numeric | N | 1Functional Disability Inventory: Q5 | |
FDI_Q5 | 91 | Numeric | N | 1Functional Disability Inventory: Q6 | |
FDI_Q6 | 92 | Numeric | N | 1Functional Disability Inventory: Q7 | |
FDI_Q7 | 93 | Numeric | N | 1Functional Disability Inventory: Q8 | |
FDI_Q8 | 94 | Numeric | N | 1Functional Disability Inventory: Q9 | |
FDI_Q9 | 95 | Numeric | N | 1Functional Disability Inventory: Q10 | |
FDI_Q10 | 96 | Numeric | N | 1Functional Disability Inventory: Q11 | |
FDI_Q11 | 97 | Numeric | N | 1Functional Disability Inventory: Q12 | |
FDI_Q12 | 98 | Numeric | N | 1Functional Disability Inventory: Q13 | |
FDI_Q13 | 99 | Numeric | N | 1Functional Disability Inventory: Q14 | |
FDI_Q14 | 100 | Numeric | N | 1Functional Disability Inventory: Q15 | |
FDI_Q15 | 101 | Numeric | N | 1Bath Adolescent Pain Questionnaire: Q1 | |
BAP_Q1 | 102 | Numeric | N | 1Bath Adolescent Pain Questionnaire: Q2 | |
BAP_Q2 | 103 | Numeric | N | 1Bath Adolescent Pain Questionnaire: Q3 | |
BAP_Q3 | 104 | Numeric | N | 1Bath Adolescent Pain Questionnaire: Q4 | |
BAP_Q4 | 105 | Numeric | N | 1Bath Adolescent Pain Questionnaire: Q5 | |
BAP_Q5 | 106 | Numeric | N | 1Bath Adolescent Pain Questionnaire: Q6 | |
BAP_Q6 | 107 | Numeric | N | 1Bath 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 lengthePPOC Patient ID | |||
PatientID | 1 | String | XXXXXX[X(14)] | 20Facility Identifier | ||||
FacilityIdentifier | 2 | String | XXXX | 4Episode ID | ||||
EpisodeID | 3Episode Identifier | |||||||
EpisodeIdentifier | 4 | |||||||
PathwayID | PathwayID | 5 | PathwayIdentifier | 5 | ||||
PathwayIdentifier | 6Questionnaire schedule identifier | |||||||
SurveyScheduleID | 7Questionnaire type | |||||||
SurveyCategoryID | 8Ad-hoc questionnaire type | |||||||
SurveyCategoryOtherID | 9Ad-hoc questionnaire type: Other - detail | |||||||
SurveyDescription | 10Generation date | |||||||
GenerationDate | 11 | |||||||
SurveyTypeID | 12 | |||||||
Survey mode | SurveyModeID | 13 | ||||||
Sent status | CarerSurveySentStatusID | 14 | ||||||
Completion date | CarerSurveyCompletionDate | 15 | ||||||
Questionnaire identifier | CarerSurveyKey | 16Pain 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] | 2Paediatric Quality of Life Inventory - Physical Functioning: Q1 | |||
PedsQL_Physical_Q1 | 58 | Numeric | N | 1Paediatric Quality of Life Inventory - Physical Functioning: Q2 | ||||
PedsQL_Physical_Q2 | 59 | Numeric | N | 1Paediatric Quality of Life Inventory - Physical Functioning: Q3 | ||||
PedsQL_Physical_Q3 | 60 | Numeric | N | 1Paediatric Quality of Life Inventory - Physical Functioning: Q4 | ||||
PedsQL_Physical_Q4 | 61 | Numeric | N | 1Paediatric Quality of Life Inventory - Physical Functioning: Q5 | ||||
PedsQL_Physical_Q5 | 62 | Numeric | N | 1Paediatric Quality of Life Inventory - Physical Functioning: Q6 | ||||
PedsQL_Physical_Q6 | 63 | Numeric | N | 1Paediatric Quality of Life Inventory - Physical Functioning: Q7 | ||||
PedsQL_Physical_Q7 | 64 | Numeric | N | 1Paediatric Quality of Life Inventory - Physical Functioning: Q8 | ||||
PedsQL_Physical_Q8 | 65 | Numeric | N | 1Paediatric Quality of Life Inventory - Emotional Functioning: Q1 | ||||
PedsQL_Emotional_Q1 | 66 | Numeric | N | 1Paediatric Quality of Life Inventory - Emotional Functioning: Q2 | ||||
PedsQL_Emotional_Q2 | 67 | Numeric | N | 1Paediatric Quality of Life Inventory - Emotional Functioning: Q3 | ||||
PedsQL_Emotional_Q3 | 68 | Numeric | N | 1Paediatric Quality of Life Inventory - Emotional Functioning: Q4 | ||||
PedsQL_Emotional_Q4 | 69 | Numeric | N | 1Paediatric Quality of Life Inventory - Emotional Functioning: Q5 | ||||
PedsQL_Emotional_Q5 | 70 | Numeric | N | 1Paediatric Quality of Life Inventory - Social Functioning: Q1 | ||||
PedsQL_Social_Q1 | 71 | Numeric | N | 1Paediatric Quality of Life Inventory - Social Functioning: Q2 | ||||
PedsQL_Social_Q2 | 72 | Numeric | N | 1Paediatric Quality of Life Inventory - Social Functioning: Q3 | ||||
PedsQL_Social_Q3 | 73 | Numeric | N | 1Paediatric Quality of Life Inventory - Social Functioning: Q4 | ||||
PedsQL_Social_Q4 | 74 | Numeric | N | 1Paediatric Quality of Life Inventory - Social Functioning: Q5 | ||||
PedsQL_Social_Q5 | 75 | Numeric | N | 1Paediatric Quality of Life Inventory - School Functioning: Q1 | ||||
PedsQL_School_Q1 | 76 | Numeric | N | 1Paediatric Quality of Life Inventory - School Functioning: Q2 | ||||
PedsQL_School_Q2 | 77 | Numeric | N | 1Paediatric Quality of Life Inventory - School Functioning: Q3 | ||||
PedsQL_School_Q3 | 78 | Numeric | N | 1Paediatric Quality of Life Inventory - School Functioning: Q4 | ||||
PedsQL_School_Q4 | 79 | Numeric | N | 1Paediatric Quality of Life Inventory - School Functioning: Q5 | ||||
PedsQL_School_Q5 | 80 | Numeric | N | 1Work status: employed | ||||
Flag_WPAIEmployed | 81Work status: employment status | |||||||
WPAIEmployedStatus | 82Work status: work hours missed | |||||||
WPAINumberHoursMissed | 83Work status: number of hours worked | |||||||
WPAINumberHoursWorked | 84Work status: lost productivity | |||||||
WPAIProductivityLoss | 85Work status: reason for unemployment | |||||||
WPAINotEmployedCause | 86Parent | |||||||
/Carer postcode/wiki/spaces/EV2DC/pages/106135597 | CarerPostCode | 87Parent | ||||||
/Carer sex/wiki/spaces/EV2DC/pages/106135613 | CarerSex | 88Parent/carer relationship to patient | ||||||
CarerRelationship | 89Parent/carer relationship to patient: Other - description | |||||||
CarerRelationshipOther | 90Parent/carer requires communication assistance | |||||||
Flag_CarerRequiresHelpWithCom | 91Height | |||||||
Height | 92Weight | |||||||
Weight | 93Current school level | |||||||
SchoolLevel | 94Current school level: Other - description | |||||||
SchoolLevelOther | 95School days missed | |||||||
SchoolDaysMissedFortnight | 96Health service use: general practitioner | |||||||
CountHSUGP | 97Health service use: specialist | |||||||
CountHSUSpecialist | 98Health service use: allied health | |||||||
CountHSUAlliedHealth | 99Health service use: other therapists | |||||||
CountHSUOtherTherapists | 100Health service use: emergency department | |||||||
CountHSUED | 101Health service use: hospital admissions | |||||||
CountHSUHospital | 102Health service use: diagnostic tests | |||||||
CountHSUDiagnosticTests | 103Medication use: Paracetamol-only | |||||||
MedicationParacetamolOnly | 104Medication use: Anti-inflammatory non-prescription | |||||||
MedicationAntiInflamatoryCounter | 105Medication use: Anti-inflammatory prescription | |||||||
MedicationAntiInflamatoryPrescription | 106Medication use: Opioid containing codeine | |||||||
MedicationOpioidWithCodeine | 107Medication use: Opioid other than codeine | |||||||
MedicationOpioidNotCodeine | 108Medication use: Nerve | |||||||
MedicationNerve | 109Medication use: Alternative | |||||||
MedicationAlternative | 110XXXX | |||||||
Flag_ChildCompletedQuestionnaire | 111XXXX | |||||||
NonCompletedReason | 112XXXX | |||||||
NonCompletedReasonOther | 113 |
...
Data item | Item name | Location in extract | Data type | Format | Maximum length | ||
|---|---|---|---|---|---|---|---|
ePPOC Patient ID/wiki/spaces/EV2DC/pages/92012545 | PatientID | 1 | String | XXXXXX[X(14)] | 20Facility Identifier | ||
FacilityIdentifier | 2 | String | XXXX | 4Episode ID | |||
EpisodeID | 3Episode Identifier | ||||||
EpisodeIdentifier | 4PathwayID | ||||||
PathwayID | 5 | ||||||
PathwayIdentifier | PathwayIdentifier | 6 | Questionnaire schedule identifier6 | ||||
SurveyScheduleID | 7Questionnaire type | ||||||
SurveyCategoryID | 8Ad-hoc questionnaire type | ||||||
SurveyCategoryOtherID | 9Ad-hoc questionnaire type: Other - detail | ||||||
SurveyDescription | 10 | ||||||
XXXX | SurveyTypeID | 11 | |||||
XXXX | SurveyModeID | 12Generation date | |||||
GenerationDate | 13 | ||||||
XXXX | CarerImpactSurveySentStatusID | 14 | |||||
Completion date | CarerImpactSurveyCompletionDate | 15 | |||||
XXXX | CarerImpactSurveyCompletedStatusID | 16Bath Parent Impact Questionnaire - Section 1: Q1 | |||||
BAPPIQ_S1_Q1 | 17 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 1: Q22 | ||
BAPPIQ_S1_Q2 | 18 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 1: Q32 | ||
BAPPIQ_S1_Q3 | 19 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 1: Q42 | ||
BAPPIQ_S1_Q4 | 20 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 1: Q52 | ||
BAPPIQ_S1_Q5 | 21 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 1: Q62 | ||
BAPPIQ_S1_Q6 | 22 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 1: Q72 | ||
BAPPIQ_S1_Q7 | 23 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 1: Q82 | ||
BAPPIQ_S1_Q8 | 24 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 1: Q92 | ||
BAPPIQ_S1_Q9 | 25 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 2: Q12 | ||
BAPPIQ_S2_Q1 | 26 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 2: Q22 | ||
BAPPIQ_S2_Q2 | 27 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 2: Q32 | ||
BAPPIQ_S2_Q3 | 28 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 2: Q42 | ||
BAPPIQ_S2_Q4 | 29 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 2: Q52 | ||
BAPPIQ_S2_Q5 | 30 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 2: Q62 | ||
BAPPIQ_S2_Q6 | 31 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 3: Q12 | ||
BAPPIQ_S3_Q1 | 32 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 3: Q22 | ||
BAPPIQ_S3_Q2 | 33 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 3: Q32 | ||
BAPPIQ_S3_Q3 | 34 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 3: Q42 | ||
BAPPIQ_S3_Q4 | 35 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 3: Q52 | ||
BAPPIQ_S3_Q5 | 36 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 4: Q12 | ||
BAPPIQ_S4_Q1 | 37 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 4: Q22 | ||
BAPPIQ_S4_Q2 | 38 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 4: Q32 | ||
BAPPIQ_S4_Q3 | 39 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 4: Q42 | ||
BAPPIQ_S4_Q4 | 40 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 4: Q52 | ||
BAPPIQ_S4_Q5 | 41 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 4: Q62 | ||
BAPPIQ_S4_Q6 | 42 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 4: Q72 | ||
BAPPIQ_S4_Q7 | 43 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Has No Partner2 | ||
Flag_HasNoPartner | 44 | Boolean | N[N] | 1 | Bath Parent Impact Questionnaire - Section 5: Q12 | ||
BAPPIQ_S5_Q1 | 45 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 5: Q22 | ||
BAPPIQ_S5_Q2 | 46 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 5: Q32 | ||
BAPPIQ_S5_Q3 | 47 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 5: Q42 | ||
BAPPIQ_S5_Q4 | 48 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 5: Q52 | ||
BAPPIQ_S5_Q5 | 49 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 5: Q62 | ||
BAPPIQ_S5_Q6 | 50 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 5: Q72 | ||
BAPPIQ_S5_Q7 | 51 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 6: Q12 | ||
BAPPIQ_S6_Q1 | 52 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 6: Q22 | ||
BAPPIQ_S6_Q2 | 53 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 6: Q32 | ||
BAPPIQ_S6_Q3 | 54 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 6: Q42 | ||
BAPPIQ_S6_Q4 | 55 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 6: Q52 | ||
BAPPIQ_S6_Q5 | 56 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 6: Q62 | ||
BAPPIQ_S6_Q6 | 57 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 6: Q72 | ||
BAPPIQ_S6_Q7 | 58 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 6: Q82 | ||
BAPPIQ_S6_Q8 | 59 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 7: Q12 | ||
BAPPIQ_S7_Q1 | 60 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 7: Q22 | ||
BAPPIQ_S7_Q2 | 61 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 7: Q32 | ||
BAPPIQ_S7_Q3 | 62 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 7: Q42 | ||
BAPPIQ_S7_Q4 | 63 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 7: Q52 | ||
BAPPIQ_S7_Q5 | 64 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 7: Q62 | ||
BAPPIQ_S7_Q6 | 65 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 7: Q72 | ||
BAPPIQ_S7_Q7 | 66 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 7: Q82 | ||
BAPPIQ_S7_Q8 | 67 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 7: Q92 | ||
BAPPIQ_S7_Q9 | 68 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 7: Q102 | ||
BAPPIQ_S7_Q10 | 69 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 7: Q112 | ||
BAPPIQ_S7_Q11 | 70 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 8: Q12 | ||
BAPPIQ_S8_Q1 | 71 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 8: Q22 | ||
BAPPIQ_S8_Q2 | 72 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 8: Q32 | ||
BAPPIQ_S8_Q3 | 73 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 8: Q42 | ||
BAPPIQ_S8_Q4 | 74 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 8: Q52 | ||
BAPPIQ_S8_Q5 | 75 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 8: Q62 | ||
BAPPIQ_S8_Q6 | 76 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 8: Q72 | ||
BAPPIQ_S8_Q7 | 77 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 8: Q82 | ||
BAPPIQ_S8_Q8 | 78 | Numeric | N[N] | 1 | Bath Parent Impact Questionnaire - Section 8: Q92 | ||
BAPPIQ_S8_Q9 | 79 | Numeric | N[N] | 12 |