RS_SO_COMP_CNT(SQL View) |
Index Back |
|---|---|
SO Competencies Count |
| SELECT A.COMPETENCY , COUNT(A.COMPETENCY) COMPCOUNT FROM PS_RS_SO_LINE_COMP A , PS_COMPETENCY_TBL B , PS_RS_SO_HDR C WHERE A.COMPETENCY = B.COMPETENCY AND A.SO_ID = C.SO_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND C.SYSTEM_SOURCE = 'RS' GROUP BY A.COMPETENCY ORDER BY COMPCOUNT DESC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPETENCY | Character(8) | VARCHAR2(8) NOT NULL | Competency |
| 2 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |