This section provides general background information about batch file structure. Subsequent sections provide specific details about the Accrual batch file structure.
Each line of text in a batch file corresponds to one record that consists of various required or optional data elements. Each data element is separated by a comma.
Traditional Table Structure
Column 1 | Column 2 | Column 3 | Column 4 |
---|---|---|---|
Row 1-Field 1 | Row 1-Field 2 | Row 1-Field 3 | Row 1-Field 4 |
Row 2-Field 1 | Row 2-Field 2 | Row 2-Field 3 | Row 2-Field 4 |
Corresponding Comma-Delimited Structure
Field 1,Field 2,Field 3,Field 4 Field 1,Field 2,Field 3,Field 4
The number of fields in a row is dictated by the number of fields required in a CTRP or CDUS record. The Complete Trial Table and Abbreviated Trial Table indicate how many fields are required in each CDUS record, and how many are required in a CTRP record. The batch file must contain values or place holders (commas) equal to the number of required fields corresponding to the CDUS format. Leave fields that are not required by CTRP blank, but keep the commas to indicate the "missing" field values.
For example, if a CDUS record requires six fields, as shown below, and the CTRP record requires only three, use commas to indicate the "missing" values.
CDUS Field 1,CDUS Field 2,CDUS Field 3,CDUS Field 4,CDUS Field 5,CDUS Field 6
CTRP Field 1,CTRP Field 2,,,,CTRP Field 6
In a traditional table grid structure, the column headings indicate the order in which the field values occur. In CTRP batch files, the column heading is implicit, and the field order is sequential from left to right, beginning at Field 1.
Traditional Table Structure
Column 1 | Column 2 | Column 3 | Column 4 |
---|---|---|---|
Row 1-Field 1 | Row 1-Field 2 | Row 1-Field 3 | Row 1-Field 4 |
Field #1,Field #2,Field #3,Field #4
The first field in each record is reserved for the table name, which is always in CAPITAL letters. The exact field number for each data element is provided in the Complete Trial Record Data Field Requirements and Abbreviated Trial Record Data Field Requirements tables.
Example - Using Automobiles Instead of Patients
Suppose CDUS stores information about cars (rather than accrued patients) in its database in a table called AUTOMOBILES.
In this example, CDUS records each of the following six data elements:
- Table Name
- VIN (Vehicle Identification Number)
- Make
- Model
- Color
- Year
These data elements are arranged in the following sequence:
Table Name | VIN | Make | Model | Color | Year |
---|
The corresponding comma-delimited sequence is as follows:
<AUTOMOBILE>,<vin>,<make>,<model>,<color>,<year>
A traditional table structure for these CDUS data elements and their values are shown below.
Table Name | VIN | Make | Model | Color | Year |
---|---|---|---|---|---|
AUTOMOBILE | ABC-123456 | Ford | Mustang | Black | 1965 |
The corresponding comma-delimited structure is as follows:
AUTOMOBILE,ABC-123456,Ford,Mustang,Black,1965
And, to extend this example, suppose that CTRP does not capture the Model nor Color of the car. In this case, the final record in the CTRP batch file would be as follows:
AUTOMOBILE,ABC-123456,Ford,,,1965