STANDARD Mask Format

The STANDARD mask is the format used by default when a new data file is created.

The following table lists the expected order of column values for each record, with the first ten characters (1-10) allotted to the first column value, the second ten characters (11-20) allotted to the second column value, and so on. Certain columns are mandatory.

Table 7-1 Default Batch Data Load Fields

Name	Position/Type	Description	Mandatory?
Investigator	01:10 CHAR	Investigator	No
Site	11:20 CHAR	Site	No
patient	21:30 CHAR	Patient	Yes
document_number	31:50 CHAR	Document Number: Leave document _number blank if your location uses document number derivation (see "User-Defined Identifier Handling" in the Oracle Clinical Application Programming Interface Guide). Otherwise, leaving it blank causes errors loading multiple DCMs/DCIs at once. If given, document number is used even with the document number derivation defined.	No
clin_plan_event_name	51:70 CHAR	Clinical Planned Event	Yes
subevent_number	71:72 NUM	Subevent Number *This column is mandatory if there is no value for dci_date.	No*
dci_date	73:80 CHAR	Visit Date (YYYYMMDD): dci_date = dcm_date, and dci_time = dcm_time; if dci_time= null, both dci_time and dcm_time = null. Note: Do not enter zero to represent an unknown part of the date (for example, 20110000). Instead, leave the date partial (for example, 2011). *This column is mandatory if there is no value for subevent_number.	No*
dci_time	81:86 CHAR	Time of Visit (HHMMSS)	No
dci_name	87:116 CHAR	DCI Name	Yes
dcm_name	117:132 CHAR	DCM Name	Yes
dcm_subset_name	133:140 CHAR	DCM Subset Name	Yes
dcm_question_grp_name	141:170 CHAR	Question Group Name	No
dcm_question_name	171:190 CHAR	Question Name Note: Before adding a question, make sure that it is not derived. You can check by navigating to Glib, Questions, and then Questions and querying for the question.	Yes
dcm_que_occ_sn	191:193 NUM	Question Occurrence Sequence Number (0 if none)	Yes
repeat_sn	194:196 NUM	Repeat Sequence Number (1 if no repeats)	Yes
value_text	197:396 CHAR	Value Text for the question. If the question has a default value, repeating or non-repeating, provide user data here if it is not provided.	No
data_comment_text	397:596 CHAR	Data Comment Text	No
qualifying_value	597:666 CHAR	Qualifying Question Value Text, if applicable. Qualifying value is mandatory if required by DCM definition; it is ignored otherwise.	No
Study	667:681 CHAR	Study	No