Skip to content

Job request: 13782

Organisation:
The London School of Hygiene & Tropical Medicine
Workspace:
cis-pop-validation-ehrql-dev
ID:
covfdcy43rqwpsrr

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

By cross-referencing the indicated Requested Actions with the Pipeline section below, you can infer what security level various outputs were written to. Outputs marked as highly_sensitive can never be viewed directly by a researcher; they can only request that code runs against them. Outputs marked as moderately_sensitive can be viewed by an approved researcher by logging into a highly secure environment. Only outputs marked as moderately_sensitive can be requested for release to the public, via a controlled output review service.

Jobs

Pipeline

Show project.yaml
version: '3.0'

expectations:
  population_size: 1000

actions:

  generate_dataset_cohortextractor:
    run: >
      cohortextractor:latest generate_cohort 
        --study-definition study_definition
        --output-dir 'output'
        --output-file "output/dataset_cohortextractor_2022-09-25.csv"
        --output-format csv
    outputs:
      highly_sensitive:
        cohort: output/dataset_cohortextractor_2022-09-25.csv

  generate_dataset_ehrql:
    run: >
      databuilder:v0
        generate-dataset analysis/dataset_definition.py 
        --output output/dataset_ehrql_2022-09-25.csv
        --dummy-tables dummy_data
    outputs:
      highly_sensitive:
        cohort: output/dataset_ehrql_2022-09-25.csv
 
  calculate_dataset_diff:
    run: >
      r:latest analysis/dataset_diff.R
    needs:
      - generate_dataset_cohortextractor
      - generate_dataset_ehrql
    outputs:
      moderately_sensitive:
        summary: output/diff/dataset_diff_summary.csv
        by_care_home_tpp: output/diff/dataset_diff_care_home_tpp.csv
        by_sex: output/diff/dataset_diff_sex.csv

Timeline

  • Created:

  • Started:

  • Finished:

  • Runtime: 00:37:57

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

Job information

Status
Succeeded
Backend
TPP
Requested by
Dave Evans
Branch
dev
Force run dependencies
No
Git commit hash
3adc61d
Requested actions
  • generate_dataset_cohortextractor
  • generate_dataset_ehrql
  • calculate_dataset_diff

Code comparison

Compare the code used in this Job Request