tblOVERLAP - Cross-cohort identification
holds information on the patient's participation in other cohorts
|
|
Core FieldsNote: Fields marked bold form the unique identifier for a record of the table.
|
Field name Format Description character (or numeric if possible) Code to identify patient (Cohort Patient ID)
|
character Code/name of the cohort
|
character Unique patient identifier in other cohorts
|
character Name of the cohort
|
QA Checks
| Table | Crosstable | Error Code | Description | Study specific | 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 |