Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table filter
fixedCols
totalrow,,,,,
hidelabelsfalse
ddSeparator
sparkNameSparkline
hidePaneFiltration panel
limitHeight
sparklinefalse
macroMarker1669610692335_993
ddSeparatorstrue
isFirstTimeEntertrue
default
hideColumnsfalse
cell-width250
totalRowName
totalColName
disabledfalse
globalFilterfalse
formatVersion2
iconfilter
order0
hideControlsfalse
numbering
inversefalse
datefilter
column
totalcol
sort
disableSavefalse
rowsPerPage
separatorPoint (.)
labelsData item
thousandSeparator
ignoreFirstNrows
ddOperator
userfilterData item
numberfilter
datepatterndd M yy
heightValue
updateSelectOptionsfalse
worklog365|5|8|y w d h m|y w d h m
isORAND
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

1

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

1

Country of birth other - description

CountryOfBirthOther

9

String

X[28]

X[28]

Urgency category

Urgency

10

Numeric

N

1

Need for interpreter

Flag_RequireInterpreter

11

Boolean

N

1

Interpreter language

InterpreterLanguage

12

String

X[32]

32

Need for assistance with communication

Flag_CommunicationAssist

13

Boolean

N

1

Is the patient hearing or sight impaired

Flag_HearingSightImpaired

14

Boolean

N

1

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,,,,,
hidelabelsfalse
ddSeparator
sparkNameSparkline
hidePaneFiltration panel
limitHeight
sparklinefalse
macroMarker1669610821068_855
ddSeparatorstrue
isFirstTimeEntertrue
default
hideColumnsfalse
cell-width250
totalRowName
totalColName
disabledfalse
globalFilterfalse
formatVersion2
iconfilter
order0
hideControlsfalse
numbering
inversefalse
datefilter
column
totalcol
sort
disableSavefalse
rowsPerPage
separatorPoint (.)
labelsData item
thousandSeparator
ignoreFirstNrows
ddOperator
userfilterData item
numberfilter
datepatterndd M yy
heightValue
updateSelectOptionsfalse
worklog365|5|8|y w d h m|y w d h m
isORAND
showNRowsifNotFiltered

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

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

Comorbidity: heart and circulation problems

Flag_CMHeartCirculation

17

Boolean

N

1

Comorbidity: high blood pressure

Flag_CMBloodPressure

18

Boolean

N

1

Comorbidity: high cholesterol

Flag_CMCholesterol

19

Boolean

N

1

Comorbidity: respiratory

Flag_CMRespiratory

20

Boolean

N

1

Comorbidity: diabetes

Flag_CMDiabetes

21

Boolean

N

1

Comorbidity: digestive

Flag_CMDigestive

22

Boolean

N

1

Comorbidity: liver, kidney and pancreas problems

Flag_CMLiverKidneyPancreas

23

Boolean

N

1

Comorbidity: mental health

Flag_CMMentalHealth

24

Boolean

N

1

Comorbidity: PTSD

Flag_CMPTSD

25

Boolean

N

1

Comorbidity: anxiety

Flag_CMAnxiety

26

Boolean

N

1

Comorbidity: depression

Flag_CMDepression

27

Boolean

N

1

Comorbidity: other mental health

ComorbiditiesMentalHealthOther

28

String

X[255]

255

Comorbidity: cancer 

Flag_CMCancer

29

Boolean

N

1

Comorbidity: arthritis

Flag_CMArthritis

30

Boolean

N

1

Comorbidity: muscle, bone and joint problems

Flag_CMMuscle

31

Boolean

N

1

Comorbidity: neurological problems

Flag_CMNeurological

32

Boolean

N

1

Comorbidity: thyroid 

Flag_CMThyroid

33

Boolean

N

1

Comorbidity: other

Flag_CMOther

34

Boolean

N

1

Comorbidity: other - detail

ComorbiditiesOther

35

String

X[255]

255

Department of Veteran's Affairs client

Flag_DVAClient

36

Boolean

N

1

Australian defence force service

Flag_DVAPreviouslyServing

37

Boolean

N

1

Compensation case

Flag_CompensationCase

38

Boolean

N

1

Compensation case type

CompensationCaseType

39

Numeric

N

1

Compensation case type: Other - detail

CompensationOtherDetail

40

String

X[64]

64

...