DE-Departments
Extracts the list of departments.
Endpoint
POST /api/v3/analytics/named-query/DE-Departments/dynamic-execute
Parameters
This query has no parameters.
Output Columns
| Column | Source Table | Source Column |
|---|---|---|
| CompanyId | com | Oid |
| Company | com | Name |
| DivisionId | div | Oid |
| Division | div | Name |
| DepartmentId | dep | Oid |
| Department | dep | Name |
| ModifiedOn | dep | ModifiedOnUtc |
| DepartmentTypeId | dpt | Oid |
| DepartmentType | dpt | Name |
Source Tables
| Table | Alias | Join |
|---|---|---|
| Department | dep | FROM |
| Division | div | JOIN |
| Company | com | JOIN |
| DepartmentType | dpt | JOIN |
Access
| Role | Administrative |
|---|---|
| DepartmentRead | No |
Version: 6 · Category: Data Extraction · System: No