NIH | National Cancer Institute | NCI Wiki  

Each line of the data file contains one record, is prefixed by the table name, and is comma delimited.

Use blank fields for those fields that are included in the CDUS standard but not used by the CTRP.


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 two participating sites supporting monthly accrual updates.  Site 1 and 2 in the below example map to "PO ID" (unique to each Participating Site).

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

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"

Special Characters

If you include any of the following characters in a value, enclose the field with double quotes:

! " # $ % & ' ( ) * +  , -  . / : ; < > = ? @ [] \^ _{} | ~

If you enclose a field with double quotes (as in "NCI-2012-00225"), CTRP interprets the string inside the quote exactly as presented. If the field does not contain any special characters, the quote marks are optional.

  • No labels