CM_TYPECOMPETENCYCM_TREE_SRCH(SQL View) |
Index Back |
|---|---|
Search Vw - Competency TreeCM_TREE_SRCH is a view which is used as the search record in the Competency Hierarchy trees. The Tree Editor's dynamic detail feature retrieves the competencies of a particular type. |
| select A.cm_type, A.competency, B.descr from ps_competency_tbl B, PS_COMPETENCY_TYPS A where a.competency = b.competency |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CM_TYPE |
Character(6) | VARCHAR2(6) NOT NULL | Competency Type |
| 2 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL | Competency |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |