Patient data file
...
Data item | Item name | Location in extract | Data type | Format | Maximum length |
PatientID | 1 | String | XXXXXX[X(14)] | 20 | |
FacilityIdentifier | 2 | String | XXXX | 4 | |
EpisodeID | 3 | ||||
EpisodeIdentifier | 4 | ||||
ReferralDate | 5 | Date | DD/MM/YYYY | 10 | |
ReferralSource | 6 | Numeric | NN | 2 | |
ReferralSourceOther | 7 | String | X[64] | 64 | |
CancerPain | 8 | Boolean | N | 1 | |
EpisodeStartDate | 9 | Date | DD/MM/YYYY | 10 | |
EpisodeStartMode | 10 | Numeric | N | 1 | |
EpisodeStartDate | 911 | Date | DD/MM/YYYY | 10 | |
EpisodeStartMode | 1012 | Numeric | N | 1 | |
PainSource | 1113 | Numeric | N[N] | 2 | |
PainSourceOtherDetail | 1214 | String | X[255] | 255 | |
PainDuration | 1315 | Numeric | N | 1 | |
EpisodeEndDate | 1416 | Date | DD/MM/YYYY | 10 | |
EpisodeEndMode | 1517 | Numeric | N | 1 | |
EpisodeEndModeOther | 1618 | String | X[255] | 255 | |
Flag_PedHealthProblemChronicDisease | 1719 | Boolean | N | 1 | |
Flag_PedHealthProblemMental | 1820 | Boolean | N | 1 | |
Flag_PedHealthProblemCancer | 1921 | Boolean | N | 1 | |
Flag_PedDisabilitySight | 2022 | Boolean | N | 1 | |
Flag_PedDisabilityHearing | 2123 | Boolean | N | 1 | |
Flag_PedDisabilityIntellectual | 2224 | Boolean | N | 1 | |
Flag_PedDisabilityPhysical | 2325 | Boolean | N | 1 | |
PedHealthConditionsAndDisabilityOther | 2426 | String | X[255] | 255 | |
Flag_PreviouslyAttended | 2527 | Boolean | N | 1 | |
Flag_NZ_FundedACC | 2628 | Boolean | N | 1 |
Pathway data file
...
Data item | Item name | Location in extract | Data type | Format | Maximum length |
---|---|---|---|---|---|
PatientID | 1 | String | XXXXXX[X(14)] | 20 | |
FacilityIdentifier | 2 | String | XXXX | 4 | |
EpisodeID | 3 | ||||
EpisodeIdentifier | 4 | ||||
PathwayID | 5 | ||||
PathwayIdentifier | 6 | ||||
SurveyScheduleID | 7 | ||||
SurveyCategoryID | 8 | ||||
SurveyCategoryOtherID | 9 | ||||
SurveyDescription | 10 | ||||
XXXX | SurveyTypeID | 11 | |||
XXXX | SurveyModeID | 12 | |||
GenerationDate | 13 | ||||
XXXX | CarerImpactSurveySentStatusID | 14 | |||
Completion date | CarerImpactSurveyCompletionDate | 15 | |||
XXXX | CarerImpactSurveyCompletedStatusID | 16 | |||
BAPPIQ_S1_Q1 | 17 | Numeric | N[N] | 2 | |
BAPPIQ_S1_Q2 | 18 | Numeric | N[N] | 2 | |
BAPPIQ_S1_Q3 | 19 | Numeric | N[N] | 2 | |
BAPPIQ_S1_Q4 | 20 | Numeric | N[N] | 2 | |
BAPPIQ_S1_Q5 | 21 | Numeric | N[N] | 2 | |
BAPPIQ_S1_Q6 | 22 | Numeric | N[N] | 2 | |
BAPPIQ_S1_Q7 | 23 | Numeric | N[N] | 2 | |
BAPPIQ_S1_Q8 | 24 | Numeric | N[N] | 2 | |
BAPPIQ_S1_Q9 | 25 | Numeric | N[N] | 2 | |
BAPPIQ_S2_Q1 | 26 | Numeric | N[N] | 2 | |
BAPPIQ_S2_Q2 | 27 | Numeric | N[N] | 2 | |
BAPPIQ_S2_Q3 | 28 | Numeric | N[N] | 2 | |
BAPPIQ_S2_Q4 | 29 | Numeric | N[N] | 2 | |
BAPPIQ_S2_Q5 | 30 | Numeric | N[N] | 2 | |
BAPPIQ_S2_Q6 | 31 | Numeric | N[N] | 2 | |
BAPPIQ_S3_Q1 | 32 | Numeric | N[N] | 2 | |
BAPPIQ_S3_Q2 | 33 | Numeric | N[N] | 2 | |
BAPPIQ_S3_Q3 | 34 | Numeric | N[N] | 2 | |
BAPPIQ_S3_Q4 | 35 | Numeric | N[N] | 2 | |
BAPPIQ_S3_Q5 | 36 | Numeric | N[N] | 2 | |
BAPPIQ_S4_Q1 | 37 | Numeric | N[N] | 2 | |
BAPPIQ_S4_Q2 | 38 | Numeric | N[N] | 2 | |
BAPPIQ_S4_Q3 | 39 | Numeric | N[N] | 2 | |
BAPPIQ_S4_Q4 | 40 | Numeric | N[N] | 2 | |
BAPPIQ_S4_Q5 | 41 | Numeric | N[N] | 2 | |
BAPPIQ_S4_Q6 | 42 | Numeric | N[N] | 2 | |
BAPPIQ_S4_Q7 | 43 | Numeric | N[N] | 2 | |
Flag_HasNoPartner | 44 | Boolean | N[N] | 2 | |
BAPPIQ_S5_Q1 | 45 | Numeric | N[N] | 2 | |
BAPPIQ_S5_Q2 | 46 | Numeric | N[N] | 2 | |
BAPPIQ_S5_Q3 | 47 | Numeric | N[N] | 2 | |
BAPPIQ_S5_Q4 | 48 | Numeric | N[N] | 2 | |
BAPPIQ_S5_Q5 | 49 | Numeric | N[N] | 2 | |
BAPPIQ_S5_Q6 | 50 | Numeric | N[N] | 2 | |
BAPPIQ_S5_Q7 | 51 | Numeric | N[N] | 2 | |
BAPPIQ_S6_Q1 | 52 | Numeric | N[N] | 2 | |
BAPPIQ_S6_Q2 | 53 | Numeric | N[N] | 2 | |
BAPPIQ_S6_Q3 | 54 | Numeric | N[N] | 2 | |
BAPPIQ_S6_Q4 | 55 | Numeric | N[N] | 2 | |
BAPPIQ_S6_Q5 | 56 | Numeric | N[N] | 2 | |
BAPPIQ_S6_Q6 | 57 | Numeric | N[N] | 2 | |
BAPPIQ_S6_Q7 | 58 | Numeric | N[N] | 2 | |
BAPPIQ_S6_Q8 | 59 | Numeric | N[N] | 2 | |
BAPPIQ_S7_Q1 | 60 | Numeric | N[N] | 2 | |
BAPPIQ_S7_Q2 | 61 | Numeric | N[N] | 2 | |
BAPPIQ_S7_Q3 | 62 | Numeric | N[N] | 2 | |
BAPPIQ_S7_Q4 | 63 | Numeric | N[N] | 2 | |
BAPPIQ_S7_Q5 | 64 | Numeric | N[N] | 2 | |
BAPPIQ_S7_Q6 | 65 | Numeric | N[N] | 2 | |
BAPPIQ_S7_Q7 | 66 | Numeric | N[N] | 2 | |
BAPPIQ_S7_Q8 | 67 | Numeric | N[N] | 2 | |
BAPPIQ_S7_Q9 | 68 | Numeric | N[N] | 2 | |
BAPPIQ_S7_Q10 | 69 | Numeric | N[N] | 2 | |
BAPPIQ_S7_Q11 | 70 | Numeric | N[N] | 2 | |
BAPPIQ_S8_Q1 | 71 | Numeric | N[N] | 2 | |
BAPPIQ_S8_Q2 | 72 | Numeric | N[N] | 2 | |
BAPPIQ_S8_Q3 | 73 | Numeric | N[N] | 2 | |
BAPPIQ_S8_Q4 | 74 | Numeric | N[N] | 2 | |
BAPPIQ_S8_Q5 | 75 | Numeric | N[N] | 2 | |
BAPPIQ_S8_Q6 | 76 | Numeric | N[N] | 2 | |
BAPPIQ_S8_Q7 | 77 | Numeric | N[N] | 2 | |
BAPPIQ_S8_Q8 | 78 | Numeric | N[N] | 2 | |
BAPPIQ_S8_Q9 | 79 | Numeric | N[N] | 2 |
...