Overview

This command will list the desired evaluation plan, filtering by its ID #. It is used to search for information of the evaluation plan and details related to it. Data listed in this command can also be searched through the File Evaluation plan (CO005) screen.

Related tables

Table

Description

Primary key (PK)

Connection tables

TREVALPLAN

Evaluation plan table

CDEVALPLAN

SVFORMGROUP

GNTASKTYPE

GNASSOC

GNACTIONPLANTYPE

CPSCALEREVISION

ADTEAM

ADAPPROVALROUTE

ADTEAM

Team record table

CDTEAM

ADAUTHLDAPCONFIG

GNMAPPING

GNPERMISSION

Oracle/Postgres/SQL Server

SELECT EP.IDEVALPLAN ,
   EP.NMEVALPLAN ,
   EP.FGFREQTYPE ,
   EP.QTFREQ ,
   EP.FGFREQ ,
   EP.QTANTFREQ ,
   EP.FGANTFREQ ,
   EP.DTEVALNEXT ,
   ADT.IDTEAM ,
   ADT.NMTEAM ,
   EP.DTEVALLAST ,
   EP.DSEVALPLAN ,
   EP.FGEVALHABILITY,
   EP.FGEVALGOAL ,
   EP.FGEVALHAB ,
   EP.FGMIN ,
   EP.FGDES ,
   EP.FGEVALAUTO ,
   EP.FGEVALLEADER ,
   EP.FGEVALLEADED ,
   EP.FGEVALPAIR ,
   EP.FGCONSENSUS
FROM   TREVALPLAN EP
     INNER JOIN ADTEAM ADT
     ON   (
   EP.CDTEAM = ADT.CDTEAM
   )
WHERE  EP.FGTYPE = 1
AND   EP.IDEVALPLAN = 'Evaluation plan ID' /* NOTE1 */

Notes

▪1: Evaluation plan data.

Fields used on the view screen

competencia-06

competencia-07

competencia-08

#	Field ID	Type	Description
1	IDEVALPLAN	VARCHAR(50)	Evaluation plan ID #
2	NMEVALPLAN	VARCHAR(255)	Evaluation plan name
3	FGFREQTYPE	NUMERIC(5)	Frequency type
4	QTFREQ	NUMERIC(9)	Evaluation frequency
5	FGFREQ	NUMERIC(5)	Frequency unit: 1 - Day; 2 - Month; 3 - Week; 4 - Year
6	QTANTFREQ	NUMERIC(9)	Evaluation frequency
7	FGANTFREQ	NUMERIC(5)	Frequency unit: 1 - Day; 2 - Month; 3 - Week; 4 - Year
8	DTEVALNEXT	DATETIME(8)	Next execution date
9	IDTEAM	VARCHAR(50)	Team ID #
10	NMTEAM	VARCHAR(255)	Team name
11	DTEVALLAST	DATETIME(8)	Latest execution date
12	DSEVALPLAN	TEXT(16)	Description
13	FGEVALHABILITY	NUMERIC(5)	Evaluate competence [1 - Yes, 2 - No]
14	FGEVALGOAL	NUMERIC(5)	Evaluate goal [1 - Yes, 2 - No]
15	FGEVALHAB	NUMERIC(5)	Type of competence to be evaluated [1 - Standard; 2 - Specific]
16	FGMIN	NUMERIC(5)	Evaluate required competences [1 - Yes; 2 - No]
17	FGDES	NUMERIC(5)	Evaluate desirable competences [1 - Yes; 2 - No]
18	FGEVALAUTO	NUMERIC(5)	Generate self-evaluation [1 - Yes; 2 - No]
19	FGEVALLEADER	NUMERIC(5)	Generate leader evaluation [1 - Yes; 2 - No]
20	FGEVALLEADED	NUMERIC(5)	Generate peer evaluation [1 - Yes; 2 - No]
21	FGEVALPAIR	NUMERIC(5)	Generate subordinates evaluation [1 - Yes; 2 - No]
22	FGCONSENSUS	NUMERIC(5)	Generate review automatically [1 - Yes; 2 - No]