Layton ServiceDesk - Configuring the System - Data Design

Revision as of 23:38, 11 November 2013

Back to Contents

Previous article in this series: Create and Define Libraries

The Data design function provides Administrative users with the ability to add user-defined fields to data tables in the Layton ServiceDesk database tables, although system fields (fields prefixed sys_) cannot be deleted.

The default data structures may be adequate, and therefore there will be no requirement to add any user defined fields. Examination of each table under Administration > Data Design will allow decisions to be made on any changes.

You must create any new data fields before you can add them to a form design. The following data tables can be viewed and edited (Note that the Problem, Change & Company data tables will only be available if these features have been turned on in Administration > System Settings > Application Settings):

• Task Data
• Request Data
• Problem Data
• Change Data
• Analyst Data
• End User Data
• Company Data
• Department Data
• Site Data
• Solution Data
• Priority Data
• Survey Data

All data tables are displayed in the same format, showing the Field Name, Type and Size. The option to delete fields will not be available against system fields, prefixed sys_.

To add a data field, click the Add New button. You are then presented with a form to enter the Field Name, Type (Text, Integer, Currency, Date, etc) and Size and when completed, click Save.

The Field Names do not have to the same as the Form name or label. Any field you do add in data design must be prefixed usr_.

Once a user-defined data field has been added to the database table, it can be added to forms by clicking the Add User Field button on the floating Toolbar in the Form Design interface.

Next article in this series: Form Design

Back to Contents