Page History

The Supplemental Qualifiers (SUPP–SUPP--) special purpose dataset model is used to represent both nonstandard variables (NSVs) and attributions with their relationship to records in a parent dataset.   SUPP-- will only be used with

There will be only one SUPP-- dataset for a parent dataset. Relationships between records in the SUPP-- dataset with and observations in the parent dataset are specified using the key variables STUDYID, RDOMAIN, and USUBJID, along with IDVAR and IDVARVAL (the domain code value of the record or dataset in the relationship) with IDVAR (the variable that identifies the related record(s)). Each record in the RELREC special-purpose dataset contains keys that identify a record (or group of records) and an identifier for the relationship which is stored in the RELID variable. The value of RELID is chosen by the applicant and it is recommended that applicants use a standard system or naming convention for RELID (e.g., all letters, all numbers, capitalized).identifying variable). IDVARVAL will contain the value of the variable described in IDVAR. Single records can be related by using a unique-record-identifier variable such as --SEQ in IDVAR. Groups of records can be related by using grouping variables such as --GRPID in IDVAR.  Using --GRPID can be a more efficient method of representing relationships in RELREC when relating a single or group of records in one dataset to a group of records in another dataset. 

In a SUPP-- dataset, the combined set of values for STUDYID, USUBJID, POOLID (for nonclinical studies only), IDVAR, IDVARVAL, and QNAM will be unique for every record. There will not be multiple records in a SUPP-- dataset for the same QNAM value, as it relates to IDVAR/IDVARVAL for a USUBJID in a domain. Using --GRPID can be a more efficient method to identify individual qualifier values (SUPP-- records) related to multiple general observation class domain records that could be grouped, such as relating an attribution to a group of laboratory measurements.

...