UCols, 35 (ver3.6.1)
Custom fields and additional related information for custom pages. This table includes information the actual columns in the Custom Form such as type, length and etc.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Alignment | 3.6.1 | Number(10,0) | The position of the item on a page. 2=center, 3=right, all the rest=left PS stores a 1. |
ContentLi | 3.6.1 | Number(10,0) | The number of lines a text box has. |
ContentS | 3.6.1 | Varchar(400) | The type of field the object is on a created web page. Text, static, checkbox, popup, radio, text area. |
ContentType | 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 | Default values or contents of a menu for display on a page. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Format | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Label | 3.6.1 | CLOB | The name of the field to be displayed on a page. |
RunningWidth | 3.6.1 | Float | The width of the HTML field. |
Seq | 3.6.1 | Number(10,0) | The sequence items occur on import/export templates. |
SortOrder | 3.6.1 | Number(10,0) | The order items will display on web pages built in PowerSchool. |
Title | 3.6.1 | CLOB | The column title provided for this column. |
Type | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Unused1 | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Unused2 | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
UTableID | 3.6.1 | Number(10,0) | Internal number all matching ones belong to the same item. Indexed. |
Width | 3.6.1 | Float | The width of a field in 0 characters. |