CM_TYPECM_TYPE_VW(SQL View) |
Index Back |
|---|---|
Competency Types ViewThis view selects those competency types, that have competencies associated with it, to be used as search criteria in competency assignment pages. Because you may use competency types to build a competency hierarchy tree, not all competency types are directly related to competencies. |
| SELECT A.CM_TYPE ,A.DESCR ,A.DESCRSHORT FROM PS_CM_TYPE_TBL A WHERE EXISTS( SELECT 'X' FROM PS_COMPETENCY_TYPS B WHERE B.CM_TYPE = A.CM_TYPE) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CM_TYPE |
Character(6) | VARCHAR2(6) NOT NULL | Competency Type |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |