...
Dataset wrap |
---|
|
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 |
---|
Row | STUDYID | DOMAIN | USUBJID | TRSEQ | TRGRPID | TRLNKGRP | TRLNKID | TRTESTCD | TRTEST | TRORRES | TRORRESU | TRSTRESC | TRSTRESN | TRSTRESU | TRSTAT | TRREASND | TRMETHOD | TREVAL | EPOCH | VISITNUM | VISIT | TRDTC | TRDY | 1 | EX55555 | TR | 90005 | 1 | TARGET | A1 | T01 | LDIAM | Longest Diameter | 10 | mm | 10 | 10 | mm |
|
| CT SCAN | INVESTIGATOR | SCREEN | 1 | SCREENING | 2007-01-02 | 1 | 2 | EX55555 | TR | 90005 | 2 | TARGET | A1 |
| SUMLDIAM | Sum of Longest Diameter | 10 | mm | 10 | 10 | mm |
|
|
| INVESTIGATOR | SCREEN | 1 | SCREENING |
|
| 3 | EX55555 | TR | 90005 | 3 | TARGET | A2 | T01 | LDIAM | Longest Diameter | 0 | mm | 0 | 0 | mm |
|
| CT SCAN | INVESTIGATOR | TREATMENT | 3 | WEEK 8 | 2007-02-27 | 56 | 4 | EX55555 | TR | 90005 | 4 | TARGET | A2 | T01 | TUMSTATE | Tumor State | ABSENT |
| ABSENT |
|
|
|
| CT SCAN | INVESTIGATOR | TREATMENT | 3 | WEEK 8 | 2007-02-27 | 56 | 5 | EX55555 | TR | 90005 | 5 | TARGET | A2 |
| SUMLDIAM | Sum of Longest Diameter | 0 | mm | 0 | 0 | mm |
|
|
| INVESTIGATOR | TREATMENT | 3 | WEEK 8 |
|
| 6 | EX55555 | TR | 90005 | 6 | TARGET | A3 | T01 | LDIAM | Longest Diameter | 0 | mm | 0 | 0 | mm |
|
| CT SCAN | INVESTIGATOR | TREATMENT | 4.1 | UNCHEDULED WEEK 13 | 2007-04-03 | 91 | 7 | EX55555 | TR | 90005 | 7 | TARGET | A3 | T01 | TUMSTATE | Tumor State | ABSENT |
| ABSENT |
|
|
|
| CT SCAN | INVESTIGATOR | TREATMENT | 4.1 | UNCHEDULED WEEK 13 | 2007-04-03 | 91 | 8 | EX55555 | TR | 90005 | 8 | TARGET | A3 |
| SUMLDIAM | Sum of Longest Diameter | 0 | mm | 0 | 0 | mm |
|
|
| INVESTIGATOR | TREATMENT | 4.1 | UNCHEDULED WEEK 13 |
|
| 9 | EX55555 | TR | 90005 | 9 | TARGET | A4 | T01 | LDIAM | Longest Diameter |
|
|
|
|
| NOT DONE | NOT EVALUABLE: Motion issue | CT SCAN | INVESTIGATOR | TREATMENT | 5 | WEEK 16 | 2007-04-24 | 112 | 10 | EX55555 | TR | 90005 | 10 | TARGET | A4 | T01 | TUMSTATE | Tumor State |
|
|
|
|
| NOT DONE | NOT EVALUABLE: Motion Motion issue | CT SCAN | INVESTIGATOR | TREATMENT | 5 | WEEK 16 | 2007-04-24 | 112 | 11 | EX55555 | TR | 90005 | 11 | TARGET | A4 |
| SUMLDIAM | Sum of Longest Diameter |
|
|
|
|
| NOT DONE |
|
| INVESTIGATOR | TREATMENT | 5 | WEEK 16 |
|
| 12 | EX55555 | TR | 90005 | 12 | TARGET | A5 | T01 | LDIAM | Longest Diameter | 5 | mm | 5 | 5 | mm |
|
| CT SCAN | INVESTIGATOR | TREATMENT | 7 | WEEK 24 | 2009-06-19 | 168 | 13 | EX55555 | TR | 90005 | 13 | TARGET | A5 | T01 | TUMSTATE | Tumor State | PRESENT |
| PRESENT |
|
|
|
| CT SCAN | INVESTIGATOR | TREATMENT | 7 | WEEK 24 | 2009-06-19 | 168 | 14 | EX55555 | TR | 90005 | 14 | TARGET | A5 |
| SUMLDIAM | Sum of Longest Diameter | 5 | mm | 5 | 5 | mm |
|
|
| INVESTIGATOR | TREATMENT | 7 | WEEK 24 |
|
| 15 | EX55555 | TR | 90005 | 15 | NEW | A5 | NEW01 | TUMSTATE | Tumor State | PRESENT |
| PRESENT |
|
|
|
| CT SCAN | INVESTIGATOR | TREATMENT | 7 | WEEK 24 | 2009-06-19 | 168 |
|
|
...
Dataset wrap |
---|
|
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 Row | STUDYID | RDOMAIN | USUBJID | IDVAR | IDVARVAL | QNAM | QLABEL | QVAL | QORIG |
---|
1 | EX77777 | TU | 90007 | TUSEQ | 3 | TUPRTYP | Tumor Presentation Type | LEPTOMENINGEAL DISEASE | CRF | 2 | EX77777 | TU | 90007 | TUSEQ | 3 | TUPLOMSR | Plane of Measurement | SAGITTAL | CRF | 3 | EX77777 | TU | 90007 | TUSEQ | 3 | TUSLNUM | Slice Number | 55 | CRF | 4 | EX77777 | TU | 90007 | TUSEQ | 4 | TUPLOMSR | Plane of Measurement | SAGITTAL | CRF | 5 | EX77777 | TU | 90007 | TUSEQ | 4 | TUSLNUM | Slice Number | 88-91 | CRF | 6 | EX77777 | TU | 90007 | TUSEQ | 4 | TUPRTYP | Tumor Presentation Type | EFFUSION | CRF |
|
|
...
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 |
---|
Row | STUDYID | DOMAIN | USUBJID | RSSEQ | RSLNKGRP | RSTESTCD | RSTEST | RSCAT | RSORRES | RSSTRESC | RSNAM | RSEVAL | RSEVALID | EPOCH | VISITNUM | VISIT | RSDTC | RSDY | 1 | EX01010 | RS | 90010 | 1 |
| TRGRESP | Target Response | RECIST 1.1 | PR | PR | RADIOL. INC. | INDEPENDENT ASSESSOR | RADIOLOGIST | TREATMENT | 20 | WEEK 12 | 2010-03-29 | 85 | 2 | EX01010 | RS | 90010 | 2 |
| NTRGRESP | Non-Target Response | RECIST 1.1 | SD | SD | RADIOL. INC. | INDEPENDENT ASSESSOR | RADIOLOGIST | TREATMENT | 20 | WEEK 12 | 2010-03-29 | 85 | 3 | EX01010 | RS | 90010 | 3 | R-A2 | OVRLRESP | Overall Response | RECIST 1.1 | PR | PR | RADIOL. INC. | INDEPENDENT ASSESSOR | RADIOLOGIST | TREATMENT | 20 | WEEK 12 | 2010-03-29 | 85 | 4 | EX01010 | RS | 90010 | 4 |
| TRGRESP | Target Response | RECIST 1.1 | CR | CR | RADIOL. INC. | INDEPENDENT ASSESSOR | RADIOLOGIST | TREATMENT | 30 | WEEK 24 | 2010-06-23 | 171 | 5 | EX01010 | RS | 90010 | 5 |
| NRGRESP | Non-Target Response | RECIST 1.1 | SD | SD | RADIOL. INC. | INDEPENDENT ASSESSOR | RADIOLOGIST | TREATMENT | 30 | WEEK 24 | 2010-06-23 | 171 | 6 | EX01010 | RS | 90010 | 6 | R-A3 | OVRLRESP | Overall Response | RECIST 1.1 | PR | PR | RADIOL. INC. | INDEPENDENT ASSESSOR | RADIOLOGIST | TREATMENT | 30 | WEEK 24 | 2010-06-23 | 171 |
|
|
...
Dataset wrap |
---|
|
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 |
---|
Row | STUDYID | DOMAIN | USUBJID | TUSEQ | TULNKID | TUTESTCD | TUTEST | TUORRES | TUSTRESC | TUNAM | TULOC | TUMETHOD | TUEVAL | TUEVALID | EPOCH | VISITNUM | VISIT | TUDTC | TUDY | 1 | EX01010 | TU | 90010 | 1 | R-T01 | TUMIDENT | Tumor Identification | TARGET | TARGET | RADIOL. INC. | LIVER | CT SCAN | INDEPENDENT ASSESSOR | RADIOLOGIST | SCREEN | 10 | SCREENING | 2010-01-02 | -2 | 2 | EX01010 | TU | 90010 | 2 | R-NT01 | TUMIDENT | Tumor Identification | NON-TARGET | NON-TARGET | RADIOL. INC. | LIVER | CT SCAN | INDEPENDENT ASSESSOR | RADIOLOGIST | SCREEN | 10 | SCREENING | 2010-01-02 | -2 | 3 | EX01010 | TU | 90010 | 3 | R-NT02 | TUMIDENT | Tumor Identification | NON-TARGET | NON-TARGET | RADIOL. INC. | CHEST WALL | CT SCAN | INDEPENDENT ASSESSOR | RADIOLOGIST | SCREEN | 10 | SCREENING | 2010-01-02 | -2 |
|
|
...
Dataset wrap |
---|
|
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 |
---|
Row | STUDYID | DOMAIN | USUBJID | TRSEQ | TRGRPID | TRLNKGRP | TRLNKID | TRTESTCD | TRTEST | TRORRES | TRORRESU | TRSTRESC | TRSTRESN | TRSTRESU | TRNAM | TRMETHOD | TREVAL | TREVALID | EPOCH | VISITNUM | VISIT | TRDTC | TRDY | 1 | EX01010 | TR | 90010 | 1 | TARGET | R-A1 | R-T01 | LDIAM | Longest Diameter | 17 | mm | 17 | 17 | mm | RADIOL. INC. | CT SCAN | INDEPENDENT ASSESSOR | RADIOLOGIST | SCREEN | 10 | SCREENING | 2010-01-02 | -2 | 2 | EX01010 | TR | 90010 | 2 | TARGET | R-A1 |
| SUMDIAM | Sum of Diameter | 17 | mm | 17 | 17 | mm | RADIOL. INC. |
| INDEPENDENT ASSESSOR | RADIOLOGIST | SCREEN | 10 | SCREENING |
|
| 3 | EX01010 | TR | 90010 | 3 | NON-TARGET | R-A1 | R-NT01 | TUMSTATE | Tumor State | PRESENT |
| PRESENT |
|
| RADIOL. INC. | CT SCAN | INDEPENDENT ASSESSOR | RADIOLOGIST | SCREEN | 10 | SCREENING | 2010-01-02 | -2 | 4 | EX01010 | TR | 90010 | 4 | NON-TARGET | R-A1 | R-NT02 | TUMSTATE | Tumor State | PRESENT |
| PRESENT |
|
| RADIOL. INC. | CT SCAN | INDEPENDENT ASSESSOR | RADIOLOGIST | SCREEN | 10 | SCREENING | 2010-01-02 | -2 | 5 | EX01010 | TR | 90010 | 5 | TARGET | R-R-A2 | R-T01 | LDIAM | Longest Diameter | 7 | mm | 7 | 7 | mm | RADIOL. INC. | CT SCAN | INDEPENDENT ASSESSOR | RADIOLOGIST | TREATMENT | 20 | WEEK 12 | 2010-03-29 | 85 | 6 | EX01010 | TR | 90010 | 6 | TARGET | R-A2 |
| SUMDIAM | Sum of Diameter | 7 | mm | 7 | 7 | mm | RADIOL. INC. |
| INDEPENDENT ASSESSOR | RADIOLOGIST | TREATMENT | 20 | WEEK 12 |
|
| 7 | EX01010 | TR | 90010 | 7 | TARGET | R-A2 |
| ACNSD | Absolute Change From Nadir in Sum of Diameter | -10 | mm | -10 | -10 | mm | RADIOL. INC. |
| INDEPENDENT ASSESSOR | RADIOLOGIST | TREATMENT | 20 | WEEK 12 |
|
| 8 | EX01010 | TR | 90010 | 8 | TARGET | R-A2 |
| PCBSD | Percent Change From Baseline in Sum of Diameter | -59 | % | -59 | -59 | % | RADIOL. INC. |
| INDEPENDENT ASSESSOR | RADIOLOGIST | TREATMENT | 20 | WEEK 12 |
|
| 9 | EX01010 | TR | 90010 | 9 | TARGET | R-A2 |
| PCNSD | Percent Change From Nadir in Sum of Diameter | -59 | % | -59 | -59 | % | RADIOL. INC. |
| INDEPENDENT ASSESSOR | RADIOLOGIST | TREATMENT | 20 | WEEK 12 |
|
| 10 | EX01010 | TR | 90010 | 10 | NON-TARGET | R-A2 | R-NT01 | TUMSTATE | Tumor State | ABSENT |
| ABSENT |
|
| RADIOL. INC. | CT SCAN | INDEPENDENT ASSESSOR | RADIOLOGIST | TREATMENT | 20 | WEEK 12 | 2010-03-29 | 85 | 11 | EX01010 | TR | 90010 | 11 | NON-TARGET | R-A2 | R-NT02 | TUMSTATE | Tumor State | ENLARGEMENT FROM NADIR |
| ENLARGEMENT FROM NADIR |
|
| RADIOL. INC. | CT SCAN | INDEPENDENT ASSESSOR | RADIOLOGIST | TREATMENT | 20 | WEEK 12 | 2010-03-29 | 85 | 12 | EX01010 | TR | 90010 | 12 | TARGET | R-A3 | R-T01 | LDIAM | Longest Diameter | 0 | mm | 0 | 0 | mm | RADIOL. INC. | CT SCAN | INDEPENDENT ASSESSOR | RADIOLOGIST | TREATMENT | 30 | WEEK 24 | 2010-06-23 | 171 | 13 | EX01010 | TR | 90010 | 13 | TARGET | R-A3 |
| SUMDIAM | Sum of Diameter | 0 | mm | 0 | 0 | mm | RADIOL. INC. |
| INDEPENDENT ASSESSOR | RADIOLOGIST | TREATMENT | 30 | WEEK 24 |
|
| 14 | EX01010 | TR | 90010 | 14 | TARGET | R-A3 |
| ACNSD | Absolute Change From Nadir in Sum of Diameter | -17 | mm | -17 | -17 | mm | RADIOL. INC. |
| INDEPENDENT ASSESSOR | RADIOLOGIST | TREATMENT | 30 | WEEK 24 |
|
| 15 | EX01010 | TR | 90010 | 15 | TARGET | R-A3 |
| PCBSD | Percent Change From Baseline in Sum of Diameter | -100 | % | -100 | -100 | % | RADIOL. INC. |
| INDEPENDENT ASSESSOR | RADIOLOGIST | TREATMENT | 30 | WEEK 24 |
|
| 16 | EX01010 | TR | 90010 | 16 | TARGET | R-A3 |
| PCNSD | Percent Change From Nadir in Sum of Diameter | -100 | % | -100 | -100 | % | RADIOL. INC. |
| INDEPENDENT ASSESSOR | RADIOLOGIST | TREATMENT | 30 | WEEK 24 |
|
| 17 | EX01010 | TR | 90010 | 17 | NON-TARGET | R-A3 | R-NT01 | TUMSTATE | Tumor State | ABSENT |
| ABSENT |
|
| RADIOL. INC. | CT SCAN | INDEPENDENT ASSESSOR | RADIOLOGIST | TREATMENT | 30 | WEEK 24 | 2010-06-23 | 171 | 18 | EX01010 | TR | 90010 | 18 | NON-TARGET | R-A3 | R-NT02 | TUMSTATE | Tumor State | PRESENT |
| PRESENT |
|
| RADIOL. INC. | CT SCAN | INDEPENDENT ASSESSOR | RADIOLOGIST | TREATMENT | 30 | WEEK 24 | 2010-06-23 | 171 |
|
|
...
The following table contains additional standard name codes for use in the Supplement Qualifiers for SUPPRS, SUPPTU and SUPPPR datasets.
Dataset wrap |
---|
|
QNAM | RDOMAIN | QLABEL | TYPE | CODELIST | ROLE |
---|
RSREASNE | RS | Reason Response Not Evaluable | text | Free text from CRF | Non-Standard Record Qualifier | TUPRVIR | TU | Previously Irradiated Indicator | text | NY | Non-Standard Record Qualifier | TUPRVIRP | TU | Previously Irradiated Progression | text | NY | Non-Standard Record Qualifier | TUPRTYP | TU | Tumor Presentation Type | text | DSPRTYP | Non-Standard Record Qualifier | TULOCDTL | TU | Location Detail | text | Free text from CRF | Non-Standard Record Qualifier | TUSLNUM | TU | Slice Number | text | Free text from CRF | Non-Standard Record Qualifier | TUPLOMSR | TU | Plane of Measurement | text | Free text from CRF | Non-Standard Record Qualifier | PRLOC1 | PR | Location of Procedure 1 | text | LOC | Non-Standard Record Qualifier | PRLOC2 | PR | Location of Procedure 2 | text | LOC | Non-Standard Record Qualifier | PRSLTHK | PR | Slice Thickness | text | Free text from CRF | Non-Standard Record Qualifier | PROIQ | PR | Overall Image Quality | text | Free 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
|
...