ADR Metadata Catalogue

ADR  > COVID-19 Test Results (PATD) @ 345

https://www.youtube.com/watch?v=ZK9-Jw3uVkw, https://saildatabank.com/about-us/, https://www.gov.uk/government/publications/coronavirus-covid-19-testing-data-methodology/covid-19-testing-data-methodology-note

Test results for COVID-19 tests. Details tests, outcomes, and some clinically relevant patient information about COVID-19 Tests in Wales.

SAIL Databank (Wales)

Welsh Results Reports Service (WRRS)

ADDED_DTTM

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-19

DF_COVID_LIMS_ANTIBODYRESULTS

The Anonymised Linking Field, which has been Encrypted for its use within the database, is derived from the persons NHS number by double encryption (first encryption occurs in NWIS and the second in SAIL). If the NHS number is not supplied in the data extract then matching methods are applied.

ALF_E

Match percentage assigned when deriving the Encrypted Anonymised Linking Field.

ALF_MTCH_PCT

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-20

Status code assigned when deriving the Encrypted Anonymised Linking Field.

ALF_STS_CD

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-21

AUTHORISED_DT

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-22

Date time that the report was authorised.

AUTHORISED_DTTM

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-23

AUTHORISED_TM

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-24

AUTO_CMT_S

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-25

Date when the data made available i.e. date of loading.

AVAIL_FROM_DT

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-26

CREATED_DTTM

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-27

CTU_LOC

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-28

CTU_LOC_PARENT_ORG_CD

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-29

CTU_LOC_PARENT_ORG_NAME

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-30

CTU Person Type (essential worker, inpatient, healthcare worker, education worker).

CTU_PERS_TYPE

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-31

CTU_PERS_TYPECONSOLIDATED

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-32

DEPT

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-33

ENTRY_DTTM

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-34

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-35

Concatanation of episode number and set key.

EPI_SETKEY

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-36

FIRSTAUTHORISED_DT

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-37

Date time that the test was first authorised.

FIRSTAUTHORISED_DTTM

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-38

FIRSTAUTHORISED_TM

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-39

GNDR_CD

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-40

Date time that the record was last changed

LASTCHANGE_DTTM

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-41

Name of Local Authority of residence based on ONS data.

LA_RES_NAME

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-42

Code of Local Authority of residence based on ONS data.

LA_RES_ONS_CD

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-43

Code of Local Health Board of residence based on ONS data.

LHB_RES_CD

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-44

Name of Local Health Board of residence based on ONS data.

LHB_RES_NAME

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-45

LHB_RES_ONS_CD

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-46

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-47

LOC_CD

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-48

METHOD

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-49

MRN_LIMS_PERS_ID_E

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-50

OTHERINFORMATION

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-51

OUTBREAK

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-52

OUTBREAK_CD

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-53

PAT_TYPE_CD

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-54

PAT_TYPE_DESC

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-55

PRAC_CD_E

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-56

RECEIVEDEPISODE_DTTM

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-57

RECEIVINGLABNAME

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-58

RECEIVINGLAB_CD

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-59

REPORT_CMT_S

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-60

Method that test was requested (e.g. paper, electronic).

REQST_TYPE

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-61

Test Result description (e.g. RNA detected)

RESULTNAME

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-62

RESULT_CD

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-63

RESULT_CMT

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-64

SENDRECEIVE_DTTM

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-65

Set Key. Indicates whether result for test set obtained.

SETKEY

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-66

SPCM_CD

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-67

SPCM_COLLECTED_DT

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-68

SPCM_COLLECTED_DTTM

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-69

SPCM_COLLECTED_TM

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-70

SPCM_NAME

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-71

SPCM_RECEIVED_DT

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-72

SPCM_RECEIVED_DTTM

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-73

SPCM_RECEIVED_TM

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-74

TATLAB_M

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-75

TATREQ_M

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-76

TESTINGLABNAME

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-77

TESTINGLAB_CD

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-78

TESTNAME

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-79

Test Set Laboratory Information Management System (LIMS) Code.

TESTSETLIMS_CD

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-80

TESTSETNAME

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-81

TESTSET_STS

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-82

TEST_CD

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-83

UPDATED

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-84

VIEWABLE_DTTM

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-85

Test results from Laboratory Information Management System for Pillar 3 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 3 Test: Serology testing to show if people have antibodies from having had COVID-86

Test results from Laboratory Information Management System for Pillar 1 and 2 COVID19 tests (coronavirus SARS CoV2 PCR and coronavirus PCR tests). Pillar 1 Test: Swab testing in Public Health England (PHE) labs and NHS hospitals for those with a clinical need, and health and care workers Pillar 2 Test: Swab testing for the wider population, as set out in government guidance

COVID-19 Test Results (PATD)

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Observations

Origin