Page Comparison

...

Table filter

fixedCols
totalrow	,,,,,
hidelabels	false
ddSeparator
sparkName	Sparkline
hidePane	Filtration panel
limitHeight
sparkline	false
macroMarker	1669610692335_993
ddSeparators	true
isFirstTimeEnter	true
default
hideColumns	false
cell-width	250
totalRowName
totalColName
disabled	false
globalFilter	false
formatVersion	2
iconfilter
order	0
hideControls	false
numbering
inverse	false
datefilter
column
totalcol
sort
disableSave	false
rowsPerPage
separator	Point (.)
labels	Data item
thousandSeparator
ignoreFirstNrows
ddOperator
userfilter	Data item
numberfilter
datepattern	dd M yy
heightValue
updateSelectOptions	false
worklog	365\|5\|8\|y w d h m\|y w d h m
isOR	AND
showNRowsifNotFiltered

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[N]	12
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[N]	12
Country of birth: Other - detail	CountryOfBirthOther	9	String	X[28]	28
Urgency category	Urgency	10	Numeric	N[N]	12
Need for interpreter	Flag_RequireInterpreter	11	Boolean	N[N]	12
Interpreter language	InterpreterLanguage	12	String	X[32]	32
Need for assistance with communication	Flag_CommunicationAssist	13	Boolean	N[N]	12
Is the patient hearing or sight impaired	Flag_HearingSightImpaired	14	Boolean	N[N]	12
Indigenous status	IndigenousStatus	15	Numeric	N[N]	12

For services located in New Zealand:

Table filter

fixedCols
totalrow	,,,,,
hidelabels	false
ddSeparator
sparkName	Sparkline
hidePane	Filtration panel
limitHeight
sparkline	false
macroMarker	1669610692335_993
ddSeparators	true
isFirstTimeEnter	true
default
hideColumns	false
cell-width	250
totalRowName
totalColName
disabled	false
globalFilter	false
formatVersion	2
iconfilter
order	0
hideControls	false
numbering
inverse	false
datefilter
column
totalcol
sort
disableSave	false
rowsPerPage
separator	Point (.)
labels	Data item
thousandSeparator
ignoreFirstNrows
ddOperator
userfilter	Data item
numberfilter
datepattern	dd M yy
heightValue
updateSelectOptions	false
worklog	365\|5\|8\|y w d h m\|y w d h m
isOR	AND
showNRowsifNotFiltered

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[N]	12
Patient Statistical linkage key	StatisticalLinkageKey	5	String	XXXXXDDMMYYYYN	14
Patient New Zealand Province	StateOrProvince	6	Numeric	NN	2
Postcode	Postcode	7	Numeric	NNNN	4
Country of birth	CountryOfBirth	8	Numeric	N[N]	12
Country of birth other - description	CountryOfBirthOther	9	String	X[28]	X[28]
Urgency category	Urgency	10	Numeric	N[N]	12
Need for interpreter	Flag_RequireInterpreter	11	Boolean	N[N]	12
Interpreter language	InterpreterLanguage	12	String	X[32]	32
Need for assistance with communication	Flag_CommunicationAssist	13	Boolean	N[N]	12
Is the patient hearing or sight impaired	Flag_HearingSightImpaired	14	Boolean	N[N]	12
Patient ethnicity: New Zealand European	Flag_NZ_EthnicityEuropean	15	Boolean	N	1
Patient ethnicity: Samoan	Flag_NZ_EthnicitySamoan	16	Boolean	N	1
Patient ethnicity: Tongan	Flag_NZ_EthnicityTongan	17	Boolean	N	1
Patient ethnicity: Chinese	Flag_NZ_EthnicityChinese	18	Boolean	N	1
Patient ethnicity: Maori	Flag_NZ_EthnicityMaori	19	Boolean	N	1
Patient ethnicity: Cook Islands Maori	Flag_NZ_EthnicityCookIslands	20	Boolean	N	1
Patient ethnicity: Niuean	Flag_NZ_EthnicityNiuean	21	Boolean	N	1
Patient ethnicity: Indian	Flag_NZ_EthnicityIndian	22	Boolean	N	1
Patient ethnicity: Not stated	Flag_NZ_EthnicityNotStated	23	Boolean	N	1
Patient ethnicity: Other	Flag_NZ_EthnicityOther	24	Boolean	N	1
Patient ethnicity: Other - detail	NZ_EthnicityOther	25	String	X[64]	64

...

Table filter

fixedCols
totalrow	,,,,,
hidelabels	false
ddSeparator
sparkName	Sparkline
hidePane	Filtration panel
limitHeight
sparkline	false
macroMarker	1669611260566_757
ddSeparators	true
isFirstTimeEnter	true
default
hideColumns	false
cell-width	250
totalRowName
totalColName
disabled	false
globalFilter	false
formatVersion	2
iconfilter
order	0
hideControls	false
numbering
inverse	false
datefilter
column
totalcol
sort
disableSave	false
rowsPerPage
separator	Point (.)
labels	Data item
thousandSeparator
ignoreFirstNrows
ddOperator
userfilter	Data item
numberfilter
datepattern	dd M yy
heightValue
updateSelectOptions	false
worklog	365\|5\|8\|y w d h m\|y w d h m
isOR	AND
showNRowsifNotFiltered

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 identifier	PatientSurveyKey	8
Completion date	Derived_CompletionDate	9	Date	DD/MM/YYYY	10
Generation date	GenerationDate	10	Date	DD/MM/YYYY	10
Sent status	Derived_SentStatusID	11	Numeric	N	1
Completion status	Derived_CompletedStatusID	12	Numeric	N	1
Questionnaire type	SurveyCategoryID	13	Numeric	N	1
Ad-hoc questionnaire type	SurveyCategoryOtherID	14	Numeric	N[N]	2
Ad-hoc questionnaire type: Other - detail	SurveyDescription	15	String	X[100]	100
Survey mode	SurveyModeID	16	Numeric	N	1
Height	Height	17	Numeric	NN[N]	3
Weight	Weight	18	Numeric	NN[N]	3
Pain description	PainDescription	19	Numeric	N[N]	2
Health service use: general practitioner	CountHSUGP	20	Numeric	N[N]	2
Health service use: medical specialist	CountHSUSpecialist	21	Numeric	N[N]	2
Health service use: allied health	CountHSUAlliedHealth	22	Numeric	N[N]	2
Health service use: emergency department	CountHSUED	23	Numeric	N[N]	2
Health service use: hospital admissions	CountHSUHospital	24	Numeric	N[N]	2
Health service use: diagnostic tests	CountHSUDiagnosticTests	25	Numeric	N[N]	2
Site of main pain	PainSiteMain	26	Numeric	N[N]	2
Pain site: Head	Flag_PainSiteOther_Head	27	Boolean	N	1
Pain site: Face	Flag_PainSiteOther_Face	28	Boolean	N	1
Pain site: Neck	Flag_PainSiteOther_Neck	29	Boolean	N	1
Pain site: Chest	Flag_PainSiteOther_Chest	30	Boolean	N	1
Pain site: Abdomen	Flag_PainSiteOther_Abdomen	31	Boolean	N	1
Pain site: Groin	Flag_PainSiteOther_Groin	32	Boolean	N	1
Pain site: Upper back	Flag_PainSiteOther_UpperBack	33	Boolean	N	1
Pain site: Mid back	Flag_PainSiteOther_MidBack	34	Boolean	N	1
Pain site: Lower back	Flag_PainSiteOther_LowBack	35	Boolean	N	1
Pain site: Shoulder (left)	Flag_PainSiteOther_ShoulderLeft	36	Boolean	N	1
Pain site: Shoulder (right)	Flag_PainSiteOther_ShoulderRight	37	Boolean	N	1
Pain site: Upper arm (left)	Flag_PainSiteOther_UpperArmLeft	38	Boolean	N	1
Pain site: Upper arm (right)	Flag_PainSiteOther_UpperArmRight	39	Boolean	N	1
Pain site: Elbow (left)	Flag_PainSiteOther_ElbowLeft	40	Boolean	N	1
Pain site: Elbow (right)	Flag_PainSiteOther_ElbowRight	41	Boolean	N	1
Pain site: Forearm (left)	Flag_PainSiteOther_ForearmLeft	42	Boolean	N	1
Pain site: Forearm (right)	Flag_PainSiteOther_ForearmRight	43	Boolean	N	1
Pain site: Wrist (left)	Flag_PainSiteOther_WristLeft	44	Boolean	N	1
Pain site: Wrist (right)	Flag_PainSiteOther_WristRight	45	Boolean	N	1
Pain site: Hand (left)	Flag_PainSiteOther_HandLeft	46	Boolean	N	1
Pain site: Hand (right)	Flag_PainSiteOther_HandRight	47	Boolean	N	1
Pain site: Hip (left)	Flag_PainSiteOther_HipLeft	48	Boolean	N	1
Pain site: Hip (right)	Flag_PainSiteOther_HipRight	49	Boolean	N	1
Pain site: Thigh (left)	Flag_PainSiteOther_ThighLeft	50	Boolean	N	1
Pain site: Thigh (right)	Flag_PainSiteOther_ThighRight	51	Boolean	N	1
Pain site: Knee (left)	Flag_PainSiteOther_KneeLeft	52	Boolean	N	1
Pain site: Knee (right)	Flag_PainSiteOther_KneeRight	53	Boolean	N	1
Pain site: Calf (left)	Flag_PainSiteOther_CalfLeft	54	Boolean	N	1
Pain site: Calf (right)	Flag_PainSiteOther_CalfRight	55	Boolean	N	1
Pain site: Ankle (left)	Flag_PainSiteOther_AnkleLeft	56	Boolean	N	1
Pain site: Ankle (right)	Flag_PainSiteOther_AnkleRight	57	Boolean	N	1
Pain site: Foot (left)	Flag_PainSiteOther_FootLeft	58	Boolean	N	1
Pain site: Foot (right)	Flag_PainSiteOther_FootRight	59	Boolean	N	1
Brief Pain Inventory: Worst pain	BPIWorst	60	Numeric	N[N]	2
Brief Pain Inventory: Least pain	BPILeast	61	Numeric	N[N]	2
Brief Pain Inventory: Average pain	BPIAverage	62	Numeric	N[N]	2
Brief Pain Inventory: Pain now	BPINow	63	Numeric	N[N]	2
Brief Pain Inventory: General activity	BPIActivity	64	Numeric	N[N]	2
Brief Pain Inventory: Mood	BPIMood	65	Numeric	N[N]	2
Brief Pain Inventory: Walking	BPIWalking	66	Numeric	N[N]	2
Brief Pain Inventory: Work	BPIWork	67	Numeric	N[N]	2
Brief Pain Inventory: Relations	BPIRelations	68	Numeric	N[N]	2
Brief Pain Inventory: Sleep	BPISleep	69	Numeric	N[N]	2
Brief Pain Inventory: Enjoyment	BPIEnjoyment	70	Numeric	N[N]	2
Depression Anxiety Stress Scale Q1	DASSQ1	71	Numeric	N	1
Depression Anxiety Stress Scale Q2	DASSQ2	72	Numeric	N	1
Depression Anxiety Stress Scale Q3	DASSQ3	73	Numeric	N	1
Depression Anxiety Stress Scale Q4	DASSQ4	74	Numeric	N	1
Depression Anxiety Stress Scale Q5	DASSQ5	75	Numeric	N	1
Depression Anxiety Stress Scale Q6	DASSQ6	76	Numeric	N	1
Depression Anxiety Stress Scale Q7	DASSQ7	77	Numeric	N	1
Depression Anxiety Stress Scale Q8	DASSQ8	78	Numeric	N	1
Depression Anxiety Stress Scale Q9	DASSQ9	79	Numeric	N	1
Depression Anxiety Stress Scale Q10	DASSQ10	80	Numeric	N	1
Depression Anxiety Stress Scale Q11	DASSQ11	81	Numeric	N	1
Depression Anxiety Stress Scale Q12	DASSQ12	82	Numeric	N	1
Depression Anxiety Stress Scale Q13	DASSQ13	83	Numeric	N	1
Depression Anxiety Stress Scale Q14	DASSQ14	84	Numeric	N	1
Depression Anxiety Stress Scale Q15	DASSQ15	85	Numeric	N	1
Depression Anxiety Stress Scale Q16	DASSQ16	86	Numeric	N	1
Depression Anxiety Stress Scale Q17	DASSQ17	87	Numeric	N	1
Depression Anxiety Stress Scale Q18	DASSQ18	88	Numeric	N	1
Depression Anxiety Stress Scale Q19	DASSQ19	89	Numeric	N	1
Depression Anxiety Stress Scale Q20	DASSQ20	90	Numeric	N	1
Depression Anxiety Stress Scale Q21	DASSQ21	91	Numeric	N	1
Pain Self-Efficacy Questionnaire Q1	PSEQQ1	92	Numeric	N	1
Pain Self-Efficacy Questionnaire Q2	PSEQQ2	93	Numeric	N	1
Pain Self-Efficacy Questionnaire Q3	PSEQQ3	94	Numeric	N	1
Pain Self-Efficacy Questionnaire Q4	PSEQQ4	95	Numeric	N	1
Pain Self-Efficacy Questionnaire Q5	PSEQQ5	96	Numeric	N	1
Pain Self-Efficacy Questionnaire Q6	PSEQQ6	97	Numeric	N	1
Pain Self-Efficacy Questionnaire Q7	PSEQQ7	98	Numeric	N	1
Pain Self-Efficacy Questionnaire Q8	PSEQQ8	99	Numeric	N	1
Pain Self-Efficacy Questionnaire Q9	PSEQQ9	100	Numeric	N	1
Pain Self-Efficacy Questionnaire Q10	PSEQQ10	101	Numeric	N	1
Pain Catastrophising Scale Q1	PCSQ1	102	Numeric	N	1
Pain Catastrophising Scale Q2	PCSQ2	103	Numeric	N	1
Pain Catastrophising Scale Q3	PCSQ3	104	Numeric	N	1
Pain Catastrophising Scale Q4	PCSQ4	105	Numeric	N	1
Pain Catastrophising Scale Q5	PCSQ5	106	Numeric	N	1
Pain Catastrophising Scale Q6	PCSQ6	107	Numeric	N	1
Pain Catastrophising Scale Q7	PCSQ7	108	Numeric	N	1
Pain Catastrophising Scale Q8	PCSQ8	109	Numeric	N	1
Pain Catastrophising Scale Q9	PCSQ9	110	Numeric	N	1
Pain Catastrophising Scale Q10	PCSQ10	111	Numeric	N	1
Pain Catastrophising Scale Q11	PCSQ11	112	Numeric	N	1
Pain Catastrophising Scale Q12	PCSQ12	113	Numeric	N	1
Pain Catastrophising Scale Q13	PCSQ13	114	Numeric	N	1
Opioid replacement program	Flag_OpioidMaint	115	Boolean	N	1
Oral Morphine Equivalent Daily Dose (oMEDD)	DailyMorphine	116	Number	TBD	TBD
Opioid frequency	Flag_OpioidFreq	117	Boolean	N	1
Medication inaccuracies	Flag_MedicationInaccuracy	118	Boolean	N	1
Work status: employed	Flag_WPAIEmployed	119	Boolean	N	1
Employment status	WPAIEmployedStatus	120	Numeric	N	1
Work hours missed	WPAINumberHoursMissed	121	Numeric	N[N]	2
Number of hours worked	WPAINumberHoursWorked	122	Numeric	N[N]	2
Lost productivity	WPAIProductivityLoss	123	Numeric	N[N]	2
Reason for unemployment	WPAINotEmployedCause	124	Numeric	N	1
ePPOC Patient Impression of Change - overall	GRCOverallImprovement	125	Numeric	N[N]	2
ePPOC Patient Impression of Change - physical	GRCPhysicalImprovement	126	Numeric	N[N]	2
Medication use	Flag_MedicationConsumed	127	Boolean	N	1
Medications reported	Flag_MedicationReported	128	Boolean	N	1
Medication: opioid	Flag_DrugGroupOpioid	129	Boolean	N	1
Medication: paracetamol	Flag_DrugGroupParacetamol	130	Boolean	N	1
Medication: NSAID	Flag_DrugGroupNSAID	131	Boolean	N	1
Medication: antidepressant	Flag_DrugGroupAntidepressant	132	Boolean	N	1
Medication: anticonvulsant	Flag_DrugGroupAnticonvulsant	133	Boolean	N	1
Medication: sedative	Flag_DrugGroupSedative	134	Boolean	N	1
Medication: medicinal cannabinoids	Flag_DrugGroupMedicalCannabis	135	Boolean	N	1
Site of main pain: none	Flag_PainSiteMainNone	136	Boolean	N	1
Pain site: none	Flag_PainSiteOtherNone	137	Boolean	N	1

...

Versions Compared

Old Version 113

New Version Current

Key