Overview

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

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
TRCOURSEREVISION	Course revision table	CDCOURSE CDREVISION	GNASSOC GNREVISION TRCONFIGURATION TRCONTENTCONFIG TRCOURSE TRCOURSETYPE
TRCONFIGURATION	Training configuration table	CDCONFIGURATION	ADAPPROVALROUTE ADCHECKLIST ADMAILTASKREL ADTEAM DCCATEGORY GNCALENDAR GNMASK GNSURVEY TRCONFIGTYPE TRTRAININGMETHOD
TRTRAININGMETHOD	Training method table	CDTRAININGMETHOD
ADTEAM	Team table	CDTEAM	ADAUTHLDAPCONFIG GNMAPPING GNPERMISSION

Oracle/Postgres/SQL Server

SELECT T.IDTRAIN ,
   T.NMTRAIN ,
   T.FGPARTTYPE ,
   T.FGSTATUS ,
   TCR.IDCOURSE ,
   TCR.NMCOURSE ,
   TC.IDCONFIGURATION ,
   TC.NMCONFIGURATION ,
   TM.IDTRAININGMETHOD ,
   TM.NMTRAININGMETHOD ,
   TP.IDTEAM AS IDTEAMPROG,
   TP.NMTEAM AS NMTEAMPROG,
   TR.IDTEAM AS IDTEAMREAL,
   TR.NMTEAM AS NMTEAMREAL,
   T.FGEXECTYPE ,
   T.NMSUPPORT ,
   T.DTPROGSTART ,
   T.DTPROGFINISH ,
   T.QTTMTOTPROG ,
   T.VLCOSTPROG ,
   T.QTPARTPROG ,
   T.DTREALSTART ,
   T.DTREALFINISH ,
   T.QTTMTOTREAL ,
   T.VLCOSTREAL ,
   T.QTPARTREAL
FROM   TRTRAINING T
     INNER JOIN TRCOURSEREVISION TCR
     ON   (
   TCR.CDCOURSE = T.CDCOURSE
   AND   TCR.CDREVISION = T.CDCOURSEREVISION
   )
     INNER JOIN TRCONFIGURATION TC
     ON   (
   TC.CDCONFIGURATION = T.CDCONFIGURATION
   )
     LEFT OUTER JOIN TRTRAININGMETHOD TM
     ON   (
   TM.CDTRAININGMETHOD = T.CDTRAININGMETHOD
   )
     LEFT OUTER JOIN ADTEAM TP
     ON   (
   TP.CDTEAM = T.CDTEAMPROG
   )
     LEFT OUTER JOIN ADTEAM TR
     ON   (
   TR.CDTEAM = T.CDTEAMREAL
   )
WHERE  T.IDTRAIN = 'Training ID'

Fields used on the view screen

training-04

training-05

#	Field ID	Type	Description
1	FGSTATUS	NUMERIC(5)	Training status: 1- Planning 2- Approval 3- Not approved 4- To be started 5- Execution 7- Effectiveness verification 8- Finished 10- Evaluation
2	IDTRAIN	VARCHAR(50)	Training ID #
3	NMTRAIN	VARCHAR(255)	Training name
4	FGPARTTYPE	NUMERIC(5)	Training type: 1- Collective 2- Individual
5	IDCOURSE	VARCHAR(50)	Course ID #
6	NMCOURSE	VARCHAR(255)	Course name
7	IDCONFIGURATION	VARCHAR(50)	Training configuration ID #
8	NMCONFIGURATION	VARCHAR(255)	Training configuration name
9	IDTRAININGMETHOD	VARCHAR(50)	Training method ID #
10	NMTRAININGMETHOD	VARCHAR(255)	Training method name
11	IDTEAMPROG	VARCHAR(50)	Planning team ID #
12	NMTEAMPROG	VARCHAR(255)	Planning team name
13	IDTEAMREAL	VARCHAR(50)	ID # of the responsible team for completing
14	NMTEAMREAL	VARCHAR(255)	Execution team name
15	FGEXECTYPE	NUMERIC(5)	Training execution: 1- Internal 2- External
16	NMSUPPORT	VARCHAR(255)	Training support staff
17	DTPROGSTART	DATETIME(8)	Planned start date
18	DTPROGFINISH	DATETIME(8)	Planned end date
19	QTTMTOTPROG	NUMERIC(9)	Planned workload
20	VLCOSTPROG	NUMERIC(13)	Scheduled cost
21	QTPARTPROG	NUMERIC(9)	Planned number of participants
22	DTREALSTART	DATETIME(8)	Actual start date
23	DTREALFINISH	DATETIME(8)	Actual end date
24	QTTMTOTREAL	NUMERIC(9)	Actual workload
25	VLCOSTREAL	NUMERIC(13)	Actual cost
26	QTPARTREAL	NUMERIC(9)	Actual number of respondents

Trainings and details

Overview

Related tables

Oracle/Postgres/SQL Server

Fields used on the view screen