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 | 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 | |
EpisodeStartDate | 911 | Date | DD/MM/YYYY | 10 | |
EpisodeStartMode | 1012 | Numeric | N | 1 | |
PainSource | 1113 | Numeric | N[N] | 2 | |
PainSourceOtherDetail | 1214 | String | X[255] | 255 | |
PainDuration | 1315 | Numeric | N | 1 | |
EpisodeEndDate | 1416 | Date | DD/MM/YYYY | 10 | |
EpisodeEndMode | 1517 | Numeric | N | 1 | |
EpisodeEndModeOther | 1618 | String | X[255] | 255 | |
Flag_PedHealthProblemChronicDisease | 1719 | Boolean | N | 1 | |
Flag_PedHealthProblemMental | 1820 | Boolean | N | 1 | |
Flag_PedHealthProblemCancer | 1921 | Boolean | N | 1 | |
Flag_PedDisabilitySight | 2022 | Boolean | N | 1 | |
Flag_PedDisabilityHearing | 2123 | Boolean | N | 1 | |
Flag_PedDisabilityIntellectual | 2224 | Boolean | N | 1 | |
Flag_PedDisabilityPhysical | 2325 | Boolean | N | 1 | |
PedHealthConditionsAndDisabilityOther | 2426 | String | X[255] | 255 | |
Flag_PreviouslyAttended | 2527 | Boolean | N | 1 | |
Flag_NZ_FundedACC | 2628 | Boolean | N | 1 |
Pathway data file
...
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 | ||||
PathwayID | 5 | ||||
PathwayIdentifier | 6 | ||||
SurveyScheduleID | 7 | ||||
SurveyCategoryID | 8 | ||||
SurveyCategoryOtherID | 9 | ||||
SurveyDescription | 10 | ||||
GenerationDate | 11 | ||||
SurveyTypeID | 12 | ||||
Survey mode | SurveyModeID | 13 | |||
Sent status | CarerSurveySentStatusID | 14 | |||
Completion date | CarerSurveyCompletionDate | 15 | |||
Questionnaire identifier | CarerSurveyKey | 16 | |||
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 |
PedsQL_Physical_Q1 | 58 | Numeric | N | 1 | |
PedsQL_Physical_Q2 | 59 | Numeric | N | 1 | |
PedsQL_Physical_Q3 | 60 | Numeric | N | 1 | |
PedsQL_Physical_Q4 | 61 | Numeric | N | 1 | |
PedsQL_Physical_Q5 | 62 | Numeric | N | 1 | |
PedsQL_Physical_Q6 | 63 | Numeric | N | 1 | |
PedsQL_Physical_Q7 | 64 | Numeric | N | 1 | |
PedsQL_Physical_Q8 | 65 | Numeric | N | 1 | |
PedsQL_Emotional_Q1 | 66 | Numeric | N | 1 | |
PedsQL_Emotional_Q2 | 67 | Numeric | N | 1 | |
PedsQL_Emotional_Q3 | 68 | Numeric | N | 1 | |
PedsQL_Emotional_Q4 | 69 | Numeric | N | 1 | |
PedsQL_Emotional_Q5 | 70 | Numeric | N | 1 | |
PedsQL_Social_Q1 | 71 | Numeric | N | 1 | |
PedsQL_Social_Q2 | 72 | Numeric | N | 1 | |
PedsQL_Social_Q3 | 73 | Numeric | N | 1 | |
PedsQL_Social_Q4 | 74 | Numeric | N | 1 | |
PedsQL_Social_Q5 | 75 | Numeric | N | 1 | |
PedsQL_School_Q1 | 76 | Numeric | N | 1 | |
PedsQL_School_Q2 | 77 | Numeric | N | 1 | |
PedsQL_School_Q3 | 78 | Numeric | N | 1 | |
PedsQL_School_Q4 | 79 | Numeric | N | 1 | |
PedsQL_School_Q5 | 80 | Numeric | N | 1 | |
Flag_WPAIEmployed | 81 | ||||
WPAIEmployedStatus | 82 | ||||
WPAINumberHoursMissed | 83 | ||||
WPAINumberHoursWorked | 84 | ||||
WPAIProductivityLoss | 85 | ||||
WPAINotEmployedCause | 86 | ||||
CarerPostCode | 87 | ||||
CarerSex | 88 | ||||
CarerRelationship | 89 | ||||
CarerRelationshipOther | 90 | ||||
Flag_CarerRequiresHelpWithCom | 91 | ||||
Height | 92 | ||||
Weight | 93 | ||||
SchoolLevel | 94 | ||||
SchoolLevelOther | 95 | ||||
SchoolDaysMissedFortnight | 96 | ||||
CountHSUGP | 97 | ||||
CountHSUSpecialist | 98 | ||||
CountHSUAlliedHealth | 99 | ||||
CountHSUOtherTherapists | 100 | ||||
CountHSUED | 101 | ||||
CountHSUHospital | 102 | ||||
CountHSUDiagnosticTests | 103 | ||||
MedicationParacetamolOnly | 104Medication use: Anti-inflammatory non-prescription | ||||
MedicationAntiInflamatoryCounter | 105 | ||||
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 | 5PathwayIdentifier | ||||||
PathwayIdentifier | 6Questionnaire schedule identifier | ||||||
SurveyScheduleID | 7Questionnaire type | ||||||
SurveyCategoryID | 8Ad-hoc questionnaire type | ||||||
SurveyCategoryOtherID | 9Ad-hoc questionnaire type: Other - detail | ||||||
SurveyDescription | 10 | ||||||
XXXX | SurveyTypeID | 11 | |||||
XXXX | SurveyModeID | 12 | Generation date | 12 | |||
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 |