Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: typos

...

Dataset wrap
Nametr


Rowcaps

Rows 1-11: Show the longest diameter and sum of longest diameter for the target lesion. The subject only has one target lesion and no non-targets.

Rows 3-6: Show assessment where the target lesion is absent. The longest diameter is shown as "0". If a sponsor collects that the tumor is absent rather than entering the longest diameter as "0", then the sponsor may optionally derive the longest diameter as "0" and represent the tumor state as ABSENT, if desired. 

Row 12: Shows a new lesion state at week 24.


Dataset2


RowSTUDYIDDOMAINUSUBJIDTRSEQTRGRPIDTRLNKGRPTRLNKIDTRTESTCDTRTESTTRORRESTRORRESUTRSTRESCTRSTRESNTRSTRESUTRSTATTRREASNDTRMETHODTREVALEPOCHVISITNUMVISITTRDTCTRDY
1EX55555TR900051TARGETA1T01LDIAMLongest Diameter10mm1010mm

CT SCANINVESTIGATORSCREEN1SCREENING2007-01-021
2EX55555TR900052TARGETA1
SUMLDIAMSum of Longest Diameter10mm1010mm


INVESTIGATORSCREEN1SCREENING

3EX55555TR900053TARGETA2T01LDIAMLongest Diameter0mm00mm

CT SCANINVESTIGATORTREATMENT3WEEK 82007-02-2756
4EX55555TR900054TARGETA2T01TUMSTATETumor StateABSENT
ABSENT



CT SCANINVESTIGATORTREATMENT3WEEK 82007-02-2756
5EX55555TR900055TARGETA2
SUMLDIAMSum of Longest Diameter0mm00mm


INVESTIGATORTREATMENT3WEEK 8

6EX55555TR900056TARGETA3T01LDIAMLongest Diameter0mm00mm

CT SCANINVESTIGATORTREATMENT4.1UNCHEDULED WEEK 132007-04-0391
7EX55555TR900057TARGETA3T01TUMSTATETumor StateABSENT
ABSENT



CT SCANINVESTIGATORTREATMENT4.1UNCHEDULED WEEK 132007-04-0391
8EX55555TR900058TARGETA3
SUMLDIAMSum of Longest Diameter0mm00mm


INVESTIGATORTREATMENT4.1UNCHEDULED WEEK 13

9EX55555TR900059TARGETA4T01LDIAMLongest Diameter




NOT DONENOT EVALUABLE: Motion issueCT SCANINVESTIGATORTREATMENT5WEEK 162007-04-24112
10EX55555TR9000510TARGETA4T01TUMSTATETumor State




NOT DONENOT EVALUABLE:  Motion Motion issueCT SCANINVESTIGATORTREATMENT5WEEK 162007-04-24112
11EX55555TR9000511TARGETA4
SUMLDIAMSum of Longest Diameter




NOT DONE

INVESTIGATORTREATMENT5WEEK 16

12EX55555TR9000512TARGETA5T01LDIAMLongest Diameter5mm55mm

CT SCANINVESTIGATORTREATMENT7WEEK 242009-06-19168
13EX55555TR9000513TARGETA5T01TUMSTATETumor StatePRESENT
PRESENT



CT SCANINVESTIGATORTREATMENT7WEEK 242009-06-19168
14EX55555TR9000514TARGETA5
SUMLDIAMSum of Longest Diameter5mm55mm


INVESTIGATORTREATMENT7WEEK 24

15EX55555TR9000515NEWA5NEW01TUMSTATETumor StatePRESENT
PRESENT



CT SCANINVESTIGATORTREATMENT7WEEK 242009-06-19168



...

Dataset wrap
Namesupptu


Rowcaps

Row 1: Shows that the presentation of the disease in the brain is leptomeningeal carcinomatosis, i.e., for the non-target site in the brain (TULNKID = "NT01"), the QVAL is "LEPTOMENINGEAL DISEASE".

Rows 2-3: Show the plane of measurement (QNAM = "TUPLOMSR") and the slice number (QNAM = "TUSLNUM") where the brain non-target lesion (TULNKID = "NT01") was identified.

Rows 4-5: Show the plane of measurement (QNAM = "TUPLOMSR") and the slice number (QNAM = "TUSLNUM") where the skeletal muscle tissue non-target lesion (TULNKID = "NT02") was identified.
Row 6: Shows that the presentation of the disease in the pericardium is effusion, i.e., for the non-target site in the pericardium (TULNKID = "NT03"), the QVAL is "EFFUSION".


Dataset2


Row RowSTUDYIDRDOMAINUSUBJIDIDVARIDVARVALQNAMQLABELQVALQORIG
1EX77777TU90007TUSEQ3TUPRTYPTumor Presentation TypeLEPTOMENINGEAL DISEASECRF
2EX77777TU90007TUSEQ3TUPLOMSRPlane of MeasurementSAGITTALCRF
3EX77777TU90007TUSEQ3TUSLNUMSlice Number55CRF
4EX77777TU90007TUSEQ4TUPLOMSRPlane of MeasurementSAGITTALCRF
5EX77777TU90007TUSEQ4TUSLNUMSlice Number88-91CRF
6EX77777TU90007TUSEQ4TUPRTYPTumor Presentation TypeEFFUSIONCRF



...

Dataset wrap


Rowcaps

Rows 1-3: Show the Target Response (RSTESTCD = "TRGRESP"), Non-Target Response (RSTESTCD = "NTRGRESP") and Overall Response (RSTESTCD = "OVRLRESP") at week 12. The Target Response of partial response (PR)  is is based on the Percent Change From Baseline in Sum of Diameter (PCBSD) of -59%. The Non-Target Response of stable disease (SD) is based on the judgement of the non-target lesions/tumors taken collectively. In this case at week 12, one of the non-targets is absent and one of the non-targets has enlarged from nadir. The Overall Response is partial response (PR).

Rows 4-6: Show the Target Response (RSTESTCD = "TRGRESP"), Non-Target Response (RSTESTCD = "NTRGRESP") and Overall Response (RSTESTCD = "OVRLRESP") at week 24. The Target Response of complete response (CR) is based on the Percent Change From Baseline in Sum of Diameter (PCBSD) of -100%. The Non-Target Response of stable disease (SD) is based on the judgement of the non-target lesions/tumors taken collectively. In this case at week 24, one of the non-targets is absent and one of the non-targets is still present. The Overall Response is partial response (PR).


Dataset2


RowSTUDYIDDOMAINUSUBJIDRSSEQRSLNKGRPRSTESTCDRSTESTRSCATRSORRESRSSTRESCRSNAMRSEVALRSEVALIDEPOCHVISITNUMVISITRSDTCRSDY
1EX01010RS900101
TRGRESPTarget ResponseRECIST 1.1PRPRRADIOL. INC.INDEPENDENT ASSESSORRADIOLOGISTTREATMENT20WEEK 122010-03-2985
2EX01010RS900102
NTRGRESPNon-Target ResponseRECIST 1.1SDSDRADIOL. INC.INDEPENDENT ASSESSORRADIOLOGISTTREATMENT20WEEK 122010-03-2985
3EX01010RS900103R-A2OVRLRESPOverall ResponseRECIST 1.1PRPRRADIOL. INC.INDEPENDENT ASSESSORRADIOLOGISTTREATMENT20WEEK 122010-03-2985
4EX01010RS900104
TRGRESPTarget ResponseRECIST 1.1CRCRRADIOL. INC.INDEPENDENT ASSESSORRADIOLOGISTTREATMENT30WEEK 242010-06-23171
5EX01010RS900105
NRGRESPNon-Target ResponseRECIST 1.1SDSDRADIOL. INC.INDEPENDENT ASSESSORRADIOLOGISTTREATMENT30WEEK 242010-06-23171
6EX01010RS900106R-A3OVRLRESPOverall ResponseRECIST 1.1PRPRRADIOL. INC.INDEPENDENT ASSESSORRADIOLOGISTTREATMENT30WEEK 242010-06-23171



...

Dataset wrap
Nametu


Rowcaps

Rows 1-3: Shows Show a subject with 1 target lesion with TULNKID "R-T01" and 2 non-target lesions/sites with TULNKID "R-NT01" and "R-NT02" identified at screening. "T01" is located in the "LIVER", "R-NT01" is also located in the liver and "R-NT02" is located in the "CHEST WALL".


Dataset2


RowSTUDYIDDOMAINUSUBJIDTUSEQTULNKIDTUTESTCDTUTESTTUORRESTUSTRESCTUNAMTULOCTUMETHODTUEVALTUEVALIDEPOCHVISITNUMVISITTUDTCTUDY
1EX01010TU900101R-T01TUMIDENTTumor IdentificationTARGETTARGETRADIOL. INC.LIVERCT SCANINDEPENDENT ASSESSORRADIOLOGISTSCREEN10SCREENING2010-01-02-2
2EX01010TU900102R-NT01TUMIDENTTumor IdentificationNON-TARGETNON-TARGETRADIOL. INC.LIVERCT SCANINDEPENDENT ASSESSORRADIOLOGISTSCREEN10SCREENING2010-01-02-2
3EX01010TU900103R-NT02TUMIDENTTumor IdentificationNON-TARGETNON-TARGETRADIOL. INC.CHEST WALLCT SCANINDEPENDENT ASSESSORRADIOLOGISTSCREEN10SCREENING2010-01-02-2



...

Dataset wrap
Nametr


Rowcaps

Rows 1-4: Show the measurements of the "R-T01" target tumor in the "LIVER" and the assessments of the 2 non-Target lesions/sites "R-NT01" and "R-NT02" in the "LIVER" and "CHEST WALL" at screening.

Rows 5-11: Show the measurement of the "R-T01" target tumor and the tumor states of "R-NT01" and "R-NT02" non-targets at week 12. "R-T01" showed a  show a decrease from 17mm at baseline to 7mm which is a Percent Change From Baseline in Sum of Diameter (PCBSD) of -59%. "R-NT01" has a TUMSTATE = "ABSENT" and "R-NT02" has a TUMSTATE = "ENLARGEMENT FROM NADIR". 

Rows 12-18: Show the measurement of the "R-T01" target tumor and the tumor states of "R-NT01" and "R-NT02" non-targets at week 24. "R-T01"  was absent is absent (LDIAM = "0") which is a Percent Change From Baseline in Sum of Diameter (PCBSD) of -100%. "R-NT01" remained TUMSTATE = "ABSENT" and "R-NT02" has a TUMSTATE = "PRESENT".


Dataset2


RowSTUDYIDDOMAINUSUBJIDTRSEQTRGRPIDTRLNKGRPTRLNKIDTRTESTCDTRTESTTRORRESTRORRESUTRSTRESCTRSTRESNTRSTRESUTRNAMTRMETHODTREVALTREVALIDEPOCHVISITNUMVISITTRDTCTRDY
1EX01010TR900101TARGETR-A1R-T01LDIAMLongest Diameter17mm1717mmRADIOL. INC.CT SCANINDEPENDENT ASSESSORRADIOLOGISTSCREEN10SCREENING2010-01-02-2
2EX01010TR900102TARGETR-A1
SUMDIAMSum of Diameter17mm1717mmRADIOL. INC.
INDEPENDENT ASSESSORRADIOLOGISTSCREEN10SCREENING

3EX01010TR900103NON-TARGETR-A1R-NT01TUMSTATETumor StatePRESENT
PRESENT

RADIOL. INC.CT SCANINDEPENDENT ASSESSORRADIOLOGISTSCREEN10SCREENING2010-01-02-2
4EX01010TR900104NON-TARGETR-A1R-NT02TUMSTATETumor StatePRESENT
PRESENT

RADIOL. INC.CT SCANINDEPENDENT ASSESSORRADIOLOGISTSCREEN10SCREENING2010-01-02-2
5EX01010TR900105TARGETR-R-A2R-T01LDIAMLongest Diameter7mm77mmRADIOL. INC.CT SCANINDEPENDENT ASSESSORRADIOLOGISTTREATMENT20WEEK 122010-03-2985
6EX01010TR900106TARGETR-A2
SUMDIAMSum of Diameter7mm77mmRADIOL. INC.
INDEPENDENT ASSESSORRADIOLOGISTTREATMENT20WEEK 12

7EX01010TR900107TARGETR-A2
ACNSDAbsolute Change From Nadir in Sum of Diameter-10mm-10-10mmRADIOL. INC.
INDEPENDENT ASSESSORRADIOLOGISTTREATMENT20WEEK 12

8EX01010TR900108TARGETR-A2
PCBSDPercent Change From Baseline in Sum of Diameter-59%-59-59%RADIOL. INC.
INDEPENDENT ASSESSORRADIOLOGISTTREATMENT20WEEK 12

9EX01010TR900109TARGETR-A2
PCNSDPercent Change From Nadir in Sum of Diameter-59%-59-59%RADIOL. INC.
INDEPENDENT ASSESSORRADIOLOGISTTREATMENT20WEEK 12

10EX01010TR9001010NON-TARGETR-A2R-NT01TUMSTATETumor StateABSENT
ABSENT

RADIOL. INC.CT SCANINDEPENDENT ASSESSORRADIOLOGISTTREATMENT20WEEK 122010-03-2985
11EX01010TR9001011NON-TARGETR-A2R-NT02TUMSTATETumor StateENLARGEMENT FROM NADIR
ENLARGEMENT FROM NADIR

RADIOL. INC.CT SCANINDEPENDENT ASSESSORRADIOLOGISTTREATMENT20WEEK 122010-03-2985
12EX01010TR9001012TARGETR-A3R-T01LDIAMLongest Diameter0mm00mmRADIOL. INC.CT SCANINDEPENDENT ASSESSORRADIOLOGISTTREATMENT30WEEK 242010-06-23171
13EX01010TR9001013TARGETR-A3
SUMDIAMSum of Diameter0mm00mmRADIOL. INC.
INDEPENDENT ASSESSORRADIOLOGISTTREATMENT30WEEK 24

14EX01010TR9001014TARGETR-A3
ACNSDAbsolute Change From Nadir in Sum of Diameter-17mm-17-17mmRADIOL. INC.
INDEPENDENT ASSESSORRADIOLOGISTTREATMENT30WEEK 24

15EX01010TR9001015TARGETR-A3
PCBSDPercent Change From Baseline in Sum of Diameter-100%-100-100%RADIOL. INC.
INDEPENDENT ASSESSORRADIOLOGISTTREATMENT30WEEK 24

16EX01010TR9001016TARGETR-A3
PCNSDPercent Change From Nadir in Sum of Diameter-100%-100-100%RADIOL. INC.
INDEPENDENT ASSESSORRADIOLOGISTTREATMENT30WEEK 24

17EX01010TR9001017NON-TARGETR-A3R-NT01TUMSTATETumor StateABSENT
ABSENT

RADIOL. INC.CT SCANINDEPENDENT ASSESSORRADIOLOGISTTREATMENT30WEEK 242010-06-23171
18EX01010TR9001018NON-TARGETR-A3R-NT02TUMSTATETumor StatePRESENT
PRESENT

RADIOL. INC.CT SCANINDEPENDENT ASSESSORRADIOLOGISTTREATMENT30WEEK 242010-06-23171



...

The following table contains additional standard name codes for use in the Supplement Qualifiers for SUPPRS, SUPPTU and SUPPPR datasets.

Dataset wrap
Namesuppqual


QNAMRDOMAINQLABELTYPECODELISTROLE
RSREASNERSReason Response Not EvaluabletextFree text from CRF

Non-Standard Record Qualifier

TUPRVIR

TUPreviously Irradiated IndicatortextNY

Non-Standard Record Qualifier

TUPRVIRPTUPreviously Irradiated ProgressiontextNY

Non-Standard Record Qualifier

TUPRTYPTUTumor Presentation TypetextDSPRTYP

Non-Standard Record Qualifier

TULOCDTLTULocation DetailtextFree text from CRF

Non-Standard Record Qualifier

TUSLNUMTUSlice NumbertextFree text from CRF

Non-Standard Record Qualifier

TUPLOMSRTUPlane of MeasurementtextFree text from CRF

Non-Standard Record Qualifier

PRLOC1PRLocation of Procedure 1textLOC

Non-Standard Record Qualifier

PRLOC2PRLocation of Procedure 2textLOC

Non-Standard Record Qualifier

PRSLTHKPRSlice ThicknesstextFree text from CRF

Non-Standard Record Qualifier

PROIQPROverall Image QualitytextFree text from CRF

Non-Standard Record Qualifier


End of Document

Info

To set up your dataset wrapper, row caption, dataset combination when in edit mode:

  • Type "{dataset" (no quotes)
  • Choose "Dataset Wrapper" and hit return.  
  • Then place your cursor in the grey box, type "{row" (no quotes) and choose "Row Captions" and hit return.  
  • Finally place the cursor below that box and do the same with "{dataset" and clicking "Dataset".

Now you can select your table from Excel, copy, and then paste (control v) into the dataset box. To be sure there are no extraneous formats, if you click the grey bar at the top of the dataset macro, it will select all of the data in the table. You can now go to the top of the edit window, click on the down arrow by the A and click "Clear formatting" to clean up the table.

Feel free to delete this info box whenever you'd like (smile)

...