RS_RES_COMP_CNT(SQL View) |
Index Back |
|---|---|
Resource Competencies Count |
| SELECT A.COMPETENCY , COUNT(A.COMPETENCY) COMPCOUNT FROM PS_COMPETENCIES A , PS_COMPETENCY_TBL B , PS_RS_WRKR_EFFDT C WHERE A.COMPETENCY = B.COMPETENCY AND A.EMPLID = C.EMPLID AND C.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_RS_WRKR_EFFDT D WHERE C.EMPLID = D.EMPLID AND C.SYSTEM_SOURCE = D.SYSTEM_SOURCE AND D.EFFDT <= %CurrentDateIn) 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 |