Instructions are provided below for preparing batch files for both Complete and Abbreviated studies.
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.
Each CTRP batch text file contains accrual data for a single study. 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 Studies.
Accruals for National studies are reported directly to CTRP from CTEP and/or DCP.
Do not include the following items in Zip files that you intend to upload:
- Folders or other Zip files
- Path names. Some ZIP/compression tools provide an option to include the entire file path name when compressing a file. Path names describe the location of the file.
Initial Accrual Batch File Submission:
- The initial accrual batch file reported to CTRP will add accrual records for either Subject, Partial Subject or Summary level accrual based on the default accrual type set on the study.
Subsequent Accrual Batch File Submissions:
- For Subject or Partial Subject accrual: Subsequent accrual batch file uploads will append data.
- If there are duplicate records (all fields are the same) within the batch file being reported, the file will not be loaded and a notification will be sent to the user asking for the duplicate record(s) to be removed and the file resubmitted.
- If an element is changed, for example Study Subject Ethnicity, then the record is considered an update, not a duplicate.
- For Summary accrual: Subsequent accrual batch file uploads will replace previously reported/uploaded accrual data. Batch uploads will not append data; cumulative accrual data must be uploaded with each accrual file reported to CTRP.
- Please ensure that your CTRP accrual batch file contains all cumulative accrual data for each participating site to date before uploading to CTRP. Failure to include cumulative accrual data will result in erasing your accrual history.
To download a copy of the of the CTRP Accrual Batch File Tool (includes instructions), go to:
After you have prepared a batch file, you can upload it to CTRP. For instructions on reporting batch files, see: Uploading Accrual Batch Data Files.
Complete Study Example Batch File - Subject accrual
|
|
Complete Study Example Batch File - Partial Subject accrual
|
For Summary accrual (typically provided for Abbreviated/Imported - e.g., Industrial study), the following is an example batch file for one study with two participating sites (Sites 1 and 2) supporting monthly accrual updates. Site 1 and 2 in the below example map to "PO ID" (unique to each Participating Site).
Note: Create and report one study per batch load. You can also include individual batch load files in one zip.
Centers have the option to provide quarter, monthly accrual from study start date to present. Another option is to provide the Cut-Off Date in the batch load file. the Cut-Off Date represents the date when accrual changed (displayed in the example below).
Abbreviated/Imported (e.g., Industrial Studies) Example Batch File - Monthly
|
Abbreviated/Imported (e.g., Industrial Studies) Example Batch File - Accrual Changes
|
For additional information, refer to the following pages:
