Users with their departments and positions

Overview

This command will list users with their respective default departments and positions.

Related tables

Table	Description	Primary key (PK)	Connection tables
ADALLUSERS	Stores uses	CDUSER	ADALLUSERS ADUSEREXTERNALDATA GNFAVORITE
ADUSERDEPTPOS	Stores the relationship between departments, positions, and users	CDUSER CDDEPARTMENT CDPOSITION	ADALLUSERS ADDEPTPOSITION
ADDEPARTMENT	Stores organizational units and departments	CDDEPARTMENT	ADALLUSERS ADDEPARTMENT ADTEAM COWORKSPACE GNASSOC GNFAVORITE GNMAPPING
ADPOSITION	Stores positions	CDPOSITION	GNMAPPING

Oracle/Postgres/SQL Server

SELECT
AD.NMUSER,
ADA.NMDEPARTMENT,
ADF.NMPOSITION
FROM ADALLUSERS AD
INNER JOIN ADUSERDEPTPOS UDP ON (AD.CDUSER = UDP.CDUSER)
INNER JOIN ADDEPARTMENT ADA ON (ADA.CDDEPARTMENT = UDP.CDDEPARTMENT)
INNER JOIN ADPOSITION ADF ON (ADF.CDPOSITION = UDP.CDPOSITION)
WHERE UDP.FGDEFAULTDEPTPOS = 1;

Fields used on the view screen

#	Field ID	Type	Description
1	NMUSER	VARCHAR (255)	User name
2	NMDEPARTMENT	VARCHAR(255)	Department name
3	NMPOSITION	VARCHAR(255)	Position name