Each field has a data type and a control type. A field's data type determines how the data will be captured in the database.
The District Administrator selects a field's data type when he or she creates a schema [see also Specifying how data is entered in the database >>]. A field's control type determines how the data will appear on screen, and is available for selection when the field is added to a panel on a page [>>].
The control type available is determined by the data type specified for the field in the schema. Note: For the data type "Collection", the schema type (Extension or Child) determines the control type [Table 123].
Table 123: Data type/control type combinations:
Data Type |
Control Type |
Description |
Alphanumeric |
A single-line text field for letters and numbers. Options include entering supplementary text to provide additional information for users, and to have PowerSchool SMS validate the data in the field [>>].
|
|
Numeric |
A single-line text field that accepts only numbers. Options include entering supplementary text to provide additional information for users.
|
|
Date |
A popup calendar and a field that accepts only dates. Options include entering supplementary text to provide additional information for users, and having PowerSchool SMS validate the data in the field [>>].
|
|
Yes/No |
A check box that users selected or deselected. Options include having PowerSchool SMS validate the data in the field [>>].
|
|
Setup list |
Drop-down list: A menu of items from a setup list.Options include having PowerSchool SMS validate the data in the field [>>]. Combo box: A drop-down list that when a user enters multiple letters, the first item in the setup list that starts with that sequence of letters appears.
|
|
Collection (Extension schema) |
A pair of list boxes that contain available and selected items from a setup list. Options include having PowerSchool SMS validate the data in the field [>>].
|
|
Collection (Child schema) |
A display-only grid that holds multiple records, with links to a page where records can be edited. Options include Add, Edit, and Delete buttons.
|
|
Collection (Child schema) |
A grid that holds multiple records, where the records can be edited within the grid. Options include Add, Edit, and Delete buttons and selecting the number of rows users are permitted to add.
|
|
Memo |
A text field with room for multiple lines of text. Options include setting the number of lines of text that users are permitted to enter.
|
|
File |
A field that points to a file attachment stored in the database, with associated buttons to upload and delete the file. Options include entering supplementary text to provide additional information for users.
|
www.powerschool.com
Tel: 866-434-6276
Email: smssupport@powerschool.com
Copyright 2015-2016 PowerSchool Group LLC and/or its affiliate(s). All rights reserved. All trademarks are either owned or licensed by PowerSchool Group LLC and/or its affiliates.