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.

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

COLUMNDBTYPE

Generated DB column type:

0 - CLOB (for string objects where length is defined as > 1000)

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.

VIEWNAME

Name of the view.

VIEWLABEL

Report topic name.

VIEWDESC

Report topic description, from the form description.

COLUMNFOLDER

Report topic folder. Can have English or Japanese folder names. 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 report topic.

COLUMNNAME

Column name.

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

ITEMID

Numeric identifier for the item.