wiki:Hicdep_1.100/TableCep

tblCEP - Clinical Events and Procedures

holds type and date of adverse events including serious non-AIDS conditions

Core fields

Note: Fields marked bold form the unique identifier for a record of the table.

Field name

Format

Description

EVENT_ID

numeric

Unique Event Identifier (foreign key to the different event tables)

PATIENT

character (or numeric if possible)

Code to identify patient (Cohort Patient ID)

CEP_D

yyyy-mm-dd

date of event

CEP_ID

character. see coding table for valid codings.

identifies type of event

CEP_SPEC

character. see coding table for valid codings.

further specification

CEP_V

numeric. See coding table for interpretation.

Depending on CEP_ID and CEP_SPEC: value of given event

SRCDOC_Y

numeric:

  • 1 = Yes
  • 0 = No

whether the source documentation is available

SRCDOC_D

yyyy-mm-dd

date for source documentation verification

VERIFY_Y

numeric:

  • 1 = Yes
  • 0 = No

Has the monitor verified the source documentation?

VERIFY_D

yyyy-mm-dd

date for monitor verification

APPROV_Y

numeric:

  • 1 = Yes
  • 0 = No

final verification/approval

APPROV_D

yyyy-mm-dd

final verification date

APPROV_S

character

signature for final verification

Additional fields

Field name

Format

Description

CEP_Y

numeric:

  • 1 = Yes
  • 0 = No
  • 9 = Unknown

has the patient had an event?

CEP_NAME

character

full name of the event

CEP_DESCRIP

character

full description of the event

CEP_R_Y

numeric:

  • 0 = not related
  • 1 = definitive
  • 2 = remote/unlikely
  • 3 = possible
  • 4 = probable

relation to treatment

QA Checks

Table Crosstable Error Code Description Study specific HICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFUYES
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFUYES
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBASYES
AllTablesCrossTableATC004any date in database in the futureYES
AllTablesCrossTableATC005patients submitted previously who have been missed outYES
AllTablesCrossTableATC006Any fields not coded as coding lists on table definitionYES
Last modified 19 months ago Last modified on 12/02/15 09:39:32