Patient data file

For services located in Australia:

Data item	Item name	Location in extract	Data type	Format	Maximum length
ePPOC Patient Identifier	PatientID	1	String	XXXXXX[X(14)]	14
Facility Identifier	FacilityIdentifier	2	String	XXXX	4
Patient date of birth	DateOfBirth	3	Date	DD/MM/YYYY	10
Patient sex	Sex	4	Numeric	N	1
Patient Statistical linkage key	StatisticalLinkageKey	5	String	XXXXXDDMMYYYYN	14
Australian state or territory	StateOrProvince	6	Numeric	N[N]	2
Postcode	Postcode	7	String	NNNN	4
Country of birth	CountryOfBirth	8	Numeric	N	1
Country of birth: Other - detail	CountryOfBirthOther	9	String	X[28]	28
Urgency category	Urgency	10	Numeric	N	1
Intellectual disability	Flag_PedIntellectualDisability	11	Boolean	N	1
Indigenous status	IndigenousStatus	12	Numeric	N	1

For services located in New Zealand:

Data item	Item name	Location in extract	Data type	Format	Maximum length
ePPOC Patient Identifier	PatientID	1	String	XXXXXX[X(14)]	14
Facility Identifier	FacilityIdentifier	2	String	XXXX	4
Patient date of birth	DateOfBirth	3	Date	DD/MM/YYYY	10
Patient sex	Sex	4	Numeric	N	1
Patient Statistical linkage key	StatisticalLinkageKey	5	String	XXXXXDDMMYYYYN	14
Australian state or territory	StateOrProvince	6	Numeric	N[N]	2
Postcode	Postcode	7	String	NNNN	4
Country of birth	CountryOfBirth	8	Numeric	N	1
Country of birth: Other - detail	CountryOfBirthOther	9	String	X[28]	28
Urgency category	Urgency	10	Numeric	N	1
Intellectual disability	Flag_PedIntellectualDisability	11	Boolean	N	1
Patient ethnicity: New Zealand European	Flag_NZ_EthnicityEuropean	12	Boolean	N	1
Patient ethnicity: Samoan	Flag_NZ_EthnicitySamoan	13	Boolean	N	1
Patient ethnicity: Tongan	Flag_NZ_EthnicityTongan	14	Boolean	N	1
Patient ethnicity: Chinese	Flag_NZ_EthnicityChinese	15	Boolean	N	1
Patient ethnicity: Maori	Flag_NZ_EthnicityMaori	16	Boolean	N	1
Patient ethnicity: Cook Islands Maori	Flag_NZ_EthnicityCookIslands	17	Boolean	N	1
Patient ethnicity: Niuean	Flag_NZ_EthnicityNiuean	18	Boolean	N	1
Patient ethnicity: Indian	Flag_NZ_EthnicityIndian	19	Boolean	N	1
Patient ethnicity: Not stated	Flag_NZ_EthnicityNotStated	20	Boolean	N	1
Patient ethnicity: Other	Flag_NZ_EthnicityOther	21	Boolean	N	1
Patient ethnicity: Other - detail	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
ePPOC Patient Identifier	PatientID	1	String	XXXXXX[X(14)]	20
Facility Identifier	FacilityIdentifier	2	String	XXXX	4
Episode ID	EpisodeID	3
Episode Identifier	EpisodeIdentifier	4
Referral Date	ReferralDate	5	Date	DD/MM/YYYY	10
Referral Source	ReferralSource	6	Numeric	NN	2
Referral Source: Other - detail	ReferralSourceOther	7	String	X[64]	64
Cancer Pain	CancerPain	8	Boolean	N	1
Episode Start Date	EpisodeStartDate	9	Date	DD/MM/YYYY	10
Episode start mode	EpisodeStartMode	10	Numeric	N	1
Pain Source	PainSource	11	Numeric	N[N]	2
Pain Source: Other - detail	PainSourceOtherDetail	12	String	X[255]	255
Pain duration	PainDuration	13	Numeric	N	1
Episode end date	EpisodeEndDate	14	Date	DD/MM/YYYY	10
Episode end mode	EpisodeEndMode	15	Numeric	N	1
Episode end mode: Other - detail	EpisodeEndModeOther	16	String	X[255]	255
Health condition: chronic disease	Flag_PedHealthProblemChronicDisease	17	Boolean	N	1
Health condition: mental health condition	Flag_PedHealthProblemMental	18	Boolean	N	1
Health condition: cancer	Flag_PedHealthProblemCancer	19	Boolean	N	1
Disability: sight impairment	Flag_PedDisabilitySight	20	Boolean	N	1
Disability: hearing impairment	Flag_PedDisabilityHearing	21	Boolean	N	1
Disability: intellectual disability	Flag_PedDisabilityIntellectual	22	Boolean	N	1
Disability: physical disability	Flag_PedDisabilityPhysical	23	Boolean	N	1
Other health conditions and disabilities - detail	PedHealthConditionsAndDisabilityOther	24	String	X[255]	255
Previous pain episode	Flag_PreviouslyAttended	25	Boolean	N	1
Compensation case	Flag_CompensationCase	26	Boolean	N	1
Compensation case type	CompensationCaseType	27	Numeric	N	1
Compensation case type: Other - detail	CompensationOtherDetail	28	String	X[64]	64

For services located in New Zealand:

Data item	Item name	Location in extract	Data type	Format	Maximum length
ePPOC Patient Identifier	PatientID	1	String	XXXXXX[X(14)]	20
Facility Identifier	FacilityIdentifier	2	String	XXXX	4
Episode ID	EpisodeID	3
Episode Identifier	EpisodeIdentifier	4
Referral Date	ReferralDate	5	Date	DD/MM/YYYY	10
Referral Source	ReferralSource	6	Numeric	NN	2
Referral Source: Other - detail	ReferralSourceOther	7	String	X[64]	64
Cancer Pain	CancerPain	8	Boolean	N	1
Episode Start Date	EpisodeStartDate	9	Date	DD/MM/YYYY	10
Episode start mode	EpisodeStartMode	10	Numeric	N	1
Pain Source	PainSource	11	Numeric	N[N]	2
Pain Source: Other - detail	PainSourceOtherDetail	12	String	X[255]	255
Pain duration	PainDuration	13	Numeric	N	1
Episode end date	EpisodeEndDate	14	Date	DD/MM/YYYY	10
Episode end mode	EpisodeEndMode	15	Numeric	N	1
Episode end mode: Other - detail	EpisodeEndModeOther	16	String	X[255]	255
Health condition: chronic disease	Flag_PedHealthProblemChronicDisease	17	Boolean	N	1
Health condition: mental health condition	Flag_PedHealthProblemMental	18	Boolean	N	1
Health condition: cancer	Flag_PedHealthProblemCancer	19	Boolean	N	1
Disability: sight impairment	Flag_PedDisabilitySight	20	Boolean	N	1
Disability: hearing impairment	Flag_PedDisabilityHearing	21	Boolean	N	1
Disability: intellectual disability	Flag_PedDisabilityIntellectual	22	Boolean	N	1
Disability: physical disability	Flag_PedDisabilityPhysical	23	Boolean	N	1
Other health conditions and disabilities - detail	PedHealthConditionsAndDisabilityOther	24	String	X[255]	255
Previous pain episode	Flag_PreviouslyAttended	25	Boolean	N	1
Episode funded by ACC	Flag_NZ_FundedACC	26	Boolean	N	1

Pathway data file

Data item	Item name	Location in extract	Data type	Format	Maximum length
ePPOC Patient Identifier	PatientID	1	String	XXXXXX[X(14)]	20
Facility Identifier	FacilityIdentifier	2	String	XXXX	4
Episode ID	EpisodeID	3
Episode Identifier	EpisodeIdentifier	4
PathwayID	PathwayID	5
PathwayIdentifier	PathwayIdentifier	6
Pathway type	PathwayType	7	Numeric	N	1
Pathway start date	PathwayStartDate	8	Date	DD/MM/YYYY	10
Pathway end date	PathwayEndDate	9	Date	DD/MM/YYYY	10
Group program start date	GroupProgramStartDate	10	Date	DD/MM/YYYY	10
Group program end date	GroupProgramEndDate	11	Date	DD/MM/YYYY	10
Pathway delivery mode	DeliveryMode	12	Numeric	N	1

Service event data file

Data item	Item name	Location in extract	Data type	Format	Maximum length
ePPOC Patient ID	PatientID	1	String	XXXXXX[X(14)]	20
Facility Identifier	FacilityIdentifier	2	String	XXXX	4
Episode ID	EpisodeID	3	String
Episode Identifier	EpisodeIdentifier	4	String
PathwayID	PathwayID	5	String
PathwayIdentifier	PathwayIdentifier	6	String
ServiceEventID	ServiceEventID	7	String
ServiceEventIdentifier	ServiceEventIdentifier	8	String
Service event type	ServiceEvents	9	Numeric	N	1
Service event type: Other - detail	ServiceEventsOther	10	String	TBD	TBD
Date of service event	DateOfService	11	Date	DD/MM/YYYY	10
DurationOfService	DurationOfService	12	Numeric	TBD	TBD
Telehealth flag	Flag_Telehealth	13	Binary	N	1

Patient questionnaire data file

Data item	Item name	Location in extract	Data type	Format	Maximum length
ePPOC Patient ID	PatientID	1	String	XXXXXX[X(14)]	20
Facility Identifier	FacilityIdentifier	2	String	XXXX	4
Episode ID	EpisodeID	3
Episode Identifier	EpisodeIdentifier	4
PathwayID	PathwayID	5
PathwayIdentifier	PathwayIdentifier	6
Questionnaire schedule identifier	SurveyScheduleID	7
Questionnaire type	SurveyCategoryID	8	Numeric	N	1
Ad-hoc questionnaire type	SurveyCategoryOtherID	9	Numeric	N[N]	2
Ad-hoc questionnaire type: Other - detail	SurveyDescription	10	String	X[100]	100
Generation date	GenerationDate	11	Date	DD/MM/YYYY	10
Paediatric questionnaire type	SurveyTypeID	12
Survey mode	SurveyModeID	13	Numeric	N	1
Sent status	PatientSurveySentStatusID	14	Numeric	N	1
Completion date	PatientSurveyCompletionDate	15	Date	DD/MM/YYYY	10
Questionnaire identifier	PatientSurveyKey	16
Pain description	PainDescription	17	Numeric
Site of main pain: none	Flag_PainSiteMainNone	18
Pain site: None	Flag_PainSiteOtherNone	19
Site of main pain	PainSiteMain	20	Numeric	N[N]	2
Pain site: Head	Flag_PainSiteOther_Head	21	Boolean	N	1
Pain site: Face	Flag_PainSiteOther_Face	22	Boolean	N	1
Pain site: Neck	Flag_PainSiteOther_Neck	23	Boolean	N	1
Pain site: Chest	Flag_PainSiteOther_Chest	24	Boolean	N	1
Pain site: Abdomen	Flag_PainSiteOther_Abdomen	25	Boolean	N	1
Pain site: Groin	Flag_PainSiteOther_Groin	26	Boolean	N	1
Pain site: Upper back	Flag_PainSiteOther_UpperBack	27	Boolean	N	1
Pain site: Mid back	Flag_PainSiteOther_MidBack	28	Boolean	N	1
Pain site: Lower back	Flag_PainSiteOther_LowBack	29	Boolean	N	1
Pain site: Shoulder (left)	Flag_PainSiteOther_ShoulderLeft	30	Boolean	N	1
Pain site: Shoulder (right)	Flag_PainSiteOther_ShoulderRight	31	Boolean	N	1
Pain site: Upper arm (left)	Flag_PainSiteOther_UpperArmLeft	32	Boolean	N	1
Pain site: Upper arm (right)	Flag_PainSiteOther_UpperArmRight	33	Boolean	N	1
Pain site: Elbow (left)	Flag_PainSiteOther_ElbowLeft	34	Boolean	N	1
Pain site: Elbow (right)	Flag_PainSiteOther_ElbowRight	35	Boolean	N	1
Pain site: Forearm (left)	Flag_PainSiteOther_ForearmLeft	36	Boolean	N	1
Pain site: Forearm (right)	Flag_PainSiteOther_ForearmRight	37	Boolean	N	1
Pain site: Wrist (left)	Flag_PainSiteOther_WristLeft	38	Boolean	N	1
Pain site: Wrist (right)	Flag_PainSiteOther_WristRight	39	Boolean	N	1
Pain site: Hand (left)	Flag_PainSiteOther_HandLeft	40	Boolean	N	1
Pain site: Hand (right)	Flag_PainSiteOther_HandRight	41	Boolean	N	1
Pain site: Hip (left)	Flag_PainSiteOther_HipLeft	42	Boolean	N	1
Pain site: Hip (right)	Flag_PainSiteOther_HipRight	43	Boolean	N	1
Pain site: Thigh (left)	Flag_PainSiteOther_ThighLeft	44	Boolean	N	1
Pain site: Thigh (right)	Flag_PainSiteOther_ThighRight	45	Boolean	N	1
Pain site: Knee (left)	Flag_PainSiteOther_KneeLeft	46	Boolean	N	1
Pain site: Knee (right)	Flag_PainSiteOther_KneeRight	47	Boolean	N	1
Pain site: Calf (left)	Flag_PainSiteOther_CalfLeft	48	Boolean	N	1
Pain site: Calf (right)	Flag_PainSiteOther_CalfRight	49	Boolean	N	1
Pain site: Ankle (left)	Flag_PainSiteOther_AnkleLeft	50	Boolean	N	1
Pain site: Ankle (right)	Flag_PainSiteOther_AnkleRight	51	Boolean	N	1
Pain site: Foot (left)	Flag_PainSiteOther_FootLeft	52	Boolean	N	1
Pain site: Foot (right)	Flag_PainSiteOther_FootRight	53	Boolean	N	1
Brief Pain Inventory: Worst pain	BPIWorst	54	Numeric	N[N]	2
Brief Pain Inventory: Least pain	BPILeast	55	Numeric	N[N]	2
Brief Pain Inventory: Average pain	BPIAverage	56	Numeric	N[N]	2
Brief Pain Inventory: Pain now	BPINow	57	Numeric	N[N]	2
Paediatric Quality of Life Inventory - Physical Functioning: Q1	PedsQL_Physical_Q1	58	Numeric	N	1
Paediatric Quality of Life Inventory - Physical Functioning: Q2	PedsQL_Physical_Q2	59	Numeric	N	1
Paediatric Quality of Life Inventory - Physical Functioning: Q3	PedsQL_Physical_Q3	60	Numeric	N	1
Paediatric Quality of Life Inventory - Physical Functioning: Q4	PedsQL_Physical_Q4	61	Numeric	N	1
Paediatric Quality of Life Inventory - Physical Functioning: Q5	PedsQL_Physical_Q5	62	Numeric	N	1
Paediatric Quality of Life Inventory - Physical Functioning: Q6	PedsQL_Physical_Q6	63	Numeric	N	1
Paediatric Quality of Life Inventory - Physical Functioning: Q7	PedsQL_Physical_Q7	64	Numeric	N	1
Paediatric Quality of Life Inventory - Physical Functioning: Q8	PedsQL_Physical_Q8	65	Numeric	N	1
Paediatric Quality of Life Inventory - Emotional Functioning: Q1	PedsQL_Emotional_Q1	66	Numeric	N	1
Paediatric Quality of Life Inventory - Emotional Functioning: Q2	PedsQL_Emotional_Q2	67	Numeric	N	1
Paediatric Quality of Life Inventory - Emotional Functioning: Q3	PedsQL_Emotional_Q3	68	Numeric	N	1
Paediatric Quality of Life Inventory - Emotional Functioning: Q4	PedsQL_Emotional_Q4	69	Numeric	N	1
Paediatric Quality of Life Inventory - Emotional Functioning: Q5	PedsQL_Emotional_Q5	70	Numeric	N	1
Paediatric Quality of Life Inventory - Social Functioning: Q1	PedsQL_Social_Q1	71	Numeric	N	1
Paediatric Quality of Life Inventory - Social Functioning: Q2	PedsQL_Social_Q2	72	Numeric	N	1
Paediatric Quality of Life Inventory - Social Functioning: Q3	PedsQL_Social_Q3	73	Numeric	N	1
Paediatric Quality of Life Inventory - Social Functioning: Q4	PedsQL_Social_Q4	74	Numeric	N	1
Paediatric Quality of Life Inventory - Social Functioning: Q5	PedsQL_Social_Q5	75	Numeric	N	1
Paediatric Quality of Life Inventory - School Functioning: Q1	PedsQL_School_Q1	76	Numeric	N	1
Paediatric Quality of Life Inventory - School Functioning: Q2	PedsQL_School_Q2	77	Numeric	N	1
Paediatric Quality of Life Inventory - School Functioning: Q3	PedsQL_School_Q3	78	Numeric	N	1
Paediatric Quality of Life Inventory - School Functioning: Q4	PedsQL_School_Q4	79	Numeric	N	1
Paediatric Quality of Life Inventory - School Functioning: Q5	PedsQL_School_Q5	80	Numeric	N	1
Work status: employed	Flag_WPAIEmployed	81
Employment status	WPAIEmployedStatus	82
Work hours missed	WPAINumberHoursMissed	83
Number of hours worked	WPAINumberHoursWorked	84
Lost productivity	WPAIProductivityLoss	85
Reason for unemployment	WPAINotEmployedCause	86
Functional Disability Inventory: Q1	FDI_Q1	87	Numeric	N	1
Functional Disability Inventory: Q2	FDI_Q2	88	Numeric	N	1
Functional Disability Inventory: Q3	FDI_Q3	89	Numeric	N	1
Functional Disability Inventory: Q4	FDI_Q4	90	Numeric	N	1
Functional Disability Inventory: Q5	FDI_Q5	91	Numeric	N	1
Functional Disability Inventory: Q6	FDI_Q6	92	Numeric	N	1
Functional Disability Inventory: Q7	FDI_Q7	93	Numeric	N	1
Functional Disability Inventory: Q8	FDI_Q8	94	Numeric	N	1
Functional Disability Inventory: Q9	FDI_Q9	95	Numeric	N	1
Functional Disability Inventory: Q10	FDI_Q10	96	Numeric	N	1
Functional Disability Inventory: Q11	FDI_Q11	97	Numeric	N	1
Functional Disability Inventory: Q12	FDI_Q12	98	Numeric	N	1
Functional Disability Inventory: Q13	FDI_Q13	99	Numeric	N	1
Functional Disability Inventory: Q14	FDI_Q14	100	Numeric	N	1
Functional Disability Inventory: Q15	FDI_Q15	101	Numeric	N	1
Bath Adolescent Pain Questionnaire: Q1	BAP_Q1	102	Numeric	N	1
Bath Adolescent Pain Questionnaire: Q2	BAP_Q2	103	Numeric	N	1
Bath Adolescent Pain Questionnaire: Q3	BAP_Q3	104	Numeric	N	1
Bath Adolescent Pain Questionnaire: Q4	BAP_Q4	105	Numeric	N	1
Bath Adolescent Pain Questionnaire: Q5	BAP_Q5	106	Numeric	N	1
Bath Adolescent Pain Questionnaire: Q6	BAP_Q6	107	Numeric	N	1
Bath Adolescent Pain Questionnaire: Q7	BAP_Q7	108	Numeric	N	1

Carer questionnaire data file

Data item	Item name	Location in extract	Data type	Format	Maximum length
ePPOC Patient ID	PatientID	1	String	XXXXXX[X(14)]	20
Facility Identifier	FacilityIdentifier	2	String	XXXX	4
Episode ID	EpisodeID	3
Episode Identifier	EpisodeIdentifier	4
PathwayID	PathwayID	5
PathwayIdentifier	PathwayIdentifier	6
Questionnaire schedule identifier	SurveyScheduleID	7
Questionnaire type	SurveyCategoryID	8
Ad-hoc questionnaire type	SurveyCategoryOtherID	9
Ad-hoc questionnaire type: Other - detail	SurveyDescription	10
Generation date	GenerationDate	11
	SurveyTypeID	12
Survey mode	SurveyModeID	13
Sent status	CarerSurveySentStatusID	14
Completion date	CarerSurveyCompletionDate	15
Questionnaire identifier	CarerSurveyKey	16
Pain description	PainDescription	17
Site of main pain: none	Flag_PainSiteMainNone	18
Pain site: None	Flag_PainSiteOtherNone	19
Site of main pain	PainSiteMain	20	Numeric	N[N]	2
Pain site: Head	Flag_PainSiteOther_Head	21	Boolean	N	1
Pain site: Face	Flag_PainSiteOther_Face	22	Boolean	N	1
Pain site: Neck	Flag_PainSiteOther_Neck	23	Boolean	N	1
Pain site: Chest	Flag_PainSiteOther_Chest	24	Boolean	N	1
Pain site: Abdomen	Flag_PainSiteOther_Abdomen	25	Boolean	N	1
Pain site: Groin	Flag_PainSiteOther_Groin	26	Boolean	N	1
Pain site: Upper back	Flag_PainSiteOther_UpperBack	27	Boolean	N	1
Pain site: Mid back	Flag_PainSiteOther_MidBack	28	Boolean	N	1
Pain site: Lower back	Flag_PainSiteOther_LowBack	29	Boolean	N	1
Pain site: Shoulder (left)	Flag_PainSiteOther_ShoulderLeft	30	Boolean	N	1
Pain site: Shoulder (right)	Flag_PainSiteOther_ShoulderRight	31	Boolean	N	1
Pain site: Upper arm (left)	Flag_PainSiteOther_UpperArmLeft	32	Boolean	N	1
Pain site: Upper arm (right)	Flag_PainSiteOther_UpperArmRight	33	Boolean	N	1
Pain site: Elbow (left)	Flag_PainSiteOther_ElbowLeft	34	Boolean	N	1
Pain site: Elbow (right)	Flag_PainSiteOther_ElbowRight	35	Boolean	N	1
Pain site: Forearm (left)	Flag_PainSiteOther_ForearmLeft	36	Boolean	N	1
Pain site: Forearm (right)	Flag_PainSiteOther_ForearmRight	37	Boolean	N	1
Pain site: Wrist (left)	Flag_PainSiteOther_WristLeft	38	Boolean	N	1
Pain site: Wrist (right)	Flag_PainSiteOther_WristRight	39	Boolean	N	1
Pain site: Hand (left)	Flag_PainSiteOther_HandLeft	40	Boolean	N	1
Pain site: Hand (right)	Flag_PainSiteOther_HandRight	41	Boolean	N	1
Pain site: Hip (left)	Flag_PainSiteOther_HipLeft	42	Boolean	N	1
Pain site: Hip (right)	Flag_PainSiteOther_HipRight	43	Boolean	N	1
Pain site: Thigh (left)	Flag_PainSiteOther_ThighLeft	44	Boolean	N	1
Pain site: Thigh (right)	Flag_PainSiteOther_ThighRight	45	Boolean	N	1
Pain site: Knee (left)	Flag_PainSiteOther_KneeLeft	46	Boolean	N	1
Pain site: Knee (right)	Flag_PainSiteOther_KneeRight	47	Boolean	N	1
Pain site: Calf (left)	Flag_PainSiteOther_CalfLeft	48	Boolean	N	1
Pain site: Calf (right)	Flag_PainSiteOther_CalfRight	49	Boolean	N	1
Pain site: Ankle (left)	Flag_PainSiteOther_AnkleLeft	50	Boolean	N	1
Pain site: Ankle (right)	Flag_PainSiteOther_AnkleRight	51	Boolean	N	1
Pain site: Foot (left)	Flag_PainSiteOther_FootLeft	52	Boolean	N	1
Pain site: Foot (right)	Flag_PainSiteOther_FootRight	53	Boolean	N	1
Brief Pain Inventory: Worst pain	BPIWorst	54	Numeric	N[N]	2
Brief Pain Inventory: Least pain	BPILeast	55	Numeric	N[N]	2
Brief Pain Inventory: Average pain	BPIAverage	56	Numeric	N[N]	2
Brief Pain Inventory: Pain now	BPINow	57	Numeric	N[N]	2
Paediatric Quality of Life Inventory - Physical Functioning: Q1	PedsQL_Physical_Q1	58	Numeric	N	1
Paediatric Quality of Life Inventory - Physical Functioning: Q2	PedsQL_Physical_Q2	59	Numeric	N	1
Paediatric Quality of Life Inventory - Physical Functioning: Q3	PedsQL_Physical_Q3	60	Numeric	N	1
Paediatric Quality of Life Inventory - Physical Functioning: Q4	PedsQL_Physical_Q4	61	Numeric	N	1
Paediatric Quality of Life Inventory - Physical Functioning: Q5	PedsQL_Physical_Q5	62	Numeric	N	1
Paediatric Quality of Life Inventory - Physical Functioning: Q6	PedsQL_Physical_Q6	63	Numeric	N	1
Paediatric Quality of Life Inventory - Physical Functioning: Q7	PedsQL_Physical_Q7	64	Numeric	N	1
Paediatric Quality of Life Inventory - Physical Functioning: Q8	PedsQL_Physical_Q8	65	Numeric	N	1
Paediatric Quality of Life Inventory - Emotional Functioning: Q1	PedsQL_Emotional_Q1	66	Numeric	N	1
Paediatric Quality of Life Inventory - Emotional Functioning: Q2	PedsQL_Emotional_Q2	67	Numeric	N	1
Paediatric Quality of Life Inventory - Emotional Functioning: Q3	PedsQL_Emotional_Q3	68	Numeric	N	1
Paediatric Quality of Life Inventory - Emotional Functioning: Q4	PedsQL_Emotional_Q4	69	Numeric	N	1
Paediatric Quality of Life Inventory - Emotional Functioning: Q5	PedsQL_Emotional_Q5	70	Numeric	N	1
Paediatric Quality of Life Inventory - Social Functioning: Q1	PedsQL_Social_Q1	71	Numeric	N	1
Paediatric Quality of Life Inventory - Social Functioning: Q2	PedsQL_Social_Q2	72	Numeric	N	1
Paediatric Quality of Life Inventory - Social Functioning: Q3	PedsQL_Social_Q3	73	Numeric	N	1
Paediatric Quality of Life Inventory - Social Functioning: Q4	PedsQL_Social_Q4	74	Numeric	N	1
Paediatric Quality of Life Inventory - Social Functioning: Q5	PedsQL_Social_Q5	75	Numeric	N	1
Paediatric Quality of Life Inventory - School Functioning: Q1	PedsQL_School_Q1	76	Numeric	N	1
Paediatric Quality of Life Inventory - School Functioning: Q2	PedsQL_School_Q2	77	Numeric	N	1
Paediatric Quality of Life Inventory - School Functioning: Q3	PedsQL_School_Q3	78	Numeric	N	1
Paediatric Quality of Life Inventory - School Functioning: Q4	PedsQL_School_Q4	79	Numeric	N	1
Paediatric Quality of Life Inventory - School Functioning: Q5	PedsQL_School_Q5	80	Numeric	N	1
Work status: employed	Flag_WPAIEmployed	81
Work status: employment status	WPAIEmployedStatus	82
Work status: work hours missed	WPAINumberHoursMissed	83
Work status: number of hours worked	WPAINumberHoursWorked	84
Work status: lost productivity	WPAIProductivityLoss	85
Work status: reason for unemployment	WPAINotEmployedCause	86
Parent/Carer postcode	CarerPostCode	87
Parent/Carer sex	CarerSex	88
Parent/carer relationship to patient	CarerRelationship	89
Parent/carer relationship to patient: Other - description	CarerRelationshipOther	90
Parent/carer requires communication assistance	Flag_CarerRequiresHelpWithCom	91
Height	Height	92
Weight	Weight	93
Current school level	SchoolLevel	94
Current school level: Other - description	SchoolLevelOther	95
School days missed	SchoolDaysMissedFortnight	96
Health service use: general practitioner	CountHSUGP	97
Health service use: specialist	CountHSUSpecialist	98
Health service use: allied health	CountHSUAlliedHealth	99
Health service use: other therapists	CountHSUOtherTherapists	100
Health service use: emergency department	CountHSUED	101
Health service use: hospital admissions	CountHSUHospital	102
Health service use: diagnostic tests	CountHSUDiagnosticTests	103
Medication use: Paracetamol-only	MedicationParacetamolOnly	104
Medication use: Anti-inflammatory non-prescription	MedicationAntiInflamatoryCounter	105
Medication use: Anti-inflammatory prescription	MedicationAntiInflamatoryPrescription	106
Medication use: Opioid containing codeine	MedicationOpioidWithCodeine	107
Medication use: Opioid other than codeine	MedicationOpioidNotCodeine	108
Medication use: Nerve	MedicationNerve	109
Medication use: Alternative	MedicationAlternative	110
XXXX	Flag_ChildCompletedQuestionnaire	111
XXXX	NonCompletedReason	112
XXXX	NonCompletedReasonOther	113

Carer impact questionnaire data file

Data item	Item name	Location in extract	Data type	Format	Maximum length
ePPOC Patient ID	PatientID	1	String	XXXXXX[X(14)]	20
Facility Identifier	FacilityIdentifier	2	String	XXXX	4
Episode ID	EpisodeID	3
Episode Identifier	EpisodeIdentifier	4
PathwayID	PathwayID	5
PathwayIdentifier	PathwayIdentifier	6
Questionnaire schedule identifier	SurveyScheduleID	7
Questionnaire type	SurveyCategoryID	8
Ad-hoc questionnaire type	SurveyCategoryOtherID	9
Ad-hoc questionnaire type: Other - detail	SurveyDescription	10
XXXX	SurveyTypeID	11
XXXX	SurveyModeID	12
Generation date	GenerationDate	13
XXXX	CarerImpactSurveySentStatusID	14
Completion date	CarerImpactSurveyCompletionDate	15
XXXX	CarerImpactSurveyCompletedStatusID	16
Bath Parent Impact Questionnaire - Section 1: Q1	BAPPIQ_S1_Q1	17	Numeric	N	1
Bath Parent Impact Questionnaire - Section 1: Q2	BAPPIQ_S1_Q2	18	Numeric	N	1
Bath Parent Impact Questionnaire - Section 1: Q3	BAPPIQ_S1_Q3	19	Numeric	N	1
Bath Parent Impact Questionnaire - Section 1: Q4	BAPPIQ_S1_Q4	20	Numeric	N	1
Bath Parent Impact Questionnaire - Section 1: Q5	BAPPIQ_S1_Q5	21	Numeric	N	1
Bath Parent Impact Questionnaire - Section 1: Q6	BAPPIQ_S1_Q6	22	Numeric	N	1
Bath Parent Impact Questionnaire - Section 1: Q7	BAPPIQ_S1_Q7	23	Numeric	N	1
Bath Parent Impact Questionnaire - Section 1: Q8	BAPPIQ_S1_Q8	24	Numeric	N	1
Bath Parent Impact Questionnaire - Section 1: Q9	BAPPIQ_S1_Q9	25	Numeric	N	1
Bath Parent Impact Questionnaire - Section 2: Q1	BAPPIQ_S2_Q1	26	Numeric	N	1
Bath Parent Impact Questionnaire - Section 2: Q2	BAPPIQ_S2_Q2	27	Numeric	N	1
Bath Parent Impact Questionnaire - Section 2: Q3	BAPPIQ_S2_Q3	28	Numeric	N	1
Bath Parent Impact Questionnaire - Section 2: Q4	BAPPIQ_S2_Q4	29	Numeric	N	1
Bath Parent Impact Questionnaire - Section 2: Q5	BAPPIQ_S2_Q5	30	Numeric	N	1
Bath Parent Impact Questionnaire - Section 2: Q6	BAPPIQ_S2_Q6	31	Numeric	N	1
Bath Parent Impact Questionnaire - Section 3: Q1	BAPPIQ_S3_Q1	32	Numeric	N	1
Bath Parent Impact Questionnaire - Section 3: Q2	BAPPIQ_S3_Q2	33	Numeric	N	1
Bath Parent Impact Questionnaire - Section 3: Q3	BAPPIQ_S3_Q3	34	Numeric	N	1
Bath Parent Impact Questionnaire - Section 3: Q4	BAPPIQ_S3_Q4	35	Numeric	N	1
Bath Parent Impact Questionnaire - Section 3: Q5	BAPPIQ_S3_Q5	36	Numeric	N	1
Bath Parent Impact Questionnaire - Section 4: Q1	BAPPIQ_S4_Q1	37	Numeric	N	1
Bath Parent Impact Questionnaire - Section 4: Q2	BAPPIQ_S4_Q2	38	Numeric	N	1
Bath Parent Impact Questionnaire - Section 4: Q3	BAPPIQ_S4_Q3	39	Numeric	N	1
Bath Parent Impact Questionnaire - Section 4: Q4	BAPPIQ_S4_Q4	40	Numeric	N	1
Bath Parent Impact Questionnaire - Section 4: Q5	BAPPIQ_S4_Q5	41	Numeric	N	1
Bath Parent Impact Questionnaire - Section 4: Q6	BAPPIQ_S4_Q6	42	Numeric	N	1
Bath Parent Impact Questionnaire - Section 4: Q7	BAPPIQ_S4_Q7	43	Numeric	N	1
Bath Parent Impact Questionnaire - Has No Partner	Flag_HasNoPartner	44	Boolean	N	1
Bath Parent Impact Questionnaire - Section 5: Q1	BAPPIQ_S5_Q1	45	Numeric	N	1
Bath Parent Impact Questionnaire - Section 5: Q2	BAPPIQ_S5_Q2	46	Numeric	N	1
Bath Parent Impact Questionnaire - Section 5: Q3	BAPPIQ_S5_Q3	47	Numeric	N	1
Bath Parent Impact Questionnaire - Section 5: Q4	BAPPIQ_S5_Q4	48	Numeric	N	1
Bath Parent Impact Questionnaire - Section 5: Q5	BAPPIQ_S5_Q5	49	Numeric	N	1
Bath Parent Impact Questionnaire - Section 5: Q6	BAPPIQ_S5_Q6	50	Numeric	N	1
Bath Parent Impact Questionnaire - Section 5: Q7	BAPPIQ_S5_Q7	51	Numeric	N	1
Bath Parent Impact Questionnaire - Section 6: Q1	BAPPIQ_S6_Q1	52	Numeric	N	1
Bath Parent Impact Questionnaire - Section 6: Q2	BAPPIQ_S6_Q2	53	Numeric	N	1
Bath Parent Impact Questionnaire - Section 6: Q3	BAPPIQ_S6_Q3	54	Numeric	N	1
Bath Parent Impact Questionnaire - Section 6: Q4	BAPPIQ_S6_Q4	55	Numeric	N	1
Bath Parent Impact Questionnaire - Section 6: Q5	BAPPIQ_S6_Q5	56	Numeric	N	1
Bath Parent Impact Questionnaire - Section 6: Q6	BAPPIQ_S6_Q6	57	Numeric	N	1
Bath Parent Impact Questionnaire - Section 6: Q7	BAPPIQ_S6_Q7	58	Numeric	N	1
Bath Parent Impact Questionnaire - Section 6: Q8	BAPPIQ_S6_Q8	59	Numeric	N	1
Bath Parent Impact Questionnaire - Section 7: Q1	BAPPIQ_S7_Q1	60	Numeric	N	1
Bath Parent Impact Questionnaire - Section 7: Q2	BAPPIQ_S7_Q2	61	Numeric	N	1
Bath Parent Impact Questionnaire - Section 7: Q3	BAPPIQ_S7_Q3	62	Numeric	N	1
Bath Parent Impact Questionnaire - Section 7: Q4	BAPPIQ_S7_Q4	63	Numeric	N	1
Bath Parent Impact Questionnaire - Section 7: Q5	BAPPIQ_S7_Q5	64	Numeric	N	1
Bath Parent Impact Questionnaire - Section 7: Q6	BAPPIQ_S7_Q6	65	Numeric	N	1
Bath Parent Impact Questionnaire - Section 7: Q7	BAPPIQ_S7_Q7	66	Numeric	N	1
Bath Parent Impact Questionnaire - Section 7: Q8	BAPPIQ_S7_Q8	67	Numeric	N	1
Bath Parent Impact Questionnaire - Section 7: Q9	BAPPIQ_S7_Q9	68	Numeric	N	1
Bath Parent Impact Questionnaire - Section 7: Q10	BAPPIQ_S7_Q10	69	Numeric	N	1
Bath Parent Impact Questionnaire - Section 7: Q11	BAPPIQ_S7_Q11	70	Numeric	N	1
Bath Parent Impact Questionnaire - Section 8: Q1	BAPPIQ_S8_Q1	71	Numeric	N	1
Bath Parent Impact Questionnaire - Section 8: Q2	BAPPIQ_S8_Q2	72	Numeric	N	1
Bath Parent Impact Questionnaire - Section 8: Q3	BAPPIQ_S8_Q3	73	Numeric	N	1
Bath Parent Impact Questionnaire - Section 8: Q4	BAPPIQ_S8_Q4	74	Numeric	N	1
Bath Parent Impact Questionnaire - Section 8: Q5	BAPPIQ_S8_Q5	75	Numeric	N	1
Bath Parent Impact Questionnaire - Section 8: Q6	BAPPIQ_S8_Q6	76	Numeric	N	1
Bath Parent Impact Questionnaire - Section 8: Q7	BAPPIQ_S8_Q7	77	Numeric	N	1
Bath Parent Impact Questionnaire - Section 8: Q8	BAPPIQ_S8_Q8	78	Numeric	N	1
Bath Parent Impact Questionnaire - Section 8: Q9	BAPPIQ_S8_Q9	79	Numeric	N	1

Data file format - paediatric

Episode data file

Pathway data file

Service event data file

Patient questionnaire data file

Carer questionnaire data file

Carer impact questionnaire data file