Use SDTM Identifiers for as many columns as possible

  • Recommendation: For each table, assign SDTM Identifiers to as many columns as possible.

    • We recommend assigning USUBJID and SUBJID for subject-level tables.

    • We recommend assigning USUBJID, VISITNUM, SUBJID, and VISIT for subject-visit-level tables.

  • Rationale: DMW/LSH indexes are based on the identifiers.

  • Additional information: Mapping columns to SDTM Identifiers increases the filtering capability in the DMW Data Management user interface.