OPRIDCOUNT1TYPEAP_MEC_OPCNT_VW(SQL View) |
Index Back |
|---|---|
AP MECC Operator Count ViewAP MECC Operator Count View |
| SELECT C.OPRID , COUNT(*) ,'U' FROM PS_AP_MTCH_GRP_USR C GROUP BY C.OPRID UNION SELECT F.ROLEUSER , COUNT(*) ,'R' FROM PS_AP_MTCH_GRP_ROL E , PSROLEUSER F WHERE E.ROLENAME = F.ROLENAME GROUP BY F.ROLEUSER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | COUNT1 |
Number(10,0) | DECIMAL(10) NOT NULL | Counter |
| 3 | TYPE |
Character(1) | VARCHAR2(1) NOT NULL | TYPE |