Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Jira
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTOBA-299

This is an example of the ADLB dataset and associated metadata. This is just an example and does not mean to indicate that ADLB must be used as the dataset name, nor are the parameters described necessarily the ones those that would be used in a particular study. 

...

Definexmltable
LevelDataset
PurposeAnalysis
NameADLB
DatasetDescriptionClassStructurePurposeKeysLocationDocumentation
ADLBLaboratory Analysis DatasetBASIC DATA STRUCTUREOne or more records per subject per analysis parameter per analysis visit per analysis timepointAnalysisSTUDYID, USUBJID, PARAM, PARAMCD, AVISIT,ADLB.xptADLB.SAS/SAP
Definexmltable
DatasetRFTRANSPADLB
LevelVariable
PurposeAnalysis
NameADLB
Variable NameVariable LabelTypeCodelist/Controlled TermsCoreCDISC Notes

STUDYID

Study IdentifierChar
ReqLB.STUDYID
USUBJIDUnique Subject IdentifierChar
ReqLB.USUBJID
TRTPPlanned ProductChar
CondADSL.TRT01P
TRT01PPlanned Product for Period 01Char
CondADSL.TRT01P
TRTAActual ProductChar
CondADSL.TRT01A
TRT01AActual Product for Period 01Char
CondADSL.TRT01A
ADTAnalysis DateNum
PermLB.LBDTC captured in numeric format
ADYAnalysis Relative DayNum
PermLB.LBDY
AVISITAnalysis VisitChar
CondLB.VISIT
AVISITNAnalysis Visit (N)Num
PermLB.VISITNUM
PARAMParameterChar
ReqLB.LBTEST concatenated with LB.LBSTRESU - if PARCAT1=URINALYSIS then preface with Urine
PARAMCDParameter Codetext
ReqLB.LBTESTCD - if PARCAT1=URINALYSIS then preface with U
PARAMNParameter (N)Num
PermNumeric representation of PARAM. Sort by PARCAT! and PARAMCD and increment by 1 for each new LBTESTCD
PARCAT1Parameter Category 1Char
PermLB.LBCAT
AVALAnalysis ValueNum
CondLB.LBSTRESN
AVALCAnalysis Value (C)Char
CondLB.LBSTRESC where LB.LBSTRESN is null
BASEBaseline ValueNum
CondAVAL where ABLFL=Y
CHGChange from BaselineNum
PermAVAL-BASE - populated on ABLFL=Y records and post-baseline records
PCHGPercent Change from BaselineNum
Permderived as ((AVAL-BASE)/BASE)*100
ABLFLBaseline Record FlagCharYCondset to Y for last pre-product value within each PARAM
ANL01FLAnalysis Flag 01CharYCondset to Y for last value within PARAM and AVISIT
RANDFLRandomized Population FlagCharY;NCondADSL.RANDFL
SAFFLSafety Population FlagCharY;NCondADSL.SAFFL
TRTSDT

Date of First Exposure to Product

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTOBA-192

Num
PermADSL.TRTSDT
TRTEDT

Date of Last Exposure to Product

Jira
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTOBA-190

Num
PermADSL.TRTEDT
LBSEQSequence NumberNum
PermLB.LBSEQ
VISITNUMVisit NumberNum
PermLB.VISITNUM
LBDTCDate/Time of Specimen CollectionChar
PermLB.LBDTC