When the District Administrator configures a custom field for a schema, he or she defines how the data should be entered in the database. The mechanism used to determine how data is entered is called a data type. Each data type can have one or several options. For example, for some data types the administrator can specify whether the data should be required and/or what the default data should be [Table 77].
Later, when the administrator adds the field to the custom schema [>>], he or she can define how the data will actually appear on screen. The mechanism used to display data on screen is called a control type [>>].
PowerSchool SMS supports several field data types [Table 77].
Data type |
Data captured in the database |
Data type options |
Alphanumeric |
Both alphabetical and numeric characters |
You can set the maximum number of characters allowed and specify whether the field is required. |
Numeric |
Numeric characters |
You can enter the maximum number of digits allowed, the number of decimal places, the default value, the numeric range, and whether the field is required. |
Date |
A date |
You can specify whether the field is required and whether to default to today’s date. |
Yes/No |
Yes and No choices specified using radio buttons |
You can choose Yes or No as the default. |
Setup list |
Captures list items |
You can select the referenced setup list and the default value. |
Memo |
Multiple lines of text |
You can specify whether the field is required. |
File |
File attachments |
You can specify whether the field is required. |
Collection |
Displays list items [>>]. In an Extension schema, items appear in a List Mover on a page. In a Child schema, items appear in a Grid on a page [see also Supported field data type/control type combinations >>]. |
You can select the referenced setup list. |
Pearson
Always Learning
www.pearsonschoolsystems.com
Tel: 866-434-6276
Email: psstechsupp@pearson.com