While departments is one of the simplest lists in the whole application, it actually relates back to quite a bit of important data.
Departments have only a few editable fields, the name of the department and a department number – if you have one – for the most part.
The whole purpose of departments is to be able to assign and filter assets and expenses per department, if applicable.
Other Parameter – this field can come in handy for e.g. Checklists – use a SQL query to select a department, this field can hold e.g. LDAP Group names or other additional parameter that you might want to use in a script – your SQL query would be something like this in the checklists:
SELECT ID, Department, DepartmentNumber, OtherParameter FROM tblDepartments
Data field and reference overview
- Department name
- Department number
- Other Parameter – see above