tblVIS_SUBS - Patients use of substances like alcohol, cigarettes and drugs
holds information on patients use of substances like alcohol, cigarettes and drugs
Core Fields
| Field name | Format | Description |
|---|---|---|
| PATIENT | Numeric | Code to identify patient (Cohort Patient ID) |
| SUBS_D | Date (yyyy-mm-dd) | Date of assessment |
| SUBS_ID | Character:
|
Type of substance
In case of abuse, it should be defined what is considered as abuse, Eg. : Alcohol: For men: An intake of >25 alcohol containing units a week. For women: An intake of > 20 alcohol containing units a week. |
| SUBS_Y | numeric:
|
Patient’s substance use at assessment date |
Additional Fields
| Field name | Format | Description |
|---|---|---|
| SUBS_FR | Numeric | Frequency For ALCO: Number of alcohol containing units per day For SMK: Number of years smoking/not smoking (depending on SUBS_Y) |
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 |