Overview

This command will list the desired course, filtering by its ID # and revision. It is used to search for information of the course and details configured in it. Data listed in this command can also be searched through the File Course (TR004) menu.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
TRCOURSEREVISION	Course revision table	CDCOURSE CDREVISION	GNASSOC GNREVISION TRCONFIGURATION TRCONTENTCONFIG TRCOURSE TRCOURSETYPE
TRCOURSE	Course table	CDCOURSE	ADAPPROVALROUTE GNASSOC GNFAVORITE GNMASK TRCONFIGURATION TRCOURSETYPE
GNREVISION	Revision table	CDREVISION	ADALLUSERS GNACTIONASSOC GNASSOC GNREASON GNREVCONFIG GNREVISIONSTATUS
TRCOURSETYPE	Course type table	CDCOURSETYPE	GNGENTYPE GNREVCONFIG
GNGENTYPE	Generic type table	CDGENTYPE	ADCHECKLIST GNACTIVITYTIMECFG GNASSOC GNELETRONICFILECFG GNEVAL GNFAVORITE GNMASK GNREVCONFIG GNSECURITY GNTRANSLATION GNTYPEROLE
TRCONFIGURATION	Training configuration table	CDCONFIGURATION	ADAPPROVALROUTE ADCHECKLIST ADMAILTASKREL ADTEAM DCCATEGORY GNCALENDAR GNMASK GNSURVEY TRCONFIGTYPE TRTRAININGMETHOD

Oracle/Postgres/SQL Server

SELECT GN.IDREVISION ,
   GN.FGSTATUS ,
   TC.FGCURRENT ,
   TC.IDCOURSE ,
   TC.NMCOURSE ,
   G.IDGENTYPE AS IDCOURSETYPE,
   G.NMGENTYPE AS NMCOURSETYPE,
   T.FGCOURSETYPE ,
   TCC.IDCONFIGURATION ,
   TCC.NMCONFIGURATION ,
   T.FGTYPE ,
   TC.QTTMTOT ,
   TC.FGTMTOT ,
   TC.DSOBS ,
   TC.DSCONTENT ,
   TC.DSRESOURCES ,
   TC.FGTRAINREQUIRED ,
   TC.FGALLOWSELFENROLL
FROM   TRCOURSEREVISION TC
     INNER JOIN TRCOURSE T
     ON   (
   TC.CDCOURSE = T.CDCOURSE
   )
     INNER JOIN GNREVISION GN
     ON   (
   GN.CDREVISION = TC.CDREVISION
   )
     INNER JOIN TRCOURSETYPE TT
     ON   (
   TT.CDCOURSETYPE = TC.CDCOURSETYPE
   )
     INNER JOIN GNGENTYPE G
     ON   (
   G.CDGENTYPE = TT.CDCOURSETYPE
   )
     LEFT OUTER JOIN TRCONFIGURATION TCC
     ON   (
   TCC.CDCONFIGURATION = TC.CDCONFIGURATION
   )
WHERE  TC.IDCOURSE = 'Course ID'
AND   GN.IDREVISION = 'Revision number'

Fields used on the view screen

training-01

training-02

training-02_a

#	Field ID	Type	Description
1	IDREVISION	VARCHAR(50)	Revision ID #
2	FGSTATUS	NUMERIC(5)	Revision status: 1 - Draft 2 - Review 3 - Approval 4 - Release 5 - Released 6 - Closure
3	FGCURRENT	NUMERIC(5)	Current revision
4	IDCOURSE	VARCHAR(50)	Course ID #
5	NMCOURSE	VARCHAR(255)	Course name
6	IDCOURSETYPE	VARCHAR(50)	Course type ID #
7	NMCOURSETYPE	VARCHAR(255)	Course type name
8	FGCOURSETYPE	NUMERIC(5)	Course type: 1- Course 2- Path
9	IDCONFIGURATION	VARCHAR(50)	Configuration ID #
10	NMCONFIGURATION	VARCHAR(255)	Configuration name
11	FGTYPE	NUMERIC(5)	Usage: 1- Training 2- Employee profile 3- Both
12	QTTMTOT	NUMERIC(9)	Workload (in seconds)
13	FGTMTOT	NUMERIC(5)	Workload: 1 - Fixed 2 - Variable
14	DSOBS	TEXT(16)	Objective
15	DSCONTENT	TEXT(16)	Syllabus
16	DSRESOURCES	TEXT(16)	Description
17	FGTRAINREQUIRED	NUMERIC(5)	Revision requires training
18	FGALLOWSELFENROLL	NUMERIC(5)	Self-training

Courses and details

Overview

Related tables

Oracle/Postgres/SQL Server

Fields used on the view screen