tblOVERLAP - Cross-cohort identification
holds information on the patient's participation in other cohorts
Core Fields
Note: Fields marked bold form the unique identifier for a record of the table.
| Field name | Format | Description |
|---|---|---|
| PATIENT | character (or numeric if possible) | Code to identify patient (Cohort Patient ID) |
| COHORT | character | Code/name of the cohort |
| PAT_OTH | character | Unique patient identifier in other cohorts |
| COH_OTH | character | Name of the cohort |
QA Checks
| Table | Crosstable | Error Code | Description | Study specific | Is HICDEP |
|---|---|---|---|---|---|
| AllTables | CrossTable | ATC001 | any date in database after DEATH_D in tblLTFU | Yes | |
| AllTables | CrossTable | ATC002 | any date in database after DROP_D in tblLTFU | Yes | |
| AllTables | CrossTable | ATC003 | any date in database before BIRTH_D in tblBAS | Yes | |
| AllTables | CrossTable | ATC004 | any date in database in the future | Yes | |
| AllTables | CrossTable | ATC005 | patients submitted previously who have been missed out | Yes | |
| AllTables | CrossTable | ATC006 | Any fields not coded as coding lists on table definition | Yes | |
| tblOVERLAP | WithinTable | OW001 | Invalid other cohort | Yes | |
| tblOVERLAP | CrossTable | OC001 | PATIENT not found in tblBAS for that cohort | Yes | |
| tblOVERLAP | CrossTable | OC002 | PAT_OTH not found in tblBAS for that overlapping cohort | Yes |