Overview
This command will list the departments that are related to a certain position.
Related tables
Table
|
Description
|
Primary key (PK)
|
Connection tables
|
ADDEPTPOSITION
|
Stores the relationship between department and position
|
CDDEPARTMENT
CDPOSITION
|
ADDEPARTMENT
ADPOSITION
GNMAPPING
|
ADDEPARTMENT
|
Stores organizational units and departments
|
CDDEPARTMENT
|
ADALLUSERS
ADDEPARTMENT
ADTEAM
COWORKSPACE
GNASSOC
GNFAVORITE
GNMAPPING
|
ADPOSITION
|
Stores positions
|
CDPOSITION
|
GNMAPPING
|
Oracle/Postgres/SQL Server
SELECT
ADA.NMDEPARTMENT
FROM ADDEPTPOSITION ADP
INNER JOIN ADPOSITION ADF ON (ADF.CDPOSITION = ADP.CDPOSITION)
INNER JOIN ADDEPARTMENT ADA ON (ADA.CDDEPARTMENT = ADP.CDDEPARTMENT)
WHERE ADF.IDPOSITION = 'IDENTIFICADOR_DA_FUNCAO'; /* OBS 1 */
|
▪NOTE1: ID # of the department to be filtered in the search. 
Fields used on the view screen
#
|
Field ID
|
Type
|
Description
|
1
|
NMDEPARTMENT
|
VARCHAR (255)
|
Department name
|
|
