RD_VIEWNAME

Name of the RD view:

• If the form does not contain any itemsets, RD_<FormRefName>.
• If the form contains one or more itemsets, RD_<FormRefName_ItemsetRefName>.
• If the form contains one or more itemsets, and the itemsets do not have RefNames, RD_<FormRefName>_<Count>.

  RD view names are truncated to 30 characters. If duplicate RD view names exist, each view is assigned the name that corresponds to the value in the TABLENAME column in the view, prefixed with RD_. If the value in the TABLENAME column includes a prefix, the prefix is removed, and replaced with RD_.

  For example, if two views named RD_AdverseEvent exist, one might be named RD_AE, and the other might be named RD_AdverseEvent.

  Note: When you migrate to the InForm 6.3 release, names of truncated RD views may change.

RD_COLUMNNAME

Column name, truncated and appended with the following, where appropriate, so that the column name contains a maximum of 30 characters.

• _DTS—Datetime string in ISO format.
• _TMS—Time string in ISO format.
• _DTR—Date time as entered, including UNK and NUL.
• _TMR—Time as entered, including UNK and NUL.
• _N—Normalized item.
• _NU—Normalized unit.
• _U—Unit item.
• _C—Code item.
• _ND—Not done item.

  For more information about column naming conventions for RD views, see Column naming conventions for RD views.

RD_RAWCOLUMN

Untruncated RD column name.

TABLENAME

Clinical table name.

COLUMNNAME

Clinical column name. The logic used to build this column name is described in the clinical table description.

COLUMNTYPE

Generated column type:

1 - COLTYPE_TEXTFLOAT

2 - COLTYPE_TEXTNUM

3 - COLTYPE_TEXTSTR

4 - COLTYPE_TEXTBLOB

5 - COLTYPE_DATE

6 - COLTYPE_MONTHYEAR

7 - COLTYPE_DATESTR

8 - COLTYPE_TIME_HM

9 - COLTYPE_TIME_HMS

10 - COLTYPE_TIMESTR

11 - COLTYPE_YEAR

12 - COLTYPE_MONTH

13 - COLTYPE_UNITNORMALIZED

14 - COLTYPE_UNITCODE

15 - COLTYPE_UNITLABEL

16 - COLTYPE_CHILDSELCODE

17 - COLTYPE_CHILDSELLABEL

18 - COLTYPE_VISITINDEX

19 - COLTYPE_FORMINDEX

20 - COLTYPE_ITEMINDEX

21 - COLTYPE_DOV

22 - COLTYPE_DELETEDFORM

23 - COLTYPE_DELETEDITEM

24 - COLTYPE_ITEMNOTDONEREASON

25 - COLTYPE_FORMMNEMONIC

26 - COLTYPE_VISITMNEMONIC

27 - COLTYPE_VISITORDER

28 - COLTYPE_SUBJECTINITIALS

29 - COLTYPE_SITENAME

30 - COLTYPE_SITEMNEMONIC

31 - COLTYPE_SITECOUNTRY

32 - COLTYPE_SUBJECTNUMBERSTR

33 - COLTYPE_FORMFIRSTDATE

34 - COLTYPE_FORMLASTDATE

COLUMNORDER

Relative order of the column in the RD view.

FORMREFNAME

Form RefName.

SECTIONREFNAME

Section RefName.

ITEMREFNAME

Item RefName.

CHILDITEMREFNAME

Child item RefName (for itemsets).

CTL0REFNAME

Top-level control RefName.

CTL1REFNAME

Second-level control RefName.

CTL2REFNAME

Third-level control RefName.

CTL3REFNAME

Fourth-level control RefName.

CTL4REFNAME

Fifth-level control RefName.

RAWCOLUMNNAME

Untruncated column name.

COLUMNDBTYPE

Generated DB column type:

1 - String

2 - Integer

3 - Float

4 - Datetime

COLUMNVALUEREFNAME

• If the column uses a list of pre-defined values, the value RefName.
• For Units, the unit RefName.
• For a radio or checkbox control, the child control RefName.
• For a drop-down list, the element RefName.

COLUMNFLOATPRECISION

Column precision. Used only for Float text controls and is NULL for all other columns.

0 - Unlimited precision.

n - Number of decimal places for the precision.

FORMNAME

Form name.

SECTIONHEADER

Section header.

ITEMQUESTION

Item question.

CONTROLCAPTION

Control caption.

SECTIONORDER

Order of the section on the form.

ITEMORDER

Order of the item within a section on the form.

CHILDITEMORDER

Order of the child item in the itemset.

VIEWLABEL

Report topic name.

VIEWDESC

Report topic description, from the form description.

COLUMNFOLDER

Report topic folder. Only one of the three predefined folders is allowed:

• Basic Data
• Additional Data
• Incomplete Data Reasons

COLUMNENABLE

If value is zero, this column is suppressed from the clinical table and clinical query subject.

COLUMNLABEL

Corresponding Cognos model report topic item name.

COLUMNDESC

Corresponding Cognos model report topic item description.

COLUMNVALUE

Column value. One of the set of values pertain to the clinical view column/clinical report topic item.

SASDATASETNAME

Null value. Reserved for future use.

SASFIELDNAME

SDSDOMAIN

SDSVARNAME

FORMTYPE

Form type:

1 - CRF

3 - Enrollment

4 - Custom

5 - Custom study

6 - Custom Admin

7 - Custom Rules

8 - Custom Auth

101 - Monitor Regdoc

102 - Monitor Visit Report

ITEMSET

Indicates whether an item is part of an itemset.

0 - The item is not part of an itemset.

1 - The item is part of an itemset.

CONTROLTYPE

Control type:

1 - ELEMENTTYPE

2 - PULLDOWNTYPE

5 - TEXTBOXTYPE

6 - CALCULATIONTYPE

7 - CONTROLGROUPTYPE

8 - RADIOGROUPTYPE

9 - CHECKBOXGROUPTYPE

10 - DATETIMETYPE

CH0TYPE

Control type of the top-level control.

CH1TYPE

Control type of the second-level control.

CH2TYPE

Control type of the third-level control.

CH3TYPE

Control type of the fourth-level control.

CH4TYPE

Control type of the fifth-level control.

REPEATINGVISIT

Indicates whether the visit is repeating.

0 - Visit is not repeating.

1 - Visit is repeating.

REPEATINGFORM

Indicates whether the form is repeating.

0 - Form is not repeating.

1 - Form is repeating.

REPEATINGITEM

Indicates whether the item is repeating.

0 - Item is not repeating.

1 - Item is repeating.

FORMID

DBUID for the form.

FORMREV

Revision number for the form.

SECTIONID

DBUID for the section.

ITEMID

DBUID for the item.

CHILDITEMID

DBUID for the child item in an itemset.

CONTROLID

DBUID for the control.

CONTROLREV

Revision number for the control.

CONTROLREFNAME

Control RefName.

CID0

DBUID for the top-level nested control.

CID1

DBUID for the second-level nested control.

CID2

DBUID for the third-level nested control.

CID3

DBUID for the fourth-level nested control.

CID4

DBUID for the fifth-level nested control.

SECORD

Order of the section on the form.

ITEMORD

Order of the item in the section.

CHILDITEMORD

Order of the child item in the itemset.

CONTROLDEPTH

Depth of nesting for the control.

CH1ORD

Order of the first-level child item.

CH2ORD

Order of the second-level child item.

CH3ORD

Order of the third-level child item.

CH4ORD

Order of the fourth-level child item.

FORMMNEMONIC

Mnemonic for the form.

FORMNOTE

Form note.

FORMDESIGNNOTE

Form design note.

ITEMLABEL

Item label.

SINGLECHILDCONTROL

Indicates whether the control has a single child.

0 - Control has no children.

1 - Control has one child.

CONTROLNAME

Name of the control.

CONTROLDESIGNNOTE

Design note for the control.

THESAMECONTROLCOUNT

Number of times the control exists in the study design.

TXT_MAXLENGTH

Maximum length for a text field.

TXT_DATATYPE

Data type of the object.

TXT_PRECISION

Precision associated with a text box with a data type of FLOAT.

0 - Control can have any precision.

n - Number of decimal places in precision.

DATE_DISPLAYMASK

Mask for date components to display.

1 - Year information is displayed.

2 - Month information is displayed.

4 - Day information is displayed.

DATE_REQUIREDMASK

Mask for date components that are required.

1 - Year information is required.

2 - Month information is required.

4 - Day information is required.

DATE_UNKNOWNMASK

Mask for date components that are not required.

1 - Year information is not required.

2 - Month information is not required.

4 - Day information is not required.

HEIGHT

Control height.