Layton ServiceDesk - Configuring the System - Data Design

Revision as of 00:44, 29 March 2011

The Data design function provides users with the ability to add user defined field fields to data tables in the Layton ServiceDesk™ database.

• Table Definitions

Layton ServiceDesk™ allows Administrative users to modify the data structures or add and delete data user defined fields from the 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 completing any Form Designs otherwise the data fields will not be available. 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):

Request
Action (Tasks)
Problem
Change
Analyst (User)
Eusers (End User)
Eclient (Department)
Site
Company
Solutions
Priority
Survey

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 select the Add New icon. You are then presented with a form to enter the Field Name, Type (Text, Integer, Currency, Date, etc) and Size and when completed select “Save”.

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

Once a user defined data filed has been added to the data table the field can be added to the forms by selecting the “Add User Field” icon on the floating Toolbar in the FORM DESIGN section.