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.
COLLECTIONS,<Study_Identifier>,,,,,,,,, ACCRUAL_COUNT,<Study_Identifier>,<Study_Site_Identifier>,< Study_Site_Accrual_Count>,<Accrual_Count_CutOff_Date>
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: 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.
