Release 6.1.1—Summary of changes

Changes to conceptual information

Changes to conceptual information

Topic	Description
Column naming conventions for RD views	Added a note that the special characters *_-()/",+%@#$&!~\|{}[]<>:;?\** are removed from each study object RefName before it is appended with the appropriate suffix. Changed the naming convention for the control name of the blank item in a Repeating Data itemset from IB_<controlname> to <controlrefname>_IB. This change was made in release 6.0, but was not added to the document.

Changes to tables and views

Changes to tables and views

Table or view name	Description
Added column(s)
IRV_STUDYVERSION_VISITS	Added the MAXTABS column.
IRV_SECTION_REVS	Added the following columns: INITIALROWCOUNT ROWCOUNTFIXED
IRV_MD_FORMS_CONTROLS	Added the following columns: CHILDITEMORDER CHILD5ID CHILD5REV CHILD5ORDER CHILD5SELECT
IRV_CUR_SUBJECT	Added the SDVSELECTEDSTATE column.
IRV_CUR_USER	Added the following columns: USERMINACTIVESTATETIME USERMINDELETESTATETIME
IRV_SV_SUBJECTVISITS	Added the SUBJECTVISITREV column.
IRV_SV_SUBJECT_FORMS	Added the following columns: VISITORDER VISITTYPE
IRV_FORM_ITEMS	Added the following columns: ITEMSETINDEXORDINAL SDVSELECTEDSTATE
IRV_CUR_COMMENT	Added the following columns: VISITIDX FORMIDX ITEMSETIDX
IRV_CUR_QUERY	Added the VISITSTUDYVERSIONID column.
IRV_AF_ROLLUP_VISITS	Added the SUBJECTVISITID column.
IRV_IC_ROLLUP_FORMS	Added the SUBJECTVISITID column.
RT_ELEMENTLABELS	Added the following columns: ELEMENTID CHILDELEMENTORDER
RT_CONTROLDATA	Added the following columns: SUBJECTVISITID TRANSACTIONID LASTENTEREDDATE ENTEREDBY ENTEREDREASON SDVTIME STATE ITEMSTATE CONTROLVALUE BLANK COUNTCANDIDATEQUERIES
RT_NOTDONE_CONTROL	Added the NDLABELRESOURCEID column.
RT_ITEMSTATE	Added the QREISSUED column.
Deleted column(s)
IRV_MD_FORMS_CONTROLS	Removed the second instance of the SECTIONID column.
RT_USER_BLINDED_ITEMS	Removed the ITEMREV column.
IRV_SV_SUBJECTVISITS	Removed the following columns: STUDYID SUBJECTVISITREV
IRV_SV_SUBJECT_FORMS	Removed the STUDYID column.
IRV_CRF_STATUS_REPORT	Removed the following columns: STUDYID ACTUALFORM DELETEDDYNAMICFORMSTATE
IRV_FORM_ITEMS	Removed the following columns: STUDYID ITEMSDVCRITICAL
IRV_AF_ROLLUP_VISITS	Removed the CSVROWID column.
IRV_IC_ROLLUP_SITES	Removed the ITEMSDELETED column.
IRV_IC_ROLLUP_STUDY	Removed the ITEMSDELETED column.
IRV_IC_ROLLUP_STUDYVERSIONS	Removed the ITEMSDELETED column.
IRV_IC_ROLLUP_SUBJECTS	Removed the ITEMSDELETED column.
IRV_IC_ROLLUP_VISITS	Removed the ITEMSDELETED column.
RT_ELEMENTLABELS	Removed the following columns: CREATEDBYUSERID CREATEDBYDATETIME MODIFIEDBYUSERID MODIFIEDBYDATETIME
RT_UNITS	Removed the following columns: CREATEDBYUSERID CREATEDBYDATETIME MODIFIEDBYUSERID MODIFIEDBYDATETIME
RT_CONTROLDATA	Removed the ITEMDELETED column.
RT_ACTIVATED_FORMS	Removed the SUBJECTVISITID column.
Column order changes
IRV_STUDYVERSION_FORMS	Moved EXPECTINGALTFORM above ALTFORM.
IRV_MD_FORMS_CONTROLS	Moved SECTIONITEMORDER (PK) from below ITEMREV.
IRV_MD_FORMS_CONTROLS	Moved the following columns from below CC_CONTROLREV: CHILDDEPTH CHILDORDER CHILDSELECT
IRV_CUR_USER	Moved USERLANGID from below USERIMAGEID.
IRV_SV_SUBJECT_FORMS	Moved FORMHISTORYTIME from below USERID.
IRV_CRF_STATUS_REPORT	Moved SUBJECTSTATE from below SUBJECTNUMBERSTR.
IRV_FORM_ITEMS	Moved STUDYVERSIONID from below SUBJECTID.
IRV_FORM_ITEMS	Moved FORMSECTIONORDER from below SECTIONREV.
IRV_FORM_ITEMS	Moved the following column from below ITEMREV: SECTIONITEMORDER ITEMSETITEMORDER
IRV_CUR_QUERY	Moved the following columns from below INFORMPARTIALURLQUERY: QORIGUSER QSTATUSTIME QDAYSINSTATE
IRV_CUR_QUERY	Moved the following columns to the end of the view: FIRSTREISSUEDTEXT LASTREISSUEDTEXT FIRSTCANDIDATETEXT LASTCANDIDATETEXT FIRSTOPENEDTEXT LASTOPENEDTEXT FIRSTANSWEREDTEXT LASTANSWEREDTEXT FIRSTCLOSEDTEXT LASTCLOSEDTEXT FIRSTDELETEDTEXT LASTDELETEDTEXT
IRV_IC_ROLLUP_FORMS	Moved SUBJECTFORM from the first column in the view.
RT_CONTROLDATA	Moved BLOBVALUE from below STRVALUE.
RT_ACTIVATED_FORMS	Re-ordered all columns to match the order in the database.
RT_MD_VIEWDICTIONARY	Re-ordered all columns to match the order in the database.
Other changes
IRV_MD_FORMS_CONTROLS	The prefix for the following columns was changed to I_, rather than CI_: I_ITEMTYPE I_ITEMLAYOUT I_ITEMQUESTION I_ITEMLABEL I_CALCULATED I_SDVREQUIRED I_RANDOMIZE I_ITEMREQUIRED I_ITEMREFNAME I_ITEMHELPURL I_DISPLAYOVERRIDE I_ITEMDESIGNNOTE
IRV_CUR_RULE	Added the following rule types for the SCRIPTTYPE column: 10 - Workflow rule 11 - GlobalCondition rule 12 - Server or Calc, or Rand or WF or GF rule
IRV_CUR_RULEITEM	Added the DEPENDOR rule dependency type for the APPLYEVENT column.
IRV_FORM_ITEMS	Renamed ITEMBLANK to BLANK.