|Version 1 (modified by admin, 3 years ago) (diff)|
tblOVERLAP - Cross-cohort identification
holds information on the patient's participation in other cohorts
Note: Fields marked bold form the unique identifier for a record of the table.
character (or numeric if possible)
Code to identify patient (Cohort Patient ID)
Code/name of the cohort
Unique patient identifier in other cohorts
Name of the cohort
Patients of an "original"-cohort who also participate in a "super"-cohort should be analysed within the "original"-cohort only. To suppress these patients from the datasets of the "super"-cohorts the identifier used in the "super"-cohort is needed. It is suggested that "original"-cohorts report id's from the "super"-cohorts, since the "super"-cohorts might not even know the other ID’s. Often this information is only available at centre level.
A record should be present for each cohort that the patient is participating in (apart from it's own "original"-cohort).
|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|