In the self-service reports service, you can access:
- CHIS and CHIS including not givens
- NIVS
- Refusal Report
- Outstanding Report
CHIS reporting
CHIS reporting is available for all our customers. There are two types: CHIS and CHIS including Not Given
Download locations
- Log into RIVIAM web (or Workflow)
- Select the "Immunisations" page
- Select the Immunisation programme
- Select the "Reporting" tab on the left-hand navigation menu
This displays the self-service reporting options. Users can choose to filter by the hub and by date range. The report requested is downloaded in a CSV format.
Default headers
The default headers in the document are:
PRACTICE_CODE |
NHS_NUMBER |
SURNAME |
MIDDLE_NAME |
FORENAME |
GENDER |
DATE_OF_BIRTH |
HOUSE_NAME |
HOUSE_NUMBER_AND_ROAD |
TOWN |
POSTCODE |
VACCINATION |
PART |
ADMIN_DATE |
BATCH_NUMBER |
EXPIRY_DATE |
DOSE |
REASON |
SITE |
METHOD |
NOTES |
SCHOOL_NAME |
IMMUNISER_FIRST_NAME |
IMMUNISER_SECOND_NAME |
AREA |
YR_GRP |
Content
CHIS | CHIS Including Not Given |
All vaccinations outcomed within the specified timeframe/hub where the vaccination status is "given" |
All vaccinations outcomed within the specified timeframe/hub where the vaccination status is "given" AND All vaccinations outcomed within the specified timeframe/hub where the vaccination status is "not given" |
Exclusions
- Batch Number contains the text "ERROR"
- The Read code contains the text "Duplicate vaccination referral"
- Referrals will not be included if the school year is missing
- Establishments where the URN is like "ZZZ" (test schools)
NIVS
Available for all our Immunisations customers with Flu or HPV programme.
Download locations
School and Bookings NIVS
- Select the Immunisation programme
- Select the school needed
- Select the "School reporting" tab as shown below
- Users have the option to download the NIVS report by school or the NIVS spreadsheet, including clinic bookings
Hub level
NIVS spreadsheets are also available to download across Hubs in self-service reporting.
To access self-service reporting
- Select the Immunisation tab
- Select "Reporting" from the left-hand navigation menu
Expected headers:
Flu | HPV |
ORGANISATION_CODE | ORGANISATION_CODE |
SCHOOL_URN | SCHOOL_URN |
SCHOOL_NAME | SCHOOL_NAME |
NHS_NUMBER | NHS_NUMBER |
PERSON_FORENAME | PERSON_FORENAME |
PERSON_SURNAME | PERSON_SURNAME |
PERSON_DOB | PERSON_DOB |
PERSON_GENDER_CODE | PERSON_GENDER_CODE |
PERSON_POSTCODE | PERSON_POSTCODE |
VACCINATED | DATE_OF_VACCINATION |
DATE_OF_VACINATION | VACCINE_GIVEN |
VACCINE_GIVEN | BATCH_NUMBER |
BATCH_NUMBER | BATCH_EXPIRY_DATE |
BATCH_EXPIRY_DATE | ANATOMICAL_SITE |
ANATOMICAL_SITE | DOSE_SEQUENCE |
PERFORNMING_PROFESSIONAL_FORENAME | LOCAL_PATIENT_ID |
PERFORMING_PROFESSIONAL_SURNAME | LOCAL_PATIENT_ID_URI |
REASON_NOT_VACCINATED | CARE_SETTING |
CONSENT_TYPE | |
LOCAL_PATIENT_ID | |
LOCAL_PATIENT_ID_URI |
Content
For all versions, for all programmes
FLU | HPV | |
Regular (available at school and hub level) |
All vaccinations outcomed within the specified timeframe OR from the current establishment (if downloading at school level) where the vaccination status is "given" AND All vaccinations outcomed within the specified timeframe OR from the current establishment (if downloading at school level) where the vaccination status is "not given" |
All vaccinations outcomed within the specified timeframe OR from the current establishment (if downloading at school level) where the vaccination status is "given" |
For Bookings (only available at a school level) | All vaccinations which are associated with a booking at the selected establishment where the outcome is created on the same day as the clinic is scheduled. For "given" and "not given" outcomes. | All vaccinations which are associated with a booking at the selected establishment where the outcome is created on the same day as the clinic is scheduled. For "given" outcomes. |
Exclusions
- Batch Number contains the text "ERROR"
- The Read code contains the text "Duplicate vaccination referral"
- Test schools are not currently excluded
Refusals Report
Available for all our Immunisations customers for all immunisation programmes via self-service reporting.
Download locations
Expected headers
2 Part programmes (e.g. DTP/Meningitis) | 1 Part programmes (e.g. Flu) |
SCHOOL_URN | SCHOOL_URN |
SCHOOL_NAME | SCHOOL_NAME |
SCHOOL_YEAR | SCHOOL_YEAR |
FAMILY_NAME | FAMILY_NAME |
GIVEN_NAME | GIVEN_NAME |
DATE_OF_BIRTH | DATE_OF_BIRTH |
EXTERNAL_REFERENCE | EXTERNAL_REFERENCE |
DTP_CONSENT | |
DTP_REASON | |
MEN_CONSENT | |
MEN_REASON |
Outstanding Vaccinations Report
Download locations
Expected headers
All programmes:
Hub
establishment_name
school_year
DOB
First_Name
Surname
external_reference
vaccine_product_name
consent_status
status
Content
All referrals for specified programmes (date range is not used), where the Consent Status is Given and the Vaccination Status is Not Given.
TPP Bulk Upload Extract- all records and failed records reports
Designed to work with the SystmOne Child Health Bulk Upload Tool.
Expected headers:
Practice code | |
NHS Number | Missing NHS Numbers are shown with a 0 in the field |
Surname | |
Middle name | Left blank |
Forename | |
Gender | |
Date of Birth | |
House name | |
House number and Road | |
Town | |
Postcode | |
Vaccination | Code only (e.g. XaIQX for meningitis) |
Part | Left blank |
Admin date | |
Batch number | |
Expiry date | |
Dose | |
Reason | Left blank |
Site | |
Method | |
Notes |
Content
This report covers all referrals for the given program and date range where the vaccination status is GIVEN and the consent status is either in the "consent given"/"not given"/"declined by service"/"conflicting consent" steps.
Options:
- TPP status = failed (iv.tpp_status < 0 OR iv.tpp_status >= 2) - excludes vaccinations where TPP status is “not processed” or “vaccination updated”
- All TPP statuses
Exclusions
- Readcode contains the text “Duplicated vaccination referral”
- Referrals will not be included if the school year is missing (i.e. no tbl_referral_imms_extra entry for that referral)
- Establishments where the URN is like “ZZZ” (test schools)
Download location
Comments
0 comments
Please sign in to leave a comment.