tpp

view details →

Available on backends: TPP

This schema defines the data (both primary care and externally linked) available in the
OpenSAFELY-TPP backend. For more information about this backend, see
"SystmOne Primary Care".

core

view details →

Available on backends: TPP, EMIS

This schema defines the core tables and columns which should be available in any backend
providing primary care data, allowing dataset definitions written using this schema to
run across multiple backends.

emis

view details →

Available on backends: EMIS

This schema defines the data (both primary care and externally linked) available in the
OpenSAFELY-EMIS backend. For more information about this backend, see
"EMIS Primary Care".

raw.core

view details →

Available on backends: TPP, EMIS

This schema defines the core tables and columns which should be available in any backend
providing primary care data, allowing dataset definitions written using this schema to
run across multiple backends.

The data provided by this schema are minimally transformed. They are very close to the
data provided by the underlying database tables. They are provided for data development
and data curation purposes.

raw.emis

view details →

Available on backends: EMIS

This schema defines the data (both primary care and externally linked) available in the
OpenSAFELY-EMIS backend. For more information about this backend, see
"EMIS Primary Care".

The data provided by this schema are minimally transformed. They are very close to the
data provided by the underlying database tables. They are provided for data development
and data curation purposes.

raw.tpp

view details →

Available on backends: TPP

This schema defines the data (both primary care and externally linked) available in the
OpenSAFELY-TPP backend. For more information about this backend, see
"SystmOne Primary Care".

The data provided by this schema are minimally transformed. They are very close to the
data provided by the underlying database tables. They are provided for data development
and data curation purposes.

smoketest

view details →

Available on backends: TPP, EMIS

This tiny schema is used to write a minimal dataset definition that
can function as a basic end-to-end test (or "smoke test") of the OpenSAFELY platform
across all available backends.