department

A table that contains details about the departments within an organization, used for categorizing and organizing personnel, expenses, and tasks.

Columns


Name	Type	References	Description
id [KEY]	Integer		The unique internal identifier for the department record.
externalid	String		The external identifier used to reference the department from an external system or source.
fullname	String		The full name of the department, which can include additional details for clarity.
includechildren	Boolean		Indicates whether child departments (subdepartments) should be included in relevant operations or processes.
isinactive	Boolean		Indicates whether the department is inactive and should be excluded from active records and processes.
name	String		The name of the department, typically used for display and identification purposes.
parent	String		The parent department to which this department belongs, indicating its hierarchical relationship.