Item mapping properties

The following table defines the properties of an item mapping definition:

Property	Definition
RefName	RefName of the component. REQUIRED. For rules about the use of RefNames, see RefNames
Type	Data type for the value of the item: DATE DATETIME FIXED FLOAT TEXT REQUIRED..
Length	Number of characters that can be entered in this item. The default is 38. OPTIONAL. This property is visible when the Type is TEXT, FIXED, or FLOAT.
Precision	Number of characters that can be added after the decimal place in an item with a type of FLOAT. This value can be a number between 1 and 15. The default is 10. If you enter 0, the precision defaults back to 10. If you enter a number greater than 15 is chosen, the precision defaults back to 15. OPTIONAL. This property is visible when the Type is FLOAT.
DB Format	Format in which Clintrial software stores values for the item in the Oracle database, for example: VARCHAR2(n) DATE DATETIME NUMBER(xx) NUMBER(xx,yy) NUMBER(xx,0).x READ ONLY.
Date Part	Part of a date time control to be mapped to a Clintrial software item. Use this property if you are mapping parts of a date time control to separate Clintrial software items. Values are: Year Month Day Hour Minute Second Undefined OPTIONAL.
Derived	True or False, indicating whether the value of the item is determined from a derivation associated with the panel. False is the default. OPTIONAL.
Required	True or False, indicating whether the item is required. False is the default. OPTIONAL.
SAS Name	Name of the item when data is sent to SAS through the Clintrial SAS interface. OPTIONAL; if entered, the name must be eight characters or fewer and conform to SAS naming requirements.
Repeat	True or False, indicating whether an item is one for which multiple values can be entered within a page section. False is the default. OPTIONAL.
Code List	Name of a Clintrial codelist associated with the item. A codelist encodes entered values. Only codes or values in the codelist can be entered as values of the item. OPTIONAL; Code List and Check List are mutually exclusive.
Check List	Name of a Clintrial checklist associated with the item. A checklist is a type of codelist used to view suggested entries for a field. OPTIONAL; Code List and Check List are mutually exclusive.
Range Lower Bound	Minimum value that can be entered for the value of the item. OPTIONAL. This property is visible if the Type is FIXED or FLOAT.
Range Upper Bound	Maximum value that can be entered for the value of the item. OPTIONAL. This property is visible if the Type is FIXED or FLOAT.
Key Order	The order in which the item appears in the concatenation of key items, if the item is part of the panel's key. 0 (not a key item) is the default. OPTIONAL.
Copy with Panel	Name of a Clintrial codelist associated with the item. A codelist encodes entered values. Only codes or values in the codelist can be entered as values of the item. OPTIONAL.
Lock Status	Indicates whether the protocol in which the item is included is locked: The item is not modifiable and cannot be made modifiable The item is modifiable The item is not modifiable, but it can be reset to modifiable OPTIONAL.
Design Note	Free-form text, with a maximum of 255 characters, containing any information you want to capture about the design of the component. This information is for documentation only. OPTIONAL. Design Note text is not transferred to the target tables.