Skip to end of banner
Go to start of banner

Data file format - paediatric

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 33 Next »

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

/wiki/spaces/EV2DC/pages/92340225

FacilityIdentifier

2

String

XXXX

4

/wiki/spaces/EV2DC/pages/92536833

DateOfBirth

3

Date

DD/MM/YYYY

10

/wiki/spaces/EV2DC/pages/92602369

Sex

4

Numeric

N

1

/wiki/spaces/EV2DC/pages/92667905

StatisticalLinkageKey

5

String

XXXXXDDMMYYYYN

14

/wiki/spaces/EV2DC/pages/92700673

StateOrProvince

6

Numeric

N[N]

2

/wiki/spaces/EV2DC/pages/92602380

Postcode

7

String

NNNN

4

/wiki/spaces/EV2DC/pages/92340240

CountryOfBirth

8

Numeric

N

1

/wiki/spaces/EV2DC/pages/93421569

CountryOfBirthOther

9

String

X[28]

28

/wiki/spaces/EV2DC/pages/93454337

Urgency

10

Numeric

N

1

/wiki/spaces/EV2DC/pages/20579275

Flag_PedIntellectualDisability

11

Boolean

N

1

/wiki/spaces/EV2DC/pages/93454345

IndigenousStatus

12

Numeric

N

1

For services located in New Zealand:

Data item

Item name

Location in extract

Data type

Format

Maximum length

/wiki/spaces/EV2DC/pages/92012545

PatientID

1

String

XXXXXX[X(14)]

14

/wiki/spaces/EV2DC/pages/92340225

FacilityIdentifier

2

String

XXXX

4

/wiki/spaces/EV2DC/pages/92536833

DateOfBirth

3

Date

DD/MM/YYYY

10

/wiki/spaces/EV2DC/pages/92602369

Sex

4

Numeric

N

1

/wiki/spaces/EV2DC/pages/92667905

StatisticalLinkageKey

5

String

XXXXXDDMMYYYYN

14

/wiki/spaces/EV2DC/pages/92798977

StateOrProvince

6

Numeric

N[N]

2

/wiki/spaces/EV2DC/pages/92602380

Postcode

7

String

NNNN

4

/wiki/spaces/EV2DC/pages/92340240

CountryOfBirth

8

Numeric

N

1

/wiki/spaces/EV2DC/pages/93421569

CountryOfBirthOther

9

String

X[28]

28

/wiki/spaces/EV2DC/pages/93454337

Urgency

10

Numeric

N

1

/wiki/spaces/EV2DC/pages/20579275

Flag_PedIntellectualDisability

11

Boolean

N

1

/wiki/spaces/EV2DC/pages/93421578

Flag_NZ_EthnicityEuropean

12

Boolean

N

1

/wiki/spaces/EV2DC/pages/93454353

Flag_NZ_EthnicitySamoan

13

Boolean

N

1

/wiki/spaces/EV2DC/pages/93421585

Flag_NZ_EthnicityTongan

14

Boolean

N

1

/wiki/spaces/EV2DC/pages/93454360

Flag_NZ_EthnicityChinese

15

Boolean

N

1

/wiki/spaces/EV2DC/pages/93421592

Flag_NZ_EthnicityMaori

16

Boolean

N

1

/wiki/spaces/EV2DC/pages/93421599

Flag_NZ_EthnicityCookIslands

17

Boolean

N

1

/wiki/spaces/EV2DC/pages/93421606

Flag_NZ_EthnicityNiuean

18

Boolean

N

1

/wiki/spaces/EV2DC/pages/93454367

Flag_NZ_EthnicityIndian

19

Boolean

N

1

/wiki/spaces/EV2DC/pages/93454374

Flag_NZ_EthnicityNotStated

20

Boolean

N

1

/wiki/spaces/EV2DC/pages/93421613

Flag_NZ_EthnicityOther

21

Boolean

N

1

/wiki/spaces/EV2DC/pages/93421621

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

/wiki/spaces/EV2DC/pages/92012545

PatientID

1

String

XXXXXX[X(14)]

20

/wiki/spaces/EV2DC/pages/92340225

FacilityIdentifier

2

String

XXXX

4

/wiki/spaces/EV2DC/pages/102694913

EpisodeID

3

/wiki/spaces/EV2DC/pages/102727681

EpisodeIdentifier

4

/wiki/spaces/EV2DC/pages/102727695

ReferralDate

5

Date

DD/MM/YYYY

10

/wiki/spaces/EV2DC/pages/102727703

ReferralSource

6

Numeric

NN

2

/wiki/spaces/EV2DC/pages/102694927

ReferralSourceOther

7

String

X[64]

64

/wiki/spaces/EV2DC/pages/102694936

CancerPain

8

Boolean

N

1

/wiki/spaces/EV2DC/pages/102694950

EpisodeStartDate

9

Date

DD/MM/YYYY

10

/wiki/spaces/EV2DC/pages/102727717

EpisodeStartMode

10

Numeric

N

1

/wiki/spaces/EV2DC/pages/102727731

PainSource

11

Numeric

N[N]

2

/wiki/spaces/EV2DC/pages/102694958

PainSourceOtherDetail

12

String

X[255]

255

/wiki/spaces/EV2DC/pages/102694967

PainDuration

13

Numeric

N

1

/wiki/spaces/EV2DC/pages/102694982

EpisodeEndDate

14

Date

DD/MM/YYYY

10

/wiki/spaces/EV2DC/pages/102694990

EpisodeEndMode

15

Numeric

N

1

/wiki/spaces/EV2DC/pages/102695004

EpisodeEndModeOther

16

String

X[255]

255

/wiki/spaces/EV2DC/pages/20580019

Flag_PedHealthProblemChronicDisease

17

Boolean

N

1

/wiki/spaces/EV2DC/pages/20579656

Flag_PedHealthProblemMental

18

Boolean

N

1

/wiki/spaces/EV2DC/pages/20579661

Flag_PedHealthProblemCancer

19

Boolean

N

1

/wiki/spaces/EV2DC/pages/20579717

Flag_PedDisabilitySight

20

Boolean

N

1

/wiki/spaces/EV2DC/pages/20579738

Flag_PedDisabilityHearing

21

Boolean

N

1

/wiki/spaces/EV2DC/pages/20579684

Flag_PedDisabilityIntellectual

22

Boolean

N

1

/wiki/spaces/EV2DC/pages/20579695

Flag_PedDisabilityPhysical

23

Boolean

N

1

/wiki/spaces/EV2DC/pages/20579706

PedHealthConditionsAndDisabilityOther

24

String

X[255]

255

/wiki/spaces/EV2DC/pages/20579768

Flag_PreviouslyAttended

25

Boolean

N

1

/wiki/spaces/EV2DC/pages/102727740

Flag_CompensationCase

26

Boolean

N

1

/wiki/spaces/EV2DC/pages/102727748

CompensationCaseType

27

Numeric

N

1

/wiki/spaces/EV2DC/pages/102727757

CompensationOtherDetail

28

String

X[64]

64


For services located in New Zealand:

Data item

Item name

Location in extract

Data type

Format

Maximum length

/wiki/spaces/EV2DC/pages/92012545

PatientID

1

String

XXXXXX[X(14)]

20

/wiki/spaces/EV2DC/pages/92340225

FacilityIdentifier

2

String

XXXX

4

/wiki/spaces/EV2DC/pages/102694913

EpisodeID

3

/wiki/spaces/EV2DC/pages/102727681

EpisodeIdentifier

4

/wiki/spaces/EV2DC/pages/102727695

ReferralDate

5

Date

DD/MM/YYYY

10

/wiki/spaces/EV2DC/pages/102727703

ReferralSource

6

Numeric

NN

2

/wiki/spaces/EV2DC/pages/102694927

ReferralSourceOther

7

String

X[64]

64

/wiki/spaces/EV2DC/pages/102694936

CancerPain

8

Boolean

N

1

/wiki/spaces/EV2DC/pages/102727731

EpisodeStartDate

9

Date

DD/MM/YYYY

10

/wiki/spaces/EV2DC/pages/102694958

EpisodeStartMode

10

Numeric

N

1

/wiki/spaces/EV2DC/pages/102694967

PainSource

11

Numeric

N[N]

2

/wiki/spaces/EV2DC/pages/102694982

PainSourceOtherDetail

12

String

X[255]

255

/wiki/spaces/EV2DC/pages/102694990

PainDuration

13

Numeric

N

1

/wiki/spaces/EV2DC/pages/102695004

EpisodeEndDate

14

Date

DD/MM/YYYY

10

/wiki/spaces/EV2DC/pages/20580019

EpisodeEndMode

15

Numeric

N

1

/wiki/spaces/EV2DC/pages/20579656

EpisodeEndModeOther

16

String

X[255]

255

/wiki/spaces/EV2DC/pages/20579661

Flag_PedHealthProblemChronicDisease

17

Boolean

N

1

/wiki/spaces/EV2DC/pages/20579717

Flag_PedHealthProblemMental

18

Boolean

N

1

/wiki/spaces/EV2DC/pages/20579738

Flag_PedHealthProblemCancer

19

Boolean

N

1

/wiki/spaces/EV2DC/pages/20579684

Flag_PedDisabilitySight

20

Boolean

N

1

/wiki/spaces/EV2DC/pages/20579695

Flag_PedDisabilityHearing

21

Boolean

N

1

/wiki/spaces/EV2DC/pages/20579706

Flag_PedDisabilityIntellectual

22

Boolean

N

1

/wiki/spaces/EV2DC/pages/102727731

Flag_PedDisabilityPhysical

23

Boolean

N

1

/wiki/spaces/EV2DC/pages/102694958

PedHealthConditionsAndDisabilityOther

24

String

X[255]

255

/wiki/spaces/EV2DC/pages/20579768

Flag_PreviouslyAttended

25

Boolean

N

1

/wiki/spaces/EV2DC/pages/102727766

Flag_NZ_FundedACC

26

Boolean

N

1

Pathway data file

Data item

Item name

Location in extract

Data type

Format

Maximum length

/wiki/spaces/EV2DC/pages/92012545

PatientID

1

String

XXXXXX[X(14)]

20

/wiki/spaces/EV2DC/pages/92340225

FacilityIdentifier

2

String

XXXX

4

/wiki/spaces/EV2DC/pages/102694913

EpisodeID

3

/wiki/spaces/EV2DC/pages/102727681

EpisodeIdentifier

4

/wiki/spaces/EV2DC/pages/102727773

PathwayID

5

/wiki/spaces/EV2DC/pages/102727781

PathwayIdentifier

6

/wiki/spaces/EV2DC/pages/102695013

PathwayType

7

Numeric

N

1

/wiki/spaces/EV2DC/pages/102695027

PathwayStartDate

8

Date

DD/MM/YYYY

10

/wiki/spaces/EV2DC/pages/102695035

PathwayEndDate

9

Date

DD/MM/YYYY

10

/wiki/spaces/EV2DC/pages/102695043

GroupProgramStartDate

10

Date

DD/MM/YYYY

10

/wiki/spaces/EV2DC/pages/102695052

GroupProgramEndDate

11

Date

DD/MM/YYYY

10

/wiki/spaces/EV2DC/pages/102727789

DeliveryMode

12

Numeric

N

1

Service event data file

Data item

Item name

Location in extract

Data type

Format

Maximum length

/wiki/spaces/EV2DC/pages/92012545

PatientID

1

String

XXXXXX[X(14)]

20

/wiki/spaces/EV2DC/pages/92340225

FacilityIdentifier

2

String

XXXX

4

/wiki/spaces/EV2DC/pages/102694913

EpisodeID

3

String

/wiki/spaces/EV2DC/pages/102727681

EpisodeIdentifier

4

String

/wiki/spaces/EV2DC/pages/102727773

PathwayID

5

String

/wiki/spaces/EV2DC/pages/102727781

PathwayIdentifier

6

String

/wiki/spaces/EV2DC/pages/102727803

ServiceEventID

7

String

/wiki/spaces/EV2DC/pages/102727811

ServiceEventIdentifier

8

String

/wiki/spaces/EV2DC/pages/102695062

ServiceEvents

9

Numeric

N

1

/wiki/spaces/EV2DC/pages/102727819

ServiceEventsOther

10

String

TBD

TBD

/wiki/spaces/EV2DC/pages/102727828

DateOfService

11

Date

DD/MM/YYYY

10

/wiki/spaces/EV2DC/pages/102727836

DurationOfService

12

Numeric

TBD

TBD

/wiki/spaces/EV2DC/pages/102695070

Flag_Telehealth

13

Binary

N

1


Patient questionnaire data file

Data item

Item name

Location in extract

Data type

Format

Maximum length

/wiki/spaces/EV2DC/pages/92012545

PatientID

1

String

XXXXXX[X(14)]

20

/wiki/spaces/EV2DC/pages/92340225

FacilityIdentifier

2

String

XXXX

4

/wiki/spaces/EV2DC/pages/102694913

EpisodeID

3

/wiki/spaces/EV2DC/pages/102727681

EpisodeIdentifier

4

/wiki/spaces/EV2DC/pages/102727773

PathwayID

5

/wiki/spaces/EV2DC/pages/102727781

PathwayIdentifier

6

/wiki/spaces/EV2DC/pages/102695078

SurveyScheduleID

7

/wiki/spaces/EV2DC/pages/102727844

SurveyCategoryID

8

Numeric

N

1

/wiki/spaces/EV2DC/pages/102727858

SurveyCategoryOtherID

9

Numeric

N[N]

2

/wiki/spaces/EV2DC/pages/102727866

SurveyDescription

10

String

X[100]

100

/wiki/spaces/EV2DC/pages/102695092

GenerationDate

11

Date

DD/MM/YYYY

10

Paediatric questionnaire type

SurveyTypeID

12

Survey mode

SurveyModeID

13

Numeric

N

1

/wiki/spaces/EV2DC/pages/102695100

PatientSurveySentStatusID

14

Numeric

N

1

/wiki/spaces/EV2DC/pages/102727875

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








  • No labels