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

COLUMNORDER

Order of the column in the view.

FORMREFNAME

Form RefName.

SECTIONREFNAME

Section RefName.

ITEMREFNAME

Item RefName.

CHILDITEMREFNAME

Childitem 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

Generated name (typically item RefName + control RefName).

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.

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

Child item order (for items within itemsets only).

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.

COLUMNLABEL

Corresponding Cognos model report element name.

COLUMNDESC

Corresponding Cognos model report element description.

COLUMNVALUE

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

SASDATASETNAME

Null value. Reserved for future use.

SASFIELDNAME

SDSDOMAIN

SDSVARNAME

FORMTYPE

Type of form.

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.