Data item

Item name

Location in extract

Data type

Format

Maximum lengthePPOC Patient Identifier

/wiki/spaces/EV2DC/pages/92012545

PatientID

1

String

XXXXXX[X(14)]

20Facility Identifier

/wiki/spaces/EV2DC/pages/92340225

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

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

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

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