Summary

This article covers the  dataset.  

Table of Contents


Mapping

Form Type IdQuestion IdInstructionValueColumn NumberColumn TitleData TypeData Format
dm,DM macroSTUDYID0STUDYIDString 
  constDM1DOMAINString 
  macroUSUBJID2USUBJIDString 
 #screening.csnt.subjid
$>
$>#screening.csnt.subjid
$>
 		char
$>setVar
$>char
$>setVar
$>getVar		begin,0,4
$>siteID
$>end,4
$>recID
$>siteID,recID		3SUBJIDString 
  parameter
$>setVar
$>toISO8601		referencePeriodStart
$>datePath
$>datePath		4RFSTDTCString 
  parameter
$>setVar
$>toISO8601		referencePeriodEnd
$>datePath
$>datePath		5RFENDTCString 
  toolName
$>substring		 
$>begin,0,4		6SITEIDString 
 #screening.csnt.csntdtcinvID 7INVIDString 
 #screening.csnt.csntdtcinvName 8INVNAMString 
 brthdattoISO8601 9BRTHDTCString 
 ageqst 10AGEInteger 
  constYEARS11AGEUString 
 sexparamListLookupsexSDTM12SEXString 
 raceoth
$>
$>race
$>
$>
$>
$>
$>		uppercase
$>setVar
$>paramListLookup
$>setVar
$>if
$>thenVar
$>elseVar
$>fi		 
$>raceOther
$>raceSDTM
$>raceVar
$>race == 5
$>raceOther
$>raceVar
$>		13RACEString 
 ethnicparamListLookupethnicSDTM14ETHNICString 
  armCode 15ARMCDString 
    16ARMString 
  toolName
$>substring
$>appendConst
$>propertyEx		 
$>begin,0,4
$>-country
$>		17COUNTRYString 
 brthdat
$>
 		const
$>setVar
$>toISO8601		#screening.dtscreen.visitdtc
$>datePath
$>datePath		18DMDTCString 
 brthdat
$>		invAnswerTime
$>studyDay		 19DMDYInteger

Summary of Questions

questionTypeIdQuestion TextData TypeAnswer Options / Default Value
brthdatDate of Birth (dd-MMM-yyyy):Date 
infconsDate Informed Consent obtained (dd-MMM-yyyy):Date 
ageAge:Integer 
sexSex:Integer1||Female::2||Male::98||Unknown::3||Undifferentiated
ethnicEthnicity:Integer1||Hispanic or Latino::2||Not Hispanic or Latino::3||Not Reported::98||Unknown
raceRace (check all that apply):String1||Black or African American::2||American Indian or Alaska Native::3||Asian::4||Native Hawaiian or Other Pacific Islander::5||White

paramListLookup Formats

NameValue
sexSDTM1||F::2||M::98||U::3||UN
raceSDTM1||BLACK OR AFRICAN AMERICAN::2||AMERICAN INDIAN OR ALASKA NATIVE::3||ASIAN::4||NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER::5||WHITE
ethnicSDTM1||HISPANIC OR LATINO::2||NOT HISPANIC OR LATINO::3||NOT REPORTED::98||UNKNOWN

To download an example Excel File of this export click on the attachment at the bottom of the page.

Need more help?

Please visit the Fountayn Contact Information page.