Skip to content

Job request: 12503

Organisation:
Bennett Institute
Workspace:
medication_reviews
ID:
ycdluji3auhteoqr

This page shows the technical details of what happened when the authorised researcher Chris Wood requested one or more actions to be run against real patient data within a secure environment.

By cross-referencing the list of jobs with the pipeline section below, you can infer what security level the outputs were written to.

The output security levels are:

  • highly_sensitive
    • Researchers can never directly view these outputs
    • Researchers can only request code is run against them
  • moderately_sensitive
    • Can be viewed by an approved researcher by logging into a highly secure environment
    • These are the only outputs that can be requested for public release via a controlled output review service.

Jobs

  • Action:
    generate_plots
    Status:
    Status: Failed
    Job identifier:
    bsqfko2xbxt7dzwm
    Error:
    cancelled_by_user: Cancelled by user
  • Action:
    generate_study_population
    Status:
    Status: Failed
    Job identifier:
    lcmxjg7uulmh6s2u
    Error:
    cancelled_by_user: Cancelled by user
  • Action:
    redact_and_round
    Status:
    Status: Failed
    Job identifier:
    qvg3jvwhzyauvhkd
    Error:
    cancelled_by_user: Cancelled by user
  • Action:
    generate_measures_all_reviews
    Status:
    Status: Failed
    Job identifier:
    7rx26eaquphiudit
    Error:
    cancelled_by_user: Cancelled by user
  • Action:
    generate_ethnicity_cohort
    Status:
    Status: Failed
    Job identifier:
    xit5s6tbweyd3tmo
    Error:
    cancelled_by_user: Cancelled by user
  • Action:
    join_cohorts
    Status:
    Status: Failed
    Job identifier:
    ql4vkps6ywckriu7
    Error:
    cancelled_by_user: Cancelled by user

Pipeline

Show project.yaml
version: '3.0'

expectations:
  population_size: 3000

actions:

  generate_study_population:
    run: >
      cohortextractor:latest generate_cohort
        --study-definition study_definition
        --index-date-range "2019-04-01 to 2022-03-01 by month"
        --output-format='csv.gz'
    outputs:
      highly_sensitive:
        cohort: output/input_*.csv.gz

  generate_ethnicity_cohort:
    run: >
      cohortextractor:latest generate_cohort
        --study-definition study_definition_ethnicity
        --output-format='csv.gz'
    outputs:
      highly_sensitive:
        cohort: output/input_ethnicity.csv.gz

  join_cohorts:
    run: >
      cohort-joiner:v0.0.44
        --lhs output/input_20*.csv.gz
        --rhs output/input_ethnicity.csv.gz
        --output-dir output/joined
    needs: [generate_study_population, generate_ethnicity_cohort]
    outputs:
      highly_sensitive:
        cohort: output/joined/input_*.csv.gz

## generate Structured Medication Review Measures and plots

  generate_measures_all_reviews:
     run: >
       cohortextractor:latest generate_measures 
       --study-definition study_definition 
       --output-dir=output/joined
     needs: [join_cohorts]
     outputs:
       moderately_sensitive:
         measure_csv: output/joined/measure_*_*_rate.csv

  generate_deciles_charts:
    run: >
      deciles-charts:v0.0.33
        --input-files output/joined/measure_*_practice_rate.csv
        --output-dir output/joined
    config:
      show_outer_percentiles: false
      tables:
        output: true
      charts:
        output: true
    needs: [generate_measures_all_reviews]
    outputs:
      moderately_sensitive:
        deciles_charts: output/joined/deciles_*_*.*

  redact_and_round:
    run: python:latest python analysis/redact_and_round.py
    needs: [generate_measures_all_reviews]
    outputs:
      moderately_sensitive:
        cohort: output/redacted/redacted_measure_*.csv

  generate_plots:
    run: python:latest python analysis/plots.py
    needs: [generate_measures_all_reviews, redact_and_round]
    outputs:
      moderately_sensitive:
        cohort: output/figures/*_*_rate.jpeg    

  generate_table_1:
    run: python:latest python analysis/table_1.py --study_def_paths="output/joined/input_*.csv.gz" --demographics="age_band,sex,region,imdQ5,ethnicity,learning_disability,care_home_type" --outcome "had_smr"
    needs: [join_cohorts]
    outputs:
      moderately_sensitive:
        counts: output/table_1.csv
        had_outcome: output/table_1_had_outcome.csv

  generate_codeuse_output:
    run: python:latest python analysis/code_use_summary.py --study_def_paths="output/joined/input_*.csv.gz" --codelistfile="user-chriswood-medication-review.csv"
    needs: [join_cohorts]
    outputs:
      moderately_sensitive:
        code_counts: output/codeuse.csv

Timeline

  • Created:

  • Finished:

  • Runtime:

These timestamps are generated and stored using the UTC timezone on the TPP backend.

Job request

Status
Failed
Backend
TPP
Workspace
medication_reviews
Requested by
Chris Wood
Branch
main
Force run dependencies
Yes
Git commit hash
a05277c
Requested actions
  • redact_and_round
  • generate_plots

Code comparison

Compare the code used in this job request