COMPETENCYPrompt Table: CM_TYPE_TBL
CM_COMP_TYPE_VW(SQL View) |
Index Back |
|---|---|
Competency Type ViewA competency can have none, one, or more than 1 competency type. This view selects maximal only one competency type for each competency, in order to show it on the same level as the competency. |
| SELECT COMPETENCY , CM_TYPE FROM PS_COMPETENCY_TYPS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL | Competency |
| 2 | CM_TYPE | Character(6) | VARCHAR2(6) NOT NULL |
Competency Type
Prompt Table: CM_TYPE_TBL |