NIH | National Cancer Institute | NCI Wiki  

WIKI MAINTENANCE NOTICE

Please be advised that NCI Wiki will be undergoing maintenance Monday, July 22nd between 1700 ET and 1800 ET and will be unavailable during this period.
Please ensure all work is saved before said time.

If you have any questions or concerns, please contact the CBIIT Atlassian Management Team.

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