Departments
Provides a filtered or joined view of department-related metadata, often used for access control, reporting, or organizational hierarchy alignment within Vault.
Columns
| Name | Type | Description |
| ID | String | Unique identifier for the department record, assigned by the system to ensure data integrity and referencing consistency. |
| Department_Name | String | Official name of the department as recorded in the organizational structure. This value is typically used for display in user interfaces and reporting. |
| Status | String | Current operational status of the department, such as Active, Inactive, or Archived. This field helps determine department availability in workflows and user selections. |
| Department_Number_Code | String | Alphanumeric code that uniquely identifies the department within the organization. Often used for internal classification, reporting, and system integration. |
| External_ID | String | Identifier used to map the department to an external system or reference. This is useful for integrations with HR, ERP, or legacy systems. |
| Created_By | String | Username or identifier of the user or system that initially created the department record. This is used for auditing and traceability. |
| Created_Date | Datetime | Timestamp indicating when the department record was first created. Stored in UTC and used for historical tracking. |
| Last_Modified_By | String | Username or identifier of the user or system that last updated the department record. Helps track changes over time. |
| Last_Modified_Date | Datetime | Timestamp of the most recent modification to the department record. This is useful for identifying the latest updates and maintaining version control. |