Patient data file
For services located in Australia:
Data item | Item name | Location in extract | Data type | Format | Maximum length |
|---|---|---|---|---|---|
PatientID | 1 | String | XXXXXX[X(14)] | 14 | |
FacilityIdentifier | 2 | String | XXXX | 4 | |
DateOfBirth | 3 | Date | DD/MM/YYYY | 10 | |
Sex | 4 | Numeric | N | 1 | |
StatisticalLinkageKey | 5 | String | XXXXXDDMMYYYYN | 14 | |
StateOrProvince | 6 | Numeric | N[N] | 2 | |
Postcode | 7 | String | NNNN | 4 | |
CountryOfBirth | 8 | Numeric | N | 1 | |
CountryOfBirthOther | 9 | String | X[28] | 28 | |
Urgency | 10 | Numeric | N | 1 | |
Flag_PedIntellectualDisability | 11 | Boolean | N | 1 | |
IndigenousStatus | 12 | Numeric | N | 1 |
For services located in New Zealand:
Data item | Item name | Location in extract | Data type | Format | Maximum length |
|---|---|---|---|---|---|
PatientID | 1 | String | XXXXXX[X(14)] | 14 | |
FacilityIdentifier | 2 | String | XXXX | 4 | |
DateOfBirth | 3 | Date | DD/MM/YYYY | 10 | |
Sex | 4 | Numeric | N | 1 | |
StatisticalLinkageKey | 5 | String | XXXXXDDMMYYYYN | 14 | |
StateOrProvince | 6 | Numeric | N[N] | 2 | |
Postcode | 7 | String | NNNN | 4 | |
CountryOfBirth | 8 | Numeric | N | 1 | |
CountryOfBirthOther | 9 | String | X[28] | 28 | |
Urgency | 10 | Numeric | N | 1 | |
Flag_PedIntellectualDisability | 11 | Boolean | N | 1 | |
Flag_NZ_EthnicityEuropean | 12 | Boolean | N | 1 | |
Flag_NZ_EthnicitySamoan | 13 | Boolean | N | 1 | |
Flag_NZ_EthnicityTongan | 14 | Boolean | N | 1 | |
Flag_NZ_EthnicityChinese | 15 | Boolean | N | 1 | |
Flag_NZ_EthnicityMaori | 16 | Boolean | N | 1 | |
Flag_NZ_EthnicityCookIslands | 17 | Boolean | N | 1 | |
Flag_NZ_EthnicityNiuean | 18 | Boolean | N | 1 | |
Flag_NZ_EthnicityIndian | 19 | Boolean | N | 1 | |
Flag_NZ_EthnicityNotStated | 20 | Boolean | N | 1 | |
Flag_NZ_EthnicityOther | 21 | Boolean | N | 1 | |
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 |
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 | |
PainSource | 11 | Numeric | N[N] | 2 | |
PainSourceOtherDetail | 12 | String | X[255] | 255 | |
PainDuration | 13 | Numeric | N | 1 | |
EpisodeEndDate | 14 | Date | DD/MM/YYYY | 10 | |
EpisodeEndMode | 15 | Numeric | N | 1 | |
EpisodeEndModeOther | 16 | String | X[255] | 255 | |
Flag_PedHealthProblemChronicDisease | 17 | Boolean | N | 1 | |
Flag_PedHealthProblemMental | 18 | Boolean | N | 1 | |
Flag_PedHealthProblemCancer | 19 | Boolean | N | 1 | |
Flag_PedDisabilitySight | 20 | Boolean | N | 1 | |
Flag_PedDisabilityHearing | 21 | Boolean | N | 1 | |
Flag_PedDisabilityIntellectual | 22 | Boolean | N | 1 | |
Flag_PedDisabilityPhysical | 23 | Boolean | N | 1 | |
PedHealthConditionsAndDisabilityOther | 24 | String | X[255] | 255 | |
Flag_PreviouslyAttended | 25 | Boolean | N | 1 | |
Flag_CompensationCase | 26 | Boolean | N | 1 | |
CompensationCaseType | 27 | Numeric | N | 1 | |
CompensationOtherDetail | 28 | String | X[64] | 64 |
For services located in New Zealand:
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 | |
PainSource | 11 | Numeric | N[N] | 2 | |
PainSourceOtherDetail | 12 | String | X[255] | 255 | |
PainDuration | 13 | Numeric | N | 1 | |
EpisodeEndDate | 14 | Date | DD/MM/YYYY | 10 | |
EpisodeEndMode | 15 | Numeric | N | 1 | |
EpisodeEndModeOther | 16 | String | X[255] | 255 | |
Flag_PedHealthProblemChronicDisease | 17 | Boolean | N | 1 | |
Flag_PedHealthProblemMental | 18 | Boolean | N | 1 | |
Flag_PedHealthProblemCancer | 19 | Boolean | N | 1 | |
Flag_PedDisabilitySight | 20 | Boolean | N | 1 | |
Flag_PedDisabilityHearing | 21 | Boolean | N | 1 | |
Flag_PedDisabilityIntellectual | 22 | Boolean | N | 1 | |
Flag_PedDisabilityPhysical | 23 | Boolean | N | 1 | |
PedHealthConditionsAndDisabilityOther | 24 | String | X[255] | 255 | |
Flag_PreviouslyAttended | 25 | Boolean | N | 1 | |
Flag_NZ_FundedACC | 26 | 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 | ||||
PathwayType | 7 | Numeric | N | 1 | |
PathwayStartDate | 8 | Date | DD/MM/YYYY | 10 | |
PathwayEndDate | 9 | Date | DD/MM/YYYY | 10 | |
GroupProgramStartDate | 10 | Date | DD/MM/YYYY | 10 | |
GroupProgramEndDate | 11 | Date | DD/MM/YYYY | 10 | |
DeliveryMode | 12 | Numeric | N | 1 |
Service event 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 | String | |||
EpisodeIdentifier | 4 | String | |||
PathwayID | 5 | String | |||
PathwayIdentifier | 6 | String | |||
ServiceEventID | 7 | String | |||
ServiceEventIdentifier | 8 | String | |||
ServiceEvents | 9 | Numeric | N | 1 | |
ServiceEventsOther | 10 | String | TBD | TBD | |
DateOfService | 11 | Date | DD/MM/YYYY | 10 | |
DurationOfService | 12 | Numeric | TBD | TBD | |
Flag_Telehealth | 13 | Binary | N | 1 |
Patient questionnaire 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 | Numeric | N | 1 | |
SurveyCategoryOtherID | 9 | Numeric | N[N] | 2 | |
SurveyDescription | 10 | String | X[100] | 100 | |
GenerationDate | 11 | Date | DD/MM/YYYY | 10 | |
Paediatric questionnaire type | SurveyTypeID | 12 | |||
Survey mode | SurveyModeID | 13 | Numeric | N | 1 |
PatientSurveySentStatusID | 14 | Numeric | N | 1 | |
PatientSurveyCompletionDate | 15 | Date | DD/MM/YYYY | 10 | |
PatientSurveyKey | 16 | ||||
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 |
PedsQL_Physical_Q1 | 58 | Numeric | N | 1 | |
PedsQL_Physical_Q2 | 59 | Numeric | N | 1 | |
PedsQL_Physical_Q3 | 60 | Numeric | N | 1 | |
PedsQL_Physical_Q4 | 61 | Numeric | N | 1 | |
PedsQL_Physical_Q5 | 62 | Numeric | N | 1 | |
PedsQL_Physical_Q6 | 63 | Numeric | N | 1 | |
PedsQL_Physical_Q7 | 64 | Numeric | N | 1 | |
PedsQL_Physical_Q8 | 65 | Numeric | N | 1 | |
PedsQL_Emotional_Q1 | 66 | Numeric | N | 1 | |
PedsQL_Emotional_Q2 | 67 | Numeric | N | 1 | |
PedsQL_Emotional_Q3 | 68 | Numeric | N | 1 | |
PedsQL_Emotional_Q4 | 69 | Numeric | N | 1 | |
PedsQL_Emotional_Q5 | 70 | Numeric | N | 1 | |
PedsQL_Social_Q1 | 71 | Numeric | N | 1 | |
PedsQL_Social_Q2 | 72 | Numeric | N | 1 | |
PedsQL_Social_Q3 | 73 | Numeric | N | 1 | |
PedsQL_Social_Q4 | 74 | Numeric | N | 1 | |
PedsQL_Social_Q5 | 75 | Numeric | N | 1 | |
PedsQL_School_Q1 | 76 | Numeric | N | 1 | |
PedsQL_School_Q2 | 77 | Numeric | N | 1 | |
PedsQL_School_Q3 | 78 | Numeric | N | 1 | |
PedsQL_School_Q4 | 79 | Numeric | N | 1 | |
PedsQL_School_Q5 | 80 | Numeric | N | 1 | |
Flag_WPAIEmployed | 81 | ||||
WPAIEmployedStatus | 82 | ||||
WPAINumberHoursMissed | 83 | ||||
WPAINumberHoursWorked | 84 | ||||
WPAIProductivityLoss | 85 | ||||
WPAINotEmployedCause | 86 | ||||
FDI_Q1 | 87 | Numeric | N | 1 | |
FDI_Q2 | 88 | Numeric | N | 1 | |
FDI_Q3 | 89 | Numeric | N | 1 | |
FDI_Q4 | 90 | Numeric | N | 1 | |
FDI_Q5 | 91 | Numeric | N | 1 | |
FDI_Q6 | 92 | Numeric | N | 1 | |
FDI_Q7 | 93 | Numeric | N | 1 | |
FDI_Q8 | 94 | Numeric | N | 1 | |
FDI_Q9 | 95 | Numeric | N | 1 | |
FDI_Q10 | 96 | Numeric | N | 1 | |
FDI_Q11 | 97 | Numeric | N | 1 | |
FDI_Q12 | 98 | Numeric | N | 1 | |
FDI_Q13 | 99 | Numeric | N | 1 | |
FDI_Q14 | 100 | Numeric | N | 1 | |
FDI_Q15 | 101 | Numeric | N | 1 | |
BAP_Q1 | 102 | Numeric | N | 1 | |
BAP_Q2 | 103 | Numeric | N | 1 | |
BAP_Q3 | 104 | Numeric | N | 1 | |
BAP_Q4 | 105 | Numeric | N | 1 | |
BAP_Q5 | 106 | Numeric | N | 1 | |
BAP_Q6 | 107 | Numeric | N | 1 | |
BAP_Q7 | 108 | Numeric | N | 1 |
Carer questionnaire 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 | ||||
GenerationDate | 11 | ||||
SurveyTypeID | 12 | ||||
Survey mode | SurveyModeID | 13 | |||
Sent status | CarerSurveySentStatusID | 14 | |||
Completion date | CarerSurveyCompletionDate | 15 | |||
Questionnaire identifier | CarerSurveyKey | 16 | |||
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 |
PedsQL_Physical_Q1 | 58 | Numeric | N | 1 | |
PedsQL_Physical_Q2 | 59 | Numeric | N | 1 | |
PedsQL_Physical_Q3 | 60 | Numeric | N | 1 | |
PedsQL_Physical_Q4 | 61 | Numeric | N | 1 | |
PedsQL_Physical_Q5 | 62 | Numeric | N | 1 | |
PedsQL_Physical_Q6 | 63 | Numeric | N | 1 | |
PedsQL_Physical_Q7 | 64 | Numeric | N | 1 | |
PedsQL_Physical_Q8 | 65 | Numeric | N | 1 | |
PedsQL_Emotional_Q1 | 66 | Numeric | N | 1 | |
PedsQL_Emotional_Q2 | 67 | Numeric | N | 1 | |
PedsQL_Emotional_Q3 | 68 | Numeric | N | 1 | |
PedsQL_Emotional_Q4 | 69 | Numeric | N | 1 | |
PedsQL_Emotional_Q5 | 70 | Numeric | N | 1 | |
PedsQL_Social_Q1 | 71 | Numeric | N | 1 | |
PedsQL_Social_Q2 | 72 | Numeric | N | 1 | |
PedsQL_Social_Q3 | 73 | Numeric | N | 1 | |
PedsQL_Social_Q4 | 74 | Numeric | N | 1 | |
PedsQL_Social_Q5 | 75 | Numeric | N | 1 | |
PedsQL_School_Q1 | 76 | Numeric | N | 1 | |
PedsQL_School_Q2 | 77 | Numeric | N | 1 | |
PedsQL_School_Q3 | 78 | Numeric | N | 1 | |
PedsQL_School_Q4 | 79 | Numeric | N | 1 | |
PedsQL_School_Q5 | 80 | Numeric | N | 1 | |
Flag_WPAIEmployed | 81 | ||||
WPAIEmployedStatus | 82 | ||||
WPAINumberHoursMissed | 83 | ||||
WPAINumberHoursWorked | 84 | ||||
WPAIProductivityLoss | 85 | ||||
WPAINotEmployedCause | 86 | ||||
CarerPostCode | 87 | ||||
CarerSex | 88 | ||||
CarerRelationship | 89 | ||||
CarerRelationshipOther | 90 | ||||
Flag_CarerRequiresHelpWithCom | 91 | ||||
Height | 92 | ||||
Weight | 93 | ||||
SchoolLevel | 94 | ||||
SchoolLevelOther | 95 | ||||
SchoolDaysMissedFortnight | 96 | ||||
CountHSUGP | 97 | ||||
CountHSUSpecialist | 98 | ||||
CountHSUAlliedHealth | 99 | ||||
CountHSUOtherTherapists | 100 | ||||
CountHSUED | 101 | ||||
CountHSUHospital | 102 | ||||
CountHSUDiagnosticTests | 103 | ||||
MedicationParacetamolOnly | 104 | ||||
MedicationAntiInflamatoryCounter | 105 | ||||
MedicationAntiInflamatoryPrescription | 106 | ||||
MedicationOpioidWithCodeine | 107 | ||||
MedicationOpioidNotCodeine | 108 | ||||
MedicationNerve | 109 | ||||
MedicationAlternative | 110 | ||||
Flag_ChildCompletedQuestionnaire | 111 | ||||
NonCompletedReason | 112 | ||||
NonCompletedReasonOther | 113 |
Carer impact questionnaire 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 |