Previous Topic

Next Topic

Book Contents

IRV_CONTROL_REVS

This view contains one row for each control installed into the study.

Columns in the IRV_CONTROL_REVS view

IRV_CONTROL_REVS
Column Name (Key indicator)

IRV_CONTROL_REVS
Column Description

CONTROLID

Numeric identifier for the control.

CONTROLREV

Revision number for the control.

FIRSTREV

This is the first revision of the control:

0 - No

1 - Yes

CURRENTREV

This is the most current revision of the control:

0 - No

1 - Yes

CONTROLREFNAME

RefName for the control.

CONTROLNAME

Control name.

CONTROLCAPTION

Control caption.

CONTROLTABLE

Name of the table containing attributes specific to the type of control.

CONTROLTYPE

Control type:

1 - Simple control
2 - Drop-down list
3 - Listbox control
5 - Text control
6 - Calculated control
7 - Group control
8 - Radio control
9 - Checkbox group
10 - Date control

CONTROLLAYOUT

Control layout:

1 - Horizontal
2 - Vertical
3 - No wrapping

CONTROLALIGNMENT

Control alignment:

1 - Left
2 - Center
3 - Right
4 - Top
5 - Middle
6 - Bottom

CAPTIONALIGNMENT

Caption alignment with respect to the control:

1 - Left
2 - Center
3 - Right
4 - Top
5 - Middle
6 - Bottom

HEIGHT

Control height.

UNITDISPLAYTYPE

Units display as:

1 - A single element
2 - Radio buttons
3 - Drop-down list

CONTROLDESIGNNOTE

Design note for the control, as provided by the study designer.

CREATEDBYUSERID

User ID of the user whose action resulted in the given view row being created.

CREATEDBYDATETIME

Date and time when the view row was created.

MODIFIEDBYUSERID

User ID of the user whose action resulted in the most recent change to data in the given view row.

MODIFIEDDATETIME

Date and time when the data in the view row was most recently updated.

Send Feedback