OPRIDAP_MECC_OPR_VW(SQL View) |
Index Back |
|---|---|
MECC OPRID'sMECC OPRID's |
| SELECT OPRID , SUM(SUM_1) , SUM(SUM_2) , SUM(SUM_3) FROM PS_AP_MEC_OPR1_VW GROUP BY OPRID |
| # | 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 | SUM_1 | Number(9,0) | DECIMAL(9) NOT NULL | Count |
| 3 | SUM_2 | Number(9,0) | DECIMAL(9) NOT NULL | Count |
| 4 | SUM_3 | Number(9,0) | DECIMAL(9) NOT NULL | Count |