Patient data file

For services located in Australia:

Data item	Item name	Location in extract	Data type	Format	Maximum length

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

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
New Zealand Province	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

Metropolis - the home of ePPOC metadata

Data file format - paediatric

Patient data file

Episode data file