UserDepartments
Returns the departments a user belongs to along with related job title information, supporting organizational mapping and identity management.
Select
The UserCode column is required in the WHERE clause. The connector will use the Kintone APIs to filter the results by this column. By default, the connector will process other filters client-side within the connector.
For example, the following queries are processed server side:
SELECT * FROM UserDepartments where UserCode = 'loginname';
Columns
| Name | Type | References | Description |
| OrganizationId [KEY] | Long | Unique identifier for the department, used to link department records to related organizational data. | |
| TitleId [KEY] | Long | Unique identifier for the job title, allowing you to associate users or roles with a specific title. | |
| OrganizationCode | String | Code assigned to the department, typically used for internal categorization or external system references. | |
| OrganizationName | String | Primary display name of the department as it appears in the organization's directory. | |
| OrganizationLocalName | String | Localized display name of the department for regions or languages that require a translated label. | |
| OrganizationLocalNameLocale | String | Locale code indicating the language or region associated with the department's localized name. | |
| OrganizationParentCode | String | Code of the department's parent unit to help model the organizational hierarchy. If the value is 'null', it indicates a root-level department. | |
| OrganizationDescription | Longvarchar | Text description that provides additional context about the department's responsibilities or purpose. | |
| TitleCode | String | Internal or external reference code assigned to the job title for classification or system integration. | |
| TitleName | String | Human-readable name of the job title used in employee profiles and organizational charts. | |
| TitleDescription | Longvarchar | Text description explaining the scope, responsibilities, or role of the job title. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| UserCode | String | Login name associated with the user, used to identify the user when querying related records. |