NIH | National Cancer Institute | NCI Wiki  

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Removed release # from one or more links.

...

Tip
titleUse the Batch File Utility as a guide

If you are new to the batch file creation process, you can use the CTRP Accrual Batch File Tool to get you started. With it you can produce properly-formatted batch files that you can upload in the Accrual application.  

...

  • 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.

    Anchor
    6348
    6348

  • 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.

...

Traditional Table Structure

Column 1Column 2Column 3Column 4
Row 1-Field 1Row 1-Field 2Row 1-Field 3Row 1-Field 4
Row 2-Field 1Row 2-Field 2Row 2-Field 3Row 2-Field 4

Corresponding Comma-Delimited Structure

...

Traditional Table Structure

Column 1Column 2Column 3Column 4
Row 1-Field 1Row 1-Field 2Row 1-Field 3Row 1-Field 4
Code Block
languagenone
titleComma-Delimited Structure
Field #1,Field #2,Field #3,Field #4

...

These data elements are arranged in the following sequence:

Table NameVINMakeModelColorYear

The corresponding comma-delimited sequence is as follows:

...

A traditional table structure for these CDUS data elements and their values are shown below.

Table NameVINMakeModelColorYear
AUTOMOBILEABC-123456FordMustangBlack1965

The corresponding comma-delimited structure is as follows:

...