Overview
This command will list the positions that are related to a certain department.
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
ADF.NMPOSITION
FROM ADDEPTPOSITION ADP
INNER JOIN ADPOSITION ADF ON (ADF.CDPOSITION = ADP.CDPOSITION)
INNER JOIN ADDEPARTMENT ADA ON (ADA.CDDEPARTMENT = ADP.CDDEPARTMENT)
WHERE ADA.IDDEPARTMENT = 'IDENTIFICADOR_DA_AREA'; /* OBS 1 */
|
Notes
▪NOTE1: ID # of the department to be filtered in the search.
Fields used on the view screen
#
|
Field ID
|
Type
|
Description
|
1
|
NMPOSITION
|
VARCHAR (255)
|
Position name
|
|