NIH | National Cancer Institute | NCI Wiki  

Error rendering macro 'rw-search'

null

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 28 Next »

  • The Accrual batch file format is based on the CTEP Clinical Data Update System (CDUS) file format. You can obtain a copy of the CDUS Instructions and Guidelines, which explains the CDUS file format in great detail, at the CTEP web site at http://ctep.cancer.gov/protocolDevelopment/electronic_applications/cdus.htm.
  • Although the CTRP accrual batch file format is CDUS-compatible, CTRP captures a subset of all the CDUS required data elements.  Comparison of CTRP and CDUS Accrual Data Elements provides a list of all the CDUS fields with a note next to each field indicating whether CTRP captures it.

  • Different data elements are required and expected when submitting accrual data to CTRP for Complete trials (National, Externally Peer Reviewed, and Institutional) than for Abbreviated Trials (Industrial). Instructions are provided below for preparing batch files for both Complete and Abbreviated Trials.

  • A CTRP accrual batch file is a TXT (.txt) file with fields delimited (separated) by commas. The text file can be UTF-8 or ANSI-encoded.

  • Each CTRP batch text file contains accrual data for a single trial. You can compress one or more CTRP accrual batch text files into a single Zip file and then upload this Zip file into CTRP. CTRP will unzip the file and process each TXT file. Your Zip file can include batch files for both Complete and Abbreviated Trials.

  • Only Super Abstractors can upload accruals for CTEP and DCP trials in the CTRP.
  • Upload accruals for CTEP and DCP trials via CTEP CDUS batch accrual files only.

Do not include the following items in Zip files that you intend to upload:

  • Folders or other Zip files
  • Path names. Some ZIP/compression tools provide an option to include the entire file path name when compressing a file. Path names describe the location of the file.

Initial Accrual Batch File Submission: 

  • The initial accrual batch file submitted to CTRP will add accrual records for either Summary Level Accrual or Subject Level Accrual based on the selection.

Subsequent Accrual Batch File Submissions:  

  • For Summary Level Accrual (typically provided for Abbreviated/Imported - e.g., Industrial trials), subsequent accrual batch file uploads will replace previously submitted/uploaded accrual data.  Batch uploads will not append data; cumulative accrual data must be uploaded with each accrual file submitted to CTRP.  
    • Please ensure that your CTRP accrual batch file contains all cumulative accrual data for each participating site to date before uploading to CTRP.  Failure to include cumulative accrual data will result in erasing your accrual history.
  • For Subject Level Accrual (typically provided for Complete trials), subsequent accrual batch file uploads will append data.   
    • If there are duplicate records (all fields are the same), the file will not be loaded and a notification will be sent to the user asking for the duplicate record(s) to be removed and the file resubmitted.  
    • If an element is changed, for example Gender, then the record is considered an update not a duplicate.

To download a copy of the of the CTRP Accrual Batch File Tool (includes instructions), go to:

CTRP Accrual Batch File Tool

For Summary Level Accrual (typically provided for Abbreviated/Imported - e.g., Industrial trials), the following is an example batch file for one trial with one participating site supporting monthly accrual updates.  

Note:  Create and submit one trial per batch load.  You can also include individual batch load files in one zip. 

Abbreviated/Imported (e.g., Industrial Trials) Example Batch File

COLLECTIONS,<Study_Identifier>,,,,,,,,,

"ACCRUAL_COUNT","NCI-2017-00225","Site 1","2","20170630"
"ACCRUAL_COUNT","NCI-2017-00225","Site 1","2","20170731"
"ACCRUAL_COUNT","NCI-2017-00225","Site 1","4","20170831"
"ACCRUAL_COUNT","NCI-2017-00225","Site 1","5","20170930"
"ACCRUAL_COUNT","NCI-2017-00225","Site 1","6","20171031"
"ACCRUAL_COUNT","NCI-2017-00225","Site 1","10","20171130"
"ACCRUAL_COUNT","NCI-2017-00225","Site 1","12","20171231"
"ACCRUAL_COUNT","NCI-2017-00225","Site 1","15","20180131"
"ACCRUAL_COUNT","NCI-2017-00225","Site 1","15","20180228"
"ACCRUAL_COUNT","NCI-2017-00225","Site 1","18","20180331"
"ACCRUAL_COUNT","NCI-2017-00225","Site 1","18","20180430"
"ACCRUAL_COUNT","NCI-2017-00225","Site 1","18","20180531"
"ACCRUAL_COUNT","NCI-2017-00225","Site 1","21","20180630"
"ACCRUAL_COUNT","NCI-2017-00225","Site 1","21","20180731"
"ACCRUAL_COUNT","NCI-2017-00225","Site 1","25","20180831"

"ACCRUAL_COUNT","NCI-2017-00225","Site 2","1","20170630"
"ACCRUAL_COUNT","NCI-2017-00225","Site 2","1","20170731"
"ACCRUAL_COUNT","NCI-2017-00225","Site 2","5","20170831"
"ACCRUAL_COUNT","NCI-2017-00225","Site 2","5","20170930"
"ACCRUAL_COUNT","NCI-2017-00225","Site 2","8","20171031"
"ACCRUAL_COUNT","NCI-2017-00225","Site 2","9","20171130"
"ACCRUAL_COUNT","NCI-2017-00225","Site 2","13","20171231"
"ACCRUAL_COUNT","NCI-2017-00225","Site 2","13","20180131"
"ACCRUAL_COUNT","NCI-2017-00225","Site 2","14","20180228"
"ACCRUAL_COUNT","NCI-2017-00225","Site 2","18","20180331"
"ACCRUAL_COUNT","NCI-2017-00225","Site 2","22","20180430"
"ACCRUAL_COUNT","NCI-2017-00225","Site 2","30","20180531"
"ACCRUAL_COUNT","NCI-2017-00225","Site 2","31","20180630"
"ACCRUAL_COUNT","NCI-2017-00225","Site 2","32","20180731"
"ACCRUAL_COUNT","NCI-2017-00225","Site 2","33","20180831"

For additional information, refer to the following pages:

  • No labels