Overview
This command will list the desired competence, filtering by its ID #.
It is used to search for information of the desired competence, its type, and its evaluation items, if any.
Data listed in this command can also be searched through the File Competence (CO004) screen.
Related tables
Table
|
Description
|
Primary key (PK)
|
Connection tables
|
TRHABILITY
|
Competence table
|
CDHABILITY
|
TRHABILITYTYPE
GNFAVORITE
GNASSOC
CPSCALEREVISION
|
CPSCALE
|
Proficiency scale
|
CDSCALE
|
CPSCALEREVISION
|
RIRISKTYPE
|
Risk type record
|
CDRISKTYPE
|
CPSCALEREVISION
|
TRHABILITYTYPE
|
Competence type
|
CDHABILITYTYPE
|
GNMASK
|
TRHABEVALITEM
|
Competence evaluation item
|
CDHABILITY
CDEVALITEM
|
TREVALITEM
TRHABILITY
CPEVALITEMTYPE
|
TREVALITEM
|
Evaluation item
|
CDEVALITEM
|
CPEVALITEMTYPE
|
Oracle/Postgres/SQL Server
SELECT TRH.IDHABILITY ,
TRH.NMHABILITY ,
TRHT.IDHABILITYTYPE,
TRHT.NMHABILITYTYPE,
CP.IDSCALE ,
CP.NMSCALE ,
TRH.NRREVISION ,
TRH.DSHABILITY ,
CIT.IDEVALITEMTYPE ,
TREI.IDEVALITEM ,
TREI.NMEVALITEM ,
TRHI.VLWEIGHT
FROM TRHABILITY TRH
INNER JOIN CPSCALE CP
ON (
CP.CDSCALE = TRH.CDSCALE
)
INNER JOIN TRHABILITYTYPE TRHT
ON (
TRH.CDHABILITYTYPE = TRHT.CDHABILITYTYPE
)
INNER JOIN TRHABEVALITEM TRHI
ON (
TRH.CDHABILITY = TRHI.CDHABILITY
)
INNER JOIN TREVALITEM TREI
ON (
TRHI.CDEVALITEM = TREI.CDEVALITEM
)
INNER JOIN CPEVALITEMTYPE CIT
ON (
TREI.CDEVALITEMTYPE = CIT.CDEVALITEMTYPE
)
WHERE TRH.IDHABILITY = 'COMPETENCE ID' /* NOTE1 */
|
Notes
1: Competence ID #.
Fields used on the view screen
#
|
Field ID
|
Type
|
Description
|
1
|
IDHABILITY
|
VARCHAR(50)
|
Competence ID #
|
2
|
IDHABILITY
|
VARCHAR(255)
|
Competence name
|
3
|
IDHABILITYTYPE
|
VARCHAR(50)
|
Competence type ID #
|
4
|
NMHABILITYTYPE
|
VARCHAR(255)
|
Competence type name
|
5
|
IDSCALE
|
VARCHAR(50)
|
Proficiency scale ID #
|
6
|
NMSCALE
|
VARCHAR(255)
|
Proficiency scale name
|
7
|
NRREVISION
|
NUMERIC(9)
|
Revision #
|
8
|
DSHABILITY
|
TEXT(16)
|
Competence description
|
9
|
IDEVALITEMTYPE
|
VARCHAR(50)
|
Evaluation item type ID #
|
10
|
IDEVALITEM
|
VARCHAR(50)
|
Evaluation item ID #
|
11
|
NMEVALITEM
|
VARCHAR(255)
|
Evaluation item name
|
12
|
VLWEIGHT
|
NUMERIC(13)
|
Evaluation item weight
|
|