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