Basic Staff Information

St Mary's Shaftesbury wanted to give the 'Functions' tab to staff whilst restricting them to the 'Basic Staff Info' output format – we have added a new opening argument for this form – 18.

Staff Export Builder

Function name: ClassNameTutor

How to use: Add to staff area of Custom columns dbo.ClassNameTutor(userident)

Purpose: Shows a person’s form or class if they are assigned to one or leaves it blank if not.

Staff additional information

In the Staff Checks form, Additional Information tab, you can record any number of different staff attributes

We have now developed 3 functions to help you export this information.

Let us suppose you want to know all staff who are St John’s qualified, when they qualified, at what level and when their qualification expires. To have all three pieces of information you would need to set up three custom columns as follows:

Function name: StaffChecksAddInfoDate

How to use: dbo.StaffChecksAddInfoDate (userident, 'St John's Qualified ')

Note: For the example above this will return 01/06/2010

Function name: StaffChecksAddInfoNote

How to use: dbo.StaffChecksAddInfoNote (userident, 'St John's Qualified ')

Note: For the example above this will return ‘Basic First Aid’

Function name: StaffChecksAddInfoExpiryDate

How to use: dbo.StaffChecksAddInfoExpiryDate (userident, 'St John's Qualified ')

Note: For the example above this will return 01/06/2013

TAKE CARE – when you set up custom columns you can add security levels. If you are potentially allowing people to export sensitive or confidential information you should consider using this function. The example above shows these new items restricted to level 60, Administrators and above.

Staff employment status

There is a new lookup where you can extend the types of employment. This table can then be applied in the Staff Checks area. There will be further developments here as we start the development of our HR system due to be released in 2012 – watch this space.