element <dat:column>
Namespace:
Type:
Content:
complex, 3+any attributes, 63 elements
Defined:
locally at 2 locations in tableInfo.xsd
XML Representation Summary
<dat:column
    columnName
 = 
xs:string
    mvColumnName
 = 
xs:string
    wrappedColumnName
 = 
xs:string
    {any attribute with any namespace}
    >
   
Content: 
dat:columnIndex? × dat:datatype? × dat:nullable? × dat:required? × dat:columnTitle? × dat:scale? × dat:precision? × dat:defaultValue? × dat:defaultValueType? × dat:autoFillValue? × dat:isAutoInc? × dat:hasDbSequence? × dat:isDisplayColumn? × dat:isReadOnly? × dat:isUserEditable? × dat:isHidden? × dat:shownInInsertView? × dat:shownInUpdateView? × dat:shownInDetailsView? × dat:shownInLookupView? × dat:measure? × dat:dimension? × dat:keyVariable? × dat:recommendedVariable? × dat:defaultScale? × dat:facetingBehavior? × dat:protected? × dat:excludeFromShifting? × dat:phi? × dat:shouldLog? × dat:isUnselectable? × dat:isMvEnabled? × dat:sortDescending? × dat:inputType? × dat:inputLength? × dat:inputRows? × dat:onChange? × dat:isKeyField? × dat:description? × dat:optionlistQuery? × dat:url? × dat:urlTarget? × dat:displayWidth? × dat:formatString? × dat:conditionalFormats? × dat:validators? × dat:excelFormatString? × dat:tsvFormatString? × dat:textExpression? × dat:textAlign? × dat:propertyURI? × dat:conceptURI? × dat:redactedText? × dat:rangeURI? × dat:sortColumn? × dat:fk? × dat:importAliases? × dat:displayColumnFactory? × dat:principalConceptCode? × dat:ontology? × dat:scannable? × dat:derivationDataScope? × dat:valueExpression?
</dat:column>
Content model elements (63):
dat:description (type xs:string),
Included in content model of elements (2):
dat:columns (type anonymous)
Definition Locations
Attribute Detail
columnName
Type:
xs:string, predefined
Use:
required
Defined:
locally, within dat:ColumnType complexType
The columnName attribute is required and corresponds in a case-insensitive way to the name of the underlying column in the table or view. Required, and supported for SQL metadata, dataset import/export and list import/export.
XML Source (see within schema source)
<xs:attribute name="columnName" type="xs:string" use="required">
<xs:annotation>
<xs:documentation>
The columnName attribute is required and corresponds in a case-insensitive way to the name of the
underlying column in the table or view.
Required, and supported for SQL metadata, dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
</xs:attribute>

mvColumnName
Type:
xs:string, predefined
Use:
optional
Defined:
locally, within dat:ColumnType complexType
DEPRECATED: Do not use this attribute; use isMvEnabled element instead.
XML Source (see within schema source)
<xs:attribute name="mvColumnName" type="xs:string" use="optional">
<xs:annotation>
<xs:documentation>
DEPRECATED: Do not use this attribute; use isMvEnabled element instead.
</xs:documentation>
</xs:annotation>
</xs:attribute>

wrappedColumnName
Type:
xs:string, predefined
Use:
optional
Defined:
locally, within dat:ColumnType complexType
The name of the column to wrap. This allows, for example, adding a new, user-specified lookup based on the value of an existing column without replacing the existing lookup. DEPRECATED: Do not use this attribute; use expression element instead.
XML Source (see within schema source)
<xs:attribute name="wrappedColumnName" type="xs:string" use="optional">
<xs:annotation>
<xs:documentation>
The name of the column to wrap. This allows, for example, adding a new, user-specified
lookup based on the value of an existing column without replacing the existing lookup.
DEPRECATED: Do not use this attribute; use expression element instead.
</xs:documentation>
</xs:annotation>
</xs:attribute>

{any attribute with any namespace}
Defined:
within dat:ColumnType complexType
XML Source (see within schema source)
<xs:anyAttribute namespace="##any" processContents="lax"/>
Content Element Detail
dat:autoFillValue
Type:
xs:string, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Not currently in use.
XML Source (see within schema source)
<xs:element minOccurs="0" name="autoFillValue" type="xs:string">
<xs:annotation>
<xs:documentation>
Not currently in use.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:columnIndex
Type:
xs:int, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Not currently in use. Deprecated, will be removed in the future.
XML Source (see within schema source)
<xs:element minOccurs="0" name="columnIndex" type="xs:int">
<xs:annotation>
<xs:documentation>
Not currently in use. Deprecated, will be removed in the future.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:columnTitle
Type:
xs:string, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
The column heading for this column in a data region. If not present, the columnName is used. Supported for SQL metadata, dataset import/export and list import/export.
XML Source (see within schema source)
<xs:element minOccurs="0" name="columnTitle" type="xs:string">
<xs:annotation>
<xs:documentation>
The column heading for this column in a data region. If not present, the columnName is used.
Supported for SQL metadata, dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:conceptURI
Type:
xs:string, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
An internal identifier for the concept of this column. Concepts extend the column's type to identify columns that are participant IDs, user IDs, etc. Valid within the context of the server. Supported for dataset import/export and list import/export. Note, this field is not directly related to more recent ontology support in LabKey server.
XML Source (see within schema source)
<xs:element minOccurs="0" name="conceptURI" type="xs:string">
<xs:annotation>
<xs:documentation>
An internal identifier for the concept of this column. Concepts extend the column's type to identify columns that are
participant IDs, user IDs, etc. Valid within the context of the server.
Supported for dataset import/export and list import/export.
Note, this field is not directly related to more recent ontology support in LabKey server.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:conditionalFormats
Type:
Defined:
locally, within dat:ColumnType complexType
Conditional formats apply formatting options, such text and background colors, or bold text, selectively based on the value of the cell. Supported for SQL metadata, dataset import/export and list import/export.
XML Source (see within schema source)
<xs:element minOccurs="0" name="conditionalFormats" type="dat:ConditionalFormatsType">
<xs:annotation>
<xs:documentation>
Conditional formats apply formatting options, such text and background colors, or bold text,
selectively based on the value of the cell.
Supported for SQL metadata, dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:datatype
Type:
xs:string, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
The name of the SQL datatype of this column as would be specified in a CREATE TABLE statement. See also the <rangeURI> property. Supported for SQL metadata (inferred from database if not specified), dataset import/export and list import/export.
XML Source (see within schema source)
<xs:element minOccurs="0" name="datatype" type="xs:string">
<xs:annotation>
<xs:documentation>
The name of the SQL datatype of this column as would be specified in a CREATE TABLE statement.
See also the &lt;rangeURI&gt; property.
Supported for SQL metadata (inferred from database if not specified), dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:defaultScale
Type:
dat:DefaultScaleType, simple content
Defined:
locally, within dat:ColumnType complexType
Defaults to 'LINEAR'. For numeric field types, defines whether linear or log scales will be used by default for this measure.
XML Source (see within schema source)
<xs:element minOccurs="0" name="defaultScale" type="dat:DefaultScaleType">
<xs:annotation>
<xs:documentation>
Defaults to 'LINEAR'. For numeric field types, defines whether linear or log scales will be
used by default for this measure.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:defaultValue
Type:
xs:string, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
The value that this column will take on if a value is not specified for the column in a data insert (add record) operation. Supported for SQL metadata and import/export.
XML Source (see within schema source)
<xs:element minOccurs="0" name="defaultValue" type="xs:string">
<xs:annotation>
<xs:documentation>
The value that this column will take on if a value is not specified for
the column in a data insert (add record) operation.
Supported for SQL metadata and import/export.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:defaultValueType
Type:
dat:DefaultValueEnumType, simple content
Defined:
locally, within dat:ColumnType complexType
The default value behavior of this column.
XML Source (see within schema source)
<xs:element minOccurs="0" name="defaultValueType" type="dat:DefaultValueEnumType">
<xs:annotation>
<xs:documentation>
The default value behavior of this column.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:derivationDataScope
Type:
Default:
"ParentOnly"
Defined:
locally, within dat:ColumnType complexType
Field editing scope for aliquots. ParentOnly: Field editable in parent and inherited by aliquot, ChildOnly: Only editable by aliquot, All: Both parent and aliquot are editable. Default is ParentOnly.
XML Source (see within schema source)
<xs:element default="ParentOnly" maxOccurs="1" minOccurs="0" name="derivationDataScope" type="dat:DerivationDataScopeTypes">
<xs:annotation>
<xs:documentation>
Field editing scope for aliquots. ParentOnly: Field editable in parent and inherited by aliquot,
ChildOnly: Only editable by aliquot, All: Both parent and aliquot are editable. Default is ParentOnly.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:description
Type:
xs:string, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
A description of the meaning of the column, appears as hovertext in insert, update, and details views. Supported for SQL metadata, dataset import/export and list import/export.
XML Source (see within schema source)
<xs:element minOccurs="0" name="description" type="xs:string">
<xs:annotation>
<xs:documentation>
A description of the meaning of the column, appears as hovertext in insert, update, and details views.
Supported for SQL metadata, dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:dimension
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Defaults to false. Data dimensions define logical groupings of measures. For example, 'Gender' could be a dimension for a dataset containing a 'Height' measure, since it may be desirable to study height by gender.
XML Source (see within schema source)
<xs:element minOccurs="0" name="dimension" type="xs:boolean">
<xs:annotation>
<xs:documentation>
Defaults to false. Data dimensions define logical groupings of measures. For example, 'Gender'
could be a dimension for a dataset containing a 'Height' measure, since it may be desirable
to study height by gender.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:displayColumnFactory
Type:
anonymous, complex content
Defined:
locally, within dat:ColumnType complexType
Fully qualified class name and properties for the org.labkey.api.data.DisplayColumnFactory that this column uses. It needs to have a no-arg constructor as it will be created via reflection. The following special className values can also be used: 'NOWRAP' (prevents a value from line-wrapping in the HTML UI), 'NOLOOKUP' (for lookup columns, show the raw FK value instead of the title column of the lookup's target, and 'DEFAULT' (the standard display behavior).
XML Source (see within schema source)
<xs:element minOccurs="0" name="displayColumnFactory">
<xs:annotation>
<xs:documentation>
Fully qualified class name and properties for the org.labkey.api.data.DisplayColumnFactory that
this column uses. It needs to have a no-arg constructor as it will be created via reflection.
The following special className values can also be used: 'NOWRAP' (prevents a value from
line-wrapping in the HTML UI), 'NOLOOKUP' (for lookup columns, show the raw FK value instead of
the title column of the lookup's target, and 'DEFAULT' (the standard display behavior).
</xs:documentation>
</xs:annotation>
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="1" minOccurs="1" name="className" type="xs:string"/>
<xs:element maxOccurs="1" minOccurs="0" name="properties" type="dat:PropertiesType"/>
</xs:sequence>
</xs:complexType>
</xs:element>

dat:displayWidth
Type:
xs:string, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
The width in pixels to reserve for data values form this column Supported for SQL metadata.
XML Source (see within schema source)
<xs:element minOccurs="0" name="displayWidth" type="xs:string">
<xs:annotation>
<xs:documentation>
The width in pixels to reserve for data values form this column
Supported for SQL metadata.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:excelFormatString
Type:
xs:string, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Format string for the column, used when exporting to Excel. If not present the formatString is used, if present. Supported for SQL metadata.
XML Source (see within schema source)
<xs:element minOccurs="0" name="excelFormatString" type="xs:string">
<xs:annotation>
<xs:documentation>
Format string for the column, used when exporting to Excel.
If not present the formatString is used, if present.
Supported for SQL metadata.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:excludeFromShifting
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Defaults to false. Participant date columns with this property checked will not be shifted on export/publication when the "Shift Participant Dates" option is selected.
XML Source (see within schema source)
<xs:element minOccurs="0" name="excludeFromShifting" type="xs:boolean">
<xs:annotation>
<xs:documentation>
Defaults to false. Participant date columns with this property checked will not be shifted on export/publication when
the "Shift Participant Dates" option is selected.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:facetingBehavior
Type:
dat:FacetingBehaviorType, simple content
Defined:
locally, within dat:ColumnType complexType
Defaults to 'AUTOMATIC'. Determines when faceted filtering options are displayed for columns. Other options are 'ALWAYS_ON' and 'ALWAYS_OFF'.
XML Source (see within schema source)
<xs:element minOccurs="0" name="facetingBehavior" type="dat:FacetingBehaviorType">
<xs:annotation>
<xs:documentation>
Defaults to 'AUTOMATIC'. Determines when faceted filtering options are displayed for
columns. Other options are 'ALWAYS_ON' and 'ALWAYS_OFF'.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:fk
Type:
anonymous, complex content
Defined:
locally, within dat:ColumnType complexType
A structure that describes a foreign key relationship between a column in the current table and a target column in another table. Supported for SQL metadata, dataset import/export and list import/export.
XML Source (see within schema source)
<xs:element minOccurs="0" name="fk">
<xs:annotation>
<xs:documentation>
A structure that describes a foreign key relationship between a column in the current table and
a target column in another table.
Supported for SQL metadata, dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
<xs:complexType>
<xs:all>
<xs:element minOccurs="0" name="fkFolderPath" type="xs:string">
<xs:annotation>
<xs:documentation>
Absolute path to the folder containing the target table of the relationship.
Example: /Home/support/lists.
Supported for SQL metadata, dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="fkTable" type="xs:string">
<xs:annotation>
<xs:documentation>
The name of the target table of the relationship, the "one" side of the many-to-one
relationship.
Supported for SQL metadata, dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element minOccurs="0" name="fkColumnName" type="xs:string">
<xs:annotation>
<xs:documentation>
The name of the target column in the target table of the fk relationship. If not
specified, defaults to primary key of the target.
Must be a column that contains 0 or 1 row for any particular value (usually
a primary key or column with a UNIQUE constraint) to prevent row multiplication
when joining.
Supported for SQL metadata.
</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element minOccurs="0" name="fkDbSchema" type="xs:string">
<xs:annotation>
<xs:documentation>
The name of the schema in which the foreign key target is defined. If empty, the
target ("one" side) table is assumed to exist in the same schema as the "many" side
table.
Supported for SQL metadata, dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element minOccurs="0" name="fkMultiValued" type="xs:string">
<xs:annotation>
<xs:documentation>
Use to specify a multi-valued column. Currently, "junction" is the only legal value.
</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element minOccurs="0" name="fkJunctionLookup" type="xs:string">
<xs:annotation>
<xs:documentation>
Specify the junction lookup column in a many-to-many relationship.
</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element minOccurs="0" name="fkDisplayColumnName" type="dat:FkDisplayColumnNameType">
<xs:annotation>
<xs:documentation>
The name of the column in the lookup's target that should be shown as the value.
If not specified, defaults to the lookup target's title column.
</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element minOccurs="0" name="filters">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" minOccurs="0" name="filterGroup" type="dat:FilterGroupType"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:all>
</xs:complexType>
</xs:element>

dat:formatString
Type:
xs:string, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
A template that specifies how to format a value from the column on display output (or on export if the corresponding excel- and tsvFormatString values are not set. Follows the same format patterns as the following objects in the java.text package: DecimalFormat DateFormat. In addition to these standard java format patterns, boolean values can be formatted using a template of the form positive;negative;null, where "positive" is the string to display when true, "negative" is the string to display when false, and "null" is the string to display when null. For date and datetime columns the values Date and DateTime can be used to display as either date or date and time with the currently configured display formats for this folder. For file and attachment columns, "attachment" to save files as a download, overriding the default behavior of displaying files like PDFs and images in the browser . Supported for SQL metadata, dataset import/export and list import/export.
XML Source (see within schema source)
<xs:element minOccurs="0" name="formatString" type="xs:string">
<xs:annotation>
<xs:documentation>
A template that specifies how to format a value from the column on display output (or on export
if the corresponding excel- and tsvFormatString values are not set. Follows the same format
patterns as the following objects in the java.text package: DecimalFormat DateFormat. In
addition to these standard java format patterns, boolean values can be formatted using a template
of the form positive;negative;null, where "positive" is the string to display when true, "negative"
is the string to display when false, and "null" is the string to display when null. For date and
datetime columns the values Date and DateTime can be used to display as
either date or date and time with the currently configured display formats for this folder.
For file and attachment columns, "attachment" to save files as a download, overriding the
default behavior of displaying files like PDFs and images in the browser .
Supported for SQL metadata, dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:hasDbSequence
Type:
dat:DbSequenceType, simple content
Defined:
locally, within dat:ColumnType complexType
True if the column is assigned an automatically incrementing value by the Java code for every new row inserted. Unlike autoInc columns, the value for this column can be available during insert without requiring additional selection to occur.
XML Source (see within schema source)
<xs:element minOccurs="0" name="hasDbSequence" type="dat:DbSequenceType">
<xs:annotation>
<xs:documentation>
True if the column is assigned an automatically incrementing value by the Java code for every
new row inserted. Unlike autoInc columns, the value for this column can be available during
insert without requiring additional selection to occur.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:importAliases
Type:
anonymous, complex content
Defined:
locally, within dat:ColumnType complexType
A collection of aliases by which this column may be named when importing from external files. Supported for dataset import/export and list import/export.
XML Source (see within schema source)
<xs:element minOccurs="0" name="importAliases">
<xs:annotation>
<xs:documentation>
A collection of aliases by which this column may be named when importing from external files.
Supported for dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
<xs:complexType>
<xs:sequence maxOccurs="unbounded" minOccurs="0">
<xs:element name="importAlias" type="xs:string"/>
</xs:sequence>
</xs:complexType>
</xs:element>

dat:inputLength
Type:
xs:int, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
The width of a text or select input control, in number of characters. Supported for SQL metadata.
XML Source (see within schema source)
<xs:element minOccurs="0" name="inputLength" type="xs:int">
<xs:annotation>
<xs:documentation>
The width of a text or select input control, in number of characters.
Supported for SQL metadata.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:inputRows
Type:
xs:int, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
The number of rows of text to display if inputType = "textarea". Supported for SQL metadata.
XML Source (see within schema source)
<xs:element minOccurs="0" name="inputRows" type="xs:int">
<xs:annotation>
<xs:documentation>
The number of rows of text to display if inputType = "textarea".
Supported for SQL metadata.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:inputType
Type:
xs:string, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
The HTML control type to use for data insert or edit into this column. Valid values are "select", "hidden", "textarea", "file", "checkbox", and "text". Supported for SQL metadata, dataset import/export and list import/export.
XML Source (see within schema source)
<xs:element minOccurs="0" name="inputType" type="xs:string">
<xs:annotation>
<xs:documentation>
The HTML control type to use for data insert or edit into this column.
Valid values are "select", "hidden", "textarea", "file", "checkbox", and "text".
Supported for SQL metadata, dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:isAutoInc
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
True if the column is assigned an automatically incrementing value by the database for every new row inserted. Supported for SQL metadata (if not specified, LabKey looks for "identity" or "serial" columns), dataset import/export and list import/export.
XML Source (see within schema source)
<xs:element minOccurs="0" name="isAutoInc" type="xs:boolean">
<xs:annotation>
<xs:documentation>
True if the column is assigned an automatically incrementing value by the database for every
new row inserted.
Supported for SQL metadata (if not specified, LabKey looks for "identity" or "serial" columns),
dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:isDisplayColumn
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Not currently in use.
XML Source (see within schema source)
<xs:element minOccurs="0" name="isDisplayColumn" type="xs:boolean">
<xs:annotation>
<xs:documentation>
Not currently in use.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:isHidden
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Defaults to false. Set to true if the column should not normally be displayed in a grid view, but is sent with the form data as a hidden attribute. In the Customize View UI, isHidden fields are only shown if the "Show Hidden" textbox is selected. Supported for SQL metadata, dataset import/export and list import/export.
XML Source (see within schema source)
<xs:element minOccurs="0" name="isHidden" type="xs:boolean">
<xs:annotation>
<xs:documentation>
Defaults to false. Set to true if the column should not normally be displayed in a grid view,
but is sent with the form data as a hidden attribute. In the Customize View UI, isHidden fields
are only shown if the "Show Hidden" textbox is selected. Supported for SQL metadata, dataset
import/export and list import/export.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:isKeyField
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
True if the column is the Primary Key or part of the Primary Key. Supported for SQL metadata (inferred from database if not specified), dataset import/export and list import/export.
XML Source (see within schema source)
<xs:element minOccurs="0" name="isKeyField" type="xs:boolean">
<xs:annotation>
<xs:documentation>
True if the column is the Primary Key or part of the Primary Key.
Supported for SQL metadata (inferred from database if not specified), dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:isMvEnabled
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Determines whether the column supports missing value indicators. See the <a href="https://www.labkey.org/Documentation/wiki-page.view?name=manageMissing" target="_top"> Missing Value Indicator</a> documentation page. Supported for dataset import/export and list import/export.
XML Source (see within schema source)
<xs:element minOccurs="0" name="isMvEnabled" type="xs:boolean">
<xs:annotation>
<xs:documentation xmlns="http://www.w3.org/1999/xhtml">
Determines whether the column supports missing value indicators. See the
<a href="https://www.labkey.org/Documentation/wiki-page.view?name=manageMissing" target="_top">
Missing Value Indicator
</a>
documentation page.
Supported for dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:isReadOnly
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
If true, column is assumed to be non-editable and is skipped during any update or insert operations. Used at the system level. Key values that are not auto-generated are described as isReadOnly=False and isUserEditable=False. Supported for SQL metadata.
XML Source (see within schema source)
<xs:element minOccurs="0" name="isReadOnly" type="xs:boolean">
<xs:annotation>
<xs:documentation>
If true, column is assumed to be non-editable and is skipped during any update or insert
operations. Used at the system level. Key values that are not auto-generated are described as
isReadOnly=False and isUserEditable=False.
Supported for SQL metadata.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:isUnselectable
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Determines whether the column can be selected in the Query column chooser. For example, the "Properties" entry cannot be selected. Supported for SQL metadata.
XML Source (see within schema source)
<xs:element minOccurs="0" name="isUnselectable" type="xs:boolean">
<xs:annotation>
<xs:documentation>
Determines whether the column can be selected in the Query column chooser.
For example, the "Properties" entry cannot be selected.
Supported for SQL metadata.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:isUserEditable
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
True if the column should be shown as editable by a user with appropriate permissions. If the column is readOnly, this property has no effect. Supported for SQL metadata.
XML Source (see within schema source)
<xs:element minOccurs="0" name="isUserEditable" type="xs:boolean">
<xs:annotation>
<xs:documentation>
True if the column should be shown as editable by a user with appropriate permissions.
If the column is readOnly, this property has no effect.
Supported for SQL metadata.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:keyVariable
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Deprecated. See recommendedVariable.
XML Source (see within schema source)
<xs:element minOccurs="0" name="keyVariable" type="xs:boolean">
<xs:annotation>
<xs:documentation>Deprecated. See recommendedVariable.</xs:documentation>
</xs:annotation>
</xs:element>

dat:measure
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Defaults to false. Measures are fields that contain data subject to charting and other analysis. Measures are typically numeric results/observations, like weight, or CD4 count.
XML Source (see within schema source)
<xs:element minOccurs="0" name="measure" type="xs:boolean">
<xs:annotation>
<xs:documentation>
Defaults to false. Measures are fields that contain data subject to charting and other analysis.
Measures are typically numeric results/observations, like weight, or CD4 count.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:nullable
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Whether or not the column accepts NULLs. Supported for SQL metadata (inferred from database if not specified), dataset import/export and list import/export.
XML Source (see within schema source)
<xs:element minOccurs="0" name="nullable" type="xs:boolean">
<xs:annotation>
<xs:documentation>
Whether or not the column accepts NULLs.
Supported for SQL metadata (inferred from database if not specified),
dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:onChange
Type:
xs:string, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Not currently in use.
XML Source (see within schema source)
<xs:element minOccurs="0" name="onChange" type="xs:string">
<xs:annotation>
<xs:documentation>
Not currently in use.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:ontology
Type:
anonymous, complex content
Defined:
locally, within dat:ColumnType complexType
This is a parent element for ontology related metadata. This includes the description of what this column "measures", as well as additional information specific to concept-valued columns.
XML Source (see within schema source)
<xs:element maxOccurs="1" minOccurs="0" name="ontology">
<xs:annotation>
<xs:documentation>
This is a parent element for ontology related metadata. This includes the description of what this column "measures", as well as
additional information specific to concept-valued columns.
</xs:documentation>
</xs:annotation>
<xs:complexType>
<xs:all>
<xs:element maxOccurs="1" minOccurs="0" name="concept" type="dat:ConceptType"/>
</xs:all>
</xs:complexType>
</xs:element>

dat:optionlistQuery
Type:
xs:string, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Not currently in use.
XML Source (see within schema source)
<xs:element minOccurs="0" name="optionlistQuery" type="xs:string">
<xs:annotation>
<xs:documentation>
Not currently in use.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:phi
Type:
dat:PHIType, simple content
Defined:
locally, within dat:ColumnType complexType
Defaults to "Not PHI". Annotates a column with one of four PHI levels (Not PHI, Limited PHI, Full PHI, or Resticted PHI). Using the Compliance module, administrators can configure the server to control access and logging for PHI annotated fields. For example, requiring users to have specific PHI security roles and/or to sign terms of use in order to view the annotated fields. Without additional configuration provided by the Compliance module, LabKey Server ignores this setting.
XML Source (see within schema source)
<xs:element minOccurs="0" name="phi" type="dat:PHIType">
<xs:annotation>
<xs:documentation>
Defaults to "Not PHI". Annotates a column with one of four PHI levels (Not PHI, Limited PHI, Full PHI, or Resticted PHI).
Using the Compliance module, administrators can configure the server to control access and logging for PHI annotated fields.
For example, requiring users to have specific PHI security roles and/or to sign terms of use in order to view the annotated fields.
Without additional configuration provided by the Compliance module, LabKey Server ignores this setting.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:precision
Type:
xs:int, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
For numeric columns only, describes the defined number of digits to the right of the decimal place for values in this column. Supported for SQL metadata (inferred from database if not specified).
XML Source (see within schema source)
<xs:element minOccurs="0" name="precision" type="xs:int">
<xs:annotation>
<xs:documentation>
For numeric columns only, describes the defined number of digits to the right of the decimal
place for values in this column.
Supported for SQL metadata (inferred from database if not specified).
</xs:documentation>
</xs:annotation>
</xs:element>

dat:principalConceptCode
Type:
xs:string, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Ontology concept code associated with this column.
XML Source (see within schema source)
<xs:element minOccurs="0" name="principalConceptCode" type="xs:string">
<xs:annotation>
<xs:documentation>
Ontology concept code associated with this column.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:propertyURI
Type:
xs:string, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
An internal identifier for the definition of this column. Valid within the context of the server. Supported for dataset import/export and list import/export.
XML Source (see within schema source)
<xs:element minOccurs="0" name="propertyURI" type="xs:string">
<xs:annotation>
<xs:documentation>
An internal identifier for the definition of this column. Valid within the context of the server.
Supported for dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:protected
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Defaults to false. Protected columns are those that contain protected or identifiable information about participants, such as internal participant IDs, transplant dates, birth dates, etc.
XML Source (see within schema source)
<xs:element minOccurs="0" name="protected" type="xs:boolean">
<xs:annotation>
<xs:documentation>
Defaults to false. Protected columns are those that contain protected or identifiable information
about participants, such as internal participant IDs, transplant dates, birth dates, etc.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:rangeURI
Type:
xs:string, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
The rangeURI identifies the range of values that this column can accept which can be more specific than the <datatype> property. For example, a file attachment column has a rangeURI of "http://www.labkey.org/exp/xml#attachment" and implies a datatype of VARCHAR. Not all possible sql types can be expressed via rangeURI -- for example, the sql REAL type. See PropertyType for set of the allowed rangeURI values. Supported for dataset import/export and list import/export.
XML Source (see within schema source)
<xs:element minOccurs="0" name="rangeURI" type="xs:string">
<xs:annotation>
<xs:documentation>
The rangeURI identifies the range of values that this column can accept which
can be more specific than the &lt;datatype&gt; property.
For example, a file attachment column has a rangeURI of "http://www.labkey.org/exp/xml#attachment"
and implies a datatype of VARCHAR.
Not all possible sql types can be expressed via rangeURI -- for example, the sql REAL type.
See PropertyType for set of the allowed rangeURI values.
Supported for dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:recommendedVariable
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Defaults to false. Define which fields in this table/query/etc. are important variables. These variables may be displayed as recommended variables when creating new charts/reports/etc.
XML Source (see within schema source)
<xs:element minOccurs="0" name="recommendedVariable" type="xs:boolean">
<xs:annotation>
<xs:documentation>
Defaults to false. Define which fields in this table/query/etc. are important variables.
These variables may be displayed as recommended variables when creating new charts/reports/etc.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:redactedText
Type:
xs:string, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Replacement string for redacted text. Supported for SND import.
XML Source (see within schema source)
<xs:element minOccurs="0" name="redactedText" type="xs:string">
<xs:annotation>
<xs:documentation>
Replacement string for redacted text. Supported for SND import.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:required
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Whether or not the column is required on insert and update. Supported for SQL metadata (inferred from database if not specified), dataset import/export and list import/export.
XML Source (see within schema source)
<xs:element minOccurs="0" name="required" type="xs:boolean">
<xs:annotation>
<xs:documentation>
Whether or not the column is required on insert and update.
Supported for SQL metadata (inferred from database if not specified),
dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:scale
Type:
xs:int, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
The defined maximum or fixed length of the data values in this column. Supported for SQL metadata (inferred from database if not specified). For string columns, a value of '-1' indicates the max column size.
XML Source (see within schema source)
<xs:element minOccurs="0" name="scale" type="xs:int">
<xs:annotation>
<xs:documentation>
The defined maximum or fixed length of the data values in this column.
Supported for SQL metadata (inferred from database if not specified).
For string columns, a value of '-1' indicates the max column size.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:scannable
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Defaults to false. Indicates that column is used as a searchable value within the application contexts.
XML Source (see within schema source)
<xs:element minOccurs="0" name="scannable" type="xs:boolean">
<xs:annotation>
<xs:documentation>
Defaults to false. Indicates that column is used as a searchable value within the application contexts.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:shouldLog
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Defaults to true. Using the Compliance module, administrators can configure logging behavior for PHI annotated fields. For example, the server can record the terms of use signed by the user, the PHI level declared at sign on, the SQL queries invoked, a list of Participant Ids accessed, and the PHI annotated fields accessed. Without additional configuration provided by the Compliance module, LabKey Server ignores this flag.
XML Source (see within schema source)
<xs:element minOccurs="0" name="shouldLog" type="xs:boolean">
<xs:annotation>
<xs:documentation>
Defaults to true. Using the Compliance module, administrators can configure logging behavior for
PHI annotated fields. For example, the server can record the terms of use signed by the user, the PHI level declared
at sign on, the SQL queries invoked, a list of Participant Ids accessed, and the PHI annotated fields accessed.
Without additional configuration provided by the Compliance module, LabKey Server ignores this flag.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:shownInDetailsView
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Defaults to true. Set to false if the column should not be shown in details views.
XML Source (see within schema source)
<xs:element minOccurs="0" name="shownInDetailsView" type="xs:boolean">
<xs:annotation>
<xs:documentation>
Defaults to true. Set to false if the column should not be shown in details views.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:shownInInsertView
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Defaults to true. Set to false if the column should not be shown in insert views. Supported for SQL metadata, dataset import/export and list import/export.
XML Source (see within schema source)
<xs:element minOccurs="0" name="shownInInsertView" type="xs:boolean">
<xs:annotation>
<xs:documentation>
Defaults to true. Set to false if the column should not be shown in insert views.
Supported for SQL metadata, dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:shownInLookupView
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Defaults to false. Set to true if the column should not be shown in lookup views.
XML Source (see within schema source)
<xs:element minOccurs="0" name="shownInLookupView" type="xs:boolean">
<xs:annotation>
<xs:documentation>
Defaults to false. Set to true if the column should not be shown in lookup views.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:shownInUpdateView
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Defaults to true. Set to false if the column should not be shown in update views. Supported for SQL metadata, dataset import/export and list import/export.
XML Source (see within schema source)
<xs:element minOccurs="0" name="shownInUpdateView" type="xs:boolean">
<xs:annotation>
<xs:documentation>
Defaults to true. Set to false if the column should not be shown in update views.
Supported for SQL metadata, dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:sortColumn
Type:
xs:string, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
If provided, the value of the provided column will be used when sorting this column instead of the actual value
XML Source (see within schema source)
<xs:element minOccurs="0" name="sortColumn" type="xs:string">
<xs:annotation>
<xs:documentation>
If provided, the value of the provided column will be used when sorting this column instead of the actual value
</xs:documentation>
</xs:annotation>
</xs:element>

dat:sortDescending
Type:
xs:boolean, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
True if the column values should normally be sorted in Descending order on first click. Used for scoring columns where the high-scoring values are most interesting and therefore should appear first when the column title sort link is clicked. If sortDescending is false or not present, the first click on the column title sort link sorts in Ascending order on the column. Supported for SQL metadata.
XML Source (see within schema source)
<xs:element minOccurs="0" name="sortDescending" type="xs:boolean">
<xs:annotation>
<xs:documentation>
True if the column values should normally be sorted in Descending order on first click.
Used for scoring columns where the high-scoring values are most interesting and therefore
should appear first when the column title sort link is clicked.
If sortDescending is false or not present, the first click on the column title sort
link sorts in Ascending order on the column.
Supported for SQL metadata.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:textAlign
Type:
xs:string, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
The horizontal alignment of a data value from this column in a grid. Valid values are "left", "center" and "right". By default, text values are left-aligned and numeric columns are right-aligned. Supported for SQL metadata.
XML Source (see within schema source)
<xs:element minOccurs="0" name="textAlign" type="xs:string">
<xs:annotation>
<xs:documentation>
The horizontal alignment of a data value from this column in a grid.
Valid values are "left", "center" and "right". By default, text values are left-aligned and numeric columns are right-aligned.
Supported for SQL metadata.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:textExpression
Type:
dat:StringExpressionType, simple content
Defined:
locally, within dat:ColumnType complexType
Expression string for the column used when rendering the column value for display. If not present, the formatString is used, if present. Supported for SQL metadata.
XML Source (see within schema source)
<xs:element minOccurs="0" name="textExpression" type="dat:StringExpressionType">
<xs:annotation>
<xs:documentation>
Expression string for the column used when rendering the column value for display.
If not present, the formatString is used, if present.
Supported for SQL metadata.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:tsvFormatString
Type:
xs:string, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
Format string for the column, used when exporting in TSV format. If not present, the formatString is used, if present. Supported for SQL metadata.
XML Source (see within schema source)
<xs:element minOccurs="0" name="tsvFormatString" type="xs:string">
<xs:annotation>
<xs:documentation>
Format string for the column, used when exporting in TSV format.
If not present, the formatString is used, if present.
Supported for SQL metadata.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:url
Type:
dat:StringExpressionType, simple content
Defined:
locally, within dat:ColumnType complexType
A URL template to use when rendering this column's value. Use the syntax ${ColumnName} to substitute values. Example: http://www.google.com/search?q=${SearchTerm}. You may also use an abbreviated syntax for built in urls which omits the context path and folder path. Example: /wiki/page.view?name=details&id=${Key} See the full URL documentation for more information: https://www.labkey.org/Documentation/wiki-page.view?name=propertyFields Supported for SQL metadata, dataset import/export and list import/export.
XML Source (see within schema source)
<xs:element minOccurs="0" name="url" type="dat:StringExpressionType">
<xs:annotation>
<xs:documentation xmlns="http://www.w3.org/1999/xhtml">
A URL template to use when rendering this column's value. Use the syntax ${ColumnName} to substitute values.
Example: http://www.google.com/search?q=${SearchTerm}.
You may also use an abbreviated syntax for built in urls which omits the context path and folder path.
Example: /wiki/page.view?name=details&amp;id=${Key}
See the full URL documentation for more information:
https://www.labkey.org/Documentation/wiki-page.view?name=propertyFields
Supported for SQL metadata, dataset import/export and list import/export.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:urlTarget
Type:
xs:string, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
The target attribute for URL links. For example, use "_blank" to open the link in a new window or tab.
XML Source (see within schema source)
<xs:element minOccurs="0" name="urlTarget" type="xs:string">
<xs:annotation>
<xs:documentation>
The target attribute for URL links. For example, use "_blank" to open the link in a new window or tab.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:validators
Type:
dat:ValidatorsType, complex content
Defined:
locally, within dat:ColumnType complexType
Validators are tested at insert and update time. Supported for SQL metadata and import/export of datasets, lists, and SND.
XML Source (see within schema source)
<xs:element minOccurs="0" name="validators" type="dat:ValidatorsType">
<xs:annotation>
<xs:documentation>
Validators are tested at insert and update time.
Supported for SQL metadata and import/export of datasets, lists, and SND.
</xs:documentation>
</xs:annotation>
</xs:element>

dat:valueExpression
Type:
xs:string, predefined, simple content
Defined:
locally, within dat:ColumnType complexType
XML Source (see within schema source)
<xs:element maxOccurs="1" minOccurs="0" name="valueExpression" type="xs:string"/>

This XML schema documentation has been generated with DocFlex/XML RE 1.7.2 using DocFlex/XML XSDDoc 2.1.0 template set.
DocFlex/XML RE is a reduced edition of DocFlex/XML, which is a tool for programming and running highly sophisticated documentation and reports generators by the data obtained from any kind of XML files. The actual doc-generators are implemented in the form of special templates that are designed visually using a high quality Template Designer GUI basing on the XML schema (or DTD) files describing the data source XML.
DocFlex/XML XSDDoc is a commercial template application of DocFlex/XML that implements a high-end XML Schema documentation generator with simultaneous support of framed multi-file HTML, single-file HTML and RTF output formats. (More formats are planned in the future).
A commercial license for "DocFlex/XML XSDDoc" will allow you:
  • To configure the generated documentation so much as you want. Thanks to our template technology, it was possible to support more than 300 template parameters (working the same as "options" of an ordinary doc-gen), which will give you an unprecedented control over the generated content!
  • To use certain features disabled in the free mode (such as the full documenting of substitution groups).
  • To enable/disable documenting of the initial, imported, included and redefined XML schemas selectively.
  • To document local element components both globally and locally (similar to attributes).
  • To enable/disable reproducing of namespace prefixes.
  • To format your annotations with XHTML tags and reproduce that formatting both in HTML and RTF output.
  • To insert images in your annotations using XHTML <img> tags (supported both in HTML and RTF output).
  • To use PlainDoc.tpl main template to generate all the XML schema documentation in the form of a single HTML file.
  • To use the same template to generate the incredible quality RTF documentation.
  • To document only selected XML schema components specified by name.
  • To remove this very advertisement text
Once having only such a license, you will be able to run the fully-featured XML schema documentation generator both with DocFlex/XML SDK and with DocFlex/XML RE, which is a reduced free edition containing only the template interpretor / output generator. No other licenses will be required!
But this is not all. In addition to it, a commercial license for DocFlex/XML SDK will allow you to modify the XSDDoc templates themselves as much as you want. You will be able to achieve whatever was impossible to do with the template parameters only. And, of course, you could develop any template applications by your own!
Please note: By purchasing a license for this software, you not only acquire a useful tool, you will also make an important investment in its future development, the result of which you could enjoy later by yourself. Every single your purchase matters and makes a difference for us!
To buy a license, please follow this link: http://www.filigris.com/shop/