Navigation:  Training >

Training participants and details

 Previous  Top  Next

Overview

This command will list the desired training participants, filtering by its ID #. It is used to search for information of the training participants and details configured in it. Data listed in this command can also be searched through the Execution arrowrgray Training execution (TR009) arrowrgray Participant or Management arrowrgray Training planning (TR007) arrowrgray Participant screens.

 

Related tables

TABLE

Description

Primary key (PK)

Connection tables

TRTRAINING

Training table

CDTRAIN

ADALLUSERS

ADAPPROVALROUTE

ADCHECKLIST

ADMAILTASKREL

ADTEAM

DCCATEGORY

GNAPPROV

GNCALENDAR

GNCHECKLISTANSWER

GNFAVORITE

GNSURVEY

TRCOMPANY

TRCONFIGURATION

TRCONTENTCONFIG

TRCOURSEREVISION

TRHISTCOURSE

TRHISTCOURSE

ADALLUSERS

User table

CDUSER

ADUSEREXTERNALDATA

GNFAVORITE

ADALLUSERS

ADDEPARTMENT

Department table

CDDEPARTMENT

ADALLUSERS

ADDEPARTMENT

ADTEAM

COWORKSPACE

GNASSOC

GNFAVORITE

GNMAPPING

ADPOSITION

Position table

CDPOSITION

GNMAPPING

TRTRAINUSER

Training participant table

CDTRAINUSER

ADALLUSERS

ADDEPARTMENT

ADPOSITION

ADUSEREXTERNALDATA

DCDOCREVISION

GNREQUEST

TRTRAINING

 

Oracle/Postgres/SQL Server

SELECT T.IDTRAIN  ,
       T.NMTRAIN  ,
       TU.NRORDER ,
       TU.FGRESULT,
       AD.IDUSER  ,
       AD.NMUSER  ,
       TU.VLNOTE  ,
       VLFREQTRAIN
FROM   TRTRAINING T
       INNER JOIN TRTRAINUSER TU
       ON     (
                     T.CDTRAIN = TU.CDTRAIN
              )
       INNER JOIN ADALLUSERS AD
       ON     (
                     AD.CDUSER = TU.CDUSER
              )
       LEFT OUTER JOIN ADDEPARTMENT ADDEP
       ON     (
                     ADDEP.CDDEPARTMENT = TU.CDDEPARTMENT
              )
       LEFT OUTER JOIN ADPOSITION AP
       ON     (
                     AP.CDPOSITION = TU.CDPOSITION
              )
WHERE  T.IDTRAIN =  'Training ID'

 

Fields used on the view screen

 

training-03

 

#

Field ID

Type

Description

1

IDTRAIN

VARCHAR(50)

Training ID #

2

NMTRAIN

VARCHAR(255)

Training name

3

NRORDER

NUMERIC(9)

Participant sequence

4

FGRESULT

NUMERIC(5)

Result

1- Approved

2- Rejected

3- Not evaluated

5

IDUSER

VARCHAR(50)

Participant ID #

6

NMUSER

VARCHAR(255)

Participant name

7

VLNOTE

NUMERIC(13)

Score

8

VLFREQTRAIN

NUMERIC(13)

Frequency