FieldsTable, 7 (ver3.6.1)
The custom fields users have entered.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ColNo | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Cols | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Data | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
DataIndex | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Datalen | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
DCID | 4.0.4 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
DefaultValue | 3.6.1 | Varchar(50) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Description | 3.6.1 | CLOB | The description of the custom field if supplied. |
DispName | 3.6.1 | Varchar(40) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
FieldNo | 3.6.1 | Number(10,0) | A unique identifier that matches the internal number. Indexed. |
FileNo | 3.6.1 | Number(10,0) | Identifies the table associated with this custom field. 100=Students, 200=Teachers, 300=Courses, 400=Sections. Indexed. |
FormatString | 3.6.1 | Varchar(20) | If the value of this custom field has to be in a certain format. |
HTML | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Help | 3.6.1 | CLOB | Any information about this custom field for Help purposes. |
HowDisp | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
InUse | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
InputFilter | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
MaxLen | 3.6.1 | Number(10,0) | Maximum length of the value of this custom field. |
MaxVal | 3.6.1 | Varchar(20) | Maximum value for this custom field. |
MinLen | 3.6.1 | Number(10,0) | Minimum length of the value of this custom field. |
MinVal | 3.6.1 | Varchar(20) | Minimum value for this custom field. |
Name | 3.6.1 | Varchar(50) | The name of the field. |
Required | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
RowsValue | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
SyncStatus | 5.0.0 | Number(10,0) | Status value used by the mechanism that keeps track of the Custom Fields tables. |
Type | 3.6.1 | Number(10,0) | The data type of the custom field. Defaults to Text. |
Unused1 | 3.6.1 | Number(10,0) | Currently unused field. |